X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=inc%2Fmodules%2Fguest%2Fwhat-top10.php;h=04d240b152c84d0e3bb35f4f2de452d6bbb5c7d5;hp=f6bc1f06a1d74a18a03dbf5d4d364335277f406f;hb=b8c86fa12322603c24a88ea2b0fd3dbeba612752;hpb=5bdeaf8b452206598b6c6cd4f941145b11a0eccc diff --git a/inc/modules/guest/what-top10.php b/inc/modules/guest/what-top10.php index f6bc1f06a1..04d240b152 100644 --- a/inc/modules/guest/what-top10.php +++ b/inc/modules/guest/what-top10.php @@ -36,7 +36,7 @@ if (!defined('__SECURITY')) { $INC = substr(dirname(__FILE__), 0, strpos(dirname(__FILE__), "/inc") + 4) . "/security.php"; require($INC); } elseif ((!EXT_IS_ACTIVE("top10")) && (!IS_ADMIN())) { - addFatalMessage(EXTENSION_PROBLEM_EXT_INACTIVE, "top10"); + addFatalMessage(__FILE__, __LINE__, getMessage('EXTENSION_PROBLEM_EXT_INACTIVE'), "top10"); return; } @@ -51,7 +51,7 @@ FROM {!_MYSQL_PREFIX!}_user_data WHERE total_logins > 0 AND - status='CONFIRMED' + `status`='CONFIRMED' ORDER BY total_logins DESC LIMIT %s", @@ -110,12 +110,12 @@ SELECT DISTINCT FROM `{!_MYSQL_PREFIX!}_user_data` AS d LEFT JOIN - {!MYSQL_PREFIX!}_user_points AS p + {!_MYSQL_PREFIX!}_user_points AS p ON p.userid=d.userid WHERE p.points > 0 AND - d.status='CONFIRMED' + d.`status`='CONFIRMED' GROUP BY p.userid ORDER BY @@ -176,12 +176,12 @@ SELECT DISTINCT FROM `{!_MYSQL_PREFIX!}_user_data` AS d LEFT JOIN - {!MYSQL_PREFIX!}_refsystem AS r + {!_MYSQL_PREFIX!}_refsystem AS r ON r.userid=d.userid WHERE r.counter > 0 AND - d.status='CONFIRMED' + d.`status`='CONFIRMED' GROUP BY r.userid ORDER BY