All database names are now 'back-ticked' and constant _MYSQL_PREFIX is wrapped. Partl...

[mailer.git] / inc / modules / guest / what-top10.php

diff --git a/inc/modules/guest/what-top10.php b/inc/modules/guest/what-top10.php
index fe843213db647fe0712c00790e61580d30fa6c26..151f60057fc50c797dac9f5b8c302dc6eb279d3c 100644 (file)
--- a/inc/modules/guest/what-top10.php
+++ b/inc/modules/guest/what-top10.php
@@ -108,9 +108,9 @@ 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
@@ -174,9 +174,9 @@ 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