X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Fmodules%2Fmember%2Fwhat-unconfirmed.php;h=88d8408cda57da357bb2b3c033d4f4c7f9708a76;hb=f6014bce7255a915872f2f463247440c0d58f9a9;hp=af971c9247ccee4f912790b756a10121bcf05c03;hpb=acf8ab4b3e330097ad47bd28bc701cf6ccce63fb;p=mailer.git diff --git a/inc/modules/member/what-unconfirmed.php b/inc/modules/member/what-unconfirmed.php index af971c9247..88d8408cda 100644 --- a/inc/modules/member/what-unconfirmed.php +++ b/inc/modules/member/what-unconfirmed.php @@ -17,7 +17,7 @@ * -------------------------------------------------------------------- * * Copyright (c) 2003 - 2009 by Roland Haeder * * Copyright (c) 2009 - 2011 by Mailer Developer Team * - * For more information visit: http://www.mxchange.org * + * For more information visit: http://mxchange.org * * * * This program is free software; you can redistribute it and/or modify * * it under the terms of the GNU General Public License as published by * @@ -52,16 +52,16 @@ if (!isExtensionActive('mailid')) { } // END - if // Shall we display a mail? -if ((isGetRequestParameterSet('bonusid')) && (isExtensionActive('bonus'))) { +if ((isGetRequestElementSet('bonusid')) && (isExtensionActive('bonus'))) { // Display bonus mail by loading it's full data $result_data = SQL_QUERY_ESC("SELECT - `id`, `subject`, `timestamp`, `cat_id`, `points`, `text`, `is_notify`, `data_type`, `time`, `url` + `id`,`subject`,`timestamp`,`cat_id`,`points`,`text`,`is_notify`,`data_type`,`time`,`url` FROM `{?_MYSQL_PREFIX?}_bonus` WHERE `id`=%s LIMIT 1", - array(bigintval(getRequestParameter('bonusid'))), __FILE__, __LINE__); + array(bigintval(getRequestElement('bonusid'))), __FILE__, __LINE__); // Load data $content = SQL_FETCHARRAY($result_data); @@ -91,7 +91,7 @@ LIMIT 1", // Free result SQL_FREERESULT($result_data); -} elseif (isGetRequestParameterSet('mailid')) { +} elseif (isGetRequestElementSet('mailid')) { // Display regular member mail by loading its full data $result_data = SQL_QUERY_ESC("SELECT s.id, s.subject, p.text, s.timestamp_ordered AS `timestamp`, @@ -109,7 +109,7 @@ ON WHERE s.id=%s LIMIT 1", - array(bigintval(getRequestParameter('mailid'))), __FILE__, __LINE__); + array(bigintval(getRequestElement('mailid'))), __FILE__, __LINE__); // Load data $content = SQL_FETCHARRAY($result_data); @@ -143,11 +143,11 @@ LIMIT 1", if (isExtensionActive('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", + $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(getMemberId()), __FILE__, __LINE__); } else { // Don't load bonus id if ext-bonus is not installed - $result = SQL_QUERY_ESC("SELECT `stats_id`, `link_type` FROM `{?_MYSQL_PREFIX?}_user_links` WHERE `userid`=%s ORDER BY `stats_id` DESC", + $result = SQL_QUERY_ESC("SELECT `stats_id`,`link_type` FROM `{?_MYSQL_PREFIX?}_user_links` WHERE `userid`=%s ORDER BY `stats_id` DESC", array(getMemberId()), __FILE__, __LINE__); } @@ -186,7 +186,7 @@ LIMIT 1", break; case 'BONUS': - $result_data = SQL_QUERY_ESC("SELECT `subject`, `timestamp`, `cat_id`, `points`, 0 FROM `{?_MYSQL_PREFIX?}_bonus` WHERE `id`=%s LIMIT 1", + $result_data = SQL_QUERY_ESC("SELECT `subject`,`timestamp`,`cat_id`,`points`, 0 FROM `{?_MYSQL_PREFIX?}_bonus` WHERE `id`=%s LIMIT 1", array(bigintval($row['bonus_id'])), __FILE__, __LINE__); $row['link_type'] = 'bonusid'; $data = $row['bonus_id'];