X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=inc%2Fmodules%2Fmember%2Fwhat-stats.php;h=46afe0b1ef409f01b730eb8ba3ba827a42c4886c;hp=c31177ee1cbd454ccaa2882a384678a30137cc0f;hb=596c8ab32594401ca84abfbfe35513ddfff31bec;hpb=63f159414369b5ea19a8ca75d8cd8033c45d8341 diff --git a/inc/modules/member/what-stats.php b/inc/modules/member/what-stats.php index c31177ee1c..46afe0b1ef 100644 --- a/inc/modules/member/what-stats.php +++ b/inc/modules/member/what-stats.php @@ -50,7 +50,15 @@ $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` + `id`, + `cat_id`, + `payment_id`, + `subject`, + `url`, + `timestamp`, + `target_send`, + `data_type`, + `zip` FROM `{?_MYSQL_PREFIX?}_pool` WHERE @@ -69,28 +77,36 @@ if (!SQL_HASZERONUMS($result)) { $content['timestamp'] = generateDateTime($content['timestamp'], '2'); // Load template - $OUT .= loadTemplate('member_pool_row', true, $content); + $OUT .= loadTemplate('member_pool_row', TRUE, $content); } // END - if // Load main template - $main_content['pool'] = loadTemplate('member_pool_table', true, $OUT); + $main_content['pool'] = loadTemplate('member_pool_table', TRUE, $OUT); } else { // No mails in pool! - $main_content['pool'] = displayMessage('{--MEMBER_NO_MAILS_IN_POOL--}', true); + $main_content['pool'] = displayMessage('{--MEMBER_NO_MAILS_IN_POOL--}', TRUE); } // Free result SQL_FREERESULT($result); // Load sent orders -$result = SQL_QUERY_ESC("SELECT - `id`,`cat_id`,`payment_id`,`subject`,`url`,`timestamp_ordered`,`max_rec`,`timestamp_send`,`clicks` +$result = SQL_QUERY_ESC('SELECT + `id`, + `cat_id`, + `payment_id`, + `subject`, + `url`, + `timestamp_ordered`, + `max_rec`, + `timestamp_send`, + `clicks` FROM `{?_MYSQL_PREFIX?}_user_stats` WHERE `userid`=%s ORDER BY - `timestamp_ordered` DESC", + `timestamp_ordered` DESC', array(getMemberId()), __FILE__, __LINE__); if (!SQL_HASZERONUMS($result)) { @@ -110,21 +126,21 @@ if (!SQL_HASZERONUMS($result)) { } // END - if // Load row template and switch colors - $OUT .= loadTemplate('member_stats_row', true, $content); + $OUT .= loadTemplate('member_stats_row', TRUE, $content); } // END - while // Load main template - $main_content['stats'] = loadTemplate('member_stats_table', true, $OUT); + $main_content['stats'] = loadTemplate('member_stats_table', TRUE, $OUT); } else { // No mail orders fond - $main_content['stats'] = displayMessage('{--MEMBER_NO_MAILS_IN_STATS--}', true); + $main_content['stats'] = displayMessage('{--MEMBER_NO_MAILS_IN_STATS--}', TRUE); } // Free result SQL_FREERESULT($result); // Load main template -loadTemplate('member_stats_pool', false, $main_content); +loadTemplate('member_stats_pool', FALSE, $main_content); // [EOF] ?>