if (eregi("block-ForumsScroll.php", $_SERVER['PHP_SELF'])) { 


Header("Location: index.php"); 


die(); 


} 





//include_once ('blocks/smileys.php'); 





global $prefix, $dbi, $sitename, $user, $cookie, $group_id; 


$count = 1; 


$amount = 15; 


$content = "<A name= \"scrollingCode\"></A>"; 


$content .="<MARQUEE behavior= \"scroll\" align= \"center\" direction= \"up\" height=\"220\" scrollamount= \"2\" scrolldelay= \"25\" onmouseover='this.stop()' onmouseout='this.start()'>"; 


$content .="<center> <STYLE=\"text-decoration: none\"><font color=\"#666666\"><b>Last $amount Forum Messages</b></center>"; 


$result1 = sql_query("SELECT DISTINCT t.topic_id, t.topic_last_post_id, t.topic_title, f.forum_name, f.forum_id, f.auth_read FROM ".$prefix."_bbtopics t, ".$prefix."_bbforums f,".$prefix."_bbuser_group a, ".$prefix."_bbauth_access b where t.forum_id=f.forum_id and f.forum_id=b.forum_id and b.group_id=a.group_id and (( a.user_id='$userid' and (b.auth_view = 1 or b.auth_mod = 1 )) OR f.auth_read = 0) ORDER BY t.topic_last_post_id DESC LIMIT $amount", $dbi); 


$content .= "<br>"; 


while(list($topic_id, $topic_last_post_id, $topic_title, $forum_name, $forum_id, $auth_read) = sql_fetch_row($result1, $dbi)) { 


$result2 = sql_query("SELECT topic_id, poster_id, FROM_UNIXTIME(post_time,'%b %d, %Y at %T') as post_time FROM ".$prefix."_bbposts where post_id='$topic_last_post_id' and auth_view='0'", $dbi); 


list($topic_id, $poster_id, $post_time)=sql_fetch_row($result2, $dbi); 





$result3 = sql_query("SELECT username, user_id FROM ".$prefix."_users where user_id='$poster_id'", $dbi); 


list($username, $user_id)=sql_fetch_row($result3, $dbi); 





//$topic_title = substr("$topic_title", 0,17); 


//$topic_title=parseEmoticons($topic_title); 


// Remove the comment below to add the counter 


//$content .="<STYLE=\"text-decoration: none\"><font color=\"#666666\"><b>Message: $count<br></b>"; 





$content .= "<img src=\"modules/Forums/templates/subSilver/images/icon_mini_message.gif\" border=\"0\"alt=\"\"><a href=\"forums.html?amp;file=viewtopic&amp;p=$topic_last_post_id#$topic_last_post_id\"STYLE=\"text-decoration: none\"><b> $topic_title </b></a><br><font color=\"#666666\"><i>Last post by <A HREF=\"forums.html?file=profile&mode=viewprofile&u=$user_id\"STYLE=\"text-decoration: none\"> $username </a> on $post_time</i></font><br><br>"; 


$count = $count + 1; 


} 


$content .= "<br><center>[ <a href=\"forums.html\"STYLE=\"text-decoration: none\">$sitename ]</center>"; 


//$content .= "<center><img src=\"images/banners/fatalexception-logo-88x31.gif\" border=\"0\"></center>"; 


$content .= "</a>"; 


?>

$result = $db->sql_query("SELECT t.topic_id, t.topic_last_post_id, t.topic_title, f.forum_name, f.forum_id, u.username, u.user_id, p.poster_id, FROM_UNIXTIME(p.post_time,'%b %d, %Y at %T') as post_time FROM ".$prefix."_bbtopics t, ".$prefix."_bbforums f LEFT JOIN ".$prefix."_bbposts p ON (p.post_id = t.topic_last_post_id) LEFT JOIN ".$prefix."_users u ON (u.user_id = p.poster_id) WHERE t.forum_id=f.forum_id AND f.auth_view=0 ORDER BY t.topic_last_post_id DESC LIMIT 20");


while(list($topic_id, $topic_last_post_id, $topic_title, $forum_name, $forum_id, $username, $user_id, $poster_id, $post_time) = $db->sql_fetchrow($result)) {





FORUM BLOCK


}

$result1 = sql_query("SELECT topic_id, topic_last_post_id, topic_title FROM ".$prefix."_bbtopics where forum_id NOT IN(10,11) ORDER BY topic_last_post_id DESC LIMIT $amount", $dbi);