<?php
require_once "maincore.php";
require_once THEMES."templates/header.php";

function paginare($page, $page_size, $max_results, $range) {
    global $locale;
    $link = FUSION_SELF."?page_size=".$page_size."&";
    $pg_cnt = ceil($max_results / $page_size);
    if ($pg_cnt <= 1) { return ""; }

    $idx_back = $page - 1;
    $idx_next = $page + 1;

    $res = $locale['global_092']." ".$page.$locale['global_093'].$pg_cnt.": ";
    if($idx_back >= 0) {
        if($page > ($range + 1)) {
            $res .= "<a href='".$link."page=1'>1</a>...";
        }
    }
    $idx_fst = max($page - $range, 1);
    $idx_lst = min($page + $range, $pg_cnt);
    if ($range == 0) {
        $idx_fst = 1;
        $idx_lst = $pg_cnt;
    }
    for ($i = $idx_fst; $i <= $idx_lst; $i++) {
          if ($i == $page) {
            $res .= "<span><strong>".$i."</strong></span>";
        } else {
            $res .= "<a href='".$link."page=".$i."'>".$i."</a>";
        }
    }
    if ($idx_next < $pg_cnt) {
        if ($page < ($pg_cnt - $range)) {
            $res .= "...<a href='".$link."page=".$pg_cnt."'>".$pg_cnt."</a>\n";
        }
    }
    return "<div class='pagenav' align='center' style='margin-top:5px;'>\n".$res."</div>\n";
}

opentable("Clasament");

$db2_host = "82...2";
$db2_user = "ti243";
$db2_pass = "a5";
$db2_name = "pr";

$db2_link = mysql_connect($db2_host, $db2_user, $db2_pass) OR
die("Nu sa putut conecta la baza de date.<br /> Mesaj de eroare: ".mysql_error());

mysql_select_db($db2_name, $db2_link) OR
die("Baza de date nu a putut fi folosita.");

$default_page_size = 50;
$default_page = 1;
$default_max_results = 1000;

// ChillyWilly
if (isset($_REQUEST['page_size']) && is_numeric($_REQUEST['page_size'])) $page_size = $_REQUEST['page_size'];
else $page_size = $default_page_size;
if (isset($_REQUEST['page'])&&is_numeric($_REQUEST['page'])) $page = $_REQUEST['page'];
else $page = $default_page;
if (isset($_REQUEST['max_results']) && is_numeric($_REQUEST['max_results'])) $max_results = $_REQUEST['max_results'];
else $max_results = $default_max_results;
//////////////

$sq2 = "SELECT * FROM player WHERE gmrec='no' AND gmrec!='ban' ORDER BY level DESC LIMIT ".(($page-1)*$page_size)." , ".$page_size."";
$i = ($page-1)*$page_size ;
$ergebnis = mysql_query($sq2);

echo "<table width='600' cellpadding='0' cellspacing='1' class='tbl-border' align='center'>\n";
echo "<tr>";
echo "<td width='10' class='forum-caption' align='center'>#</td><td class='forum-caption' align='left'>Nume</td><td width='75' class='forum-caption' align='left'>Experien&#355;&#259;:</td><td width='24' class='forum-caption' align='center'>LvL</td><td width='41' class='forum-caption' align='left'>Regat:</td>";
echo "</tr>";

while($row = mysql_fetch_object($ergebnis))
    {
        $ida = $row->account_id;
        $sq3 = " SELECT * FROM player_index WHERE id=".$ida."";
        $ergebnis2 = mysql_query($sq3, $db2_link);

            while($rows = mysql_fetch_object($ergebnis2))
                {
                    $i = $i + 1 ;
                    echo "<tr>";
                    echo "<td class='tbl".($i % 2 == 0 ? "2" : "1")."' align='center'>".$i."</td><td class='tbl".($i % 2 == 0 ? "2" : "1")."' align='left'>".$row->name."</td><td class='tbl".($i % 2 == 0 ? "2" : "1")."' align='left'>".$row->exp."</td><td class='tbl".($i % 2 == 0 ? "2" : "1")."' align='center'>".$row->level."</td>";
                        $lume = $rows->empire;
                        if ($lume == 3) {
                            echo "<td class='tbl".($i % 2 == 0 ? "2" : "1")."' align='center'><img src='images/flags/blue.jpg' alt='Albastru' border='0' width='21' height='13' /></td>";
                        }
                        if ($lume == 1) {
                            echo "<td class='tbl".($i % 2 == 0 ? "2" : "1")."' align='center'><img src='images/flags/red.jpg' alt='Rosu' border='0' width='21' height='13' /></td>";
                        }
                        if ($lume == 2) {
                            echo "<td class='tbl".($i % 2 == 0 ? "2" : "1")."' align='center'><img src='images/flags/yellow.jpg' alt='Galben' border='0' width='21' height='13' /></td>";
                        }
                        echo "</tr>";
                }
   }

echo "</table>";

$entries = dbcount("(account_id)", $db2_name, "gmrec='no' AND gmrec!='ban'");
//$nr_pagini = min($entries,$max_results);
//if ($entries % $page_size == 0)
// $nr_pagini = $entries/$page_size;
//else $nr_pagini = $entries / $page_size + 1;
//for ($i=1; $i<=$nr_pagini; $i++)
//{
// echo "<a href=?page_size=".$page_size."&page=".$i."&max_results=".$max_results.">pagina ".$i."</a>";
//}

echo paginare($page, $page_size, min($entries, $max_results) , 3);

mysql_close($db2_link);

// baza de date de la fusion
$link = dbconnect($db_host, $db_user, $db_pass, $db_name);

closetable();
require_once THEMES."templates/footer.php";
?>