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'));
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;
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;
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);