X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=inc%2Fmodules%2Fadmin%2Fwhat-list_links.php;h=e69026afb7046fce5cfb69702d529be557d880f9;hp=0f31e43bd914ea48c7f0e917809f0a0a4814a5bf;hb=5071030af40e69ca4284642f44758964e18f5be8;hpb=3dc2d90bb1fb18124d214dd0aa06f0d3489393e6 diff --git a/inc/modules/admin/what-list_links.php b/inc/modules/admin/what-list_links.php index 0f31e43bd9..e69026afb7 100644 --- a/inc/modules/admin/what-list_links.php +++ b/inc/modules/admin/what-list_links.php @@ -53,9 +53,9 @@ if (!REQUEST_ISSET_GET('del')) REQUEST_SET_GET('del', ''); if (REQUEST_ISSET_GET('uid')) { // Check if the user already exists $result = SQL_QUERY_ESC("SELECT surname, family, email FROM `{!_MYSQL_PREFIX!}_user_data` WHERE userid=%s LIMIT 1", - array(bigintval(REQUEST_GET('uid'))), __FILE__, __LINE__); + array(bigintval(REQUEST_GET('uid'))), __FILE__, __LINE__); - // Is there an entry? + // Is there an entry? if (SQL_NUMROWS($result) == 1) { // Loads surname, family's name and the email address list($sname, $fname, $email) = SQL_FETCHROW($result); @@ -65,11 +65,11 @@ if (REQUEST_ISSET_GET('uid')) { if (EXT_IS_ACTIVE('bonus')) { // Load bonus ID $result = SQL_QUERY_ESC("SELECT stats_id, bonus_id, link_type FROM `{!_MYSQL_PREFIX!}_user_links` WHERE userid=%s ORDER BY `id`", - array(bigintval(REQUEST_GET('uid'))), __FILE__, __LINE__); + array(bigintval(REQUEST_GET('uid'))), __FILE__, __LINE__); } else { // Load stats ID (2nd will be ignored later! But it is needed for the same fetchrow command) $result = SQL_QUERY_ESC("SELECT stats_id, stats_id, link_type FROM `{!_MYSQL_PREFIX!}_user_links` WHERE userid=%s ORDER BY `id`", - array(bigintval(REQUEST_GET('uid'))), __FILE__, __LINE__); + array(bigintval(REQUEST_GET('uid'))), __FILE__, __LINE__); } // Get number of rows from the query @@ -80,7 +80,7 @@ if (REQUEST_ISSET_GET('uid')) { if (REQUEST_GET('del') == "all") { // Delete all unconfirmed mails by this user SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM `{!_MYSQL_PREFIX!}_user_links` WHERE userid=%s LIMIT %s", - array(bigintval(REQUEST_GET('uid')), $nums), __FILE__, __LINE__); + array(bigintval(REQUEST_GET('uid')), $nums), __FILE__, __LINE__); // Prepare mail and send it away $msg = LOAD_EMAIL_TEMPLATE("admin-del_links", $nums, bigintval(REQUEST_GET('uid'))); @@ -104,24 +104,24 @@ if (REQUEST_ISSET_GET('uid')) { // Load data from stats table... switch ($type) { - case "NORMAL": - $result_data = SQL_QUERY_ESC("SELECT subject, timestamp_ordered, cat_id FROM `{!_MYSQL_PREFIX!}_user_stats` WHERE `id`=%s LIMIT 1", + case "NORMAL": + $result_data = SQL_QUERY_ESC("SELECT subject, timestamp_ordered, cat_id FROM `{!_MYSQL_PREFIX!}_user_stats` WHERE `id`=%s LIMIT 1", array(bigintval($id)), __FILE__, __LINE__); - $type = 'mailid'; $DATA = $id; $PROBLEM = getMessage('NORMAL_MAIL_PROBLEM'); - $LINK = "".$id.""; - break; + $type = 'mailid'; $DATA = $id; $PROBLEM = getMessage('NORMAL_MAIL_PROBLEM'); + $LINK = "".$id.""; + break; - case "BONUS": - $result_data = SQL_QUERY_ESC("SELECT subject, timestamp, cat_id FROM `{!_MYSQL_PREFIX!}_bonus` WHERE `id`=%s LIMIT 1", + case "BONUS": + $result_data = SQL_QUERY_ESC("SELECT subject, timestamp, cat_id FROM `{!_MYSQL_PREFIX!}_bonus` WHERE `id`=%s LIMIT 1", array(bigintval($id2)), __FILE__, __LINE__); - $type = 'bonusid'; $DATA = $id2; $PROBLEM = getMessage('BONUS_MAIL_PROBLEM'); - $LINK = "".$id2.""; - break; - - default: // Problem in application detected! - // Log the error - DEBUG_LOG(__FILE__, __LINE__, sprintf("Invalid email type %s detected.", $type)); - break; + $type = 'bonusid'; $DATA = $id2; $PROBLEM = getMessage('BONUS_MAIL_PROBLEM'); + $LINK = "".$id2.""; + break; + + default: // Problem in application detected! + // Log the error + DEBUG_LOG(__FILE__, __LINE__, sprintf("Invalid email type %s detected.", $type)); + break; } if (SQL_NUMROWS($result_data) == 1) { @@ -144,11 +144,11 @@ if (REQUEST_ISSET_GET('uid')) { } else { // Load template for error $OUT .= LOAD_TEMPLATE("admin_list_links_problem", - array( + array( 'sw' => $SW, 'problem' => $PROBLEM, 'data' => $DATA - ) + ) ); } $SW = 3 - $SW;