// 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);
// List mail
OUTPUT_HTML("<TR>
<TD class=\"bottom top2 right\" width=\"23%\" align=\"center\">
- ".EMAIL_SENDER.":<BR>
+ ".EMAIL_SENDER.":<br />
<STRONG class=\"admin_misc\">".ADMIN_USER_PROFILE_LINK($pool[1])."</STRONG>
</TD>
<TD class=\"bottom top2 right\" width=\"23%\" align=\"center\">
- ".EMAIL_SUBJECT.":<BR>
+ ".EMAIL_SUBJECT.":<br />
<STRONG class=\"admin_misc\">".COMPILE_CODE($pool[2])."</STRONG>
</TD>
<TD class=\"bottom top2\" width=\"54%\" align=\"center\">
- ".EMAIL_TEXT.":<BR>
+ ".EMAIL_TEXT.":<br />
<STRONG class=\"admin_misc\">".COMPILE_CODE($pool[3])."</STRONG>
</TD>
</TR>
<TR><TD height=\"5\" colspan=\"3\"></TD></TR>
<TR>
<TD colspan=\"2\" align=\"center\" class=\"top bottom right\">
- ".EMAIL_PAYMENT.":<BR>
+ ".EMAIL_PAYMENT.":<br />
<STRONG class=\"admin_misc\">".GET_PAYMENT($pool[5])."
</TD>
<TD align=\"center\" class=\"top bottom\">
- ".EMAIL_CATEGORY.":<BR>
+ ".EMAIL_CATEGORY.":<br />
<STRONG class=\"admin_misc\">".GET_CATEGORY($pool[10])."
</TD>
</TR>
<TR><TD height=\"5\" colspan=\"3\"></TD></TR>
<TR>
<TD align=\"center\" class=\"top bottom right\">
- ".EMAIL_RECEIVERS.":<BR>
+ ".EMAIL_RECEIVERS.":<br />
<STRONG class=\"admin_misc\">".$sent."</STRONG> (".EMAIL_RUIDS.": <STRONG class=\"admin_misc\">".str_replace(";", ", ", $pool[4])."</STRONG>)
</TD>
<TD align=\"center\" class=\"top bottom right\">
- ".USERS_LINKS.":<BR>
+ ".USERS_LINKS.":<br />
<STRONG class=\"admin_misc\">".$unconfirmed."</STRONG>
</TD>
<TD align=\"center\" class=\"top bottom\">
- ".EMAIL_POOL_TYPE.":<BR>
+ ".EMAIL_POOL_TYPE.":<br />
<STRONG class=\"admin_misc\">".GET_POOL_TYPE($pool[6])."</STRONG>
</TD>
</TR>
<TR><TD height=\"5\" colspan=\"3\"></TD></TR>
<TR>
<TD align=\"center\" class=\"top right\">
- ".EMAIL_TSEND.":<BR>
+ ".EMAIL_TSEND.":<br />
<STRONG class=\"admin_misc\">".$pool[9]."</STRONG>
</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>
+ ".EMAIL_URL.":<br />
+ <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>
+ ".EMAIL_TIMESTAMP.":<br />
<STRONG class=\"admin_misc\">".MAKE_DATETIME($pool[7], "0")."</STRONG>
</TD>
</TR>
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>
if ((EXT_IS_ACTIVE("bonus")) && ($WHO == _ALL))
{
// Check only if bonus extension is active
- if (SQL_NUMROWS($result_bonus) > 0) OUTPUT_HTML("<BR><BR>");
+ if (SQL_NUMROWS($result_bonus) > 0) OUTPUT_HTML("<br /><br />");
}
}
</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))
OUTPUT_HTML("<TR>
<TD class=\"bottom top2 right\" colspan=\"2\" width=\"46%\" align=\"center\">
- ".EMAIL_SUBJECT.":<BR>
+ ".EMAIL_SUBJECT.":<br />
<STRONG class=\"admin_misc\">".$bonus[1]."</STRONG>
</TD>
<TD class=\"bottom top2\" width=\"54%\" align=\"center\">
- ".EMAIL_TEXT.":<BR>
+ ".EMAIL_TEXT.":<br />
<STRONG class=\"admin_misc\">".$bonus[2]."</STRONG>
</TD>
</TR>
<TR><TD height=\"5\" colspan=\"3\"></TD></TR>
<TR>
<TD align=\"center\" class=\"top bottom right\" width=\"23%\">
- ".EMAIL_POINTS.":<BR>
+ ".EMAIL_POINTS.":<br />
<STRONG class=\"admin_misc\">".$bonus[4]." ".POINTS."
</TD>
<TD align=\"center\" class=\"top bottom right\" width=\"23%\">
- ".EMAIL_SECONDS.":<BR>
- <STRONG class=\"admin_misc\">".$bonus[5]." ".SECS."
+ ".EMAIL_SECONDS.":<br />
+ <STRONG class=\"admin_misc\">".$bonus[5]." "._SECONDS."
</TD>
<TD align=\"center\" class=\"top bottom\">
- ".EMAIL_CATEGORY.":<BR>
+ ".EMAIL_CATEGORY.":<br />
<STRONG class=\"admin_misc\">".GET_CATEGORY($bonus[9])."
</TD>
</TR>
<TR><TD height=\"5\" colspan=\"3\"></TD></TR>
<TR>
<TD align=\"center\" class=\"top bottom right\">
- ".EMAIL_RECEIVERS.":<BR>
+ ".EMAIL_RECEIVERS.":<br />
<STRONG class=\"admin_misc\">".$bonus[11]."</STRONG> (".EMAIL_RUIDS.": <STRONG class=\"admin_misc\">".str_replace(";", ", ", $bonus[3])."</STRONG>)
</TD>
<TD align=\"center\" class=\"top bottom right\">
- ".USERS_LINKS.":<BR>
+ ".USERS_LINKS.":<br />
<STRONG class=\"admin_misc\">".$unconfirmed."</STRONG>
</TD>
<TD align=\"center\" class=\"top bottom\">
- ".EMAIL_POOL_TYPE.":<BR>
+ ".EMAIL_POOL_TYPE.":<br />
<STRONG class=\"admin_misc\">".GET_POOL_TYPE($bonus[6])."</STRONG>
</TD>
</TR>
<TR><TD height=\"5\" colspan=\"3\"></TD></TR>
<TR>
<TD align=\"center\" class=\"top right\">
- ".EMAIL_TSEND.":<BR>
+ ".EMAIL_TSEND.":<br />
<STRONG class=\"admin_misc\">".$bonus[10]."</STRONG>
</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>
+ ".EMAIL_URL.":<br />
+ <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>
+ ".EMAIL_TIMESTAMP.":<br />
<STRONG class=\"admin_misc\">".MAKE_DATETIME($bonus[7], "0")."</STRONG>
</TD>
</TR>
}
// 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>