X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Fmodules%2Fadmin%2Fwhat-surfbar_stats.php;h=7db1aaf511aef397877bd8471ebd0ae3d0d15fd2;hb=9d3e47c8ab6ff3ab7efca2a968d66a5ccf76728d;hp=ea53ffdfe925ff44d8e18e694cfe2982a549ee7e;hpb=cca98f57dff720b174d21d071cee8303462485d7;p=mailer.git diff --git a/inc/modules/admin/what-surfbar_stats.php b/inc/modules/admin/what-surfbar_stats.php index ea53ffdfe9..7db1aaf511 100644 --- a/inc/modules/admin/what-surfbar_stats.php +++ b/inc/modules/admin/what-surfbar_stats.php @@ -10,7 +10,12 @@ * -------------------------------------------------------------------- * * Kurzbeschreibung : URL-Statistiken fuer die Surfbar * * -------------------------------------------------------------------- * - * * + * $Revision:: $ * + * $Date:: $ * + * $Tag:: 0.2.1-FINAL $ * + * $Author:: $ * + * 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 * @@ -33,34 +38,34 @@ // Some security stuff... if ((!defined('__SECURITY')) || (!IS_ADMIN())) { - $INC = substr(dirname(__FILE__), 0, strpos(dirname(__FILE__), "/inc") + 4) . "/security.php"; + $INC = substr(dirname(__FILE__), 0, strpos(dirname(__FILE__), '/inc') + 4) . '/security.php'; require($INC); } // Add description as navigation point -ADD_DESCR("admin", __FILE__); +ADD_DESCR('admin', __FILE__); // Is the 'url_id' set? -if (isset($_GET['url_id'])) { +if (REQUEST_ISSET_GET(('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_online`) AS `last_online` +FROM `{!_MYSQL_PREFIX!}_surfbar_stats` WHERE `url_id`=%s ORDER BY `userid` ASC", - array(bigintval($_GET['url_id'])), __FILE__, __LINE__); + array(bigintval(REQUEST_GET('url_id'))), __FILE__, __LINE__); // Entries found? if (SQL_NUMROWS($result) > 0) { // Get all rows - $OUT = ""; $SW = 2; $cnt = 0; $visits = 0; + $OUT = ''; $SW = 2; $cnt = 0; $visits = 0; while ($content = SQL_FETCHARRAY($result)) { // Count totals $visits += $content['total_visits']; // "Translate" some data - $content['userid'] = ADMIN_USER_PROFILE_LINK($content['userid']); - $content['total_visits'] = TRANSLATE_COMMA($content['total_visits']); - $content['last_online'] = MAKE_DATETIME($content['last_online'], "2"); + $content['userid'] = generateUserProfileLink($content['userid']); + $content['total_visits'] = translateComma($content['total_visits']); + $content['last_online'] = generateDateTime($content['last_online'], '2'); $content['sw'] = $SW; // Load row template @@ -80,28 +85,28 @@ ORDER BY `userid` ASC", LOAD_TEMPLATE("admin_surfbar_url_stats", false, $content); } else { // No statistics so far - LOAD_TEMPLATE("admin_settings_saved", false, ADMIN_SURFBAR_NO_URL_STATS); + LOAD_TEMPLATE('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` +FROM `{!_MYSQL_PREFIX!}_surfbar_stats` GROUP BY `userid` ORDER BY `userid` ASC", __FILE__, __LINE__); // Entries found? if (SQL_NUMROWS($result) > 0) { // Get all rows - $OUT = ""; $SW = 2; $urls = 0; $visits = 0; + $OUT = ''; $SW = 2; $urls = 0; $visits = 0; while ($content = SQL_FETCHARRAY($result)) { // Count totals $urls += $content['visited_urls']; $visits += $content['total_visits']; // "Translate" some data - $content['userid'] = ADMIN_USER_PROFILE_LINK($content['userid']); - $content['visited_urls'] = TRANSLATE_COMMA($content['visited_urls']); - $content['total_visits'] = TRANSLATE_COMMA($content['total_visits']); + $content['userid'] = generateUserProfileLink($content['userid']); + $content['visited_urls'] = translateComma($content['visited_urls']); + $content['total_visits'] = translateComma($content['total_visits']); $content['sw'] = $SW; // Load row template @@ -121,7 +126,7 @@ ORDER BY `userid` ASC", __FILE__, __LINE__); LOAD_TEMPLATE("admin_surfbar_stats", false, $content); } else { // No statistics so far - LOAD_TEMPLATE("admin_settings_saved", false, ADMIN_SURFBAR_NO_STATS); + LOAD_TEMPLATE('admin_settings_saved', false, getMessage('ADMIN_SURFBAR_NO_STATS')); } }