Файл: duels.php
Строк: 169
<?php
require 'sid.php';
require 'config.php';
$link = connect_db();
list($user, $id, $ps) = check_login($link);
whorm(0, 'duels');
include 'head.php';
include 'navigator.php';
echo $div_title . ''.$lang['Фото-дуэли'].'' . $div_end . $div_left;
function timeLeft($t)
{
$t2 = $t - time();
if ($t2 > (60 * 60 * 24)) $t3 = round($t2 / (60 * 60 * 24)) . ' d.';
elseif ($t2 > (60 * 60)) $t3 = round($t2 / (60 * 60)) . ' h.';
elseif ($t2 > 60) $t3 = round($t2 / 60) . ' m.';
else $t3 = $t2 . ' s.';
return $t3;
}
$outOfTime = mysql_query("SELECT * FROM duels WHERE time < '" . time() . "' AND stat = '1'");
if (mysql_num_rows($outOfTime) != false)
{
$sqli = mysql_fetch_array($outOfTime);
$inVotes = mysql_fetch_array(mysql_query("SELECT vote_1, vote_2 FROM v_duels WHERE uid = '$sqli[id]' LIMIT 1"));
mysql_query("UPDATE duels SET stat = '0' WHERE id = '$sqli[id]' LIMIT 1");
if ($inVotes[0] > $inVotes[1])
{
mysql_query("UPDATE users SET duel_win = duel_win + '1', balls = balls + '300' WHERE id = '$sqli[user_1]' LIMIT 1");
mysql_query("UPDATE users SET duel_lose = duel_lose + '1' WHERE id = '$sqli[user_2]' LIMIT 1");
#####################
$msg_1 = $sqli['user_1'] . ' '.$lang['вы выиграли'].' <a href="/duels.php?lg='.$lg.'">'.$lang['дуэль'].'</a>.';
$msg_2 = $sqli['user_2'] . ' '.$lang['вы проиграли'].' <a href="/duels.php?lg='.$lg.'">'.$lang['дуэль'].'</a>.';
mysql_query("INSERT INTO `lenta` SET
`user` = '$sqli[user_1]',
`text` = '$msg_1',
`type` = 'comments',
`date` = '" . time() . "',
`read` = '1'");
mysql_query("INSERT INTO `lenta` SET
`user` = '$sqli[user_2]',
`text` = '$msg_2',
`type` = 'comments',
`date` = '" . time() . "',
`read` = '1'");
#####################
header('Location: ?lg='.$lg.'');
}
if ($inVotes[0] < $inVotes[1])
{
mysql_query("UPDATE users SET duel_win = duel_win + '1', balls = balls + '300' WHERE id = '$sqli[user_2]' LIMIT 1");
mysql_query("UPDATE users SET duel_lose = duel_lose + '1' WHERE id = '$sqli[user_1]' LIMIT 1");
#####################
$msg_1 = $sqli['user_1'] . ' '.$lang['вы выиграли'].' <a href="/duels.php?lg='.$lg.'">'.$lang['дуэль'].'</a>.';
$msg_2 = $sqli['user_2'] . ' '.$lang['вы проиграли'].' <a href="/duels.php?lg='.$lg.'">'.$lang['дуэль'].'</a>.';
mysql_query("INSERT INTO `lenta` SET
`user` = '$sqli[user_1]',
`text` = '$msg_2',
`type` = 'comments',
`date` = '" . time() . "',
`read` = '1'");
mysql_query("INSERT INTO `lenta` SET
`user` = '$sqli[user_2]',
`text` = '$msg_1',
`type` = 'comments',
`date` = '" . time() . "',
`read` = '1'");
#####################
header('Location: ?lg='.$lg.'');
}
}
$do = isset($_GET['do']) ? $_GET['do'] : NULL;
switch($do) {
default:
if (isset($_GET['id']))
{
$id = my_int($_GET['id']);
$sql = mysql_query("SELECT * FROM duels WHERE user_1 = '$id' AND stat = '1' OR user_2 = '$id' AND stat = '1' LIMIT 1");
if (mysql_num_rows($sql) != false)
{
$is = mysql_fetch_assoc($sql);
if ($is['user_1'] == $id) $vt = 'vote_1';
if ($is['user_2'] == $id) $vt = 'vote_2';
$double = mysql_query("SELECT id FROM v_duels WHERE uid = '$is[id]' AND who = '$user[id]' LIMIT 1");
if (mysql_num_rows($double) == false)
{
mysql_query("INSERT INTO v_duels SET $vt = '1', who = '$user[id]', uid = '$is[id]'");
$msg_J = $user['user'] . ' '.$lang['проголосовал за вас в'].' <a href="/duels.php?lg='.$lg.'">'.$lang['дуэлях'].'</a>.';
mysql_query("INSERT INTO `lenta` SET
`user` = '$id',
`text` = '$msg_J',
`type` = 'comments',
`date` = '" . time() . "',
`read` = '1'");
}
header('Location: ?lg='.$lg.'');
}
else
{
header('Location: ?lg='.$lg.'');
die();
}
unset($sql);
}
$sql = mysql_query("SELECT duels .*,
(SELECT SUM(vote_1) FROM v_duels WHERE v_duels.uid = duels.id) AS t1,
(SELECT SUM(vote_2) FROM v_duels WHERE v_duels.uid = duels.id) AS t2
FROM duels WHERE stat = '1' ORDER BY RAND() DESC LIMIT 1");
echo $div_menu . '» <a href="?do=top_win&lg='.$lg.'">'.$lang['Топ по победам'].'</a><br/>
» <a href="?do=top_lose&lg='.$lg.'">'.$lang['Топ по поражениям'].'</a><br/>' . $div_end;
if (mysql_num_rows($sql) != false)
{
$a = mysql_fetch_assoc($sql);
$votes_1 = ($a['t1'] != 0) ? $a['t1'] : 0;
$votes_2 = ($a['t2'] != 0) ? $a['t2'] : 0;
echo us($a['user_1']) . ' <b>VS</b> ' . us($a['user_2']) . $block . '
<img src="'.$a['img_1'].'" width="80" height="80" alt=""/>
<br/>
<a href="?id='.$a['user_1'].'&lg='.$lg.'">'.$lang['Голосовать'].'</a> (' . $votes_1 . ')
<br/>
<img src="'.$a['img_2'].'" width="80" height="80" alt=""/>
<br/>
<a href="?id='.$a['user_2'].'&lg='.$lg.'">'.$lang['Голосовать'].'</a> (' . $votes_2 . ')
<br/>
'.$lang['До завершения'].': ' . timeLeft($a['time']) . '
<br/>
»»<a href="?lg='.$lg.'">'.$lang['Следующая дуэль'].'</a>
<br/>';
} else {
echo ''.$lang['Активных дуэлей нет'].'.<br/>';
}
echo ''.$lang['Активные дуэли'].'<br/>
<a href="?do=end_d&lg='.$lg.'">'.$lang['Завершенные дуэли'].'</a>';
break;
case end_d:
$count = mysql_result(mysql_query("SELECT COUNT(id) FROM duels WHERE stat = '0'"), 0);
if ($count != 0)
{
$n = new navigator($count, 10, '?do=end_d&lg='.$lg.'&');
$sql = mysql_query("SELECT duels .*,
(SELECT SUM(vote_1) FROM v_duels WHERE v_duels.uid = duels.id) AS t1,
(SELECT SUM(vote_2) FROM v_duels WHERE v_duels.uid = duels.id) AS t2
FROM duels WHERE stat = '0' ORDER BY id DESC {$n->limit}");
while($a = mysql_fetch_assoc($sql))
{
$votes_1 = ($a['t1'] != 0) ? $a['t1'] : 0;
$votes_2 = ($a['t2'] != 0) ? $a['t2'] : 0;
if ($votes_1 > $votes_2) $win_1 = '<b style="color:#FF0000;">'.$lang['Победитель'].'</b>';
if ($votes_1 < $votes_2) $win_2 = '<b style="color:#FF0000;">'.$lang['Победитель'].'</b>';
echo $div_tworazdel . '<div style="text-align: center; background-color: #D1FFE8;">
<img src="'.$a['img_1'].'" width="50" height="50" alt=""/> <img src="'.$a['img_2'].'" width="50" height="50" alt=""/></div>
<br/>
' . us($a['user_1']) . $votes_1 . '
<b>VS</b>
' . us($a['user_2']) . $votes_2 . '
<br/>' . $div_end;
}
echo $n->navi();
} else {
echo ''.$lang['Завершенных дуэлей нет'].'.<br/>';
}
echo ''.$lang['Завершенные дуэли'].'<br/>
<a href="?lg='.$lg.'">'.$lang['Активные дуэли'].'</a><br/>';
break;
case invite:
$nk = my_int($_GET['nk']);
$sql = mysql_query("SELECT * FROM duels WHERE user_1 = '$user[id]' AND user_2 = '$nk' OR user_1 = '$nk' AND user_2 = '$user[id]' LIMIT 1");
$int = mysql_fetch_assoc($sql);
if (!user_inf($nk)) {
echo ''.$lang['Пользователь не найден'].'!<br/>';
} elseif (empty($user['img'])) {
echo ''.$lang['Вы должны установить аватар для участия'].'!<br/>';
} elseif ($int['interval'] > time()) {
echo ''.$lang['Вы сможете пригласить этого человека не раньше, чем через 3 часа'].'!<br/>';
} elseif (mysql_num_rows($sql) != false) {
echo ''.$lang['Ошибка'].'!<br/>';
} else {
$na = 3 * 120 * 24;
$na = time() + $na;
$inter = 3 * 60;
$inter = time() + $inter;
mysql_query("INSERT INTO duels SET user_1 = '$user[id]', user_2 = '$nk', img_1 = '$user[img]', stat = '2', time = '$na', `interval` = '$inter'");
$msg_J = $user['user'] . ' '.$lang['вызывает вас на'].' <a href="/duels.php?do=select&lg='.$lg.'">'.$lang['дуэль'].'</a>.';
mysql_query("INSERT INTO `lenta` SET
`user` = '$nk',
`text` = '$msg_J',
`type` = 'comments',
`date` = '" . time() . "',
`read` = '1'");
msg(''.$lang['Приглашение выслано'].'.');
}
break;
case select:
$sql = mysql_query("SELECT id, user_1 FROM duels WHERE user_2 = '$user[id]' AND stat = '2' LIMIT 1");
if (isset($_GET['yes']))
{
if (empty($user['img'])) {
echo ''.$lang['Вы должны установить аватар для участия'].'!<br/>';
} else {
$yes = my_int($_GET['yes']);
$empty = mysql_query("SELECT id FROM duels WHERE id = '$yes' AND user_2 = '$user[id]' AND stat = '2' LIMIT 1");
if (mysql_num_rows($empty) != false)
{
mysql_query("UPDATE duels SET stat = '1', img_2 = '$user[img]', ind = '" . time() . "' WHERE user_2 = '$user[id]' AND stat = '2' LIMIT 1");
$Is = mysql_fetch_array(mysql_query("SELECT user_1 FROM duels WHERE user_2 = '$user[id]' AND stat = '2' LIMIT 1"));
$msg_J = $user['nick'] . ' '.$lang['принял вашу заявку в'].' <a href="/duels.php?lg='.$lg.'">'.$lang['дуэлях'].'</a>.';
mysql_query("INSERT INTO `lenta` SET
`user` = '$Is[0]',
`text` = '$msg_J',
`type` = 'comments',
`date` = '" . time() . "',
`read` = '1'");
}
header('Location: ?lg='.$lg.'');
}
}
if (isset($_GET['no']))
{
$no = my_int($_GET['no']);
$empty = mysql_query("SELECT id, user_id FROM duels WHERE id = '$no' AND user_2 = '$user[id]' AND stat = '2' LIMIT 1");
if (mysql_num_rows($empty) != false)
{
mysql_query("DELETE FROM duels WHERE user_2 = '$user[id]' AND stat = '2' LIMIT 1");
$Is = mysql_fetch_array(mysql_query("SELECT user_1 FROM duels WHERE user_2 = '$user[id]' AND stat = '2' LIMIT 1"));
$msg_J = $user['nick'] . ' '.$lang['отказался от вашей заявки в'].' <a href="/duels.php?lg='.$lg.'">'.$lang['дуэлях'].'</a>.';
mysql_query("INSERT INTO `lenta` SET
`user` = '$Is[0]',
`text` = '$msg_J',
`type` = 'comments',
`date` = '" . time() . "',
`read` = '1'");
mysql_query("DELETE FROM v_duels WHERE uid = '$no'");
header('Location: ?lg='.$lg.'');
} else {
header('Location: ?lg='.$lg.'');
}
}
if (mysql_num_rows($sql) == false)
{
echo ''.$lang['У вас нет непринятых вызовов'].'!<br/>';
} else {
echo ''.$lang['Вас вызывают на дуэль'].':<br/>';
while($a = mysql_fetch_assoc($sql))
{
echo us($a['user_1']) . ' <a href="?do=select&yes='.$a['id'].'&lg='.$lg.'">'.$lang['принять'].'</a> |
<a href="?do=select&no='.$a['id'].'&lg='.$lg.'">'.$lang['отклонить'].'</a><br/>';
}
}
break;
case top_win:
$top = mysql_query("SELECT id, duel_win, img FROM users WHERE duel_win > '0' ORDER BY duel_win DESC LIMIT 10");
if (mysql_num_rows($top) != false)
{
while($a = mysql_fetch_assoc($top))
{
echo '<img src="resize.php?img='.$a['img'].'&width=75&height=0" alt=""/>';
echo '<a href="/'.$a['id'].'&lg='.$lg.'">' . cvetnik($a['id']) . '</a> (' . $a['duel_win'] . ' '.$lang['побед'].')<br/>';
}
} else {
echo ''.$lang['Топ пуст'].'.<br/>';
}
break;
case top_lose:
$top = mysql_query("SELECT id, duel_lose, img FROM users WHERE duel_lose > '0' ORDER BY duel_lose DESC LIMIT 10");
if (mysql_num_rows($top) != false)
{
while($a = mysql_fetch_assoc($top))
{
echo '<img src="resize.php?img='.$a['img'].'&width=75&height=0" alt=""/>';
echo '<a href="info.php?id='.$a['id'].'&lg='.$lg.'">' . cvetnik($a['id']) . '</a> (' . $a['duel_lose'] . ' '.$lang['поражений'].')<br/>';
}
} else {
echo ''.$lang['Топ пуст'].'.<br/>';
}
break;
}
include 'foot.php';
?>