phpbb scrolling info box

October 11, 2005

yes it works ... but now it shows

i.e.

shows what? is there a link I can see the box?

oh ok, took all the <br> tags out.

find this:

$phpbb_post['post_subject'] . '</a></b>' . "\n";

change it to this

$phpbb_post['post_subject'] . '</a></b><br>' . "\n";

gregy · October 11, 2005

yes sure .. at Vstopnice.com on the right side .. second box "Koncertni Forum"

Edited October 11, 2005 by gregy

October 11, 2005

ok I see it yes the br I mentioned earlier should do it. If you want it a bit fancier you could add numbers like

1. Topic1

2. Topic2

and so find this code:

  $forum_text = '';
 while( $phpbb_post = tep_db_fetch_array($phpbb_post_query) ) {

change it to this:

  $index = 0;
 $forum_text = '';
 while( $phpbb_post = tep_db_fetch_array($phpbb_post_query) ) {
$index++;

Then goto this line of code:

$forum_text .= '<b><a href="' . tep_href_link(FILENAME_BBMODULES, 'op=modload&name=phpbb2&file=viewforum.php&f=' . $phpbb_post['forum_id'], 'NONSSL') . '">' . $phpbb_post['post_subject'] . '</a></b>' . "\n";

change it to this:

$forum_text .= '<b><a href="' . tep_href_link(FILENAME_BBMODULES, 'op=modload&name=phpbb2&file=viewforum.php&f=' . $phpbb_post['forum_id'], 'NONSSL') . '">' . $index . '. ' . $phpbb_post['post_subject'] . '</a></b><br>' . "\n";

gregy · October 11, 2005

:thumbsup:

may i dig further :D

can we strip out double topics .. where there are replies .. to show only once?

thanx a lot for your time!!!

October 11, 2005

yes just change the sql query line to this:

  $phpbb_post_query = tep_db_query("select pt.post_subject, pt.post_text, p.forum_id, p.post_time, t.topic_title from phpbb_posts p left join phpbb_posts_text pt on p.post_id=pt.post_id left join phpbb_topics t on t.topic_id=p.topic_id where pt.post_subject != '' order by pt.post_id desc limit " . MAX_DISPLAY_PHPBB_BOX_POSTS);

Also I am gonna make the phpbb box available as a listing. I was working on this a bit, take a look

http://www.herbalfox.com/us/rss.php

And maybe I will set it as well to unique subjects.

I still want to change the format a bit

Edited October 11, 2005 by enigma1

Top_Speed · December 6, 2005

Hi,

I have an outside phpbb: www.gokartsrus.com/go-kart_forum/

Following directions on install (ver 1.02 latest) done to a tee (or so I think?)

I'm using or have uploaded the phpbb_forum_external.php (includes/boxes dir)

-Added the defines in the includes/configure.php

-Added the code for the 2nd db in includes/functions/database.php

-Did the mysql insert (shows the line in my admin about min. display) this is OK

Now when I put the command in my includes/column_left.php (very last before ?>

if( MAX_DISPLAY_PHPBB_BOX_POSTS )

include (DIR_WS_BOXES . 'phpbb_forum.php');

....my whole site goes blank white. Locked to the point where I have to reload all the old backup files (includes/configure.php, includes/functions/database.php, includes/column_left.php) to get it to work again. My host has looked at your contrib and they usually are pretty good with php but it has them stumped as well.

I would really like this contrib to work and would be greatful for your help in this matter.

Best Regards, KJ Miller (top_speed)

December 6, 2005

The instructions state for external forum to use the phpbb_forum_external.php that comes with the package. Did you use that one? Because from your post seems you're using the internal version with an external forum.

NOTE: If you use the phpbb as an external forum (not integrated under osc) use this box file instead ? included in the package.

phpbb_forum_external.php Instructions for the external phpbb forum are included in the file.

Top_Speed · December 6, 2005

I'm using or have uploaded the phpbb_forum_external.php (includes/boxes dir)

Hi Mark,

Thanks for such a quick response!

Yes on the external box file. Followed those directions but they are missing a couple of things like adding the english file and the statement in the column_left to load the box.

As said, all I get is a blank screen. Can you re-look at those directions because I think they may be missing something else besides the english.php statement and the column_left (right).php statement that needs to happen and like said it is not in the directions for the external forum.

Thanks, Ken

December 7, 2005

Ok yes the language details are common between the 2 different versions with the exception of the box filename itself.

So the document should include a statement like

  if( MAX_DISPLAY_PHPBB_BOX_POSTS )
include (DIR_WS_BOXES . 'phpbb_forum_external.php');

But I don't think its the problem. So now couple of things. The phpbb external forum in your case it is in a separate dbase correct? This is how the external version expects the dbase setup. So the osc store is say dbase1 then phpbb is in dbase2.

The blank screen could occur most likely if the dbase cannot be accessed. Or if the installation of the files is incorrect. Did you include the second set of functions for the secondary dbase in the database.php file? And also the configure.php requires the second set of definitions for server/dbase/username/password.

Finally if it was a parse error it would not only appear when you add the include line.

Also you can isolate the problem from the phpbb_forum_external.php

Try these:

1. Comment out the box build code

  // YOUR EXTERNAL FORUM URL HERE
 $forum_url = "http://mysite.com/phpbb";

 $info_box_contents = array();
 $info_box_contents[] = array('text' => BOX_HEADING_FORUM);
 new infoBoxHeading($info_box_contents, true, true, '<a href="' . $forum_url . '">Forum</a>');

 $forum_text = '';
 while( $phpbb_post = tep_db_fetch_array($phpbb_post_query) ) {
// Remove HTML tags
$post_content = strip_tags($phpbb_post['post_text']);
// Process PHPBB tags
$post_content = phpbb_tags_to_html($post_content);

$forum_text .= '<center><b><a href="' . $forum_url . 'op=modload&name=phpbb2&file=viewforum.php&f=' . $phpbb_post['forum_id'] . '">' . $phpbb_post['post_subject'] . '</a></b></center><br>' . $post_content . "\n";
 }

 $forum_text = '<MARQUEE behavior= "scroll" align= "center" direction= "up" height="160" scrollamount= "2" scrolldelay= "20" onmouseover=\'this.stop()\' onmouseout=\'this.start()\'>'.$forum_text.'</MARQUEE>' . "\n";
 $info_box_contents = array();
 $info_box_contents[] = array('align' => 'center', 
						   'text' => $forum_text);

 new infoBox($info_box_contents);

See if it gets over the blank screen.

2. Check if the dbase connection is the problem

Comment out these lines at the beginning and near the end of the box file:

  tep_db_close();
 tep_db_connect2() or die('Unable to connect to database server!');

and

  tep_db_close2();
 tep_db_connect() or die('Unable to connect to database server!');

So if the phpbb is on another dbase you should get an sql error in this case for the unknown phpbb tables and not a blank screen.

Maybe this way we can see where this problem is coming from.

December 8, 2005

is there a way to stop it from showing hidden staff threads or moderator threads that shouldnt be shown, perhaps only threads registered users can see.

Top_Speed · December 12, 2005

Hi Mark,

This thing has been driving me crazy but I really would like to have it work.

Its breaking the HTML code on the creation of the infobox.

I've attached a screen shot of the stuff I uncommented to break it, and the

result. Not being a php programmer I don't know how to fix it or even

why/where its picking up the broken code from. At one point I did have it

pulling in a post from the phpbb, so I know it works, its just breaking the

infobox and front page formatting code.

18 <?php

19 // YOUR EXTERNAL FORUM URL HERE

20 $forum url = "http://www.gokartsrus.com/go-kart_forum";

21 $info box contents = array();

22 $info box contents[] = array(`text' => BOX-HEADING-FORUM);

23 new infoBoxHeading($info box contents, true, true, `<a href="http://www.gokartsrus.com/go-kart forum">Forum</a>');

24 

25 //$forum text 

26 //while( $phpbb post = tep_db fetch array($phpbb post query) ) { 

27 // Remove HTML tags 

28 //$post content = strip_tags($phpbb_post[`post_text`]); 

29 // Process PHPBB tags 

30 //$post content = phpbb tags to html($post content); 

31 

32 //$forum text ._ `<center><b><a href="` $forum url `op=modload6name=phpbb2Sfile=viewforum.php6f=` $phpbb_post[`for

um id'] "`>` $phpbb post [`post subject`] `</a></b></center><br>` $post content "\n"; 

33 

34 

35 //$forum text = `MARQUEE behavior="scroll" align="center" direction="up" height="160" scrollamount="2" scrolldelay="20"

onmouseover=\'this stop()\' onmouseout=\`this.start()\'>`.$forum text.'</MARQUEE>' "\n"; 

36 //$info box contents = array(); 

37 //$info box contents[] = array(`align' => `center`, 

38 //,text, => $forum text); 

39 

40 new infoBox($info_box_contents); 

41

Your suggestions are appreciated 101%!

Thanks, KJ

December 12, 2005

Here is the code I could make from the posted lines plus integrating it into the external forum. You have plenty of problems in your code. Dashes intead of underscores, wrong quotes (` instead of ' there is a difference), html links?

<?php
 // YOUR EXTERNAL FORUM URL HERE
 $forum_url = "http://www.gokartsrus.com/go-kart forum";

 $info_box_contents = array();
 $info_box_contents[] = array('text' => BOX_HEADING_FORUM);
 new infoBoxHeading($info_box_contents, true, true, '<a href="' . $forum_url . '">Forum</a>');

 $forum_text = '';
 while( $phpbb_post = tep_db_fetch_array($phpbb_post_query) ) {
// Remove HTML tags
$post_content = strip_tags($phpbb_post['post_text']);
// Process PHPBB tags
$post_content = phpbb_tags_to_html($post_content);

$forum_text .= '<center><b><a href="' . $forum_url . 'op=modload&name=phpbb2&file=viewforum.php&f=' . $phpbb_post['forum_id'] . '">' . $phpbb_post['post_subject'] . '</a></b></center><br>' . $post_content . "\n";
 }

 $forum_text = '<MARQUEE behavior= "scroll" align= "center" direction= "up" height="160" scrollamount= "2" scrolldelay= "20" onmouseover=\'this.stop()\' onmouseout=\'this.start()\'>'.$forum_text.'</MARQUEE>' . "\n";
 $info_box_contents = array();
 $info_box_contents[] = array('align' => 'center', 
						   'text' => $forum_text);

 new infoBox($info_box_contents);

// close the connection
 tep_db_close2();
 tep_db_connect() or die('Unable to connect to database server!');
?>

So use this code I posted see if it gets any better. If not apply the chanes to locate the problem. You have to comment out bit by bit. And when you comment out code use the /* */ notation. Not the //

is there a way to stop it from showing hidden staff threads or moderator threads that shouldnt be shown, perhaps only threads registered users can see.

Yes there is, but what's the parameter you need to filter? Posts by someone with a special rank? Or you simply want only posts from regular users?

So here is one query for users with rank 0 (regular, anonymous users)

  $phpbb_post_query = tep_db_query("select pt.post_subject, pt.post_text, p.forum_id from phpbb_posts p left join phpbb_posts_text pt on p.post_id=pt.post_id left join phpbb_users u on u.user_id=p.poster_id where u.user_level=0 order by pt.post_id desc limit " . MAX_DISPLAY_PHPBB_BOX_POSTS);

just replace the sql query line with the above in the phpbb_forum.php and give it a try. Haven't tested it but its the main idea.

Edited December 12, 2005 by enigma1

Top_Speed · December 13, 2005

Hi Mark,

Sorry about the broken code (it was copied from a jpg shot) and converted (sorry!)

Here is the actual code as we have it now...

(I will revise as suggested)

<?php
/*
 $Id: information.php,v 1.6 2003/02/10 22:31:00 hpdl Exp $

 osCommerce, Open Source E-Commerce Solutions
 [url=http://www.oscommerce.com]http://www.oscommerce.com[/url]

 Copyright ? 2003 osCommerce

 Released under the GNU General Public License

*/
 tep_db_close();
 tep_db_connect2() or die('Unable to connect to database server!');
 $phpbb_post_query = tep_db_query2("select pt.post_subject, pt.post_text,
p.forum_id from posts p left join posts_text pt on p.post_id=pt.post_id
order by pt.post_id desc limit " . MAX_DISPLAY_PHPBB_BOX_POSTS);

?>
<?php
// YOUR EXTERNAL FORUM URL HERE
$forum_url = "http://www.gokartsrus.com/go-kart_forum";
//$info_box_contents = array();
//$info_box_contents[] = array('text' => BOX_HEADING_FORUM);
//new infoBoxHeading($info_box_contents, true, true, '<a
href="http://www.gokartsrus.com/go-kart_forum">Forum</a>');

//$forum_text = '';
//while( $phpbb_post = tep_db_fetch_array($phpbb_post_query) ) {
// Remove HTML tags
//$post_content = strip_tags($phpbb_post['post_text']);
// Process PHPBB tags
//$post_content = phpbb_tags_to_html($post_content);

//$forum_text .= '<center><b><a href="' . $forum_url .
'op=modload&name=phpbb2&file=viewforum.php&f=' . $phpbb_post['forum_id']
. '">' . $phpbb_post['post_subject'] . '</a></b></center><br>' .
$post_content . "\n";
//}

//$forum_text = '<MARQUEE behavior="scroll" align="center" direction="up"
height="160" scrollamount="2" scrolldelay="20" onmouseover=\'this.stop()\'
onmouseout=\'this.start()\'>'.$forum_text.'</MARQUEE>' . "\n";
//$info_box_contents = array();
//$info_box_contents[] = array('align' => 'center',
//'text' => $forum_text);

//new infoBox($info_box_contents);

// close the connection
tep_db_close2();
tep_db_connect() or die('Unable to connect to database server!');
?>
</td>
</tr>
<!-- external_forum_eof //-->

Thanks so much, KJ

Edited December 13, 2005 by Top_Speed

December 13, 2005

use the /* */ notation to comment out code in php not the //

so instead of:

//$info_box_contents[] = array('align' => 'center',

use:

/*$info_box_contents[] = array('align' => 'center',*/

Top_Speed · December 14, 2005

Hi Mark,

Still stumped, I have Erin (my host tech) working on this and she to is baffled. Here is her findings and note:

As I mentioned on the phone earlier, the method to commenting out the code
doesn't make a difference. I have attached 3 text files and 3 matching

screen shots of your site, as well as a 4th text file that contains the

wholly commented out code as it resides on the server, and a 5th containing

the html code as it is served with the contrib fully active. As long as

everything is commented out, the site works perfectly (but obviously there

is no infobox with the scrolling phpbb topics). As soon as you uncomment any

part of the code that *creates the infobox* all of the infoboxes/components

get stuck over to the left of the screen and that broken "> shows up in the

phpbb infobox heading.

This Code (below) makes the left and right colums combine together (aligned vertically on left side) It also makes the content in the center show up down below the left column, right before the right column is displayed on the left.

<?php
// YOUR EXTERNAL FORUM URL HERE
$forum_url = "http://www.gokartsrus.com/go-kart_forum";
$info_box_contents = array();
$info_box_contents[] = array('text' => BOX_HEADING_FORUM);
new infoBoxHeading($info_box_contents, true, true, '<a href="http://www.gokartsrus.com/go-kart_forum">Forum</a>');

$forum_text = '';
while( $phpbb_post = tep_db_fetch_array($phpbb_post_query) ) {
// Remove HTML tags
/* $post_content = strip_tags($phpbb_post['post_text']); */
// Process PHPBB tags
/* $post_content = phpbb_tags_to_html($post_content); */

$forum_text .= '<center><b><a href="' . $forum_url . 'op=modload&name=phpbb2&file=viewforum.php&f=' . $phpbb_post['forum_id'] .
'">' . $phpbb_post['post_subject'] . '</a></b></center><br>' . $post_content . "\n";
}


$forum_text = '<MARQUEE behavior="scroll" align="center" direction="up" height="160" scrollamount="2" scrolldelay="20" onmouseover=\'this.stop()\' onmouseout=\'this.start()\'>'.$forum_text.'</MARQUEE>' . "\n";
$info_box_contents = array();
$info_box_contents[] = array('align' => 'center',
'text' => $forum_text);



new infoBox($info_box_contents);

Here is a snap shot of above code

live with no build box code (has L&R colums OK, the Santa is in top center etc. ->Go Karts R us

Please let me know what's up (or not up :)

Thanks, KJ

December 14, 2005

what I posted earlier is part of the file. Make sure you have everything before and after of the original file in the contributions section. (at least the html code) there is a <tr><td> near the beginning and </td></tr> near the end. And the php termination tag.

From the screenshot I can see the php code inside the html which means its not the whole file there.

ripthesystem · February 19, 2006

just as an FYI I had this same problem with the Featured Products Infobox contribution. The thing that both of these infoboxes have in common is the <tr><td> near the beginning and </td></tr> near the end.

I was able to solve the problem with both contributions simply by removing these tags. HTH.

ripthesystem · February 19, 2006

The other thing I was/am having a problem with is the BBCode being changed into the appropriate HTML in the block. Out of the box with the latest release of this contribution(v1.02) only Bold and Quote work properly there are also changes in the HTML_OUTPUT.php file to make List and URL's work but I can't get them to work properly at all.

Meaning that the List BBcode works to a point, it will actually make the <ul> code properly but in BBcode if you are making a list you use [*] for each item in the list. This returns:

[*:6a320d0767] List Item 1
[*:6a320d0767] List Item 2

The URL link doesn't seem to do anything at all.

It is structured in PHPBB2 like this:

[url=http://www.sitename.com]Click Here for Site[/url]

and in the Infobox it is returned exactly like that.

I have managed, using your original design as a template to create working BBcode translations for Italic, Underline, & Code.

That brings us to:

Working: Bold, Italic, Underline, Quote, & Code

Not Working: Img, URL, List

I'm going to keep trying to figure this out but if any of you have succeeded please share!

Thx

ripthesystem · February 19, 2006

here's my function so far in the html_output.php:

  function phpbb_tags_to_html($msg) {



$strip_array = array(

					 array('textopen' => '', 

						   'textclose' => '', 

						   'open' => '[b:', 

						   'close' => '[/b:',

						   'htmlopen' => '<b>', 

						   'htmlclose' => '</b>'),							   

					 array('textopen' => '', 

						   'textclose' => '', 

						   'open' => '[i:', 

						   'close' => '[/i:',

						   'htmlopen' => '<i>', 

						   'htmlclose' => '</i>'),

					 array('textopen' => '', 

						   'textclose' => '', 

						   'open' => '[u:', 

						   'close' => '[/u:',

						   'htmlopen' => '<u>', 

						   'htmlclose' => '</u>'),

					 array('textopen' => '', 

						   'textclose' => '', 

						   'open' => '[quote:', 

						   'close' => '[/quote:',

						   'htmlopen' => '<br><em>', 

						   'htmlclose' => '</em><br>'),

					 array('textopen' => '', 

						   'textclose' => '', 

						   'open' => '[code:', 

						   'close' => '[/code:',

						   'htmlopen' => '<br><em>', 

						   'htmlclose' => '</em><br>'),				

					 array('textopen' => '', 

						   'textclose' => '', 

						   'open' => '[list:', 

						   'close' => '[/list:',

						   'htmlopen' => '<ul>', 

						   'htmlclose' => '</ul>'),

					 array('textopen' => '', 

						   'textclose' => '', 

						   'open' => '[*:', 

						   'close' => '[*:',

						   'htmlopen' => '<li>', 

						   'htmlclose' => '</li>'),

					 array('textopen' => '', 

						   'textclose' => '', 

						   'open' => '[img:', 

						   'close' => '[/img:',

						   'htmlopen' => '<b>image: ',

						   'htmlclose' => '</b>') );

This gets B, I, U, QUOTE, CODE working

It also kinda has IMG working. It shows the image as the URL for the IMG which is fine. However since the URL length is longer than the length of the infobox the last half of the URL for the IMG is cut off instead of wrapped as it should be.

LIST [*] still isn't working

URL= and URL aren't working

No smilies are working. It would be nice to convert the ;-) into the actual image for the smiley.

Suggestions?

February 20, 2006

for the wrap issue if a single word has more characters than a predefined number you could only print the first n characters.

For the undecoded phpbb tags you could simply remove them if there are no array entries. Otherwise you need to add the code to decode them. All of the phpbb tags use square brackets so those signify the opening/closing.

As of the <tr>, <td> tags all boxes of the default osc have them so why you're having a problem unless it' s modified osc store or some template in which case its up to you to customize all boxes regardless of contribution feature.

ripthesystem · February 20, 2006

As of the <tr>, <td> tags all boxes of the default osc have them so why you're having a problem unless it' s modified osc store or some template in which case its up to you to customize all boxes regardless of contribution feature.

My store started off as a templated STS store but that killed my store speed and so I was forced to remove STS from a highly modified store and then redesign it from scratch. This may have inadvertently created my problem with the boxes. Regardless I don't mind editing the boxes to work so all is well there!

for the wrap issue if a single word has more characters than a predefined number you could only print the first n characters.

In reality it's kinda doing that on its own. Meaning that a URL or a single word that is longer than the infobox has space for just cuts itself off at the edge of the infobox.

Any way you could think of to replace any urls or images with a shorter phrase?

For example if someone types in a link or an image:

hey there this is my example post!
Click [url=http://www.oscommerce.com/forums/index.php]here[/url] to visit the forums. Or if you just want to look at a pretty picture look at this: [img=http://www.oscommerce.com/forums/style_emoticons/default/thumbsup.gif]

Is there anyway to take this and make it so that we don't have to deal with long urls and image links, etc?

Maybe have the infobox print out something like:

hey there this is my example post!
Click (link) here to visit the forums. Or if you just want to look at a pretty picture look at this: (image)

That way you wouldn't have to parse the links or have to deal with single lines that are longer than an infobox and won't wrap but it would still get across the idea of the post.

I have no clue how to do this however. Any ideas? Clues?

For the undecoded phpbb tags you could simply remove them if there are no array entries. Otherwise you need to add the code to decode them. All of the phpbb tags use square brackets so those signify the opening/closing.

Generally I figured this much out while looking through your html_output.php file changes.

That's how I figured out how to do the Underline code change for example:

array('textopen' => '', 
'textclose' => '', 
'open' => '[u:', 
'close' => '[/u:',
'htmlopen' => '<u>', 
'htmlclose' => '</u>'),

Underline in BBcode is [ u ] and then [ /u ]

That's easy enough.

However what about stuff like [ url= ???] and then [ /url ]

or even ones that don't have an opening and a closing? Like bullets in a list? [ * ] or Emoticons. Both of these only have one tag. Not an opening and a closing.

Sorry for all the questions. This is a great contribution you have here! Thanks!

jackrabbit · May 16, 2006

Hey Mark,

I would really like to be able to have a forum integrated with OSC, and I was hoping to use your contribution, but I'm afraid I'm a little confused about how it's all supposed to be working.

Am I supposed to already have a phpBB installed? The way that I have read this thread and the documentation from the contribution I'm of the understanding that this will add the forum to my site. But now that I've gone through the installation process and read the forum it seems like this is not the case.

Could you point me in the right direction for this? I went through all the installation steps and ran the sql querry in v1.02 and I get this error on my front page:

1146 - Table 'xxx_osc2.phpbb_posts' doesn't exist

select pt.post_subject, pt.post_text, p.forum_id from phpbb_posts p left join phpbb_posts_text pt on p.post_id=pt.post_id order by pt.post_id desc limit 5

[TEP STOP]

I figure that I really need to have installed the phpBB already.

Any help would be greatly appreciated. Thanks so much.

May 16, 2006

yes you do need the phpbb forum installed (internal or external) in order to use that contribution box.

jackrabbit · May 16, 2006

yes you do need the phpbb forum installed (internal or external) in order to use that contribution box.

Hey Mark,

Thank you so much for the rapid response. I appreciate it.

Do you have any suggestions on where to look for instructions for installing phpBB as an internal page in OSC?

Thanks again.

;-j

May 16, 2006

Here is the one I was testing the box, when the phpbb forum is integrated with osC

http://www.oscommerce.com/community/contributions,2116

phpbb scrolling info box

Recommended Posts

Guest

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Popular Days

gregy

Guest

gregy

Guest

Top_Speed

Guest

Top_Speed

Guest

Guest

Top_Speed

Guest

Top_Speed

Guest

Top_Speed

Guest

ripthesystem

ripthesystem

ripthesystem

Guest

ripthesystem

jackrabbit

Guest

jackrabbit

Guest

Join the conversation

Browse

Activity