Previous fix fixed, a lot constants rewritten (unfinished)

[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 9d9fc055063be13c1e9bdb375c7965379edcf23d..59a1c99fa3d6c45f4edab75a510998519b6a793d 100644 (file)
--- a/inc/modules/admin/what-stats_mods.php
+++ b/inc/modules/admin/what-stats_mods.php
@@ -55,10 +55,10 @@ if (($_GET['mod'] == "index") || ($_GET['mod'] == "login"))
        }
 
        // 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 = SQL_QUERY_ESC("SELECT action, title, counter FROM `{!_MYSQL_PREFIX!}_%s_menu` WHERE `what` != '' AND `what` IS NOT NULL ORDER BY counter DESC",
                array($mod), __FILE__, __LINE__);
        $SW = 2; $OUT = "";
-       while(list($act, $title, $clicks) = SQL_FETCHROW($result))
+       while (list($act, $title, $clicks) = SQL_FETCHROW($result))
        {
                // Prepare array for the template
                $content = array(
@@ -81,19 +81,16 @@ if (($_GET['mod'] == "index") || ($_GET['mod'] == "login"))
 
        // Load final template
        LOAD_TEMPLATE("admin_mods_stats2");
-}
- else
-{
+} else {
        // Load module statics
-       $result = SQL_QUERY("SELECT module, title, clicks FROM `{!MYSQL_PREFIX!}_mod_reg` ORDER BY clicks DESC, module", __FILE__, __LINE__);
+       $result = SQL_QUERY("SELECT module, title, clicks FROM `{!_MYSQL_PREFIX!}_mod_reg` ORDER BY clicks DESC, module", __FILE__, __LINE__);
        $SW = 2; $OUT = "";
-       while(list($mod, $title, $clicks) = SQL_FETCHROW($result))
-       {
+       while (list($mod, $title, $clicks) = SQL_FETCHROW($result)) {
                if (empty($title)) $title = "---";
                if (($mod == "index") || ($mod == "login"))
                {
                        // Add link to detail statistics
-                       $mod = "<strong><a href=\"".URL."/modules.php?module=admin&amp;what=stats_mods&amp;mod=".$mod."\">".$mod."</a></strong>";
+                       $mod = "<strong><a href=\"{!URL!}/modules.php?module=admin&amp;what=stats_mods&amp;mod=".$mod."\">".$mod."</a></strong>";
                }
                // Prepare array for the template
                $content = array(