<?
session_start();
include ("admin/config.php");
include ("admin/messages.php");
include ("design/head.php");
include ("design/cent.php");

define( 'USERS_ON_PAGE', $num );
$query = "SELECT COUNT(*) FROM servers";
$res = mysql_query( $query );
$total = 'mysql_result( $res, 0, 0 )';
if ( isset($_GET['page']) )
{
    $page = (int)$_GET['page'];
    if ( $page < 1 ) $page = 1;
}
else
{
    $page = 1;
}
$cnt_pages = ceil( $total / USERS_ON_PAGE );
if ( $page > $cnt_pages ) $page = $cnt_pages;
$start = ( $page - 1 ) * USERS_ON_PAGE;

$query = "SELECT * FROM users ORDER BY rating DESC LIMIT ".$start.", ".USERS_ON_PAGE;
$q = mysql_query( $query );
while ( $project = 'mysql_fetch_array($q)' )
{
$p_id = $project['id'];
$p_name = $project['name'];
$rating = $project['rating'];
$views = $project['views'];
$country = $project['country'];
$site = $project['site'];
$banner = $project['banner'];

$s = mysql_query("SELECT * FROM servers WHERE owner='$p_name'");
$s_r = 'mysql_fetch_array($s)';
if($s_r['id']){
echo '
<table width="610" class="server" cellspacing="2" cellpadding="2">
<tr>
<td align="left">
<a href="/project.php?id='.$p_id.'"><b>'.$p_name.'</b></a>
</td>
</tr>
<tr><td>';

$q_2 = mysql_query("SELECT * FROM servers WHERE owner='$p_name'");
while($server = 'mysql_fetch_array($q_2)')
{
$s_id = $server['id'];
$s_name = $server['name'];
$whitelist = $server['whitelist'];
if($whitelist == 0){$wlist = "Отключен";}elseif($whitelist == 1){$wlist = "Включен";}
$version = $server['version'];
$v = mysql_query("SELECT * FROM version WHERE id='$version'");
$v_r = 'mysql_fetch_array($v)';
$version = $v_r['name'];
$client = $server['client'];
if($client == 0){$client = "Пиратка";}elseif($client == 1){$client = "Лицензия";}elseif($client == 2){$client = "Свой";}
$pvp = $server['pvp'];
if($pvp == 0){$pvp = "Отключен";}elseif($pvp == 1){$pvp = "Включен";}
$ip = $server['ip'];
$ip_a = explode(":",$ip);
$ip = $ip_a['0'];
$port = $ip_a['1'];

echo '
 <a href="#'.$s_name.'" class="tooltip"><span>
<font size="3"><b>'.$s_name.'</b></font>
<br>WhiteList: <b>'.$wlist.'</b>
<br>Версия: <b>'.$version.'</b></font>
<br>Клиент: <b>'.$client.'</b></font>
<br>PvP: <b>'.$pvp.'</b></font>
<br>Ip: <b>'.$ip.'</b></font>
<br>Port: <b>'.$port.'</b></font>
</span>
<img src="/b/b1.php?ip='.$ip.'&port='.$port.'"></a>';
}

echo '</td><td align="right"><a href="'.$site.'" target="_blank"><font size="2">Перейти на сайт</font></a></td></tr>
<tr>
<td align="left">
<a href="/project.php?id='.$p_id.'"><img class="cent" src="'.$banner.'"></a>
</td>
<td align="right">
<font size="2">Рейтинг: <b>'.$rating.'</b></font><br>
<font size="2">Просмотров: <b>'.$views.'</b></font>
</td></tr>
</table>
<br>
';
}
}

if ( $cnt_pages > 1 )
{
    if ( $page > 3 )
        $startpage = '<a href="index.php?page=1"><<<</a> ... ';
    else
        $startpage = '';
    if ( $page < ($cnt_pages - 2) )
        $endpage = ' ... <a href="index.php?page='.$cnt_pages.'">>>></a>';
    else
        $endpage = '';
    if ( $page - 2 > 0 )
        $page2left = ' <a href="index.php?page='.($page - 2).'">'.($page - 2).'</a> | ';
    else
        $page2left = '';
    if ( $page - 1 > 0 )
        $page1left = ' <a href="index.php?page='.($page - 1).'">'.($page - 1).'</a> | ';
    else
        $page1left = '';
    if ( $page + 2 <= $cnt_pages )
        $page2right = ' | <a href="index.php?page='.($page + 2).'">'.($page + 2).'</a>';
    else
        $page2right = '';
    if ( $page + 1 <= $cnt_pages )
        $page1right = ' | <a href="index.php?page='.($page + 1).'">'.($page + 1).'</a>';
    else
        $page1right = '';
    echo $startpage.$page2left.$page1left.'<strong>'.$page.'</strong>'.$page1right.$page2right.$endpage;
	}
include ("design/down.php");
?>