Файл: photo_battle/activ_battles.php
Строк: 84
<?php
include_once '../sys/inc/home.php';
include_once H.'sys/inc/start.php';
include_once H.'sys/inc/compress.php';
include_once H.'sys/inc/sess.php';
include_once H.'sys/inc/settings.php';
include_once H.'sys/inc/db_connect.php';
include_once H.'sys/inc/ipua.php';
include_once H.'sys/inc/fnc.php';
include_once H.'sys/inc/user.php';
$set['title']="Все активные баттлы";
include_once H.'sys/inc/thead.php';
title();
aut();
include_once H.'photo_battle/includes/configuration.php';
$k_post = mysql_result(mysql_query("SELECT COUNT(*) FROM `photo_battle` WHERE `activ` = '1'"),0);
$k_page = k_page($k_post,1);
$page = page($k_page);
$start = 1 * $page - 1;
if ($k_post == 0){
echo '<div class="mess">Нет активных баттлов</div>';
}
$q = mysql_query("SELECT * FROM `photo_battle` WHERE `activ` ='1' ORDER BY `id` DESC LIMIT $start, 1");
while($battle = mysql_fetch_array($q)){
$ank1=get_user($battle['id_user1']);
$ank2=get_user($battle['id_user2']);
$ank3=get_user($battle['id_user3']);
if (isset($_GET['vot1']) && isset($user) && $user['id']!=$battle['id_user1'] && mysql_result(mysql_query("SELECT SUM(`golos`) FROM `photo_battle_golos` WHERE `id_user` = '$user[id]' AND `id_battle` = '$battle[id]'"),0)!=1){
mysql_query("UPDATE `user` SET `balls` = '".($user['balls']+5)."' WHERE `id` = '$user[id]' LIMIT 1");
mysql_query("INSERT INTO `photo_battle_golos` (`golos`, `id_battle`, `id_user`) VALUES ('1','$battle[id]','$user[id]')");
mysql_query("UPDATE `photo_battle` SET `golos1` = '".($battle['golos1']+1)."' WHERE `id` = '$battle[id]' LIMIT 1");
header("location:?page=$page&$passgen");
}
if (isset($_GET['vot2']) && isset($user) && $user['id']!=$battle['id_user2'] && mysql_result(mysql_query("SELECT SUM(`golos`) FROM `photo_battle_golos` WHERE `id_user` = '$user[id]' AND `id_battle` = '$battle[id]'"),0)!=1){
mysql_query("UPDATE `user` SET `balls` = '".($user['balls']+5)."' WHERE `id` = '$user[id]' LIMIT 1");
mysql_query("INSERT INTO `photo_battle_golos` (`golos`, `id_battle`, `id_user`) VALUES ('1','$battle[id]','$user[id]')");
mysql_query("UPDATE `photo_battle` SET `golos2` = '".($battle['golos2']+1)."' WHERE `id` = '$battle[id]' LIMIT 1");
header("location:?page=$page&$passgen");
}
if (isset($_GET['vot3']) && isset($user) && $user['id']!=$battle['id_user3'] && mysql_result(mysql_query("SELECT SUM(`golos`) FROM `photo_battle_golos` WHERE `id_user` = '$user[id]' AND `id_battle` = '$battle[id]'"),0)!=1){
mysql_query("UPDATE `user` SET `balls` = '".($user['balls']+5)."' WHERE `id` = '$user[id]' LIMIT 1");
mysql_query("INSERT INTO `photo_battle_golos` (`golos`, `id_battle`, `id_user`) VALUES ('1','$battle[id]','$user[id]')");
mysql_query("UPDATE `photo_battle` SET `golos3` = '".($battle['golos3']+1)."' WHERE `id` = '$battle[id]' LIMIT 1");
header("location:?page=$page&$passgen");
}
echo "<div class='mess'><a href='/info.php?id=$ank1[id]'><b>$ank1[nick]</b></a></div><div class='nav2'><table><td><img src='/photo_battle/images/$battle[img1].png' alt='' style='width:50px;height:50px;'></td><td><a href='/photo_battle/images/$battle[img1].png'>Просмотреть фотографию</a><br/><b>Голосов $battle[golos1] </b>";
if (isset($user) && $user['id']!=$battle['id_user1'] && mysql_result(mysql_query("SELECT SUM(`golos`) FROM `photo_battle_golos` WHERE `id_user` = '$user[id]' AND `id_battle` = '$battle[id]'"),0)!=1)echo "<a href='?page=$page&vot1'>Голосовать</a>";
echo "</td></table></div>";
echo "<div class='mess'><a href='/info.php?id=$ank2[id]'><b>$ank2[nick]</b></a></div><div class='nav1'><table><td><img src='/photo_battle/images/$battle[img2].png' alt='' style='width:50px;height:50px;'></td><td><a href='/photo_battle/images/$battle[img2].png'>Просмотреть фотографию</a><br/><b>Голосов $battle[golos2] </b>";
if (isset($user) && $user['id']!=$battle['id_user2'] && mysql_result(mysql_query("SELECT SUM(`golos`) FROM `photo_battle_golos` WHERE `id_user` = '$user[id]' AND `id_battle` = '$battle[id]'"),0)!=1)echo "<a href='?page=$page&vot2'>Голосовать</a>";
echo "</td></table></div>";
echo "<div class='mess'><a href='/info.php?id=$ank3[id]'><b>$ank3[nick]</b></a></div><div class='nav2'><table><td><img src='/photo_battle/images/$battle[img3].png' alt='' style='width:50px;height:50px;'></td><td><a href='/photo_battle/images/$battle[img3].png'>Просмотреть фотографию</a><br/><b>Голосов $battle[golos3] </b>";
if (isset($user) && $user['id']!=$battle['id_user3'] && mysql_result(mysql_query("SELECT SUM(`golos`) FROM `photo_battle_golos` WHERE `id_user` = '$user[id]' AND `id_battle` = '$battle[id]'"),0)!=1)echo "<a href='?page=$page&vot3'>Голосовать</a>";
echo "</td></table></div>";
echo "<div class='mess'>Баттл закончится ".vremja($battle['time'])."</div>";
}
if ($k_page>1)str("?",$k_page,$page);
echo "<div class='foot'><img src='/style/icons/str.gif' alt=''><a href='/photo_battle/'> Баттлы фотографий</a></div>";
if (isset($user)){
echo "<div class='foot'><img src='/style/icons/str.gif' alt=''><a href='/photo_battle/my_battle.php'> Мой баттл</a></div>";
echo "<div class='foot'><img src='/style/icons/str.gif' alt=''><a href='/photo_battle/new_battle.php'> Создать баттл</a></div>";
echo "<div class='foot'><img src='/style/icons/str.gif' alt=''><a href='/photo_battle/my_finish_battles.php'> Мои завершенные баттлы $my_finish</a></div>";
}
echo "<div class='foot'><img src='/style/icons/str.gif' alt=''><a href='/photo_battle/expect_battles.php'> Ожидают противников $expect</a></div>";
echo "<div class='foot'><img src='/style/icons/str.gif' alt=''><a href='/photo_battle/finish_battles.php'> Все завершенные баттлы $finish</a></div>";
include_once H.'sys/inc/tfoot.php';
?>