Updated copyright year.

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

diff --git a/inc/modules/admin/what-stats_mods.php b/inc/modules/admin/what-stats_mods.php
index 6d4d26cc760b58395f831aa8e09233fcbce00b04..ec316e12ce4077800d13fa998d4c3ddc2c6cb85b 100644 (file)
--- a/inc/modules/admin/what-stats_mods.php
+++ b/inc/modules/admin/what-stats_mods.php
@@ -16,7 +16,7 @@
  * $Author::                                                          $ *
  * -------------------------------------------------------------------- *
  * Copyright (c) 2003 - 2009 by Roland Haeder                           *
- * Copyright (c) 2009 - 2012 by Mailer Developer Team                   *
+ * Copyright (c) 2009 - 2016 by Mailer Developer Team                   *
  * For more information visit: http://mxchange.org                      *
  *                                                                      *
  * This program is free software; you can redistribute it and/or modify *
@@ -49,38 +49,38 @@ if ((getRequestElement('mod') == 'index') || (getRequestElement('mod') == 'login
        $mod = mapModuleToTable(getRequestElement('mod'));
 
        // Load module's detail statistic
-       $result = SQL_QUERY_ESC("SELECT `action`,`title`,`counter` FROM `{?_MYSQL_PREFIX?}_%s_menu` WHERE `what` != '' AND `what` IS NOT NULL ORDER BY `counter` DESC",
+       $result = sqlQueryEscaped("SELECT `action`, `title`, `counter` FROM `{?_MYSQL_PREFIX?}_%s_menu` WHERE `what` != '' AND `what` IS NOT NULL ORDER BY `counter` DESC, `action` ASC, `sort` ASC",
                array($mod), __FILE__, __LINE__);
        $OUT = '';
-       while ($content = SQL_FETCHARRAY($result)) {
+       while ($content = sqlFetchArray($result)) {
                // Load row template
-               $OUT .= loadTemplate('admin_list_mods_stats2_row', true, $content);
+               $OUT .= loadTemplate('admin_list_mods_stats2_row', TRUE, $content);
        } // END - while
 
        // Free memory
-       SQL_FREERESULT($result);
+       sqlFreeResult($result);
 
        // Load final template
-       loadTemplate('admin_list_mods_stats2', false, $OUT);
+       loadTemplate('admin_list_mods_stats2', FALSE, $OUT);
 } else {
        // Load module statics
-       $result = SQL_QUERY("SELECT `module`,`title`,`clicks` FROM `{?_MYSQL_PREFIX?}_mod_reg` ORDER BY `clicks` DESC,`module` ASC", __FILE__, __LINE__);
+       $result = sqlQuery('SELECT `module`, `title`, `clicks` FROM `{?_MYSQL_PREFIX?}_mod_reg` ORDER BY `clicks` DESC, `module` ASC', __FILE__, __LINE__);
        $OUT = '';
-       while ($content = SQL_FETCHARRAY($result)) {
+       while ($content = sqlFetchArray($result)) {
                if (($content['module'] == 'index') || ($content['module'] == 'login')) {
                        // Add link to detail statistics
                        $content['module'] = '<a href="{%url=modules.php?module=admin&amp;what=stats_mods&amp;mod=' . $content['module'] . '%}">' . $content['module'] . '</a>';
                } // END - if
 
                // Load row template
-               $OUT .= loadTemplate('admin_list_mods_stats_row', true, $content);
+               $OUT .= loadTemplate('admin_list_mods_stats_row', TRUE, $content);
        } // END - while
 
        // Free memory
-       SQL_FREERESULT($result);
+       sqlFreeResult($result);
 
        // Load final template
-       loadTemplate('admin_list_mods_stats', false, $OUT);
+       loadTemplate('admin_list_mods_stats', FALSE, $OUT);
 }
 
 // [EOF]