// Set offset an current page to default values
if (empty($_GET['page'])) $_GET['page'] = "1";
-if (empty($_GET['offset'])) $_GET['offset'] = $CONFIG['mails_page'];
+if (empty($_GET['offset'])) $_GET['offset'] = $_CONFIG['mails_page'];
// Add limitation to SQL string
if (empty($_GET['mid']))
if ((!empty($SQL2)) && ($WHO == _ALL)) $result_bonus = SQL_QUERY($SQL2, __FILE__, __LINE__);
// Calculate pages
-$PAGES = round(SQL_NUMROWS($result_normal) / $CONFIG['mails_page'] + 0.3);
+$PAGES = round(SQL_NUMROWS($result_normal) / $_CONFIG['mails_page'] + 0.3);
SQL_FREERESULT($result_normal);
$MAIL = false;
</TR>");
// Add navigation (with change box and colspan=3)
- if ($PAGES > 1) ADD_EMAIL_NAV($PAGES, $CONFIG['mails_page'], false, "3");
+ if ($PAGES > 1) ADD_EMAIL_NAV($PAGES, $_CONFIG['mails_page'], false, "3");
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 />
SQL_FREERESULT($result_list);
// Add navigation (without change box but with colspan=3)
- if ($PAGES > 1) ADD_EMAIL_NAV($PAGES, $CONFIG['mails_page'], false, "3");
+ if ($PAGES > 1) ADD_EMAIL_NAV($PAGES, $_CONFIG['mails_page'], false, "3");
// Output footer
OUTPUT_HTML("</TABLE>
</TD>
</TR>");
// Calculate pages
- $PAGES = round(SQL_NUMROWS($result_bonus) / $CONFIG['mails_page'] + 0.5);
+ $PAGES = round(SQL_NUMROWS($result_bonus) / $_CONFIG['mails_page'] + 0.5);
// Add navigation (with change box and colspan=3)
- if ($PAGES > 1) ADD_EMAIL_NAV($PAGES, $CONFIG['mails_page'], true, "3");
+ if ($PAGES > 1) ADD_EMAIL_NAV($PAGES, $_CONFIG['mails_page'], true, "3");
// List emails
while ($bonus = SQL_FETCHROW($result_bonus))
</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 />
}
// Add navigation (without change box but with colspan=3)
- if ($PAGES > 1) ADD_EMAIL_NAV($PAGES, $CONFIG['mails_page'], false, "3");
+ if ($PAGES > 1) ADD_EMAIL_NAV($PAGES, $_CONFIG['mails_page'], false, "3");
// Output footer
OUTPUT_HTML("</TABLE>