X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Fmodules%2Fguest%2Fwhat-top10.php;h=705a45fa7a9ed06cfb355f5cefb2a0dd7fc088fb;hb=742dc54551e0e109f5ece9f1c6233673e44392ac;hp=f4e0c86e2f03dfc9fb7232356002055bc227e56f;hpb=56b24f7a0fb2373847ecf00d08cfb52a0ffb5d28;p=mailer.git

diff --git a/inc/modules/guest/what-top10.php b/inc/modules/guest/what-top10.php
index f4e0c86e2f..705a45fa7a 100644
--- a/inc/modules/guest/what-top10.php
+++ b/inc/modules/guest/what-top10.php
@@ -95,7 +95,7 @@ define('__TOP_LOGINS_ROWS', $OUT);
 //// TOP earners
 $result = SQL_QUERY_ESC("SELECT DISTINCT p.userid, d.".$ADD.", (SUM(p.points) - d.used_points) AS tpoints, d.last_online
 FROM "._MYSQL_PREFIX."_user_points AS p
-LEFT JOIN "._MYSQL_PREFIX."_user_data AS d
+LEFT JOIN `"._MYSQL_PREFIX."_user_data` AS d
 ON p.userid=d.userid
 WHERE p.points > 0 AND d.status='CONFIRMED'
 GROUP BY p.userid
@@ -146,7 +146,7 @@ define('__TOP_POINTS_ROWS', $OUT);
 //// TOP referal "hunter"
 $result = SQL_QUERY_ESC("SELECT DISTINCT r.userid, d.".$ADD.", SUM(r.counter) AS refs, d.last_online
 FROM "._MYSQL_PREFIX."_refsystem AS r
-LEFT JOIN "._MYSQL_PREFIX."_user_data AS d
+LEFT JOIN `"._MYSQL_PREFIX."_user_data` AS d
 ON r.userid=d.userid
 WHERE r.counter > 0 AND d.status='CONFIRMED'
 GROUP BY r.userid