X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Fmysql-manager.php;h=a2cb2579fa00f7e7279a23ff1264e15a9736bdb9;hb=6822d852b1eebf903029dc8218ade7778c0a331e;hp=ea9bff0ee3b9387ce02e056024754deea04c9f56;hpb=dbd1bc95c8f89024118791dc3fb3633a90afa9cf;p=mailer.git

diff --git a/inc/mysql-manager.php b/inc/mysql-manager.php
index ea9bff0ee3..a2cb2579fa 100644
--- a/inc/mysql-manager.php
+++ b/inc/mysql-manager.php
@@ -280,14 +280,14 @@ function ADD_DESCR($ACC_LVL, $file, $return = false, $output = true)
 	if ((!isset($DEPTH)) && (!$return))
 	{
 		$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) $DEPTH++;
-		$PREFIX = "";
+		$prefix = "";
 	}
-	$PREFIX .= "&nbsp;-&gt;&nbsp;";
+	$prefix .= "&nbsp;-&gt;&nbsp;";
 	if (ereg(".php", $search))
 	{
 		$search = substr($search, 0, strpos($search, ".php"));
@@ -306,7 +306,7 @@ 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";
+			$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";
@@ -343,7 +343,7 @@ function ADD_MENU($MODE, $act, $wht)
 	//* DEBUG: */ echo __LINE__."/".$main_cnt."/".$main_action."/".$sub_what.":".$GLOBALS['what']."*<br />\n";
 	if (SQL_NUMROWS($result_main) > 0)
 	{
-		OUTPUT_HTML ("<TABLE border=\"0\" cellspacing=\"0\" cellpadding=\"0\" class=\"".$MODE."_menu\">");
+		OUTPUT_HTML("<TABLE border=\"0\" cellspacing=\"0\" cellpadding=\"0\" class=\"".$MODE."_menu\">");
 		// There are menus available, so we simply display them... :)
 		while (list($main_title, $main_action) = SQL_FETCHROW($result_main))
 		{
@@ -427,19 +427,19 @@ function ADD_MENU($MODE, $act, $wht)
 				if ((file_exists($INC_BLOCK)) && (is_readable($INC_BLOCK)))
 				{
 					// Load include file
-					if ((!EXT_IS_ACTIVE($main_action)) || ($main_action == "online")) OUTPUT_HTML ("<TR>
+					if ((!EXT_IS_ACTIVE($main_action)) || ($main_action == "online")) OUTPUT_HTML("<TR>
   <TD class=\"".$MODE."_menu_whats\">");
 					//* DEBUG: */ echo __LINE__."/".$main_cnt."/".$main_action."/".$sub_what.":".$GLOBALS['what']."*<br />\n";
 					include ($INC_BLOCK);
 					//* DEBUG: */ echo __LINE__."/".$main_cnt."/".$main_action."/".$sub_what.":".$GLOBALS['what']."*<br />\n";
-					if ((!EXT_IS_ACTIVE($main_action)) || ($main_action == "online")) OUTPUT_HTML ("  </TD>
+					if ((!EXT_IS_ACTIVE($main_action)) || ($main_action == "online")) OUTPUT_HTML("  </TD>
 </TR>");
 				}
 				//* DEBUG: */ echo __LINE__."/".$main_cnt."/".$main_action."/".$sub_what.":".$GLOBALS['what']."*<br />\n";
 			}
 			$main_cnt++;
 			//* DEBUG: */ echo __LINE__."/".$main_cnt."/".$main_action."/".$sub_what.":".$GLOBALS['what']."*<br />\n";
-			if (SQL_NUMROWS($result_main) > $main_cnt) 	OUTPUT_HTML ("<TR><TD class=\"".$MODE."_menu_seperator\"></TD></TR>");
+			if (SQL_NUMROWS($result_main) > $main_cnt) 	OUTPUT_HTML("<TR><TD class=\"".$MODE."_menu_seperator\"></TD></TR>");
 		}
 
 		// Free memory
@@ -447,7 +447,7 @@ function ADD_MENU($MODE, $act, $wht)
 
 		// Close table
 		//* DEBUG: */ echo __LINE__."/".$main_cnt."/".$main_action."/".$sub_what.":".$GLOBALS['what']."*<br />\n";
-		OUTPUT_HTML ("</TABLE>");
+		OUTPUT_HTML("</TABLE>");
 	}
 }
 // This patched function will reduce many SELECT queries for the specified or current admin login
@@ -569,7 +569,7 @@ function ADD_MAX_RECEIVE_LIST($MODE, $default="", $return=false)
 	 else
 	{
 		// Output directly (default)
-		OUTPUT_HTML ($OUT);
+		OUTPUT_HTML($OUT);
 	}
 }
 //
@@ -1167,12 +1167,12 @@ function ADD_POINTS_REFSYSTEM($uid, $points, $send_notify=false, $rid="0", $lock
 			$P = $points * $per / 100;
 
 			// Update points...
-			$result = SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_user_points SET %s=%s+%s WHERE userid=%d AND ref_depth='%s' LIMIT 1",
+			$result = SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_user_points SET %s=%s+%s WHERE userid=%d AND ref_depth=%d LIMIT 1",
 			 array($data, $data, $P, bigintval($uid), bigintval($DEPTH)), __FILE__, __LINE__);
 			if (SQL_AFFECTEDROWS($link, __FILE__, __LINE__) == 0)
 			{
 				// 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 (%d, %d, %s)",
 				 array($data, bigintval($uid), bigintval($DEPTH), $P), __FILE__, __LINE__);
 			}
 
@@ -1531,7 +1531,7 @@ function META_DESCRIPTION($mod, $wht)
 		// Exclude admin and member's area
 		$DESCR = MAIN_TITLE." ".trim($CONFIG['title_middle'])." ".ADD_DESCR("guest", "what-".$wht, true);
 		unset($DEPTH);
-		OUTPUT_HTML ("<META name=\"description\" content=\"".$DESCR."\">\n");
+		OUTPUT_HTML("<META name=\"description\" content=\"".$DESCR."\">\n");
 	}
 }
 //
@@ -1564,7 +1564,7 @@ function SUB_JACKPOT($points)
 	if (SQL_NUMROWS($result) == 0)
 	{
 		// Create line
-		$result = SQL_QUERY("INSERT INTO "._MYSQL_PREFIX."_jackpot (ok, points) VALUES ('ok', '0.00000')", __FILE__, __LINE__);
+		$result = SQL_QUERY("INSERT INTO "._MYSQL_PREFIX."_jackpot (ok, points) VALUES ('ok', 0.00000)", __FILE__, __LINE__);
 	}
 	 else
 	{
@@ -1576,7 +1576,8 @@ function SUB_JACKPOT($points)
 		if ($jackpot >= $points)
 		{
 			// Update points when there are enougth points in jackpot
-			$result = SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_jackpot SET points=points-%s WHERE ok='ok' LIMIT 1", array($points), __FILE__, __LINE__);
+			$result = SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_jackpot SET points=points-%s WHERE ok='ok' LIMIT 1",
+				array($points), __FILE__, __LINE__);
 			$ret = $jackpot - $points;
 		}
 	}