Файл: important/important_chat.php
Строк: 136
<?php
$g=mysql_query("SELECT * FROM `bishopl2_personaz` WHERE `login`='$login' AND `chat`='1' LIMIT 1");
if(mysql_num_rows($g)==1){
$as = mysql_query("SELECT * FROM `bishopl2_personaz` WHERE `login`='".$login."'");
$pers = mysql_fetch_array($as);
if (isset($allchatdelete)){
if ($pers[acces_level]=="200" || $pers[acces_level]=="100"){
$g=mysql_query("SELECT * FROM `bishopl2_chat` WHERE `id`='$id' LIMIT 1");
if(mysql_num_rows($g)==1){
mysql_query("DELETE FROM `bishopl2_chat` WHERE `id`='".$id."'");
}else{}
}else{}
header("Location: ?");
exit;
}
if (isset($allchatsave)){
$g=mysql_query("SELECT * FROM `bishopl2_ban` WHERE `login`='$login' LIMIT 1");
if(mysql_num_rows($g)==1){
header("Location: ?");
exit;
}
if ($pers[lvl]<"9"){
header("Location: ?");
exit;
}
if ($msgs==""){
header("Location: ?");
exit;
}
if (strlen($msgs) > 1000) {
header("Location: ?");
exit;
}
if ($pers[post]>"0"){
$msgs=str_replace(":)","<img src="pictures/smile/1.gif" alt=":)"/>",$msgs);
$msgs=str_replace(":(","<img src="pictures/smile/2.gif" alt=":("/>",$msgs);
$msgs=str_replace(":*","<img src="pictures/smile/3.gif" alt=":*"/>",$msgs);
$msgs=str_replace(":P","<img src="pictures/smile/4.gif" alt=":P"/>",$msgs);
}
if ($pers[post]>"999"){
$msgs=str_replace(".lala.","<img src="pictures/smile/5.gif" alt=".lala."/>",$msgs);
$msgs=str_replace(".fuck.","<img src="pictures/smile/6.gif" alt=".fuck."/>",$msgs);
$msgs=str_replace(".haha.","<img src="pictures/smile/7.gif" alt=".haha."/>",$msgs);
$msgs=str_replace(".gg.","<img src="pictures/smile/8.gif" alt=".gg."/>",$msgs);
$msgs=str_replace(".vinni.","<img src="pictures/smile/9.gif" alt=".vinni."/>",$msgs);
$msgs=str_replace(".be.","<img src="pictures/smile/10.gif" alt=".be."/>",$msgs);
$msgs=str_replace(".hlopaem.","<img src="pictures/smile/11.gif" alt=".hlopaem."/>",$msgs);
$msgs=str_replace(".plak.","<img src="pictures/smile/12.gif" alt=".plak."/>",$msgs);
$msgs=str_replace(".poka.","<img src="pictures/smile/13.gif" alt=".poka."/>",$msgs);
$msgs=str_replace(".svadba.","<img src="pictures/smile/14.gif" alt=".svadba."/>",$msgs);
$msgs=str_replace(".cvety.","<img src="pictures/smile/15.gif" alt=".cvety."/>",$msgs);
}
if ($pers[post]>"2999"){
$msgs=str_replace(".ups.","<img src="pictures/smile/16.gif" alt=".ups."/>",$msgs);
$msgs=str_replace(".nono.","<img src="pictures/smile/17.gif" alt=".nono."/>",$msgs);
$msgs=str_replace(".revet.","<img src="pictures/smile/18.gif" alt=".revet."/>",$msgs);
$msgs=str_replace(".upsgirl.","<img src="pictures/smile/19.gif" alt=".upsgirl."/>",$msgs);
$msgs=str_replace(".ex.","<img src="pictures/smile/20.gif" alt=".ex."/>",$msgs);
$msgs=str_replace(".dro4il.","<img src="pictures/smile/21.gif" alt=".dro4il."/>",$msgs);
}
if ($pers[post]>"6999"){
$msgs=str_replace(".spam.","<img src="pictures/smile/22.gif" alt=".spam."/>",$msgs);
$msgs=str_replace(".lol.","<img src="pictures/smile/23.gif" alt=".lol."/>",$msgs);
$msgs=str_replace(".ng.","<img src="pictures/smile/24.gif" alt=".ng."/>",$msgs);
}
if ($pers[acces_level]=="100"){
$msgs=str_replace(".bomba.","<img src="pictures/smile/25.gif" alt=".bomba."/>",$msgs);
$msgs=str_replace(".hear.","<img src="pictures/smile/26.gif" alt=".hear."/>",$msgs);
$msgs=str_replace(".piska.","<img src="pictures/smile/27.gif" alt=".piska."/>",$msgs);
$msgs=str_replace(".doloj.","<img src="pictures/smile/28.gif" alt=".doloj."/>",$msgs);
$msgs=str_replace(".hool.","<img src="pictures/smile/32.gif" alt=".hool."/>",$msgs);
}
if ($pers[acces_level]=="200"){
$msgs=str_replace(".rediska.","<img src="pictures/smile/29.gif" alt=".rediska."/>",$msgs);
$msgs=str_replace(".bat.","<img src="pictures/smile/30.gif" alt=".bat."/>",$msgs);
$msgs=str_replace(".admin.","<img src="pictures/smile/31.gif" alt=".admin."/>",$msgs);
$msgs=str_replace(".hool.","<img src="pictures/smile/32.gif" alt=".hool."/>",$msgs);
}
// Заносим сообщение в БД
$time = time();
mysql_query("INSERT INTO `bishopl2_chat` SET `id` = '', `login` = '$login', `time` = '$time', `msg` = '$msgs', `nick` = '$idf'");
// Делаем запись пользователя в флуд
$time=time();
mysql_query("INSERT INTO `bishopl2_antiflood` SET `login` = '$login', `time` = '$time'");
$as = mysql_query("SELECT * FROM `bishopl2_personaz` WHERE `login`='".$login."'");
$pers = mysql_fetch_array($as);
// Добавляем посты за сообщения
$post=$pers[post]+1;
mysql_query("UPDATE `bishopl2_personaz` SET `post`='$post' WHERE `login`='$login'");
header("Location: ?");
exit;
}
$g=mysql_query("SELECT * FROM `bishopl2_personaz` WHERE `login`='$idf' LIMIT 1");
if(mysql_num_rows($g)==1){
if (isset($idf)){
echo '<form method="post" action="?allchatsave&idf='.$idf.'">';
echo 'Ответ персонажу '.$idf.'<br/>';
echo '<textarea cols="20" rows="2" class="button" name="msgs"></textarea><br/>';
echo '<input class="bt" type="submit" value="Написать"/></form>';
}}else{
echo'<form method="post" action="?allchatsave">';
echo '<textarea cols="20" rows="2" class="button" name="msgs"></textarea><br/>';
echo '<input class="bt" type="submit" value="Написать"/></form>';
}
$num = 5;
$page = $_GET['page'];
$q = mysql_query("SELECT COUNT(`id`) FROM `bishopl2_chat`");
$posts = mysql_result($q, 0);
$total = intval(($posts - 1) / $num) + 1;
$page = intval($page);
if(empty($page) or $page < 0) $page = 1;
if($page > $total) $page = $total;
$start = $page * $num - $num;
$qi = mysql_query("SELECT * FROM `bishopl2_chat` ORDER by `id` DESC LIMIT $start, $num");
while($chat=mysql_fetch_array($qi))
{
$time=time();
if (($time-$chat[time])>="86400"){
$chat[time]=date("j M Y в H:i", $chat[time]);
$chat[time] = strtr($chat[time], array ("Jan" => "Янв","Feb" => "Фев","Mar" => "Марта","May" => "Мая","Apr" => "Апр","Jun" => "Июня","Jul" => "Июля","Aug" => "Авг","Sep" => "Сент","Oct" => "Окт","Nov" => "Ноября","Dec" => "Дек",));
}else{
$timer=$time-$chat[time];
$ost=@date("i",$timer);
$time2=time()-10800;
$timer2=$time2-$chat[time];
$ost2=@date("H",$timer2);
if($ost2>0){
$chat[time]=@date("H ч. i мин. s сек. назад",$timer2);
}else{
if($ost>0){
$chat[time]=@date("i мин. s сек. назад",$timer);
}else{
$chat[time]=@date("s сек. назад",$timer);
}}}
$as = mysql_query("SELECT * FROM `bishopl2_personaz` WHERE `login`='".$login."'");
$pers2 = mysql_fetch_array($as);
if ($pers2[acces_level]=="200" || $pers2[acces_level]=="100"){
echo '[<a href="?allchatdelete&id='.$chat[id].'"><font color="lime">X</font></a>] ';
}
//альянс
$as = mysql_query("SELECT * FROM `bishopl2_clanlist` WHERE `login`='".$chat[login]."'");
$clan1 = mysql_fetch_array($as);
$g=mysql_query("SELECT * FROM `bishopl2_allylist` WHERE `name`='".$clan1[name]."' LIMIT 1");
if(mysql_num_rows($g)==1){
$as = mysql_query("SELECT * FROM `bishopl2_allylist` WHERE `name`='".$clan1[name]."'");
$ally1 = mysql_fetch_array($as);
$as = mysql_query("SELECT * FROM `bishopl2_ally` WHERE `id`='".$ally1[id]."'");
$ally2 = mysql_fetch_array($as);
if ($ally2[img]!==""){
echo '<img src="'.$ally2[img].'" alt=".">';
}}
//клан
$g=mysql_query("SELECT * FROM `bishopl2_clanlist` WHERE `login`='".$chat[login]."' LIMIT 1");
if(mysql_num_rows($g)==1){
$as = mysql_query("SELECT * FROM `bishopl2_clanlist` WHERE `login`='".$chat[login]."'");
$clan1 = mysql_fetch_array($as);
$as = mysql_query("SELECT * FROM `bishopl2_clan` WHERE `name`='".$clan1[name]."'");
$clan2 = mysql_fetch_array($as);
if ($clan2[img]!==""){
echo '<img src="'.$clan2[img].'" alt=".">';
}}
if (isset($chat[nick])){
$nick="$chat[nick]";
}
if ($nick==$login){
$nick="<font color='#CD3333'><b>$nick</b></font>";
}
$as = mysql_query("SELECT * FROM `bishopl2_personaz` WHERE `login`='".$chat[login]."'");
$pers = mysql_fetch_array($as);
if ($pers[acces_level]=="200"){
$nik = gradient(''.$chat[login].'.GM','FFA500', 'FFFF00');
echo '<a href="information?id='.$chat[login].'">'.$nik.'</a> <a href="?idf='.$chat[login].'"><img src="pictures/other/chat.gif"></a> <small>['.$chat[time].']</small><br/><u>'.$nick.'</u> <font color="lime">'.$chat[msg].'</font><br/>';
}else{
if ($pers[acces_level]=="100"){
$nik = gradient(''.$chat[login].'.MD','551A8B', 'AB82FF');
echo '<a href="information?id='.$chat[login].'">'.$nik.'</a> <a href="?idf='.$chat[login].'"><img src="pictures/other/chat.gif"></a> <small>['.$chat[time].']</small><br/><u>'.$nick.'</u> <font color="lime">'.$chat[msg].'</font><br/>';
}else{
echo '<a href="information?id='.$chat[login].'">'.$chat[login].'</a> <a href="?idf='.$chat[login].'"><img src="pictures/other/chat.gif"></a> <small>['.$chat[time].']</small><br/><u>'.$nick.'</u> '.$chat[msg].'<br/>';
}}
}
$q = mysql_query("SELECT COUNT(`id`) FROM `bishopl2_chat`");
$kol = mysql_result($q, 0);
if ($kol=="0"){
echo 'Сообщений нет<br/>';
}
if ($page != 1) $pervpage = '<a href= ?page=1><<</a>
<a href= ?page='. ($page - 1) .'><</a> ';
if ($page != $total) $nextpage = ' <a href= ?page='. ($page + 1) .'>></a>
<a href= ?page=' .$total. '>>></a>';
if($page - 2 > 0) $page2left = ' <a href= ?page='. ($page - 2) .'>'. ($page - 2) .'</a> | ';
if($page - 1 > 0) $page1left = '<a href= ?page='. ($page - 1) .'>'. ($page - 1) .'</a> | ';
if($page + 2 <= $total) $page2right = ' | <a href= ?page='. ($page + 2) .'>'. ($page + 2) .'</a>';
if($page + 1 <= $total) $page1right = ' | <a href= ?page='. ($page + 1) .'>'. ($page + 1) .'</a>';
}
?>