<? include "header.php"; ?>
<h3>Лидеры нашего проекта</h3>
<fieldset><font color="#000000"><legend>Топ 5 лучших кликеров</legend></font>
<center>
<table width=100%>
<?
require "config.php";
$mysql_queries++;
$sql = "SELECT * FROM tb_users order by visits desc limit 5";
$result = mysql_query($sql);
while($stat=mysql_fetch_array($result)){
echo "
<td width=110px align=center>
<b>$stat[username]</b>
<br>
<img src='avp/$stat[avatar]' width=100px height=100px>
<br>Просмотрел: $stat[visits]шт.
</td>
";}

?></table></center></fieldset>
<br>
<fieldset><font color="#000000"><legend><b>Топ 5 лучших рефоводов</b></legend></font>
<center>
<table width=100%>
<?
$sql = "SELECT *,cast(referals as signed) as refs FROM tb_users order by refs desc limit 5";
$result = mysql_query($sql);
while($stat=mysql_fetch_array($result)){
echo "
<td width=110px align=center>
<b>$stat[username]</b>
<br>
<img src='avp/$stat[avatar]' width=100px height=100px>
<br>Рефералов: $stat[referals]шт.
</td>
";
}?>
</table></center></fieldset>
<?php
include "footer.php";?>

<? include('liders.php'); ?>