More language strings rewritten

[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 0f160adf3ff439095737084347c717624dd91ad4..59a1c99fa3d6c45f4edab75a510998519b6a793d 100644 (file)
--- a/inc/modules/admin/what-stats_mods.php
+++ b/inc/modules/admin/what-stats_mods.php
@@ -55,9 +55,10 @@ if (($_GET['mod'] == "index") || ($_GET['mod'] == "login"))
        }
 
        // Load module's detail statistic
-       $result = SQL_QUERY("SELECT action, title, counter FROM "._MYSQL_PREFIX."_".$mod."_menu WHERE what != '' ORDER BY counter DESC", __FILE__, __LINE__);
+       $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(
@@ -80,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(