X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=mailid_top.php;h=4eb9719ca4d8f4108d0721d21faf73acf5fd2a4e;hb=f328172e16c619d30889fac830e873f2eeef857a;hp=57c541e9720ee4909758dab53976391f5167cd1f;hpb=09fd6484d1eaf735476270c33692f799bc0c9590;p=mailer.git diff --git a/mailid_top.php b/mailid_top.php index 57c541e972..4eb9719ca4 100644 --- a/mailid_top.php +++ b/mailid_top.php @@ -68,11 +68,11 @@ $code = '0'; $mode = ''; // Secure all data -if (isGetRequestParameterSet('userid')) $userId = bigintval(getRequestParameter('userid')); -if (isGetRequestParameterSet('mailid')) $mailId = bigintval(getRequestParameter('mailid')); -if (isGetRequestParameterSet('bonusid')) $bonusId = bigintval(getRequestParameter('bonusid')); -if (isGetRequestParameterSet('code')) $code = bigintval(getRequestParameter('code')); -if (isGetRequestParameterSet('mode')) $mode = getRequestParameter('mode'); +if (isGetRequestElementSet('userid')) $userId = bigintval(getRequestElement('userid')); +if (isGetRequestElementSet('mailid')) $mailId = bigintval(getRequestElement('mailid')); +if (isGetRequestElementSet('bonusid')) $bonusId = bigintval(getRequestElement('bonusid')); +if (isGetRequestElementSet('code')) $code = bigintval(getRequestElement('code')); +if (isGetRequestElementSet('mode')) $mode = getRequestElement('mode'); // 01 2 21 12 2 2 21 1 2210 if ((isValidUserId($userId)) && (($mailId > 0) || ($bonusId > 0)) && (!ifFatalErrorsDetected())) { @@ -84,12 +84,12 @@ if ((isValidUserId($userId)) && (($mailId > 0) || ($bonusId > 0)) && (!ifFatalEr // Maybe he wants to confirm an email? if ($mailId > 0) { - $result_main = SQL_QUERY_ESC("SELECT `id`, `link_type` FROM `{?_MYSQL_PREFIX?}_user_links` WHERE `stats_id`=%s AND `userid`=%s LIMIT 1", + $result_main = SQL_QUERY_ESC("SELECT `id`,`link_type` FROM `{?_MYSQL_PREFIX?}_user_links` WHERE `stats_id`=%s AND `userid`=%s LIMIT 1", array($mailId, $userId), __FILE__, __LINE__); $type = 'mailid'; $urlId = $mailId; } elseif ($bonusId > 0) { - $result_main = SQL_QUERY_ESC("SELECT `id`, `link_type` FROM `{?_MYSQL_PREFIX?}_user_links` WHERE `bonus_id`=%s AND `userid`=%s LIMIT 1", + $result_main = SQL_QUERY_ESC("SELECT `id`,`link_type` FROM `{?_MYSQL_PREFIX?}_user_links` WHERE `bonus_id`=%s AND `userid`=%s LIMIT 1", array($bonusId, $userId), __FILE__, __LINE__); $type = 'bonusid'; $urlId = $bonusId; @@ -105,12 +105,12 @@ if ((isValidUserId($userId)) && (($mailId > 0) || ($bonusId > 0)) && (!ifFatalEr // @TODO Rewrite this to a filter switch ($ltype) { case 'NORMAL': - $result_mailid = SQL_QUERY_ESC("SELECT `pool_id`, `userid`, `id` FROM `{?_MYSQL_PREFIX?}_user_stats` WHERE `id`=%s LIMIT 1", + $result_mailid = SQL_QUERY_ESC("SELECT `pool_id`,`userid`,`id` FROM `{?_MYSQL_PREFIX?}_user_stats` WHERE `id`=%s LIMIT 1", array($mailId), __FILE__, __LINE__); break; case 'BONUS': - $result_mailid = SQL_QUERY_ESC("SELECT `id`, `id`, `is_notify` FROM `{?_MYSQL_PREFIX?}_bonus` WHERE `id`=%s LIMIT 1", + $result_mailid = SQL_QUERY_ESC("SELECT `id`,`id`,`is_notify` FROM `{?_MYSQL_PREFIX?}_bonus` WHERE `id`=%s LIMIT 1", array($bonusId), __FILE__, __LINE__); break; @@ -125,10 +125,14 @@ if ((isValidUserId($userId)) && (($mailId > 0) || ($bonusId > 0)) && (!ifFatalEr list($pool, $sender, $notify) = SQL_FETCHROW($result_mailid); // Correct notification switch in non-bonus mails - if (($notify != 'Y') && ($notify != 'N')) $notify = 'N'; + if (($notify != 'Y') && ($notify != 'N')) { + $notify = 'N'; + } // END - if // Set sender to 0 when we have a bonus mail - if ($ltype == 'BONUS') $sender = '0'; + if ($ltype == 'BONUS') { + $sender = '0'; + } // END - if // Is the user id valid? if (fetchUserData($userId) === true) { @@ -154,7 +158,7 @@ if ((isValidUserId($userId)) && (($mailId > 0) || ($bonusId > 0)) && (!ifFatalEr break; case 'BONUS': - $result = SQL_QUERY_ESC("SELECT `time`, `points` FROM `{?_MYSQL_PREFIX?}_bonus` WHERE `id`=%s LIMIT 1", + $result = SQL_QUERY_ESC("SELECT `time`,`points` FROM `{?_MYSQL_PREFIX?}_bonus` WHERE `id`=%s LIMIT 1", array(bigintval($pool)), __FILE__, __LINE__); // Entry found? @@ -239,10 +243,10 @@ if ((isValidUserId($userId)) && (($mailId > 0) || ($bonusId > 0)) && (!ifFatalEr } // END - if // Insert stats record - //insertUserStatsRecord($userId, $type, $stats_data); + insertUserStatsRecord($userId, $type, $stats_data); // Right code entered? - if (bigintval(postRequestParameter('gfx_check')) == $realCode) { + if (bigintval(postRequestElement('gfx_check')) == $realCode) { // Set HTTP status to okay setHttpStatus('200 OK');