X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Flibs%2Fsponsor_functions.php;h=a2b9d11c336de89adfec42d2ea8b1607826a8a4c;hb=64eecfb13d8618ddcf0e9d53920a21b0401b3971;hp=5f9ff596a241cb54a64c934970f40b994632b9ee;hpb=0a37fc5afcd828646d4e62e68fea07c3d2c54a87;p=mailer.git diff --git a/inc/libs/sponsor_functions.php b/inc/libs/sponsor_functions.php index 5f9ff596a2..a2b9d11c33 100644 --- a/inc/libs/sponsor_functions.php +++ b/inc/libs/sponsor_functions.php @@ -157,7 +157,7 @@ function handleSponsorRequest ($postData, $update=false, $messageArray = array() // Generate hash code $DATA['keys'][] = 'hash'; // @TODO Rewrite this to API function - $DATA['values'][] = md5(session_id() . getEncryptSeperator() . $postData['email'] . getEncryptSeperator() . detectRemoteAddr() . getEncryptSeperator() . detectUserAgent() . getEncryptSeperator() . time()); + $DATA['values'][] = md5(session_id() . getEncryptSeparator() . $postData['email'] . getEncryptSeparator() . detectRemoteAddr() . getEncryptSeparator() . detectUserAgent() . getEncryptSeparator() . time()); $DATA['keys'][] = 'remote_addr'; $DATA['values'][] = detectRemoteAddr(); } @@ -269,7 +269,8 @@ function addSponsorMenu ($current) { // Load main menu entries $result_main = SQL_QUERY("SELECT - `action` AS `main_action`,`title` AS `main_title` + `action` AS `main_action`, + `title` AS `main_title` FROM `{?_MYSQL_PREFIX?}_sponsor_menu` WHERE @@ -282,7 +283,8 @@ ORDER BY while ($content = SQL_FETCHARRAY($result_main)) { // Load sub menus $result_sub = SQL_QUERY_ESC("SELECT - `what` AS `sub_what`,`title` AS `sub_title` + `what` AS `sub_what`, + `title` AS `sub_title` FROM `{?_MYSQL_PREFIX?}_sponsor_menu` WHERE @@ -424,11 +426,11 @@ function saveSponsorData ($postData, $content) { $EMAIL = true; // Okay, has changed then add status with UNCONFIRMED and new hash code - $sql .= " `status`='EMAIL', `hash`='%s',"; + $sql .= " `status`='EMAIL',`hash`='%s',"; // Generate hash code // @TODO Rewrite this to API function - $HASH = md5(session_id() . getEncryptSeperator() . $postData['email'] . getEncryptSeperator() . detectRemoteAddr() . getEncryptSeperator() . detectUserAgent() . getEncryptSeperator() . time()); + $HASH = md5(session_id() . getEncryptSeparator() . $postData['email'] . getEncryptSeparator() . detectRemoteAddr() . getEncryptSeparator() . detectUserAgent() . getEncryptSeparator() . time()); $DATA[] = $HASH; } // END - if } // END - if @@ -436,7 +438,7 @@ function saveSponsorData ($postData, $content) { $sql = substr($sql, 0, -1); // Add last_change - $sql .= ', `last_change`=NOW()'; + $sql .= ',`last_change`=NOW()'; // Add SQL tail data $sql .= " WHERE `id`=%s AND `password`='%s' LIMIT 1";