Файл: public_html/fk/konkurs.php
Строк: 210
<?
include_once '../sys/inc/start.php';
include_once '../sys/inc/compress.php';
include_once '../sys/inc/sess.php';
include_once '../sys/inc/home.php';
include_once '../sys/inc/settings.php';
include_once '../sys/inc/db_connect.php';
include_once '../sys/inc/ipua.php';
include_once '../sys/inc/fnc.php';
include_once '../sys/inc/user.php';
$set['title']='Фотоконкурс';
include_once '../sys/inc/thead.php';
$set['title']='Фотоконкурс';
title();
aut();
?>
<style>
.vpravo{float:right;}
.end{display:inline-block;overflow:hidden}
.phcmp_i{margin-right:.3em;padding:.2em .3em;text-align:center;color:#fff;background-color:#61bf01;font-size:small}
.phcmp_i{display:inline-block;padding-right:1.5em;position:relative;overflow:hidden;margin-right:0}.n
.phcmp_i:after{content:'';display:block;height:100%;width:1.5em;position:absolute;top:0;right:-.8em;background:#fff;
-webkit-transform:rotate(45deg);-moz-transform:rotate(45deg);-ms-transform:rotate(45deg);transform:rotate(45deg)}.
</style>
<?
$id = intval($_GET['id']);
$fk=mysql_fetch_assoc(mysql_query("SELECT * FROM `fk` WHERE `id` = '".$id."' "));
if(!isset($id) or $fk['name'] == null){
header("Location: index.php?".SID); }
$fk_win=mysql_fetch_assoc(mysql_query("SELECT id_user FROM `fk_foto` WHERE `id_fk` = '".$id."' and `active` = '1' and `golosov` > '0' order by `golosov` DESC limit 1 "));
$fk_win2=mysql_fetch_assoc(mysql_query("SELECT id_user FROM `fk_foto` WHERE `id_user` != '".$fk_win['id_user']."' and `id_fk` = '".$id."' and `active` = '1' and `golosov` > '0' order by `golosov` DESC limit 1 "));
$fk_win3=mysql_fetch_assoc(mysql_query("SELECT id_user FROM `fk_foto` WHERE `id_user` != '".$fk_win['id_user']."' and `id_user` != '".$fk_win2['id_user']."' and `id_fk` = '".$id."' and `active` = '1' and `golosov` > '0' order by `golosov` DESC limit 1 "));
////////// Вознаграждения ////////////
if($fk['end_time'] < $time and $fk['active'] != 0) {
mysql_query("UPDATE `fk` SET `active` = '0' where `id` = '".$id."' ");
if($fk_win['id_user'] > 0) {
mysql_query("UPDATE `user` SET `balls` = `balls`+'".$fk['pobeda']."' where `id` = '".$fk_win['id_user']."' ");
mysql_query("INSERT INTO `mail` (`id_user`, `id_kont`, `msg`, `time`)
values('0', '".$fk_win['id_user']."', 'Примите наши поздравления! Вы заняли 1 место в фотоконкурсе [url=/fk/konkurs.php?id=$id][b]$fk[name][/b][/url].
В качестве приза мы подарили Вам [b]$fk[pobeda][/b] баллов!', '$time')");
}
if($fk_win2['id_user'] > 0) {
mysql_query("UPDATE `user` SET `balls` = `balls`+'".$fk['pobeda2']."' where `id` = '".$fk_win2['id_user']."' ");
mysql_query("INSERT INTO `mail` (`id_user`, `id_kont`, `msg`, `time`)
values('0', '".$fk_win2['id_user']."', 'Примите наши поздравления! Вы заняли 2 место в фотоконкурсе [url=/fk/konkurs.php?id=$id][b]$fk[name][/b][/url].
В качестве приза мы подарили Вам [b]$fk[pobeda2][/b] баллов!', '$time')");
}
if($fk_win3['id_user'] > 0) {
mysql_query("UPDATE `user` SET `balls` = `balls`+'".$fk['pobeda3']."' where `id` = '".$fk_win3['id_user']."' ");
mysql_query("INSERT INTO `mail` (`id_user`, `id_kont`, `msg`, `time`)
values('0', '".$fk_win3['id_user']."', 'Примите наши поздравления! Вы заняли 3 место в фотоконкурсе [url=/fk/konkurs.php?id=$id][b]$fk[name][/b][/url].
В качестве приза мы подарили Вам [b]$fk[pobeda3][/b] баллов!', '$time')");
}
}
///////////////////////////////
if($fk['images'] == null) { $images = '<img src="img/not.png" alt="*" class="image" align="left" height="50" width="50" style="margin: -4px 8px 1px 0px;"/>'; }
else { $images = '<img src="images/'.$fk['images'].'" alt="*" class="image" align="left" height="50" width="50" style="margin: -4px 8px 1px 0px;"/>'; }
if($fk['active'] == 0) { $end = '<span class="end">завершен</span>'; }
elseif($fk['active'] == 3) { $end = '<span class="end">голосование закрыто</span>'; }
elseif($fk['active'] == 1) { $end = '<span class="end">активен</span>'; }
echo'<div class="mess">
'.$images.'
<body class="noscroll n fixe"> <span class="phcmp_i">Конкурс</span>'.$end.'
<br/>'.$fk['name'].'<br/></div>';
echo '<div class="main_menu"><img src="img/infor.png"><a href="info_fk.php?id='.$id.'"> Информация о фотоконкурсе </a></div>';
$dcs = mysql_result(mysql_query("SELECT COUNT(*) FROM `fk_discus` WHERE `id_fk` = '".$id."' "), 0);
echo '<div class="main_menu"><img src="img/comm.png"><a href="discus.php?id='.$id.'"> Обсуждения </a> ('.$dcs.')</div>';
if(isset($user))
echo '<div class="main_menu"><img src="img/who.png"><a href="add_foto.php?id='.$id.'"> Добавить фото </a></div>';
$sk = mysql_result(mysql_query("SELECT COUNT(*) FROM `fk_foto` WHERE `id_fk` = '".$id."' "), 0);
echo '<div class="main_menu"><img src="img/info.png"><a href="members.php?id='.$id.'"> Фото участников </a> ('.$sk.')</div>';
if($fk['active'] == 0)
{echo '<div class="main"> Победители:</div>';}
else
{echo '<div class="main"> Случайные фото:</div>';}
if($fk['active'] != 0) { $ft = 'order by rand() limit 3'; }
else {
if($fk_win['id_user'] > 0 and $fk_win2['id_user'] > 0 and $fk_win3['id_user'] > 0) { $sk2 = 3; }
elseif($fk_win['id_user'] > 0 and $fk_win2['id_user'] > 0) { $sk2 = 2; }
elseif($fk_win['id_user'] > 0 and $fk_win3['id_user'] > 0) { $sk2 = 2; }
elseif($fk_win2['id_user'] > 0 and $fk_win3['id_user'] > 0) { $sk2 = 2; }
else { $sk2 = 1; }
$ft = "order by `golosov` DESC limit $sk2"; }
// Фото участников
$proverka3 = mysql_result(mysql_query("SELECT COUNT(id_fk) FROM `fk_golos` WHERE `id_fk` = '".$id."' and `id_user` = '".$user['id']."' "),0);
$q=mysql_query("SELECT * FROM `fk_foto` WHERE `id_fk` = '".$id."' $ft ");
while ($res = mysql_fetch_array($q)) {
$proverka = mysql_result(mysql_query("SELECT COUNT(id_foto) FROM `fk_golos` WHERE `id_foto` = '".$res['id']."' and `id_user` = '".$user['id']."' "),0);
if($fk_win['id_user'] == $res['id_user']) { echo '<span class="vpravo"><img src="img/win.png"></span>'; }
if($fk_win2['id_user'] == $res['id_user']) { echo '<span class="vpravo"><img src="img/win2.png"></span>'; }
if($fk_win3['id_user'] == $res['id_user']) { echo '<span class="vpravo"><img src="img/win3.png"></span>'; }
if(isset($user['id']) and $res['id_user'] != $user['id'] and $proverka == 0 and $proverka3 < $fk['skolko'] and $res['active'] == 1 and $fk['active'] == 1) { $golosov = '<a href="?id='.$id.'&golos='.$res['id'].'"><img src="img/golos.png"> Голосовать</a>'; }
elseif($res['active'] == 0) {$golosov = '<font color="red">заблокировано</font>';}
elseif ( $proverka == 1 ) { $golosov = '<img src="img/golos.png"> Ваш голос учтен!'; }
elseif (!isset($user['id']) or $res['id_user'] == $user['id'] or $fk['active'] == 0 or $fk['active'] == 3 or $proverka3 == $fk['skolko']) { $golosov = ''; }
echo '<div class="mess"><a href="foto.php?id='.$res['id'].'"><img src="images/'.$res['images'].'" alt="*" class="image"
align="left" height="50" width="50" style="margin: -5px 8px 1px 0px;"/></a> <span class="page"><img src="img/top.png"> '.$res['golosov'].'</span> голосов
<br/> '.$golosov.' <br/> </div>';
}
////////////////
if ($fk['active'] != 0 and $sk == 0)
{
echo '<div class="err">Никто не добавил фотографию! Будьте первыми ;) </div>';
}
elseif ($fk['active'] == 0 and $sk == 0)
{
echo '<div class="err">Победителей нет :( </div>';
}
if(isset($_GET['golos'])) {
$proverka = mysql_result(mysql_query("SELECT COUNT(*) FROM `fk_golos` WHERE `id_foto` = '".intval($_GET['golos'])."' and `id_user` = '".$user['id']."' "),0);
$fk_foto=mysql_fetch_assoc(mysql_query("SELECT * FROM `fk_foto` WHERE `id` = '".intval($_GET['golos'])."' "));
if(isset($user['id']) and $fk_foto['id_user'] != $user['id'] and $proverka == 0 and $proverka3 < 3 and $fk_foto['active'] == 1 and $fk['active'] == 1)
{
mysql_query("INSERT INTO `fk_golos` (`id_foto`, `id_fk`, `id_user`, `time`) values ('".intval($_GET['golos'])."', '".$id."', '".$user['id']."', '".$time."')");
mysql_query("INSERT INTO `mail` (`id_user`, `id_kont`, `msg`, `time`)
values('0', '".$fk_foto['id_user']."', 'За ваше фото проголосовали в фотоконкурсе [url=/fk/foto.php?id=$_GET[golos]][b]$fk[name][/b][/url]', '$time')");
$vsego = mysql_result(mysql_query("SELECT COUNT(*) FROM `fk_golos` WHERE `id_foto` = '".intval($_GET['golos'])."' "),0);
mysql_query("UPDATE `user` SET `balls` = `balls`+'".$fk['golosue']."' where `id` = '".$user['id']."' ");
mysql_query("UPDATE `fk_foto` SET `golosov` = '".$vsego."' where `id` = '".intval($_GET['golos'])."' ");
header("Location: konkurs.php?id=".$id."".SID);
}
}
echo '<div class="foot"><img src="img/fk.png"> <a href="index.php">Фотоконкурсы</a></div>';
err();
include_once '../sys/inc/tfoot.php';
?>