X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=mailid.php;h=691017aa90998c1c90a94420edde9a6509fdf690;hp=f93838a1bae4ddec241f994bad9fd01b09d195a4;hb=00283a82c807a00d66bd5811d41992bb3b059996;hpb=76740e48546bb3fdb9fca65d8d205765f2bd4d68 diff --git a/mailid.php b/mailid.php index f93838a1ba..691017aa90 100644 --- a/mailid.php +++ b/mailid.php @@ -57,9 +57,9 @@ setHttpStatus('404 NOT FOUND'); redirectOnUninstalledExtension('mailid'); // Init -$userId = '0'; -$bonusId = '0'; -$mailId = '0'; +$userId = '0'; +$bonusId = '0'; +$mailId = '0'; // Secure all data if (isGetRequestParameterSet('userid')) $userId = bigintval(getRequestParameter('userid')); @@ -97,7 +97,7 @@ if ((isValidUserId($userId)) && (($mailId > 0) || ($bonusId > 0)) && (!ifFatalEr switch ($ltype) { case 'NORMAL': // Is the stats id valid? - $result = SQL_QUERY_ESC("SELECT `pool_id`, `url`, `subject` FROM `{?_MYSQL_PREFIX?}_user_stats` WHERE `id`=%s LIMIT 1", + $result = SQL_QUERY_ESC("SELECT `pool_id`,`url`,`subject` FROM `{?_MYSQL_PREFIX?}_user_stats` WHERE `id`=%s LIMIT 1", array($mailId), __FILE__, __LINE__); break; @@ -106,7 +106,7 @@ if ((isValidUserId($userId)) && (($mailId > 0) || ($bonusId > 0)) && (!ifFatalEr redirectOnUninstalledExtension('bonus'); // Bonus-Mails - $result = SQL_QUERY_ESC("SELECT `id`, `url`, `subject` FROM `{?_MYSQL_PREFIX?}_bonus` WHERE `id`=%s LIMIT 1", + $result = SQL_QUERY_ESC("SELECT `id`,`url`,`subject` FROM `{?_MYSQL_PREFIX?}_bonus` WHERE `id`=%s LIMIT 1", array($bonusId), __FILE__, __LINE__); break; @@ -153,7 +153,7 @@ if ((isValidUserId($userId)) && (($mailId > 0) || ($bonusId > 0)) && (!ifFatalEr break; case 'BONUS': - $result = SQL_QUERY_ESC("SELECT `points`, `time` FROM `{?_MYSQL_PREFIX?}_bonus` WHERE `id`=%s LIMIT 1", + $result = SQL_QUERY_ESC("SELECT `points`,`time` FROM `{?_MYSQL_PREFIX?}_bonus` WHERE `id`=%s LIMIT 1", array($bonusId), __FILE__, __LINE__); if (SQL_NUMROWS($result) == 1) { list($points, $time) = SQL_FETCHROW($result);