|
|
|
Thread
|
Author
|
Replies
|
Viewed
|
Last Date Posted
|
$prune ORDER BY lastpost DESC LIMIT $limitlower,$perpage";
$query = mysql_db_query($database, $sql) or die(geterrdesc($sql));
if (mysql_num_rows($query) <= 0) {
print("| No posts made in the last $prunedays days. | \n");
} else {
while ($thread = mysql_fetch_array($query)) {
$multipage = "";
$threadtitle = htmlspecialchars($thread[title]);
$threadtitle = stripslashes($threadtitle);
$TID = $thread[TID];
$sql = "SELECT username FROM post WHERE TID='$thread[TID]' ORDER BY dateline DESC LIMIT 0, 1";
$last = mysql_db_query($database, $sql) or die(geterrdesc($sql));
$lastposted = mysql_fetch_array($last);
$lastpostedby = $lastposted[username];
if (($thread[icon] == "none") or ($thread[icon] == "")) {
$icon = "";
} else {
$icon = "![](\"images/icons/$thread[icon]\") ";
}
$replies = $thread[replycount];
$viewed_num = $thread[viewed_num];
$firstposter = htmlspecialchars($thread[postusername]);
$lastreplydate = date("F d, Y",$thread[lastpost]+($timeoffset*3600));
$lastreplytime = date("h:i A",$thread[lastpost]+($timeoffset*3600));
if ($thread[rating] == 1) { $rating = "![\"This](\"images/stars/1star.gif\") "; }
elseif ($thread[rating] == 2) { $rating = "![\"This](\"images/stars/2stars.gif\") "; }
elseif ($thread[rating] == 3) { $rating = "![\"This](\"images/stars/3stars.gif\") "; }
elseif ($thread[rating] == 4) { $rating = "![\"This](\"images/stars/4stars.gif\") "; }
elseif ($thread[rating] == 5) { $rating = "![\"This](\"images/stars/5stars.gif\") "; }
else { $rating = ""; }
$newoldhot="folder";
if ($thread[replycount] > $hottopic) {
$newoldhot="hot".$newoldhot;
$multipage = multipage($thread[replycount],$thread[TID],$FID);
}
if ($thread[thread_lock] == 1) {
$newoldhot="lock".$newoldhot;
}
if ($lastvisitdate == "Never") {
$newoldhot="new".$newoldhot;
} elseif ($lastvisit < $thread[lastpost]) {
$newoldhot="new".$newoldhot;
} else { }
$ratesystemcol = "";
if ($info[rate] == "1") {
$ratesystemcol = " $rating | ";
}
$forumdisplay_threads = "
![](\"images/$newoldhot.gif\") |
$icon |
$threadtitle $multipage |
$firstposter |
$replies |
$viewed_num |
$ratesystemcol
$lastreplydate $lastreplytime $lang[lastpost] $lastpostedby |
";
echo "$forumdisplay_threads";
}
}
//FWD Back
$sql = "SELECT COUNT(FID) FROM thread WHERE FID=$FID AND lastpost > '$prune'";
$query = mysql_db_query($database, $sql) or die(geterrdesc($sql));
$count = mysql_result($query,0);
$pages = $count / $perpage;
$pages = ceil($pages);
if ($pages >= $pagenumber)
{
for ($i = 1; $i <= $pages; $i++) {
if ($i == $pagenumber) {
$fwd_back .= " $i ";
} else {
$fwd_back .= " $i
";
}
}
}
$pages = "Pages: $fwd_back";
$jump = jump_to();
echo "|
|
|
![\"Post](\"images/new_poll2.gif\")
![](\"images/multipage.gif\")
Pages: $fwd_back)";
return $pages;
}
if ($FID == "") {
echo "No board defined!";
exit;
}
cookie($lastactive, $lastvisit, $cookiepath);
check_session($username, "Forums", "forumdisplay.php3?FID=$FID&usenet=$usenet", getenv(REMOTE_ADDR));
if (isset($perpage)==0 or $perpage==0) {
$perpage=$topicsper;
}
if (isset($pagenumber)==0 or $pagenumber==0) {
$pagenumber=1;
}
if (isset($userdaysprune) && $userdaysprune > 0){
$prunedays = $userdaysprune;
} else {
$prunedays = $daysprune;
}
$prune = time()-$prunedays*86400;
$limitlower=($pagenumber-1)*$perpage;
$sql = "SELECT title,description,category,active,private,rate,poll,PASSPROTECT,PASSWORD FROM forum WHERE FID=$FID";
$query = mysql_db_query($database, $sql) or die(geterrdesc($sql));
$info = mysql_fetch_array($query);
$forum_name = stripslashes(htmlspecialchars($info[title]));
if ($info[active]==0) {
echo "$forum_name is inactive, please visit another board!";
exit;
}
$notify = "$lang[not_loggedin]";
if ($username != "") {
$notify = "$lang[loggedin]";
}
$sql = "SELECT status FROM members WHERE username='$username'";
$member_query = mysql_db_query($database, $sql) or die(geterrdesc($sql));
$memberinfo = mysql_fetch_array($member_query);
$status = $memberinfo[status];
//Private Forums code begins
if ($info[private] == "0")
{
$view = "true";
}
if ($info[private] == "3")
{
$view = "true";
}
if ($info[private] == "4")
{
$view = "true";
}
if ($info[private] == "1")
{
if ($status == "Administrator")
{
$view = "true";
} else {
$denied = "This forum is private, and you are not allowed here. Sorry!";
}
}
if ($info[private] == "2")
{
if ($status == "Administrator" || $status == "Moderator")
{
$view = "true";
} else {
$denied = "This forum is private, and you are not allowed here. Sorry!";
}
}
if ($info[rate] == "0")
{
$ratesystemtop = "";
} else {
$ratesystemtop = "![\"Post](\"images/new_poll.jpg\")
";
}
if ($info[private] == "5")
{
$sql = "SELECT * FROM forumprivate WHERE username='$username' AND FID='$FID'";
$query = mysql_query($sql) or die(geterrdesc($sql));
$private = mysql_fetch_array($query);
if ($status == "Administrator" || $status == "Moderator" || $private[FID] == "$FID")
{
$view = "true";
} else {
$denied = "This forum is private. Please make sure you are logged in before trying to access it again.";
}
}
if ($info[PASSPROTECT] == "1"){
if($HTTP_COOKIE_VARS["F$FID"] == $info[PASSWORD]){
$view = "true";
} else {
$view = "false";
$IFORM = "";
$denied = "This forum is private, a password is required to access it.![](\"images/arrow.gif\"){kind=icon}
";
}
if ($onoff == "on") {
$newpost = "![\"New](\"images/on.gif\")
";
} else {
$newpost = "![\"No](\"images/off.gif\")
";
}
$sql = "SELECT * FROM moderator WHERE FID=$forum[FID]";
$query_moderator = mysql_db_query("$database", $sql) or die(geterrdesc($sql));
$moderator = "";
while ($moderator_info = mysql_fetch_array($query_moderator))
{
$moderator .= "$moderator_info[moderator] ";
}
$forumdisplay_forums = "![\"Post](\"images/new_topic2.gif\")
![\"New](\"images/newfolder.gif\")
![\"No](\"images/folder.gif\")
$lang[opentopic]
(![\"New](\"images/newhotfolder.gif\")
![\"Hot](\"images/hotfolder.gif\")
$lang[hottopic]
).![\"Closed](\"images/newlockfolder.gif\")
![\"Closed](\"images/lockfolder.gif\")
$lang[closedtopic] (![\"New](\"images/lockhotfolder.gif\")
![\"Hot](\"images/newlockhotfolder.gif\")
$lang[hottopic]).