if (!defined('__SECURITY')) {
$INC = substr(dirname(__FILE__), 0, strpos(dirname(__FILE__), "/inc") + 4) . "/security.php";
require($INC);
-} elseif (!EXT_IS_ACTIVE("top10")) {
+} elseif ((!EXT_IS_ACTIVE("top10")) && (!IS_ADMIN())) {
ADD_FATAL(EXTENSION_PROBLEM_EXT_INACTIVE, "top10");
return;
}
$result = SQL_QUERY_ESC("SELECT userid, ".$ADD.", total_logins, last_online
FROM "._MYSQL_PREFIX."_user_data
WHERE total_logins>0 AND status='CONFIRMED' ORDER BY total_logins DESC LIMIT %s",
- array($_CONFIG['top10_max']), __FILE__, __LINE__);
+ array(getConfig('top10_max')), __FILE__, __LINE__);
$OUT = ""; $SW = 2; $cnt = 1;
while(list($uid, $nick, $logins, $last) = SQL_FETCHROW($result))
// Switch colors and count one up
$SW = 3 - $SW; $cnt++;
}
-if ($cnt < $_CONFIG['top10_max'])
+if ($cnt < getConfig('top10_max'))
{
// Add more "blank" rows
- for ($i = $cnt; $i <= $_CONFIG['top10_max']; $i++)
+ for ($i = $cnt; $i <= getConfig('top10_max'); $i++)
{
// Prepare data for template
$content = array(
//// 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
ORDER BY tpoints DESC, d.last_online DESC
LIMIT %s",
- array($_CONFIG['top10_max']), __FILE__, __LINE__);
+ array(getConfig('top10_max')), __FILE__, __LINE__);
$OUT = ""; $SW = 2; $cnt = 1;
while(list($uid, $nick, $points, $last) = SQL_FETCHROW($result))
// Switch colors and count one up
$SW = 3 - $SW; $cnt++;
}
-if ($cnt < $_CONFIG['top10_max'])
+if ($cnt < getConfig('top10_max'))
{
// Add more "blank" rows
- for ($i = $cnt; $i <= $_CONFIG['top10_max']; $i++)
+ for ($i = $cnt; $i <= getConfig('top10_max'); $i++)
{
// Prepare data for template
$content = array(
//// 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
ORDER BY refs DESC, d.last_online DESC
LIMIT %s",
- array($_CONFIG['top10_max']), __FILE__, __LINE__);
+ array(getConfig('top10_max')), __FILE__, __LINE__);
$OUT = ""; $SW = 2; $cnt = 1;
while(list($uid, $nick, $refs, $last) = SQL_FETCHROW($result))
// Switch colors and count one up
$SW = 3 - $SW; $cnt++;
}
-if ($cnt < $_CONFIG['top10_max'])
+if ($cnt < getConfig('top10_max'))
{
// Add more "blank" rows
- for ($i = $cnt; $i <= $_CONFIG['top10_max']; $i++)
+ for ($i = $cnt; $i <= getConfig('top10_max'); $i++)
{
// Prepare data for template
$content = array(
define('__TOP_REFERRAL_ROWS', $OUT);
// Remember other values in constants
-define('__TOP10_MAX', $_CONFIG['top10_max']);
+define('__TOP10_MAX', getConfig('top10_max'));
// Load final template
LOAD_TEMPLATE("guest_top10");