A lot fixes to templates and missing functions added, more rewrites

[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 f6bc1f06a1d74a18a03dbf5d4d364335277f406f..04d240b152c84d0e3bb35f4f2de452d6bbb5c7d5 100644 (file)
--- 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