Файл: forum.php
Строк: 304
<?
include './system/common.php';
include './system/functions.php';
include './system/user.php';
if(!$user) {
header('location: /');
exit;
}
$sub = _string(_num($_GET['sub']));
$topic = _string(_num($_GET['topic']));
if(!$sub && !$topic) {
$title = 'Форум';
include './system/h.php';
?>
<div class="title-top"> Форум</div>
<?
$count = mysql_result(mysql_query('SELECT COUNT(*) FROM `forum_sub`'),0);
if($count > 0) {
if($_GET['create'] == true && $user['access'] == 2) {
$name = _string($_POST['name']);
$access = _string(_num($_POST['access']));
if($name) {
mysql_query('INSERT INTO `forum_sub` (`name`,
`access`) VALUES ("'.$name.'",
"'.$access.'")');
header('location: /forum/');
}
?>
<div class='content'>
<form action='/forum/?create=true' method='post'>
Название раздела:<br/>
<input name='name'/><br/>
Создавать топики могут:<br/>
<select name='access'>
<option value='0'>все</option>
<option value='1'>модераторы</option>
<option value='2'>администраторы</option>
</select><br/>
<input type='submit' value='Создать'/>
</form>
</div>
<div class='line'></div>
<?
}
$id = _string(_num($_GET['id']));
if($id && $user['access'] == 2) {
$i = mysql_query('SELECT * FROM `forum_sub` WHERE `id` = "'.$id.'"');
$i = mysql_fetch_array($i);
if(!$i) {
header('location: /forum/');
exit;
}
$name = _string($_POST['name']);
if($name) {
mysql_query('UPDATE `forum_sub` SET `name` = "'.$name.'" WHERE `id` = "'.$i['id'].'"');
header('location: /forum/?adm=true');
}
?>
<div class='content'>
<form action='/forum/?adm=true&id=<?=$i['id']?>' method='post'>
Название раздела:<br/>
<input name='name' value='<?=$i['name']?>'/> <input type='submit' value='Сохранить'/>
</form>
</div>
<div class='line'></div>
<?
if($_GET['delete'] == true) {
$q = mysql_query('SELECT * FROM `forum_topic` WHERE `sub` = "'.$i['id'].'"');
while($row = mysql_fetch_array($q)) {
mysql_query('DELETE FROM `forum_comments` WHERE `topic` = "'.$row['id'].'"');
}
mysql_query('DELETE FROM `forum_topic` WHERE `sub` = "'.$i['id'].'"');
mysql_query('DELETE FROM `forum_sub` WHERE `id` = "'.$i['id'].'"');
header('location: /forum/?adm=true');
}
}
?>
<div class='list'>
<?
$q = mysql_query('SELECT * FROM `forum_sub`');
while($row = mysql_fetch_array($q)) {
$i++;
?>
<?
if($_GET['adm'] == true && $user['access'] == 2) {
?>
<span style='float: right;'>( <a href='/forum/?adm=true&id=<?=$row['id']?>&delete=true'>Удалить</a> | <a href='/forum/?adm=true&id=<?=$row['id']?>'>Редактировать</a> )</span>
<?
}
?>
<div class="separ2"></div><a href="/forum/sub/<?=$row['id']?>/" class="menu_link"><img src="http://213.239.195.28/xaos/icons_old/violet-folder--plus.png" alt="+"> <?=$row['name']?></a>
<?
}
?>
<?=($_GET['adm'] == true ? '':'')?>
<?
if($user['access'] == 2) {
?>
<a href=''><a class='menu_link' href='/forum/<?=($_GET['adm'] == true ? '':'?adm=true')?>' <?=($_GET['adm'] == true ? 'style='color: #909090;'':'')?>><img src='/images/icon/arrow.png' alt='*'/> Управление форумом</a></a>
<?
if($_GET['adm'] == true) {
?>
<a class='menu_link' href='/forum/?create=true'><img src='/images/icon/arrow.png' alt='*'/> Создать раздел</a>
<?
}
}
?>
</div>
<?
}
else
{
?>
<div class="separ3"></div><a href="/forum/" class="menu_link"><img src="http://213.239.195.28/xaos/icons_old/tick.png" alt=""> Отметить всё как прочитанное</a><div class="separ3"></div>
<div class='content'><font color='#909090'></font></div>
<?
}
include './system/f.php';
}
elseif($sub) {
$sub = mysql_query('SELECT * FROM `forum_sub` WHERE `id` = "'.$sub.'"');
$sub = mysql_fetch_array($sub);
if(!$sub) {
header('location: /forum');
exit;
}
if($_GET['create'] == true && $user['access'] >= $sub['access']) {
$title = 'Новый топик';
include './system/h.php';
?>
<div class='title'><?=$title?></div>
<div class='line'></div>
<?
if($user['save'] == 1) {
$name = _string($_POST['name']);
$text = _string($_POST['text']);
if($name && $text) {
if($user['level'] > 14) {
mysql_query('INSERT INTO `forum_topic` (`sub`,
`name`,
`user`,
`text`,
`time`) VALUES ("'.$sub['id'].'",
"'.$name.'",
"'.$user['id'].'",
"'.$text.'",
"'.time().'")');
$topic_id = mysql_insert_id();
header('location: /forum/topic/'.$topic_id.'/');
}
else
{
?>
<div class='content' align='center'><font color='#909090'>Топики можно создавать с <img src='/images/icon/level.png' alt='*'/> 15 уровня!</font></div>
<div class='line'></div>
<?
}
}
?>
<div class='content'>
<form action='/forum/sub/<?=$sub['id']?>/?create=true' method='post'>
Название топика:<br/>
<input name='name'/><br/>
Оглавление:<br/>
<textarea name='text' style='width: 100%;'></textarea><br/>
<input type='submit' value='Создать'/>
</form>
</div>
<?
}
else
{
?>
<div class='content'><font color='#999'>Для создания топика вам нужно сохранить своего персонажа</font></div>
<?
}
include './system/f.php';
}
else
{
$title = $sub['name'];
include './system/h.php';
?>
<div class="title-top"><a href=""> Форум</a> / </div><div class="separ3"></div>
<?
$max = 10;
$count = mysql_result(mysql_query('SELECT COUNT(*) FROM `forum_topic` WHERE `sub` = "'.$sub['id'].'"'),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) {
?>
<?
$q = mysql_query('SELECT * FROM `forum_topic` WHERE `sub` = "'.$sub['id'].'" ORDER BY `stick` DESC, `id` DESC LIMIT '.$start.', '.$max.'');
while($row = mysql_fetch_array($q)) {
$i++;
?>
<div class="separ2"></div><div class="list"><b><a href="/forum/topic/<?=$row['id']?>/" <?=($row['stick'] == 1 ? 'style="font-weight: bold;"':'')?> class="menu_link"> <span style="color:skyblue"><img src='/images/icon/forum_<?=($row['close'] == 1 ? 3:2)?>.png' alt='*'/> <?=$row['name']?> <span style="color:#5bbd04;vertical-align:middle">*</span></span></a></b>
<?
}
?>
</div><div class="separ3"></div><div class="menu_link2"><div class="div_hr2"></div><center><div class="navi"><?=pages('/forum/sub/'.$sub['id'].'/?')?></div>
</li>
</div>
<?
}
else
{
?>
<div class='content'><font color='#999'>Форум пуст!</font></div>
<?
}
?>
</div>
<?
if($user['access'] >= $sub['access']) {
?>
</center></div><div class="separ2"></div><a href="/forum/sub/<?=$sub['id']?>/" class="menu_link"><img src="http://213.239.195.28/xaos/icons_
old/tick.png" alt=""> Сделать все прочитанным</a><a href="/forum/sub/<?=$sub['id']?>/?create=true" class="menu_link"><img src="http://213.239.195.28/xaos/icons_old/pencil.png" alt=""> Новый топик</a><a href="" class="menu_link"><img src="http://213.239.195.28/xaos/icons_old/exclamation--frame.png" alt=""> Позвать модератора</a><a href="/forum/" class="menu_link"><img src="http://213.239.195.28/xaos/16x16/folders.png" alt=""> К списку разделов</a><div class="separ3"></div>
</div>
<?
}
include './system/f.php';
}
}
elseif($topic) {
$topic = mysql_query('SELECT * FROM `forum_topic` WHERE `id` = "'.$topic.'"');
$topic = mysql_fetch_array($topic);
if(!$topic) {
header('location: /forum');
exit;
}
$title = $topic['name'];
include './system/h.php';
$topic_user = mysql_query('SELECT * FROM `users` WHERE `id` = "'.$topic['user'].'"');
$topic_user = mysql_fetch_array($topic_user);
?>
<div class="title-top"><a href=""> Форум</a> / <?=$topic['name']?></div><div class="separ2"></div><div class="menu_link2" style="padding-left:2px;padding-right:2px;">
<?
if($_GET['adm'] == true && $user['access'] > 0) {
?>
<div class='content'>
<img src='/images/icon/arrow.png' alt='*'/> <a href='/forum/topic/<?=$topic['id']?>/?stick=true'> <?=($topic['stick'] == 0 ? 'Закрепить':'Открепить')?></a> | <a href='/forum/topic/<?=$topic['id']?>/?close=true'> <?=($topic['close'] == 0 ? 'Закрыть':'Открыть')?></a> | <a href='/forum/topic/<?=$topic['id']?>/?delete=true'>Удалить</a>
</div>
<div class='line'></div>
<?
}
?>
<img src="http://213.239.195.28/xaos/style2/<?=$user['r']?>.png" alt=""> <a href="/user/<?=$topic_user['id']?>/" style="color:khaki"> <?=$topic_user['login']?></a><span style="color:#a5a5a5;font-size:small">, <?=date('d m H:i:s,', $topic['time'])?></span><div style="padding:1px;"><span style="color:#e1e1e1;font-size:small">
<?
if($topic_user['access'] == 1) {
?>
<font color='f09060'>
<?
}
if($topic_user['access'] == 2) {
?>
<font color='90c0c0'>
<?
}
?>
<?=bb(smiles($topic['text']))?>
<?
if($topic_user['access'] > 0) {
?>
</font>
<?
}
?>
</div>
<div class='line'></div>
<?
if($user['access'] > 0) {
if($_GET['stick'] == true) {
mysql_query('UPDATE `forum_topic` SET `stick` = "'.($topic['stick'] == 0 ? 1:0).'" WHERE `id` = "'.$topic['id'].'"');
header('location: /forum/topic/'.$topic['id'].'/?adm=true');
}
if($_GET['close'] == true) {
mysql_query('UPDATE `forum_topic` SET `close` = "'.($topic['close'] == 0 ? 1:0).'" WHERE `id` = "'.$topic['id'].'"');
header('location: /forum/topic/'.$topic['id'].'/?adm=true');
}
if($_GET['delete'] == true) {
$q = mysql_query('SELECT * FROM `forum_comments` WHERE `topic` = "'.$topic['id'].'"');
while($row = mysql_fetch_array($q)) {
mysql_query('DELETE FROM `forum_comments` WHERE `id` = "'.$row['id'].'"');
}
header('location: /forum/sub/'.$topic['sub'].'/?adm=true');
mysql_query('DELETE FROM `forum_topic` WHERE `id` = "'.$topic['id'].'"');
}
?>
<div class='list'>
<li class='no_b'><a href='/forum/topic/<?=$topic['id']?>/<?=($_GET['adm'] == true ? '':'?adm=true')?>' <?=($_GET['adm'] == true ? 'style='color: #909090;'':'')?>><img src='/images/icon/arrow.png' alt='*'/> Управление топиком</a></li>
</div>
<div class='line'></div>
<?
}
$count = mysql_result(mysql_query('SELECT COUNT(*) FROM `forum_comments` WHERE `topic` = "'.$topic['id'].'"'),0);
?>
<div class="menu_link2" style="font-size:14px;padding-right:3px"> Комментариев: <?=$count?></div><div class="separ3"></div><div class="menu_link3" style="padding-left:2px;padding-right:2px;">
<?
if($count > 0) {
?>
<div class='line'></div>
<div class='menu'>
<?
$max = 10;
$pages = ceil($count/$max);
$page = _string(_num($_GET['page']));
if($page > $pages) {
$page = $pages;
}
if($page < 1) {
$page = 1;
}
$start = $page * $max - $max;
$q = mysql_query('SELECT * FROM `forum_comments` WHERE `topic` = "'.$topic['id'].'" ORDER BY `id` LIMIT '.$start.', '.$max.'');
while($row = mysql_fetch_array($q)) {
$comment_user = mysql_query('SELECT * FROM `users` WHERE `id` = "'.$row['user'].'"');
$comment_user = mysql_fetch_array($comment_user);
?>
<li><img src='/images/icon/race/<?=$comment_user['r'].($comment_user['online'] > time() - 300 ? '':'-off')?>.png' alt='*'/> <a href='/user/<?=$comment_user['id']?>/'><?=$comment_user['login']?></a><?
if($comment_user['id'] != $user['id']) {
?> <a href='/forum/topic/<?=$topic['id']?>/?page=<?=$page?>&to=<?=$comment_user['id']?>'>(»)</a><? } ?>, <?=date
('H:i:s,', $row['time'])?><br/>
<?
if($row['to']) {
$__to = mysql_query('SELECT * FROM `users` WHERE `id` = "'.$row['to'].'"');
$__to = mysql_fetch_array($__to);
if($__to['id'] == $user['id']) {
?>
<font color='#90c090'>
<?
}
?>
<?=$__to['login']?>,
<?
if($__to['id'] == $user['id']) {
?>
</font>
<?
}
}
if($comment_user['access'] == 1) {
?>
<font color='f09060'>
<?
}
if($comment_user['access'] == 2) {
?>
<font color='90c0c0'>
<?
}
?>
<?=bb(smiles($row['text']))?>
<?
if($comment_user['access'] > 0) {
?>
</font>
<?
}
if($user['access'] > 0) {
$comment = _string(_num($_GET['comment']));
if($comment) {
mysql_query('DELETE FROM `forum_comments` WHERE `id` = "'.$comment.'"');
header('location: /forum/topic/'.$topic['id'].'/?page='.$page);
}
?>
<a href='/forum/topic/<?=$topic['id']?>/?page=<?=$page?>&comment=<?=$row['id']?>'>[x]</a>
</span></div></div><div class="separ"></div>
<?
}
?>
</li>
<?
}
?>
<center><?=pages('/forum/topic/'.$topic['id'].'/?')?></center>
</div>
<?
}
?>
</div></div>
<div class='content'>
<?
if($topic['close'] == 0) {
if($user['save'] == 1) {
if($user['level'] > 5) {
$text = _string($_POST['text']);
$to = _string(_num($_GET['to']));
if($to) {
$_to = mysql_query('SELECT * FROM `users` WHERE `id` = "'.$to.'"');
$_to = mysql_fetch_array($_to);
if(!$_to OR $_to['id'] == $user['id']) {
header('location: /forum/topic/'.$topic['id'].'/?page='.$page);
exit;
}
}
if($_to) {
$text = str_replace($_to['login'].', ', '', $text);
}
if($text) {
mysql_query('INSERT INTO `forum_comments` (`topic`,`user`,`to`,`text`,`time`) VALUES ("'.$topic['id'].'", "'.$user['id'].'", "'.$_to['id'].'", "'.$text.'", "'.time().'")');
header('location: /forum/topic/'.$topic['id'].'/?page='.$pages);
}
?>
<div class="separ"></div><div class="menu_link2" style="padding:0;padding-top:3px"><form action="/forum/topic/<?=$topic['id']?>/?page=<?=$page?>&to=<?=$to?>" method="post" id="edit" style="font-size:small;color:#a5a5a5;padding:4px"><input type="hidden" name="text" value="">
<div style="text-align:center"><textarea rows="5" class="input_text" name="text" style="height:90px;width:90%"><?=($to ? $_to['login'].', ':'')?></textarea></div>
</form></div><div class="separ"></div><div class="menu_link2" style="text-align:center"><div><input type="submit" class="mybutt_att" style="height:24px;padding-left:20px;padding-right:20px" name="save" value="Новый пост"> <input type="submit" class="mybutt_att" style="height:24px;padding-left:20px;padding-right:20px" name="ent_smyle"
value="Смайлик">
<input type="submit" style="height:24px;padding-left:20px;padding-right:20px" class="mybutt_att" name="trans" value="Транслит"></div>
</div><div class="separ"></div>
<textarea name='text' style='width: 100%;'><?=($to ? $_to['login'].', ':'')?></textarea><br/>
<input type='submit' value='Отправить'/>
</form>
<?
}
else
{
?>
<font color='#999'>Писать на форуме можно с <img src='/images/icon/level.png' alt='*'/> 5 уровня</font>
<?
}
}
else
{
?>
<font color='#999'>Для общения на форуме вам нужно сохранить своего персонажа</font>
<?
}
}
else
{
?>
<font color='#f33'>Топик закрыт</font>
<?
}
?>
</div>
<?
include './system/f.php';
}
?>