X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Flibs%2Fsponsor_functions.php;h=6e07f8f46c89513a469ccac4cd7a46da3e29617f;hb=de00b5169fad659aa89d398b35ac83357c549f51;hp=1b8056b99e39a22a68d0ea05eeeadb22560be9b8;hpb=ac04130f9ccbaba51d7d7992d8a10c38db776eee;p=mailer.git

diff --git a/inc/libs/sponsor_functions.php b/inc/libs/sponsor_functions.php
index 1b8056b99e..6e07f8f46c 100644
--- a/inc/libs/sponsor_functions.php
+++ b/inc/libs/sponsor_functions.php
@@ -69,7 +69,7 @@ function SPONSOR_HANDLE_SPONSOR (&$POST, $NO_UPDATE=false, $MSGs=array(), $RET_S
 					$SAVE = false;
 				} else {
 					// Do we want to add a new sponsor or update his data?
-					$result = SQL_QUERY_ESC("SELECT id FROM "._MYSQL_PREFIX."_sponsor_data WHERE email='%s' LIMIT 1",
+					$result = SQL_QUERY_ESC("SELECT id FROM `"._MYSQL_PREFIX."_sponsor_data` WHERE email='%s' LIMIT 1",
 						array($POST['email']), __FILE__, __LINE__);
 
 					// Is a sponsor alread in the db?
@@ -103,32 +103,7 @@ function SPONSOR_HANDLE_SPONSOR (&$POST, $NO_UPDATE=false, $MSGs=array(), $RET_S
 
 			default:
 				// Test if there is are time selections
-				$TEST = substr($k, -3);
-				if ((($TEST == "_ye") || ($TEST == "_mo") || ($TEST == "_we") || ($TEST == "_da") || ($TEST == "_ho") || ($TEST == "_mi") || ($TEST == "_se")) && (!empty($v))) {
-					// Found a multi-selection for timings?
-					$TEST = substr($k, 0, -3);
-					if ((!empty($POST[$TEST."_ye"])) && (!empty($POST[$TEST."_mo"])) && (!empty($POST[$TEST."_we"])) && (!empty($POST[$TEST."_da"])) && (!empty($POST[$TEST."_ho"])) && (!empty($POST[$TEST."_mi"])) && (!empty($POST[$TEST."_se"])) && ($TEST != $TEST2)) {
-						// Generate timestamp
-						$POST[$TEST] = CREATE_TIMESTAMP_FROM_SELECTIONS($TEST, $POST);
-						$DATA['keys'][] = $TEST;
-						$DATA['values'][] = $POST[$TEST];
-
-						// Remove data from array
-						// @TODO Do we still need this all?
-						unset($POST[$TEST."_ye"]);
-						unset($POST[$TEST."_mo"]);
-						unset($POST[$TEST."_we"]);
-						unset($POST[$TEST."_da"]);
-						unset($POST[$TEST."_ho"]);
-						unset($POST[$TEST."_mi"]);
-						unset($POST[$TEST."_se"]);
-
-						// Skip adding
-						$k = ""; $skip = true; $TEST2 = $TEST;
-					}
-				} else {
-					$skip = false; $TEST2 = "";
-				}
+				CONVERT_SELECTIONS_TO_TIMESTAMP($POST, $DATA, $k, $skip);
 				break;
 			}
 
@@ -150,7 +125,7 @@ function SPONSOR_HANDLE_SPONSOR (&$POST, $NO_UPDATE=false, $MSGs=array(), $RET_S
 		// Update?
 		if ($UPDATE) {
 			// Update his data
-			$SQL = "UPDATE "._MYSQL_PREFIX."_sponsor_data SET ";
+			$SQL = "UPDATE `"._MYSQL_PREFIX."_sponsor_data` SET ";
 			foreach ($DATA['keys'] as $k => $v) {
 				$SQL .= $v."='%s', ";
 			}
@@ -185,7 +160,7 @@ function SPONSOR_HANDLE_SPONSOR (&$POST, $NO_UPDATE=false, $MSGs=array(), $RET_S
 			$VALUES = str_repeat("%s', '", count($DATA['values']) - 1);
 
 			// Generate string
-			$SQL = "INSERT INTO "._MYSQL_PREFIX."_sponsor_data (".$KEYS.") VALUES ('".$VALUES."%s')";
+			$SQL = "INSERT INTO `"._MYSQL_PREFIX."_sponsor_data` (".$KEYS.") VALUES ('".$VALUES."%s')";
 
 			// Generate message
 			$MSG = SPONSOR_GET_MESSAGE(ADMIN_SPONSOR_ADDED, "added", $MSGs);
@@ -289,7 +264,7 @@ function IS_SPONSOR () {
 	$ret = false;
 	if ((isSessionVariableSet('sponsorid'))) && (isSessionVariableSet('sponsorpass')))) {
 		// Check cookies against database records...
-		$result = SQL_QUERY_ESC("SELECT id FROM "._MYSQL_PREFIX."_sponsor_data
+		$result = SQL_QUERY_ESC("SELECT id FROM `"._MYSQL_PREFIX."_sponsor_data`
 WHERE id='%s' AND password='%s' AND status='CONFIRMED' LIMIT 1",
 			array(bigintval(get_session('sponsorid')), get_session('sponsorpass')), __FILE__, __LINE__);
 		if (SQL_NUMROWS($result) == 1) {
@@ -312,7 +287,7 @@ function GENERATE_SPONSOR_MENU($current)
 	if (IS_ADMIN()) $WHERE = "";
 
 	// Load main menu entries
-	$result_main = SQL_QUERY("SELECT action, title FROM "._MYSQL_PREFIX."_sponsor_menu
+	$result_main = SQL_QUERY("SELECT action, title FROM `"._MYSQL_PREFIX."_sponsor_menu`
 WHERE (what='' OR what IS NULL) ".$WHERE."
 ORDER BY sort", __FILE__, __LINE__);
 	if (SQL_NUMROWS($result_main) > 0)
@@ -321,7 +296,7 @@ ORDER BY sort", __FILE__, __LINE__);
 		while(list($action, $title_main) = SQL_FETCHROW($result_main))
 		{
 			// Load sub menus
-			$result_sub = SQL_QUERY_ESC("SELECT what, title FROM "._MYSQL_PREFIX."_sponsor_menu
+			$result_sub = SQL_QUERY_ESC("SELECT what, title FROM `"._MYSQL_PREFIX."_sponsor_menu`
 WHERE action='%s' AND what != '' AND what IS NOT NULL ".$WHERE."
 ORDER BY sort", array($action), __FILE__, __LINE__);
 			if (SQL_NUMROWS($result_sub) > 0)
@@ -399,7 +374,7 @@ function UPDATE_SPONSOR_LOGIN () {
 	// Is sponsor?
 	if (IS_SPONSOR()) {
 		// Update last online timestamp
-		SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_sponsor_data
+		SQL_QUERY_ESC("UPDATE `"._MYSQL_PREFIX."_sponsor_data`
 SET last_online=UNIX_TIMESTAMP()
 WHERE id='%s' AND password='%s' LIMIT 1",
 			array(bigintval(get_session('sponsorid')), get_session('sponsorpass')), __FILE__, __LINE__);
@@ -442,7 +417,7 @@ function SPONSOR_SAVE_DATA ($POST, $content) {
 	$DATA = array();
 
 	// Prepare SQL string
-	$SQL = "UPDATE "._MYSQL_PREFIX."_sponsor_data SET";
+	$SQL = "UPDATE `"._MYSQL_PREFIX."_sponsor_data` SET";
 	foreach ($POST as $key => $value) {
 		// Mmmmm, too less security here???
 		$SQL   .= " ".strip_tags($key)."='%s',";