Tons of rewrites (SQL queries), surfbar nearly finished (working: surfing with static...

[mailer.git] / inc / modules / admin / what-email_details.php

diff --git a/inc/modules/admin/what-email_details.php b/inc/modules/admin/what-email_details.php
index b27e002184e99170a43ad907edd051a68549693a..2a765f9b3a9e51704413552e869d92f09f2cff78 100644 (file)
--- a/inc/modules/admin/what-email_details.php
+++ b/inc/modules/admin/what-email_details.php
@@ -139,7 +139,7 @@ if (SQL_NUMROWS($result_list) > 0)
        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);
@@ -206,7 +206,7 @@ if (SQL_NUMROWS($result_list) > 0)
   </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 />
@@ -315,7 +315,7 @@ if ((EXT_IS_ACTIVE("bonus")) && ($WHO == _ALL))
   </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 />