X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Fmodules%2Fmember%2Fwhat-stats.php;h=a5bd35b6e8f2c0c265fd80a9364bc6cf1af72727;hb=414570c5081d337bb6c28dcf521bd8bca02f69e7;hp=1b76b8fd27e08e045e5b481fef060f7151c9777f;hpb=cca98f57dff720b174d21d071cee8303462485d7;p=mailer.git diff --git a/inc/modules/member/what-stats.php b/inc/modules/member/what-stats.php index 1b76b8fd27..a5bd35b6e8 100644 --- a/inc/modules/member/what-stats.php +++ b/inc/modules/member/what-stats.php @@ -10,7 +10,12 @@ * -------------------------------------------------------------------- * * Kurzbeschreibung : Statistik ueber gesendete Mails * * -------------------------------------------------------------------- * - * * + * $Revision:: 856 $ * + * $Date:: 2009-03-06 20:24:32 +0100 (Fr, 06. Mär 2009) $ * + * $Tag:: 0.2.1-FINAL $ * + * $Author:: stelzi $ * + * Needs to be in all Files and every File needs "svn propset * + * svn:keywords Date Revision" (autoprobset!) at least!!!!!! * * -------------------------------------------------------------------- * * Copyright (c) 2003 - 2008 by Roland Haeder * * For more information visit: http://www.mxchange.org * @@ -47,7 +52,7 @@ $main_content = array(); // Load waiting/pending orders $result = SQL_QUERY_ESC("SELECT id, cat_id, payment_id, subject, url, timestamp, target_send, data_type, zip -FROM `{!MYSQL_PREFIX!}_pool` +FROM `{!_MYSQL_PREFIX!}_pool` WHERE sender=%s AND data_type != 'SEND' ORDER BY timestamp DESC", array($GLOBALS['userid']), __FILE__, __LINE__); @@ -85,7 +90,7 @@ if (SQL_NUMROWS($result) > 0) { $main_content['pool'] = LOAD_TEMPLATE("member_pool_table", true, $OUT); } else { // No mails in pool! - $main_content['pool'] = LOAD_TEMPLATE("admin_settings_saved", true, MEMBER_NO_MAILS_IN_POOL); + $main_content['pool'] = LOAD_TEMPLATE("admin_settings_saved", true, getMessage('MEMBER_NO_MAILS_IN_POOL')); } // Free result @@ -94,14 +99,14 @@ SQL_FREERESULT($result); // Load sent orders // 0 1 2 3 4 5 6 7 8 $result = SQL_QUERY_ESC("SELECT id, cat_id, payment_id, subject, url, timestamp_ordered, max_rec, timestamp_send, clicks -FROM `{!MYSQL_PREFIX!}_user_stats` +FROM `{!_MYSQL_PREFIX!}_user_stats` WHERE userid=%s ORDER BY timestamp_ordered DESC", array($GLOBALS['userid']), __FILE__, __LINE__); if (SQL_NUMROWS($result) > 0) { // Mail orders are in pool so we can display them - $SW = 2; $OUT = ""; + $OUT = ""; $SW = 2; while ($data = SQL_FETCHROW($result)) { // Prepare data for the template $content = array( @@ -126,7 +131,7 @@ if (SQL_NUMROWS($result) > 0) { $main_content['stats'] = LOAD_TEMPLATE("member_stats_table", true, $OUT); } else { // No mail orders fond - $main_content['stats'] = LOAD_TEMPLATE("admin_settings_saved", true, MEMBER_NO_MAILS_IN_STATS); + $main_content['stats'] = LOAD_TEMPLATE("admin_settings_saved", true, getMessage('MEMBER_NO_MAILS_IN_STATS')); } // Free result