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

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

diff --git a/inc/modules/admin/what-surfbar_stats.php b/inc/modules/admin/what-surfbar_stats.php
index 7db1aaf511aef397877bd8471ebd0ae3d0d15fd2..6818b12e489d448bab3543857e272d4a27f88ba8 100644 (file)
--- a/inc/modules/admin/what-surfbar_stats.php
+++ b/inc/modules/admin/what-surfbar_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 *
@@ -37,22 +37,21 @@
  ************************************************************************/
 
 // Some security stuff...
-if ((!defined('__SECURITY')) || (!IS_ADMIN())) {
-       $INC = substr(dirname(__FILE__), 0, strpos(dirname(__FILE__), '/inc') + 4) . '/security.php';
-       require($INC);
+if ((!defined('__SECURITY')) || (!isAdmin())) {
+       die();
 }
 
 // Add description as navigation point
-ADD_DESCR('admin', __FILE__);
+addMenuDescription('admin', __FILE__);
 
 // Is the 'url_id' set?
-if (REQUEST_ISSET_GET(('url_id'))) {
+if (isGetRequestElementSet(('url_id'))) {
        // Generate general statistics
-       $result = SQL_QUERY_ESC("SELECT `userid`,`count` AS `total_visits`, UNIX_TIMESTAMP(`last_online`) AS `last_online`
-FROM `{!_MYSQL_PREFIX!}_surfbar_stats`
+       $result = SQL_QUERY_ESC("SELECT `userid`,`count` AS `total_visits`, UNIX_TIMESTAMP(`last_surfed`) AS `last_surfed`
+FROM `{?_MYSQL_PREFIX?}_surfbar_stats`
 WHERE `url_id`=%s
 ORDER BY `userid` ASC",
-       array(bigintval(REQUEST_GET('url_id'))), __FILE__, __LINE__);
+       array(bigintval(getRequestElement('url_id'))), __FILE__, __LINE__);
 
        // Entries found?
        if (SQL_NUMROWS($result) > 0) {
@@ -65,11 +64,11 @@ ORDER BY `userid` ASC",
                        // "Translate" some data
                        $content['userid']       = generateUserProfileLink($content['userid']);
                        $content['total_visits'] = translateComma($content['total_visits']);
-                       $content['last_online']  = generateDateTime($content['last_online'], '2');
+                       $content['last_surfed']  = generateDateTime($content['last_surfed'], '2');
                        $content['sw']           = $SW;
 
                        // Load row template
-                       $OUT .= LOAD_TEMPLATE("admin_surfbar_url_stats_row", true, $content);
+                       $OUT .= loadTemplate('admin_surfbar_url_stats_row', true, $content);
                        $cnt++; $SW = 3 - $SW;
                } // END - while
 
@@ -82,17 +81,21 @@ ORDER BY `userid` ASC",
 
 
                // Load main template
-               LOAD_TEMPLATE("admin_surfbar_url_stats", false, $content);
+               loadTemplate('admin_surfbar_url_stats', false, $content);
        } else {
                // No statistics so far
-               LOAD_TEMPLATE('admin_settings_saved', false, getMessage('ADMIN_SURFBAR_NO_URL_STATS'));
+               loadTemplate('admin_settings_saved', false, getMessage('ADMIN_SURFBAR_NO_URL_STATS'));
        }
 } else {
        // Generate general statistics
-       $result = SQL_QUERY("SELECT `userid`, COUNT(`url_id`) AS `visited_urls`, SUM(`count`) AS `total_visits`
-FROM `{!_MYSQL_PREFIX!}_surfbar_stats`
-GROUP BY `userid`
-ORDER BY `userid` ASC", __FILE__, __LINE__);
+       $result = SQL_QUERY("SELECT
+       `userid`, COUNT(`url_id`) AS `visited_urls`, SUM(`count`) AS `total_visits`
+FROM
+       `{?_MYSQL_PREFIX?}_surfbar_stats`
+GROUP BY
+       `userid`
+ORDER BY
+       `userid` ASC", __FILE__, __LINE__);
 
        // Entries found?
        if (SQL_NUMROWS($result) > 0) {
@@ -110,7 +113,7 @@ ORDER BY `userid` ASC", __FILE__, __LINE__);
                        $content['sw']           = $SW;
 
                        // Load row template
-                       $OUT .= LOAD_TEMPLATE("admin_surfbar_stats_row", true, $content);
+                       $OUT .= loadTemplate('admin_surfbar_stats_row', true, $content);
                        $SW = 3 - $SW;
                } // END - while
 
@@ -123,10 +126,10 @@ ORDER BY `userid` ASC", __FILE__, __LINE__);
 
 
                // Load main template
-               LOAD_TEMPLATE("admin_surfbar_stats", false, $content);
+               loadTemplate('admin_surfbar_stats', false, $content);
        } else {
                // No statistics so far
-               LOAD_TEMPLATE('admin_settings_saved', false, getMessage('ADMIN_SURFBAR_NO_STATS'));
+               loadTemplate('admin_settings_saved', false, getMessage('ADMIN_SURFBAR_NO_STATS'));
        }
 }