<?php











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





/* Forums Block for phpBB 2.0.0 port to PHP Nuke 6.5b6+                 */





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





/*                                                                      */





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





/* http://phpnuke.org                                                        */





/*                                                                        */





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





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





/*                                                                      */





/* Updated by Tom Nitzschner 22/06/2002 to add the scrolling text       */





/*                                                                      */





/* Updated by Paul Laudanski 14 Jan 2003                                */





/* NukeCops.com  |  ComputerCops.biz                                        */





/*                                                                        */





/* Last Edited - 14 Jan 2003                                                      */





/*                                                                        */





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





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











if (eregi("block-Forums.php", $PHP_SELF)) {





    Header("Location: index.php");





    die();





}


putenv("TZ=Europe/Oslo"); 


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





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





$count = 1;





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





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





$content .="<center><b>Zadnjih 5 sporočil na forumu</b></center>";





$result1 = sql_query("SELECT t.topic_id, t.topic_last_post_id, t.topic_title, f.forum_name, f.forum_id FROM ".$prefix."_bbtopics t, ".$prefix."_bbforums f where t.forum_id=f.forum_id and f.auth_view=0  ORDER BY t.topic_last_post_id DESC LIMIT 5", $dbi);





$content .= "<br>";





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








$result2 = sql_query("SELECT topic_id, poster_id, FROM_UNIXTIME(post_time,'%d, %b %Y ob %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 ".$prefix."_users where user_id='$poster_id'", $dbi);





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





$topic_title = substr("$topic_title", 0,18);





//$topic_title=parseEmoticons($topic_title);











// Remove the comment below to add the counter





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











$content .= "<a href=\"forums.html?amp;file=viewtopic&amp;p=$topic_last_post_id#$topic_last_post_id\"><b> $topic_title...</b></a><br><i>Zadnji prispevek <A HREF=\"profile-.html$user_id\"> $username </a> v <a href=\"forums.html?amp;file=viewforum&amp;f=$forum_id\">$forum_name</a> $post_time</i></font><br><br>";





$count = $count + 1;





}





$content .= "<br><center>[ <a href=\"forums.html\">$sitename ]</center>";





?>