X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Flibs%2Fsponsor_functions.php;h=a2b9d11c336de89adfec42d2ea8b1607826a8a4c;hb=64eecfb13d8618ddcf0e9d53920a21b0401b3971;hp=7c48106f356f15f0d0a088abc49c07cfefbfdf44;hpb=be95b59229961d5d633def85d896329f33deba02;p=mailer.git diff --git a/inc/libs/sponsor_functions.php b/inc/libs/sponsor_functions.php index 7c48106f35..a2b9d11c33 100644 --- a/inc/libs/sponsor_functions.php +++ b/inc/libs/sponsor_functions.php @@ -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,7 +426,7 @@ 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 @@ -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";