Файл: dop/forum.php
Строк: 209
<?php
/**
* @author wistis
* @copyright 2011
*/
print '<style>
.block {
background: #c7c7c7;
border: 2px solid #BEBEBE;
margin: 2px 4px;
padding: 1px 3px;
text-align: left;
}
.block1 {
background:#3393ff;
border: 2px solid #BEBEBE;
margin: 2px 4px;
padding: 1px 3px;
text-align: left;
}
/*QUICKLINKS conf*/
ul.conf {list-style: none; padding:5; margin: 0; }
ul.conf li { background: none; padding: 2; margin: 0; }
ul.conf li a {
font-size:12px;
display: block;
line-height: 15px;
}
ul.conf li a img { float: left; margin-right: 5px; margin-top: 0px; }
</style>';
// показываем защищенные от гостей данные.
if ((isset($_GET['r'])) && (!is_numeric($_GET['r']))) {
print "неверно";
exi($row, $opredelenie);
}
if ((isset($_GET['tema'])) && (!is_numeric($_GET['tema']))) {
print "неверно";
exi($row, $opredelenie);
}
print "<h1>Форум</h1><hr>";
if ((isset($_GET['r'])) && (isset($_GET['tema']))) {
$query2 = "SELECT * FROM `frk` WHERE `id`=" . $_GET['r'] . " ";
$sql2 = mysql_query($query2) or die(mysql_error());
$row23r = mysql_fetch_assoc($sql2);
print ("");
print '<div class="block1">';
print $row23r['name'];
print ": ";
$query2 = "SELECT * FROM `fraz` WHERE `id`=" . $_GET['tema'] . " ";
$sql2 = mysql_query($query2) or die(mysql_error());
$row2 = mysql_fetch_assoc($sql2);
print $row2['name'];
$golos='';
;
print '</div>';
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());
$num_rows1w = mysql_num_rows($sql);
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';
;
}
;
}
$past = date("j.m.y G :i :s", $row['time']);
print '<div style="margin: 0 auto; width:auto; color:#000000;">
<div class="block">
<ul class="conf">
<img src="./media/images/ico/' . $kartinka . '" />
';
echo "<a href=index.php?id=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'];
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="index.php?id&r=' . $_GET['r'] . '&tema=' . $_GET['tema'] .
'&page=1">начало</a> ... <a href="index.php?id&r=' . $_GET['r'] . '&tema=' .
$_GET['tema'] . '&page=' . ($page - 1) . '">←сюда</a> ';
}
for ($i = $left_neighbour; $i <= $right_neighbour; $i++) {
if ($i != $page) {
print ' <a href="index.php?id&r=' . $_GET['r'] . '&tema=' . $_GET['tema'] .
'&page=' . $i . '">' . $i . '</a> ';
} else { // выбранная страница
print ' <b>' . $i . '</b> ';
}
}
if ($page < $pages) {
print ' <a href="index.php?id=forum&r=' . $_GET['r'] . '&tema=' . $_GET['tema'] .
'&page=' . ($page + 1) . '">туда→</a> ... <a href="index.php?id=forum&r=' . $_GET['r'] .
'&tema=' . $_GET['tema'] . '&page=' . $pages . '">конец</a> ';
;
}
;
////////////////////////////////////////////////////////////////////////////////////////////////////////
print'<br><a href=index.php?id=forum>Форум</a><br>';
print "<b><a href=index.php>На главную</a>";
//////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
exit;;}
////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
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 '<div class="block1">';
print $row2['name'];
print ("</div><br>");
$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>';
while ($row = mysql_fetch_assoc($sql)) {
$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);
///////////////////////////////////
$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']);
////////////////////////////
$golos='';
print '<div style="margin: 0 auto; width:auto; color:#000000;">
<div class="block">
<ul class="conf">
<img src="./media/images/ico/stick.gif" >
';
echo "<a href=index.php?id=forum&r=" . $row['idfrk'] . "&tema=" . $row['id'] .
" ><font color=green> <b>" . $row['name'] . " </b> </font></a> <br>
" . $ros['name'] . "- $past
";
if($row['status']==1){print"<img src=./media/images/ico/topic_locked.gif>";}
print ' </ul></div>
</div>';
}
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="index.php?id=forum&r=' . $_GET['r'] .
'&page=1">начало</a> ... <a href="index.php?id=forum&r=' . $_GET['r'] . '&page=' . ($page -
1) . '">←сюда</a> ';
}
for ($i = $left_neighbour; $i <= $right_neighbour; $i++) {
if ($i != $page) {
print ' <a href="index.php?id=forum&page=' . $i . '">' . $i . '</a> ';
} else { // выбранная страница
print ' <b>' . $i . '</b> ';
}
}
if ($page < $pages) {
print ' <a href="index.php?id=forum&r=' . $_GET['r'] . '&page=' . ($page + 1) .
'">туда→</a> ... <a href="index.php?id=forum&r=' . $_GET['r'] . '&page=' . $pages .
'">конец</a> ';
;
}
;
if (($_GET['r'] == 12) || ($_GET['r'] == 8)) {
;
} else {
}
print'<br><a href=index.php?id=forum>Форум</a><br>';
print "<b><a href=index.php>На главную</a>";
exit;
}
//////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
////////////////////////////////////////////////////////разделы
$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;
// когда у нас в таблице нет записей
if ($start < 0)
$start = 0;
$query = "SELECT *
FROM `frk`where id!=6 and id!=12 and id!=3
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=index.php?id=forum&r=" . $row['id'] . " ><font color=green> <b>" . $row['name'] .
" [$rf]</b> </font></a>
<br><a href=index.php?id=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="index.php?id=forum&page=' . ($page -
1) . '">←сюда</a> ';
}
for ($i = $left_neighbour; $i <= $right_neighbour; $i++) {
if ($i != $page) {
print ' <a href="index.php?id=forum&page=' . $i . '">' . $i . '</a> ';
} else {
// выбранная страница
print ' <b>' . $i . '</b> ';
}
}
if ($page < $pages) {
print ' <a href="index.php?id=forum&page=' . ($page + 1) .
'">туда→</a> ... <a href="index.php?id=forum&page=' . $pages . '">конец</a> ';
}
print'<br><a href=index.php?id=forum>Форум</a><br>';
print "<b><a href=index.php>На главную</a>";
//////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
?>