<?
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';
if (mysql_result(mysql_query("SELECT COUNT(*) FROM `pianica_info` WHERE `id_user` = '$user[id]' LIMIT 1"),0)==0)
{
mysql_query("INSERT INTO `pianica_info` (`id_user`) values('$user[id]')");
}
$set['title']='Пьяница'; // заголовок страницы
include_once '../../sys/inc/thead.php';
echo '<link rel="stylesheet" href="style/css.css" type="text/css"/>';
title();
aut();
echo "<div class='fon'>";
if (isset($user))
{
$game=mysql_fetch_assoc(mysql_query("SELECT * FROM `pianica` WHERE `id_user` = '$user[id]' OR `id_prot` = '$user[id]'"));
if ((isset($user)) && ($game['status']==1 || $game['status']==2 || $game['status']==3 || $game['status']==4 || $game['status']==5))
{
if (isset($_POST['msg']) && isset($user))
{
$msg=$_POST['msg'];
if (isset($_POST['translit']) && $_POST['translit']==1)$msg=translit($msg);
$mat=antimat($msg);
if ($mat)$err[]='В тексте сообщения обнаружен мат: '.$mat;
if (strlen2($msg)>512){$err='Сообщение слишком длинное';}
elseif (strlen2($msg)<1){$err='Короткое сообщение';}
elseif (mysql_result(mysql_query("SELECT COUNT(*) FROM `pianica_chat` WHERE `id_game` = '$game[id]' AND `id_user` = '$user[id]' AND `msg` = '".my_esc($msg)."' LIMIT 1"),0)!=0){$err='Ваше сообщение повторяет предыдущее';}
elseif(!isset($err)){
mysql_query("INSERT INTO `pianica_chat` (`id_user`, `time`, `msg`, `id_game`) values('$user[id]', '$time', '".my_esc($msg)."', '$game[id]')");
mysql_query("UPDATE `user` SET `balls` = '".($user['balls']+1)."' WHERE `id` = '$user[id]' LIMIT 1");
msg('Ваш комментарий успешно принят');
}
}
$avtor = get_user($game['id_user']);
$prot = get_user($game['id_prot']);
$login_avtor=mysql_fetch_assoc(mysql_query("SELECT * FROM `pianica_info` WHERE `id_user` = $avtor[id] LIMIT 1"));
$login_prot=mysql_fetch_assoc(mysql_query("SELECT * FROM `pianica_info` WHERE `id_user` = $prot[id] LIMIT 1"));
$count_avtor = mysql_result(mysql_query("SELECT COUNT(*) FROM `pianica_game` WHERE `id_user` = '$avtor[id]' AND `on` = '0' AND `id_game` = '".$game['id']."'"),0);
$count_prot = mysql_result(mysql_query("SELECT COUNT(*) FROM `pianica_game` WHERE `id_user` = '$prot[id]' AND `on` = '0' AND `id_game` = '".$game['id']."'"),0);
$game_my = mysql_result(mysql_query("SELECT COUNT(*) FROM `pianica` WHERE `id_user` = '$user[id]' OR `id_prot` = '$user[id]'"),0);
if (($prot['url']=='/plugins/pianica/game.php' || $prot['url']=='/plugins/pianica/index.php') && (mysql_result(mysql_query("SELECT COUNT(*) FROM `user` WHERE `id` = '$prot[id]' AND `date_last` > '".(time()-120)."' LIMIT 1"),0)==1))
$pon="<img src='style/green.png' title='Онлайн'>";
elseif (($prot['url']!='/plugins/pianica/game.php' || $prot['url']!='/plugins/pianica/index.php') && (mysql_result(mysql_query("SELECT COUNT(*) FROM `user` WHERE `id` = '$prot[id]' AND `date_last` > '".(time()-120)."' LIMIT 1"),0)==1))
$pon="<img src='style/yellow.png' title='Отошел'>";
else
$pon="<img src='style/red.png' title='Не в сети'>";
if (($avtor['url']=='/plugins/pianica/game.php' || $avtor['url']=='/plugins/pianica/index.php') && (mysql_result(mysql_query("SELECT COUNT(*) FROM `user` WHERE `id` = '$avtor[id]' AND `date_last` > '".(time()-120)."' LIMIT 1"),0)==1))
$aon="<img src='style/green.png' title='Онлайн'>";
elseif (($avtor['url']!='/plugins/pianica/game.php' || $avtor['url']!='/plugins/pianica/index.php') && (mysql_result(mysql_query("SELECT COUNT(*) FROM `user` WHERE `id` = '$avtor[id]' AND `date_last` > '".(time()-120)."' LIMIT 1"),0)==1))
$aon="<img src='style/yellow.png' title='Отошел'>";
else
$aon="<img src='style/red.png' title='Не в сети'>";
if ($count_avtor==36 && $game['status']==3)
{
mysql_query("UPDATE `pianica` SET `game_over` = '$avtor[id]' , `read` = '0', `status` = '4' WHERE `id` = '$game[id]' LIMIT 1");
$bonus = $login_prot['bonus'];
mysql_query("UPDATE `user` SET `balls` = '" . ($prot['balls']+5000+$bonus) . "' WHERE `id` = '$prot[id]' LIMIT 1");
mysql_query("UPDATE `pianica_info` SET `bonus` = '" . ($login_prot['bonus']+10) . "', `vins` = '" . ($login_prot['vins']+1) . "', `rating` = '" . ($login_prot['rating']+1) . "' WHERE `id_user` = '$login_prot[id_user]' LIMIT 1");
mysql_query("UPDATE `pianica_info` SET `loss` = '" . ($login_avtor['loss']+1) . "' WHERE `id_user` = '$login_avtor[id_user]' LIMIT 1");
header("Location: ?");
}
elseif ($count_prot==36 && $game['status']==3)
{
mysql_query("UPDATE `pianica` SET `game_over` = '$prot[id]' , `read` = '0', `status` = '4' WHERE `id` = '$game[id]' LIMIT 1");
$bonus = $login_avtor['bonus'];
mysql_query("UPDATE `user` SET `balls` = '" . ($avtor['balls']+5000+$bonus) . "' WHERE `id` = '$avtor[id]' LIMIT 1");
mysql_query("UPDATE `pianica_info` SET `bonus` = '" . ($login_avtor['bonus']+10) . "', `vins` = '" . ($login_avtor['vins']+1) . "', `rating` = '" . ($login_avtor['rating']+1) . "' WHERE `id_user` = '$login_avtor[id_user]' LIMIT 1");
mysql_query("UPDATE `pianica_info` SET `loss` = '" . ($login_prot['loss']+1) . "' WHERE `id_user` = '$login_prot[id_user]' LIMIT 1");
header("Location: ?");
}
if (isset($_GET['go']) && $_GET['go']=='exit')
{
echo "<center><br /><font class='rules'>Вы уверены что хотите закончить игру?</font><br /><br />";
echo "<a href='?go=exit&ok' class='niz_menu'>Да</a> <a href='?' class='niz_menu'>Нет</a><br /><br /></center>";
}
if (isset($_GET['go']) && $_GET['go']=='exit' && isset($_GET['ok']))
{
mysql_query("DELETE FROM `pianica_chat` WHERE `id_game` = '".$game['id']."'");
mysql_query("DELETE FROM `pianica_game` WHERE `id_game` = '".$game['id']."'");
mysql_query("DELETE FROM `pianica` WHERE `id` = '".$game['id']."'");
// отправка приглашения
$msg = 'Пользователь [b]'.$user['nick'].'[/b] закончил с вами игру [b]"[url=/plugins/pianica/index.php]Пьяница[/url]"[/b]';
mysql_query("INSERT INTO `mail` (`id_user`, `id_kont`, `msg`, `time`) values('0', '$ank[id]', '".my_esc($msg)."', '$time')");
header("Location: index.php?");
}
if ($game['status']==4 && ($game['game_over']==$avtor['id'] || $game['game_over']==$prot['id']))
{
if ($game['game_over']==$avtor['id'])
{
mysql_query("DELETE FROM `pianica_game` WHERE `id_game` = '".$game['id']."'");
mysql_query("UPDATE `pianica` SET `status` = '5' WHERE `id` = '$game[id]' LIMIT 1");
header("Location: ?");
}else{
mysql_query("DELETE FROM `pianica_game` WHERE `id_game` = '".$game['id']."'");
mysql_query("UPDATE `pianica` SET `status` = '5' WHERE `id` = '$game[id]' LIMIT 1");
header("Location: ?");
}
}
if (isset($_GET['plus']) && $game['status']==5 && $avtor['id']==$user['id'])
{
mysql_query("UPDATE `pianica` SET `status` = '1', `over_hod` = '0', `game_over` = '', `hod` = '', `karta` = '' WHERE `id` = '$game[id]' LIMIT 1");
header("Location: index.php?");
}
if (isset($user) && $game['status']>0 && $game_my==1)
{
if ($avtor['id']==$user['id'])
$ank = get_user($prot['id']);
elseif ($prot['id']==$user['id'])
$ank = get_user($avtor['id']);
if ($game['status']==5)
{
echo "<div class='uved'>";
echo "Игра окончена";
echo "</div>";
echo "<table>";
echo "<tr>";
echo "<td class='nav'>";
echo "$avtor[nick] <font color='#06ff00'>($count_avtor)</font> $aon";
echo "</td>";
echo "<td class='nav2'>";
echo "$pon <font color='#06ff00'>($count_prot)</font> $prot[nick]";
echo "</td>";
echo "</tr>";
echo "</table><br />";
echo "<div style='text-align:right; vertical-align:top;'>";
echo "<font class='niz_menu'>Итоги игры</font>";
echo "</div><br />";
echo "<div class='rules'>";
echo "Победил: ";
if ($game['game_over']==$avtor['id'])
echo "$prot[nick]";
else
echo "$avtor[nick]";
echo ", он получает 5000 баллов сайта, и 10 бонусов на свой личный счет.<br />";
echo "</div>";
echo "</div>";
echo "<div class='niz'>";
if ($avtor['id']==$user['id'])echo "<a href='?plus' class='niz_menu'>Играть еще</a> ";
echo "<a href='?' class='niz_menu'>Обновить</a><br /><br /> <a href='index.php' class='niz_menu'>Меню</a> <a href='game.php?go=exit' class='niz_menu'>Закончить игру с $ank[nick]</a>";
echo "<br /><br /></div>";
}
if ($game['status']==3)
{
$my_karta = mysql_fetch_assoc(mysql_query("SELECT * FROM `pianica_game` WHERE `id_user` = '$user[id]' AND `on` = '0' ORDER BY `time` ASC limit 1"));
$activ_karta = mysql_fetch_assoc(mysql_query("SELECT * FROM `pianica_game` WHERE `karta` = '$game[karta]' limit 1"));
if (isset($_GET['go']) && $_GET['go']=='hod' && $game['hod']==$user['id'] && $game['read']==0) // ход первый
{
mysql_query("UPDATE `pianica_game` SET `on` = '1', `time` = '$time' WHERE `id` = '$my_karta[id]' AND `id_game` = '".$game['id']."' LIMIT 1");
mysql_query("UPDATE `pianica` SET `karta` = '$my_karta[karta]',`read` = '1', `hod` = '$ank[id]' WHERE `id` = '$game[id]' LIMIT 1");
header("Location: ?");
}
elseif ((isset($_GET['go']) && $_GET['go']=='hod' && $game['hod']==$user['id'] && $game['read']==1) && (($my_karta['sila']==5) && ($activ_karta['sila']==6 || $activ_karta['sila']==7 || $activ_karta['sila']==8) || ($my_karta['sila']==6 || $my_karta['sila']==7 || $my_karta['sila']==8) && ($activ_karta['sila']==5))) // десятка
{
if (($my_karta['sila']==5) && ($activ_karta['sila']==6 || $activ_karta['sila']==7 || $activ_karta['sila']==8))
{
mysql_query("UPDATE `pianica` SET `karta` = '', `read` = '2', `over_hod` = '$ank[id]', `hod` = '$ank[id]' WHERE `id` = '$game[id]' LIMIT 1");
header("Location: ?");
}
else if (($my_karta['sila']==6 || $my_karta['sila']==7 || $my_karta['sila']==8) && ($activ_karta['sila']==5))
{
mysql_query("UPDATE `pianica` SET `karta` = '', `read` = '2', `over_hod` = '$user[id]', `hod` = '$user[id]' WHERE `id` = '$game[id]' LIMIT 1");
header("Location: ?");
}
else if ($my_karta['sila'] == $activ_karta['sila'])
{
mysql_query("UPDATE `pianica` SET `read` = '0', `over_hod` = '', `hod` = '$ank[id]' WHERE `id` = '$game[id]' LIMIT 1");
header("Location: ?");
}
mysql_query("UPDATE `pianica_game` SET `on` = '1', `time` = '$time' WHERE `id` = '$my_karta[id]' AND `id_game` = '".$game['id']."' LIMIT 1");
mysql_query("UPDATE `pianica` SET `karta` = '$my_karta[karta]'WHERE `id` = '$game[id]' LIMIT 1");
}
elseif ((isset($_GET['go']) && $_GET['go']=='hod' && $game['hod']==$user['id'] && $game['read']==1) && ($my_karta['sila']==1 && $activ_karta['sila']==9 || $my_karta['sila']==9 && $activ_karta['sila']==1)) // шестерка и туз
{
if ($my_karta['sila']==1 && $activ_karta['sila']==9)
{
mysql_query("UPDATE `pianica` SET `karta` = '', `read` = '2', `over_hod` = '$ank[id]', `hod` = '$ank[id]' WHERE `id` = '$game[id]' LIMIT 1");
header("Location: ?");
}
else if ($my_karta['sila']==9 && $activ_karta['sila']==1)
{
mysql_query("UPDATE `pianica` SET `karta` = '', `read` = '2', `over_hod` = '$user[id]', `hod` = '$user[id]' WHERE `id` = '$game[id]' LIMIT 1");
header("Location: ?");
}
else if ($my_karta['sila'] == $activ_karta['sila'])
{
mysql_query("UPDATE `pianica` SET `read` = '0', `over_hod` = '', `hod` = '$ank[id]' WHERE `id` = '$game[id]' LIMIT 1");
header("Location: ?");
}
mysql_query("UPDATE `pianica_game` SET `on` = '1', `time` = '$time' WHERE `id` = '$my_karta[id]' AND `id_game` = '".$game['id']."' LIMIT 1");
mysql_query("UPDATE `pianica` SET `karta` = '$my_karta[karta]'WHERE `id` = '$game[id]' LIMIT 1");
}
elseif (isset($_GET['go']) && $_GET['go']=='hod' && $game['hod']==$user['id'] && $game['read']==1) // бить карту
{
if ($my_karta['sila'] > $activ_karta['sila'])
{
mysql_query("UPDATE `pianica` SET `karta` = '', `read` = '2', `over_hod` = '$ank[id]', `hod` = '$ank[id]' WHERE `id` = '$game[id]' LIMIT 1");
header("Location: ?");
}
else if ($my_karta['sila'] < $activ_karta['sila'])
{
mysql_query("UPDATE `pianica` SET `karta` = '', `read` = '2', `over_hod` = '$user[id]', `hod` = '$user[id]' WHERE `id` = '$game[id]' LIMIT 1");
header("Location: ?");
}
else if ($my_karta['sila'] == $activ_karta['sila'])
{
mysql_query("UPDATE `pianica` SET `read` = '0', `over_hod` = '', `hod` = '$ank[id]' WHERE `id` = '$game[id]' LIMIT 1");
header("Location: ?");
}
mysql_query("UPDATE `pianica_game` SET `on` = '1', `time` = '$time' WHERE `id` = '$my_karta[id]' AND `id_game` = '".$game['id']."' LIMIT 1");
mysql_query("UPDATE `pianica` SET `karta` = '$my_karta[karta]'WHERE `id` = '$game[id]' LIMIT 1");
}
if ($count_avtor==0 || $count_prot==0 && $game['status']==3 && $game['read']!=2 && $my_karta['sila'] == $activ_karta['sila'])
{
if ($count_avtor==0)
mysql_query("UPDATE `pianica` SET `karta` = '', `read` = '2', `over_hod` = '$prot[id]', `hod` = '$prot[id]' WHERE `id` = '$game[id]' LIMIT 1");
else if ($count_prot==0)
mysql_query("UPDATE `pianica` SET `karta` = '', `read` = '2', `over_hod` = '$avtor[id]', `hod` = '$avtor[id]' WHERE `id` = '$game[id]' LIMIT 1");
header("Location: ?");
}
if (isset($_GET['go']) && $_GET['go']=='zabrat' && $game['over_hod']==$user['id'] && $game['read']==2)
{
mysql_query("UPDATE `pianica_game` SET `id_user` = '$user[id]', `on` = '0', `time` = '$time' WHERE `on` = '1' AND `id_game` = '".$game['id']."'");
mysql_query("UPDATE `pianica` SET `hod` = '$ank[id]', `over_hod` = '', `read` = '0' WHERE `id` = '$game[id]' LIMIT 1");
header("Location: ?");
}
echo "<table>";
echo "<tr>";
echo "<td class='nav'>";
echo "$avtor[nick] <font color='#06ff00'>($count_avtor)</font> $aon";
echo "</td>";
echo "<td class='nav2'>";
echo "$pon <font color='#06ff00'>($count_prot)</font> $prot[nick]";
echo "</td>";
echo "</tr>";
echo "</table>";
echo "<table>";
echo "<tr>";
echo "<td>";
$q = mysql_query("SELECT * FROM `pianica_game` where `on` = '1' AND `id_game` = '".$game['id']."' ORDER BY `time` ASC");
$ob = 0;
while ($karta = mysql_fetch_assoc($q))
{
$ob++;
?>
<div class="items_spec">
<img src="<?echo "$game[koloda]/$karta[karta].jpg";?>" style="border: 2px solid #bdbdbd;border-radius: 5px;" class="ob<?echo $ob;?>" border="0" />
</div>
<style>
.items_spec {
float: left;
padding: 12px 0 0 12px;
width: 3px;
height: 130px;
display: block;
position: relative;
}
span.special {
position: absolute;
right: 0;
top: 0;
}
</style>
<?
}
echo "</td>";
echo "<td style='text-align:right; vertical-align:top;'>";
if (($count_avtor==0 || $count_prot==0) && ($game['over_hod']==$avtor['id'] && $game['over_hod']==$prot['id']))
{
if ($game['over_hod']==$user['id'])
echo "<font class='niz_menu'>Вы проиграли</font>";
else
echo "<font class='niz_menu'>Вы победили</font>";
}
else
{
if ($game['hod']==$user['id'])
echo "<font class='niz_menu'>Ваше действие</font>";
else
echo "<font class='niz_menu'>Действие противника</font>";
}
echo "</td>";
echo "</tr>";
echo "</table>";
echo "</div>";
echo "<div class='niz'><center>";
if ($game['hod']==$user['id'] && $game['read']==0)
echo "<a href='?go=hod' class='niz_menu'>Ходить</a> ";
elseif ($game['hod']==$user['id'] && $game['read']==1)
echo "<a href='?go=hod' class='niz_menu'>Побить карту</a> ";
elseif ($game['over_hod']==$user['id'] && $game['read']==2)
echo "<a href='?go=zabrat' class='niz_menu'>Забрать карты</a> ";
echo "<a href='?' class='niz_menu'>Обновить</a> ";
echo "</center></div>";
}else if ($game['status']==2){
if (isset($_GET['razdat']) && $game['status']==2)
{
mysql_query("UPDATE `pianica_info` SET `count` = '" . ($login_prot['count']+1) . "' WHERE `id_user` = '$login_prot[id_user]' LIMIT 1");
mysql_query("UPDATE `pianica_info` SET `count` = '" . ($login_avtor['count']+1) . "' WHERE `id_user` = '$login_avtor[id_user]' LIMIT 1");
$q = mysql_query("SELECT * FROM `pianica_karty` ORDER BY rand() ");
$num=0;
while ($karta = mysql_fetch_assoc($q))
{
$num++;
$time++;
if ($num >= 0 && $num<=18)
mysql_query("INSERT INTO `pianica_game` (`karta`, `sila`, `id_user`, `time`, `id_game`) values('$karta[name]', '$karta[sila]', '$avtor[id]', '$time', '$game[id]')");
else if ($num >= 19 && $num<=36)
mysql_query("INSERT INTO `pianica_game` (`karta`, `sila`, `id_user`, `time`, `id_game`) values('$karta[name]', '$karta[sila]', '$prot[id]', '$time', '$game[id]')");
}
mysql_query("UPDATE `pianica` SET `hod` = '$avtor[id]', `status` = '3' WHERE `id` = '$game[id]' LIMIT 1");
header("Location: ?");
}
echo "<table>";
echo "<tr>";
echo "<td class='nav'>";
echo "$avtor[nick] <font color='#06ff00'>($count_avtor)</font> $aon";
echo "</td>";
echo "<td class='nav2'>";
echo "$pon <font color='#06ff00'>($count_prot)</font> $prot[nick]";
echo "</td>";
echo "</tr>";
echo "</table><br />";
echo "<div style='text-align:right; vertical-align:top;'>";
echo "<font class='niz_menu'>Ожидание раздачи</font>";
echo "</div>";
echo "</div>";
echo "<div class='niz'>";
if ($avtor['id']==$user['id'])echo "<a href='?razdat' class='niz_menu'>Раздать карты</a> ";
echo "<a href='?' class='niz_menu'>Обновить</a> ";
echo "</div>";
}
}
$k_post=mysql_result(mysql_query("SELECT COUNT(*) FROM `pianica_chat` WHERE `id_game` = '$game[id]'"),0);
$q=mysql_query("SELECT * FROM `pianica_chat` WHERE `id_game` = '$game[id]' ORDER BY `id` DESC LIMIT 5");
if ($game['chat']==1)
{
echo " <div class='fon2'>\n";
echo " <div class='chat_foot'>\n";
if (isset($user) && isset($_GET['mess']))
{
echo "<form method=\"post\" name='message' action=\"?\">\n";
echo "<textarea name=\"msg\"></textarea><br />\n";
echo "<input value=\"Отправить\" type=\"submit\"/>\n"; echo " <a href='?$passgen'>Скрыть</a>";
echo "</form>\n";
}else{
echo "Сообщения: <a href='?mess' >Написать</a> ";
}
echo " </div>\n";
if ($k_post==0)
{
echo " <div class='uved' style='text-align:left;'>\n";
echo "Нет комментариев\n";
echo " </div>\n";
}
$nnn=0;
while ($post = mysql_fetch_assoc($q))
{
if ($nnn==0)
{
echo "<div class='chat2'>";
$nnn = 1;
}
elseif ($nnn==1)
{
echo "<div class='chat'>";
$nnn = 0;
}
//$ank_c=mysql_fetch_assoc(mysql_query("SELECT * FROM `user` WHERE `id` = $post[id_user] LIMIT 1"));
$ank_c=get_user($post['id_user']);
echo "<b>$ank_c[nick]</b> (".vremja($post['time']).") » \n";
echo output_text($post['msg'])."";echo " <br />";
echo "</div>";
}
}
}else{
header("Location: index.php?");
}
echo " <div class='chat_foot' style='padding:13px;'>\n";
echo "<a href='index.php' class='niz_menu'>Меню</a> <a href='info.php' class='niz_menu'>Анкета</a>";
echo "</div>";
echo "</div>";
}else{
echo " <div class='chat_foot' style='padding:13px;'>\n";
echo "Вы не авторизованы! Игра доступна только для зарегистрированных пользователей!";
echo "</div>";
}
echo "</div>";
include_once '../../sys/inc/tfoot.php';
?>