X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Fmodules%2Fadmin%2Fwhat-stats_mods.php;h=59a1c99fa3d6c45f4edab75a510998519b6a793d;hb=77cdaff2afb97ed32985ced906a3a95ee078c2ef;hp=fc69db6d3e89a7710d8a5315ce00a9ba55602876;hpb=7f104f6fe558bb56b4205241435a2357c2feece1;p=mailer.git

diff --git a/inc/modules/admin/what-stats_mods.php b/inc/modules/admin/what-stats_mods.php
index fc69db6d3e..59a1c99fa3 100644
--- a/inc/modules/admin/what-stats_mods.php
+++ b/inc/modules/admin/what-stats_mods.php
@@ -38,7 +38,7 @@ if ((!defined('__SECURITY')) || (!IS_ADMIN())) {
 }
 
 // Add description as navigation point
-ADD_DESCR("admin", basename(__FILE__));
+ADD_DESCR("admin", __FILE__);
 
 // If var is empty set it to empty
 if (empty($_GET['mod'])) $_GET['mod'] = "";
@@ -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(