X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=inc%2Fmodules%2Fadmin%2Fwhat-list_rallyes.php;h=4438870eee70aee9589aebc598b44f89b249eefd;hp=18d8b63cd5983f23999450d4326feffea05f0b6d;hb=0369c36aaab5af6ed44da1e13a53baef285f79b4;hpb=e1653405d28923c78b2e292125306ccf61138f24

diff --git a/inc/modules/admin/what-list_rallyes.php b/inc/modules/admin/what-list_rallyes.php
index 18d8b63cd5..4438870eee 100644
--- a/inc/modules/admin/what-list_rallyes.php
+++ b/inc/modules/admin/what-list_rallyes.php
@@ -54,11 +54,11 @@ if (isset($_GET['rallye']))
 		switch ($_GET['activate'])
 		{
 		case "1": // Activate
-			$SQL = "UPDATE "._MYSQL_PREFIX."_rallye_data SET is_active='Y' WHERE id=%d AND is_active='N' LIMIT 1";
+			$SQL = "UPDATE "._MYSQL_PREFIX."_rallye_data SET is_active='Y' WHERE id=%s AND is_active='N' LIMIT 1";
 			break;
 
 		case "0": // Deactivate
-			$SQL = "UPDATE "._MYSQL_PREFIX."_rallye_data SET is_active='N' WHERE id=%d AND is_active='Y' LIMIT 1";
+			$SQL = "UPDATE "._MYSQL_PREFIX."_rallye_data SET is_active='N' WHERE id=%s AND is_active='Y' LIMIT 1";
 			break;
 		}
 	}
@@ -69,11 +69,11 @@ if (isset($_GET['rallye']))
 		switch ($_GET['notify'])
 		{
 		case "1": // Activate
-			$SQL = "UPDATE "._MYSQL_PREFIX."_rallye_data SET send_notify='Y' WHERE id=%d AND send_notify='N' LIMIT 1";
+			$SQL = "UPDATE "._MYSQL_PREFIX."_rallye_data SET send_notify='Y' WHERE id=%s AND send_notify='N' LIMIT 1";
 			break;
 
 		case "0": // Deactivate
-			$SQL = "UPDATE "._MYSQL_PREFIX."_rallye_data SET send_notify='N' WHERE id=%d AND send_notify='Y' LIMIT 1";
+			$SQL = "UPDATE "._MYSQL_PREFIX."_rallye_data SET send_notify='N' WHERE id=%s AND send_notify='Y' LIMIT 1";
 			break;
 		}
 	}
@@ -84,11 +84,11 @@ if (isset($_GET['rallye']))
 		switch ($_GET['auto'])
 		{
 		case "1": // Activate
-			$SQL = "UPDATE "._MYSQL_PREFIX."_rallye_data SET auto_add_new_user='Y' WHERE id=%d AND auto_add_new_user='N' LIMIT 1";
+			$SQL = "UPDATE "._MYSQL_PREFIX."_rallye_data SET auto_add_new_user='Y' WHERE id=%s AND auto_add_new_user='N' LIMIT 1";
 			break;
 
 		case "0": // Deactivate
-			$SQL = "UPDATE "._MYSQL_PREFIX."_rallye_data SET auto_add_new_user='N' WHERE id=%d AND auto_add_new_user='Y' LIMIT 1";
+			$SQL = "UPDATE "._MYSQL_PREFIX."_rallye_data SET auto_add_new_user='N' WHERE id=%s AND auto_add_new_user='Y' LIMIT 1";
 			break;
 		}
 	}
@@ -106,14 +106,14 @@ if (isset($_GET['rallye']))
 	if ($SEL > 0)
 	{
 		// Delete selected rallyes and all it's data
-		foreach ($_POST['sel'] as $id=>$sel)
+		foreach ($_POST['sel'] as $id => $sel)
 		{
 			// Remove selected rallye entirely...
-			$result = SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM "._MYSQL_PREFIX."_rallye_data WHERE id=%d LIMIT 1",
+			$result = SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM "._MYSQL_PREFIX."_rallye_data WHERE id=%s LIMIT 1",
 			 array(bigintval($id)), __FILE__, __LINE__);
-			$result = SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM "._MYSQL_PREFIX."_rallye_prices WHERE rallye_id=%d",
+			$result = SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM "._MYSQL_PREFIX."_rallye_prices WHERE rallye_id=%s",
 			 array(bigintval($id)), __FILE__, __LINE__);
-			$result = SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM "._MYSQL_PREFIX."_rallye_users WHERE rallye_id=%d",
+			$result = SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM "._MYSQL_PREFIX."_rallye_users WHERE rallye_id=%s",
 			 array(bigintval($id)), __FILE__, __LINE__);
 		}
 
@@ -133,7 +133,7 @@ if (isset($_GET['rallye']))
 	if ($SEL > 0)
 	{
 		// Change selected rallyes and all it's data
-		foreach ($_POST['title'] as $id=>$title)
+		foreach ($_POST['title'] as $id => $title)
 		{
 			// Secure ID number
 			$id = bigintval($id);
@@ -169,10 +169,10 @@ if (isset($_POST['edit']))
 	{
 		// Make all selected and deactivated rallyes editable
 		$SW = 2; $OUT = "";
-		foreach ($_POST['sel'] as $id=>$sel)
+		foreach ($_POST['sel'] as $id => $sel)
 		{
 			// Load rallye basic data
-			$result = SQL_QUERY_ESC("SELECT title, descr, template, start_time, end_time, min_users, min_prices FROM "._MYSQL_PREFIX."_rallye_data WHERE id=%d LIMIT 1",
+			$result = SQL_QUERY_ESC("SELECT title, descr, template, start_time, end_time, min_users, min_prices FROM "._MYSQL_PREFIX."_rallye_data WHERE id=%s LIMIT 1",
 			 array(bigintval($id)), __FILE__, __LINE__);
 			list($title, $descr, $templ, $start, $end, $min_users, $min_prices) = SQL_FETCHROW($result);
 			SQL_FREERESULT($result);
@@ -223,7 +223,7 @@ if (isset($_POST['edit']))
  elseif (($_GET['sub'] == "users") && ($_GET['rallye'] > 0))
 {
 	// List users and their refs before start and current
-	$result = SQL_QUERY_ESC("SELECT userid, refs, curr_points FROM "._MYSQL_PREFIX."_rallye_users WHERE rallye_id=%d ORDER BY userid",
+	$result = SQL_QUERY_ESC("SELECT userid, refs, curr_points FROM "._MYSQL_PREFIX."_rallye_users WHERE rallye_id=%s ORDER BY userid",
 	 array(bigintval($_GET['rallye'])), __FILE__, __LINE__);
 	if (SQL_NUMROWS($result) > 0)
 	{
@@ -240,7 +240,7 @@ if (isset($_POST['edit']))
 			if (($old > 0) || ($cnt > 0))
 			{
 				// Insert link to referral list
-				//* DEBUG: */ echo "-".$uid."/".$cnt."/".$old."-<BR>";
+				//* DEBUG: */ echo "-".$uid."/".$cnt."/".$old."-<br />";
 				$cnt = ADMIN_USER_PROFILE_LINK($uid, $cnt, "list_refs");
 				$old = ADMIN_USER_PROFILE_LINK($uid, $old, "list_refs");
 			}
@@ -287,11 +287,11 @@ ORDER BY start_time DESC",
 			$alogin = GET_ADMIN_LOGIN($aid);
 
 			// Count assigned prices
-			$result_prices = SQL_QUERY_ESC("SELECT id FROM "._MYSQL_PREFIX."_rallye_prices WHERE rallye_id=%d",
+			$result_prices = SQL_QUERY_ESC("SELECT id FROM "._MYSQL_PREFIX."_rallye_prices WHERE rallye_id=%s",
 			 array(bigintval($id)), __FILE__, __LINE__);
 
 			// Count joined userids
-			$result_user = SQL_QUERY_ESC("SELECT id FROM "._MYSQL_PREFIX."_rallye_users WHERE rallye_id=%d",
+			$result_user = SQL_QUERY_ESC("SELECT id FROM "._MYSQL_PREFIX."_rallye_users WHERE rallye_id=%s",
 			 array($id), __FILE__, __LINE__);
 			$joined = SQL_NUMROWS($result_user);
 
@@ -341,7 +341,7 @@ ORDER BY start_time DESC",
 				// Rallye is active so do not edit it!
 				$content['select'] = "<STRONG class=\"big\">".$id."</STRONG>";
 				$content['active_title'] = RALLYE_DEACTIVATE_NOW;
-				$content['active'] = "0";
+				$content['active'] = 0;
 				break;
 
 			case 'N':
@@ -355,7 +355,7 @@ ORDER BY start_time DESC",
 			{
 			case 'Y':
 				$content['notify_title'] = RALLYE_STOP_NOTIFY_NOW;
-				$content['notify'] = "0";
+				$content['notify'] = 0;
 				break;
 
 			case 'N':
@@ -369,7 +369,7 @@ ORDER BY start_time DESC",
 			{
 			case 'Y':
 				$content['auto_title'] = RALLYE_STOP_AUTO_ADD_NOW;
-				$content['auto'] = "0";
+				$content['auto'] = 0;
 				break;
 
 			case 'N':