phpBB2 forums block..?

Katsushiro · Cadet Joined: Jan 28, 2003 Posts: 1 Location: USA

Allright.. I hate to ask this here since Iknow it's mostly a help site, but I've been searching all over and am pretty ready to give up. I'd love to get my hands on the scrolling phpBB2 forum block you guys have here on the site, I've seen the same (or similar) block on a couple of other sites but I haven't seen it available for download anywhere. I'm testing out phpNuke 6.5b6, and used to have a non-scrolling phpBB2 forum block, but now that it's integrated and the forum fields changed, that one's useless. Iwas gonna sit down and modify it so it would work, but then I saw this one and it's really much spiffier. Did you guys make it yourseles, or if you downloaded it, where did you get it? I'm really hankering to give it a try on my site. Thanks in advance. Very Happy

Oh.. while I'm here, I should ask an actual technical question.. although this one's mostly specific to the 6.5 series in general, and also relates to the forum.. since the field names changed, is there any chance you could let me know which field is which now? That way I could migrate the contents of my old 5.6 w/ phpBB2 port into the new integrated 6.5 forums (I instaled the 6.5 upgrade over a copy of my old 5.6 site (kept the original in a separate directory untouched) and most things worked fine but I noticed my forum data had 'gone away')

Paul · Admin Joined: Feb 22, 2002 Posts: 5719 Location: USA

Hi & welcome. I run both this site and http://nukecops.com. Aspects of this site help the cause of PHP-Nuke when it comes to security, but Nuke Cops is 100% focused on PHP-Nuke. The scrolling block I got from somewhere and modified it to act like it does here and at Nuke Cops. I have to find time to polish up the code and release it. Ideally this week.

As for the technical question, I put together a dissection from beta 5 to beta 6 as a news article at Nuke Cops. Mainly the changes that concern you are the nuke_users changes. Also, the splatt forums have been removed as of beta 6.

Guest · Posted: Wed Jan 29, 2003 5:59 am Post subject:

Hi there, thanks for the welcome and the polite reply, I was half afraid I'd get flamed as I know this post is a bit off topic as a whole. I'm looking forward to the release of your code, then, I'll keep an eyes on nukecops.com for it. I've allready tried out the fixfile packs from there on the 6.5b6 I'm playing with and have been very impressed.

As for the article, I'll go have a look at it later today as well then, hopefully it will help me out some. Thanks again for the advice, and great work on both sites (I had a feeling they were related).

Paul · Admin Joined: Feb 22, 2002 Posts: 5719 Location: USA

That's the standing order pretty much for both sites... everyone gets treated with respect.

andysamb4 · Guest

Sorry to be a pain but I've installed the scroller with the SPlat forum but no joy. Just get the header message "Last 20 Posts".

Any help available?

Paul · Admin Joined: Feb 22, 2002 Posts: 5719 Location: USA

The forum block works for phpbb2 and not splatt.

chatserv · Cadet Joined: Mar 06, 2003 Posts: 7 Location: Puertorico

Point me to the exact block you downloaded (as there are more than one) and i'll see what i can do.

ktb-pdrive · Guest

Please don't think i have 4$$hole tattoo'ed on my forehead but..
i downloaded the scrolling forums block
i stuck it in my blocks directory with all my other blocks
it wanted me to overwrite a already existing file with that name
i said sure...
but when i goto my admin page i dont see the block listed
Did i miss a FAQ on this sucker?

im running 6.5 PhPNuke
My Address is http://www.twilight-skies.com

Paul · Admin Joined: Feb 22, 2002 Posts: 5719 Location: USA

Hi, make sure you activated the block.

lamamike · Cadet Joined: Sep 20, 2003 Posts: 1 Location: USA

hi.. i'm sure you're busy, so thanks for any help up front...

I'm trying to implement the scrolling forums block (I know there are many downloads out there, so here's the one I'm using)...

____________________________________________________
<?php
if (eregi("block-Forums.php", $PHP_SELF)) {
Header("Location: index.php");
die();
}
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\">Last 20 Forum Messages</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 .= "
";
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 uname, uid FROM ".$prefix."_users where uid='$poster_id'", $dbi);
list($uname, $uid)=sql_fetch_row($result3, $dbi);

// Remove the comment below to add the counter
//$content .="<STYLE=\"text-decoration: none\"><font color=\"#666666\">Message: $count
";

$content .= " $\"\"$ <a href=\"postp.html$topic_last_post_id#$topic_last_post_id\"STYLE=\"text-decoration: none\"> $topic_title </a>
<font color=\"#666666\">Last post by <A HREF=\"modules.php?name=Forums&file=profile&mode=viewprofile&u=$uid\"STYLE=\"text-decoration: none\"> $uname </a> in <a href=\"forum.html$forum_id\">$forum_name</a> on $post_time</font>

";
$count = $count + 1;
}
$content .= "
<center>[ <a href=\"modules.php?name=Forums\"STYLE=\"text-decoration: none\">$sitename ]</center>";
?>
_______________________________________________

when i activate the block in my site I get 20 identical "Warning" errors in a row.... here's one (and I've activated the =1 in sql_layer.php to see the full error message on these cut and pastes...) as an example:

_____________

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/virtual/site263/fst/var/www/html/includes/sql_layer.php on line 286
SQL query: SELECT topic_id, poster_id, FROM_UNIXTIME(post_time, '%b %d, %Y at %T') as post_time FROM nuke__bbposts where post_id='32'
SQL query: SELECT uname, uid FROM nuke__users where uid='2'
____________

They stretch out my 150 px left block halfway across the screen and litter my site with error messages! But the cute little scrolling recent forums posts block sits neatly at the bottom of it all, happily doing what it is supposed to do.

Can you help me get rid of those ugly errors?? And also -- I am the only one on the planet still using notepad to edit stuff (and counting down to line 286 in sql_layer.php to see if I could figure it out myself sucks!)... can you recommend a good editor that I can use on a cranky Win 98 system that I've borrowed from my work ever since my laptop died? I know I'm a dinosaur when it comes to my editor....??

thanks for your help...

Jesus-squirrel · Cadet Joined: Jan 07, 2004 Posts: 1 Location: USA

Is this the latest version??
I Have sucessfully installed this version of block_Forms on my nuke 6.9 site. Razz

Its at the nukecops downloads
http://nukecops.com/downloads-cats-3-10-10.html

block_Forums Nuke 6,5beta6 and up
Description: This is the release of the block for the scrolling forums text specifically for PHP-Nuke 6.5 beta 6 and up. Files get placed in the blocks folder.
Version: 3 Filesize: 1.98 Kb
Added on: 29-Jan-2003 Downloads: 6509 Rating: 8 (5 Votes)
HomePage | Rate Resource | Report Broken Link | Details | Comments (1)

http://s88920839.onlinehome.us/

phoenix22 · Posted: Thu Jan 08, 2004 8:29 pm Post subject:

nukecops is our site.....


	Home ˇ Topics ˇ Submit News ˇ Top 10 This entire site, Cops Themes, and Computer Cops are Š 2002 - 2004 Computer Cops, LLC. All rights reserved. You can syndicate our news using the file RSS 0.91, ultramode.txt, or RSS 1.0. Acceptable Use Policy. Use signifies your agreement. Engine Copyright Š 2002 by PHP-Nuke, GNU/GPL Licensed. ICRA Member. Paul Laudanski, Member of Computer Cops, LLC Server Load: 1256 pages served in previous 5 minutes. Page Rendered: 1.620 seconds.