Fix for INSERT INTO query

[mailer.git] / inc / mysql-manager.php

diff --git a/inc/mysql-manager.php b/inc/mysql-manager.php
index 21e7f49846b3b240985bed1b866363b1b1f12663..89d3d5e44f6eba5690755dd57baf50c9532b3a23 100644 (file)
--- a/inc/mysql-manager.php
+++ b/inc/mysql-manager.php
@@ -132,22 +132,25 @@ function CHECK_MODULE ($mod) {
                }
        }
 
-       // Check returned values against current access permissions
-       //
-       //  Admin access            ----- Guest access -----           --- Guest   or   member? ---
-       if ((IS_ADMIN()) || (($locked == "N") && ($admin == "N") && (($mem == "N") || (IS_MEMBER())))) {
-               // If you are admin you are welcome for everything!
-               $ret = "done";
-       } elseif ($locked == "Y") {
-               // Module is locked
-               $ret = "locked";
-       } elseif (($mem == "Y") && (!IS_MEMBER())) {
-               // You have to login first!
-               $ret = "mem_only";
-       } elseif (($admin == "Y") && (!IS_ADMIN())) {
-               // Only the Admin is allowed to enter this module!
-               $ret = "admin_only";
-       }
+       // Is the module found?
+       if ($found) {
+               // Check returned values against current access permissions
+               //
+               //  Admin access            ----- Guest access -----           --- Guest   or   member? ---
+               if ((IS_ADMIN()) || (($locked == "N") && ($admin == "N") && (($mem == "N") || (IS_MEMBER())))) {
+                       // If you are admin you are welcome for everything!
+                       $ret = "done";
+               } elseif ($locked == "Y") {
+                       // Module is locked
+                       $ret = "locked";
+               } elseif (($mem == "Y") && (!IS_MEMBER())) {
+                       // You have to login first!
+                       $ret = "mem_only";
+               } elseif (($admin == "Y") && (!IS_ADMIN())) {
+                       // Only the Admin is allowed to enter this module!
+                       $ret = "admin_only";
+               }
+       } // END - if
 
        // Still no luck or not found?
        if (($ret == "major") || ($ret == "cache_miss") || (!$found)) {
@@ -1177,7 +1180,7 @@ function ADD_POINTS_REFSYSTEM ($subject, $uid, $points, $send_notify=false, $rid
                        // No entry updated?
                        if (SQL_AFFECTEDROWS() < 1) {
                                // First ref in this level! :-)
-                               $result = SQL_QUERY_ESC("INSERT INTO "._MYSQL_PREFIX."_user_points (userid,ref_depth,%s) VALUES (%s,%s,%s)",
+                               $result = SQL_QUERY_ESC("INSERT INTO "._MYSQL_PREFIX."_user_points (userid,ref_depth,%s) VALUES (%s,'%s',%s)",
                                        array($data, bigintval($uid), bigintval($GLOBALS['ref_level']), $ref_points), __FILE__, __LINE__);
                                //* DEBUG: */ print __FUNCTION__."(<font color=\"#0000aa\">".__LINE__."</font>):data={$data},ref_points={$ref_points},uid={$uid},depth={$GLOBALS['ref_level']},mode={$add_mode} - INSERTED! (".SQL_AFFECTEDROWS().")<br />\n";
                        } // END - if