<?php
if (!defined('BASEPATH')) {
exit('Nu poti accesa acest fisier direct.');
}
$expire = $CFG->get('rank_regenerate');
$expire = 0;
if (Cache::is_cached('top_10_players', $expire)) {
Vars::set('players_rank', Cache::get('top_10_players'));
} else {
$players = array();
$sql = "SELECT player.id, player.name, player.level, player_index.empire \n FROM " . PLAYER_DATABASE . ".player \n LEFT JOIN " . PLAYER_DATABASE . ".player_index ON player_index.id=player.account_id \n LEFT JOIN " . PLAYER_DATABASE . ".guild_member ON guild_member.pid=player.id \n INNER JOIN " . ACCOUNT_DATABASE . ".account \n ON account.id=player.account_id\n WHERE player.name NOT LIKE '[%]%' AND account.status!='BLOCK'\n ORDER BY player.level DESC, player.exp DESC LIMIT 10";
$query = $DB->query($sql);
while ($row = $DB->fetch($query)) {
$players[] = $row;
}
Cache::set('top_10_players', $players);
Vars::set('players_rank', $players);
}
if (Cache::is_cached('top_10_guilds', $expire)) {
Vars::set('guilds_rank', Cache::get('top_10_guilds'));
} else {
$guilds = array();
$sql = "SELECT \n guild.name, guild.level, guild.win, guild.ladder_point, player_index.empire\n FROM " . PLAYER_DATABASE . ".guild \n LEFT JOIN " . PLAYER_DATABASE . ".player ON guild.master = player.id \n LEFT JOIN " . PLAYER_DATABASE . ".player_index ON player_index.id = player.account_id \n WHERE player.name NOT LIKE '[%]%' \n ORDER BY guild.ladder_point DESC LIMIT 10";
$query = $DB->query($sql);
while ($row = $DB->fetch($query)) {
$guilds[] = $row;
}
Cache::set('top_10_guilds', $guilds);
Vars::set('guilds_rank', $guilds);
}
/**
* @todo: Replace this code with a proper router
**/
define('DS', DIRECTORY_SEPARATOR);
define('BASEPATH', realpath(dirname(__FILE__)) . DS);
define('APPPATH', BASEPATH . 'application' . DS);
require BASEPATH . 'system' . DS . 'core.php';
define('LOGGED_IN', is_logged_in());
$smarty->assign('logged_in', LOGGED_IN);
if (isset($_SESSION['user_data']['id'])) {
$smarty->assign('user_id', $_SESSION['user_data']['id']);
} else {
$smarty->assign('user_id', 0);
}
/* ----- Use a router insted ----- */
$query = isset($_SERVER['QUERY_STRING']) ? $_SERVER['QUERY_STRING'] : '';
$req_uri = isset($_SERVER['REQUEST_URI']) ? $_SERVER['REQUEST_URI'] : '';
$request = str_replace($CFG->get('relative_path'), '', $req_uri);
$request = str_replace('?' . $query, '', $request);
$url_parts = explode('/', trim($request, '/'));
$url_parts[0] = isset($url_parts[0]) && $url_parts[0] != '' ? $url_parts[0] : '';
$url_parts = str_replace('..', '', $url_parts);
/* ---------- */
$file = plugin($url_parts);
Vars::set('args', $url_parts);
Vars::set('plain_args', implode('/', $url_parts));
require $file;
require BASEPATH . 'getRank.php';
$smarty->assign('players_rank', Vars::get('players_rank'));
$smarty->assign('guilds_rank', Vars::get('guilds_rank'));
$smarty->display('main.tpl');
