Naming convention applied

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

diff --git a/inc/mysql-manager.php b/inc/mysql-manager.php
index 00f410949434c0176604b2a8b6438c986a22a326..ea9bff0ee3b9387ce02e056024754deea04c9f56 100644 (file)
--- a/inc/mysql-manager.php
+++ b/inc/mysql-manager.php
@@ -213,16 +213,16 @@ function CHECK_MODULE($mod)
        return $ret;
 }
 //
-function ADD_DESCR($ACC_LVL, $FILE, $return = false, $output = true)
+function ADD_DESCR($ACC_LVL, $file, $return = false, $output = true)
 {
-       global $_GET, $DEPTH, $CONFIG;
+       global $DEPTH, $CONFIG;
        $LINK_ADD = ""; $OUT = ""; $AND = "";
        // First we have to do some analysis...
-       if (ereg("action-", $FILE))
+       if (ereg("action-", $file))
        {
                // This is an action file!
-               $TYPE = "action";
-               $SEARCH = substr($FILE, 7);
+               $type = "action";
+               $search = substr($file, 7);
                switch ($ACC_LVL)
                {
                case "admin":
@@ -237,11 +237,11 @@ function ADD_DESCR($ACC_LVL, $FILE, $return = false, $output = true)
                }
                $AND = " AND what=''";
        }
-        elseif (ereg("what-", $FILE))
+        elseif (ereg("what-", $file))
        {
                // This is an admin what file!
-               $TYPE = "what";
-               $SEARCH = substr($FILE, 5);
+               $type = "what";
+               $search = substr($file, 5);
                $AND = "";
                switch ($ACC_LVL)
                {
@@ -258,22 +258,22 @@ function ADD_DESCR($ACC_LVL, $FILE, $return = false, $output = true)
                        }
                        break;
                }
-               $DUMMY = substr($SEARCH, 0, -4);
+               $DUMMY = substr($search, 0, -4);
                $AND .= " AND action='".GET_ACTION($ACC_LVL, $DUMMY)."'";
        }
         elseif (($ACC_LVL == "sponsor") || ($ACC_LVL == "engine"))
        {
                // Sponsor / engine menu
-               $TYPE = "what";
-               $SEARCH = $FILE;
+               $type = "what";
+               $search = $file;
                $MOD_CHECK = $GLOBALS['module'];
                $AND = "";
        }
         else
        {
                // Other
-               $TYPE = "menu";
-               $SEARCH = $FILE;
+               $type = "menu";
+               $search = $file;
                $MOD_CHECK = $GLOBALS['module'];
                $AND = "";
        }
@@ -288,12 +288,12 @@ function ADD_DESCR($ACC_LVL, $FILE, $return = false, $output = true)
                $PREFIX = "";
        }
        $PREFIX .= " -> ";
-       if (ereg(".php", $SEARCH))
+       if (ereg(".php", $search))
        {
-               $SEARCH = substr($SEARCH, 0, strpos($SEARCH, ".php"));
+               $search = substr($search, 0, strpos($search, ".php"));
        }
        $result = SQL_QUERY_ESC("SELECT title FROM "._MYSQL_PREFIX."_%s_menu WHERE %s='%s' ".$AND." LIMIT 1",
-        array($ACC_LVL, $TYPE, $SEARCH), __FILE__, __LINE__);
+        array($ACC_LVL, $type, $search), __FILE__, __LINE__);
        if (SQL_NUMROWS($result) == 1)
        {
                list($ret) = SQL_FETCHROW($result);
@@ -306,10 +306,10 @@ function ADD_DESCR($ACC_LVL, $FILE, $return = false, $output = true)
                 elseif (((GET_EXT_VERSION("sql_patches") >= "0.2.3") && ($CONFIG['youre_here'] == 'Y')) || ((IS_ADMIN()) && ($MOD_CHECK == "admin")))
                {
                        // Output HTML code
-                       $OUT = $PREFIX."<STRONG><A class=\"you_are_here\" href=\"".URL."/modules.php?module=".$MOD_CHECK."&amp;".$TYPE."=".$SEARCH.$LINK_ADD."\">".$ret."</A></STRONG>\n";
-                       //* DEBUG: */ echo __LINE__."*".$TYPE."/".$GLOBALS['what']."*<br />\n";
-                       if (($TYPE == "what") || (($TYPE == "action") && (!isset($_GET['what'])) && ($GLOBALS['what'] != "welcome"))) {
-                               //* DEBUG: */ echo __LINE__."+".$TYPE."+<br />\n";
+                       $OUT = $PREFIX."<STRONG><A class=\"you_are_here\" href=\"".URL."/modules.php?module=".$MOD_CHECK."&amp;".$type."=".$search.$LINK_ADD."\">".$ret."</A></STRONG>\n";
+                       //* DEBUG: */ echo __LINE__."*".$type."/".$GLOBALS['what']."*<br />\n";
+                       if (($type == "what") || (($type == "action") && (!isset($_GET['what'])) && ($GLOBALS['what'] != "welcome"))) {
+                               //* DEBUG: */ echo __LINE__."+".$type."+<br />\n";
                                $OUT .= "</DIV><BR>\n";
                        }
                }
@@ -582,7 +582,7 @@ function SEARCH_EMAIL_USERTAB($email)
        return $ret;
 }
 //
-function WHAT_IS_VALID($act, $wht, $TYPE="guest")
+function WHAT_IS_VALID($act, $wht, $type="guest")
 {
        if (IS_ADMIN())
        {
@@ -592,7 +592,7 @@ function WHAT_IS_VALID($act, $wht, $TYPE="guest")
         else
        {
                $ret = false;
-               $result = SQL_QUERY_ESC("SELECT id FROM "._MYSQL_PREFIX."_%s_menu WHERE action='%s' AND what='%s' AND locked='N' LIMIT 1", array($TYPE, $act, $wht), __FILE__, __LINE__);
+               $result = SQL_QUERY_ESC("SELECT id FROM "._MYSQL_PREFIX."_%s_menu WHERE action='%s' AND what='%s' AND locked='N' LIMIT 1", array($type, $act, $wht), __FILE__, __LINE__);
                // Is "what" valid?
                if (SQL_NUMROWS($result) == 1) $ret = true;
                SQL_FREERESULT($result);
@@ -1059,15 +1059,15 @@ function REMOVE_RECEIVER(&$ARRAY, $key, $uid, $pool_id, $stats_id="", $bonus=fal
                if ($stats_id > 0)
                {
                        // Only when we got a real stats ID continue searching for the entry
-                       $TYPE = "NORMAL"; $ROW = "stats_id";
-                       if ($bonus) { $TYPE = "BONUS"; $ROW = "bonus_id"; }
+                       $type = "NORMAL"; $ROW = "stats_id";
+                       if ($bonus) { $type = "BONUS"; $ROW = "bonus_id"; }
                        $result = SQL_QUERY_ESC("SELECT id FROM "._MYSQL_PREFIX."_user_links WHERE %s='%s' AND userid=%d AND link_type='%s' LIMIT 1",
-                        array($ROW, $stats_id, bigintval($uid), $TYPE), __FILE__, __LINE__);
+                        array($ROW, $stats_id, bigintval($uid), $type), __FILE__, __LINE__);
                        if (SQL_NUMROWS($result) == 0)
                        {
                                // No, so we add one!
                                $result = SQL_QUERY_ESC("INSERT INTO "._MYSQL_PREFIX."_user_links (%s, userid, link_type) VALUES ('%s', '%s', '%s')",
-                                array($ROW, $stats_id, bigintval($uid), $TYPE), __FILE__, __LINE__);
+                                array($ROW, $stats_id, bigintval($uid), $type), __FILE__, __LINE__);
                                $ret = "done";
                        }
                         else
@@ -1084,24 +1084,24 @@ function REMOVE_RECEIVER(&$ARRAY, $key, $uid, $pool_id, $stats_id="", $bonus=fal
        return $ret;
 }
 //
-function GET_TOTAL_DATA($SEARCH, $TABLE, $DATA, $WHERE="userid", $ONLY_ROWS=false)
+function GET_TOTAL_DATA($search, $TABLE, $DATA, $WHERE="userid", $ONLY_ROWS=false)
 {
        $ret = "0";
        if ($ONLY_ROWS)
        {
                // Count rows
                $result = SQL_QUERY_ESC("SELECT COUNT(%s) FROM "._MYSQL_PREFIX."_%s WHERE %s='%s'",
-                array($DATA, $TABLE, $WHERE, $SEARCH), __FILE__, __LINE__);
+                array($DATA, $TABLE, $WHERE, $search), __FILE__, __LINE__);
        }
         else
        {
                // Add all rows
                $result = SQL_QUERY_ESC("SELECT SUM(%s) FROM "._MYSQL_PREFIX."_%s WHERE %s='%s'",
-                array($DATA, $TABLE, $WHERE, $SEARCH), __FILE__, __LINE__);
+                array($DATA, $TABLE, $WHERE, $search), __FILE__, __LINE__);
        }
        // Load row
        list($ret) = SQL_FETCHROW($result);
-       //* DEBUG: */ echo __LINE__."*".$DATA."/".$SEARCH."/".$TABLE."/".$ret."*<br />\n";
+       //* DEBUG: */ echo __LINE__."*".$DATA."/".$search."/".$TABLE."/".$ret."*<br />\n";
        SQL_FREERESULT($result);
        if (empty($ret)) {
                if (($DATA == "counter") || ($DATA == "id")) {