<?php


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


/* Forums Scrolling Block for RavenNuke(tm)  */


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


/*                                                                      */


/* Copyright (c) 2009 by Gaylen Fraley (raven@ravenphpscripts.com       */


/* http://ravenphpscripts.com                     */


/* 2009-01-18  Modified for RavenNuke(tm)  v2.30.00+ by Gaylen Fraley (Raven) http://ravenphpscripts.com */


/* Added security so that user only sees the forums that he is authorized to see */


/*                           */


/* Original 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/                                */


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


/*                                               */


/* This Block shows the last (elected number of 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.       */


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





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


    Header("Location: index.php");


    die();


}





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





global $prefix, $user_prefix, $db, $sitename, $user, $cookie, $group_id;


$count = 1;


$amount = 15;


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


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


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


$sql = 'SELECT t.forum_id, topic_id, topic_last_post_id, topic_title, auth_view, auth_read FROM '.$prefix.'_bbtopics AS t, '.$prefix.'_bbforums AS f WHERE f.forum_id=t.forum_id ORDER BY topic_time DESC LIMIT ' . $amount;


$result = $db->sql_query($sql);


$content .= "<br />";


while (list($forum_id, $topic_id, $topic_last_post_id, $topic_title, $auth_view, $auth_read) = $db->sql_fetchrow($result)) {


   if (($auth_view < 2) OR ($auth_read < 2)) {


      $sql1 = "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'";


      $result1 = $db->sql_query($sql1);


      list($topic_id, $poster_id, $post_time) = $db->sql_fetchrow($result1);


      $sql2 = 'SELECT username, user_id FROM ' . $user_prefix . '_users where user_id=' . $poster_id;


      $result2 = $db->sql_query($sql2);


      list($username, $user_id)=$db->sql_fetchrow($result2);





$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=\"#6677A0\"><b>Message: $count<br /></b>";


      $content .= "<img src=\"modules/Forums/templates/subSilver/images/icon_mini_message.gif\" border=\"0\" alt=\"\">";


      $content .= "<a href=\"modules.php?name = Forums&amp;file=viewtopic&amp;t=".$topic_id."\" style=\"text-decoration: none\"><b> $topic_title </b></a><br />";


      <font color=\"#6677A0\"><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="modules.php?name = Forums"><b>'.$sitename.' Forums</b></a><br /><br /></center>';


?>

  $sql1 = "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'"; 

  $sql1 = "SELECT topic_id, poster_id, FROM_UNIXTIME(post_time,'%b %d, %Y at %r') as post_time FROM ".$prefix."_bbposts where post_id='$topic_last_post_id'";