File size: 1.99Kb
<?php
$set['title'] = "Гаремы";
include_once H.'sys/inc/thead.php';
title();
aut();
echo "<div class='main2'><center>Самая популярна девушка</center></div>";
$w=mysql_query("SELECT * FROM `user` WHERE `pol`='0' ORDER BY`harem_count` DESC LIMIT 1");
while($woman=mysql_fetch_array($w)){
echo "<div class='mess'><table><td>";
echo "".status($woman['id'])."";
echo "</td><td>";
echo " ".group($woman['id'])." <a href='/info.php?id=$woman[id]' title='Анкета $woman[nick]'>$woman[nick]</a>";
echo medal($woman['id'])." ".online($woman['id']);
echo "<br/>Украдена $woman[harem_count]<br/></td></table></div>";
}
echo "<div class='main2'><center>Самый популярный парень</center></div>";
$m=mysql_query("SELECT * FROM `user` WHERE `pol`='1' ORDER BY`harem_count` DESC LIMIT 1");
while($man=mysql_fetch_array($m)){
echo "<div class='mess'><table><td>";
echo "".status($man['id'])."";
echo "</td><td>";
echo " ".group($man['id'])." <a href='/info.php?id=$man[id]' title='Анкета $man[nick]'>$man[nick]</a>";
echo medal($man['id'])." ".online($man['id']);
echo "<br/>Украден $man[harem_count]<br/></td></table></div>";
}
echo "<div class='main2'><a href='?top_harems'><img src='/style/icons/str.gif' alt='W'> Топ гаремов (".mysql_result(mysql_query("SELECT COUNT(*) FROM `user` WHERE `harem_users` > '0'"), 0).") </a></div>";
echo "<div class='main2'><a href='?top_users'><img src='/style/icons/str.gif' alt='W'> Топ украденых (".mysql_result(mysql_query("SELECT COUNT(*) FROM `user` WHERE `harem_count` > '0'"), 0).") </a></div>";
if (isset($user))echo "<div class='main2'><a href='?user_harem=$user[id]'><img src='/style/icons/str.gif' alt='W'> Мой гарем (".mysql_result(mysql_query("SELECT COUNT(*) FROM `user` WHERE `harem_user` = '$user[id]'"), 0).") </a></div>";
if (isset($user))echo "<div class='main2'><a href='?settings'><img src='/style/icons/str.gif' alt='W'> Мои настройки </a></div>";
?>