';
connect(supercheats_forum);
$latest=array();
$query="SELECT id FROM forums WHERE name='".addslashes($name)."'";
$result = mysql_query($query) or die(mysql_error());
if (mysql_num_rows($result)) {
$forum = mysql_fetch_array($result, MYSQL_ASSOC);
$query="SELECT title,postscount,id,first_postid FROM topics WHERE forumid='".$forum["id"]."' and (status='ACTIVE' or status='PINNED') ORDER BY last_postid DESC LIMIT 6";
$result = mysql_query($query) or die(mysql_error());
if (mysql_num_rows($result)) {
while($row = mysql_fetch_array($result, MYSQL_ASSOC)){
$latest[]=$row;
}
}
}
$m=8-count($latest);if ($m>5) { $m=5; }
$query="SELECT title,postscount,id,first_postid FROM topics WHERE forumid='531' and (status='ACTIVE' or status='PINNED') ORDER BY last_postid DESC LIMIT $m";
$result = mysql_query($query) or die(mysql_error());
if (mysql_num_rows($result)) {
while($row = mysql_fetch_array($result, MYSQL_ASSOC)){
$general[]=$row;
}
}
if ($latest) {
$text.='
PostsDiscussion
';
foreach ($latest as $row) {
$pquery="SELECT status FROM fullposts WHERE id='".$row["first_postid"]."'";
$presult = mysql_query($pquery) or die(mysql_error());
$prow = mysql_fetch_array($presult, MYSQL_ASSOC);
if ($prow["status"]=="") {
$text.='
'.$row["postscount"].''.$row["title"].'
';
}
}
} else {
$text.='
No discussions open for '.$name.' at the moment.
';
}
$text.='
Start a chat
';
if ($general) {
$text.='
';
foreach ($general as $row) {
$pquery="SELECT status FROM topics WHERE id='".$row["first_postid"]."'";
$presult = mysql_query($pquery) or die(mysql_error());
$prow = mysql_fetch_array($presult, MYSQL_ASSOC);
if ($prow["status"]=="") {
$text.='
'.$row["postscount"].''.$row["title"].'
';
}
}
}
$text.='
';
#$text.='Get Involved and join the fun. Go to our '.$name.' forums to talk about the game, or visit our other forums to chat to gamers.';
$text.='
';
#$text.='
#
#
#
';
connect(supercheats);
$text.='