| |
Forum |
Topics |
Posts |
Last Post |
Moderator |
$newsfader";
$catlist = 0;
if ($catlist == "0" || $viewcat != "") {
$sql = "SELECT * FROM category ORDER BY displayorder";
$query_cat = mysql_db_query("$database", $sql) or die(geterrdesc($sql));
$row = mysql_fetch_array($query_cat);
do {
if (($row['membersonly'] == 0) || (($row['membersonly'] == 1) and ($username != ""))) {
if($viewcat && $row[CID] == $viewcat) {
$sub_sql = "Select f.* from forum f where f.category=$row[CID] and f.active=1 ORDER BY f.displayorder";
}
else if($viewcat && $row[CID] != $viewcat) {
$title = stripslashes($row[category]);
continue;
}
else if(!$viewcat) {
$sub_sql = "SELECT f.* FROM forum f WHERE f.category = '$row[CID]' and f.active=1 ORDER BY f.displayorder";
}
$sub_result = mysql_db_query($database, $sub_sql) or die(geterrdesc($sql));
if($myrow = mysql_fetch_array($sub_result)) {
$title = stripslashes($row[category]);
echo "| $title | ";
do {
echo "";
if ($lastvisit == "") {
$onoff="on";
} else {
if ($lastvisit<$myrow[lastpost]) {
$onoff="on";
} else {
$onoff="off";
}
}
$newpost_icon = "![\"No](\"images/off.gif\") ";
if ($onoff == "on") {
$newpost_icon = "![\"New](\"images/on.gif\") ";
}
if (($myrow[lastpost] == 0) OR ($myrow[lastpost] == "")) {
$lastreplydate = "N/A";
$lastreplytime = "";
$arrow = "";
} else {
$lastreplydate = date("F d, Y",$myrow[lastpost]+($timeoffset*3600));
$lastreplytime = date("h:i A",$myrow[lastpost]+($timeoffset*3600));
}
echo "$newpost_icon | ";
$sql = "SELECT moderator FROM moderator WHERE FID='$myrow[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] ";
}
echo "
$myrow[title]
" . stripslashes($myrow[description]) . " | ";
echo " $myrow[threadcount]
| ";
echo " $myrow[replycount]
| ";
echo " $lastreplydate $lastreplytime $arrow
$lastpost
| ";
echo " $moderator | ";
$count = 0;
echo " \n";
} while($myrow = mysql_fetch_array($sub_result));
}
}
} while($row = mysql_fetch_array($query_cat));
/*Category Addon*/
} else {
$sql = "SELECT * FROM category ORDER BY displayorder";
$querynew = mysql_db_query($database, $sql) or die(geterrdesc($sql));
echo "| Category Listing | ";
while ($category_list = mysql_fetch_array($querynew))
{
if ($bg_color == $col1_bg) {
$bg_color=$col2_bg;
} else {
$bg_color=$col1_bg;
}
echo "| $category_list[category] | ";
}
echo "| | ";
}
/* End Category Addon */
$sql = "SELECT status FROM pm WHERE username_to='$username' AND folder='Inbox' AND status='new' LIMIT 0, 1";
$query = mysql_db_query("$database", $sql) or die(geterrdesc($sql));
$pm = mysql_fetch_array($query);
$pm_icon = "![\"$lang[nonew_pm_alt]\"](\"images/pm_icon_old.gif\") ";
if ($pm[status] == "new")
{
$pm_icon = "![\"$lang[new_pm_alt]\"](\"images/pm_icon.gif\") ";
}
echo " $whosonline
$pms
$bstats
|
$lang[timezone] |
|
![\"Send](\"images/online.gif\")
";
} else {
$pmslight = "
";
}
if ($foruminfo[pms] == 1) {
$pms = "