Файл: www/love/index.php
Строк: 23
<?
include '../config.php';
div('Знакомства');
echo '<div class="msg1">Всего анкет: '. mysql_result(mysql_query("SELECT COUNT(*) FROM `users`"), 0).'</div>';
echo '<img src="img/search.png"> <a href="../user_search.php">Поиск друзей</a><br/>
<img src="img/female.png"> <a href="female.php">Девушек</a> ('.mysql_result(mysql_query("SELECT COUNT(*) FROM `users` WHERE `pol`='1'"), 0).')<br/>
<img src="img/male.png"> <a href="male.php">Парней</a> ('.mysql_result(mysql_query("SELECT COUNT(*) FROM `users` WHERE `pol`='0'"), 0).')';
if(mysql_result(mysql_query("SELECT COUNT(*) FROM `users`"), 0)==0){
echo '<div class="msg1">Пользователей нет</div>';
}else{
if(mysql_result(mysql_query("SELECT COUNT(*) FROM `users` WHERE `pol`='1'"), 0)==0){
echo '<div class="msg1">Девушек нет</div>';
}else{
echo '<div class="msg2">Лучшая девушка:<br/>';
$female = mysql_fetch_array(mysql_query("SELECT * FROM `users` WHERE `pol`='1' ORDER BY `count_post` DESC LIMIT 1"));
$photo0=mysql_fetch_array(mysql_query("SELECT * FROM `alb_photo` WHERE `id_user`='$female[id]' AND `status`='1' LIMIT 1"));
if(!empty($photo0[0])){
echo '<img src="../album/pic.php?id='.$photo0['id'].'">';}
echo '<br/>Логин: <a href="../info.php?id='.$female['id'].'">'.$female['login'].'</a><br/>';
$p1=mysql_fetch_array(mysql_query("SELECT SUM(count) FROM `rt_user_plus` WHERE `id_rait`='$female[id]'"));
$m1=mysql_fetch_array(mysql_query("SELECT SUM(count) FROM `rt_user_minus` WHERE `id_rait`='$female[id]'"));
echo 'Рейтинг: '.intval($p1[0]).'/'.intval($m1[0]).'</div>';}
if(mysql_result(mysql_query("SELECT COUNT(*) FROM `users` WHERE `pol`='0'"), 0)==0){
echo '<div class="msg1">Парней нет</div>';
}else{
echo '<div class="msg1">Лучший парень:<br/>';
$male=mysql_fetch_array(mysql_query("SELECT * FROM `users` WHERE `pol`='0' ORDER BY `count_post` DESC LIMIT 1"));
$photo1=mysql_fetch_array(mysql_query("SELECT * FROM `alb_photo` WHERE `id_user`='$male[id]' AND `status`='1' LIMIT 1"));
if(!empty($photo1[0])){
echo '<img src="../album/pic.php?id='.$photo1['id'].'">';}
echo '<br/>Логин: <a href="../info.php?id='.$male['id'].'">'.$male['login'].'</a><br/>';
$p0=mysql_fetch_array(mysql_query("SELECT SUM(count) FROM `rt_user_plus` WHERE `id_rait`='$male[id]'"));
$m0=mysql_fetch_array(mysql_query("SELECT SUM(count) FROM `rt_user_minus` WHERE `id_rait`='$male[id]'"));
echo 'Рейтинг: '.intval($p0[0]).'/'.intval($m0[0]).'</div>';}}
echo '</div>';
include '../foot.php';
echo '</div>';
?>