Файл: rban/rban/forum/main.php
Строк: 181
<?
require "consts.php";
require "incl.php";
require "valid1.php";
$agent=$HTTP_USER_AGENT;
$conn=mysql_connect(my_host, my_user, my_password);
mysql_select_db(my_db, $conn);
header("Cache-Control: no-cache");
header("Content-Type: text/vnd.wap.wml; charset=utf-8");
echo '<?xml version="1.0" encoding="utf-8"?>';
echo '<!DOCTYPE wml PUBLIC "-//WAPFORUM//DTD WML 1.2//EN"
"http://www.wapforum.org/DTD/wml1.2.dtd">';
$sql1=("select `nomer` from `rating` where room='1'");
$result1=mysql_query($sql1);
$n1=0;
$n2=0;
$n3=0;
$n4=0;
$n6=0;
$n7=0;
$n8=0;
$n9=0;
$n10=0;
$n11=0;
$n12=0;
$n13=0;
$n14=0;
while ($row1=mysql_fetch_object($result1))
{
$n1=$n1+1;
}
$sql2=("select `nomer` from `rating` where room='2'");
$result2=mysql_query($sql2);
while ($row2=mysql_fetch_object($result2))
{
$n2=$n2+1;
}
$sql3=("select `nomer` from `rating` where room='3'");
$result3=mysql_query($sql3);
while ($row3=mysql_fetch_object($result3))
{
$n3=$n3+1;
}
$sql4=("select `nomer` from `rating` where room='4'");
$result4=mysql_query($sql4);
while ($row4=mysql_fetch_object($result4))
{
$n4=$n4+1;
}
$sql5=("select `nomer` from `rating` where room='5'");
$result5=mysql_query($sql5);
while ($row5=mysql_fetch_object($result5))
{
$n5=$n5+1;
}
$sql6=("select `nomer` from `rating` where room='6'");
$result6=mysql_query($sql6);
while ($row6=mysql_fetch_object($result6))
{
$n6=$n6+1;
}
$sql7=("select `nomer` from `rating` where room='7'");
$result7=mysql_query($sql7);
while ($row7=mysql_fetch_object($result7))
{
$n7=$n7+1;
}
$sql8=("select `nomer` from `rating` where room='8'");
$result8=mysql_query($sql8);
while ($row8=mysql_fetch_object($result8))
{
$n8=$n8+1;
}
$sql9=("select `nomer` from `rating` where room='9'");
$result9=mysql_query($sql9);
while ($row9=mysql_fetch_object($result9))
{
$n9=$n9+1;
}
$sql10=("select `nomer` from `rating` where room='10'");
$result10=mysql_query($sql10);
while ($row10=mysql_fetch_object($result10))
{
$n10=$n10+1;
}
$sql11=("select `nomer` from `rating` where room='11'");
$result11=mysql_query($sql11);
while ($row11=mysql_fetch_object($result11))
{
$n11=$n11+1;
}
$sql12=("select `nomer` from `rating` where room='12'");
$result12=mysql_query($sql12);
while ($row12=mysql_fetch_object($result12))
{
$n12=$n12+1;
}
$sql13=("select `nomer` from `rating` where room='13'");
$result13=mysql_query($sql13);
while ($row13=mysql_fetch_object($result13))
{
$n13=$n13+1;
}
$sql14=("select `nomer` from `rating` where room='14'");
$result14=mysql_query($sql14);
while ($row14=mysql_fetch_object($result14))
{
$n14=$n14+1;
}
if ($room==1)
{
$nameroom="Баннерная сеть";
$n=$n1;
}
if ($room==2)
{
$nameroom="Технический подфорум";
$n=$n2;
}
if ($room==3)
{
$nameroom="Музыка, кино";
$n=$n3;
}
if ($room==4)
{
$nameroom="Разное";
$n=$n4;
}
if ($room==6)
{
$nameroom="Вопросы админу";
$n=$n6;
}
if ($room==7)
{
$nameroom="Создание сайтов";
$n=$n7;
}
if ($room==5)
{
$nameroom="Мобилки";
$n=$n5;
}
if ($room==8)
{
$nameroom="Куплю/продам";
$n=$n8;
}
if ($room==9)
{
$nameroom="Hard&Soft";
$n=$n9;
}
if ($room==10)
{
$nameroom="Встречи чата";
$n=$n10;
}
if ($room==11)
{
$nameroom="Вопросы";
$n=$n11;
}
if ($room==12)
{
$nameroom="Приколы";
$n=$n12;
}
if ($room==13)
{
$nameroom="Человек, жизнь, общество";
$n=$n13;
}
if ($room==14)
{
$nameroom="Предложения";
$n=$n14;
}
echo '<wml>';
echo '<head>';
echo '<meta http-equiv="Cache-Control" content="no-cache" forua="true"/>';
echo '</head>';
?><card title="<?=$nameroom?> (<?=$n?>)"><?
echo '<p>';
?>
<small><a href="topic.php?id=<?=$id?>&pass=<?=$pass?>&room=<?=$room?>">Добавить тему</a></small><br/>
<?
if(isset($HTTP_GET_VARS['next_row']))
{
$next_row=$HTTP_GET_VARS['next_row'];
}
else
{
$next_row=0;
}
$sql=("select * from `rating` where room='$room' order by nomer desc limit $next_row, $themes ");
$result=mysql_query($sql);
$sql3=("select * from `topic` where nomer='$nomer'");
$result3=mysql_query($sql3);
$row3=mysql_fetch_object($result3);
$nomer=$row3->nomer;
$prosm=$row3->prosm;
$name=$row3->name;
$message=str_replace("$", "backs", $message);
$message=htmlspecialchars($message);
$message=$row3->message;
$message=ereg_replace("h","?", $message);
$message=ereg_replace("a","?", $message);
$message=ereg_replace("b","?", $message);
$message=ereg_replace("v","?", $message);
$message=ereg_replace("g","?", $message);
$message=ereg_replace("d","?", $message);
$message=ereg_replace("e","?", $message);
$message=ereg_replace("z","?", $message);
$message=ereg_replace("i","?", $message);
$message=ereg_replace("j","?", $message);
$message=ereg_replace("k","?", $message);
$message=ereg_replace("l","?", $message);
$message=ereg_replace("m","?", $message);
$message=ereg_replace("n","?", $message);
$message=ereg_replace("o","?", $message);
$message=ereg_replace("p","?", $message);
$message=ereg_replace("r","?", $message);
$message=ereg_replace("s","?", $message);
$message=ereg_replace("t","?", $message);
$message=ereg_replace("u","?", $message);
$message=ereg_replace("f","?", $message);
$message=ereg_replace("c","?", $message);
$message=ereg_replace("y?","?", $message);
$message=ereg_replace("x","?", $message);
$message=ereg_replace("y?","?", $message);
$message=ereg_replace("y?","?", $message);
$message=ereg_replace("q","?", $message);
$message=ereg_replace("Q","?", $message);
$message=ereg_replace("H","?", $message);
$message=ereg_replace("A","?", $message);
$message=ereg_replace("B","?", $message);
$message=ereg_replace("V","?", $message);
$message=ereg_replace("G","?", $message);
$message=ereg_replace("D","?", $message);
$message=ereg_replace("E","?", $message);
$message=ereg_replace("Z","?", $message);
$message=ereg_replace("I","?", $message);
$message=ereg_replace("J","?", $message);
$message=ereg_replace("K","?", $message);
$message=ereg_replace("L","?", $message);
$message=ereg_replace("M","?", $message);
$message=ereg_replace("N","?", $message);
$message=ereg_replace("O","?", $message);
$message=ereg_replace("P","?", $message);
$message=ereg_replace("R","?", $message);
$message=ereg_replace("S","?", $message);
$message=ereg_replace("T","?", $message);
$message=ereg_replace("U","?", $message);
$message=ereg_replace("F","?", $message);
$message=ereg_replace("C","?", $message);
$message=ereg_replace("Y?","?", $message);
$message=ereg_replace("X","?", $message);
$message=ereg_replace("Y?","?", $message);
$message=ereg_replace("Y?","?", $message);
$message=str_replace("$", " backs", $message);
$message=htmlspecialchars($message);
$row3->message=$message;
$sql2=("select `nomer` from `forum` where topic='$id'");
$result2=mysql_query($sql2);
$n=0;
while ($row2=mysql_fetch_object($result2))
{
$n=$n+1;
}
$message=$row3->message;
$row3->message=$message;
$row3->message=translate($row3->message);
$sql2=("select `nomer` from `forum` where topic='$id'");
$result2=mysql_query($sql2);
$n=0;
while ($row2=mysql_fetch_object($result2))
{
$n=$n+1;
}
$message=$row3->message;
$row3->message=$message;
$row3->message=translate($row3->message);
$sql22="select nick from users where id='$name'";
$res22=mysql_query($sql22);
$row22=mysql_fetch_object($res22);
$name2=$row22->nick;
$name2=translate($name2);
?>
<a href="read_topic.php?id=<?=$id?>&pass=<?=$pass?>&topic=<?=$nomer?>&user=<?=$name?>&room=<?=$room?>"><?=$site?>
<?echo ' ';?>
<?=$row3->date?> [<?=$n?>/<?=$prosm?>]</a><br/>
<?=$row3->message?><br/>
<br/>
<?
$next_row=$next_row+1;
?>
<a href="main.php?id=<?=$id?>&pass=<?=$pass?>&next_row=<?=$next_row?>&room=<?=$room?>">
<?
echo '<small>Дальше</small></a><br/>';
?><small><a href="index.php?id=<?=$id?>&pass=<?=$pass?>">Главная форума</a><br/></small>
<?
$dpoint=".";
$dpoint2=":";
$time2 =date(d);
$time2 .=$dpoint;
$time2 .=date(m);
$time2 .=$dpoint;
$time2 .=date(y);
$time2.= " - ";
$time2 .=date(H);
$time2.=$dpoint2;
$time2.=date(i1);
$time2.=$dpoint2;
$time2 .=date(s);
?>
</p>
</card>
</wml>