Dolphin/ phpBB3

Has anyone fixed a database merge for Dolphin/ phpBB3?

I think if you go to PHPBB they probally in several different topics or threads have Tutorials on how to blend into a regular website ?

Hi Technoman,

I been searching since days/ month and have not found anything useful.

I once worked out where i was able to put PHPBB3 into DOLPHIN but it has been so long since that I cant remember on how to and there was a tutorial on here expling on how to .... if I find it i will let you know for sure

Thanks :-)

http://www.boonex.com/unity/forums/topic/Free-PHPBB3-and-dolphin-intigration-mod-.htm

There is no solution only talk and I got pommo of mscott and can not reach him to get a deal.

As I have heard he has retired.

2 ways:

sessions

EG code for your dev's

member.php

if ($_POST['ID'] != "")
{
$_POST['username']     = $_POST['ID'];
$_POST['password']     = $_POST['Password'];
$_POST['login']        = "Login";

define('IN_PHPBB', true);
$phpbb_root_path = (defined('PHPBB_ROOT_PATH')) ? PHPBB_ROOT_PATH : './forum/';
$phpEx = substr(strrchr(__FILE__, '.'), 1);
require($phpbb_root_path . 'common.' . $phpEx);
require($phpbb_root_path . 'includes/functions_user.' . $phpEx);
require($phpbb_root_path . 'includes/functions_module.' . $phpEx);

$id     = request_var('i', ''); $mode    = request_var('mode', '');
if ($mode == 'login') { define('IN_LOGIN', true); }

$user->session_begin(); $auth->acl($user->data); $user->setup('ucp');
$template->assign_var('S_IN_UCP', true);
$module = new p_master();


login_box_mod(request_var('redirect', "index.$phpEx"));   
}

see how the above logs you into phpbb also?


alternately, merge the DB's use the aemodue and then on join.php form add in:
function showFinishPage

after:

case 'NotSent':     $sStatusText = ('_EMAIL_CONF_NOT_SENT');       break; //failed to send conf mail
}

insert:
//vbull integrate
$sexy_dbHost="localhost";
$sexy_dbLogin="user";
$sexy_dbPass="pass";
$sexy_db="DB";
$connection=mysql_connect("$sexy_dbHost","$sexy_dbLogin","$sexy_dbPass") or die("Couldn't connect to the server.");
$db=mysql_select_db("$sexy_db", $connection) or die("Couldn't select a database.");
$sql="SELECT * FROM `Profiles` WHERE ID = '{$iMemID}'";
$sql_result=mysql_query($sql,$connection) or die(mysql_error());
while($row=mysql_fetch_array($sql_result)) {
$NickName=$row["NickName"];
$Pass=$row["Password"];

}

$vRes = db_res("INSERT INTO `vb_user` (`usergroupid`, `membergroupids`, `username`, `password`, `salt`) VALUES ('2', '2', '$NickName', '$Pass', MD5( 'crAzy' ) ); " );

mysql_close($connection);
//vbull integrate end

****NOTE**** above is how we do vbulletin, phpbb is just the same just edit above to suit $vRes line and DB connect etc./////had to get it in this way cause catching it right on join was too hard for ole dad lol

You have been around for almost 600 days so i know you know how to do the modules thingy

I believe I have these docs in my personal fix it files  on www.darrenpowless blah blah

you are an angel :-)

I should be able to manage. Thanks a lot.

I will go on it tomorrow.

mrpowless!

Where I get the following database from?

Query:
INSERT INTO `vb_user` (`usergroupid`, `membergroupids`, `username`, `password`, `salt`)

MrPowless -

In which member.php is this going in?  PHPBB3 or Dolphin?

To which database table does this go?

ok you are opting for the "merged" and use of aemodule install

you have to sit all phpbb tables inside dolhin DB with prefix phpbb_

now you will edit the line

what is the users table for phpbb? change vb_user to phpbb_users (example only)

the code I gave is for example only and has to be modified so that it sits info into proper fields in phpbb

MED...dolphin...we're assuming you will only go one way...theres a ton more to do if you want a 2 way street.

So here is what I have the PHPBB set at:

Same database as my dolphin database.  So, one database with both tables in it.

When using the included phpbb module, doing a database compare, it says the users are not in the phbb database and doesn't insert them into it.  I am guessing then that the database insert function is not automatic? Your code that you gave for the member.php is not all that clear in my eyes.  Can you clarify?

I understand that I have to sub the phpbb reference in place of the vbullietin reference, but not seeing where to add that into my member.php file.

Mrpowless - could you submit this to Boonex so that it can be a formally recognized and supported mod.  Maybe someone here could help write this up so it is easier to understand.  This has been needed for a long time.

-

Rob