X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Fmodules%2Fguest%2Fwhat-top10.php;h=b055bae9ef8c536bfa47439cd1a8fb39548730aa;hb=7989ec603971c0dc8dc35d8be4e72f8098b83baa;hp=151f60057fc50c797dac9f5b8c302dc6eb279d3c;hpb=cca98f57dff720b174d21d071cee8303462485d7;p=mailer.git

diff --git a/inc/modules/guest/what-top10.php b/inc/modules/guest/what-top10.php
index 151f60057f..b055bae9ef 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(getMessage('EXTENSION_PROBLEM_EXT_INACTIVE'), "top10");
 	return;
 }
 
@@ -48,10 +48,10 @@ $result = SQL_QUERY_ESC("
 SELECT
 	userid, total_logins, last_online
 FROM
-	"._MYSQL_PREFIX."_user_data
+	{!_MYSQL_PREFIX!}_user_data
 WHERE
 	total_logins > 0 AND
-	status='CONFIRMED'
+	`status`='CONFIRMED'
 ORDER BY
 	total_logins DESC
 LIMIT %s",
@@ -108,14 +108,14 @@ SELECT DISTINCT
 	(SUM(p.points) - d.used_points) AS tpoints,
 	d.last_online
 FROM
-	`{!MYSQL_PREFIX!}_user_data` AS d
+	`{!_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
@@ -174,14 +174,14 @@ SELECT DISTINCT
 	SUM(r.counter) AS refs,
 	d.last_online
 FROM
-	`{!MYSQL_PREFIX!}_user_data` AS d
+	`{!_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