Joined: Mar 03, 2003 Posts: 6287 Location: Washington Township, NJ, USA
Posted: Tue May 03, 2005 8:36 pm Post subject: Standalone phpBB2 integration within PHPNuke - Part II
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 (9 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 existing PHPNuke / BB2Nuke installations Portions of this are taken from phpBB.com [phpbb.com]
This is a bit trickier, as most of the required phpBB tables are already created by phpNuke, just with a different name. It is crucial that you back up your database before doing this.
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
These are the tables that store all of your posts, private messages, etc. Below is a list of the tables:
You may have more or less, depending on your version of PHPNuke (this list is from phpNuke 7.2).
You want to keep the contents of these tables intact during this conversion.
Install a fresh copy of phpBB, making sure to specify the proper database name, database login, and password (the same as your phpNuke database). Leave the phpBB prefix at it's default value.
Drop the following tables created by the phpBB installation:
Rename the phpNuke database tables that correspond to the above tables to their phpBB counterparts. For example, <prefix>_bbtopics would get renamed to <prefix>bb_topics.
Rename the <prefix>_users table to <prefix>bb_users.
Rename your <prefix>_users_temp table (from phpNuke) to <prefix>bb_users_temp.
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.)
This step is crucial. You must edit your phpBB config.php file and change the prefix from phpbb_ to <nuke_user_prefix>_.Don't forget to include the underscore character ( _ ) after your phpNuke user prefix.
Do the following in the <prefix>bb_users table
Next, you will need to convert the user_regdate from the phpNuke "pretty-print" format to unixtime. The following php script will perform the conversion for you. (Note that this script will only function if your regdates are in the format "MMM dd, YYYY", for example "Nov 10, 2003") Once you've run this script, change the user_regdate from varchar(20) to int(11).
PHP: › <?php
require_once("mainfile.php");
global $user_prefix,$db;
Simply put this script into a file called "changetime.php" in your phpNuke root directory and view it through your browser for the update to take place.
Change the user_id field from int(11) to mediumint( and remove the autoincrement property.
Change the Anonymous user to have a user_id of -1.
Make the following file modifications in your PHPNuke installation.
The following modifications are done inside Your_Account/index.php:
PHP: › <?php #
#-----[ OPEN ]-----------------------------------
#
modules/Your_Account/index.php
#
#-----[ FIND - THERE ARE 2 INSTANCES OF THIS]----
#
$sql = "SELECT * FROM ".$prefix."_bbconfig";
$result = $db->sql_query($sql);
#
#-----[ REPLACE BOTH INSTANCES WITH ]------------
#
$sql = "SELECT * FROM ".$prefix."bb_config";
$result = $db->sql_query($sql);
#
#-----[ 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.
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.
Joined: Jan 31, 2005 Posts: 37 Location: Forest Falls, CA; USA
Posted: Wed May 04, 2005 10:59 pm Post subject: Re: Standalone phpBB2 integration within PHPNuke - Part II
Hiya Dari,
Just a quick note, as I'm editing some of the files right now before the movie my honey and I are going to watch begins....
BTW, I'm using PHP-Nuke 7.6 (with the chatserv security patch 2.9; don't know if THAT part matters).
Now instead of admin/modules/users.php(that file no longer exists in 7.6), you'd now use the file modules/Your_Account/admin/index.php .... the find/replace is identical in that file to your tutorial you have posted for Nuke 7.2 using the former file.
I'm sure that sooner or later you'll want to update your tutorial for newer versions of Nuke, so figured I'd just post that here so you'd know already.
If/when I come across any other differences that I find and solve myself, I'll let ya know.
OH, being that it's a different Nuke version, there were a couple of "finds" that were slightly different.... stupidly I didn't take note of them like I normally do as I'm in a bit of a hurry tonight. However, it'd be VERY simple for me to find them and let you know what the "find" would be for 7.6 vs. 7.2 Nuke.
Joined: Jan 31, 2005 Posts: 37 Location: Forest Falls, CA; USA
Posted: Thu May 05, 2005 10:29 am Post subject: Re: Standalone phpBB2 integration within PHPNuke - Part II
WHEW! I feel better now.... After I posted last night I logged off the PC and watched a movie, then as I was dozing off I suddenly felt a bit of an urge to come back and either delete or edit my post as I didn't want to step on toes or anything. Which I know is ridiculous in most forums like this, because users help when they can: not only the admins and/or original authors. It's how community help works really.... but I've seen some help type forums where the admins or authors didn't like being told "such and such" is different, etc. (Over-inflated egos IMHO; I personally would want help and even corrections if my code IS different and/or has errors, that's how modding improves anyway. Here, however, it's not like that. It's just people helping people, the way community help forums should be!)
The way I see it is that someone here has gone out of their way to be of help to others with what can be such a difficult project, and so since I have a newer version of both Nuke and phpBB than when the tutorial was written and of course there are always upgraded versions when improvements and stronger security are implemented, I thought I'd try and be helpful by taking note of what changes there are. (I normally do take note of differences in file edit instruction files anyway, so that if I'd have to reinstall for any emergency reason and need to reinstall mods then I want to just quickly find what I need to find rather than searching for the differing lines all over again.)
ANYHOOO.... rather than putting up 100 posts RE: what turns out different with the newer versions each time I come across one, I'll instead take note of each difference (there've only been a few so far; I've done the edits for Nuke but not phpBB yet, that's my next step) and put all of the differences I've found in one post. AND also I'll make note of the fact in the post that my phpBB is modded quite a lot so some "find" changes would be different from straight phpBB whereas others will still be the same. (I go through that a lot when I mod my phpBB already, so I know that some "finds" will be different and some will be the same.) It's just more of a "help" to you when you decide to implement for newer versions; after all, I need to take the notes for myself anyway, so it's not any more difficult for me to list them in a post when I've already documented them for my own use.
OH, BTW! Something I noticed in your tutorial immediately.... I think it's the first mod/hack instruct that had correct spelling and grammar throughout, which has always been a "peeve" of mine per se. I mean, when coding one HAS to make sure that every word and symbol, etc., is spelled 100% correctly, then the exact same authors will use some vocabluary and spelling that is a cross between English and I don't know what! Granted, I know that many authors don't speak English so of course the translation would be different, but many of the mod/hack authors DO speak English as their first language and I find myself correcting the spelling and grammar in the instruction files. (My own copies, I don't go telling the authors that they're awful at spelling and grammar. I'm not that rude! LMAO)
Well, sorry to have rambled so much, and hope I made some sense here.... haven't made my coffee yet so I'm still extremely disoriented. Chronic insomnia sucks!!!
Joined: Jan 31, 2005 Posts: 37 Location: Forest Falls, CA; USA
Posted: Thu May 05, 2005 3:46 pm Post subject: Re: Standalone phpBB2 integration within PHPNuke - Part II
NOTE: I've used BBcode to make the differences show up asbold & redin this post so they'd be easy to see.... so be careful not to simply click on "quote" in my post and paste the changes without first finding and deleting the BBcode!
That's also why I'm posting this in "regular" format, rather than using either [code] or [php] BBcode, so that the portions I've made bold will show up as such.
OH, and any differences I've posted that are NOT marked in bold/red means that the "find" WAS different but I didn't have the time to examine exactly what was different.... sorry, but I really need to get off of the PC and start today's studying.
~~ Kat ~~
These are all of the differences I've found....
The PHP-Nuke differences definitely apply to version change, as it's a FRESH install and I haven't modified a thing before this integration attempt.
I also want to make it completely clear:
The phpBB differences could be due to version change OR due to my present modifications; or both.
ANYHOOO.... Hope this might help for those who have Nuke 7.6 and phpBB 2.0.14
And once again, I'm NO programmer! I simply compensate when instructed to find a line of code and it's different in my file/version, etc. So this should definitely be looked over by someone who knows a lot more about PHP than I do!
Therefore, feel free to edit this post to your liking so that everything is correct AND so that the format/size of the post fits better in another way than what I've formatted here.
(NUKE FILE EDITS):
#
#-----[ OPEN ]-----------------------------------
#
modules/Your_Account/index.php
#-----[ FIND (Nuke 7.2) ]-----------------------------------
$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);
#-----[ FIND (Nuke 7.6) ]-----------------------------------
$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;
#
#-----[ OPEN ]-----------------------------------
#
admin.php
#-----[ FIND (Nuke 7.2) ]-----------------------------------
$sql = "INSERT INTO ".$user_prefix."_users (user_id, username, user_email, user_website, user_avatar, user_regdate, user_password, theme, commentmax, user_lang, user_dateformat) VALUES (NULL,'$name','$email','$url','$user_avatar','$user_regdate','$pwd','$Default_Theme','$commentlimit','english','D M d, Y g:i a')";
#-----[ FIND (Nuke 7.6) ]-----------------------------------
$db->sql_query("INSERT INTO ".$user_prefix."_users (user_id, username, user_email, user_website, user_avatar, user_regdate, user_password, theme, commentmax, user_level, user_lang, user_dateformat) VALUES (NULL,'$name','$email','$url','$user_avatar','$user_regdate','$pwd','$Default_Theme','$commentlimit','2','english','D M d, Y g:i a')");
#-----[ REPLACE WITH ]-----------------------------------
$sql = "INSERT INTO ".$user_prefix."_users (user_id, username, user_email, user_website, user_avatar, user_regdate, user_password, theme, commentmax, user_level, user_lang, user_dateformat) VALUES (2,'$name','$email','$url','$user_avatar',$user_regdate,'$pwd','$Default_Theme','$commentlimit','2','english','D M d, Y g:i a')";
#-----[ FIND (Nuke 7.2) ]-----------------------------------
$db->sql_query("INSERT INTO ".$user_prefix."_users (user_id, username, user_email, user_website, user_avatar, user_regdate, user_password, theme, commentmax, user_level, user_lang, user_dateformat) VALUES (NULL,'$name','$email','$url','$user_avatar','$user_regdate','$pwd','$Default_Theme','$commentlimit', '2', 'english','D M d, Y g:i a')");
#-----[ FIND (Nuke 7.6) ]-----------------------------------
$sql = "INSERT INTO ".$user_prefix."_users (user_id, username, user_email, user_website, user_avatar, user_regdate, user_password, theme, commentmax, user_level, user_lang, user_dateformat) VALUES (2,'$name','$email','$url','$user_avatar',$user_regdate,'$pwd','$Default_Theme','$commentlimit','2','english','D M d, Y g:i a')";
#-----[ REPLACE WITH ]-----------------------------------
$sql = "INSERT INTO ".$user_prefix."_users (user_id, username, user_email, user_website, user_avatar, user_regdate, user_password, theme, commentmax, user_level, user_lang, user_dateformat) VALUES (2,'$name','$email','$url','$user_avatar',$user_regdate,'$pwd','$Default_Theme','$commentlimit','2','english','D M d, Y g:i a')";
$db->sql_query($sql);
#
#-----[ OPEN ]-----------------------------------
#
(Nuke 7.2): admin/modules/users.php
(This file no longer exists in 7.6; I don't know which version changed this, however!) (Nuke 7.6): modules/Your_Account/admin/index.php
(This is the file you'd edit instead.)
(File finds/edits are the same, it's only the file itself that has changed.)
(PHPBB2 FILE EDITS):
#
#-----[ OPEN ]-----------------------------------
#
phpBB2/includes/constants.php
#-----[ FIND Original tutorial instruct ]-----------------------------------
define('DELETED', -1);
define('ANONYMOUS', -1);
#-----[ FIND ]-----------------------------------
# My phpBB IS modded, but users should note differences
# as many people do add mods; i.e., MINE is:
define('DELETED', -1);
define('ANONYMOUS', -1);
#-----[ REPLACE WITH ]-----------------------------------
# Simply take note of your values before replacing; it could be the same as the original tutorial. i.e., MINE would be:
define('DELETED', -1);
define('ANONYMOUS', -1);
#-----[ FIND ]-----------------------------------
# My phpBB IS modded, but users should note differences as many people do add mods;
# i.e., MINE is:
# (In other words, the "find" appeared to be the same except for the modded add-on in the middle;
# just something to watch for if your board is modded.)
//
// Generate logged in/logged out status
//
if ( $userdata['session_logged_in'] )
{
$u_login_logout = 'login.'.$phpEx.'?logout=true&sid=' . $userdata['session_id'];
$l_login_logout = $lang['Logout'] . ' [ ' . $userdata['username'] . ' ]';
if ($board_config['points_browse'] && !$post_info['points_disabled'] )
{
$points = $board_config['points_browse'];
#-----[ REPLACE WITH ]-----------------------------------
# MY replacement would keep the add-in for the modded portion.
#
//
// Generate logged in/logged out status
//
if ( $userdata['session_logged_in'] )
{
$u_login_logout = '/modules.php?name=Your_Account&op=logout&redirect=phpBB';
$l_login_logout = $lang['Logout'];
$l_user = "Hello, ".$userdata['username']."! ";
if ($board_config['points_browse'] && !$post_info['points_disabled'] )
{
$points = $board_config['points_browse'];
#
#-----[ OPEN ]-----------------------------------
#
phpBB2/includes/sessions.php
#-----[ FIND ]-----------------------------------
function session_pagestart($user_ip, $thispage_id)
#-----[ FIND ]-----------------------------------
# (This could be due to my mods, or it could be due to phpBB now being version 2.0.14)
function session_pagestart($user_ip, $thispage_id, $thistopic_id=PAGE_INDEX)
#-----[ REPLACE WITH ]-----------------------------------
# (The bolded code could be due the newer phpBB format,
# or it could be from a mod in mine.)
function session_pagestart($user_ip, $thispage_id, $nukeuser)
#
#-----[ OPEN ]-----------------------------------
#
viewtopic.php
#-----[ FIND ]-----------------------------------
# (This could be due to my mods, or it could be due to phpBB now being version 2.0.14)
$userdata = session_pagestart($user_ip, $forum_id, $topic_id);
#-----[ REPLACE WITH ]-----------------------------------
# (Due to either version upgrade or because my phpBB is modded):
$userdata = session_pagestart($user_ip, $forum_id, $topic_id, $nukeuser);
Posted: Thu Jun 09, 2005 4:49 pm Post subject: Re: Standalone phpBB2 integration within PHPNuke - Part II
Could I have a little help? I did all of the above and got this in return (every time I attempt to log in... Not tried anything else yet, but this has cropped up):
"Parse error: parse error, unexpected $ in /home/jamiea64/public_html/testnukebb/modules/Your_Account/index.php on line 1717"
The thing that really throws me is that line 1717 is the last line in index.php, and consists only of "?>"...
Any help would be greatly appreciated! It's using phpBB2 2.0.13 and phpNuke 7.6 (I followed all the 7.6 specific commands)
Joined: Mar 03, 2003 Posts: 6287 Location: Washington Township, NJ, USA
Posted: Fri Jun 10, 2005 6:11 am Post subject: Re: Standalone phpBB2 integration within PHPNuke - Part II
it means:
1. there is whitespace after the ?> . if so, delete it (and any blank lines after it).
2. there is a lingering $ somewhere in the code that doesn't belong....
Posted: Fri Jun 10, 2005 10:41 am Post subject: Re: Standalone phpBB2 integration within PHPNuke - Part II
I did that, but unfortunately to no avail... I can't see any stray $ signs... Everything is exactly as the above modifications say (I even re-did them to no avail). Any other ideas?
Here is the full code incase that will help... Unfortunately it's quite big... So I don't know if it will help really...
Hmmm... OK - I can't work out how to do that php thingy... How can I do that? As I don't want to post 1700 lines unless it's default is collapsed
Joined: Jan 31, 2005 Posts: 37 Location: Forest Falls, CA; USA
Posted: Fri Jun 17, 2005 12:48 am Post subject: Re: Standalone phpBB2 integration within PHPNuke - Part II
I kept getting that same error/debug message myself, whether I used my current phpBB & Nuke 7.6 or instead used the premodded distribution that was on this site once upon a time and disappeared when the URL changed. I got tired of banging my head on my desk, I don't like headaches very much. So I put the phpbb2/Nuke Integration on the back burner for the time being.... school has to come first whether I like it or not. (LOL) But I'm still going to work this out if it kills me, as soon as I have the time and the focus.
BTW Dari, I believe I still have that .zip saved on a CD that you'd distributed when I'd first found your site and the integration instructions/files (phpBB 2.10 & Nuke 7.4), if it's missing due to URL/database (whatever) changes per chance.
Posted: Mon Jul 11, 2005 9:03 pm Post subject: Re: Standalone phpBB2 integration within PHPNuke - Part II
Ok I have tried this like 100 times, both new install and existing install. I have had no success with either. I need to post some help now, I am getting fed up.
Here is the error I am getting.
phpBB : Critical Error
Error creating new session
DEBUG MODE
SQL Error : 1054 Unknown column 'session_admin' in 'field list'
Joined: Jan 31, 2005 Posts: 37 Location: Forest Falls, CA; USA
Posted: Mon Jul 11, 2005 9:12 pm Post subject: Re: Standalone phpBB2 integration within PHPNuke - Part II
(I ran across this problem myself when phpBB's version 2.0.15 came out.)
That's because in phpBB's version 2.0.15 and now 2.0.16 the phpbb_sessions table has changed, added "sesson_admin" into the tables which "includes/sessions.php" calls for.....
The table info is now as follows (copied from MY database, so of course take note of the prefix if you use a different one!.... also, MY board is premodded for now until I get my "vanilla" board modded enough to replace the crappy coding that the premodded board has LOL, so what you REALLY need to do is look at phpBB's installation .sql files, search for "phpbb_sessions" and look at the database formation from there):
Code: › DROP TABLE IF EXISTS `phpbb_sessions`;
CREATE TABLE IF NOT EXISTS `phpbb_sessions` (
`session_id` char(32) NOT NULL default '',
`session_user_id` mediumint(8) NOT NULL default '0',
`session_start` int(11) NOT NULL default '0',
`session_time` int(11) NOT NULL default '0',
`session_ip` char(8) NOT NULL default '0',
`session_page` int(11) NOT NULL default '0',
`session_topic` int(11) NOT NULL default '0',
`session_logged_in` tinyint(1) NOT NULL default '0',
`session_admin` tinyint(2) NOT NULL default '0',
PRIMARY KEY (`session_id`),
KEY `session_user_id` (`session_user_id`),
KEY `session_id_ip_user_id` (`session_id`,`session_ip`,`session_user_id`)
) TYPE=MyISAM;
Which version of phpBB are you using??? (It would appear to me that your sessions.php file isn't matching up with your phpbb_sessions database table.)
If you're using 2.0.15 or higher, then that's what's wrong: you're missing the `session_admin` field in the phpbb_sessions table.
If you're using a phpBB version LOWER than 2.0.15, then that field will NOT be in the phpbb_sessions table.
Hope that helps.
~~ Kat ~~
P.S.:
Refer to http://www.nukedgallery.net/posts1606-start15.html and you'll see a BIG reason why this isn't working.... easier to just give you the link than to retype all the B.S. involved with Nuke. However, whether you continue with the attempt at Nuke/phpBB integration or not, the phpBB install definitely isn't matching up with the includes/sessions.php file.... easy error, I made the same one myself as I didn't pay enough attention when I upgraded to 2.0.15
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
Granted, I know that many authors 
