ranking.php

<?php
// The Kabal Invasion - A web-based 4X space game
// Copyright © 2014 The Kabal Invasion development team, Ron Harwood, and the BNT development team
//
//  This program is free software: you can redistribute it and/or modify
//  it under the terms of the GNU Affero 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 Affero General Public License for more details.
//
//  You should have received a copy of the GNU Affero General Public License
//  along with this program.  If not, see <http://www.gnu.org/licenses/>.
//
// File: ranking.php
// FUTURE: Remove color controls out to css

require_once './common.php';

// Always make sure we are using empty vars before use.
$variables = null;

$variables['body_class'] = 'tki';
$variables['lang'] = $lang;
$variables['link'] = 'ranking.php';
$variables['title'] = $langvars['l_ranks_title'];

// These should be set within the template config, and be css driven using nth + 1 selectors.
$variables['color_header'] = $tkireg->color_header;
$variables['color_line1'] = $tkireg->color_line1;
$variables['color_line2'] = $tkireg->color_line2;

// Load required language variables for the ranking page.
$langvars = Tki\Translate::load($pdo_db, $lang,
            array('main', 'ranking', 'common', 'global_includes', 'global_funcs', 'footer', 'teams'));

// Get requested ranking order.
// Detect if this variable exists, and filter it. Returns false if anything wasn't right.
$sort = null;
$sort = filter_input(INPUT_GET, 'sort', FILTER_SANITIZE_STRING);
if (mb_strlen(trim($sort)) === 0)
{
    $sort = false;
}

switch ($sort)
{
    case 'turns':
        $by = 'turns_used DESC, character_name ASC';
        break;
    case 'login':
        $by = 'last_login DESC, character_name ASC';
        break;
    case 'good':
        $by = 'rating DESC, character_name ASC';
        break;
    case 'bad':
        $by = 'rating ASC, character_name ASC';
        break;
    case 'team':
        $by = "::prefix::teams.team_name DESC, character_name ASC";
        break;
    case 'efficiency':
        $by = 'efficiency DESC';
        break;
    default:
        $by = 'score DESC, character_name ASC';
        break;
}

$variables['num_players'] = (int) 0;

$sql = "SELECT {$db->prefix}ships.ship_id, {$db->prefix}ships.email, {$db->prefix}ships.ip_address, " .
"{$db->prefix}ships.score, {$db->prefix}ships.character_name, {$db->prefix}ships.turns_used, " .
"{$db->prefix}ships.last_login, UNIX_TIMESTAMP({$db->prefix}ships.last_login) as online, " .
"{$db->prefix}ships.rating, {$db->prefix}teams.team_name, {$db->prefix}teams.admin AS team_admin, " .
"if ({$db->prefix}ships.turns_used < 150, 0, ROUND({$db->prefix}ships.score/{$db->prefix}ships.turns_used)) " .
"AS efficiency FROM {$db->prefix}ships LEFT JOIN {$db->prefix}teams ON " .
"{$db->prefix}ships.team = {$db->prefix}teams.id WHERE ship_destroyed='N' and email NOT LIKE '%@xenobe' " .
"AND turns_used > 0 ORDER BY :order_by LIMIT :limit";

$stmt = $pdo_db->prepare($sql);
$stmt->bindParam(':order_by', $by);
$stmt->bindParam(':limit', $tkireg->max_ranks);
$stmt->execute();
$rankings = $stmt->fetchAll(PDO::FETCH_ASSOC);
$variables['num_players'] = (int) count($rankings);
$player_list = array();
$xx = 1;

if ($rankings !== null && ($variables['num_players'] > 0))
{
    foreach ($rankings as $row)
    {
        // Set the players rank number.
        $row['rank'] = count($player_list) + 1;

        // Calculate the players rating.
        $rating = round(sqrt(abs($row['rating'])));
        if (abs($row['rating']) != $row['rating'])
        {
            $rating = -1 * $rating;
        }

        $row['rating'] = $rating;

        // Calculate the players online status.
        $curtime = time();
        $time = $row['online'];
        $difftime = ($curtime - $time) / 60;
        $temp_turns = $row['turns_used'];
        if ($temp_turns <= 0)
        {
            $temp_turns = 1;
        }

        // Set the players online/offline status.
        $row['online'] = (bool) false;
        if ($difftime <= 5)
        {
            $row['online'] = (bool) true;
        }

        // Set the characters Insignia.
        $row['insignia'] = Tki\Character::getInsignia($pdo_db, $row['email'], $langvars);

        // This is just to show that we can set the type of player.
        // like: banned, admin, player, npc etc.
        if ($row['email'] == $tkireg->admin_mail || $row['team_admin'] === 'Y')
        {
            $row['type'] = 'admin';
        }
        else
        {
            $row['type'] = 'player';
        }

        // Check for banned players.
        $ban_result = Tki\CheckBan::isBanned($pdo_db, $row);

        if ($ban_result === false || (array_key_exists('ban_type', $ban_result) && $ban_result['ban_type'] === ID_WATCH))
        {
            $row['banned'] = (bool) false;
            $row['ban_info'] = null;
        }
        else
        {
            $row['banned'] = (bool) true;
            $row['ban_info'] = array('type' => $ban_result['ban_type'],
                'public_info' => "Player banned/locked for the following:\n{$ban_result['public_info']}");
        }

        array_push($player_list, $row);
    }

    $template->addVariables('players', $player_list);
}

if (empty ($_SESSION['username']))
{
    $variables['loggedin'] = (bool) true;
    $variables['linkback'] = array('caption' => $langvars['l_global_mlogin'], 'link' => 'index.php');
}
else
{
    $variables['loggedin'] = (bool) false;
    $variables['linkback'] = array('caption' => $langvars['l_global_mmenu'], 'link' => 'main.php');
}

Tki\Header::display($pdo_db, $lang, $template, $variables['title'], $variables['body_class']);
$template->addVariables('variables', $variables);

// Load required language variables for the ranking page.
$langvars = Tki\Translate::load($pdo_db, $lang,
            array('main', 'ranking', 'common', 'global_includes', 'global_funcs', 'footer', 'teams', 'news'));

// Modify the requires language variables here.
$langvars['l_ranks_title'] = str_replace('[max_ranks]', $tkireg->max_ranks, $langvars['l_ranks_title']);

// Now add the loaded language variables into Smarty.
$template->addVariables('langvars', $langvars);

// Now we tell Smarty to output the page
$template->display('ranking.tpl');

Tki\Footer::display($pdo_db, $lang, $tkireg, $template);