X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;ds=sidebyside;f=inc%2Fmodules%2Fmember%2Fwhat-unconfirmed.php;h=b10c723aa538b93a64efd76276ea38c4950bf127;hb=885637e9f61f315ba051500061ec193ebc937f7b;hp=73eff91ad6b0ad403c47d99656a675c7236be0cd;hpb=7b0f17cd637e388049d2167811e4332cec1e979b;p=mailer.git diff --git a/inc/modules/member/what-unconfirmed.php b/inc/modules/member/what-unconfirmed.php index 73eff91ad6..b10c723aa5 100644 --- a/inc/modules/member/what-unconfirmed.php +++ b/inc/modules/member/what-unconfirmed.php @@ -55,7 +55,7 @@ if ((REQUEST_ISSET_GET(('bonusid'))) && (EXT_IS_ACTIVE('bonus'))) { $result_data = SQL_QUERY_ESC("SELECT id, subject, timestamp, cat_id, points, text, is_notify, data_type, time, url FROM `{!_MYSQL_PREFIX!}_bonus` WHERE `id`=%s LIMIT 1", - array(bigintval(REQUEST_GET('bonusid'))), __FILE__, __LINE__); + array(bigintval(REQUEST_GET('bonusid'))), __FILE__, __LINE__); // Load data $content = SQL_FETCHARRAY($result_data); @@ -73,7 +73,7 @@ WHERE `id`=%s LIMIT 1", // Get timestamp from insert $content['user_status'] = sprintf(getMessage('MEMBER_MAIL_BONUS_CONFIRMED_ON'), - generateDateTime(getTimestampFromUserStats('bonusid', $content['id']), '2') + generateDateTime(getTimestampFromUserStats('bonusid', $content['id']), '2') ); // Display it depending on mail (data) type @@ -90,7 +90,7 @@ ON s.pool_id=p.id LEFT JOIN `{!_MYSQL_PREFIX!}_payments` AS pay ON p.payment_id=pay.id WHERE s.id=%s LIMIT 1", - array(bigintval(REQUEST_GET('mailid'))), __FILE__, __LINE__); + array(bigintval(REQUEST_GET('mailid'))), __FILE__, __LINE__); // Load data $content = SQL_FETCHARRAY($result_data); @@ -106,7 +106,7 @@ WHERE s.id=%s LIMIT 1", // Get timestamp from insert $content['user_status'] = sprintf(getMessage('MEMBER_MAIL_NORMAL_CONFIRMED_ON'), - generateDateTime(getTimestampFromUserStats('mailid', $content['id']), '2') + generateDateTime(getTimestampFromUserStats('mailid', $content['id']), '2') ); // Display it depending on mail (data) type @@ -119,11 +119,11 @@ WHERE s.id=%s LIMIT 1", 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 bonus_id DESC, stats_id DESC", - array(getUserId()), __FILE__, __LINE__); + array(getUserId()), __FILE__, __LINE__); } else { // Don't load bonus ID $result = SQL_QUERY_ESC("SELECT stats_id, stats_id, link_type FROM `{!_MYSQL_PREFIX!}_user_links` WHERE userid=%s ORDER BY stats_id DESC", - array(getUserId()), __FILE__, __LINE__); + array(getUserId()), __FILE__, __LINE__); } // Mails left for confirmation? @@ -137,26 +137,26 @@ if (SQL_NUMROWS($result) > 0) { $cat = ''; $result_data = false; switch ($type) { - case 'NORMAL': - $result_data = SQL_QUERY_ESC("SELECT s.subject, s.timestamp_ordered, s.cat_id, s.payment_id, p.sender + case 'NORMAL': + $result_data = SQL_QUERY_ESC("SELECT s.subject, s.timestamp_ordered, s.cat_id, s.payment_id, p.sender FROM `{!_MYSQL_PREFIX!}_user_stats` AS s LEFT JOIN `{!_MYSQL_PREFIX!}_pool` AS p ON s.pool_id=p.id WHERE s.id=%s LIMIT 1", array(bigintval($id)), __FILE__, __LINE__); - $type = 'mailid'; $DATA = $id; $PROBLEM = getMessage('NORMAL_MAIL_PROBLEM'); - break; + $type = 'mailid'; $DATA = $id; $PROBLEM = getMessage('NORMAL_MAIL_PROBLEM'); + break; - case 'BONUS': - $result_data = SQL_QUERY_ESC("SELECT subject, timestamp, cat_id, points, 0 FROM `{!_MYSQL_PREFIX!}_bonus` WHERE `id`=%s LIMIT 1", + case 'BONUS': + $result_data = SQL_QUERY_ESC("SELECT subject, timestamp, cat_id, points, 0 FROM `{!_MYSQL_PREFIX!}_bonus` WHERE `id`=%s LIMIT 1", array(bigintval($id2)), __FILE__, __LINE__); - $type = 'bonusid'; $DATA = $id2; $PROBLEM = getMessage('BONUS_MAIL_PROBLEM'); - break; + $type = 'bonusid'; $DATA = $id2; $PROBLEM = getMessage('BONUS_MAIL_PROBLEM'); + break; - default: // Unknown type detected! - DEBUG_LOG(__FILE__, __LINE__, sprintf("Unknown mail type %s detected.", $type)); - break; + default: // Unknown type detected! + DEBUG_LOG(__FILE__, __LINE__, sprintf("Unknown mail type %s detected.", $type)); + break; } // Data found to this mail?