Файл: phpfile/forum.php
Строк: 579
<?php
/**
* @author wistis
* @copyright 2011
*/
// показываем защищенные от гостей данные.
print '<div class="spiski"><div class="zagolovok">Форум</div><div class="line"></div><ul>';
$query = "SELECT * FROM `table1` WHERE `name`='" . mysql_real_escape_string($opredelenie) .
"'";
$sql = mysql_query($query) or die(mysql_error());
$row = mysql_fetch_assoc($sql);
if ($row['administracia'] > 2) {
if (isset($_GET['editsms'])) {
if (isset($_POST['news'])) {
$text = htmlspecialchars($_POST['text']);
$text = mysql_real_escape_string($text);
mysql_query("UPDATE `fsms` SET `text` = '$text' WHERE `id` ='" .
mysql_real_escape_string($_GET['editsms']) . "' LIMIT 1 ;");
print y."Вы изменили сообщение".d;
print "<li><a href=88.php?go=forum>Форум</a>
</li><li><a href=88.php?go=forum&r=" . $_GET['r'] . "&tema=" . $_GET['tema'] .
">К темам</a></li>";
exitt($row, $opredelenie);
;
}
$sqlpp = mysql_query("SELECT *
FROM `fsms`
where `id`='" . mysql_real_escape_string($_GET['editsms']) . "'");
$rowpp = mysql_fetch_array($sqlpp);
print cat."Редактирование сообщений
<form action=88.php?go=forum&r=" . $_GET['r'] . "&tema=" . $_GET['tema'] .
"&editsms=" . $_GET['editsms'] . " method=post>
Текст письма:<br><textarea class=x_text name=text rows=3 cols=20>" . $rowpp['text'] .
"</textarea><br>
<input name=ok class=x_sumbit type=submit value=ok><input type=hidden name=news />
</form></center>".d;
print "<li><a href=88.php?go=forum>Форум</a>
</li><li><a href=88.php?go=forum&r=" . $_GET['r'] . "&tema=" . $_GET['tema'] .
">К темам</a></li>";
exitt($row, $opredelenie);
;
}
if (isset($_GET['edit'])) {
if (isset($_POST['news'])) {
$text = htmlspecialchars($_POST['text']);
$text = mysql_real_escape_string($text);
mysql_query("UPDATE `fraz` SET `name` = '$text' WHERE `id` ='" .
mysql_real_escape_string($_GET['tma']) . "' LIMIT 1 ;");
print y."Вы изменили название темы!".d;
print "<li><a href=88.php?go=forum>Форум</a>
</li><li><a href=88.php?go=forum&r=" . $_GET['r'] . ">К темам</a></li>";
exitt($row, $opredelenie);
;
}
$sqlpp = mysql_query("SELECT *
FROM `fraz`
where `id`='" . mysql_real_escape_string($_GET['tma']) . "'");
$rowpp = mysql_fetch_array($sqlpp);
print cat."<li>Редактирование названия темы</li>
<form action=88.php?go=forum&r=" . $_GET['r'] . "&tma=" . $_GET['tma'] .
"&edit method=post>
Текст письма:<br><textarea class=x_text name=text rows=3 cols=20>" . $rowpp['name'] .
"</textarea><br>
<input name=ok class=x_sumbit type=submit value=ok><input type=hidden name=news />
</form></center>".d;
print "<li><a href=88.php?go=forum>Форум</a>
</li><li><a href=88.php?go=forum&r=" . $_GET['r'] . ">К темам</a></li>";
exitt($row, $opredelenie);
;
}
if (isset($_GET['perenesti'])) {
print "<li>Перенос тем форума!</li>";
if (isset($_POST['magia'])) {
mysql_query("UPDATE `fraz` SET `idfrk` = '" . mysql_real_escape_string($_POST['magia']) .
"' WHERE
`id` ='" . mysql_real_escape_string($_GET['tma']) . "' LIMIT 1 ;");
mysql_query("UPDATE `fsms` SET `razdel` = '" . mysql_real_escape_string($_POST['magia']) .
"' WHERE
`tema` ='" . mysql_real_escape_string($_GET['tma']) . "' ;");
print y."Вы перенесли тему!".d;
print "<li><a href=88.php?go=forum>Форум</a></li>
<li><a href=88.php?go=forum&r=" . $_GET['r'] . ">К темам</a></li>";
exitt($row, $opredelenie);
}
$queryzakl = "SELECT * FROM `frk` ";
$sqlzakl = mysql_query($queryzakl) or die(mysql_error());
print cat."<br>
<form name=forselect1912 action=88.php?go=forum&r=" . $_GET['r'] . "&tma=" . $_GET['tma'] .
"&perenesti method=post>
<select class=x_option name=magia size=1>";
while ($rowzakl = mysql_fetch_assoc($sqlzakl)) {
print "
<option selected value=" . $rowzakl['id'] . ">" . htmlspecialchars($rowzakl['name']) .
"</option>
;";
;
}
print "
</select><br><input class=x_sumbit type=submit name=formbutton2fff value=Перенести>
</form>".d;
print "<li><a href=88.php?go=forum>Форум</a></li><li>
<a href=88.php?go=forum&r=" . $_GET['r'] . ">К темам</a></li>";
exitt($row, $opredelenie);
;
}
#########################################################################
###############################################################################
if (isset($_GET['loc'])) {
mysql_query("update `fraz` set `status`='1'WHERE `fraz`.`id` = '" . $_GET['tma'] . "' ") or
die(mysql_error());
;
;
}
if (isset($_GET['deltema'])) {
mysql_query("DELETE FROM `fraz` WHERE `fraz`.`id` = '" . $_GET['tma'] . "' ") or
die(mysql_error());
;
mysql_query("DELETE FROM `fsms` WHERE `fsms`.`tema` = '" . $_GET['tma'] . "' ") or
die(mysql_error());
;
}
if (isset($_GET['golos'])) {
mysql_query("UPDATE `fraz` SET `golos` = '1' WHERE
`id` ='" . mysql_real_escape_string($_GET['tma']) . "' LIMIT 1 ;");
;
}
;
if (isset($_GET['del'])) {
mysql_query("DELETE FROM `fsms` WHERE `fsms`.`id` = " . $_GET['del'] . " ");
}
}
if ((isset($_GET['r'])) && (!is_numeric($_GET['r']))) {
print no."неверно".d;
exi($row, $opredelenie);
}
if ((isset($_GET['tema'])) && (!is_numeric($_GET['tema']))) {
print no."неверно".d;
exi($row, $opredelenie);
}
if (isset($_GET['otvet'])) {
?>
<script language="JavaScript">
function pi(str) {
tmp = parent.forumot.log.value;
parent.forumot.log.value = tmp + str;
}
</script>
<center>
<?php
echo cat;
if((isset($_GET['stra']))&&($_GET['stra']==1)){
?>
<A href="javascript:pi(' :01_Smile1 ')"><IMG src=smiles/01_Smile1.gif border=0></A>
<A href="javascript:pi(' :02_smile2 ')"><IMG src=smiles/02_smile2.gif border=0></A>
<A href="javascript:pi(' :03_biggrin ')"><IMG src=smiles/03_biggrin.gif border=0></A>
<A href="javascript:pi(' :03_lol ')"><IMG src=smiles/03_lol.gif border=0></A>
<A href="javascript:pi(' :04_wink ')"><IMG src=smiles/04_wink.gif border=0></A>
<A href="javascript:pi(' :05_skeptik ')"><IMG src=smiles/05_skeptik.gif border=0></A><br />
<A href="javascript:pi(' :06_blink ')"><IMG src=smiles/06_blink.gif border=0></A>
<A href="javascript:pi(' :07_sad ')"><IMG src=smiles/07_sad.gif border=0></A>
<A href="javascript:pi(' :08_cool ')"><IMG src=smiles/08_cool.gif border=0></A>
<A href="javascript:pi(' :09_bebe ')"><IMG src=smiles/09_bebe.gif border=0></A>
<A href="javascript:pi(' :10_shok ')"><IMG src=smiles/10_shok.gif border=0></A>
<A href="javascript:pi(' :12_plaksa ')"><IMG src=smiles/12_plaksa.gif border=0></A><br />
<A href="javascript:pi(' :13_angry ')"><IMG src=smiles/13_angry.gif border=0></A>
<A href="javascript:pi(' :15_blush ')"><IMG src=smiles/15_blush.gif border=0></A>
<A href="javascript:pi(' :19_Privet ')"><IMG src=smiles/19_Privet.gif border=0></A>
<A href="javascript:pi(' :20_Poka ')"><IMG src=smiles/20_Poka.gif border=0></A>
<A href="javascript:pi(' :24_roza ')"><IMG src=smiles/24_roza.gif border=0></A>
<A href="javascript:pi(' :27_pivo ')"><IMG src=smiles/27_pivo.gif border=0></A><br />
<A href="javascript:pi(' :28_devil ')"><IMG src=smiles/28_devil.gif border=0></A>
<A href="javascript:pi(' :29_dash ')"><IMG src=smiles/29_dash.gif border=0></A>
<A href="javascript:pi(' :2pistoleta ')"><IMG src=smiles/2pistoleta.gif border=0></A>
<A href="javascript:pi(' :30_druzhba ')"><IMG src=smiles/30_druzhba.gif border=0></A>
<A href="javascript:pi(' :31_kur ')"><IMG src=smiles/31_kur.gif border=0></A>
<A href="javascript:pi(' :35_idiot ')"><IMG src=smiles/35_idiot.gif border=0></A><br />
<?php
;}
if((isset($_GET['stra']))&&($_GET['stra']==2)){
?>
<A href="javascript:pi(' :36_fingal ')"><IMG src=smiles/36_fingal.gif border=0></A>
<A href="javascript:pi(' :actoy ')"><IMG src=smiles/actoy.gif border=0></A>
<A href="javascript:pi(' :afiget ')"><IMG src=smiles/afiget.gif border=0></A>
<A href="javascript:pi(' :alkawi ')"><IMG src=smiles/alkawi.gif border=0></A>
<A href="javascript:pi(' :alkogolik ')"><IMG src=smiles/alkogolik.gif border=0></A>
<A href="javascript:pi(' :angel ')"><IMG src=smiles/angel.gif border=0></A><br />
<A href="javascript:pi(' :ban ')"><IMG src=smiles/ban.gif border=0></A>
<A href="javascript:pi(' :bis ')"><IMG src=smiles/bis.gif border=0></A>
<A href="javascript:pi(' :blabla ')"><IMG src=smiles/blabla.gif border=0></A>
<A href="javascript:pi(' :bolen ')"><IMG src=smiles/bolen.gif border=0></A>
<A href="javascript:pi(' :bomba ')"><IMG src=smiles/bomba.gif border=0></A>
<A href="javascript:pi(' :cenzura ')"><IMG src=smiles/cenzura.gif border=0></A><br />
<A href="javascript:pi(' :cherep ')"><IMG src=smiles/cherep.gif border=0></A>
<A href="javascript:pi(' :condom ')"><IMG src=smiles/condom.gif border=0></A>
<A href="javascript:pi(' :cool3 ')"><IMG src=smiles/cool3.gif border=0></A>
<A href="javascript:pi(' :death ')"><IMG src=smiles/death.gif border=0></A>
<A href="javascript:pi(' :dozhd ')"><IMG src=smiles/dozhd.gif border=0></A>
<A href="javascript:pi(' :druzhba3 ')"><IMG src=smiles/druzhba3.gif border=0></A><br />
<A href="javascript:pi(' :fan ')"><IMG src=smiles/fan.gif border=0></A>
<A href="javascript:pi(' :Faq ')"><IMG src=smiles/Faq.gif border=0></A>
<A href="javascript:pi(' :feministka ')"><IMG src=smiles/feministka.gif border=0></A>
<A href="javascript:pi(' :figa ')"><IMG src=smiles/figa.gif border=0></A>
<A href="javascript:pi(' :flag2 ')"><IMG src=smiles/flag2.gif border=0></A>
<A href="javascript:pi(' :gadaet ')"><IMG src=smiles/gadaet.gif border=0></A><br />
<?php
;}
if((isset($_GET['stra']))&&($_GET['stra']==3)){
?>
<A href="javascript:pi(' :help ')"><IMG src=smiles/help.gif border=0></A>
<A href="javascript:pi(' :google ')"><IMG src=smiles/google.gif border=0></A>
<A href="javascript:pi(' :hi ')"><IMG src=smiles/hi.gif border=0></A>
<A href="javascript:pi(' :hrap ')"><IMG src=smiles/hrap.gif border=0></A>
<A href="javascript:pi(' :idea ')"><IMG src=smiles/idea.gif border=0></A>
<A href="javascript:pi(' :kiss4 ')"><IMG src=smiles/kiss4.gif border=0></A><br />
<A href="javascript:pi(' :korol ')"><IMG src=smiles/korol.gif border=0></A>
<A href="javascript:pi(' :larisu ')"><IMG src=smiles/larisu.gif border=0></A>
<A href="javascript:pi(' :ment ')"><IMG src=smiles/ment.gif border=0></A>
<A href="javascript:pi(' :Moder1 ')"><IMG src=smiles/Moder1.gif border=0></A>
<A href="javascript:pi(' :Moder2 ')"><IMG src=smiles/Moder2.gif border=0></A>
<A href="javascript:pi(' :Moder3 ')"><IMG src=smiles/Moder3.gif border=0></A><br />
<A href="javascript:pi(' :mog ')"><IMG src=smiles/mog.gif border=0></A>
<A href="javascript:pi(' :nakone ')"><IMG src=smiles/nakone.gif border=0></A>
<A href="javascript:pi(' :nedovolna ')"><IMG src=smiles/nedovolna.gif border=0></A>
<A href="javascript:pi(' :ninja ')"><IMG src=smiles/ninja.gif border=0></A>
<A href="javascript:pi(' :OOps ')"><IMG src=smiles/OOps.gif border=0></A>
<A href="javascript:pi(' :or ')"><IMG src=smiles/or.gif border=0></A><br />
<A href="javascript:pi(' :owibochka ')"><IMG src=smiles/owibochka.gif border=0></A>
<A href="javascript:pi(' :perv ')"><IMG src=smiles/perv.gif border=0></A>
<A href="javascript:pi(' :piosmok ')"><IMG src=smiles/piosmok.gif border=0></A>
<A href="javascript:pi(' :pirat ')"><IMG src=smiles/pirat.gif border=0></A>
<A href="javascript:pi(' :pivanet ')"><IMG src=smiles/pivanet.gif border=0></A>
<A href="javascript:pi(' :ploho2 ')"><IMG src=smiles/ploho2.gif border=0></A><br />
<?php
;}
if((isset($_GET['stra']))&&($_GET['stra']==4)){
?>
<A href="javascript:pi(' :poka ')"><IMG src=smiles/poka.gif border=0></A>
<A href="javascript:pi(' :russoldat ')"><IMG src=smiles/russoldat.gif border=0></A>
<A href="javascript:pi(' :rzhu ')"><IMG src=smiles/rzhu.gif border=0></A>
<A href="javascript:pi(' :sestra ')"><IMG src=smiles/sestra.gif border=0></A>
<A href="javascript:pi(' :sex2 ')"><IMG src=smiles/sex2.gif border=0></A>
<A href="javascript:pi(' :siski ')"><IMG src=smiles/siski.gif border=0></A><br />
<A href="javascript:pi(' :skosoj ')"><IMG src=smiles/skosoj.gif border=0></A>
<A href="javascript:pi(' :Sorry ')"><IMG src=smiles/Sorry.gif border=0></A>
<A href="javascript:pi(' :super ')"><IMG src=smiles/super.gif border=0></A>
<A href="javascript:pi(' :svadba ')"><IMG src=smiles/svadba.gif border=0></A>
<A href="javascript:pi(' :tanz ')"><IMG src=smiles/tanz.gif border=0></A>
<A href="javascript:pi(' :vilka_nozh ')"><IMG src=smiles/vilka_nozh.gif border=0></A><br />
<A href="javascript:pi(' :vopros ')"><IMG src=smiles/vopros.gif border=0></A>
<A href="javascript:pi(' :vsempr ')"><IMG src=smiles/vsempr.gif border=0></A>
<A href="javascript:pi(' :yahoo ')"><IMG src=smiles/yahoo.gif border=0></A>
<A href="javascript:pi(' :yy ')"><IMG src=smiles/yy.gif border=0></A>
<A href="javascript:pi(' :zona ')"><IMG src=smiles/zona.gif border=0></A>
<A href="javascript:pi(' :zub ')"><IMG src=smiles/zub.gif border=0></A><br />
<A href="javascript:pi(' :zuby ')"><IMG src=smiles/zuby.gif border=0></A>
</center>
<?
;}
if(isset($_GET['otvet'])){
print "Смайлики:
<a href=88.php?go=forum&r=" . $_GET['r'] .
"&tema=" . $_GET['tema'] . "&otvet=".htmlspecialchars($_GET['otvet'])."&stra=1>1</a>|
<a href=88.php?go=forum&r=" . $_GET['r'] .
"&tema=" . $_GET['tema'] . "&otvet=".htmlspecialchars($_GET['otvet'])."&stra=2>2</a>|
<a href=88.php?go=forum&r=" . $_GET['r'] .
"&tema=" . $_GET['tema'] . "&otvet=".htmlspecialchars($_GET['otvet'])."&stra=3>3</a>|
<a href=88.php?go=forum&r=" . $_GET['r'] .
"&tema=" . $_GET['tema'] . "&otvet=".htmlspecialchars($_GET['otvet'])."&stra=4>4</a>|
";}else{
print "Смайлики:
<a href=88.php?go=forum&r=" . $_GET['r'] .
"&tema=" . $_GET['tema'] . "&stra=1>1</a>|
<a href=88.php?go=forum&r=" . $_GET['r'] .
"&tema=" . $_GET['tema'] . "&stra=2>2</a>|
<a href=88.php?go=forum&r=" . $_GET['r'] .
"&tema=" . $_GET['tema'] . "&stra=3>3</a>|
<a href=88.php?go=forum&r=" . $_GET['r'] .
"&tema=" . $_GET['tema'] . "&stra=4>4</a>| "
;}
print "<form action=88.php?go=forum&add=ok&r=" . $_GET['r'] . "&tema=" . $_GET['tema'] .
" name=forumot method=post>
Текст<textarea class=x_text name=log rows=3 cols=20>RE:" . $_GET['otvet'] . "</textarea>
<br>
<input type=submit class=select value=Отправить>
<li><a href=88.php?go=pessonag&row=" . $_GET['otvet'] .
">Инфо персонажа</a></li><li> <a href=88.php?go=post&pers=" . $_GET['otvet'] .
">Написать письмо</a></li><li>
<a href=88.php?go=forum&r=" . $_GET['r'] . "&tema=" . $_GET['tema'] .
">Назад</a></li><li>
<a href=88.php?go=forum&r=" . $_GET['r'] . ">К темам</a></li>
".d;
exitt($row, $opredelenie);
}
if ((isset($_GET['add'])) && $_GET['add'] == 'ok') {
///////////////////////////////////////////////////
///////////////////////////////////////////////////
@$_GET['otvet'] = htmlspecialchars(@$_GET['otvet']);
@$_GET['r'] = htmlspecialchars(@$_GET['r']);
@$_POST['log'] = htmlspecialchars(@$_POST['log']);
@$_GET['name'] = htmlspecialchars(@$_GET['name']);
@$_POST['name'] = htmlspecialchars(@$_POST['name']);
@$_GET['r'] = mysql_real_escape_string(@$_GET['r']);
@$_POST['log'] = mysql_real_escape_string(@$_POST['log']);
@$_GET['name'] = mysql_real_escape_string(@$_GET['name']);
@$_POST['name'] = mysql_real_escape_string(@$_POST['name']);
@$_GET['tema'] = mysql_real_escape_string(@$_GET['tema']);
$com=$_POST['log'];
$com = str_replace(":01_Smile1","<img src=smiles/01_Smile1.gif border=0>",$com);
$com = str_replace(":02_smile2","<img src=smiles/02_smile2.gif border=0>",$com);
$com = str_replace(":03_biggrin","<img src=smiles/03_biggrin.gif border=0>",$com);
$com = str_replace(":03_lol","<img src=smiles/03_lol.gif border=0>",$com);
$com = str_replace(":04_wink","<img src=smiles/04_wink.gif border=0>",$com);
$com = str_replace(":05_skeptik","<img src=smiles/05_skeptik.gif border=0>",$com);
$com = str_replace(":06_blink","<img src=smiles/06_blink.gif border=0>",$com);
$com = str_replace(":07_sad","<img src=smiles/07_sad.gif border=0>",$com);
$com = str_replace(":08_cool","<img src=smiles/08_cool.gif border=0>",$com);
$com = str_replace(":09_bebe","<img src=smiles/09_bebe.gif border=0>",$com);
$com = str_replace(":10_shok","<img src=smiles/10_shok.gif border=0>",$com);
$com = str_replace(":12_plaksa","<img src=smiles/12_plaksa.gif border=0>",$com);
$com = str_replace(":13_angry","<img src=smiles/13_angry.gif border=0>",$com);
$com = str_replace(":15_blush","<img src=smiles/15_blush.gif border=0>",$com);
$com = str_replace(":19_Privet","<img src=smiles/19_Privet.gif border=0>",$com);
$com = str_replace(":20_Poka","<img src=smiles/20_Poka.gif border=0>",$com);
$com = str_replace(":24_roza","<img src=smiles/24_roza.gif border=0>",$com);
$com = str_replace(":27_pivo","<img src=smiles/27_pivo.gif border=0>",$com);
$com = str_replace(":28_devil","<img src=smiles/28_devil.gif border=0>",$com);
$com = str_replace(":29_dash","<img src=smiles/29_dash.gif border=0>",$com);
$com = str_replace(":2pistoleta","<img src=smiles/2pistoleta.gif border=0>",$com);
$com = str_replace(":30_druzhba","<img src=smiles/30_druzhba.gif border=0>",$com);
$com = str_replace(":31_kur","<img src=smiles/31_kur.gif border=0>",$com);
$com = str_replace(":35_idiot","<img src=smiles/35_idiot.gif border=0>",$com);
$com = str_replace(":36_fingal","<img src=smiles/36_fingal.gif border=0>",$com);
$com = str_replace(":actoy","<img src=smiles/actoy.gif border=0>",$com);
$com = str_replace(":afiget","<img src=smiles/afiget.gif border=0>",$com);
$com = str_replace(":alkawi","<img src=smiles/alkawi.gif border=0>",$com);
$com = str_replace(":alkogolik","<img src=smiles/alkogolik.gif border=0>",$com);
$com = str_replace(":angel","<img src=smiles/angel.gif border=0>",$com);
$com = str_replace(":ban","<img src=smiles/ban.gif border=0>",$com);
$com = str_replace(":bis","<img src=smiles/bis.gif border=0>",$com);
$com = str_replace(":blabla","<img src=smiles/blabla.gif border=0>",$com);
$com = str_replace(":bolen","<img src=smiles/bolen.gif border=0>",$com);
$com = str_replace(":bomba","<img src=smiles/bomba.gif border=0>",$com);
$com = str_replace(":cenzura","<img src=smiles/cenzura.gif border=0>",$com);
$com = str_replace(":cherep","<img src=smiles/cherep.gif border=0>",$com);
$com = str_replace(":condom","<img src=smiles/condom.gif border=0>",$com);
$com = str_replace(":cool3","<img src=smiles/cool3.gif border=0>",$com);
$com = str_replace(":death","<img src=smiles/death.gif border=0>",$com);
$com = str_replace(":dozhd","<img src=smiles/dozhd.gif border=0>",$com);
$com = str_replace(":druzhba3","<img src=smiles/druzhba3.gif border=0>",$com);
$com = str_replace(":fan","<img src=smiles/fan.gif border=0>",$com);
$com = str_replace(":Faq","<img src=smiles/Faq.gif border=0>",$com);
$com = str_replace(":feministka","<img src=smiles/feministka.gif border=0>",$com);
$com = str_replace(":figa","<img src=smiles/figa.gif border=0>",$com);
$com = str_replace(":flag2","<img src=smiles/flag2.gif border=0>",$com);
$com = str_replace(":gadaet","<img src=smiles/gadaet.gif border=0>",$com);
$com = str_replace(":help","<img src=smiles/help.gif border=0>",$com);
$com = str_replace(":google","<img src=smiles/google.gif border=0>",$com);
$com = str_replace(":hi","<img src=smiles/hi.gif border=0>",$com);
$com = str_replace(":hrap","<img src=smiles/hrap.gif border=0>",$com);
$com = str_replace(":idea","<img src=smiles/idea.gif border=0>",$com);
$com = str_replace(":kiss4","<img src=smiles/kiss4.gif border=0>",$com);
$com = str_replace(":korol","<img src=smiles/korol.gif border=0>",$com);
$com = str_replace(":larisu","<img src=smiles/larisu.gif border=0>",$com);
$com = str_replace(":ment","<img src=smiles/ment.gif border=0>",$com);
$com = str_replace(":Moder1","<img src=smiles/Moder1.gif border=0>",$com);
$com = str_replace(":Moder2","<img src=smiles/Moder2.gif border=0>",$com);
$com = str_replace(":Moder3","<img src=smiles/Moder3.gif border=0>",$com);
$com = str_replace(":mog","<img src=smiles/mog.gif border=0>",$com);
$com = str_replace(":nakone","<img src=smiles/nakone.gif border=0>",$com);
$com = str_replace(":nedovolna","<img src=smiles/nedovolna.gif border=0>",$com);
$com = str_replace(":ninja","<img src=smiles/ninja.gif border=0>",$com);
$com = str_replace(":OOps","<img src=smiles/OOps.gif border=0>",$com);
$com = str_replace(":or","<img src=smiles/or.gif border=0>",$com);
$com = str_replace(":owibochka","<img src=smiles/owibochka.gif border=0>",$com);
$com = str_replace(":perv","<img src=smiles/perv.gif border=0>",$com);
$com = str_replace(":piosmok","<img src=smiles/piosmok.gif border=0>",$com);
$com = str_replace(":pirat","<img src=smiles/pirat.gif border=0>",$com);
$com = str_replace(":pivanet","<img src=smiles/pivanet.gif border=0>",$com);
$com = str_replace(":ploho2","<img src=smiles/ploho2.gif border=0>",$com);
$com = str_replace(":poka","<img src=smiles/poka.gif border=0>",$com);
$com = str_replace(":russoldat","<img src=smiles/russoldat.gif border=0>",$com);
$com = str_replace(":rzhu","<img src=smiles/rzhu.gif border=0>",$com);
$com = str_replace(":sestra","<img src=smiles/sestra.gif border=0>",$com);
$com = str_replace(":sex2","<img src=smiles/sex2.gif border=0>",$com);
$com = str_replace(":siski","<img src=smiles/siski.gif border=0>",$com);
$com = str_replace(":skosoj","<img src=smiles/skosoj.gif border=0>",$com);
$com = str_replace(":Sorry","<img src=smiles/Sorry.gif border=0>",$com);
$com = str_replace(":super","<img src=smiles/super.gif border=0>",$com);
$com = str_replace(":svadba","<img src=smiles/svadba.gif border=0>",$com);
$com = str_replace(":tanz","<img src=smiles/tanz.gif border=0>",$com);
$com = str_replace(":vilka_nozh","<img src=smiles/vilka_nozh.gif border=0>",$com);
$com = str_replace(":vopros","<img src=smiles/vopros.gif border=0>",$com);
$com = str_replace(":vsempr","<img src=smiles/vsempr.gif border=0>",$com);
$com = str_replace(":yahoo","<img src=smiles/yahoo.gif border=0>",$com);
$com = str_replace(":yy","<img src=smiles/yy.gif border=0>",$com);
$com = str_replace(":zona","<img src=smiles/zona.gif border=0>",$com);
$com = str_replace(":zub","<img src=smiles/zub.gif border=0>",$com);
$com = str_replace(":zuby","<img src=smiles/zuby.gif border=0>",$com);
$_POST['log']=$com;
$query7 = "SELECT *FROM `fraz` WHERE `id`=" . $_GET['tema'] . " AND `idfrk`='" .
$_GET['r'] . "'";
$sql7 = mysql_query($query7) or die(mysql_error());
$row7 = mysql_fetch_assoc($sql7);
if($row7['status']==1){print no."Тема закрыта".d;exitt($row,$opredelenie);}
$query9 = "SELECT * FROM `table1` WHERE `name`='" . mysql_real_escape_string($opredelenie) .
"'";
$sql9 = mysql_query($query9) or die(mysql_error());
$row9 = mysql_fetch_assoc($sql9);
if ($row9['lvl'] > 5) {
if($row['ban']==2){Print no."У вас бан на общение до ";
print date('j-n-Y G:i:s ', $row['time_ban']) ;echo d;exitt($row,$opredelenie) ;}
mysql_query("INSERT INTO `fsms` ( `id` , `text` , `name` , `time` , `tema` , `razdel` )
VALUES (
'', '" . $_POST['log'] . "', '$opredelenie', '" . time() . "', '" . $_GET['tema'] .
"', '" . $_GET['r'] . "'
);");
header("location:88.php?go=forum&r=" . $_GET['r'] . "&tema=" . $_GET['tema'] .
"");
$query7 = "SELECT *FROM `fraz` WHERE `id`=" . $_GET['tema'] . " AND `idfrk`='" .
$_GET['r'] . "'";
$sql7 = mysql_query($query7) or die(mysql_error());
$row7 = mysql_fetch_assoc($sql7);
$row7['kolsms']++;
mysql_query("UPDATE `fraz` SET `kolsms` = '" . $row7['kolsms'] . "',
`new` = '" . time() . "' WHERE `id` =" . $_GET['tema'] . " AND `idfrk`='" . $_GET['r'] .
"' LIMIT 1 ;");
} else {
print no."Вы не можете пока добавлять сообщения".d;
}
exi($row, $opredelenie);
;
}
if ((isset($_GET['addtem'])) && @$_GET['dob'] == 'ok') {
$post = htmlspecialchars($_POST['log']);
$post = mysql_real_escape_string($post);
$query9 = "SELECT * FROM `table1` WHERE `name`='" . mysql_real_escape_string($opredelenie) .
"'";
$sql9 = mysql_query($query9) or die(mysql_error());
$row9 = mysql_fetch_assoc($sql9);
if ($row9['lvl'] > 5) {
mysql_query("INSERT INTO `fraz` ( `id` , `idfrk` , `name` , `kolsms` , `new` )
VALUES ('', '" . $_GET['addtem'] . "', '$post', '0', '" . time() . "');");
$queryfrk = "SELECT * FROM `frk` WHERE `id` ='" . $_GET['addtem'] . "'";
$sqlfrk = mysql_query($queryfrk) or die(mysql_error());
$rowfrk = mysql_fetch_assoc($sqlfrk);
$rowfrk['koltem']++;
$rowfrk['kolsms']++;
mysql_query("UPDATE `frk` SET `koltem` = '" . $rowfrk['koltem'] . "',
`kolsms` = '" . $rowfrk['kolsms'] . "' WHERE `id` ='" . $_GET['addtem'] .
"' LIMIT 1 ;");
print y."Тема $log успешно создана".d;
} else {
print no."Вы не можете пока добавлять сообщения".d;
}
header("location:88.php?go=forum&r=" . $_GET['addtem'] . "");
exi($row, $opredelenie);
}
post($row, $opredelenie) ;
if ((isset($_GET['r'])) && (isset($_GET['tema']))) {
mysql_query("UPDATE `table1` SET `forumtime` = '" . time() . "'
WHERE `name`='$opredelenie' ") or die();
$query2 = "SELECT * FROM `frk` WHERE `id`=" . $_GET['r'] . " ";
$sql2 = mysql_query($query2) or die(mysql_error());
$row23r = mysql_fetch_assoc($sql2);
print ("");
print '<li>';
print $row23r['name'];
print ":</li> ";
$query2 = "SELECT * FROM `fraz` WHERE `id`=" . $_GET['tema'] . " ";
$sql2 = mysql_query($query2) or die(mysql_error());
$row2 = mysql_fetch_assoc($sql2);
print "<li>".$row2['name']."</li>";
$golos='';
if($row2['golos']==1){
$za=mysql_query("SELECT *
FROM `fraz_golos` where `da`='1'and `fraz`='". mysql_real_escape_string($_GET['tema'])."'");
$za=mysql_num_rows($za);
$net=mysql_query("SELECT *
FROM `fraz_golos` where `net`='1'and `fraz`='". mysql_real_escape_string($_GET['tema'])."'");
$net=mysql_num_rows($net);
print $golos="<li>-голосование [ <font color=green>$za</font> | <font color=red>$net</font> ]
</li>
<li><a href=88.php?go=forum&gol=da&r=" . $_GET['r'] .
"&tema=" . $_GET['tema'] . "><font color=green> [ЗА] </font></a>
___<a href=88.php?go=forum&gol=net&r=" . $_GET['r'] .
"&tema=" . $_GET['tema'] . "><font color=red> [ПРОТИВ] </font></a></li>";
if(isset($_GET['gol'])){
$prover=mysql_query("SELECT *
FROM `fraz_golos` where `name`='$opredelenie' and `fraz`='". mysql_real_escape_string($_GET['tema'])."'");
if(mysql_num_rows($prover)==0){
if($_GET['gol']=='da'){mysql_query("INSERT INTO `fraz_golos` ( `fraz` , `name` , `da` , `net` )
VALUES (
'".mysql_real_escape_string($_GET['tema'])."', '$opredelenie', '1', ''
);");}
if($_GET['gol']=='net'){mysql_query("INSERT INTO `fraz_golos` ( `fraz` , `name` , `da` , `net` )
VALUES (
'".mysql_real_escape_string($_GET['tema'])."', '$opredelenie', '', '1'
);");}
print y."Ваш голос принят!".d;
;}
else{print no.'Вы уже голосовали!'.d;}
;}
;}
print ("<br>");
$nums = 20;
if (isset($_GET['page'])) {
$page = intval($_GET['page']);
} else {
$page = 1;
}
$query = "SELECT COUNT(*) AS `counter` FROM `fsms` WHERE `tema`='" .
$_GET['tema'] . "' AND `razdel`='" . $_GET['r'] . "' ";
$sql = mysql_query($query) or die(mysql_error());
$row = mysql_fetch_assoc($sql);
$elements = $row['counter'];
$pages = ceil($elements / $nums);
if ($page < 1) {
$page = 1;
} elseif ($page > $pages) {
$page = $pages;
}
$start = ($page - 1) * $nums;
// когда у нас в таблице нет записей
if ($start < 0)
$start = 0;
$query = "SELECT * FROM `fsms` WHERE `tema`='" . $_GET['tema'] .
"' AND `razdel`='" . $_GET['r'] . "' ORDER BY `time` DESC LIMIT {$start}, {$nums}";
$sql = mysql_query($query) or die(mysql_error());
$query23 = "SELECT * FROM `table1` WHERE `name`='" . mysql_real_escape_string($opredelenie) .
"'";
$sql23 = mysql_query($query23) or die(mysql_error());
$row23 = mysql_fetch_assoc($sql23);
$num_rows1w = mysql_num_rows($sql);
echo cat;
while ($row = mysql_fetch_assoc($sql)) {
$query234 = "SELECT * FROM `table1` WHERE `name`='" . mysql_real_escape_string($row['name']) .
"'";
$sql234 = mysql_query($query234) or die(mysql_error());
$row234 = mysql_fetch_assoc($sql234);
if ($row234['polmmg'] == 'Мужской') {
$pasttt = time() - 300;
if ($row234['timme'] > $pasttt) {
$kartinka = 'man_on.gif';
} else {
$kartinka = 'man_off.gif';
;
}
;
}
if ($row234['polmmg'] == 'Женский') {
$pasttt = time() - 300;
if ($row234['timme'] > $pasttt) {
$kartinka = 'woman_on.gif';
} else {
$kartinka = 'woman_off.gif';
;
}
;
}
if (($row23['klan'] !== $row2['klan']) && ($row2['idfrk'] == 12) && ($row23['name']
!== 'Админ')) {
print no."Ошибка входа в тему".d;
exitt($row, $opredelenie);
}
;
if (($row23['klan'] !== 'Администрация') && $row23r['tip'] == 1) {
print no."Ошибка входа в тему".d;
exitt($row, $opredelenie);
;
}
$query5 = "SELECT * FROM `forum_time` WHERE `razdel`='" . $_GET['r'] .
"' and `tema`='" . $row['tema'] . "' and `name`='$opredelenie' ";
$sql5 = mysql_query($query5) or die(mysql_error());
$num_rows1 = mysql_num_rows($sql5);
$row5 = mysql_fetch_assoc($sql5);
if ($num_rows1 == 0) {
mysql_query(" INSERT INTO `forum_time` (
`razdel` ,`name` ,`tema` ,`kolsms`)
VALUES (
'" . $_GET['r'] . "', '$opredelenie', '" . $row['tema'] . "', '$num_rows1w'
);") or die(mysql_error());
} else {
mysql_query("UPDATE `forum_time` SET `kolsms`='$num_rows1w' WHERE `razdel` ='" .
$_GET['r'] . "' AND `name` = '$opredelenie' AND `tema` ='" . $_GET['tema'] .
"' LIMIT 1") or die(mysql_error());
}
$past = date("j.m.y G :i :s", $row['time']);
print '<li>
<img src="./media/images/ico/' . $kartinka . '" />
';
echo "<a href=88.php?go=forum&otvet=" . $row['name'] . "&r=" . $_GET['r'] .
"&tema=" . $_GET['tema'] . "><font color=green><b>" . $row['name'] .
"</b></font></a> <font color=blue>$past </font> <br>";
print $row['text'];
$query4 = "SELECT * FROM `table1` WHERE `name`='" . mysql_real_escape_string($opredelenie) .
"'";
$sql4 = mysql_query($query4) or die(mysql_error());
$row4 = mysql_fetch_assoc($sql4);
if ($row4['administracia'] > 2) {
print "<br>_______________<a href=88.php?go=forum&del=" . $row['id'] . "&r=" . $_GET['r'] .
"&tema=" . $_GET['tema'] . "><font color=red>[x]</font></a>
___<a href=88.php?go=forum&r=" . $_GET['r'] . "&tema=" . $_GET['tema'] .
"&editsms=" . $row['id'] . "><font color=red>[edit]</font></a>";
}
print ' </li>';
}
echo d."<li>";
$neighbours = 6;
$left_neighbour = $page - $neighbours;
if ($left_neighbour < 1)
$left_neighbour = 1;
$right_neighbour = $page + $neighbours;
if ($right_neighbour > $pages)
$right_neighbour = $pages;
if ($page > 1) {
print ' <a href="88.php?go=forum&r=' . $_GET['r'] . '&tema=' . $_GET['tema'] .
'&page=1">начало</a> ... <a href="88.php?go=forum&r=' . $_GET['r'] . '&tema=' .
$_GET['tema'] . '&page=' . ($page - 1) . '">←сюда</a> ';
}
for ($i = $left_neighbour; $i <= $right_neighbour; $i++) {
if ($i != $page) {
print ' <a href="88.php?go=forum&r=' . $_GET['r'] . '&tema=' . $_GET['tema'] .
'&page=' . $i . '">' . $i . '</a> ';
} else { // выбранная страница
print ' <b>' . $i . '</b> ';
}
}
if ($page < $pages) {
print ' <a href="88.php?go=forum&r=' . $_GET['r'] . '&tema=' . $_GET['tema'] .
'&page=' . ($page + 1) . '">туда→</a> ... <a href="88.php?go=forum&r=' . $_GET['r'] .
'&tema=' . $_GET['tema'] . '&page=' . $pages . '">конец</a> ';
;
}
;echo'</li>';
////////////////////////////////////////////////////////////////////////////////////////////////////////
?>
<script language="JavaScript">
function pi(str) {
tmp = parent.forums.log.value;
parent.forums.log.value = tmp + str;
}
</script>
<center>
<?php
echo cat;
if((isset($_GET['stra']))&&($_GET['stra']==1)){
?>
<A href="javascript:pi(' :01_Smile1 ')"><IMG src=smiles/01_Smile1.gif border=0></A>
<A href="javascript:pi(' :02_smile2 ')"><IMG src=smiles/02_smile2.gif border=0></A>
<A href="javascript:pi(' :03_biggrin ')"><IMG src=smiles/03_biggrin.gif border=0></A>
<A href="javascript:pi(' :03_lol ')"><IMG src=smiles/03_lol.gif border=0></A>
<A href="javascript:pi(' :04_wink ')"><IMG src=smiles/04_wink.gif border=0></A>
<A href="javascript:pi(' :05_skeptik ')"><IMG src=smiles/05_skeptik.gif border=0></A><br />
<A href="javascript:pi(' :06_blink ')"><IMG src=smiles/06_blink.gif border=0></A>
<A href="javascript:pi(' :07_sad ')"><IMG src=smiles/07_sad.gif border=0></A>
<A href="javascript:pi(' :08_cool ')"><IMG src=smiles/08_cool.gif border=0></A>
<A href="javascript:pi(' :09_bebe ')"><IMG src=smiles/09_bebe.gif border=0></A>
<A href="javascript:pi(' :10_shok ')"><IMG src=smiles/10_shok.gif border=0></A>
<A href="javascript:pi(' :12_plaksa ')"><IMG src=smiles/12_plaksa.gif border=0></A><br />
<A href="javascript:pi(' :13_angry ')"><IMG src=smiles/13_angry.gif border=0></A>
<A href="javascript:pi(' :15_blush ')"><IMG src=smiles/15_blush.gif border=0></A>
<A href="javascript:pi(' :19_Privet ')"><IMG src=smiles/19_Privet.gif border=0></A>
<A href="javascript:pi(' :20_Poka ')"><IMG src=smiles/20_Poka.gif border=0></A>
<A href="javascript:pi(' :24_roza ')"><IMG src=smiles/24_roza.gif border=0></A>
<A href="javascript:pi(' :27_pivo ')"><IMG src=smiles/27_pivo.gif border=0></A><br />
<A href="javascript:pi(' :28_devil ')"><IMG src=smiles/28_devil.gif border=0></A>
<A href="javascript:pi(' :29_dash ')"><IMG src=smiles/29_dash.gif border=0></A>
<A href="javascript:pi(' :2pistoleta ')"><IMG src=smiles/2pistoleta.gif border=0></A>
<A href="javascript:pi(' :30_druzhba ')"><IMG src=smiles/30_druzhba.gif border=0></A>
<A href="javascript:pi(' :31_kur ')"><IMG src=smiles/31_kur.gif border=0></A>
<A href="javascript:pi(' :35_idiot ')"><IMG src=smiles/35_idiot.gif border=0></A><br />
<?php
;}
if((isset($_GET['stra']))&&($_GET['stra']==2)){
?>
<A href="javascript:pi(' :36_fingal ')"><IMG src=smiles/36_fingal.gif border=0></A>
<A href="javascript:pi(' :actoy ')"><IMG src=smiles/actoy.gif border=0></A>
<A href="javascript:pi(' :afiget ')"><IMG src=smiles/afiget.gif border=0></A>
<A href="javascript:pi(' :alkawi ')"><IMG src=smiles/alkawi.gif border=0></A>
<A href="javascript:pi(' :alkogolik ')"><IMG src=smiles/alkogolik.gif border=0></A>
<A href="javascript:pi(' :angel ')"><IMG src=smiles/angel.gif border=0></A><br />
<A href="javascript:pi(' :ban ')"><IMG src=smiles/ban.gif border=0></A>
<A href="javascript:pi(' :bis ')"><IMG src=smiles/bis.gif border=0></A>
<A href="javascript:pi(' :blabla ')"><IMG src=smiles/blabla.gif border=0></A>
<A href="javascript:pi(' :bolen ')"><IMG src=smiles/bolen.gif border=0></A>
<A href="javascript:pi(' :bomba ')"><IMG src=smiles/bomba.gif border=0></A>
<A href="javascript:pi(' :cenzura ')"><IMG src=smiles/cenzura.gif border=0></A><br />
<A href="javascript:pi(' :cherep ')"><IMG src=smiles/cherep.gif border=0></A>
<A href="javascript:pi(' :condom ')"><IMG src=smiles/condom.gif border=0></A>
<A href="javascript:pi(' :cool3 ')"><IMG src=smiles/cool3.gif border=0></A>
<A href="javascript:pi(' :death ')"><IMG src=smiles/death.gif border=0></A>
<A href="javascript:pi(' :dozhd ')"><IMG src=smiles/dozhd.gif border=0></A>
<A href="javascript:pi(' :druzhba3 ')"><IMG src=smiles/druzhba3.gif border=0></A><br />
<A href="javascript:pi(' :fan ')"><IMG src=smiles/fan.gif border=0></A>
<A href="javascript:pi(' :Faq ')"><IMG src=smiles/Faq.gif border=0></A>
<A href="javascript:pi(' :feministka ')"><IMG src=smiles/feministka.gif border=0></A>
<A href="javascript:pi(' :figa ')"><IMG src=smiles/figa.gif border=0></A>
<A href="javascript:pi(' :flag2 ')"><IMG src=smiles/flag2.gif border=0></A>
<A href="javascript:pi(' :gadaet ')"><IMG src=smiles/gadaet.gif border=0></A><br />
<?php
;}
if((isset($_GET['stra']))&&($_GET['stra']==3)){
?>
<A href="javascript:pi(' :help ')"><IMG src=smiles/help.gif border=0></A>
<A href="javascript:pi(' :google ')"><IMG src=smiles/google.gif border=0></A>
<A href="javascript:pi(' :hi ')"><IMG src=smiles/hi.gif border=0></A>
<A href="javascript:pi(' :hrap ')"><IMG src=smiles/hrap.gif border=0></A>
<A href="javascript:pi(' :idea ')"><IMG src=smiles/idea.gif border=0></A>
<A href="javascript:pi(' :kiss4 ')"><IMG src=smiles/kiss4.gif border=0></A><br />
<A href="javascript:pi(' :korol ')"><IMG src=smiles/korol.gif border=0></A>
<A href="javascript:pi(' :larisu ')"><IMG src=smiles/larisu.gif border=0></A>
<A href="javascript:pi(' :ment ')"><IMG src=smiles/ment.gif border=0></A>
<A href="javascript:pi(' :Moder1 ')"><IMG src=smiles/Moder1.gif border=0></A>
<A href="javascript:pi(' :Moder2 ')"><IMG src=smiles/Moder2.gif border=0></A>
<A href="javascript:pi(' :Moder3 ')"><IMG src=smiles/Moder3.gif border=0></A><br />
<A href="javascript:pi(' :mog ')"><IMG src=smiles/mog.gif border=0></A>
<A href="javascript:pi(' :nakone ')"><IMG src=smiles/nakone.gif border=0></A>
<A href="javascript:pi(' :nedovolna ')"><IMG src=smiles/nedovolna.gif border=0></A>
<A href="javascript:pi(' :ninja ')"><IMG src=smiles/ninja.gif border=0></A>
<A href="javascript:pi(' :OOps ')"><IMG src=smiles/OOps.gif border=0></A>
<A href="javascript:pi(' :or ')"><IMG src=smiles/or.gif border=0></A><br />
<A href="javascript:pi(' :owibochka ')"><IMG src=smiles/owibochka.gif border=0></A>
<A href="javascript:pi(' :perv ')"><IMG src=smiles/perv.gif border=0></A>
<A href="javascript:pi(' :piosmok ')"><IMG src=smiles/piosmok.gif border=0></A>
<A href="javascript:pi(' :pirat ')"><IMG src=smiles/pirat.gif border=0></A>
<A href="javascript:pi(' :pivanet ')"><IMG src=smiles/pivanet.gif border=0></A>
<A href="javascript:pi(' :ploho2 ')"><IMG src=smiles/ploho2.gif border=0></A><br />
<?php
;}
if((isset($_GET['stra']))&&($_GET['stra']==4)){
?>
<A href="javascript:pi(' :poka ')"><IMG src=smiles/poka.gif border=0></A>
<A href="javascript:pi(' :russoldat ')"><IMG src=smiles/russoldat.gif border=0></A>
<A href="javascript:pi(' :rzhu ')"><IMG src=smiles/rzhu.gif border=0></A>
<A href="javascript:pi(' :sestra ')"><IMG src=smiles/sestra.gif border=0></A>
<A href="javascript:pi(' :sex2 ')"><IMG src=smiles/sex2.gif border=0></A>
<A href="javascript:pi(' :siski ')"><IMG src=smiles/siski.gif border=0></A><br />
<A href="javascript:pi(' :skosoj ')"><IMG src=smiles/skosoj.gif border=0></A>
<A href="javascript:pi(' :Sorry ')"><IMG src=smiles/Sorry.gif border=0></A>
<A href="javascript:pi(' :super ')"><IMG src=smiles/super.gif border=0></A>
<A href="javascript:pi(' :svadba ')"><IMG src=smiles/svadba.gif border=0></A>
<A href="javascript:pi(' :tanz ')"><IMG src=smiles/tanz.gif border=0></A>
<A href="javascript:pi(' :vilka_nozh ')"><IMG src=smiles/vilka_nozh.gif border=0></A><br />
<A href="javascript:pi(' :vopros ')"><IMG src=smiles/vopros.gif border=0></A>
<A href="javascript:pi(' :vsempr ')"><IMG src=smiles/vsempr.gif border=0></A>
<A href="javascript:pi(' :yahoo ')"><IMG src=smiles/yahoo.gif border=0></A>
<A href="javascript:pi(' :yy ')"><IMG src=smiles/yy.gif border=0></A>
<A href="javascript:pi(' :zona ')"><IMG src=smiles/zona.gif border=0></A>
<A href="javascript:pi(' :zub ')"><IMG src=smiles/zub.gif border=0></A><br />
<A href="javascript:pi(' :zuby ')"><IMG src=smiles/zuby.gif border=0></A>
</center>
<?
;}
if(isset($_GET['pers'])){
print "Смайлики:
<a href=88.php?go=forum&r=" . $_GET['r'] .
"&tema=" . $_GET['tema'] . "&pers=".htmlspecialchars($_GET['pers'])."&stra=1>1</a>|
<a href=88.php?go=forum&r=" . $_GET['r'] .
"&tema=" . $_GET['tema'] . "&pers=".htmlspecialchars($_GET['pers'])."&stra=2>2</a>|
<a href=88.php?go=forum&r=" . $_GET['r'] .
"&tema=" . $_GET['tema'] . "&pers=".htmlspecialchars($_GET['pers'])."&stra=3>3</a>|
<a href=88.php?go=forum&r=" . $_GET['r'] .
"&tema=" . $_GET['tema'] . "&pers=".htmlspecialchars($_GET['pers'])."&stra=4>4</a>|
";}else{
print "Смайлики:
<a href=88.php?go=forum&r=" . $_GET['r'] .
"&tema=" . $_GET['tema'] . "&stra=1>1</a>|
<a href=88.php?go=forum&r=" . $_GET['r'] .
"&tema=" . $_GET['tema'] . "&stra=2>2</a>|
<a href=88.php?go=forum&r=" . $_GET['r'] .
"&tema=" . $_GET['tema'] . "&stra=3>3</a>|
<a href=88.php?go=forum&r=" . $_GET['r'] .
"&tema=" . $_GET['tema'] . "&stra=4>4</a>| "
;}
///////////////////////////////////////
print "</table><br><form action=88.php?go=forum&add=ok&r=" . $_GET['r'] .
"&tema=" . $_GET['tema'] . " name=forums method=post>
Текст<textarea class=x_text name=log rows=3 cols=20></textarea><br>
<input type=submit class=x_sumbit value=Отправить>
<li><a href=88.php?go=forum&r=" . $_GET['r'] . "&tema=" . $_GET['tema'] .
"&stra=1>Смайлы</a></li><li><a href=88.php?go=forum&r=" . $_GET['r'] .
">К темам</a><br><a href=88.php?go=forum>Форум</a></li>
".d;
exitt($row, $opredelenie);
}
//////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
if (isset($_GET['r'])) {
$query2 = "SELECT * FROM `frk` WHERE `id`=" . $_GET['r'] . " ";
$sql2 = mysql_query($query2) or die(mysql_error());
$row2 = mysql_fetch_assoc($sql2);
print ("");
print '<li>';
print $row2['name'];
print ("</li>");
$nums = 20;
if (isset($_GET['page'])) {
$page = intval($_GET['page']);
} else {
$page = 1;
}
$query = "SELECT COUNT(*) AS `counter` FROM `fraz` WHERE `idfrk`=" .
$_GET['r'] . "";
$sql = mysql_query($query) or die(mysql_error());
$row = mysql_fetch_assoc($sql);
$elements = $row['counter'];
$pages = ceil($elements / $nums);
if ($page < 1) {
$page = 1;
} elseif ($page > $pages) {
$page = $pages;
}
$start = ($page - 1) * $nums;
// когда у нас в таблице нет записей
$po = 0;
if ($start < 0)
$start = 0;
$query = "SELECT * FROM `fraz` WHERE `idfrk`=" . $_GET['r'] .
" ORDER BY `new` DESC LIMIT {$start}, {$nums}";
$sql = mysql_query($query) or die(mysql_error());
print '<table width="100%" cellspacing=1 border=1>';
$query45w = "SELECT * FROM `table1` WHERE `name`='" . mysql_real_escape_string($opredelenie) .
"'";
$sql45w = mysql_query($query45w) or die(mysql_error());
$row45w = mysql_fetch_assoc($sql45w);
echo cat;
while ($row = mysql_fetch_assoc($sql)) {
$query9 = "SELECT * FROM `table1` WHERE `name`='" . mysql_real_escape_string($opredelenie) .
"'";
$sql9 = mysql_query($query9) or die(mysql_error());
$row9 = mysql_fetch_assoc($sql9);
$query00 = "SELECT * FROM `fsms` WHERE `tema`='" . $row['id'] .
"' AND `razdel`='" . $_GET['r'] . "' ";
$sql00 = mysql_query($query00) or die(mysql_error());
$num_rows = mysql_num_rows($sql00);
$query5 = "SELECT * FROM `forum_time` WHERE `razdel`='" . $_GET['r'] .
"' and `tema`='" . $row['id'] . "' and `name`='$opredelenie' ";
$sql5 = mysql_query($query5) or die(mysql_error());
$num_rows1 = mysql_num_rows($sql5);
$row5 = mysql_fetch_assoc($sql5);
///////////////////////////////////
$query00 = "SELECT * FROM `fsms` WHERE `tema`='" . $row['id'] .
"' AND `razdel`='" . $_GET['r'] . "'ORDER BY `time` DESC limit 1";
$sql00 = mysql_query($query00) or die(mysql_error());
$ros = mysql_fetch_array($sql00);
$past = date("j.m.y G :i :s", $ros['time']);
////////////////////////////
if ($num_rows1 == 1) {
$num_rows1 = $num_rows - $row5['kolsms'];
} else {
$num_rows1 = 0;
}
$golos='';
if($row['golos']==1){
$za=mysql_query("SELECT *
FROM `fraz_golos` where `da`='1' and `fraz`='". mysql_real_escape_string($row['id'])."'");
$za=mysql_num_rows($za);
$net=mysql_query("SELECT *
FROM `fraz_golos` where `net`='1' and `fraz`='". mysql_real_escape_string($row['id'])."'");
$net=mysql_num_rows($net);
$golos="-голосование [ <font color=green>$za</font> | <font color=red>$net</font> ]";}
print '<li>
<img src="./media/images/ico/stick.gif" >
';
echo "<a href=88.php?go=forum&r=" . $row['idfrk'] . "&tema=" . $row['id'] .
" ><font color=green> <b>" . $row['name'] . " </b> </font></a> ($num_rows1 /$num_rows) $golos<br>
" . $ros['name'] . "- $past
";
if($row['status']==1){print"<img src=./media/images/ico/topic_locked.gif>";}
if ($row45w['administracia'] > 2) {
print "<br>____________<a href=88.php?go=forum&r=" . $row['idfrk'] . "&tma=" . $row['id'] .
"&deltema>[Х]</a>___
<a href=88.php?go=forum&r=" . $row['idfrk'] . "&tma=" . $row['id'] .
"&perenesti>[-->]</a>___<a href=88.php?go=forum&r=" . $row['idfrk'] . "&tma=" .
$row['id'] . "&edit>[Edit]</a>
___<a href=88.php?go=forum&r=" . $row['idfrk'] . "&tma=" .
$row['id'] . "&golos>[golos]</a>___<a href=88.php?go=forum&r=" . $row['idfrk'] . "&tma=" .
$row['id'] . "&loc>[blok]</a>";
}
}
print ' </li>';
print '</table>';
$neighbours = 6;
$left_neighbour = $page - $neighbours;
if ($left_neighbour < 1)
$left_neighbour = 1;
$right_neighbour = $page + $neighbours;
if ($right_neighbour > $pages)
$right_neighbour = $pages;
if ($page > 1) {
print ' <a href="88.php?go=forum&r=' . $_GET['r'] .
'&page=1">начало</a> ... <a href="88.php?go=forum&r=' . $_GET['r'] . '&page=' . ($page -
1) . '">←сюда</a> ';
}
for ($i = $left_neighbour; $i <= $right_neighbour; $i++) {
if ($i != $page) {
print ' <a href="88.php?go=forum&page=' . $i . '">' . $i . '</a> ';
} else { // выбранная страница
print ' <b>' . $i . '</b> ';
}
}
if ($page < $pages) {
print ' <a href="88.php?go=forum&r=' . $_GET['r'] . '&page=' . ($page + 1) .
'">туда→</a> ... <a href="88.php?go=forum&r=' . $_GET['r'] . '&page=' . $pages .
'">конец</a> ';
;
}
;
$query = "SELECT * FROM `table1` WHERE `name`='" . mysql_real_escape_string($opredelenie) .
"'";
$sql = mysql_query($query) or die(mysql_error());
$row = mysql_fetch_assoc($sql);
if ($row['administracia'] > 2) {
print "<li><a href=88.php?go=forum&addtem=" . $_GET['r'] . ">Добавить тему</a></li>";
}
if (($_GET['r'] == 12) || ($_GET['r'] == 8)) {
;
} else {
print "<li><a href=88.php?go=forum&addtem=" . $_GET['r'] . ">Добавить тему</a></li>";
}
print "<li><a href=88.php?go=forum>в форум</a></li>";
exitt($row, $opredelenie);
}
//////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
////////////////////////////////////////////////////////разделы
print "";
//////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
if (isset($_GET['addtem'])) {
$razdel = $_GET['addtem'];
print "<body bgcolor=white text=black link=blue vlink=blue alink=blue>
Добавить тему
<form action=88.php?go=forum&addtem=$razdel&dob=ok method=post>
Название темы:<br><input class=x_textsmall type=text name=log>
<br><input type=submit class=x_sumbit value=Отправить>
";
exi($row, $opredelenie);
}
$nums = 20;
if (isset($_GET['page'])) {
$page = intval($_GET['page']);
} else {
$page = 1;
}
$query = "SELECT COUNT(*) AS `counter`
FROM `frk`";
$sql = mysql_query($query) or die(mysql_error());
$row = mysql_fetch_assoc($sql);
$elements = $row['counter'];
$pages = ceil($elements / $nums);
if ($page < 1) {
$page = 1;
} elseif ($page > $pages) {
$page = $pages;
}
$start = ($page - 1) * $nums;
$queryh = "SELECT * FROM `table1` WHERE `name`='" . mysql_real_escape_string($opredelenie) .
"'";
$sqlh = mysql_query($queryh) or die(mysql_error());
$rowh = mysql_fetch_assoc($sqlh);
// когда у нас в таблице нет записей
if ($start < 0)
$start = 0;
$query = "SELECT *
FROM `frk`
LIMIT {$start}, {$nums}";
$sql = mysql_query($query) or die(mysql_error());
while ($row = mysql_fetch_assoc($sql)) {
$rsql = mysql_query("SELECT *
FROM `fraz` where `idfrk`='" . $row['id'] . "'
ORDER BY `new` DESC
LIMIT 1");
$rsql1 = mysql_query("SELECT *
FROM `fraz` where `idfrk`='" . $row['id'] . "'
");
$rf = mysql_num_rows($rsql1);
$rrow = mysql_fetch_assoc($rsql);
if ($row['tip'] == 0) {
print '<div style="margin: 0 auto; width:auto; color:#000000;">
<div class="block">
<ul class="conf">
<img src="./media/images/ico/ads_icon.gif" />
';
echo "<a href=88.php?go=forum&r=" . $row['id'] . " ><font color=green> <b>" . $row['name'] .
" [$rf]</b> </font></a>
<br><a href=88.php?go=forum&r=" . $row['id'] . "&tema=" . $rrow['id'] . ">" . $rrow['name'] .
"</a>";
print ' </ul></div>
</div>';
}
if ($row['tip'] == 1) {
if ($rowh['klan'] == 'Администрация') {
print '<div style="margin: 0 auto; width:auto; color:#000000;">
<div class="block">
<ul class="conf">
<img src="./media/images/ico/ads_icon.gif" />
';
echo "<a href=88.php?go=forum&r=" . $row['id'] . " ><font color=green> <b>" . $row['name'] .
" [$rf]</b> </font></a>
<br><a href=88.php?go=forum&r=" . $row['id'] . "&tema=" . $rrow['id'] . ">" . $rrow['name'] .
"</a>";
print ' </ul></div>
</div>';
}
}
}
// далее нам надо прицепить листалку
$neighbours = 6;
$left_neighbour = $page - $neighbours;
if ($left_neighbour < 1)
$left_neighbour = 1;
$right_neighbour = $page + $neighbours;
if ($right_neighbour > $pages)
$right_neighbour = $pages;
if ($page > 1) {
print ' <a href="?page=1">начало</a> ... <a href="88.php?go=forum&page=' . ($page -
1) . '">←сюда</a> ';
}
for ($i = $left_neighbour; $i <= $right_neighbour; $i++) {
if ($i != $page) {
print ' <a href="88.php?go=forum&page=' . $i . '">' . $i . '</a> ';
} else {
// выбранная страница
print ' <b>' . $i . '</b> ';
}
}
if ($page < $pages) {
print ' <a href="88.php?go=forum&page=' . ($page + 1) .
'">туда→</a> ... <a href="88.php?go=forum&page=' . $pages . '">конец</a> ';
}
print "<b><a href=88.php?go=do>в игру</a>";
//////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
?>