Файл: forum.php
Строк: 498
<?php
include ("niz/head.php");
include ("db_bse/bssest.php");
$g=mysql_query("SELECT * FROM `turaga_pers` WHERE `nick`='$nick' AND `pass`='$pass' LIMIT 1");
if(mysql_num_rows($g)==1){
include ("niz/verh.php");
switch($_GET[mod]){
default:
function smiles($string){
$dir = opendir ("pictures/smiles");
while ($file = readdir ($dir)) {
if (ereg (".gif$", "$file")){
$file2=str_replace(".gif","",$file);
$string=str_replace(":$file2",'<img src="pictures/smiles/'.$file.'" alt="">',$string);
}}
closedir ($dir);
return $string; }
if($game=="readsave"){
$g=mysql_query("SELECT * FROM `tb_themes` WHERE `id`='$id' AND `uid`='$uid' LIMIT 1");
if(mysql_num_rows($g)==1){
$g=mysql_query("SELECT * FROM `tb_forummsgs` WHERE `oid`='$id' AND `uid`='$uid' AND `aid`='$aid' AND `autor`='$nick' LIMIT 1");
if(mysql_num_rows($g)==1){
if($transi=="ok"){
require_once "niz/translit.php";
if(ereg("[а-яА-Я]",$msg)){}else{
$msg=str_replace($trans1,$trans2,$msg);}
}
mysql_query("UPDATE `tb_forummsgs` SET `msg`='$msg' WHERE `oid`='$id' AND `uid`='$uid' AND `aid`='$aid'");
echo "Сообщение изменено";
header ("Location: forum.php?game=tem&id=$id&uid=$uid");
}else{echo "Вы не автор этого сообщения!";}
}else{echo "Такая тема не существует!";}
include ("niz/niz.php");
exit;
}
if($game=="read"){
$g=mysql_query("SELECT * FROM `tb_themes` WHERE `id`='$id' AND `uid`='$uid' LIMIT 1");
if(mysql_num_rows($g)==1){
$g=mysql_query("SELECT * FROM `tb_forummsgs` WHERE `oid`='$id' AND `uid`='$uid' AND `aid`='$aid' AND `autor`='$nick' LIMIT 1");
if(mysql_num_rows($g)==1){
$result666 = mysql_query("SELECT * FROM `tb_forummsgs` WHERE `oid`='$id' AND `uid`='$uid' AND `aid`='$aid' AND `autor`='$nick'");
$po = mysql_fetch_array($result666);
echo'<form method="post" action="forum.php?game=readsave&id='.$id.'&aid='.$aid.'&uid='.$uid.'">';
echo "<br/>Редактировать:<br/>";
echo "<input class="button" name="msg" maxlength="500" value="$po[msg]" title="Редактировать" emptyok="true"/><br/>";
echo '<input type="checkbox" name="transi" value="ok">Транслит<br/>';
echo '<input class="button" type="submit" value="Редактировать"/></form>';
}else{echo "Вы не автор этого сообщения!";}
}else{echo "Такая тема не существует!";}
include ("niz/niz.php");
exit;
}
if($game=="deltem"){
if($prava<=5){
$result666 = mysql_query("SELECT * FROM `tb_forums` WHERE `id`='".$id."'");
$po = mysql_fetch_array($result666);
$msg2=$po[forumthemes]-1;
$q = mysql_query("SELECT COUNT(`uid`) FROM `tb_forummsgs` WHERE `uid`='".$uid."' AND `oid`='".$id."'");
$kol = mysql_result($q, 0);
$msg=$po[forummsg]-$kol;
mysql_query("UPDATE `tb_forums` SET `forummsg`='$msg',`forumthemes`='$msg2' WHERE `id`='$id'");
mysql_query("DELETE FROM `tb_themes` WHERE `uid`='".$uid."'");
mysql_query("DELETE FROM `tb_forummsgs` WHERE `uid`='".$uid."'");
echo "Тема удалена!";
}else{echo"Вы не админ!";}
include ("niz/niz.php");
exit;
}
if($game=="razsave"){
if($prava<=5){
if(empty($forumname)){
header ("Location: forum.php?game=addraz");
include ("niz/niz.php");
exit;
}
$raz = "INSERT INTO tb_forums VALUES('','$forumname','0','0')";
$result = mysql_query($raz);
echo "Раздел успешно создан";
}else{echo"Вы не админ!";}
include ("niz/niz.php");
exit;
}
if($game=="addraz"){
if($prava<=5){
echo'<form method="post" action="forum.php?game=razsave">';
echo "<br/>Название раздела:<br/>";
echo "<input class="button" name="forumname" maxlength="30" title="Название раздела" emptyok="true"/>";
echo '<input class="button" type="submit" value="Добавить"/></form>';
}else{echo"Вы не админ!";}
include ("niz/niz.php");
exit;
}
if($game=="okclose"){
$g=mysql_query("SELECT * FROM `tb_themes` WHERE `id`='$id' AND `uid`='$uid' LIMIT 1");
if(mysql_num_rows($g)==1){
if($prava>=5){
$result666 = mysql_query("SELECT * FROM `tb_themes` WHERE `uid`='".$uid."'");
$onoff = mysql_fetch_array($result666);
if($onoff[onoff]=="1"){
mysql_query("UPDATE `tb_themes` SET `onoff`='0' WHERE `uid`='$uid'");
echo "Тема закрыта!";
}else{
mysql_query("UPDATE `tb_themes` SET `onoff`='1' WHERE `uid`='$uid'");
echo "Тема открыта!";
}
}else{echo"Вы не админ!";}
}else{echo "Такая тема не существует!";}
include ("niz/niz.php");
exit;
}
if($game=="newforums"){
$g=mysql_query("SELECT * FROM `tb_forums` WHERE `id`='$id' LIMIT 1");
if(mysql_num_rows($g)==1){
if(empty($nazva)){
header ("Location: forum.php?game=theme&id=$id");
include ("niz/niz.php");
exit;
}
if(empty($msg)){
header ("Location: forum.php?game=theme&id=$id");
include ("niz/niz.php");
exit;
}
if($transi=="ok"){
require_once "niz/translit.php";
if(ereg("[а-яА-Я]",$nazva)){}else{
$nazva=str_replace($trans1,$trans2,$nazva);}
}
if($transik=="ok"){
require_once "niz/translit.php";
if(ereg("[а-яА-Я]",$msg)){}else{
$msg=str_replace($trans1,$trans2,$msg);}
}
$time = date("H:i:s");
$new = "INSERT INTO tb_themes VALUES('$id','','$nazva','$nick','$time','1','1','$nick')";
$result = mysql_query($new);
$u=mysql_query("SELECT * FROM `tb_themes` ORDER by `uid` DESC");
$dat=mysql_fetch_array($u);
$uids=$dat[uid];
$mg = "INSERT INTO tb_forummsgs VALUES('$id','$uids','0','$nick','$time','$msg')";
$result = mysql_query($mg);
$result666 = mysql_query("SELECT * FROM `tb_forums` WHERE `id`='".$id."'");
$po = mysql_fetch_array($result666);
$msg=$po[forumthemes]+1;
$msg2=$po[forummsg]+1;
mysql_query("UPDATE `tb_forums` SET `forumthemes`='$msg',`forummsg`='$msg2' WHERE `id`='$id'");
mysql_query("UPDATE `tb_forumosts` SET `nick`='$nick'");
header ("Location: forum.php?game=tem&id=$id&uid=$uids");
}else{echo "Такой раздел не существует!";}
include ("niz/niz.php");
exit;
}
if($game=="newforum"){
$g=mysql_query("SELECT * FROM `tb_forums` WHERE `id`='$id' LIMIT 1");
if(mysql_num_rows($g)==1){
if($lvl<"2"){echo "На форуме можно создавать темы только после <b>2</b> Уровня.";
include ("niz/niz.php");
exit;
}
echo'<form method="post" action="forum.php?game=newforums&id='.$id.'&uid='.$uid.'">';
echo "<br/>Название темы:<br/>";
echo "<input class="button" name="nazva" maxlength="30" title="Название темы" emptyok="true"/>";
echo "<br/>Сообщение:<br/>";
echo "<input class="button" name="msg" maxlength="500" title="Сообщение" emptyok="true"/><br/>";
echo '<input type="checkbox" name="transi" value="ok">Транслировать название темы<br/>';
echo '<input type="checkbox" name="transik" value="ok">Транслировать название сообщение<br/>';
echo '<input class="button" type="submit" value="Написать"/></form>';
}else{echo "Такой раздел не существует!";}
include ("niz/niz.php");
exit;
}
if($game=="saves"){
$g=mysql_query("SELECT * FROM `tb_themes` WHERE `id`='$id' AND `uid`='$uid' LIMIT 1");
if(mysql_num_rows($g)==1){
if(empty($msg)){
header ("Location: forum.php?game=say&id=$id&uid=$uid");
include ("niz/niz.php");
exit;
}
if($transi=="ok"){
require_once "niz/translit.php";
if(ereg("[а-яА-Я]",$msg)){}else{
$msg=str_replace($trans1,$trans2,$msg);}
}
$time = date("H:i:s");
$q = mysql_query("SELECT COUNT(`aid`) FROM `tb_forummsgs` WHERE `uid`='$uid'");
$aid = mysql_result($q, 0);
$otvet = "INSERT INTO tb_forummsgs VALUES('$id','$uid','$aid','$nick','$time','$msg')";
$result = mysql_query($otvet);
$result666 = mysql_query("SELECT * FROM `tb_forums` WHERE `id`='".$id."'");
$po = mysql_fetch_array($result666);
$msg2=$po[forummsg]+1;
mysql_query("UPDATE `tb_forums` SET `forummsg`='$msg2' WHERE `id`='$id'");
$result666 = mysql_query("SELECT * FROM `tb_themes` WHERE `uid`='".$uid."'");
$po = mysql_fetch_array($result666);
$msg2=$po[msg]+1;
mysql_query("UPDATE `tb_themes` SET `msg`='$msg2',`posl`='$nick' WHERE `uid`='$uid'");
mysql_query("UPDATE `tb_forumosts` SET `nick`='$nick'");
header ("Location: forum.php?game=tem&id=$id&uid=$uid");
}else{echo "Такая тема не существует!";}
include ("niz/niz.php");
exit;
}
if($game=="say"){
$g=mysql_query("SELECT * FROM `tb_themes` WHERE `id`='$id' AND `uid`='$uid' LIMIT 1");
if(mysql_num_rows($g)==1){
if($lvl<"2"){echo "На форуме можно создавать темы только после <b>2</b> Уровня.<br>";
include ("niz/niz.php");
exit;
}
$result666 = mysql_query("SELECT * FROM `tb_themes` WHERE `uid`='".$uid."'");
$onoff = mysql_fetch_array($result666);
if($onoff[onoff]=="0"){
echo "Эта тема закрыта вы неможете писать сообщения!";
include ("niz/niz.php");
exit;
}
echo'<form method="post" action="forum.php?game=saves&id='.$id.'&uid='.$uid.'">';
echo "<br/>Ответить на тему:<br/>";
echo "<input class="button" name="msg" maxlength="500" title="Сообщение" emptyok="true"/><br/>";
echo '<input type="checkbox" name="transi" value="ok">Транслит<br/>';
echo '<input class="button" type="submit" value="Написать"/></form>';
}else{echo "Такая тема не существует!";}
include ("niz/niz.php");
exit;
}
if($game=="tem"){
$g=mysql_query("SELECT * FROM `tb_themes` WHERE `id`='$id' AND `uid`='$uid' LIMIT 1");
if(mysql_num_rows($g)==1){
$q = mysql_query("SELECT COUNT(`oid`) FROM `tb_forummsgs` WHERE `oid`='$id' AND `uid`='$uid'");
$kmsg = mysql_result($q, 0);
echo "В теме сообщений (<b>$kmsg</b>)<div class='bts'></div>";
if(empty($startan)) $startan = 0;
$startan=intval($startan);
if($startan<0) $startan=0; $num_msgs_an=5;
$qi = mysql_query("SELECT * FROM `tb_forummsgs` WHERE `oid`='$id' AND `uid`='$uid' ORDER by `aid` ASC LIMIT $startan,$num_msgs_an");
while($row=mysql_fetch_array($qi))
{
if($row[autor]=="$nick"){
echo"[<a href="forum.php?id=$id&aid=$row[aid]&uid=$row[uid]&game=read">Ред</a>]";
}
$req = mysql_query("SELECT `prava`,`status` FROM `turaga_pers` WHERE `nick` = '$row[autor]'");
$pic = mysql_fetch_array($req);
if ($pic['status']==0)echo "<img src='/pictures/status/on.gif' alt='' class='icon'/>";
else if ($pic['status']==1)echo "<img src='/pictures/status/gotov_boltat.png' alt='' class='icon'/>";
else if ($pic['status']==2)echo "<img src='/pictures/status/zaniat.png' alt='' class='icon'/>";
else if ($pic['status']==3)echo "<img src='/pictures/status/boleu.png' alt='' class='icon'/>";
else if ($pic['status']==4)echo "<img src='/pictures/status/depressia.png' alt='' class='icon'/>";
else if ($pic['status']==5)echo "<img src='/pictures/status/dumau.png' alt='' class='icon'/>";
else if ($pic['status']==6)echo "<img src='/pictures/status/kuru.png' alt='' class='icon'/>";
else if ($pic['status']==7)echo "<img src='/pictures/status/kushau.png' alt='' class='icon'/>";
else if ($pic['status']==8)echo "<img src='/pictures/status/love.png' alt='' class='icon'/>";
else if ($pic['status']==9)echo "<img src='/pictures/status/tv.png' alt='' class='icon'/>";
else if ($pic['status']==10)echo "<img src='/pictures/status/music.png' alt='' class='icon'/>";
else if ($pic['status']==11)echo "<img src='/pictures/status/vanna.png' alt='' class='icon'/>";
else if ($pic['status']==12)echo "<img src='/pictures/status/tualet.png' alt='' class='icon'/>";
else if ($pic['status']==13)echo "<img src='/pictures/status/sex.png' alt='' class='icon'/>";
else if ($pic['status']==14)echo "<img src='/pictures/status/igrau.png' alt='' class='icon'/>";
else if ($pic['status']==15)echo "<img src='/pictures/status/pivo.png' alt='' class='icon'/>";
else if ($pic['status']==16)echo "<img src='/pictures/status/sonni.png' alt='' class='icon'/>";
////////
else if ($pic['status']==17)echo "<img src='/pictures/status/1.png' alt='' class='icon'/>";
else if ($pic['status']==18)echo "<img src='/pictures/status/12.png' alt='' class='icon'/>";
else if ($pic['status']==19)echo "<img src='/pictures/status/13.png' alt='' class='icon'/>";
else if ($pic['status']==20)echo "<img src='/pictures/status/14.png' alt='' class='icon'/>";
else if ($pic['status']==21)echo "<img src='/pictures/status/18.png' alt='' class='icon'/>";
else if ($pic['status']==22)echo "<img src='/pictures/status/19.png' alt='' class='icon'/>";
else if ($pic['status']==23)echo "<img src='/pictures/status/31.png' alt='' class='icon'/>";
else if ($pic['status']==24)echo "<img src='/pictures/status/7.png' alt='' class='icon'/>";
echo" <a href="nick_info.php?nick=$row[autor]&go=go"> $row[autor]</a>";
if($pic['prava']==5){
echo'<font color="lime">.GM</font>';
}
if($pic['prava']==2){
echo'<font color="blue">.M</font>';
}
if($pic['prava']==3){
echo'<font color="yellow">.Faq</font>';
}
$koment = strip_tags($row['msg']);
$koment = smiles($koment);
if($pic['prava']==5){$koment='<font color="IndianRed1">'.$koment.'</font>';}
if($pic['prava']==2){$koment='<font color="blue">'.$koment.'</font>';}
if($pic['prava']==3){$koment='<font color="DarkGoldenrod1">'.$koment.'</font>';}
echo" ($row[time])";
echo"<br/> $koment";
echo"<br/><div class='bts'></div>";
}
$result666 = mysql_query("SELECT * FROM `tb_themes` WHERE `uid`='".$uid."'");
$onoff = mysql_fetch_array($result666);
if($onoff[onoff]=="1"){
echo "<img src='/pictures/icons/help.gif' alt='*'/> <a href="forum.php?game=say&id=$id&uid=$uid">Написать в тему</a><br/>";
if($prava>=5){
echo "<img src='/pictures/icons/help.gif' alt='*'/> <a href="forum.php?game=okclose&id=$id&uid=$uid">Закрыть тему</a><br/>";
}
}else{
echo "<br/>Тема закрыта!<br/>";
if($prava>=5){
echo "<img src='/pictures/icons/help.gif' alt='*'/> <a href="forum.php?game=okclose&id=$id&uid=$uid">Открыть тему</a><br/>";
}
}
if($prava>=5){
echo "<img src='/pictures/icons/help.gif' alt='*'/> <a href="forum.php?game=deltem&id=$id&uid=$uid">Удалить тему</a><br/>";
}
$q = mysql_query("SELECT COUNT(`uid`) FROM `tb_forummsgs` WHERE `uid`='$uid'");
$kol = mysql_result($q, 0);
echo "<div class='bts'></div>";
if($startan!= 0) $page2left = ' <a href= forum.php?game=tem&startan='. ($startan - 5) .'&page='.($page-1).'&id='.$id.'&uid='.$uid.'>'. ($page - 1) .'</a> | ';
if(empty($page)){$page=1;}
if($kol > $startan + 5) $page2right = ' | <a href= forum.php?game=tem&startan='. ($startan + 5) .'&page='. ($page+1) .'&id='.$id.'&uid='.$uid.'>'. ($page + 1) .'</a>';
echo $page2left.'<b>('.$page.')</b>'.$page1right.$page2right.'<br/>';
if ($startan != 0) {echo '<div class="bts"></div><a href="forum.php?startan='.($startan - 5).'&id='.$id.'&uid='.$uid.'&game=tem&page='.($page-1).'">Назад</a> ';}
if ($kol > $startan + 5) {echo ' <a href="forum.php?startan='.($startan + 5).'&id='.$id.'&uid='.$uid.'&game=tem&page='.($page+1).'">Далее</a>';}
}else{echo "Такая тема не существует!";}
include ("niz/niz.php");
exit;
}
if($game=="theme"){
$g=mysql_query("SELECT * FROM `tb_forums` WHERE `id`='$id' LIMIT 1");
if(mysql_num_rows($g)==1){
$q = mysql_query("SELECT COUNT(`id`) FROM `tb_themes` WHERE `id`='$id'");
$kol = mysql_result($q, 0);
if($kol=="0"){echo "В разделе пока нет тем!";}
if(empty($startan)) $startan = 0;
$startan=intval($startan);
if($startan<0) $startan=0; $num_msgs_an=5;
$qi = mysql_query("SELECT * FROM `tb_themes` WHERE `id`='$id' ORDER by `uid` DESC LIMIT $startan,$num_msgs_an");
while($row=mysql_fetch_array($qi))
{
if($row[autor]=="$nick"){
echo "";
}
if($row[onoff]=="0"){
echo "<img src='/pictures/icons/them_01.png' alt='*'/> ";
}
$req = mysql_query("SELECT `prava`,`status` FROM `turaga_pers` WHERE `nick` = '$row[autor]'");
$pic = mysql_fetch_array($req);
if ($pic['status']==0)echo "<img src='/pictures/status/on.gif' alt='' class='icon'/>";
else if ($pic['status']==1)echo "<img src='/pictures/status/gotov_boltat.png' alt='' class='icon'/>";
else if ($pic['status']==2)echo "<img src='/pictures/status/zaniat.png' alt='' class='icon'/>";
else if ($pic['status']==3)echo "<img src='/pictures/status/boleu.png' alt='' class='icon'/>";
else if ($pic['status']==4)echo "<img src='/pictures/status/depressia.png' alt='' class='icon'/>";
else if ($pic['status']==5)echo "<img src='/pictures/status/dumau.png' alt='' class='icon'/>";
else if ($pic['status']==6)echo "<img src='/pictures/status/kuru.png' alt='' class='icon'/>";
else if ($pic['status']==7)echo "<img src='/pictures/status/kushau.png' alt='' class='icon'/>";
else if ($pic['status']==8)echo "<img src='/pictures/status/love.png' alt='' class='icon'/>";
else if ($pic['status']==9)echo "<img src='/pictures/status/tv.png' alt='' class='icon'/>";
else if ($pic['status']==10)echo "<img src='/pictures/status/music.png' alt='' class='icon'/>";
else if ($pic['status']==11)echo "<img src='/pictures/status/vanna.png' alt='' class='icon'/>";
else if ($pic['status']==12)echo "<img src='/pictures/status/tualet.png' alt='' class='icon'/>";
else if ($pic['status']==13)echo "<img src='/pictures/status/sex.png' alt='' class='icon'/>";
else if ($pic['status']==14)echo "<img src='/pictures/status/igrau.png' alt='' class='icon'/>";
else if ($pic['status']==15)echo "<img src='/pictures/status/pivo.png' alt='' class='icon'/>";
else if ($pic['status']==16)echo "<img src='/pictures/status/sonni.png' alt='' class='icon'/>";
////////
else if ($pic['status']==17)echo "<img src='/pictures/status/1.png' alt='' class='icon'/>";
else if ($pic['status']==18)echo "<img src='/pictures/status/12.png' alt='' class='icon'/>";
else if ($pic['status']==19)echo "<img src='/pictures/status/13.png' alt='' class='icon'/>";
else if ($pic['status']==20)echo "<img src='/pictures/status/14.png' alt='' class='icon'/>";
else if ($pic['status']==21)echo "<img src='/pictures/status/18.png' alt='' class='icon'/>";
else if ($pic['status']==22)echo "<img src='/pictures/status/19.png' alt='' class='icon'/>";
else if ($pic['status']==23)echo "<img src='/pictures/status/31.png' alt='' class='icon'/>";
else if ($pic['status']==24)echo "<img src='/pictures/status/7.png' alt='' class='icon'/>";
echo " <a href="nick_info.php?nick=$row[autor]&go=go">$row[autor]</a>";
$req = mysql_query("SELECT `prava`,`status` FROM `turaga_pers` WHERE `nick` = '$row[autor]'");
$pic = mysql_fetch_array($req);
if($pic['prava']==5){
echo'<font color="lime">.GM</font>';
}
if($pic['prava']==2){
echo'<font color="blue">.M</font>';
}
if($pic['prava']==3){
echo'<font color="yellow">.Faq</font>';
}
echo" ($row[time])<br/>
<a href="forum.php?game=tem&id=$row[id]&uid=$row[uid]">$row[name]</a> [<b>$row[msg]</b>]<br/>Последний написал в теме: ";
$req = mysql_query("SELECT `prava`,`status` FROM `turaga_pers` WHERE `nick` = '$row[posl]'");
$pic = mysql_fetch_array($req);
if ($pic['status']==0)echo "<img src='/pictures/status/on.gif' alt='' class='icon'/>";
else if ($pic['status']==1)echo "<img src='/pictures/status/gotov_boltat.png' alt='' class='icon'/>";
else if ($pic['status']==2)echo "<img src='/pictures/status/zaniat.png' alt='' class='icon'/>";
else if ($pic['status']==3)echo "<img src='/pictures/status/boleu.png' alt='' class='icon'/>";
else if ($pic['status']==4)echo "<img src='/pictures/status/depressia.png' alt='' class='icon'/>";
else if ($pic['status']==5)echo "<img src='/pictures/status/dumau.png' alt='' class='icon'/>";
else if ($pic['status']==6)echo "<img src='/pictures/status/kuru.png' alt='' class='icon'/>";
else if ($pic['status']==7)echo "<img src='/pictures/status/kushau.png' alt='' class='icon'/>";
else if ($pic['status']==8)echo "<img src='/pictures/status/love.png' alt='' class='icon'/>";
else if ($pic['status']==9)echo "<img src='/pictures/status/tv.png' alt='' class='icon'/>";
else if ($pic['status']==10)echo "<img src='/pictures/status/music.png' alt='' class='icon'/>";
else if ($pic['status']==11)echo "<img src='/pictures/status/vanna.png' alt='' class='icon'/>";
else if ($pic['status']==12)echo "<img src='/pictures/status/tualet.png' alt='' class='icon'/>";
else if ($pic['status']==13)echo "<img src='/pictures/status/sex.png' alt='' class='icon'/>";
else if ($pic['status']==14)echo "<img src='/pictures/status/igrau.png' alt='' class='icon'/>";
else if ($pic['status']==15)echo "<img src='/pictures/status/pivo.png' alt='' class='icon'/>";
else if ($pic['status']==16)echo "<img src='/pictures/status/sonni.png' alt='' class='icon'/>";
////////
else if ($pic['status']==17)echo "<img src='/pictures/status/1.png' alt='' class='icon'/>";
else if ($pic['status']==18)echo "<img src='/pictures/status/12.png' alt='' class='icon'/>";
else if ($pic['status']==19)echo "<img src='/pictures/status/13.png' alt='' class='icon'/>";
else if ($pic['status']==20)echo "<img src='/pictures/status/14.png' alt='' class='icon'/>";
else if ($pic['status']==21)echo "<img src='/pictures/status/18.png' alt='' class='icon'/>";
else if ($pic['status']==22)echo "<img src='/pictures/status/19.png' alt='' class='icon'/>";
else if ($pic['status']==23)echo "<img src='/pictures/status/31.png' alt='' class='icon'/>";
else if ($pic['status']==24)echo "<img src='/pictures/status/7.png' alt='' class='icon'/>";
echo" <a href="nick_info.php?nick=$row[posl]&go=go">$row[posl]</a>";
$req = mysql_query("SELECT `prava`,`status` FROM `turaga_pers` WHERE `nick` = '$row[posl]'");
$pic = mysql_fetch_array($req);
if($pic['prava']==5){
echo'<font color="lime">.GM</font>';
}
if($pic['prava']==2){
echo'<font color="blue">.M</font>';
}
if($pic['prava']==3){
echo'<font color="yellow">.Faq</font>';
}
echo"<div class='bts'></div>";
}
echo "<img src='/pictures/icons/chat.gif' alt='*'/> <a href="forum.php?game=newforum&id=$id">Начать новую тему</a>";
echo"<div class='bts'></div>";
$q = mysql_query("SELECT COUNT(`id`) FROM `tb_themes` WHERE `id`='$id'");
$kol = mysql_result($q, 0);
if($startan!= 0) $page2left = ' <a href= forum.php?game=theme&startan='. ($startan - 5) .'&page='.($page-1).'&id='.$id.'>'. ($page - 1) .'</a> | ';
if(empty($page)){$page=1;}
if($kol > $startan + 5) $page2right = ' | <a href= forum.php?game=theme&startan='. ($startan + 5) .'&page='. ($page+1) .'&id='.$id.'>'. ($page + 1) .'</a>';
echo $page2left.'<b>('.$page.')</b>'.$page1right.$page2right.'<br/>';
if ($startan != 0) {echo '<a href="forum.php?game=theme&startan='.($startan - 5).'&nick='.$nick.'&pass='.$pass.'&page='.($page-1).'&id='.$id.'">Назад</a> ';}
if ($kol > $startan + 5) {echo ' <a href="forum.php?&game=theme&startan='.($startan + 5).'&page='.($page+1).'&id='.$id.'">Далее</a>';}
include ("niz/niz.php");
exit;
}}
//////////////////
$q = mysql_query("SELECT COUNT(`id`) FROM `tb_forums`;");
$kol = mysql_result($q, 0);
if($kol<="0"){echo "Разделы пока не созданы";
if($prava>=5){
echo "<br/><img src='/pictures/icons/chat.gif' alt='*'/> <a href="forum.php?game=addraz">Добавить раздел</a>";
}
include ("niz/niz.php");
exit;
}
$qi = mysql_query("SELECT * FROM `tb_forums` ORDER by `id` ASC");
while($row=mysql_fetch_array($qi))
{
echo "<img src="pictures/forums.gif"> <a href="forum.php?game=theme&id=$row[id]">$row[forumname]</a> [<b><font color='lime'>$row[forumthemes]</font></b>/<b><font color='red'>$row[forummsg]</font></b>]<br/>";
}
$q = mysql_query("SELECT COUNT(`id`) FROM `tb_forums`;");
$kol1 = mysql_result($q, 0);
$q = mysql_query("SELECT COUNT(`aid`) FROM `tb_forummsgs`;");
$kol2 = mysql_result($q, 0);
$q = mysql_query("SELECT COUNT(`id`) FROM `tb_themes`;");
$kol3 = mysql_result($q, 0);
if($prava>=5){
echo "<br/><img src='/pictures/icons/chat.gif' alt='*'/> <a href="forum.php?game=addraz">Добавить раздел</a>";
}
$result666 = mysql_query("SELECT * FROM `tb_forumosts`");
$post = mysql_fetch_array($result666);
echo "<br/><img src='/pictures/icons/chat.gif' alt='*'/> Последний написавший на форуме: <a href="nick_info.php?nick=$post[nick]&go=go">$post[nick]</a>";
echo"<br/>
<img src='/pictures/icons/chat.gif' alt='*'/> Всего на форуме разделов: (<b>$kol1</b>)<br/>
<img src='/pictures/icons/chat.gif' alt='*'/> Всего на форуме тем: (<b>$kol3</b>)<br/>
<img src='/pictures/icons/chat.gif' alt='*'/> Всего на форуме сообщений: (<b>$kol2</b>)<br/>";
}
}else{
echo "Пройдите авторизацию!";
echo "<hr><a href="index.php">На главную</a>";
}
include ("niz/niz.php");
?>