$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;
}
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",
(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
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