Ако линка ми е;
Ми излиза грешка:
Помогнете , защото вече превъртях..
Код:
forum/index.php?act=viewforum&id='Ми излиза грешка:
Помогнете , защото вече превъртях..
Код:
<?php
echo '<div class="gzaglavie-forum"> Преглед на тема</div>
<div class="gkutiika-forum"><br />';
$id = trim(strip_tags(addslashes($_GET['id'])));
if(!$id) {
echo "Изберете тема!";
}
else if(is_numeric($id) ){
$broinastranica = 7;
$pageNum = 1;
if(isset($_GET['page'])){
$pageNum = trim(strip_tags(addslashes($_GET['page'])));
}
$redove = ($pageNum - 1) * $broinastranica;
$sql1 = "SELECT * FROM forum_posts WHERE topic='$id' ORDER BY postid ASC LIMIT $redove, $broinastranica";
$res1 = mysql_query($sql1) or die (mysql_error());
$sql4o = mysql_query("SELECT * FROM forum_topics WHERE topicid='$id'") or die (mysql_error());
$row = mysql_fetch_array($sql4o);
$name = $row['name'];
$avtor_na_temata = $row['author'];
$bonus = $row['bonus'];
$sql4ozz = mysql_query("SELECT * FROM `users` WHERE username='$avtor_na_temata'") or die (mysql_error());
$rowxz = mysql_fetch_array($sql4ozz);
$idito = $rowxz['id'];
$sql4o2 = "SELECT * FROM `forum_forums` WHERE forum_id='$row[forum_id]'";
$result4e2 = mysql_query($sql4o2);
$rowz = mysql_fetch_array($result4e2);
$forum_name = $rowz['forum_name'];
echo "<a href='index.php'><strong>VB-Sbornik - Форуми</strong></a> -> <strong><a href='index.php?act=viewforum&id=$row[forum_id]'>$forum_name</a> -> <strong><a href='index.php?act=viewtopic&id=$id'>$name</a></strong>\n";
echo "
<table>
<tr>
<td valign=\"top\" align=\"left\" width=\"710px\">";
if ($username) {
if ($row['vajna'] != 2) {
echo "<a href='?act=newtopic&mode=reply&t=$id' style='margin-left: 4px;'><img src='images/forum/newanswer.png' alt='Нов отговор' /></a>\n";
}
else {
echo "<img src='images/forum/locktopic.png' alt='Заключена тема' />\n";
}}
echo "</td>";
$query = "SELECT COUNT(postid) AS numrows FROM forum_posts WHERE topic = '$id'";
$result = mysql_query($query) or die(mysql_error());
$row = mysql_fetch_array($result, MYSQL_ASSOC);
$numrows = $row['numrows'];
$maxPage = ceil($numrows/$broinastranica);
$self = $_SERVER['PHP_SELF'];
$nomeranastranici = '';
for($page = 1; $page <= $maxPage; $page++){
if ($page == $pageNum){
$nomeranastranici .= " $page ";
}
else{
$nomeranastranici .= " <a href=\"?act=viewtopic&id=$id&page=$page\">$page</a> ";
}}
if ($pageNum > 1){
$page = $pageNum - 1;
$predishna = " <a href=\"?act=viewtopic&id=$id&page=$page\"> [<<<<<] </a> ";
$parva = " <a href=\"?act=viewtopic&id=$id&page=1\">1</a> ";
}
else{
$predishna = ' ';
$parva = ' ';
}
if ($pageNum < $maxPage){
$page = $pageNum + 1;
$sledvashta = " <a href=\"?act=viewtopic&id=$id&page=$page\"> [>>>>>] </a> ";
$posledna = " <a href=\"?act=viewtopic&id=$id&page=$maxPage\">$maxpage</a> ";
}
else {
$sledvashta = ' ';
$posledna = ' ';
}
echo "<td>";
echo "Страници: ".$parva . $predishna . $nomeranastranici . $sledvashta . $posledna;
echo "</td>
</tr>
</table>
<table>";
while($row = mysql_fetch_array($res1)) {
$sql = mysql_query("SELECT * FROM `forum_posts` WHERE author = '$row[author]'") or die (mysql_error());
$postove = mysql_num_rows($sql);
$a_vtor = $row[author];
$sql4e = mysql_query("SELECT * FROM `users` WHERE username='$a_vtor'") or die (mysql_error());
$user = mysql_fetch_array($sql4e);
$aid = $user['id'];
$ranka = $user['rank'];
$tochki = $user['tochki'];
$bonusi = $user['bonusi'];
$date = $user['date'];
$rank = $_SESSION['rank'];
if ($ranka == 1) {
$ranka = "Потребител";
}
elseif ($ranka == 2) {
$ranka = "Модератор";
}
elseif ($ranka == 3) {
$ranka = "Администратор";
}
echo "<tr>
<td class='forum-td' align='center' width='150' valign='top'>
<a href='../index.php?act=viewprofile&id=$aid'>$row[author]</a>
<br />
$ranka<br />
<img src='../$user[avatar]' alt='$user[username]' /><br /><br />
<div align='left' class='postdetails'>
Регистриран на: $date";
if ($bonus != 1) {
$tema_id = $_GET['id'];
if ($avtor_na_temata == $username and $user['username'] != $username){
echo "<br /><br /><a href='index.php?act=viewtopic&id=$tema_id&blagodaria=$aid'><font color='red'><b><u><font size='1px'>Благодари на $user[username]<br> като му дадеш 1 точка!</font></u></b></font></a>";
}
else {}
}
echo "<br /><br />
Support: <b>$tochki</b><br />
Bonus: <b>$bonusi</b><br />
Мнения: <b>$postove</b><br /><br /><br /><br />
</div>
</td>
<td class='forum-td' valign='top'>
<div style='background: #dadada; width: 630px; height: 20px;' align='left'>
<span class=\"postdetails\">$row[date]</span>
";
if (($row['author'] == $username) or $rank > 1) {
echo "
<a href='?act=newtopic&mode=edit&post=$row[postid]'><img src='images/forum/editpost.png' alt='Редактирай' /></a>";
}
if ($username) {
$t = $_GET['id'];
$sql2 = mysql_query("SELECT * FROM forum_topics WHERE topicid = '$t'") or die (mysql_error());
$row2 = mysql_fetch_array($sql2);
if ($row2['vajna'] != 2) {
echo " <a href='?act=newtopic&mode=quote&post=$row[postid]&t=$id'><img src='images/forum/quote.png' alt='Цитирай' /></a>";
}}
$post = nl2br($row['post']);
echo "</div>
$post</td>
</tr>";
$profile = "<a href='../index.php?act=viewprofile&id=$user[id]'><img src='images/forum/profile.png' alt='$user[username]' /></a>";
$email = "<a href='mailto:$user[email]'><img src='images/forum/email.png' alt='$user[username]' /></a>";
if (strlen($user[site]) > 7) {
$site = "<a href='$user[site]'><img src='images/forum/site.png' alt='$user[username]' /></a>";
}
else {
$site = "";
}
echo "<tr><td class='forum-td' align='center' valign='top'><a href='#'>Върни се в началото</a></td>
<td class='forum-td'>$profile $email $site</td></tr>\n";
}
echo "</table>";
if ($username) {
if ($row['vajna'] != 2) {
echo "<a href='?act=post&mode=reply&t=$id' style='margin-left: 4px;'><img src='images/forum/newanswer.png' alt='Нов отговор' /></a><br />\n";
}
else {
echo "<img src='images/forum/locktopic.png' alt='Заключена тема' /><br />\n";
}}
$query = mysql_query("SELECT COUNT(postid) AS numrows FROM `forum_posts` WHERE topic = '$id'") or die(mysql_error());
$row = mysql_fetch_array($query, MYSQL_ASSOC);
$numrows = $row['numrows'];
$maxPage = ceil($numrows/$broinastranica);
$self = $_SERVER['PHP_SELF'];
$nomeranastranici = '';
for($page = 1; $page <= $maxPage; $page++){
if ($page == $pageNum){
$nomeranastranici .= " $page ";
}
else{
$nomeranastranici .= " <a href=\"?act=viewtopic&id=$id&page=$page\">$page</a> ";
}}
if ($pageNum > 1){
$page = $pageNum - 1;
$predishna = " <a href=\"?act=viewtopic&id=$id&page=$page\"> [<<<<<] </a> ";
$parva = " <a href=\"?act=viewtopic&id=$id&page=1\">[първа]</a> ";
}
else{
$predishna = ' ';
$parva = ' ';
}
if ($pageNum < $maxPage){
$page = $pageNum + 1;
$sledvashta = " <a href=\"?act=viewtopic&id=$id&page=$page\"> [>>>>>] </a> ";
$posledna = " <a href=\"?act=viewtopic&id=$id&page=$maxPage\">[последна]</a> ";
}
else{
$sledvashta = ' ';
$posledna = ' ';
}
echo "<table>
<tr>
<td valign=\"top\" align=\"left\" width=\"530px\">";
echo "Страници: ".$parva . $predishna . $nomeranastranici . $sledvashta . $posledna;
echo "</td>";
if (!$_SESSION['username']) {
echo "
<td>
<b>Не Можете</b> да пускате нови теми<br />
<b>Не Можете</b> да отговаряте на темите<br />
<b>Не Можете</b> да променяте съобщенията си<br />
<b>Не Можете</b> да изтривате съобщенията си<br />";
}
else {
echo "<td valign=\"top\" align=\"right\">
<b>Можете да</b> пускате нови теми<br />
<b>Можете да</b> отговаряте на темите<br />
<b>Можете да</b> променяте съобщенията си<br />
<b>Можете да</b> изтривате съобщенията си<br />";
}
echo "</td></tr></table>";}
else {
echo "Темата която търсите не съществува.";
}
echo '</div></div>';
?>
Благодаря на всички!