1) { echo '

Редактирование топика

'; 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 '
'; echo "
"; } elseif(isset($_GET['lock']) && $ku['status']>1) { mysql_query("UPDATE `kolhoz_forum` SET `locked` = '".($forum['locked']==1?"0":"1")."' WHERE `id` = '$forum[id]'"); header("Location:?forum=$forum[id]"); } elseif(isset($_GET['pin']) && $ku['status']>1) { mysql_query("UPDATE `kolhoz_forum` SET `pined` = '".($forum['pined']==1?"0":"1")."' WHERE `id` = '$forum[id]'"); header("Location:?forum=$forum[id]"); } elseif(isset($_GET['del']) && $ku['status']>1) { 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 '

Подтверждение

'; } 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']>1) { mysql_query("delete from `kolhoz_forum` where `mother` = '$forum[id]' and `type` = 'komm' and `id` = '".intval($_GET['del_komm'])."'"); header("Location:?forum=$forum[id]"); } else { echo "

".htmlspecialchars($mother['name'])." / ".htmlspecialchars($forum['name'])."

"; 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=mysql_fetch_array(mysql_query("SELECT * FROM `user` WHERE `id` = '$otv[id_user]'")); } if(isset($_GET['add']) && $_GET['add']=='ok' && $forum['locked']==0) { $msg=$_POST['msg']; if($msg==NULL) { echo err_game("Слишком короткое сообщение"); $err=1; } if(!isset($err)) { mysql_query("INSERT INTO `kolhoz_forum` SET `msg` = '".my_esc($msg)."', `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]"); exit; } } echo "
"; echo "
    "; $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=mysql_fetch_array(mysql_query("SELECT * FROM `user` WHERE `id` = '$ank[id_user]'")); echo "
  • "; echo on_k($anku['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=mysql_fetch_array(mysql_query("SELECT * FROM `user` WHERE `id` = '$otvet[id_user]'")); } echo "".nc($ank['id'])." ".vremja($post['time'])."

    ".(isset($otvet)?"".($ku['id']==$otvet['id']?"":null)."$otvetu[nick]".($ku['id']==$otvet['id']?"":null).", ":null)."".output_text($post['msg'])."

    ".($fk['id']!=$post['id']?"".($forum['locked']==0?"".($ank['id']!=$ku['id']?"[ответить]":null)."":null)."":null).""; if($ku['status']>1 && $post['id']!=$fk['id'])echo " [удалить]"; echo "
  • "; } if($forum['locked']==0)echo "
    "; else echo "
    Топик закрыт.
    "; if ($k_page>1)str("?forum=$forum[id]&",$k_page,$page); // Вывод страниц echo "
"; echo "
    "; if($ku['status']>1)echo "
  • o Управление
  • "; if(isset($_GET['moderate']) && $ku['status']>1) { echo "
  • o ".($forum['pined']==0?"При":"От")."крепить
  • "; echo "
  • o ".($forum['locked']==0?"За":"От")."крыть
  • "; echo "
  • o Перенести
  • "; 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 "
  • "; echo "
    Перенос топика \"".htmlspecialchars($forum['name'])."\"
  • "; } } if($ku['status']>1)echo "
  • o Удалить
  • "; if($ku['status']>1)echo "
  • o Изменить
  • "; echo "
"; } } elseif(isset($forum) && $forum['type']=='razdel' && ($forum['locked']==1 && $ku['status']>1 || $forum['locked']==0)) { if(isset($_GET['add']) && $ku['level']>=10 && ($forum['admod']==1 && $ku['status']>1 || $forum['admod']==0)) { echo '

Создание топика

'; 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(!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'"); header("Location:?forum=$id"); exit; } } echo '
'; echo "
"; } elseif(isset($_GET['edit']) && $ku['status']>1) { echo '

Редактирование раздела

'; 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 '
'; echo "
  • "; echo " Создает топики только администрацыя
    "; echo " Давать доступ только администрации
    "; echo "
"; } elseif(isset($_GET['del']) && $ku['status']>1) { 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 '

Подтверждение

'; } else { echo "

Форум / ".htmlspecialchars($forum['name'])."

"; echo '
    '; $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 "
  • ".($post['locked']==1?"x":"*")." ".htmlspecialchars($post['name'])."
  • "; } if ($k_page>1)str("?forum=$forum[id]&",$k_page,$page); // Вывод страниц echo "
"; echo "
"; } } else { if(isset($_GET['add']) && $ku['status']>1) { echo '

Создание раздела

'; 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 '
'; echo "
  • "; echo " Создает топики только администрацыя
    "; echo " Давать доступ только администрации
    "; echo "
"; } else { if (isset($_GET['up']) && $ku['status']>1) { $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']>1) { $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 "

Форум

"; echo '
    '; $q=mysql_query("SELECT * FROM `kolhoz_forum` WHERE `type` = 'razdel' ORDER BY `pos` ASC"); while($post=mysql_fetch_array($q)) { echo "
  • * ".htmlspecialchars($post['name']).""; if(isset($_GET['moderate']))echo "o o"; echo "
  • "; } echo "
"; echo "
"; } } ?>