Previous fix fixed, a lot constants rewritten (unfinished)

[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 151f60057fc50c797dac9f5b8c302dc6eb279d3c..f6bc1f06a1d74a18a03dbf5d4d364335277f406f 100644 (file)
--- a/inc/modules/guest/what-top10.php
+++ b/inc/modules/guest/what-top10.php
@@ -48,7 +48,7 @@ $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'
@@ -108,7 +108,7 @@ 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
 ON
@@ -174,7 +174,7 @@ 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
 ON