<?php
/*
fiemeCP - BETA.
Written by, and managed by xDario.

The script may be altered at wish, but redistributing any part of it, even with credets, is prohibited. Currently, only myself and my website (http://www.dario-ml.com/) along with kryptodev are aloud to host my script.

©2011 xDario (created for Ohai Online)

You must provide a thanks on the page from which this is called, unless you have donated. If I find my class used without copyright, or a mention of appreciation, I will pursude you. Fiesta servers aren't thousands, so you're not hard to spot out.

Page: leaderboard.php
Last Change: 30 June 2011
*/

define('IN_FIEME', 1);

require_once 'global.php';
$lang->load("leaderboard");
$settings->load("leaderboard");

$plugin->run_hooks("leaderboard_page_start");

// CHECK ADMIN LEVELS OF CHARACTER!!

if ($settings->lb_allow != 1)
{
	$plugin->run_hooks("leaderboard_page_stopped");
	die ("The admin has deactivated leaderboard viewing for members.");
}

eval("\$leaderboard_table = \"".$template->get("leaderboard_table_open")."\";");

//Get the proper results fom the database
if (@$_GET['order'] == "money")
{
	$query = sqlsrv_query($fiemecp->dbchar, "SELECT TOP " . $settings->lb_top_howmany . " * FROM dbo.tCharacter WHERE bDeleted = '0' AND nAdminLevel <= " . $settings->lb_min_adminlevel . " ORDER BY nMoney DESC", array(), array( "Scrollable" => SQLSRV_CURSOR_KEYSET));
}
elseif (@$_GET['order'] == "time_online")
{
	$query = sqlsrv_query($fiemecp->dbchar, "SELECT TOP " . $settings->lb_top_howmany . " * FROM dbo.tCharacter WHERE bDeleted = '0' AND nAdminLevel <= " . $settings->lb_min_adminlevel . " ORDER BY nPlayMin DESC", array(), array( "Scrollable" => SQLSRV_CURSOR_KEYSET));
}
elseif (@$_GET['order'] == "login_count")
{
	$query = sqlsrv_query($fiemecp->dbchar, "SELECT TOP " . $settings->lb_top_howmany . " * FROM dbo.tCharacter WHERE bDeleted = '0' AND nAdminLevel <= " . $settings->lb_min_adminlevel . " ORDER BY nLoginCount DESC", array(), array( "Scrollable" => SQLSRV_CURSOR_KEYSET));
}
else
{
	$query = sqlsrv_query($fiemecp->dbchar, "SELECT TOP " . $settings->lb_top_howmany . " * FROM dbo.tCharacter WHERE bDeleted = '0' AND nAdminLevel <= " . $settings->lb_min_adminlevel . " ORDER BY nExp DESC", array(), array( "Scrollable" => SQLSRV_CURSOR_KEYSET));
}

$plugin->run_hooks("leaderboard_table_row_start");

while ($row = sqlsrv_fetch_array($query))
{
	$plugin->run_hooks("leaderboard_table_row_foreach_start");
	$row['nMoney'] = addslashes($fiemecp->money_to_readable($row['nMoney']));
	eval("\$leaderboard_table .= \"".dsprintf($template->get("leaderboard_table_continue"), array("name"=>$row['sID'], "level"=>$row['nLevel'], "money"=>$row['nMoney'], "time_online"=>$row['nPlayMin'], "tot_login"=>$row['nLoginCount']))."\";");
	$plugin->run_hooks("leaderboard_table_row_foreach_end");
}

$plugin->run_hooks("leaderboard_table_row_end");

eval("\$leaderboard_table .= \"".$template->get("leaderboard_table_close")."\";");

$plugin->run_hooks("leaderboard_table_end");

eval("\$leaderboard_main = \"".$template->get("leaderboard")."\";");

$plugin->run_hooks("leaderboard_page_end");
output_page($leaderboard_main);