Joined: Mar 03, 2003 Posts: 6287 Location: Washington Township, NJ, USA
Posted: Tue May 03, 2005 8:34 pm Post subject: Standalone phpBB2 integration within PHPNuke
This is a DRAFT of the FORTH VERSION of the installation guide. Make backup copies of your phpNuke files and your database before starting this process. If it works for you, let us know [nukedgallery.net]. If it doesn't, let us know what went wrong [nukedgallery.net], then revert back to your saved backup for your site until we can work out the bugs.
Version History:
Beta1 (8 April 2004):
Initial Draft
Beta2 (27 April 2004):
Reduced number of phpNuke modifications by using $user_prefix.
Beta3 (3 May 2004):
Introduced ability to redirect to forums upon login/logout.
Added fixes for phpNuke admin control panel related to change in format of $user_regdate field in the database.
Beta4 (12 July 2004):
Updated to phpNuke 7.2.
Split the integration methods into two separate guides.
How to integrate standalone phpBB with phpNuke Developed and Authored by: Dariush Molavi (dari AT nukedgallery DOT net) and spcdata
Special thanks to spcdata for testing
This is a how-to on integrating standalone phpBB within PHPNuke. Why do this? Simply stated, it makes upgrading and modifying both pieces of software much simpler.
Standard disclaimer: Before you start any of this:
Backup your existing phpnuke database.
Backup your existing phpnuke directory.
For new PHPNuke / BB2Nuke installations Those with existing phpNuke installations, read this [nukedgallery.net] post.
Install phpNuke as you normally would.
Make the following database modifications for phpNuke:
When you install phpNuke for the first time, it creates lots of tables with names in the following format:
Code: › <prefix>_bbXXXXX
phpBB uses tables with the format of:
Code: › <prefix>bb_XXXXX
So, when you first install phpNuke, you will need to delete all of the tables of the format <prefix>_bbXXXXX. Below is a list of the tables:
#
#-----[ FIND ]-----------------------------------
#
$db->sql_query("DELETE FROM ".$user_prefix."_users_temp WHERE time < $past");
$sql = "SELECT * FROM ".$user_prefix."_users_temp WHERE username='$username' AND check_num='$check_num'";
$result = $db->sql_query($sql);
#
#-----[ AFTER, ADD ]-----------------------------------
#
$uid_result = $db->sql_query("SELECT MAX(user_id) AS total FROM ".$user_prefix."_users");
$uid_row = $db->sql_fetchrow($uid_result);
$user_id = $uid_row['total'] + 1;
#
#-----[ FIND ]-----------------------------------
#
$row3 = $db->sql_fetchrow($db->sql_query("SELECT COUNT(user_id) AS userCount from $user_prefix"._users." WHERE user_regdate LIKE '$curDate2'"));
$userCount = $row3['userCount'];
$row4 = $db->sql_fetchrow($db->sql_query("SELECT COUNT(user_id) AS userCount FROM $user_prefix"._users." WHERE user_regdate LIKE '$curDateP'"));
$userCount2 = $row4['userCount'];
#
#-----[ REPLACE WITH ]-----------------------------------
#
$sql = "SELECT COUNT(user_id) AS userCount from $user_prefix"._users." WHERE FROM_UNIXTIME(user_regdate,'%b %e %Y') LIKE '$curDate2'";
$result = $db->sql_query($sql);
$row3 = $db->sql_fetchrow($result);
$userCount = $row[userCount];
$sql = "SELECT COUNT(user_id) AS userCount FROM $user_prefix"._users." WHERE FROM_UNIXTIME(user_regdate,'%b %e %Y') LIKE '$curDateP'";
$result = $db->sql_query($sql);
$row4 = $db->sql_fetchrow($result);
$userCount2 = $row[userCount];
#
#-----[ SAVE & CLOSE ]-----------------------------------
#
/admin.php ?>
The following modifications are made in admin/modules/users.php:
#
#-----[ SAVE & CLOSE ]-----------------------------------
#
/admin/modules/users.php ?>
That is all the file mods that need to be made for stock phpNuke files.
Next is the installation and modification of phpBB.
Change the $user_prefix in <phpNuke_root>/config.php to look like this:
$user_prefix = "nukebb";
(You may have a different portion for the "nuke" part. The important thing here is that you have "bb" on the end of it.)
Install phpBB, making sure to specify the proper database name, database login, and password (the same as your phpNuke database). Make sure that your database prefix is the same as the $user_prefix for your phpNuke installation.
Delete the <prefix>bb_users table just installed by phpBB, and rename your <prefix>_users table (from phpNuke) to <prefix>bb_users.
Rename your <prefix>_users_temp table (from phpNuke) to <prefix>bb_users_temp. There are no further database modifications to be made.
Now comes the fun part, modifying the phpBB files to work with PHPNuke. Luckily, most of the modifications are minor. These are the only modifications you will have to repeat when/if you upgrade your phpBB installation. If you are using the stock subSilver template in your forum, it is important that you do NOT overwrite your templates directory during an upgrade of phpBB. This may look like a lot of modifications, but most are only one or two lines. With a heavily modified installation, such as the one here at NukedGallery.net, the additional time required to perform these alterations is trivial compared to the time required to re-implement all of the other modifications already in place.
PHP: › <?php #
#-----[ OPEN ]-----------------------------------
#
phpBB2/admin/pagestart.php
#
#-----[ OPEN ]-----------------------------------
#
phpBB2/templates/subSilver/login_body.tpl
#
#-----[ FIND SIMILAR ]---------------------------
#
<form action="{S_LOGIN_ACTION}" method="post">
#
#-----[ CONFIRM ]-----------------------------------
#
You MUST confirm that there is no "target="_top"" statement in this form tag. If there is, you MUST remove it.
#
#-----[ CONFIRM ]-----------------------------------
#
You MUST confirm that the name of the "password" variable is "user_password". If it is no "user_password", you MUST change it to "user_password".
#
#-----[ SAVE & CLOSE]-----------------------------------
#
All Files ?>
All of these modifications get phpBB and phpNuke to share the same user database and recognise when users are logged in. You can now view your forum and log in/out via the forum or phpNuke. But, you may notice that it doesn't have the phpNuke header and footer, and some colors or fonts might be wrong.
For the header (the part of the page at the top with your site logo) and the footer (the bottom of the page, with all of the boring copyright information) to match your phpNuke site, you must make a few minor modifcations to the following files:
The easiest way for your phpBB footer to match your phpNuke footer is to view the html source of your phpNuke page. Scroll down to the part that contains your footer code and just copy and paste the html source into your overall_footer.tpl file. Please do the wonderful developers at phpBB the courtesy of leaving their copyright information intact.
Making your header match your phpNuke header is a little more complicated. You cannot have any database driven information in your overall_header.tpl file (no $db->sql_query statements). So, you'll have to keep a basic navigation menu at the top, similar to the one you see here. To add your header, put your desired html code in overall_header.tpl after the <body> tag.
Lastly, the fonts and background colors. Those are controlled via CSS, and are either located in a separate CSS file in your template directory (ie /phpBB2/templates/fisubsilver/fisubsilver.css), or both in the overall_header.tpl file and a separate CSS file (as is the case with the default subSilver template). You will want to add/modify code to these CSS files to create fonts, etc to your liking.
Line : 218
File : /home/jamiea64/public_html/tnbb2/modules/Forums/common.php
As far as I can tell, all other nuke things work fine... I haven't missed any sections, yet it still seems to want to use the modules/forum/ integrated forum, rather than my external one... How do I change that?
To test the forum, I manually switched (using URL) to it... I experienced some problems there also... I can't log in... When I try to log in it comes up with this:
Login Error wrote: › Not Found
The requested URL /tbbn/modules.php was not found on this server.
Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request.
I don't know why it's going to /tbnn/, as my php is in tnbb2... But I don't know why it can't go to the right place... Have I done something wrong?
Posted: Tue Jun 14, 2005 3:32 pm Post subject: Re: Standalone phpBB2 integration within PHPNuke
When I try and access the forums (either through nuke or through the URL) I get this message come back:
Quote: › Hacking attempt
Fatal error: Call to undefined function: session_pagestart() in /home/jamiea64/public_html/tnbb2/modules/Forums/index.php on line 31
Joined: Jan 31, 2005 Posts: 37 Location: Forest Falls, CA; USA
Posted: Fri Jun 17, 2005 1:06 am Post subject: Re: Standalone phpBB2 integration within PHPNuke
So THAT is why we get the error/debug messages RE: nuke_bbconfig not existing, etc.?
OK, so then the question for those of us who don't know how to properly link modules.... is there a suggestion as to the best (i.e., most functional) way to do this? (I honestly don't remember that being addressed in the tutorial, and I went over it extensively several times.)
Posted: Fri Jun 17, 2005 11:46 am Post subject: Re: Standalone phpBB2 integration within PHPNuke
I wanted to double check with this.
I wanted to convert my site from the regular html to a CMS. I tried postNuke out...wasn't so pleased with it. Tried Mambo...nothing works on that thing.
My last resort is phpNuke. I have a phpbb forum with 592 members, 60813 articles, the database is over 15MB, and it's been around for about 2-3 years now (updated to 2.0.15). The theme is custom made by me and it's heavily modded. When I tried to go with postNuke, there was all of this pressure and suggesting for everyone who had phpbb to switch to their pnphpbb (is that right?). I don't want to switch. I'm quite happy with phpbb, you know? I've gotten used to the coding and the way it works.
What I wanted to do with any CMS I use (which looks like it might be phpNuke), is make it so that phpbb is a seperate entity from Nuke--in the way that I can leave the style, database, and mods alone and updated it by itself, but have Nuke share the user information.
Having people log in on both might turn quite a few off, you know?
After reading this, I want to double check that this is what it will do.
Another question is: Do I really have to edit the header and footer templates for phpbb? Can I leave that part alone (at least for now)?
Dumb question time: Once (or if) phpNuke will share the users from phpbb, can I add other features to Nuke--like a gallery--and it will still work properly with the users?
Last stupid question, I swear!: Which version of phpNuke should I use? I see the 6.5 enhanced bundle, but would that really work with what I want to do?
Joined: Jan 31, 2005 Posts: 37 Location: Forest Falls, CA; USA
Posted: Fri Jun 17, 2005 1:31 pm Post subject: Re: Standalone phpBB2 integration within PHPNuke
Neserit.... I got a "remark" (in jest mind you, not insulting) about "dumb" questions. (My word was "stupid" but it's all the same.) So be careful with your wording here, or you might get teased like I did.
From what Dari has told me before, and I believe that it's mentioned somewhere in the tutorial but don't quote me on that one, is that the whole idea behind doing the file edits is that you CAN add mods/hacks to your phpBB and modules to Nuke without it affecting your users, etc. Even if you upgrade to a newer version of phpBB and/or Nuke, you'd only have a few file edits to do to KEEP IT integrated, so that's a plus too.
I did use PHP-Nuke before I went to standalone phpBB. I liked PHP-Nuke a lot, so did my site's members. Not that it's the best thing in the world, but when one doesn't know enough PHP to create their own CMS from scratch OR simply doesn't have the time to do so, IMNSHO PHP-Nuke is the best one to use. (I didn't like PostNuke, PHPWiki, Xoops, etc., as I'm too new to PHP and they're not as user friendly RE: figuring out how to configure/use functions as PHP-Nuke is.). The only thing about Nuke (any CMS for that matter) I didn't like is that VERY FEW phpBB mods/hacks will work with Nuke's "version" of phpBB because it's ported.... lots of coding changed to make it a forum inside of Nuke rather than integrating it with standalone (which would have been the smart thing to do to begin with, but I didn't program it. LOL!). So I "dumped" Nuke altogether and switched to standalone phpBB so that I could use any mod/hack I wanted. (If I'm going to build a site, albeit from scratch or from starting with an open source CMS or forums prog, I still want CONTROL over what my site does and how it appears, etc.!)
Dari's tutorial is what made me finally decide that yes, it's time to go back to using Nuke so that I can use features they have that standalone phpBB doesn't, and yet still have my phpBB standalone so that I can use its features to its fullest extent as well. Balance and all that. Well, the integration just wouldn't work for me, but I'm 99.99999999999999% positive that it was directly caused by my phpBB being premodded.... it's not only so crammed with mods that it's absolutely ludicrous, but also so many lines of code are changed including how the files and SQL handle posts, PM's, etc., that it not only doesn't want to respond to any integration but it also prevents me from installing mods that I DO want, I can't even uninstall mods they've got on there that no one uses and therefore is a waste of space and bandwidth, etc., because they've bastardized the coding so much that you simply can't uninstall THEIR mods, and at least half the time install your own mods, without the entire board going POOF! gone and having to restore the backed up files and database just to get the site to reappear! SOOO.... I'm in the process of "dumping" my premodded phpBB (long story LOL) but before that I've got a "vanilla" installation of phpBB in a "test" directory that I'm modding the way I want it, which will take some time of course, before switching from the premodded phpBB to MY modded phpBB.
Speaking of which: my version of phpBB is 2.0.15 and Nuke's latest is 7.7(unless 7.8 has come out in the last month anyway, LOL) .... I've already listed in these forums the difference between 7.2 edits and 7.6, I'm sure it won't be much (if at all) different with 7.7 though. (If you get the latest PHP-Nuke at nukescripts.net, you can get it with tons of security already installed for you but it's not bastardized coding, these guys know their stuff; I always recommend nukescripts.net for obtaining Nuke as well as any initial search for modules/blocks/addon's etc. [well, I don't know about the gallery provided here as I haven't used Nuke in over a year so therefore haven't tried out Dari's version of the gallery] as they fix what php-nuke.org puts out as a "finished" project but turns out to be so full of bugs AND security holes it's just ridiculous, not to mention unworkable functions all over the place due to sloppy coding by the "original" authors! There's "controversy" about the "author" of PHP-Nuke as it is, but there are posts/articles all over the 'net RE: this so I don't need to get into it here, plus I don't know how much is truth and how much is Urban Legend per se and/or jealous/competitive programmers, etc.)
ANYHOOO.... I've been searching for well over a year now for a way to use PHP-Nuke and standalone phpBB together, and this is the ONLY way I've ever found that'd be even CLOSE to workable: others did absolutely nothing at all except produce error after error in simply running the install files and/or updating the SQL manually. This one DOES work, I've seen too many people who use this method and are very happy with it. Like I said, I know that it didn't work for me because my phpBB is HEAVILY premodded and it won't work with anything!
So now I just have to juggle time for study, family, daily household crud we don't like to do but are forced to do anyway (LOL), work on my site, and somewhere in there still find leisure time for MYSELF to try to stay sane! But I AM going to do this integration again ASAP, on my fresh phpBB instead.
And hey, so long as you make sure you back up every file you edit BEFORE you edit it and your entire database (the database I'd back up immediately before the actual database changes take place, of course).... then the worst that can happen is that you restore your backups and then try it again a bit more slowly so as to avoid missing anything you might have missed the first time (which can be SO easy to do, no matter how experienced one is with PHP we're still human and make mistakes; even the most simple mistake and/or oversight will cause an entire project to crash, of course).
OH, and RE: having members logging onto both Nuke and phpBB simultaneously possibly being a turn off.... that's what Nuke does already (ANY form of Nuke or CMS that has forums ported into it for that matter), is log users in to the CMS and the forums both. The difference with THIS approach is that the users will simply be logged into a better format of phpBB, one that you as the admin/webmaster can control unlike the phpBB that is ported into the CMS's.
Posted: Fri Jun 17, 2005 2:35 pm Post subject: Re: Standalone phpBB2 integration within PHPNuke
Thank you so much for all of that!
I ran right over to nukescripts and got the latest version of it.
I tried other ones, just like you and--argh!!--I wanted to gouge out my eyes! Mambo is horrible! Nothing on it worked!
I did have one other question that I completely forgot.
Now, when I install the Nuke, I'll have to set up an admin account, right? I use the same name for all of my scripts. Will it get confused beacuse I have the same name in my phpbb?
Should I just use a different name to cover my butt?
Joined: Jan 31, 2005 Posts: 37 Location: Forest Falls, CA; USA
Posted: Fri Jun 17, 2005 3:12 pm Post subject: Re: Standalone phpBB2 integration within PHPNuke
NP Neserit.... I'm guessing dari hasn't been online and/or hasn't had the chance to address these things yet.... I'm no pro, I'm only going by what I've already experienced and/or read w/the tutorial. But because I'm no pro, don't take what I post as "dogma" because I'm mostly going by memory: getting it from the horse's mouth (i.e., dari or else someone who also is very knowledgable in this area) is the best route.
Read the tutorial that Dari has provided VERY carefully & extensively, and then reread it if necessary (I don't know how many times I've read it, and I've gotten a "revelation" each time by noticing something I didn't before; it's not as difficult as the tutorial appears to make it, but it's still a VERY step by step IN ORDER process).... just about any modification has to be done in the correct order to be a success, but this one is a definite.
It will tell you exactly what to do with your database RE: changes AND backup as well as keeping the phpbb_ prefixes intact until all is working properly (I believe the database "stuff" is the first step, but again don't quote me, I'm only recalling what I read before, LOL), what to do with your config.php files during installation, as well as username "stuff".... If I remember correctly, you DO make the admin name/password (etc.) the same, because it will not only be in the same database when all is finished but also the I'm pretty positive that the admin needs to be the same for Nuke and phpBB both in order to manage both without logging in to them separately. (Makes sense anyway, eh?)
Hey dari, when you're logged in again and get to read/address this....
Quote: › dari: this mod replaces your phpnuke forums, private messages, and memberlist.
andrewbelcher: Yeh, that's what I thought... But it hasn't done so... It still looks for them all under the modules sections...
dari: you have to delete those modules and hard code in the links...
andrewbelcher: When I try and access the forums (either through nuke or through the URL) I get this message come back:
Hacking attempt
Fatal error: Call to undefined function: session_pagestart() in /home/jamiea64/public_html/tnbb2/modules/Forums/index.php on line 31
dari: this REPLACES your nuke modules, you do NOT access it via forums.html.
andrewbelcher: How do I link to it then? Do I add in a link to the 'index.html' of the forum?
dari: if your new installation is in /public_html/phpBB2 then you would link to the index file in that directory.
Katatawnic: So THAT is why we get the error/debug messages RE: nuke_bbconfig not existing, etc.?
OK, so then the question for those of us who don't know how to properly link modules.... is there a suggestion as to the best (i.e., most functional) way to do this?
Well, some of us are "dummies" in this area, namely me.
Are there instuctions I/we missed in the tutorial as to how we do this (and correctly/successfully), or is this something that needs to be answered "post tutorial" so that we know exactly how to do this?
Posted: Thu Jul 07, 2005 6:16 pm Post subject: Re: Standalone phpBB2 integration within PHPNuke
ive done all this but when i go to login it just gives me a blank page,
phpnuke 7.8 and phpBB 2.0.15
ive done all the mods cant figure it out thinking about just using the nuke version..
just turned on display errors i get this:
Parse error: parse error, unexpected $ in /usr/home/flipside/www/newsite/modules/Your_Account/index.php on line 1768
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
Forum FAQ
Statistics
Search
Usergroups
(I honestly don't remember that being addressed in the tutorial, and I went over it extensively several times.)
