Обучение/Помощь новичкам | Чат в игре
YMGYROFF 
DrozD
Ka[Mp]Er , Ванга mode on. Код давай...
CreepMatis
CreepMatis , <?
require_once 'core/system.php';
echo only_reg();
if(!$user) { header('location: /'); exit; }
$header = ($_GET['clan'] == true) ? 'Таверна ордена':'Общий чат';
require_once 'core/head.php';
///echo '<div class=\'mini-line\'></div>';
if($user['level'] < 0) {
}
else
{
echo '<div class=\'menu\'>';
if($user['level'] < 0) {
echo '<li><font color=\'#909090\'>Писать в чат можно с <img src=\'/images/icon/level.png\' alt=\'\'5-го уровня</font></li>';
}
else
{
$text = _string($_POST['text']);
$to = _num($_GET['to']);
if($to) {
$_to = mysql_query('SELECT * FROM `user` WHERE `id` = "'.$to.'"');
$_to = mysql_fetch_array($_to);
if(!$_to OR $_to['id'] == $user['id']) {
header('location: /chat/'.($_GET['clan'] == true ? 'orden/':''));
exit;
}
}
if($text && $user['level'] > 2) {
$antiflood = mysql_fetch_array(mysql_query('SELECT * FROM `chat` WHERE `clan` = \''.($_GET['clan'] == true ? $clan['id']:0).'\' AND `user` = \''.$user['id'].'\' ORDER BY `time` DESC LIMIT 1'));
if(time() - $antiflood['time'] < 5) $errors[] = 'Ошибка, писать можно 1 раз в 5 секунд';
if($errors) {
echo '<div class=\'content\' align=\'center\'>';
foreach($errors as $error) {
echo $error.'<br/>';
}
echo '</div>
<div class=\'mini-line\'></div>';
}
else
{
if($_to) {
$text = str_replace($_to['nick'].' ', '', $text);
}
mysql_query('INSERT INTO `chat` (`clan`,
`user`,
`to`,
`text`,
`time`) VALUES ("'.($_GET['clan'] == true ? $clan['id']:0).'",
"'.$user['id'].'",
"'.$_to['id'].'",
"'.$text.'",
"'.time().'")');
header('location: /chat/'.($_GET['clan'] == true ? 'orden/':''));
}
}
?>
<form action='/chat/<?=($_GET['clan'] == true ? 'orden/':'')?>?to=<?=$to?>' method='post'>
<input class='text medium-text' name='text' style='width: 60%;' value="<?=($to ? $_to['-'].'-> ':'')?>"/><br/>
<span class='btn'><span class='end'><input class='label' type='submit' value='Отправить'></span></span> <a href='/chat/<?=($_GET['clan'] == true ? 'orden/':'')?>'>
<font color='#909090'>Обновить</font></a><br/><br/></div>
</form>
<?
}
?>
<?
$max = 15;
$count = mysql_result(mysql_query('SELECT COUNT(*) FROM `chat` WHERE `clan` = "'.($_GET['clan'] == true ? $clan['id']:0).'"'),0);
$pages = ceil($count/$max);
$page = _string(_num($_GET['page']));
if($page > $pages) {
$page = $pages;
}
if($page < 1) {
$page = 1;
}
$start = $page * $max - $max;
if($count > 0) {
$msg = _string(_num($_GET['msg']));
if($msg) {
$i_msg = mysql_query('SELECT * FROM `chat` WHERE `id` = "'.$msg.'"');
$i_msg = mysql_fetch_array($i_msg);
if(!$i_msg) {
header('location: /chat/'.($_GET['clan'] == true ? 'orden/':'').'?page='.$page);
exit;
}
if($_GET['clan'] == true && $clan_memb['rank'] == 4 OR $user['prava'] >= 3) {
mysql_query('DELETE FROM `chat` WHERE `clan` = "'.($_GET['clan'] == true ? $clan['id']:0).'" AND`id` = "'.$i_msg['id'].'"');
}
header('location: /chat/'.($_GET['clan'] == true ? 'orden/':'').'?page='.$page);
}
$q = mysql_query('SELECT * FROM `chat` WHERE `clan` = "'.($_GET['clan'] == true ? $clan['id']:0).'" ORDER BY `id` DESC LIMIT '.$start.', '.$max.'');
while($row = mysql_fetch_array($q)) {
if($row['to'] == $user['id'] && $row['read'] == 0) {
mysql_query('UPDATE `chat` SET `read` = "1" WHERE `id` = "'.$row['id'].'"');
}
$sender = mysql_query('SELECT * FROM `user` WHERE `id` = "'.$row['user'].'"');
$sender = mysql_fetch_array($sender);
echo online($sender['id']);
?>
<a href='/user/?id=<?=$sender['id']?>'><?=$sender['nick']?></a><?
if($sender['id'] != $user['id']) {
?> <a href='/chat/<?=($_GET['clan'] == true ? 'orden/':'')?>?to=<?=$sender['id']?>'> (»)</a><?
}
?>:<?
if($row['to']) {
$__to = mysql_query('SELECT * FROM `user` WHERE `id` = "'.$row['to'].'"');
$__to = mysql_fetch_array($__to);
if($__to['id'] == $user['id']) {
?>
<font color='#90c090'>
<?
}
?>
<?=$__to['nick']?>
<?
if($__to['id'] == $user['id']) {
?>
</font>
<?
}
}
if($sender['prava'] == 4) {
?>
<font color='#E99534'>
<?
}
if($sender['prava'] == 245345) {
?>
<font color='#BC8F9F'>
<?
}
?>
<?
if($sender['prava'] == 5) {
?>
<font color='#87CEEB'>
<?
}
?>
<?=smiles($row['text'])?>
<?
if($sender['prava'] > 0) {
?>
</font>
<?
}
if($user['prava'
require_once 'core/system.php';
echo only_reg();
if(!$user) { header('location: /'); exit; }
$header = ($_GET['clan'] == true) ? 'Таверна ордена':'Общий чат';
require_once 'core/head.php';
///echo '<div class=\'mini-line\'></div>';
if($user['level'] < 0) {
}
else
{
echo '<div class=\'menu\'>';
if($user['level'] < 0) {
echo '<li><font color=\'#909090\'>Писать в чат можно с <img src=\'/images/icon/level.png\' alt=\'\'5-го уровня</font></li>';
}
else
{
$text = _string($_POST['text']);
$to = _num($_GET['to']);
if($to) {
$_to = mysql_query('SELECT * FROM `user` WHERE `id` = "'.$to.'"');
$_to = mysql_fetch_array($_to);
if(!$_to OR $_to['id'] == $user['id']) {
header('location: /chat/'.($_GET['clan'] == true ? 'orden/':''));
exit;
}
}
if($text && $user['level'] > 2) {
$antiflood = mysql_fetch_array(mysql_query('SELECT * FROM `chat` WHERE `clan` = \''.($_GET['clan'] == true ? $clan['id']:0).'\' AND `user` = \''.$user['id'].'\' ORDER BY `time` DESC LIMIT 1'));
if(time() - $antiflood['time'] < 5) $errors[] = 'Ошибка, писать можно 1 раз в 5 секунд';
if($errors) {
echo '<div class=\'content\' align=\'center\'>';
foreach($errors as $error) {
echo $error.'<br/>';
}
echo '</div>
<div class=\'mini-line\'></div>';
}
else
{
if($_to) {
$text = str_replace($_to['nick'].' ', '', $text);
}
mysql_query('INSERT INTO `chat` (`clan`,
`user`,
`to`,
`text`,
`time`) VALUES ("'.($_GET['clan'] == true ? $clan['id']:0).'",
"'.$user['id'].'",
"'.$_to['id'].'",
"'.$text.'",
"'.time().'")');
header('location: /chat/'.($_GET['clan'] == true ? 'orden/':''));
}
}
?>
<form action='/chat/<?=($_GET['clan'] == true ? 'orden/':'')?>?to=<?=$to?>' method='post'>
<input class='text medium-text' name='text' style='width: 60%;' value="<?=($to ? $_to['-'].'-> ':'')?>"/><br/>
<span class='btn'><span class='end'><input class='label' type='submit' value='Отправить'></span></span> <a href='/chat/<?=($_GET['clan'] == true ? 'orden/':'')?>'>
<font color='#909090'>Обновить</font></a><br/><br/></div>
</form>
<?
}
?>
<?
$max = 15;
$count = mysql_result(mysql_query('SELECT COUNT(*) FROM `chat` WHERE `clan` = "'.($_GET['clan'] == true ? $clan['id']:0).'"'),0);
$pages = ceil($count/$max);
$page = _string(_num($_GET['page']));
if($page > $pages) {
$page = $pages;
}
if($page < 1) {
$page = 1;
}
$start = $page * $max - $max;
if($count > 0) {
$msg = _string(_num($_GET['msg']));
if($msg) {
$i_msg = mysql_query('SELECT * FROM `chat` WHERE `id` = "'.$msg.'"');
$i_msg = mysql_fetch_array($i_msg);
if(!$i_msg) {
header('location: /chat/'.($_GET['clan'] == true ? 'orden/':'').'?page='.$page);
exit;
}
if($_GET['clan'] == true && $clan_memb['rank'] == 4 OR $user['prava'] >= 3) {
mysql_query('DELETE FROM `chat` WHERE `clan` = "'.($_GET['clan'] == true ? $clan['id']:0).'" AND`id` = "'.$i_msg['id'].'"');
}
header('location: /chat/'.($_GET['clan'] == true ? 'orden/':'').'?page='.$page);
}
$q = mysql_query('SELECT * FROM `chat` WHERE `clan` = "'.($_GET['clan'] == true ? $clan['id']:0).'" ORDER BY `id` DESC LIMIT '.$start.', '.$max.'');
while($row = mysql_fetch_array($q)) {
if($row['to'] == $user['id'] && $row['read'] == 0) {
mysql_query('UPDATE `chat` SET `read` = "1" WHERE `id` = "'.$row['id'].'"');
}
$sender = mysql_query('SELECT * FROM `user` WHERE `id` = "'.$row['user'].'"');
$sender = mysql_fetch_array($sender);
echo online($sender['id']);
?>
<a href='/user/?id=<?=$sender['id']?>'><?=$sender['nick']?></a><?
if($sender['id'] != $user['id']) {
?> <a href='/chat/<?=($_GET['clan'] == true ? 'orden/':'')?>?to=<?=$sender['id']?>'> (»)</a><?
}
?>:<?
if($row['to']) {
$__to = mysql_query('SELECT * FROM `user` WHERE `id` = "'.$row['to'].'"');
$__to = mysql_fetch_array($__to);
if($__to['id'] == $user['id']) {
?>
<font color='#90c090'>
<?
}
?>
<?=$__to['nick']?>
<?
if($__to['id'] == $user['id']) {
?>
</font>
<?
}
}
if($sender['prava'] == 4) {
?>
<font color='#E99534'>
<?
}
if($sender['prava'] == 245345) {
?>
<font color='#BC8F9F'>
<?
}
?>
<?
if($sender['prava'] == 5) {
?>
<font color='#87CEEB'>
<?
}
?>
<?=smiles($row['text'])?>
<?
if($sender['prava'] > 0) {
?>
</font>
<?
}
if($user['prava'
Ay
Ka[Mp]Er , смотри в таблицу, подставь значения вручную и через дюбой менеджер БД проверь выполнение запроса, судя по всему с запросом косяк
VarrkaN
VarrkaN , не понял
Ka[Mp]Er , PHPMyAdmin юзай, запросы вручную делай =)