Файл: vfermu.ru/sys/other/chat.php
Строк: 390
<?
if(mysql_result(mysql_query("SELECT COUNT(*) FROM `online_chat` WHERE `id_user`='$ku[id]'"),0)==1)mysql_query("UPDATE `online_chat` SET `time`='$time' WHERE `id_user`='$ku[id]'"); else mysql_query("INSERT INTO `online_chat` SET `time`='$time',`id_user`='$ku[id]'");
mysql_query("DELETE FROM `online_chat` WHERE `time`<'".($time-600)."'");
if(isset($_GET['onlineChat']))
{
$q=mysql_query("SELECT * FROM `online_chat` ORDER by `time`DESC");
echo "<div class='content'><div class='block'>";
While($post=mysql_fetch_array($q))
{
$ank=mysql_fetch_array(mysql_query("SELECT * FROM `farm_user` WHERE `id`='$post[id_user]'"));
echo '<li>'.on_k($ank['id']);
echo " <a class='' href='/user/$ank[id]'><span>".nc($ank['id'])."</span></a></span> ";
}
echo '</div></div>';
include_once 'sys/other/foot.php';
}
mysql_query("UPDATE `farm_user` SET `chat_count` = '0' WHERE `id` = '$ku[id]'");
if(intval($_GET['chat'])!=NULL && mysql_result(mysql_query("SELECT COUNT(*) FROM `farm_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 `farm_chat` WHERE `id` = '".intval($_GET['chat'])."' AND `type` = 'room'"));
echo "<title>$chat[name]</title>";
if(isset($_GET['edit']) && $ku['status']>0)
{
if($_GET['edit']=='ok')
{
$name=$_POST['name'];
$opis=$_POST['opis'];
if($name==NULL)
{
echo err_game("Слишком короткое название");
$err=1;
}
if(!isset($err))
{
mysql_query("UPDATE `farm_user` SET `chat_count` = '1'");
if($_POST['admod']==1)$admod=1;else $admod=0;
mysql_query("UPDATE `farm_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="block">';
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></div>";
include_once 'sys/other/foot.php';
}
elseif(isset($_GET['clean']) && $ku['status']>0)
{
if($_GET['clean']=='ok')
{
mysql_query("delete from `farm_chat` where `mother` = '$chat[id]' and `type` = 'komm'");
header("Location:?chat=$chat[id]");
}
else echo '<div class="content"><div class="block"><ul class="block"><li><span class="title">Вы уверены?</span></li><li class="pt"><img alt="" width="16" height="16" src="images/icons/tick.png"> <a href="?chat='.$chat['id'].'&clean=ok"><span>
Да, подтверждаю</span></a></li><li><img alt="" width="16" height="16" src="images/icons/cross.png"> <a href="?chat='.$chat['id'].'"><span>
Нет, отказываюсь</span></a></li></ul></div>';
include_once 'sys/other/foot.php';
}
elseif(isset($_GET['del_komm']) && intval($_GET['del_komm'])!=NULL && mysql_result(mysql_query("SELECT COUNT(*) FROM `farm_chat` WHERE `id` = '".intval($_GET['del_komm'])."' AND `type` = 'komm'"),0)!=0 && $ku['status']>0)
{
mysql_query("delete from `farm_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']>0)
{
if($_GET['del']=='ok')
{
mysql_query("delete from `farm_chat` where `mother` = '$chat[id]' and `type` = 'komm'");
mysql_query("delete from `farm_chat` where `id` = '$chat[id]' and `type` = 'room'");
header("Location:?chat");
}
else echo '<div class="content"><div class="block"><ul class="block"><li><span class="title">Вы уверены?</span></li><li class="pt"><img alt="" width="16" height="16" src="images/icons/tick.png"> <a href="?chat='.$chat['id'].'&del=ok"><span>
Да, подтверждаю</span></a></li><li><img alt="" width="16" height="16" src="images/icons/cross.png"> <a href="?chat='.$chat['id'].'"><span>
Нет, отказываюсь</span></a></li></ul></div>';
include_once 'sys/other/foot.php';
}
else
{
if(isset($_GET['otv']) && intval($_GET['otv'])!=NULL && mysql_result(mysql_query("SELECT COUNT(*) FROM `farm_user` WHERE `id` = '".intval($_GET['otv'])."'"),0)!=0 && intval($_GET['otv'])!=$ku['id'])
{
$otv=mysql_fetch_array(mysql_query("SELECT * FROM `farm_user` WHERE `id` = '".intval($_GET['otv'])."'"));
$otvu=$otv;
}
elseif(isset($_GET['md']))
{
if(isset($_GET['da']))
{
if($ku['rubies']>=$lk)
{
mysql_query("INSERT INTO `farm_mail` SET `id_user` = '120', `id_kont` = '$ku[id]', `msg` = 'Ув.администрация зайдите в чат,в комнату общение.', `time` = '$time', `type` = 'to'");
mysql_query("INSERT INTO `farm_mail` SET `id_user` = '5', `id_kont` = '$ku[id]', `msg` = 'Ув.администрация зайдите в чат,в комнату общение.', `time` = '$time', `type` = 'to'");
mysql_query("INSERT INTO `farm_mail` SET `id_user` = '1', `id_kont` = '$ku[id]', `msg` = 'Ув.администрация зайдите в чат,в комнату общение.', `time` = '$time', `type` = 'to'");
mysql_query("INSERT INTO `farm_mail` SET `id_user` = '344', `id_kont` = '$ku[id]', `msg` = 'Ув.администрация зайдите в чат,в комнату общение.', `time` = '$time', `type` = 'to'");
mysql_query("INSERT INTO `farm_mail` SET `id_user` = '342', `id_kont` = '$ku[id]', `msg` = 'Ув.администрация зайдите в чат,в комнату общение.', `time` = '$time', `type` = 'to'");
mysql_query("INSERT INTO `farm_mail` SET `id_user` = '10', `id_kont` = '$ku[id]', `msg` = 'Ув.администрация зайдите в чат,в комнату общение.', `time` = '$time', `type` = 'to'");
}
else
{
$rm=$lk-$ku['rubies'];
$_SESSION['no_rubies']=$rm;
}
header("Location:/?chat=1177");
}
echo "<div class='block'><h1>Подтверждение</h1></div><div class='content'><ul class='block'><li><span>Вызов администрации</span>: <span><span class='epic'> Вызов администрации </span></span><br/><span></span></li><li class='pt'><img alt='*' width='16' height='16' src='images/icons/tick.png'> <a href='/?chat=1177&md&da'><span>Да, подтверждаю</span></a></li><li><img alt='*' width='16' height='16' src='images/icons/cross.png'> <a href='/?chat=1177'><span>Нет, отказываюсь</span></a></li></ul>";
include "sys/other/foot.php";
}
echo "<div class='block'>";
echo '<div class="content"><ul>';
/////Тут функции
$result = mysql_query("SELECT * FROM `farm_user` ORDER BY `liderchat` DESC LIMIT 1");
while($msg = mysql_fetch_assoc($result)){
echo'<center>Лидер по сообщениям ';
echo "".on_k($msg['id'])."";
echo'<span><a class="" href="/center"> '.nc($msg['id']).' </span></a> (<img width="16" height="16" src="/images/novo/w512h5121381942911socialmedia.png" alt="o"> <span class="title">'.rating($msg[liderchat]).'</span>)<br/></center>';
}
echo '<hr size="2" color="#114411"/>';
echo "<center> <a href='/chat-$chat[id]/".(rand(100000000,900000000))."'>обновить страницу</a>";
echo " или <a href='/chat-$chat[id]".(!isset($_GET['write'])?"/write":null)."'>написать сообщение</a></center> ";
echo '<hr size="2" color="#114411"/>';
if(isset($_GET['add']) && $_GET['add']=='ok' && isset($_GET['write']) && !isset($molchi))
{
$msg=$_POST['msg'];
include 'sys/fnc/fnc_spam.php';
if($msg==NULL)
{
echo err_game("Слишком короткое сообщение ");
$err=1;
}
elseif($ku['level']<7)
{
$err=1;
echo err_game("Писать в чат можно с 7 уровня");
}
elseif($ku['time']<1000)
{
$err=1;
echo err_game("Чтобы писать сообщения нужно провести 16 минут в игре!");
}
if(!isset($err))
{
$qq=mysql_query("SELECT * FROM `farm_zadanie` WHERE `id_user` = '$ku[id]' AND `id_zadanie` = '5'");
while($poster=mysql_fetch_array($qq))
{
if($poster['kol_user_nado']!=$poster['kol_user'])
{
mysql_query("UPDATE `farm_zadanie` SET `kol_user` = '".($poster['kol_user']+1)."' WHERE `id_user` = '$ku[id]' AND `id_zadanie` = '5' LIMIT 1");
}
}
/////
if($ku['limit_nail']<$limit_nail)
{
if($ku['ur_dom']==6){}else
{
if($ku['level']>=10)
{
$rand_off=rand(1,20);
if($rand_off=7)
{
$bansay=1;
$kbfijgia=$ku['nail']+$bansay;
$kbfijgisa=$ku['limit_nail']+$bansay;
mysql_query("UPDATE `farm_user` SET `nail` = '$kbfijgia' WHERE `id` = '$ku[id]' LIMIT 1");
mysql_query("UPDATE `farm_user` SET `limit_nail` = '$kbfijgisa' WHERE `id` = '$ku[id]' LIMIT 1");
$text="Поздоровляем , вы нашли гвозди при сборе урожая на грядках";
if($ku['dontSendMessageChest']==0)
{
mysql_query("INSERT INTO `farm_mail` SET `id_user` = '$ku[id]', `id_kont` = '0', `msg` = '$text', `time` = '".time()."', `type` = 'to'");
}}}}}
///////
mysql_query("UPDATE `farm_user` SET `chat_count` = '1'");
mysql_query("INSERT INTO `farm_chat` SET `msg` = '".my_esc($msg)."', `id_user` = '$ku[id]', `type` = 'komm', `mother` = '$chat[id]', `time` = '$time'".(isset($otv)?", `otvet` = '$otv[id]'":null)."");
mysql_query("UPDATE `farm_user` SET `rubies` = '".($ku['rubies']+2)."' WHERE `id` = '$ku[id]'");
mysql_query("UPDATE `farm_user` SET `otvets` = '".($ku['otvets']+1)."' WHERE `id` = '$otv[id]'");
mysql_query("UPDATE `farm_user` SET `liderchat` = '".($ku['liderchat']+1)."' WHERE `id` = '$ku[id]'");
header("Location:?chat=$chat[id]&write=yes");
exit;
}
}
if(isset($_GET['write']))
{
if($ban['id'])
{
echo "
<div>
<li class='major'><span>".($ban['izg']==1?'БАН':"Обет Молчания до ".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></ul>";
}
else echo "<center><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></center>";
}
$k_post = mysql_result(mysql_query("SELECT COUNT(*) FROM `farm_chat` WHERE `type` = 'komm' AND `mother` = '$chat[id]'"),0);
if ($k_post==0)
{
echo "<li>пустo...</li>";
}
$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 `farm_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 `farm_user` WHERE `id` = '$post[id_user]'"));
if($post['otvet']!=0 && mysql_result(mysql_query("SELECT COUNT(*) FROM `farm_user` WHERE `id` = '$post[otvet]'"),0)!=0)
{
$ot=mysql_fetch_array(mysql_query("SELECT * FROM `farm_user` WHERE `id` = '$post[otvet]'"));
}
$kuzens=$post['id'];
echo "<li class='pt'><span>";
echo on_k($ank['id']);
if($ank['cvetnikl'] == 1){
echo '<font style="background: url(http://vkolhoze.com/pavelgrey/bling1.gif) repeat scroll 9% 0% transparent; font-weight: bold ; text-shadow:0px 0px 15px;"><font color="">';
}
elseif($ank['cvetnikl'] == 2){
echo '<font style="background: url(http://vkolhoze.com/pavelgrey/bling2.gif) repeat scroll 10% 0% transparent; font-weight: bold ; text-shadow:0px 0px 15px;"><font color="">';
}
elseif($ank['cvetnikl'] == 3){
echo '<font style="background: url(http://vkolhoze.com/pavelgrey/bling3.gif) repeat scroll 10% 0% transparent; font-weight: bold ; text-shadow:0px 0px 15px;"><font color="">';
}
elseif($ank['cvetnikl'] == 4){
echo '<font style="background: url(http://vkolhoze.com/pavelgrey/bling4.gif) repeat scroll 10% 0% transparent; font-weight: bold ; text-shadow:0px 0px 15px;"><font color="">';
}
elseif($ank['cvetnikl'] == 5){
echo '<font style="background: url(http://vkolhoze.com/pavelgrey/bling5.gif) repeat scroll 10% 0% transparent; font-weight: bold ; text-shadow:0px 0px 15px;"><font color="">';
}
elseif($ank['cvetnikl'] == 6){
echo '<font style="background: url(http://vkolhoze.com/pavelgrey/bling6.gif) repeat scroll 10% 0% transparent; font-weight: bold ; text-shadow:0px 0px 15px;"><font color="">';
}
elseif($ank['cvetnikl'] == 7){
echo '<font style="background: url(http://vkolhoze.com/pavelgrey/bling7.gif) repeat scroll 10% 0% transparent; font-weight: bold ; text-shadow:0px 0px 15px;"><font color="">';
}
elseif($ank['cvetnikl'] == 8){
echo '<font style="background: url(http://vkolhoze.com/pavelgrey/bling8.gif) repeat scroll 900% 500% transparent; font-weight: bold ; text-shadow:15px 15px 20px; ">';
}
elseif($ank['cvetnikl'] == 9){
echo '<font style="background: url(http://vkolhoze.com/pavelgrey/bling9.gif) repeat scroll 900% 500% transparent; font-weight: bold ; text-shadow:0px 0px 20px;">';
}
echo " <a href='?user=$ank[id]'>".nc($ank['id'])."</a><span class='minor small'> <span>".($time-$post['time']<=2592000?"".time_left($time-$post['time'])."</span> назад</span>":"".vremja($post['time'])."</span>")."</span></span></div><div class='title'><p>".(($post['otvet']!=0)?"".($ku['id']==$ot['id']?"<span class='rare'>":null)."$ot[nick]".($ku['id']==$ot['id']?"</span>":null).", ":null)."".output_text($post['msg'], $ank['id'], $kuzens)."</p></div><div>".($ank['id']!=$ku['id']?"<a class='small minor' href='?chat=$chat[id]&otv=$ank[id]&write'>[ответить]</a><a href='?mail&new_msg=$ank[id]'><font color='#79CDCD'> [в лс]</font></a></font> <a href='?presents=$ank[id]&do'> <font color='#CDB7B5'>[подарить]</font>":null)."";
if($ku['status']>0)echo " <a class='small minor' href='?chat=$chat[id]&del_komm=$post[id]'>[удалить]</a>";
echo "</li>";
}
if ($k_page>1)str("?chat=$chat[id]&",$k_page,$page); // Вывод страниц
echo "</ul>";
echo "<ul class='pt'>";
echo "<li></li>";
echo "<div><img width='16' height='16' src='images/icons/smiles.png' alt='o'> <a href='?smiles'>Смайлы</a></div>";
if($ku['status']>0)echo "<li><img alt='o' width='16' height='16' src='images/icons/delete.png'> <a href='?chat=$chat[id]&del'>Удалить</a></li>";
if($ku['status']>0)echo "<li><img alt='o' width='16' height='16' src='images/icons/delete.png'> <a href='?chat=$chat[id]&clean'>Очистить комнату</a></li>";
if($ku['status']>0)echo "<li><img alt='o' width='16' height='16' src='images/icons/forum_edit.png'> <a href='?chat=$chat[id]&edit'>Изменить название</a></li>";
echo "</ul></div></div>";
include_once 'sys/other/foot.php';
}
}
else
{
if(isset($_GET['add']) && $ku['status']>0)
{
echo '<title>Создание комнаты</title>';
if($_GET['add']=='ok')
{
$name=$_POST['name'];
$opis=$_POST['opis'];
if($name==NULL)
{
echo err_game("Слишком короткое название");
$err=1;
}
if(!isset($err))
{
mysql_query("UPDATE `farm_user` SET `chat_count` = '1'");
if($_POST['admod']==1)$admod=1;else $admod=0;
$pos=mysql_result(mysql_query("SELECT MAX(`pos`) FROM `farm_chat` WHERE `type` = 'room'"), 0)+1;
mysql_query("INSERT INTO `farm_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 'sys/other/foot.php';
}
else
{
if (isset($_GET['up']) && $ku['status']>0)
{
$up=mysql_fetch_assoc(mysql_query("SELECT * FROM `farm_chat` WHERE `id` = '".intval($_GET['up'])."' AND `type` = 'room' LIMIT 1"));
if(mysql_result(mysql_query("SELECT COUNT(*) FROM `farm_chat` WHERE `pos` < '$up[pos]' AND `type` = 'room' LIMIT 1"),0)!=0)
{
mysql_query("UPDATE `farm_chat` SET `pos` = '".($up['pos'])."' WHERE `pos` = '".($up['pos']-1)."' AND `type` = 'room' LIMIT 1");
mysql_query("UPDATE `farm_chat` SET `pos` = '".($up['pos']-1)."' WHERE `id` = '".intval($_GET['up'])."' AND `type` = 'room' LIMIT 1");
}
}
elseif (isset($_GET['down']) && $ku['status']>0)
{
$down=mysql_fetch_assoc(mysql_query("SELECT * FROM `farm_chat` WHERE `id` = '".intval($_GET['down'])."' AND `type` = 'room' LIMIT 1"));
if(mysql_result(mysql_query("SELECT COUNT(*) FROM `farm_chat` WHERE `pos` > '$down[pos]' AND `type` = 'room' LIMIT 1"),0)!=0)
{
mysql_query("UPDATE `farm_chat` SET `pos` = '".($down['pos'])."' WHERE `pos` = '".($down['pos']+1)."' AND `type` = 'room' LIMIT 1");
mysql_query("UPDATE `farm_chat` SET `pos` = '".($down['pos']+1)."' WHERE `id` = '".intval($_GET['down'])."' AND `type` = 'room' LIMIT 1");
}
}
echo '<div class="content"><div class="block"><ul>';
$q=mysql_query("SELECT * FROM `farm_chat` WHERE `type` = 'room'".($ku['status']<=0?" AND `admod` = '0'":null)." ORDER BY `pos` ASC");
while($post=mysql_fetch_array($q))
{
echo "<li><div><img width='16' height='16' src='images/icons/chat.png' alt='o'> <a href='?chat=$post[id]'><span>".hsc($post['name'])."</span></a> <a href='/chat/onlineChat'><span class='title'>(".mysql_result(mysql_query("SELECT COUNT(*) FROM `online_chat`"),0).")</a></span></div>".(strlen2($post['opis'])!=NULL?"<div class='minor small'>".hsc($post['opis'])."</div>":null)."";
if(isset($_GET['moderate']) && $ku['status']>0)echo "<a href='?chat&moderate&up=$post[id]'><img width='16' height='16' src='images/icons/up.png' alt='o'></a> <a href='?chat&moderate&down=$post[id]'><img width='16' height='16' src='images/icons/down.png' alt='o'></a>";
echo "</li>";
}
echo "</ul>";
echo "<ul class='pt'>";
if($ku['status']>0)echo "<li><img width='16' height='16' src='images/icons/moderate.png' alt='o'> <a href='?chat".(!isset($_GET['moderate'])?"&moderate":null)."'>Управление</a></li><li><img width='16' height='16' src='images/icons/chat.png' alt='*' title='*'> <a href='?chat&add'>Создать комнату</a></li>";
echo "</ul></div></div>";
?>
<title>Куда идем ? </title>
<?
include_once 'sys/other/foot.php';
}
}
echo "</div>";
include_once "sys/other/foot.php";
?>