while ($pool = SQL_FETCHROW($result_list))
{
// Unconfirmed mails and sent mails
- $result_uncon = SQL_QUERY_ESC("SELECT max_rec, clicks FROM "._MYSQL_PREFIX."_user_stats WHERE pool_id=%d LIMIT 1",
+ $result_uncon = SQL_QUERY_ESC("SELECT max_rec, clicks FROM "._MYSQL_PREFIX."_user_stats WHERE pool_id=%s LIMIT 1",
array(bigintval($pool[0])), __FILE__, __LINE__);
list($sent, $clicks) = SQL_FETCHROW($result_uncon);
SQL_FREERESULT($result_uncon);
</TD>
<TD align=\"center\" class=\"top right\">
".EMAIL_URL.":<br />
- <STRONG class=\"admin_misc\"><A href=\"".FRAMETESTER($pool[8])."\" target=\"_blank\">".EMAIL_URL_TEST."</A></STRONG>
+ <STRONG class=\"admin_misc\"><A href=\"".FRAMETESTER($pool[8])."\" target=\"_blank\">".ADMIN_TEST_URL."</A></STRONG>
</TD>
<TD align=\"center\" class=\"top\">
".EMAIL_TIMESTAMP.":<br />
</TD>
<TD align=\"center\" class=\"top bottom right\" width=\"23%\">
".EMAIL_SECONDS.":<br />
- <STRONG class=\"admin_misc\">".$bonus[5]." ".SECS."
+ <STRONG class=\"admin_misc\">".$bonus[5]." "._SECONDS."
</TD>
<TD align=\"center\" class=\"top bottom\">
".EMAIL_CATEGORY.":<br />
</TD>
<TD align=\"center\" class=\"top right\">
".EMAIL_URL.":<br />
- <STRONG class=\"admin_misc\"><A href=\"".FRAMETESTER($bonus[8])."\" target=\"_blank\">".EMAIL_URL_TEST."</A></STRONG>
+ <STRONG class=\"admin_misc\"><A href=\"".FRAMETESTER($bonus[8])."\" target=\"_blank\">".ADMIN_TEST_URL."</A></STRONG>
</TD>
<TD align=\"center\" class=\"top\">
".EMAIL_TIMESTAMP.":<br />