if (!$threadid) { header("Location: index.php"); exit; }
if (!$HTTP_COOKIE_VARS["name"]) { $notlogged='
You\'re currently not logged. Please log in now so that you can post. Unregister users can only browse through the forum...'; }
if (!$HTTP_COOKIE_VARS["T$threadid"]) { $setacookie=1; setcookie("T$threadid", '1'); }
if (!$page) { $page=1; }
$start=($page-1)*20;
$db = mysql_connect ("localhost", "user", "pass") or die ("Could not connect to mysql!");
$bd = mysql_select_db("baza",$db) or die ("Could not select database!");
######## ako thread postoji vidi koji je forum i koliko ima stranica, a ako ne - izadji ########
$result = mysql_query("SELECT posts,forumid FROM forum_thread WHERE threadid='$threadid'",$db) or die ("Invalid query!");
$row = mysql_fetch_array($result);
if (!$row) {
echo "The specified thread doesn't exist. If you've followed a link from our site, please notify us!"; exit;
} else {
$forumid=$row[forumid];
$ukupno=floor(($row['posts']-1)/20)+1;
}
######## ucitavaj redom postove ######
$result = mysql_query("SELECT * FROM forum_post,users WHERE forum_post.threadid='$row[threadid]' AND users.userid=forum_post.userid ORDER BY forum_post.postid ASC",$db) or die ("Invalid query!");
while ($row = mysql_fetch_array($result)) {
if (eregi("\[quote",$row[text])) {
$row[text]=preg_replace("/\[quote=\"(.*)\"\]/","
\\1: ",$row[text]);
$row[text]=str_replace('[/quote]', '
', $row[text]);
}
if ($row[avatar]) { $avatar="
"; } else { $avatar=''; }
echo "$row[name] $row[usertit] $avatar | ";
echo '';
echo "posted on: " . date("D, M d Y, h:i a",$row[vreme]) . " | quote | delete | edit | ";
echo "$row[text] |
";
}
######## ovde povecava broj pregleda (promenio sam views u vws jer sam pomislio da je mozda views neka rezervisana rec u Mysql ###########
if ($setacookie) {
mysql_query("UPDATE forum_thread SET vws = vws + 1 WHERE threadid='$threadid'",$db) or die ("Invalid query!");
}
mysql_close($db);
######## navigacija ########
$frpage=$page-8; if ($frpage<2) { $frpage=1; } else { $lstring="first page ... "; }
$lspage=$page+8; if ($lspage>=$ukupno) { $lspage=$ukupno; } else { $rstring=" ... last page"; }
$display='';
for ($i=$frpage; $i<=$lspage; $i++) {
$display.=" ";
}
$display=ereg_replace("","$page",$display);
echo "|