X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Fmysql-manager.php;h=f3a7aba8246c3a89b3d09588a32ca88f7f2b12de;hb=97eb53f4fdcc3f433dea23d09efde744d52a3740;hp=3e3b5124a42578cab52ef822ddc9e665dc1ed86b;hpb=668485e1cdc24a6d918c41ea1f2214566ed71226;p=mailer.git

diff --git a/inc/mysql-manager.php b/inc/mysql-manager.php
index 3e3b5124a4..f3a7aba824 100644
--- a/inc/mysql-manager.php
+++ b/inc/mysql-manager.php
@@ -39,7 +39,7 @@ if (!defined('__SECURITY')) {
 
 //
 function ADD_MODULE_TITLE($mod) {
-	global $cacheArray, $_CONFIG;
+	global $cacheArray;
 	$name = ""; $result = false;
 
 	// Is the script installed?
@@ -50,7 +50,7 @@ function ADD_MODULE_TITLE($mod) {
 			$name = $cacheArray['modules']['title'][$mod];
 
 			// Update cache hits
-			if (getConfig('cache_hits') > 0) { $_CONFIG['cache_hits']++; } else { $_CONFIG['cache_hits'] = 1; }
+			incrementConfigEntry('cache_hits');
 		} elseif (!EXT_IS_ACTIVE("cache")) {
 			// Load from database
 			$result = SQL_QUERY_ESC("SELECT title FROM "._MYSQL_PREFIX."_mod_reg WHERE module='%s' LIMIT 1", array($mod), __FILE__, __LINE__);
@@ -79,7 +79,7 @@ function ADD_MODULE_TITLE($mod) {
 // Check validity of a given module name (no file extension)
 function CHECK_MODULE ($mod) {
 	// We need them now here...
-	global $cacheArray, $_CONFIG, $cacheInstance;
+	global $cacheArray, $cacheInstance;
 
 	// Filter module name (names with low chars and underlines are fine!)
 	$mod = preg_replace("/[^a-z_]/", "", $mod);
@@ -115,7 +115,7 @@ function CHECK_MODULE ($mod) {
 			$mem    = $cacheArray['modules']['mem_only'][$mod_chk];
 
 			// Update cache hits
-			if (getConfig('cache_hits') > 0) { $_CONFIG['cache_hits']++; } else { $_CONFIG['cache_hits'] = 1; }
+			incrementConfigEntry('cache_hits');
 			$found = true;
 		} else {
 			// No, then we have to update it!
@@ -202,8 +202,8 @@ function CHECK_MODULE ($mod) {
 }
 
 // Add menu description pending on given file name (without path!)
-function ADD_DESCR($ACC_LVL, $file, $return = false, $output = true) {
-	global $NAV_DEPTH, $_CONFIG;
+function ADD_DESCR ($ACC_LVL, $file, $return = false, $output = true) {
+	global $NAV_DEPTH;
 	// Use only filename of the file ;)
 	$file = basename($file);
 
@@ -264,7 +264,7 @@ function ADD_DESCR($ACC_LVL, $file, $return = false, $output = true) {
 	}
 	if ((!isset($NAV_DEPTH)) && (!$return)) {
 		$NAV_DEPTH = 0;
-		$prefix = "<DIV class=\"you_are_here\">".YOU_ARE_HERE."&nbsp;<STRONG><A class=\"you_are_here\" href=\"".URL."/modules.php?module=".$GLOBALS['module'].$LINK_ADD."\">Home</A></STRONG>";
+		$prefix = "<div class=\"you_are_here\">".YOU_ARE_HERE."&nbsp;<strong><a class=\"you_are_here\" href=\"".URL."/modules.php?module=".$GLOBALS['module'].$LINK_ADD."\">Home</a></strong>";
 	} else {
 		if (!$return) $NAV_DEPTH++;
 		$prefix = "";
@@ -293,11 +293,10 @@ function ADD_DESCR($ACC_LVL, $file, $return = false, $output = true) {
 			return $ret;
 		} elseif (((GET_EXT_VERSION("sql_patches") >= "0.2.3") && (getConfig('youre_here') == "Y")) || ((IS_ADMIN()) && ($modCheck == "admin"))) {
 			// Output HTML code
-			$OUT = $prefix."<STRONG><A class=\"you_are_here\" href=\"".URL."/modules.php?module=".$modCheck."&amp;".$type."=".$search.$LINK_ADD."\">".$ret."</A></STRONG>\n";
+			$OUT = $prefix."<strong><a class=\"you_are_here\" href=\"".URL."/modules.php?module=".$modCheck."&amp;".$type."=".$search.$LINK_ADD."\">".$ret."</a></strong>\n";
 
 			// Can we close the you-are-here navigation?
 			//* DEBUG: */ echo __LINE__."*".$type."/".$GLOBALS['what']."*<br />\n";
-			//* DEBUG: */ die("<pre>".print_r($_CONFIG, true)."</pre>");
 			if (($type == "what") || (($type == "action") && ((!isset($GLOBALS['what'])) || ($GLOBALS['what'] == "overview")))) {
 				//* DEBUG: */ echo __LINE__."+".$type."+<br />\n";
 				// Add closing div and br-tag
@@ -324,9 +323,7 @@ function ADD_DESCR($ACC_LVL, $file, $return = false, $output = true) {
 	}
 }
 //
-function ADD_MENU($MODE, $act, $wht) {
-	global $_CONFIG;
-
+function ADD_MENU ($MODE, $act, $wht) {
 	// Init some variables
 	$main_cnt = 0;
 	$AND = "";
@@ -376,26 +373,26 @@ function ADD_MENU($MODE, $act, $wht) {
 					$test = (FILE_READABLE($test_inc));
 					if ($test) {
 						if ((!empty($wht)) && (($wht == $sub_what))) {
-							$content = "<STRONG>";
+							$content = "<strong>";
 						}
 
 						// Navigation link
-						$content .= "<A name=\"menu\" class=\"menu_blur\" href=\"".URL."/modules.php?module=".$GLOBALS['module']."&amp;what=".$sub_what.ADD_URL_DATA("")."\" target=\"_self\">";
+						$content .= "<a name=\"menu\" class=\"menu_blur\" href=\"".URL."/modules.php?module=".$GLOBALS['module']."&amp;what=".$sub_what.ADD_URL_DATA("")."\" target=\"_self\">";
 					} else {
-						$content .= "<I>";
+						$content .= "<em>";
 					}
 
 					// Menu title
 					$content .= getConfig('menu_blur_spacer') . $sub_title;
 
 					if ($test) {
-						$content .= "</A>";
+						$content .= "</a>";
 					} else {
-						$content .= "</I>";
+						$content .= "</em>";
 					}
 
 					if ((!empty($wht)) && (($wht == $sub_what))) {
-						$content .= "</STRONG>";
+						$content .= "</strong>";
 					}
 					$wht = $sub_what; $cnt++;
 					// Prepare array
@@ -441,9 +438,10 @@ function ADD_MENU($MODE, $act, $wht) {
 	}
 }
 // This patched function will reduce many SELECT queries for the specified or current admin login
-function IS_ADMIN($admin="")
-{
-	global $cacheArray, $_CONFIG;
+function IS_ADMIN ($admin="") {
+	global $cacheArray;
+
+	// Init variables
 	$ret = false; $passCookie = ""; $valPass = "";
 	//* DEBUG: */ echo __LINE__."ADMIN:".$admin."<br />";
 
@@ -461,7 +459,7 @@ function IS_ADMIN($admin="")
 		$valPass = $cacheArray['admin_hash'];
 	} elseif ((!empty($passCookie)) && (isset($cacheArray['admins']['password'][$admin])) && (!empty($admin))) {
 		// Count cache hits
-		if (getConfig('cache_hits') > 0) { $_CONFIG['cache_hits']++; } else { $_CONFIG['cache_hits'] = 1; }
+		incrementConfigEntry('cache_hits');
 
 		// Login data is valid or not?
 		$valPass = generatePassString($cacheArray['admins']['password'][$admin]);
@@ -515,11 +513,11 @@ function ADD_MAX_RECEIVE_LIST($MODE, $default="", $return=false)
 			$OUT = "";
   			while (list($value, $comment) = SQL_FETCHROW($result))
 			{
-				$OUT .= "      <OPTION value=\"".$value."\"";
+				$OUT .= "      <option value=\"".$value."\"";
 				if ($_POST['max_mails'] == $value) $OUT .= " selected=\"selected\"";
 				$OUT .= ">".$value." ".PER_DAY;
 				if (!empty($comment)) $OUT .= " (".$comment.")";
-				$OUT .= "</OPTION>\n";
+				$OUT .= "</option>\n";
 			}
 			define('__MAX_RECEIVE_OPTIONS', $OUT);
 
@@ -541,11 +539,11 @@ function ADD_MAX_RECEIVE_LIST($MODE, $default="", $return=false)
 			$OUT = "";
   			while (list($value, $comment) = SQL_FETCHROW($result))
 			{
-				$OUT .= "      <OPTION value=\"".$value."\"";
+				$OUT .= "      <option value=\"".$value."\"";
 				if ($default == $value) $OUT .= " selected=\"selected\"";
 				$OUT .= ">".$value." ".PER_DAY;
 				if (!empty($comment)) $OUT .= " (".$comment.")";
-				$OUT .= "</OPTION>\n";
+				$OUT .= "</option>\n";
 			}
 			define('__MAX_RECEIVE_OPTIONS', $OUT);
 			SQL_FREERESULT($result);
@@ -597,8 +595,7 @@ function WHAT_IS_VALID($act, $wht, $type="guest")
 	}
 }
 //
-function IS_MEMBER()
-{
+function IS_MEMBER () {
 	global $status, $LAST, $cacheArray;
 	if (!is_array($LAST)) $LAST = array();
 	$ret = false;
@@ -610,16 +607,14 @@ function IS_MEMBER()
 	} // END - if
 
 	// Fix "deleted" cookies first
-	FIX_DELETED_COOKIES(array('userid','u_hash','lifetime'));
+	FIX_DELETED_COOKIES(array('userid', 'u_hash'));
 
 	// Are cookies set?
-	if ((!empty($GLOBALS['userid'])) && (isSessionVariableSet('u_hash')) && (isSessionVariableSet('lifetime')) && (defined('COOKIE_PATH')))
-	{
+	if ((!empty($GLOBALS['userid'])) && (isSessionVariableSet('u_hash'))) {
 		// Cookies are set with values, but are they valid?
 		$result = SQL_QUERY_ESC("SELECT password, status, last_module, last_online FROM `"._MYSQL_PREFIX."_user_data` WHERE userid=%s LIMIT 1",
-		 array($GLOBALS['userid']), __FILE__, __LINE__);
-		if (SQL_NUMROWS($result) == 1)
-		{
+			array($GLOBALS['userid']), __FILE__, __LINE__);
+		if (SQL_NUMROWS($result) == 1) {
 			// Load data from cookies
 			list($password, $status, $mod, $onl) = SQL_FETCHROW($result);
 
@@ -627,7 +622,10 @@ function IS_MEMBER()
 			$valPass = generatePassString($password);
 
 			// Transfer last module and online time
-			if ((!empty($mod)) && (empty($LAST['module']))) { $LAST['module'] = $mod; $LAST['online'] = $onl; }
+			if ((!empty($mod)) && (empty($LAST['module']))) {
+				$LAST['module'] = $mod;
+				$LAST['online'] = $onl;
+			} // END - if
 
 			// So did we now have valid data and an unlocked user?
 			//* DEBUG: */ echo $valPass."<br />".get_session('u_hash')."<br />";
@@ -638,17 +636,11 @@ function IS_MEMBER()
 				// Maybe got locked etc.
 				//* DEBUG: */ echo __LINE__."!!!<br />";
 				destroy_user_session();
-
-				// Reset userid
-				$GLOBALS['userid'] = 0;
 			}
 		} else {
 			// Cookie data is invalid!
 			//* DEBUG: */ echo __LINE__."***<br />";
 			destroy_user_session();
-
-			// Reset userid
-			$GLOBALS['userid'] = 0;
 		}
 
 		// Free memory
@@ -657,9 +649,6 @@ function IS_MEMBER()
 		// Cookie data is invalid!
 		//* DEBUG: */ echo __LINE__."///<br />";
 		destroy_user_session();
-
-		// Reset userid
-		$GLOBALS['userid'] = 0;
 	}
 
 	// Cache status
@@ -735,9 +724,8 @@ function GET_MOD_DESCR($MODE, $wht, $column="what")
 	return $ret;
 }
 //
-function SEND_MODE_MAILS($mod, $modes)
-{
-	global $_CONFIG, $DATA;
+function SEND_MODE_MAILS($mod, $modes) {
+	global $DATA;
 
 	// Load hash
 	$result_main = SQL_QUERY_ESC("SELECT password FROM `"._MYSQL_PREFIX."_user_data` WHERE userid=%s AND status='CONFIRMED' LIMIT 1",
@@ -814,25 +802,25 @@ function SEND_MODE_MAILS($mod, $modes)
 					$sub_mem = MEMBER_CHANGED_DATA;
 
 					// Output success message
-					$content = "<SPAN class=\"member_done\">".MYDATA_MAIL_SENT."</SPAN>";
+					$content = "<span class=\"member_done\">".MYDATA_MAIL_SENT."</span>";
 					break;
 
 				default:
 					DEBUG_LOG(__FUNCTION__, __LINE__, sprintf("Unsupported module %s detected.", $mod));
-					$content = "<SPAN class=\"member_failed\">".UNKNOWN_MODULE."</SPAN>";
+					$content = "<span class=\"member_failed\">".UNKNOWN_MODULE."</span>";
 					break;
 				} // END - switch
 			} else {
 				// Could not load profile data
-				$content = "<SPAN class=\"member_failed\">".MEMBER_CANNOT_LOAD_PROFILE."</SPAN>";
+				$content = "<span class=\"member_failed\">".MEMBER_CANNOT_LOAD_PROFILE."</span>";
 			}
 		} else {
 			// Passwords mismatch
-			$content = "<SPAN class=\"member_failed\">".MEMBER_PASSWORD_ERROR."</SPAN>";
+			$content = "<span class=\"member_failed\">".MEMBER_PASSWORD_ERROR."</span>";
 		}
 	} else {
 		// Could not load profile
-		$content = "<SPAN class=\"member_failed\">".MEMBER_CANNOT_LOAD_PROFILE."</SPAN>";
+		$content = "<span class=\"member_failed\">".MEMBER_CANNOT_LOAD_PROFILE."</span>";
 	}
 
 	// Send email to user if required
@@ -851,7 +839,7 @@ function SEND_MODE_MAILS($mod, $modes)
 			$content = CANNOT_SEND_ADMIN_MAILS;
 		} else {
 			// No mail to admin
-			$content = "<SPAN class=\"member_done\">".MYDATA_MAIL_SENT."</SPAN>";
+			$content = "<span class=\"member_done\">".MYDATA_MAIL_SENT."</span>";
 		}
 	} // END - if
 
@@ -867,9 +855,9 @@ function COUNT_MODULE($mod) {
 	} // END - if
 }
 // Get action value from mode (admin/guest/member) and what-value
-function GET_ACTION ($MODE, &$wht)
-{
-	global $ret, $_CONFIG;
+function GET_ACTION ($MODE, &$wht) {
+	global $ret;
+
 	// @DEPRECATED Init status
 	$ret = "";
 
@@ -894,6 +882,7 @@ function GET_ACTION ($MODE, &$wht)
 	}
 	//* DEBUG: */ echo __FUNCTION__."(<font color=\"#0000aa\">".__LINE__."</font>): ret=".$ret."<br />\n";
 
+	// Does the module have a menu?
 	if (MODULE_HAS_MENU($MODE)) {
 		// Rewriting modules to menu
 		switch ($MODE) {
@@ -914,7 +903,10 @@ function GET_ACTION ($MODE, &$wht)
 
 		// Free memory
 		SQL_FREERESULT($result);
-	} // END - if
+	} elseif ((GET_EXT_VERSION("sql_patches") == "") && ($MODE != "admin")) {
+		// No sql_patches installed!
+		LOAD_URL("admin.php");
+	}
 
 	// Return action value
 	return $ret;
@@ -1062,7 +1054,7 @@ function GET_TOTAL_DATA ($search, $tableName, $lookFor, $whereStatement="userid"
 }
 // "Getter fro ref level percents
 function GET_REF_LEVEL_PERCENTS ($level) {
-	global $cacheInstance, $_CONFIG, $cacheArray;
+	global $cacheInstance, $cacheArray;
 
 	// Default is zero
 	$per = 0;
@@ -1076,7 +1068,7 @@ function GET_REF_LEVEL_PERCENTS ($level) {
 			$per = $cacheArray['ref_depths']['percents'][$key];
 
 			// Count cache hit
-			if (getConfig('cache_hits') > 0) { $_CONFIG['cache_hits']++; } else { $_CONFIG['cache_hits'] = 1; }
+			incrementConfigEntry('cache_hits');
 		}
 	} elseif (!EXT_IS_ACTIVE("cache")) {
 		// Get referal data
@@ -1111,7 +1103,7 @@ function GET_REF_LEVEL_PERCENTS ($level) {
  */
 function ADD_POINTS_REFSYSTEM ($subject, $uid, $points, $send_notify=false, $rid="0", $locked=false, $add_mode="ref") {
 	//* DEBUG: */ print "----------------------- <font color=\"#00aa00\">".__FUNCTION__." - ENTRY</font> ------------------------<ul><li>\n";
-	global $_CONFIG, $DATA, $cacheArray;
+	global $DATA, $cacheArray;
 
 	// Convert mode to lower-case
 	$add_mode = strtolower($add_mode);
@@ -1306,14 +1298,14 @@ function SEND_ADMIN_EMAILS ($subj, $msg) {
 
 // Get ID number from administrator's login name
 function GET_ADMIN_ID ($login) {
-	global $cacheArray, $_CONFIG;
+	global $cacheArray;
 	$ret = "-1";
 	if (isset($cacheArray['admins']['aid'][$login])) {
 		// Check cache
 		$ret = $cacheArray['admins']['aid'][$login];
 
 		// Update cache hits
-		if (getConfig('cache_hits') > 0) { $_CONFIG['cache_hits']++; } else { $_CONFIG['cache_hits'] = 1; }
+		incrementConfigEntry('cache_hits');
 	} elseif (!EXT_IS_ACTIVE("cache")) {
 		// Load from database
 		$result = SQL_QUERY_ESC("SELECT id FROM "._MYSQL_PREFIX."_admins WHERE login='%s' LIMIT 1",
@@ -1343,14 +1335,14 @@ function GET_CURRENT_ADMIN_ID () {
 // Get password hash from administrator's login name
 function GET_ADMIN_HASH ($aid)
 {
-	global $cacheArray, $_CONFIG;
+	global $cacheArray;
 	$ret = "-1";
 	if (isset($cacheArray['admins']['password'][$aid])) {
 		// Check cache
 		$ret = $cacheArray['admins']['password'][$aid];
 
 		// Update cache hits
-		if (getConfig('cache_hits') > 0) { $_CONFIG['cache_hits']++; } else { $_CONFIG['cache_hits'] = 1; }
+		incrementConfigEntry('cache_hits');
 	} elseif (!EXT_IS_ACTIVE("cache")) {
 		// Load from database
 		$result = SQL_QUERY_ESC("SELECT password FROM "._MYSQL_PREFIX."_admins WHERE id=%s LIMIT 1",
@@ -1370,14 +1362,14 @@ function GET_ADMIN_HASH ($aid)
 }
 //
 function GET_ADMIN_LOGIN ($aid) {
-	global $cacheArray, $_CONFIG;
+	global $cacheArray;
 	$ret = "***";
 	if (isset($cacheArray['admins']['login'][$aid])) {
 		// Get cache
 		$ret = $cacheArray['admins']['login'][$aid];
 
 		// Update cache hits
-		if (getConfig('cache_hits') > 0) { $_CONFIG['cache_hits']++; } else { $_CONFIG['cache_hits'] = 1; }
+		incrementConfigEntry('cache_hits');
 	} elseif (!EXT_IS_ACTIVE("cache")) {
 		// Load from database
 		$result = SQL_QUERY_ESC("SELECT login FROM "._MYSQL_PREFIX."_admins WHERE id=%s LIMIT 1",
@@ -1397,7 +1389,7 @@ function GET_ADMIN_LOGIN ($aid) {
 }
 // Get email address of admin id
 function GET_ADMIN_EMAIL ($aid) {
-	global $cacheArray, $_CONFIG;
+	global $cacheArray;
 
 	$ret = "***";
 	if (isset($cacheArray['admins']['email'][$aid])) {
@@ -1405,7 +1397,7 @@ function GET_ADMIN_EMAIL ($aid) {
 		$ret = $cacheArray['admins']['email'][$aid];
 
 		// Update cache hits
-		if (getConfig('cache_hits') > 0) { $_CONFIG['cache_hits']++; } else { $_CONFIG['cache_hits'] = 1; }
+		incrementConfigEntry('cache_hits');
 	} elseif (!EXT_IS_ACTIVE("cache")) {
 		// Load from database
 		$result_aid = SQL_QUERY_ESC("SELECT email FROM "._MYSQL_PREFIX."_admins WHERE id=%s LIMIT 1",
@@ -1427,7 +1419,7 @@ function GET_ADMIN_EMAIL ($aid) {
 }
 // Get default ACL  of admin id
 function GET_ADMIN_DEFAULT_ACL ($aid) {
-	global $cacheArray, $_CONFIG;
+	global $cacheArray;
 
 	$ret = "***";
 	if (isset($cacheArray['admins']['def_acl'][$aid])) {
@@ -1435,7 +1427,7 @@ function GET_ADMIN_DEFAULT_ACL ($aid) {
 		$ret = $cacheArray['admins']['def_acl'][$aid];
 
 		// Update cache hits
-		if (getConfig('cache_hits') > 0) { $_CONFIG['cache_hits']++; } else { $_CONFIG['cache_hits'] = 1; }
+		incrementConfigEntry('cache_hits');
 	} elseif (!EXT_IS_ACTIVE("cache")) {
 		// Load from database
 		$result_aid = SQL_QUERY_ESC("SELECT default_acl FROM "._MYSQL_PREFIX."_admins WHERE id=%s LIMIT 1",
@@ -1456,16 +1448,16 @@ function GET_ADMIN_DEFAULT_ACL ($aid) {
 	return $ret;
 }
 //
-function ADD_OPTION_LINES($table, $id, $name, $default="",$special="",$where="") {
+function ADD_OPTION_LINES ($table, $id, $name, $default="", $special="", $where="") {
 	$ret = "";
 	if ($table == "/ARRAY/") {
 		// Selection from array
 		if (is_array($id) && is_array($name) && sizeof($id) == sizeof($name)) {
 			// Both are arrays
 			foreach ($id as $idx => $value) {
-				$ret .= "<OPTION value=\"".$value."\"";
+				$ret .= "<option value=\"".$value."\"";
 				if ($default == $value) $ret .= " selected checked";
-				$ret .= ">".$name[$idx]."</OPTION>\n";
+				$ret .= ">".$name[$idx]."</option>\n";
 			} // END - foreach
 		} // END - if
 	} else {
@@ -1475,22 +1467,22 @@ function ADD_OPTION_LINES($table, $id, $name, $default="",$special="",$where="")
 		$ORDER = $name.$SPEC;
 		if ($table == "country") $ORDER = $special;
 		$result = SQL_QUERY_ESC("SELECT %s, %s".$SPEC." FROM "._MYSQL_PREFIX."_%s ".$where." ORDER BY %s",
-		 array($id, $ORDER, $table, $name), __FILE__, __LINE__);
+			array($id, $ORDER, $table, $name), __FILE__, __LINE__);
 		if (SQL_NUMROWS($result) > 0) {
 			// Found data so add them as OPTION lines: $id is the value and $name is the "name" of the option
 			while (list($value, $title, $add) = SQL_FETCHROW($result)) {
 				if (empty($special)) $add = "";
-				$ret .= "<OPTION value=\"".$value."\"";
+				$ret .= "<option value=\"".$value."\"";
 				if ($default == $value) $ret .= " selected checked";
 				if (!empty($add)) $add = " (".$add.")";
-				$ret .= ">".$title.$add."</OPTION>\n";
+				$ret .= ">".$title.$add."</option>\n";
 			} // END - while
 
 			// Free memory
 			SQL_FREERESULT($result);
 		} else {
 			// No data found
-			$ret = "<OPTION value=\"x\">".SELECT_NONE."</OPTION>\n";
+			$ret = "<option value=\"x\">".SELECT_NONE."</option>\n";
 		}
 	}
 
@@ -1561,10 +1553,9 @@ WHERE p.userid=%s", array(bigintval($uid)), __FILE__, __LINE__);
 	// Ok, delete the account!
 	SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM `"._MYSQL_PREFIX."_user_data` WHERE userid=%s LIMIT 1", array(bigintval($uid)), __FILE__, __LINE__);
 }
+
 //
 function META_DESCRIPTION ($mod, $wht) {
-	global $_CONFIG;
-
 	// Exclude admin and member's area
 	if (($mod != "admin") && ($mod != "login")) {
 		// Construct dynamic description
@@ -1657,8 +1648,6 @@ function LOAD_CONFIG ($no="0") {
 }
 // Gets the matching what name from module
 function GET_WHAT($modCheck) {
-	global $_CONFIG;
-
 	$wht = "";
 	//* DEBUG: */ echo __LINE__."!".$modCheck."!<br />\n";
 	switch ($modCheck)
@@ -1842,7 +1831,7 @@ WHERE userid=%s AND status='CONFIRMED' AND receive_mails > 0".PREPARE_SQL_HTML_H
 		$OUT = "";
 		foreach ($CATS['id'] as $key => $value) {
 			if (strlen($CATS['name'][$key]) > 20) $CATS['name'][$key] = substr($CATS['name'][$key], 0, 17)."...";
-			$OUT .= "      <OPTION value=\"".$value."\">".$CATS['name'][$key]." (".$CATS['uids'][$key]." ".USER_IN_CAT.")</OPTION>\n";
+			$OUT .= "      <option value=\"".$value."\">".$CATS['name'][$key]." (".$CATS['uids'][$key]." ".USER_IN_CAT.")</option>\n";
 		}
 	} else {
 		// No cateogries are defined yet
@@ -1918,8 +1907,6 @@ VALUES ('%s','%s','%s','%s','%s','NEW', UNIX_TIMESTAMP(),'%s','%s','%s','%s')",
 
 // Generate a receiver list for given category and maximum receivers
 function GENERATE_RECEIVER_LIST ($cat, $receiver, $mode="") {
-	global $_CONFIG;
-
 	// Init variables
 	$CAT_TABS     = "%s";
 	$CAT_WHERE    = "";
@@ -2034,8 +2021,6 @@ function USER_STATS_INSERT_RECORD ($uid, $type, $data) {
 
 // "Getter" for array for user refs and points in given level
 function GET_USER_REF_POINTS ($uid, $level) {
-	global $_CONFIG;
-
 	//* DEBUG: */ print "----------------------- <font color=\"#00aa00\">".__FUNCTION__." - ENTRY</font> ------------------------<ul><li>\n";
 	// Default is no refs and no nickname
 	$ADD = "";