vb3 to phpbb integration.

[taveren]

I was in the process of upgrading very old versions of vb (2 -> 3), PP and vbportal when I realized I really don't like vbportal and everything is coming up for renewal soon. So I decided to migrate to a phpbb2 setup instead, and thus far, I've got everything working right. All I'm missing is admin access in PP. All my photos are there and under the right users. PP recognizes me as the admin user, but doesn't let me into the admin panel.

I upgraded VB first, then Photopost, then converted my vb3 database to a phpbb installation and modified the PP database and config files to use the new phpbb database instead. I just need admin access and I'm set. Any ideas? Is there a debug mode I can put it in? The error I get when I try to access the admin panel is "You are not a valid administrator or moderator!".

[Chuck S]

Make sure your cookie settings are matched vb by default has a bb cookie prefix and to input the vblicense number into the photopost config

That should get ya set

[taveren]

Do you get tired of saying that?

I no longer wish to use vb, and am trying to migrate to phpbb2. I assume I don't need the licence, and my cookie prefix is set to phpbb2mysql.

[Chuck S]

LOL yes your backwards here.

Okay well make sure usergroups are synced and cookie settings are exactly the same

Remember in VB the admin user is usergroup 6 but in phpbb its 2 so you need to use phpmyadmin and resync those a little

[taveren]

Alright, I have some searching to do I guess. The conversion from vb3 to phpbb2 creates some new groups. Can you point me to the correct tables please? I believe PP's "usergroups" is what I want, but phpbb's tables are stumping me a bit. There's phpbb_groups, _users, _user_group... What do I need to change?

[Chuck S]

What you need to do is this

In photopost usergroups table delete all entries except 6 Administrators. Change the groupid from 6 to 2

Then in your phpbb2.php file correct a small bug I posted and then you can login as admin and import your phpbb groups into photopost. Lines 486-495 there are // in front of these lines remove them

$query = array();
$query[] = "INSERT INTO {$Globals['pp_db_prefix']}usergroups VALUES ('1','Anonymous','','','','','','',0,0,0,0,0,0)";
$query[] = "INSERT INTO {$Globals['pp_db_prefix']}usergroups VALUES ('2','Admin',1,1,1,'','','',1,1,1,1,0,1)";
$query[] = "INSERT INTO {$Globals['pp_db_prefix']}usergroups VALUES ('3','Regular Users','',1,1,'','','',1,1,0,1,0,0)";

for ( $x=0; $x < count($query); $x++) {
$iquery = $query[$x];
$setup = mysql_query($iquery, $link);
if ( !$setup ) print "<b>Error: ".mysql_error()."</b><br />";
}

[taveren]

Great! This worked perfectly for me. I now have an admin panel and all my photos appear to be set right. Now to hack up some portals to suit my needs. Thanks.