* All rights reserved.
*
* This program is free software: you can redistribute it and/or modify
* it under the terms of the GNU General Public License as published by
* the Free Software Foundation, either version 3 of the License, or
* (at your option) any later version.
*
* This program is distributed in the hope that it will be useful,
* but WITHOUT ANY WARRANTY; without even the implied warranty of
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
* GNU General Public License for more details.
*
* You should have received a copy of the GNU General Public License
* along with this program. If not, see .
*
* --> NOTICE <--
* This file is part of the core development branch, changing its contents will
* make you unable to use the automatic updates manager. Please refer to the
* documentation for further information about customizing XNova.
*
*/
define('INSIDE' , true);
define('INSTALL' , false);
require_once dirname(__FILE__) .'/common.php';
includeLang('stat');
$parse = $lang;
$who = (isset($_POST['who'])) ? $_POST['who'] : $_GET['who'];
if (!isset($who)) {
$who = 1;
}
$type = (isset($_POST['type'])) ? $_POST['type'] : $_GET['type'];
if (!isset($type)) {
$type = 1;
}
$range = (isset($_POST['range'])) ? $_POST['range'] : $_GET['range'];
if (!isset($range)) {
$range = 1;
}
$parse['who'] = "";
$parse['who'] .= "";
$parse['type'] = "";
$parse['type'] .= "";
$parse['type'] .= "";
$parse['type'] .= "";
$parse['type'] .= "";
if ($type == 1) {
$Order = "total_points";
$Points = "total_points";
$Counts = "total_count";
$Rank = "total_rank";
$OldRank = "total_old_rank";
} elseif ($type == 2) {
$Order = "fleet_points";
$Points = "fleet_points";
$Counts = "fleet_count";
$Rank = "fleet_rank";
$OldRank = "fleet_old_rank";
} elseif ($type == 3) {
$Order = "tech_count";
$Points = "tech_points";
$Counts = "tech_count";
$Rank = "tech_rank";
$OldRank = "tech_old_rank";
} elseif ($type == 4) {
$Order = "build_points";
$Points = "build_points";
$Counts = "build_count";
$Rank = "build_rank";
$OldRank = "build_old_rank";
} elseif ($type == 5) {
$Order = "defs_points";
$Points = "defs_points";
$Counts = "defs_count";
$Rank = "defs_rank";
$OldRank = "defs_old_rank";
}
if ($who == 2) {
$MaxAllys = doquery ("SELECT COUNT(*) AS `count` FROM {{table}} WHERE 1;", 'alliance', true);
if ($MaxAllys['count'] > 100) {
$LastPage = floor($MaxAllys['count'] / 100);
}
$parse['range'] = "";
for ($Page = 0; $Page <= $LastPage; $Page++) {
$PageValue = ($Page * 100) + 1;
$PageRange = $PageValue + 99;
$parse['range'] .= "";
}
$parse['stat_header'] = parsetemplate(gettemplate('stat_alliancetable_header'), $parse);
$start = floor($range / 100 % 100) * 100;
$query = doquery("SELECT * FROM {{table}} WHERE `stat_type` = '2' AND `stat_code` = '1' ORDER BY `". $Order ."` DESC LIMIT ". $start .",100;", 'statpoints');
$start++;
$parse['stat_date'] = $gameConfig['stats'];
$parse['stat_values'] = "";
while ($StatRow = $query->fetch(PDO::FETCH_ASSOC)) {
$parse['ally_rank'] = $start;
$AllyRow = doquery("SELECT * FROM {{table}} WHERE `id` = '". $StatRow['id_owner'] ."';", 'alliance',true);
$rank_old = $StatRow[ $OldRank ];
if ( $rank_old == 0) {
$rank_old = $start;
$QryUpdRank = doquery("UPDATE {{table}} SET `".$Rank."` = '".$start."', `".$OldRank."` = '".$start."' WHERE `stat_type` = '2' AND `stat_code` = '1' AND `id_owner` = '". $StatRow['id_owner'] ."';" , "statpoints");
} else {
$QryUpdRank = doquery("UPDATE {{table}} SET `".$Rank."` = '".$start."' WHERE `stat_type` = '2' AND `stat_code` = '1' AND `id_owner` = '". $StatRow['id_owner'] ."';" , "statpoints");
}
$rank_new = $start;
$ranking = $rank_old - $rank_new;
if ($ranking == "0") {
$parse['ally_rankplus'] = "*";
}
if ($ranking < "0") {
$parse['ally_rankplus'] = "".$ranking."";
}
if ($ranking > "0") {
$parse['ally_rankplus'] = "+".$ranking."";
}
$parse['ally_tag'] = $AllyRow['ally_tag'];
$parse['ally_name'] = $AllyRow['ally_name'];
$parse['ally_mes'] = '';
$parse['ally_members'] = $AllyRow['ally_members'];
$parse['ally_points'] = pretty_number( $StatRow[ $Order ] );
$parse['ally_members_points'] = pretty_number( floor($StatRow[ $Order ] / $AllyRow['ally_members']) );
$parse['stat_values'] .= parsetemplate(gettemplate('stat_alliancetable'), $parse);
$start++;
}
} else {
$MaxUsers = doquery ("SELECT COUNT(*) AS `count` FROM {{table}} WHERE `db_deaktjava` = '0';", 'users', true);
if ($MaxUsers['count'] > 100) {
$LastPage = floor($MaxUsers['count'] / 100);
}
$parse['range'] = "";
for ($Page = 0; $Page <= $LastPage; $Page++) {
$PageValue = ($Page * 100) + 1;
$PageRange = $PageValue + 99;
$parse['range'] .= "";
}
$parse['stat_header'] = parsetemplate(gettemplate('stat_playertable_header'), $parse);
$start = floor($range / 100 % 100) * 100;
$query = doquery("SELECT * FROM {{table}} WHERE `stat_type` = '1' AND `stat_code` = '1' ORDER BY `". $Order ."` DESC LIMIT ". $start .",100;", 'statpoints');
$start++;
$parse['stat_date'] = $gameConfig['stats'];
$parse['stat_values'] = "";
while ($StatRow = $query->fetch(PDO::FETCH_ASSOC)) {
$parse['stat_date'] = date("d M Y - H:i:s", $StatRow['stat_date']);
$parse['player_rank'] = $start;
$UsrRow = doquery("SELECT * FROM {{table}} WHERE `id` = '". $StatRow['id_owner'] ."';", 'users',true);
$QryUpdateStats .= "`stat_type` = '1' AND `stat_code` = '1' AND `id_owner` = '". $TheRank['id_owner'] ."';";
$rank_old = $StatRow[ $OldRank ];
if ( $rank_old == 0) {
$rank_old = $start;
$QryUpdRank = doquery("UPDATE {{table}} SET `".$Rank."` = '".$start."', `".$OldRank."` = '".$start."' WHERE `stat_type` = '1' AND `stat_code` = '1' AND `id_owner` = '". $StatRow['id_owner'] ."';" , "statpoints");
} else {
$QryUpdRank = doquery("UPDATE {{table}} SET `".$Rank."` = '".$start."' WHERE `stat_type` = '1' AND `stat_code` = '1' AND `id_owner` = '". $StatRow['id_owner'] ."';" , "statpoints");
}
$rank_new = $start;
$ranking = $rank_old - $rank_new;
if ($ranking == "0") {
$parse['player_rankplus'] = "*";
}
if ($ranking < "0") {
$parse['player_rankplus'] = "".$ranking."";
}
if ($ranking > "0") {
$parse['player_rankplus'] = "+".$ranking."";
}
if ($UsrRow['id'] == $user['id']) {
$parse['player_name'] = "".$UsrRow['username']."";
} else {
$parse['player_name'] = $UsrRow['username'];
}
$parse['player_mes'] = "![\"".](\"")
";
if ($UsrRow['ally_name'] == $user['ally_name']) {
$parse['player_alliance'] = "".$UsrRow['ally_name']."";
} else {
$parse['player_alliance'] = $UsrRow['ally_name'];
}
$parse['player_points'] = pretty_number( $StatRow[ $Order ] );
$parse['stat_values'] .= parsetemplate(gettemplate('stat_playertable'), $parse);
$start++;
}
}
$page = parsetemplate( gettemplate('stat_body'), $parse );
display($page, $lang['stat_title']);
// -----------------------------------------------------------------------------------------------------------
// History version
// 1.0 - R��criture module
?>