Chris Morgan : Pass a valid link resource to mysql_real_escape_string()

[Chris Morgan]

Module: appdb
Branch: master
Commit: 13fe229774c52ad5df50b415b3ba6f86206e5fe1
URL:    http://source.winehq.org/git/appdb.git/?a=commit;h=13fe229774c52ad5df50b415b...

Author: Chris Morgan <cmorgan(a)alum.wpi.edu>
Date:   Sun Jun  1 00:19:49 2008 -0400

Pass a valid link resource to mysql_real_escape_string()

---

 include/query.php |   13 ++++++++++++-
 1 files changed, 12 insertions(+), 1 deletions(-)

diff --git a/include/query.php b/include/query.php
index 4643621..0c45496 100644
--- a/include/query.php
+++ b/include/query.php
@@ -190,7 +190,18 @@ function query_num_rows($hResult)
 
 function query_escape_string($sString)
 {
-    return mysql_real_escape_string($sString);
+    global $hAppdbLink;
+
+    if(!is_resource($hAppdbLink))
+    {
+        // The last argument makes sure we are really opening a new connection
+        $hAppdbLink = mysql_connect(APPS_DBHOST, APPS_DBUSER, APPS_DBPASS, true);
+        if(!$hAppdbLink)
+          die("Database error, please try again soon.");
+        mysql_select_db(APPS_DB, $hAppdbLink);
+    }
+
+    return mysql_real_escape_string($sString, $hAppdbLink);
 }
 
 function query_field_type($hResult, $iFieldOffset)