problem with a block from 6.5 to 6.9 (scrolling post block)

Court Jester Joined: Sep 20, 2003 Posts: 106

my scrolling block for my forums no longer works in php-nuke 6.9

What do i need to change.

Here is an example

www.mafiamods.com

-this is the site i maintain-

you will notice a block on the right side that isnt moving, and has 5 forum links.

i hope its ok, but here is the code being used for it:

Code:

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


    Header("Location: index.php");


    die();


}





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=\"220\" scrollamount= \"2\" scrolldelay= \"20\" onmouseover='this.stop()' onmouseout='this.start()'>";


$content .="<center> <STYLE=\"text-decoration: none\"><font color=\"#666666\"><b>Last 20 Forum Messages</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 20", $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,'%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 ".$prefix."_users where user_id='$poster_id'", $dbi);


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





$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=\"modules.php?name=Forums&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=\"forum-userprofile-.html$user_id\"STYLE=\"text-decoration: none\"> $username </a> in <a href=\"modules.php?name=Forums&amp;file=viewforum&amp;f=$forum_id\">$forum_name</a> on $post_time</i></font><br><br>";


$count = $count + 1;


}


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


?>

Site Admin/Owner Joined: Aug 27, 2002 Posts: 17088

I had to comment out lines 7 and 23 because I do not have the smileys.php file that you refer to. However, the block works perfectly w/o those 2 lines for me. So I would suggest that you comment out those 2 lines and see if the block works. If so, then it would appear that it may be related to the smileys.php or to the function on line 23.

Posted: Thu Sep 25, 2003 7:56 pm

THANKS!

AWSOME IT WORKS! Very Happy