<?php





/************************************************************************/


/* Forums Block for phpBB 2.0.0 port to PHP Nuke 5.5                    */


/* =================================================                    */


/*                                                                      */


/* Copyright (c) 2002 by Francisco Burzi (fbc@mandrakesoft.com)         */


/* http://phpnuke.org                     */


/*                           */


/* Version 1, modified by Sébastien Vaast                               */


/* http://membres.lycos.fr/projectpluto/                                */


/*                                                                      */


/*                                               */


/* Last Edited - 09 May 2002                        */


/*                                               */


/* This Block shows the last 10 topics where a message was posted,   */


/* along with the username of the last poster and the day and time   */


/* of the post.                        */


/* It will also show smileys in the topic titles thanks to the      */


/* smileys.php file found in Leo Tan Block Forums version      */


/* (http://www.cybercomp.d2g.com).               */


/*                           */


/* This program is free software. You can redistribute it and/or modify */


/* it under the terms of the GNU General Public License as published by */


/* the Free Software Foundation; either version 2 of the License.       */


/************************************************************************/


/************************************************************************/


/* Modified by Gaylen Fraley http://ravenphpscripts.com                 */


/************************************************************************/





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


    Header("Location: index.php");


    die();


}





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





global $prefix, $user_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 topic_id, topic_last_post_id, topic_title FROM ".$prefix."_bbtopics ORDER BY topic_last_post_id DESC LIMIT $amount", $dbi);


$content .= "<br>";


while(list($topic_id, $topic_last_post_id, $topic_title) = 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'", $dbi);


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





$result3 = sql_query("SELECT username, user_id FROM ".$user_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=\"profile-.html$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>";


?>