Файл: vkolhoze.com/inc/chat.php
Строк: 254
<?
require_header ('Чат');
if(mysql_result(mysql_query("SELECT COUNT(*) FROM `chat_see` WHERE `id_chat` = '0' AND `id_user` = '$ku[id]'"), 0)==0)mysql_query("INSERT INTO `chat_see` SET `id_user` = '$ku[id]', `id_chat` = '0'");
if(intval($_GET['chat'])!=NULL && mysql_result(mysql_query("SELECT COUNT(*) FROM `kolhoz_chat` WHERE `id` = '".intval($_GET['chat'])."' AND `type` = 'room'".($ku['status']<1?" AND `admod` = '0'":null).""),0)!=0)
{
$chat=mysql_fetch_array(mysql_query("SELECT * FROM `kolhoz_chat` WHERE `id` = '".intval($_GET['chat'])."' AND `type` = 'room'"));
if(mysql_result(mysql_query("SELECT COUNT(*) FROM `chat_see` WHERE `id_chat` = '$chat[id]' AND `id_user` = '$ku[id]'"), 0)==0)mysql_query("INSERT INTO `chat_see` SET `id_user` = '$ku[id]', `id_chat` = '$chat[id]'");
if(isset($_GET['edit']) && $ku['status']>2)
{
if($_GET['edit']=='ok')
{
$name=$_POST['name'];
$opis=$_POST['opis'];
if($name==NULL)
{
echo err_game("Слишком короткое название");
$err=1;
}
if(!isset($err))
{
if($_POST['admod']==1)$admod=1;else $admod=0;
mysql_query("UPDATE `kolhoz_chat` SET `name` = '".my_esc($name)."', `opis` = '".my_esc($opis)."', `admod` = '$admod' WHERE `id` = '$chat[id]'");
header("Location:/chat-$chat[id]");
exit;
}
}
echo '<div class="content"><div class="balloon2">';
echo "<form action='?chat=$chat[id]&edit=ok' method='post'><ul><li><label><div>Название:</div><div><input type='text' class='wide' value='".hsc($chat['name'])."' name='name'></div></label></li><li><label><div>Описание:</div><div><textarea class='wide' rows='5' name='opis'>".hsc($chat['opis'])."</textarea></div></label></li>";
echo "<input type='checkbox' name='admod' value='1'".($chat['admod']==1?" checked='checked'":null)."> <span>Давать доступ только администрации</span><br/>";
echo "<li><input type='submit' value='Создать'></li></ul></form></div>";
include_once 'inc/foot.php';
}
elseif(isset($_GET['clean']) && $ku['status']>0)
{
if($_GET['clean']=='ok')
{
mysql_query("delete from `kolhoz_chat` where `mother` = '$chat[id]' and `type` = 'komm'");
header("Location:/chat-$chat[id]");
}
else echo '<div class="event"><title>Подтверждение</title></div><div class="content"><div class="block"><ul class="block"><li><span class="title">Вы уверены?</span></li><li class="pt"><a class="loc" href="?chat='.$chat['id'].'&clean=ok"><span>
<img alt="" width="20" height="20"src="images/icons/tick.png"> Да, подтверждаю</span></a></li><li><a class="loc" href="?chat='.$chat['id'].'"><span>
<img alt="" width="20" height="20"src="images/icons/cross.png"> Нет, отказываюсь</span></a></li></ul></div>';
include_once 'inc/foot.php';
}
elseif(isset($_GET['del_komm']) && intval($_GET['del_komm'])!=NULL && mysql_result(mysql_query("SELECT COUNT(*) FROM `kolhoz_chat` WHERE `id` = '".intval($_GET['del_komm'])."' AND `type` = 'komm'"),0)!=0 && $ku['status']>0)
{
mysql_query("delete from `kolhoz_chat` where `mother` = '$chat[id]' and `type` = 'komm' and `id` = '".intval($_GET['del_komm'])."'");
header("Location:/chat-$chat[id]");
}
elseif(isset($_GET['del']) && $ku['status']>2)
{
if($_GET['del']=='ok')
{
mysql_query("delete from `kolhoz_chat` where `mother` = '$chat[id]' and `type` = 'komm'");
mysql_query("delete from `kolhoz_chat` where `id` = '$chat[id]' and `type` = 'room'");
header("Location:/chat");
}
else echo '<div class="event"><title>Подтверждение</title></div><div class="content"><div class="block"><ul class="block"><li><span class="title">Вы уверены?</span></li><li class="pt"><a class="loc" href="?chat='.$chat['id'].'&del=ok"><span>
<img alt="" width="20" height="20"src="images/icons/tick.png"> Да, подтверждаю</span></a></li><li><a class="loc" href="?chat='.$chat['id'].'"><span>
<img alt="" width="20" height="20"src="images/icons/cross.png"> Нет, отказываюсь</span></a></li></ul></div>';
include_once 'inc/foot.php';
}
else
{
if(isset($_GET['otv']) && intval($_GET['otv'])!=NULL && mysql_result(mysql_query("SELECT COUNT(*) FROM `kolhoz_user` WHERE `id` = '".intval($_GET['otv'])."'"),0)!=0 && intval($_GET['otv'])!=$ku['id'])
{
$otv=mysql_fetch_array(mysql_query("SELECT * FROM `kolhoz_user` WHERE `id` = '".intval($_GET['otv'])."'"));
$otvu=$otv;
}
echo "<div class='event'><title>".hsc($chat['name'])."</title></div>";
echo '<div class="content"><div class="block"><ul>';
echo "<li class='pb'>";
echo "<li><a class='loc' href='/chat'><img width='20' height='20'src='images/icons/chat.png' alt='*'> Чаты</a></li>";
echo "<div><td><a class='loc' href='/chat-$chat[id]/".(rand(100000000,900000000))."'><img alt='*' width='20' height='20'src='images/icons/refresh.png'> Обновить</a></td>
<td><a class='loc' href='/chat-$chat[id]".(!isset($_GET['write'])?"/write":null)."'><img alt='' width='20' height='20'src='images/icons/pencil.png'> Написать</a></td></div>
<div>
";
if(isset($_GET['add']) && $_GET['add']=='ok' && isset($_GET['write']) && !isset($molchi))
{
$msg=$_POST['msg'];
if($msg==NULL)
{
echo err_game("Слишком короткое сообщение");
$err=1;
}
if($ku['level']<=14)
{
echo err_game("Писать в чате можно с 15 уровня");
$err=1;
}
//if($ku['time']<1800)
//{
//$err=1;
//err_game("Чтобы писать сообщения нужно провести 30 минут в игре!");
//}
if(!isset($err))
{
mysql_query("INSERT INTO `kolhoz_chat` SET `msg` = '".my_esc($msg)."'".($ku['status']>0?", `bb` = '1'":null).", `id_user` = '$ku[id]', `type` = 'komm', `mother` = '$chat[id]', `time` = '$time'".(isset($otv)?", `otvet` = '$otv[id]'":null)."");
mysql_query("DELETE FROM `chat_see` WHERE `id_chat` = '$chat[id]'");
mysql_query("DELETE FROM `chat_see` WHERE `id_chat` = '0'");
mysql_query("UPDATE `kolhoz_user` SET `chatpost` = '".($ku['chatpost']+1)."' WHERE `id` = '$ku[id]' LIMIT 1");
mysql_query("UPDATE `kolhoz_user` SET `chat_count` = '1'");
header("Location:?chat=$chat[id]&write=yes");
exit;
}
}
if(isset($_GET['write']))
{
if(!$ban['id']){$ban=mysql_fetch_array(mysql_query("SELECT * FROM `kolhoz_ban` WHERE `id_user` = '$ku[id]' AND `time` > '$time' AND `izg` = '2' ORDER BY `id` DESC LIMIT 1"));
$us_ban=mysql_fetch_array(mysql_query("SELECT * FROM `kolhoz_user` WHERE `id` = '$ban[id_who]'"));
}
if($ban['id'])
{
echo "<ul class='pt'>
<div>
<li class='major'><span>".($ban['izg']==2?"Бан в чате до ".vremja($ban['time'])."":"Обет Молчания до ".vremja($ban['time']))."</span>, выдал".($us_ban['pol']==0?'a':null)." <span>";
echo on_k($us_ban['id']);
echo "<a href='/user/$us_ban[id]'>".nc($us_ban['id'])."</a></span><span>, (".output_text($ban['msg']).")</span></li></div></ul>";
}
elseif(isset($_GET['write']))echo "<div><form action='?chat=$chat[id]&write=yes&add=ok".(isset($otv)?"&otv=$otv[id]":null)."' method='post'><label>Сообщение".(isset($otv)?" для $otvu[nick]":null).":<br><textarea class='wide' rows='2' name='msg'></textarea></label><br><input type='submit' value='Отправить'> <a class = 'otvet' href='?smiles'><img alt='' width='20' height='20'src='/images/icons/smiles.png'>Смайлы</a></form></div>";}
/*else echo "<div><form action='?chat=$chat[id]&write=yes&add=ok".(isset($otv)?"&otv=$otv[id]":null)."' method='post'><label>Сообщение".(isset($otv)?" для $otvu[nick]":null).":<br><textarea class='wide' rows='2' name='msg'></textarea></label><br><input type='submit' value='Отправить'></form></div>";
}*/
echo "</li>";
echo "<hr color='green'>";
mysql_query("UPDATE kolhoz_user SET chat_cpunt = '0' WHERE id ='$ku[id]'");
$k_post = mysql_result(mysql_query("SELECT COUNT(*) FROM `kolhoz_chat` WHERE `type` = 'komm' AND `mother` = '$chat[id]'"),0);
if ($k_post==0)
{
echo "пустo...";
}
$k_page=k_page($k_post,$set['p_str']);
$page=page($k_page);
$start=$set['p_str']*$page-$set['p_str'];
$q=mysql_query("SELECT * FROM `kolhoz_chat` WHERE `type` = 'komm' AND `mother` = '$chat[id]' ORDER BY `time` DESC LIMIT $start, $set[p_str]");
while($post=mysql_fetch_array($q))
{
$ank=mysql_fetch_array(mysql_query("SELECT * FROM `kolhoz_user` WHERE `id` = '$post[id_user]'"));
if($post['otvet']!=0 && mysql_result(mysql_query("SELECT COUNT(*) FROM `kolhoz_user` WHERE `id` = '$post[otvet]'"),0)!=0)
{
$otvet=mysql_fetch_array(mysql_query("SELECT * FROM `kolhoz_user` WHERE `id` = '$post[otvet]'"));
$otvetu=$otvet;
}
if($ank['status']>0 && $post['bb']==0)mysql_query("UPDATE `kolhoz_forum` SET `bb` = '1' WHERE `id` = '$post[id]'");
echo "<li class='pb'><div><span>";
echo on_k($ank['id']);
echo " <a class='' href='/user/$ank[id]'><span>".nc($ank['id'])."</span></a></span> <span class='minor small'> <span>
".($time-$post['time']<=2592000?"".time_left($time-$post['time'])."</span> назад</span>":"
".vremja($post['time'])."</span>")."
</div><div class='title'>".($post['otvet']>0?"<span class='nick".($ank['status']==1?"Supporter":null)."".($ank['status']==2?"Moderator":null)."".($ank['status']==3?"Admin":null)."'>".($ku['id']==$otvet['id']?"<span class='rare'>":null)."$otvetu[nick]".($ku['id']==$otvet['id']?"</span>":null).", </span>":null)."".output_text($post['msg'], $ank['id'], $post['bb'])."</div><div>".($ank['id']!=$ku['id']?"<a class='otvet' href='/chat-$chat[id]/otv-$ank[id]/write'>Ответить</a>":null)."";
if($ku['status']>0)echo " <a class='udal' href='?chat=$chat[id]&del_komm=$post[id]'>Удалить</a> ";
echo "</div></li>";
}
if ($k_page>1){echo'<ul class="pt"></ul>'; new_str("chat-$chat[id]/",$k_page,$page);} // Вывод страниц
echo "</ul>";
echo "<ul class='pt'>";
echo "<li></li>";
echo "<hr color='green'>";
//echo "<div><a class='loc' href='/smiles'><img width='20' height='20'src='images/icons/smiles.png' alt='*'> Смайлы</a></div>";
if($ku['status']>2)echo "<li><a class='loc' href='/chat-$chat[id]/del'><img alt='*' width='20' height='20'src='images/icons/delete.png'> Удалить чат</a></li>";
if($ku['status']>0)echo "<li><a class='loc' href='/chat-$chat[id]/clean'><img alt='*' width='20' height='20'src='images/icons/delete.png'> Очистить комнату</a></li>";
if($ku['status']>2)echo "<li><a class='loc' href='/chat-$chat[id]/edit'><img alt='*' width='20' height='20'src='images/icons/forum_edit.png'> Изменить название</a></li>";
//echo "<li><a class='loc' href='/online/admin'><img width='20' height='20'src='images/icons/rules.png' alt='*'> Позвать
//модератора</a></li>";
//echo '<img width="100%" style="border-radius:7px" src="images/grass.png">';
echo "</ul></div>";
include_once 'inc/foot.php';
}
}
else
{
if(isset($_GET['add']) && $ku['status']>2)
{
echo '<div class="event"><title>Создание комнаты</title></div>';
if($_GET['add']=='ok')
{
$name=$_POST['name'];
$opis=$_POST['opis'];
if($name==NULL)
{
echo err_game("Слишком короткое название");
$err=1;
}
if(!isset($err))
{
if($_POST['admod']==1)$admod=1;else $admod=0;
$pos=mysql_result(mysql_query("SELECT MAX(`pos`) FROM `kolhoz_chat` WHERE `type` = 'room'"), 0)+1;
mysql_query("INSERT INTO `kolhoz_chat` SET `name` = '".my_esc($name)."', `id_user` = '$ku[id]', `type` = 'room', `mother` = '0', `time` = '$time', `admod` = '$admod', `pos` = '$pos', `opis` = '".my_esc($opis)."'");
header("Location:?chat");
exit;
}
}
echo '<div class="content"><div class="block">';
echo "<form action='?chat&add=ok' method='post'><ul><li><label><div>Название:</div><div><input type='text' class='wide' value='' name='name'></div></label></li><li><label><div>Описание:</div><div><textarea class='wide' rows='5' name='opis'></textarea></div></label></li>";
echo "<input type='checkbox' name='admod' value='1'> <span>Давать доступ только администрации</span><br/>";
echo "<li><input type='submit' value='Создать'></li></ul></form></div>";
include_once 'inc/foot.php';
}
else
{
if (isset($_GET['up']) && $ku['status']>2)
{
$up=mysql_fetch_assoc(mysql_query("SELECT * FROM `kolhoz_chat` WHERE `id` = '".intval($_GET['up'])."' AND `type` = 'room' LIMIT 1"));
if(mysql_result(mysql_query("SELECT COUNT(*) FROM `kolhoz_chat` WHERE `pos` < '$up[pos]' AND `type` = 'room' LIMIT 1"),0)!=0)
{
mysql_query("UPDATE `kolhoz_chat` SET `pos` = '".($up['pos'])."' WHERE `pos` = '".($up['pos']-1)."' AND `type` = 'room' LIMIT 1");
mysql_query("UPDATE `kolhoz_chat` SET `pos` = '".($up['pos']-1)."' WHERE `id` = '".intval($_GET['up'])."' AND `type` = 'room' LIMIT 1");
}
}
elseif (isset($_GET['down']) && $ku['status']>2)
{
$down=mysql_fetch_assoc(mysql_query("SELECT * FROM `kolhoz_chat` WHERE `id` = '".intval($_GET['down'])."' AND `type` = 'room' LIMIT 1"));
if(mysql_result(mysql_query("SELECT COUNT(*) FROM `kolhoz_chat` WHERE `pos` > '$down[pos]' AND `type` = 'room' LIMIT 1"),0)!=0)
{
mysql_query("UPDATE `kolhoz_chat` SET `pos` = '".($down['pos'])."' WHERE `pos` = '".($down['pos']+1)."' AND `type` = 'room' LIMIT 1");
mysql_query("UPDATE `kolhoz_chat` SET `pos` = '".($down['pos']+1)."' WHERE `id` = '".intval($_GET['down'])."' AND `type` = 'room' LIMIT 1");
}
}
elseif(isset($_GET['readall']))
{
$all=mysql_query("SELECT * FROM `kolhoz_chat`");
while($allpost=mysql_fetch_array($all))
{
if(mysql_result(mysql_query("SELECT COUNT(*) FROM `chat_see` WHERE `id_chat` = '$allpost[id]' AND `id_user` = '$ku[id]'"), 0)==0)mysql_query("INSERT INTO `chat_see` SET `id_user` = '$ku[id]', `id_chat` = '$allpost[id]'");
}
header("Location:/chat");
}
echo "<div class='event'><title>Куда идем?</title></div>";
echo '<div class="content"><div class="block"><ul>';
$q=mysql_query("SELECT * FROM `kolhoz_chat` WHERE `type` = 'room'".($ku['status']<=0?" AND `admod` = '0'":null)." ORDER BY `pos` ASC");
while($post=mysql_fetch_array($q))
{
echo "<li><div><a class='loc' href='/chat-$post[id]'><span><img width='20' height='20'src='images/icons/chat".(mysql_result(mysql_query("SELECT COUNT(*) FROM `chat_see` WHERE `id_chat` = '$post[id]' AND `id_user` = '$ku[id]'"), 0)==0?"_new":null).".png' alt='*'> ".hsc($post['name'])."</span></a></div>";
if(isset($_GET['moderate']) && $ku['status']>0)echo "<a href='/chat/moderate/up-$post[id]'><img width='20' height='20'src='images/icons/up.png' alt='*'></a> <a href='/chat/moderate/down-$post[id]'><img width='20' height='20'src='images/icons/down.png' alt='*'></a>";
echo "</li>";
}
echo "</ul>";
echo "<ul class='pt'>";
echo "<li><a class='loc' href='/chat/readall'><img width='20' height='20'src='images/icons/tick.png' alt='*'> Отметить всё как прочитанное</a></li>";
if($ku['status']>2)echo "<li><a class='loc' href='/chat".(!isset($_GET['moderate'])?"/moderate":null)."'><img width='20' height='20'src='images/icons/moderate.png' alt='*'> Управление</a></li><li><a class='loc' href='/chat/add'><img width='20' height='20'src='images/icons/chat.png' alt='*' title='*'> Создать комнату</a></li>";
echo "</ul></div>";
include_once 'inc/foot.php';
}
}
?>