Huge script change, see http://forum.mxchange.org/topic-458.html for details:

[mailer.git] / inc / modules / member / what-stats.php

diff --git a/inc/modules/member/what-stats.php b/inc/modules/member/what-stats.php
index 110701133dc3abbf37be41670019474f0fec20c2..14178a2238bed72f8e46d0904c68accaa7d6cf1a 100644 (file)
--- a/inc/modules/member/what-stats.php
+++ b/inc/modules/member/what-stats.php
@@ -17,7 +17,7 @@
  * 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                           *
+ * Copyright (c) 2003 - 2009 by Roland Haeder                           *
  * For more information visit: http://www.mxchange.org                  *
  *                                                                      *
  * This program is free software; you can redistribute it and/or modify *
@@ -38,21 +38,20 @@
 
 // Some security stuff...
 if (!defined('__SECURITY')) {
-       $INC = substr(dirname(__FILE__), 0, strpos(dirname(__FILE__), '/inc') + 4) . '/security.php';
-       require($INC);
-} elseif (!IS_MEMBER()) {
-       redirectToUrl('modules.php?module=index');
+       die();
+} elseif (!isMember()) {
+       redirectToIndexMemberOnlyModule();
 }
 
 // Add description as navigation point
-ADD_DESCR('member', __FILE__);
+addMenuDescription('member', __FILE__);
 
 // Init output
 $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(getUserId()), __FILE__, __LINE__);
@@ -66,13 +65,14 @@ if (SQL_NUMROWS($result) > 0) {
                if (empty($data['zip'])) $data['zip'] =  '---';
 
                // Prepare content for output
+               // @TODO Rewrite in template subj->subject,stamp->timestamp,recs->target_send
                $content = array(
                        'sw'    => $SW,
                        'id'    => $data['id'],
                        'cat'   => getCategory($data['cat_id']),
                        'pay'   => getPaymentTitlePrice($data['payment_id']),
-                       'subj'  => COMPILE_CODE($data['subject']),
-                       'url'   => DEREFERER($data['url']),
+                       'subj'  => $data['subject'],
+                       'url'   => generateDerefererUrl($data['url']),
                        'stamp' => generateDateTime($data['timestamp'], '2'),
                        'recs'  => $data['target_send'],
                        'type'  => translatePoolType($data['data_type']),
@@ -80,17 +80,17 @@ if (SQL_NUMROWS($result) > 0) {
                );
 
                // Load template
-               $OUT .= LOAD_TEMPLATE("member_pool_row", true, $content);
+               $OUT .= loadTemplate('member_pool_row', true, $content);
 
                // Switch color
                $SW = 3 - $SW;
        } // END - if
 
        // Load main template
-       $main_content['pool'] = LOAD_TEMPLATE("member_pool_table", true, $OUT);
+       $main_content['pool'] = loadTemplate('member_pool_table', true, $OUT);
 } else {
        // No mails in pool!
-       $main_content['pool'] = LOAD_TEMPLATE('admin_settings_saved', true, getMessage('MEMBER_NO_MAILS_IN_POOL'));
+       $main_content['pool'] = loadTemplate('admin_settings_saved', true, getMessage('MEMBER_NO_MAILS_IN_POOL'));
 }
 
 // Free result
@@ -100,7 +100,7 @@ SQL_FREERESULT($result);
 $result = SQL_QUERY_ESC("SELECT
        `id`, `cat_id`, `payment_id`, `subject`, `url`, `timestamp_ordered`, `max_rec`, `timestamp_send`, `clicks`
 FROM
-       `{!_MYSQL_PREFIX!}_user_stats`
+       `{?_MYSQL_PREFIX?}_user_stats`
 WHERE
        `userid`=%s
 ORDER BY
@@ -112,36 +112,36 @@ if (SQL_NUMROWS($result) > 0) {
        $OUT = ''; $SW = 2;
        while ($content = SQL_FETCHARRAY($result)) {
                // Prepare data for the template
+               // @TODO Rewrite in template: stamp->timestamp_ordered,recs->max_rec,clix->clicks,perc->percents
                $content = array(
                        'sw'    => $SW,
                        'cat'   => getCategory($content['cat_id']),
                        'pay'   => getPaymentTitlePrice($content['payment_id']),
-                       'subj'  => COMPILE_CODE($content['subject']),
-                       'url'   => DEREFERER($content['url']),
+                       'url'   => generateDerefererUrl($content['url']),
                        'stamp' => generateDateTime($content['timestamp_ordered'], '2'),
                        'recs'  => $content['max_rec'],
                        'sent'  => generateDateTime($content['timestamp_send'], '2'),
                        'clix'  => $content['clicks'],
-                       'perc'  => COMPILE_CODE($content['clicks'] / $content['max_rec'] * 100)."%",
+                       'perc'  => ($content['clicks'] / $content['max_rec'] * 100)."%",
                );
 
                // Load row template and switch colors
-               $OUT .= LOAD_TEMPLATE('member_stats_row', true, $content);
+               $OUT .= loadTemplate('member_stats_row', true, $content);
                $SW = 3 - $SW;
        }
 
        // Load main template
-       $main_content['stats'] = LOAD_TEMPLATE('member_stats_table', true, $OUT);
+       $main_content['stats'] = loadTemplate('member_stats_table', true, $OUT);
 } else {
        // No mail orders fond
-       $main_content['stats'] = LOAD_TEMPLATE('admin_settings_saved', true, getMessage('MEMBER_NO_MAILS_IN_STATS'));
+       $main_content['stats'] = loadTemplate('admin_settings_saved', true, getMessage('MEMBER_NO_MAILS_IN_STATS'));
 }
 
 // Free result
 SQL_FREERESULT($result);
 
 // Load main template
-LOAD_TEMPLATE('member_stats_pool', false, $main_content);
+loadTemplate('member_stats_pool', false, $main_content);
 
-//
+// [EOF]
 ?>