Файл: vkolhoze.com/inc/forum2.php
Строк: 395
<?
if(intval($_GET['forum'])!=NULL && mysql_result(mysql_query("SELECT COUNT(*) FROM `kolhoz_forum` WHERE `id` = '".intval($_GET['forum'])."'"),0)!=0)$forum=mysql_fetch_array(mysql_query("SELECT * FROM `kolhoz_forum` WHERE `id` = '".intval($_GET['forum'])."'"));
if(mysql_result(mysql_query("SELECT COUNT(*) FROM `forum_see` WHERE `id_user` = '$ku[id]' AND `id_forum` = '0' AND `id_them` = '0'"), 0)==0)mysql_query("INSERT INTO `forum_see` SET `id_user` = '$ku[id]', `id_forum` = '0'");
if(isset($forum) && $forum['type']=='tema')
{
$fk=mysql_fetch_array(mysql_query("SELECT * FROM `kolhoz_forum` WHERE `type` = 'komm' AND `mother` = '$forum[id]' ORDER BY `time` ASC LIMIT 1"));
if(mysql_result(mysql_query("SELECT COUNT(*) FROM `forum_see` WHERE `id_user` = '$ku[id]' AND `id_them` = '$forum[id]'"), 0)==0)mysql_query("INSERT INTO `forum_see` SET `id_user` = '$ku[id]', `id_them` = '$forum[id]'");
$mother=mysql_fetch_array(mysql_query("SELECT * FROM `kolhoz_forum` WHERE `id` = '$forum[mother]'"));
if(mysql_result(mysql_query("SELECT COUNT(*) FROM `forum_see` WHERE `id_user` = '$ku[id]' AND `id_forum` = '$mother[id]'"), 0)==0)mysql_query("INSERT INTO `forum_see` SET `id_user` = '$ku[id]', `id_forum` = '$mother[id]'");
if($mother['locked']==1 && $ku['status']<=0)header("Location:?forum");
if(isset($_GET['edit']) && $ku['status']>0)
{
echo '<div class="event"><title>Редактирование топика</title></div>';
if($_GET['edit']=='ok')
{
$name=$_POST['name'];
$msg=$_POST['msg'];
if($name==NULL)
{
echo err_game("Слишком короткое название");
$err=1;
}
if($msg==NULL)
{
echo err_game("Слишком короткое сообщение");
$err=1;
}
if(!isset($err))
{
mysql_query("UPDATE `kolhoz_forum` SET `name` = '".my_esc($name)."', `msg` = '".my_esc($msg)."' WHERE `id` = '$forum[id]'");
mysql_query("UPDATE `kolhoz_forum` SET `msg` = '".my_esc($msg)."' WHERE `id` = '$fk[id]'");
header("Location:/forum-$forum[id]");
exit;
}
}
echo '<div class="content"><div class="block">';
echo "<form action='?forum=$forum[id]&edit=ok' method='post'><ul><li><label><div>Заголовок:</div><div><input type='text' class='wide' value='".hsc($forum['name'])."' name='name'></div></label></li><li><label><div>Сообщение:</div><div><textarea class='wide' rows='20' name='msg'>".hsc($forum['msg'])."</textarea></div></label></li><li><input type='submit' value='Сохранить'></li></ul></form></div>";
include_once 'inc/foot.php';
}
elseif(isset($_GET['lock']) && $ku['status']>0)
{
mysql_query("UPDATE `kolhoz_forum` SET `locked` = '".($forum['locked']==1?"0":"1")."' WHERE `id` = '$forum[id]'");
header("Location:?forum=$forum[id]&page=end");
}
elseif(isset($_GET['pin']) && $ku['status']>0)
{
mysql_query("UPDATE `kolhoz_forum` SET `pined` = '".($forum['pined']==1?"0":"1")."' WHERE `id` = '$forum[id]'");
header("Location:?forum=$forum[id]&page=end");
}
elseif(isset($_GET['del']) && $ku['status']>0)
{
if($_GET['del']=='ok')
{
mysql_query("delete from `kolhoz_forum` where `mother` = '$forum[id]' and `type` = 'komm'");
mysql_query("delete from `kolhoz_forum` where `id` = '$forum[id]' and `type` = 'tema'");
header("Location:?forum=$mother[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="?forum='.$forum['id'].'&del=ok"><span>
<img alt="" width="16" height="16" src="images/icons/tick.png"> Да, подтверждаю</span></a></li><li><a class="loc" href="?forum='.$forum['id'].'"><span>
<img alt="" width="16" height="16" src="images/icons/cross.png"> Нет, отказываюсь</span></a></li></ul></div>';
//==============
if($ku['level']>=20){$int_get_like = (int) $_GET['like_user'];}
if($int_get_like!=''){
$like_data = mysql_fetch_assoc(mysql_query('SELECT `like_users` FROM `kolhoz_forum` WHERE `id`="'.$int_get_like.'"'));
$ass_li = explode(',',$like_data['like_users']);
if(in_array($ku['id'], $ass_li)){unset($ass_li[array_search($ku['id'], $ass_li)]);} else {array_push($ass_li, $ku['id']);}
mysql_query('UPDATE `kolhoz_forum` SET `like_users`="'.implode(',',$ass_li).'" WHERE `id`="'.$int_get_like.'"');
header('location:?forum='.$forum['id'].($_GET['page']!=''?'&page='.$_GET['page']:null));
exit;
}
//==============
include_once 'inc/foot.php';
}
elseif(isset($_GET['del_komm']) && intval($_GET['del_komm'])!=NULL && mysql_result(mysql_query("SELECT COUNT(*) FROM `kolhoz_forum` WHERE `id` = '".intval($_GET['del_komm'])."' AND `type` = 'komm' AND `id` != '$fk[id]'"),0)!=0 && $ku['status']>0)
{
mysql_query("delete from `kolhoz_forum` where `mother` = '$forum[id]' and `type` = 'komm' and `id` = '".intval($_GET['del_komm'])."'");
header("Location:?forum=$forum[id]&page=end");
}
else
{
echo "<div class='event'><h1><a class='knopka1' href='?forum=$mother[id]'>".hsc($mother['name'])."</a> : ".hsc($forum['name'])."</h1> <title>".hsc($forum['name'])."</title></div>";
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;
}
if(isset($_GET['add']) && $_GET['add']=='ok' && $forum['locked']==0 && !isset($molchi) && $ku['time']>=7200)
{
$msg=$_POST['msg'];
if($msg==NULL)
{
echo err_game("Слишком короткое сообщение");
$err=1;
}
if(!isset($err))
{
mysql_query("DELETE FROM `forum_see` WHERE `id_them` = '$forum[id]'");
mysql_query("DELETE FROM `forum_see` WHERE `id_forum` = '$mother[id]'");
mysql_query("DELETE FROM `forum_see` WHERE `id_forum` = '0' AND `id_them`= '0'");
mysql_query("INSERT INTO `kolhoz_forum` SET `msg` = '".my_esc($msg)."'".($ku['status']>0?", `bb` = '1'":null).", `id_user` = '$ku[id]', `type` = 'komm', `mother` = '$forum[id]', `time` = '$time'".(isset($otv)?", `otvet` = '$otv[id]'":null)."");
mysql_query("UPDATE `kolhoz_forum` SET `time_obnov` = '$time' WHERE `id` = '$forum[id]'");
header("Location:?forum=$forum[id]&page=end");
exit;
}
}
echo "<div class='content'><div class='block'>";
echo "<ul>";
$k_post = mysql_result(mysql_query("SELECT COUNT(*) FROM `kolhoz_forum` WHERE `type` = 'komm' AND `mother` = '$forum[id]'"),0);
if ($k_post==0)
{
echo "Список пуст...";
}
$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_forum` WHERE `type` = 'komm' AND `mother` = '$forum[id]' ORDER BY `time` ASC 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]'"));
$anku=$ank;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 class='small'><span>";
echo on_k($ank['id']);
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;
}
echo "<a class='' href='/user/$ank[id]'>".nc($ank['id'])."</a></span> <span class='minor'><span>".vremja($post['time'])."</span></span></span>";
//==============
//$like_user = explode(',',$post['like_users']);
//if(in_array($ku['id'], $like_user)){$mys = ' и Вы'; $minus = 1;} else {$mys = null; $minus = null;}
//$vsego_like = count($like_user)-1;
//$likes_rez = $vsego_like - $minus;
//if($vsego_like==0){$echo_l = null;}
//elseif($vsego_like==1 && $mys==' и Вы'){$echo_l = 'Вы';}
//else{$echo_l = '<b>'.$likes_rez.'</b>'.$mys;}
//echo ' <nobr><a class="knopka_one" href="forum='.$forum['id'].'&like_user='.$post['id'].($_GET['page']!=''?'&page='.$_GET['page']:null).'"><img width="16" height="16" src="images/like_pandcar.png" alt="o"/> '.$echo_l.'</a></nobr>';
//==============
echo "<p>".($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'])."</p></span></div><div class='small'>".($fk['id']!=$post['id']?"".($forum['locked']==0?"".($ank['id']!=$ku['id']?"<a class='otvet' href='?forum=$forum[id]".(isset($_GET['page'])?"&page=$_GET[page]":null)."&otv=$ank[id]'>ответить</a>":null)."":null)."":null)."";
if($ku['status']>0 && $post['id']!=$fk['id'])echo " <a class='udal' href='?forum=$forum[id]&del_komm=$post[id]'>удалить</a>";
echo "</div></li>";
unset($otvet);
}
if(!$ban['id']){$ban=mysql_fetch_array(mysql_query("SELECT * FROM `kolhoz_ban` WHERE `id_user` = '$ku[id]' AND `time` > '$time' AND `izg` = '3' ORDER BY `id` DESC LIMIT 1"));
$us_ban=mysql_fetch_array(mysql_query("SELECT * FROM `kolhoz_user` WHERE `id` = '$ban[id_who]'"));
}
if($ku['time']<1800)
{
err_game("Чтобы писать сообщения нужно провести 30 минут!");
} else {
if($ban['id'])
{
echo "<ul class='pt'>
<div>
<li class='major'><span>".($ban['izg']==3?"Бан на форуме до ".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>";
}
else
{
if($forum['locked']==0)echo "<form action='?forum=$forum[id]&add=ok".(isset($otv)?"&otv=$otv[id]":null)."' method='post'><ul><li><label><div>Сообщение".(isset($otv)?" для $otvu[nick]":null)."</div><div><textarea class='wide' rows='5' name='msg'></textarea></div></label></li><li><input type='submit' value='Написать'></li></ul></form>";
else echo "<div class='pt minor'>Топик закрыт.</div>";
}
}
if ($k_page>1)str("?forum=$forum[id]&",$k_page,$page); // Вывод страниц
echo "</ul>";
echo "<ul class='pt'>";
if($ku['status']>0)echo "<li><a class='loc' href='?forum=$forum[id]".(!isset($_GET['moderate'])?"&moderate":null)."'><img alt='o' width='' height='16' src='images/icons/moderate.png'> Управление</a></li>";
if(isset($_GET['moderate']) && $ku['status']>0)
{
echo "<li><a class='loc' href='?forum=$forum[id]&pin'><span><img alt='o' width='16' height='16' src='images/icons/forum_pin.png'> ".($forum['pined']==0?"При":"От")."крепить</span></a></li>";
echo "<li><a class='loc' href='?forum=$forum[id]&lock'><span><img alt='o' width='16' height='16' src='images/icons/forum_close.png'> ".($forum['locked']==0?"За":"От")."крыть</span></a></li>";
echo "<li><a class='loc' href='?forum=$forum[id]&moderate".(!isset($_GET['replace'])?"&replace":null)."'><img alt='o' width='16' height='16' src='images/icons/forum_move.png'> Перенести</a><br></li>";
if(isset($_GET['replace']))
{
if($_GET['replace']=='ok' && mysql_result(mysql_query("SELECT COUNT(*) FROM `kolhoz_forum` WHERE `id` = '".intval($_POST['forum'])."' AND `type` = 'razdel'"),0)!=0)
{
mysql_query("UPDATE `kolhoz_forum` SET `mother` = '".intval($_POST['forum'])."' WHERE `id` = '$forum[id]'");
header("Location:?forum=$forum[id]");
}
echo "<li>";
echo "<form method='post' action='?forum=$forum[id]&moderate&replace=ok'><div>Перенос топика "<span>".hsc($forum['name'])."</span>"</div><label>Новый раздел<br>";
echo "<select name='forum'>";
$q=mysql_query("SELECT * FROM `kolhoz_forum` WHERE `id` != '$mother[id]' AND `type` = 'razdel'");
while($post=mysql_fetch_array($q))
{
echo "<option value='$post[id]'>".hsc($post['name'])."</option>";
}
echo "</label><br><input type='submit' value='Перенести'></form></li>";
}
}
if($ku['status']>0)echo "<li><a class='loc' href='?forum=$forum[id]&del'><img alt='o' width='16' height='16' src='images/icons/delete.png'> Удалить</a></li>";
if($ku['status']>0)echo "<li><a class='loc' href='?forum=$forum[id]&edit'><img alt='o' width='16' height='16' src='images/icons/forum_edit.png'> Изменить</a></li>";
echo "</ul></div>";
include_once 'inc/foot.php';
}
}
elseif(isset($forum) && $forum['type']=='razdel' && ($forum['locked']==1 && $ku['status']>0 || $forum['locked']==0))
{
if(mysql_result(mysql_query("SELECT COUNT(*) FROM `forum_see` WHERE `id_user` = '$ku[id]' AND `id_forum` = '$forum[id]'"), 0)==0)mysql_query("INSERT INTO `forum_see` SET `id_user` = '$ku[id]', `id_forum` = '$forum[id]'");
if(isset($_GET['add']) && !isset($molchi) && $ku['level']>=10 && ($forum['admod']==1 && $ku['status']>0 || $forum['admod']==0))
{
echo '<div class="event"><title>Создание топика</title></div>';
if($_GET['add']=='ok')
{
$name=$_POST['name'];
$msg=$_POST['msg'];
if($name==NULL)
{
echo err_game("Слишком короткое название");
$err=1;
}
if($msg==NULL)
{
echo err_game("Слишком короткое сообщение");
$err=1;
}
if($forum[id]==7 and $ku[status]<=2)
{
echo err_game("Запрещено создавать темы в этом разделе!");
$err=1;
}
if(!isset($err))
{
mysql_query("INSERT INTO `kolhoz_forum` SET `name` = '".my_esc($name)."', `msg` = '".my_esc($msg)."', `id_user` = '$ku[id]', `type` = 'tema', `mother` = '$forum[id]', `time` = '$time', `time_obnov` = '$time'");
$id=mysql_insert_id();
mysql_query("INSERT INTO `kolhoz_forum` SET `msg` = '".my_esc($msg)."', `id_user` = '$ku[id]', `type` = 'komm', `mother` = '$id', `time` = '$time'");
//mysql_query("INSERT INTO `forum_see` SET `id_user` = '$ku[id]', `id_them` = '$id'");
mysql_query("DELETE FROM `forum_see` WHERE `id_forum` = '$forum[id]'");
mysql_query("DELETE FROM `forum_see` WHERE `id_forum` = '0' AND `id_them` = '0'");
header("Location:?forum=$id");
exit;
}
}
echo '<div class="content"><div class="block">';
echo "<form action='?forum=$forum[id]&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='msg'></textarea></div></label></li><li><input type='submit' value='Написать'></li></ul></form></div>";
include_once 'inc/foot.php';
}
elseif(isset($_GET['edit']) && $ku['status']>0)
{
echo '<div class="event"><h1>Редактирование раздела</h1><title>Редактирование раздела</title></div>';
if($_GET['edit']=='ok')
{
$name=$_POST['name'];
if($name==NULL)
{
echo err_game("Слишком короткое название");
$err=1;
}
if(!isset($err))
{
if($_POST['admod']==1)$admod=1;else $admod=0;
if($_POST['locked']==1)$locked=1;else $locked=0;
mysql_query("UPDATE `kolhoz_forum` SET `name` = '".my_esc($name)."', `admod` = '$admod', `locked` = '$locked' WHERE `id` = '$forum[id]'");
header("Location:/forum-$forum[id]");
exit;
}
}
echo '<div class="content"><div class="block">';
echo "<form action='?forum=$forum[id]&edit=ok' method='post'><ul><li><label><div>Название:</div><div><input type='text' class='wide' value='".hsc($forum['name'])."' name='name'></div></label></li>";
echo "<input type='checkbox' name='admod' value='1'".($forum['admod']==1?" checked='checked'":null)."> <span>Создает топики только администрацыя</span><br/>";
echo "<input type='checkbox' name='locked' value='1'".($forum['locked']==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['readall']))
{
$qa=mysql_query("SELECT * FROM `kolhoz_forum` WHERE `type` = 'tema' AND `mother` = '$forum[id]'");
while($posta=mysql_fetch_array($qa))
{
if(mysql_result(mysql_query("SELECT COUNT(*) FROM `forum_see` WHERE `id_user` = '$ku[id]' AND `id_forum` = '$posta[id]'"), 0)==0)mysql_query("INSERT INTO `forum_see` SET `id_user` = '$ku[id]', `id_them` = '$posta[id]'");
}
header("Location:/forum-$forum[id]");
}
elseif(isset($_GET['del']) && $ku['status']>0)
{
if($_GET['del']=='ok')
{
$q=mysql_query("SELECT * FROM `kolhoz_forum` WHERE `mother` = '$forum[id]' AND `type` = 'tema'");
while($post=mysql_fetch_array($q))
{
mysql_query("delete from `kolhoz_forum` where `mother` = '$post[id]' and `type` = 'komm'");
mysql_query("delete from `kolhoz_forum` where `id` = '$post[id]'");
}
$links = mysql_query("SELECT * FROM `kolhoz_forum` WHERE `type` = 'razdel' AND `pos` > '$forum[pos]' ORDER BY `pos` ASC");
while ($p = mysql_fetch_array($links))
{
mysql_query("UPDATE `kolhoz_forum` SET `pos` = '".($p['pos']-1)."' WHERE `id` = '$p[id]' LIMIT 1");
}
mysql_query("delete from `kolhoz_forum` where `id` = '$forum[id]' and `type` = 'razdel'");
header("Location:?forum");
}
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="?forum='.$forum['id'].'&del=ok"><span>
<img alt="" width="16" height="16" src="images/icons/tick.png"> Да, подтверждаю</span></a></li><li><a class="loc" href="?forum='.$forum['id'].'"><span>
<img alt="" width="16" height="16" src="images/icons/cross.png"> Нет, отказываюсь</span></a></li></ul></div>';
include_once 'inc/foot.php';
}
else
{
echo "<div class='event'><h1><a class='knopka1' href='/forum'>Форум</a> : ".hsc($forum['name'])."</h1> <title> ".hsc($forum['name'])."</title></div>";
echo '<div class="content"><div class="block"><ul>';
$k_post = mysql_result(mysql_query("SELECT COUNT(*) FROM `kolhoz_forum` WHERE `type` = 'tema' AND `mother` = '$forum[id]'"),0);
if ($k_post==0)
{
echo "Список пуст...";
}
$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_forum` WHERE `type` = 'tema' AND `mother` = '$forum[id]' ORDER BY `pined` DESC, `time_obnov` DESC LIMIT $start, $set[p_str]");
while($post=mysql_fetch_array($q))
{
echo "<li><div>".(mysql_result(mysql_query("SELECT COUNT(*) FROM `forum_see` WHERE `id_user` = '$ku[id]' AND `id_them` = '$post[id]'"), 0)==0?"<img width='16' height='16' src='images/icons/forum_topic_new.png' alt='*' title='*'>":($post['locked']==1?"<img width='16' height='16' src='images/icons/forum_topic_closed.png' alt='x' title='x'>":"<img width='16' height='16' src='images/icons/forum_topic.png' alt='*' title='*'>"))." <a class=''href='".(mysql_result(mysql_query("SELECT COUNT(*) FROM `forum_see` WHERE `id_user` = '$ku[id]' AND `id_them` = '$post[id]'"), 0)==0?"/forum-$post[id]/page-end":"/forum-$post[id]")."'>".($post['pined']>0?"<b>":null).hsc($post['name']).($post['pined']>0?"</b>":null)."</a></div><div class='small'></div></li>";
}
if ($k_page>1)str("?forum=$forum[id]&",$k_page,$page); // Вывод страниц
echo "</ul>";
echo "<ul class='pt'>";
echo "<li></li>";
if(!$ban['id']){$ban=mysql_fetch_array(mysql_query("SELECT * FROM `kolhoz_ban` WHERE `id_user` = '$ku[id]' AND `time` > '$time' AND `izg` = '3' 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']==3?"Бан на форуме до ".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($ku['level']>=10 && ($forum['admod']==1 && $ku['status']>0 || $forum['admod']==0))echo "<li><a class='loc' href='/forum-$forum[id]/add'><img width='16' height='16' src='images/icons/forum_topic.png' alt='*' title='*'> Создать топик</a></li>";
echo "<li><a class='loc' href='/forum-$forum[id]/readall'><img src='/images/icons/tick.png'> Отметить всё как прочитанное</a></li>";
if($ku['status']>0)echo "<li><a class='loc' href='/forum-$forum[id]/del'><img alt='o' width='16' height='16' src='images/icons/delete.png'> Удалить</a></li>";
if($ku['status']>0)echo "<li><a class='loc' href='/forum-$forum[id]/edit'><img alt='o' width='16' height='16' src='images/icons/forum_edit.png'> Изменить название</a></li>";
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'];
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_forum` WHERE `type` = 'razdel'"), 0)+1;
mysql_query("INSERT INTO `kolhoz_forum` SET `name` = '".my_esc($name)."', `id_user` = '$ku[id]', `type` = 'razdel', `mother` = '0', `time` = '$time', `admod` = '$admod', `pos` = '$pos', `locked` = '".($_POST['locked']==1?"1":"0")."'");
header("Location:?forum");
exit;
}
}
echo '<div class="content"><div class="block">';
echo "<form action='?forum&add=ok' method='post'><ul><li><label><div>Название:</div><div><input type='text' class='wide' value='' name='name'></div></label></li>";
echo "<input type='checkbox' name='admod' value='1'> <span>Создает топики только администрация</span><br/>";
echo "<input type='checkbox' name='locked' 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_forum` WHERE `id` = '".intval($_GET['up'])."' AND `type` = 'razdel' LIMIT 1"));
if(mysql_result(mysql_query("SELECT COUNT(*) FROM `kolhoz_forum` WHERE `pos` < '$up[pos]' AND `type` = 'razdel' LIMIT 1"),0)!=0)
{
mysql_query("UPDATE `kolhoz_forum` SET `pos` = '".($up['pos'])."' WHERE `pos` = '".($up['pos']-1)."' AND `type` = 'razdel' LIMIT 1");
mysql_query("UPDATE `kolhoz_forum` SET `pos` = '".($up['pos']-1)."' WHERE `id` = '".intval($_GET['up'])."' AND `type` = 'razdel' LIMIT 1");
}
}
elseif (isset($_GET['down']) && $ku['status']>2)
{
$down=mysql_fetch_assoc(mysql_query("SELECT * FROM `kolhoz_forum` WHERE `id` = '".intval($_GET['down'])."' AND `type` = 'razdel' LIMIT 1"));
if(mysql_result(mysql_query("SELECT COUNT(*) FROM `kolhoz_forum` WHERE `pos` > '$down[pos]' AND `type` = 'razdel' LIMIT 1"),0)!=0)
{
mysql_query("UPDATE `kolhoz_forum` SET `pos` = '".($down['pos'])."' WHERE `pos` = '".($down['pos']+1)."' AND `type` = 'razdel' LIMIT 1");
mysql_query("UPDATE `kolhoz_forum` SET `pos` = '".($down['pos']+1)."' WHERE `id` = '".intval($_GET['down'])."' AND `type` = 'razdel' LIMIT 1");
}
}
echo "<div class='event'><title>Форум</title></div>";
echo '<div class="content"><div class="block"><ul>';
$q=mysql_query("SELECT * FROM `kolhoz_forum` WHERE `type` = 'razdel'".($ku['status']==0?" AND `locked` = '0'":null)." ORDER BY `pos` ASC");
while($post=mysql_fetch_array($q))
{
echo "<li><a class='loc' href='/forum-$post[id]'><span><img width='16' height='16' src='images/icons/forum".(mysql_result(mysql_query("SELECT COUNT(*) FROM `forum_see` WHERE `id_user` = '$ku[id]' AND `id_forum` = '$post[id]'"), 0)==0?"_new":null).".png' alt='*' title='*'> ".hsc($post['name'])."</span></a>";
if(isset($_GET['moderate']))echo "<a href='?forum&moderate&up=$post[id]'><img width='16' height='16' src='images/icons/up.png' alt='o'></a> <a href='?forum&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']>2)echo "<li><a class='loc' href='/forum".(!isset($_GET['moderate'])?"/moderate":null)."'><img width='16' height='16' src='images/icons/moderate.png' alt='o'> Управление</a></li><li><a class='loc' href='/forum/add'><img width='16' height='16' src='images/icons/forum_new.png' alt='*' title='*'> Создать раздел</a></li>";
echo "</ul></div>";
//include_once 'inc/foot.php';
}
}
?>