Help with PHPBB linking to esyndicat auth (MySQL)

[orchie]

Tried this on Yahoo! answers but am still stuck I want to use one table for authentication between esyndicat and PHPBB, I've managed to create one database with tables from both DB's combined so esyndicat uses tables starting dir_ and PHPBB uses tables starting PHPBB_ my knowledge of MySQL is very basic, can someone take me step by step as to how I can have the username and password field in PHPBB update automatically when someone registers in esyndicat?? I know this is asking alot but any help would be much appreciated.

[Vasily B.]

what version of phpBB are you using? We used to have phpBB on our site and used simultaneous registration

Please try to add the following code in your registration code:


/** forum account adding **/
$sql = "INSERT INTO `phpbb_users` (`user_id`, `user_active`, `username`, `user_password`, `user_session_time`, ";
$sql .= "`user_session_page`, `user_lastvisit`, `user_regdate`, `user_level`, `user_posts`, `user_timezone`, `user_style`, ";
$sql .= "`user_lang`, `user_dateformat`, `user_new_privmsg`, `user_unread_privmsg`, `user_last_privmsg`, `user_emailtime`, ";
$sql .= "`user_viewemail`, `user_attachsig`, `user_allowhtml`, `user_allowbbcode`, `user_allowsmile`, `user_allowavatar`, ";
$sql .= "`user_allow_pm`, `user_allow_viewonline`, `user_notify`, `user_notify_pm`, `user_popup_pm`, `user_rank`, ";
$sql .= "`user_email`, `user_website`, `user_newpasswd`) ";
$sql .= "VALUES ({$id}, 1, '{$aName}', '{$md5pass}', 0, 0, 0, ".time().", 0, 0, 0.00, 1, 'english', 'D M d, Y g:i a', 0, 0, 0, NULL, ";
$sql .= "0, 0, 0, 1, 1, 0, 1, 1, 0, 0, 0, 0, '{$aEmail}', '{$aUrl}', NULL)";
$this->mDb->query($sql);


user correct values instead of name, md5pass, email, etc

[orchie]

Hi Simon, I'm using PHPBB 2.0.22, I've tried your code above but I get the following error:

"Fatal error: Call to a member function on a non-object in /home/justsme/public_html/register.php on line 92"

Where line 92 is, $this->mDb->query($sql); have I just missed something out do you know?

[Vasily B.]

ok try to change this line to:
$this->query($sql);

I advised for our free version

[Loren]

Has anyone used this and got it to work? Apart from you Simon, just I want get my site a bit more synchronised with my directory...

[Loren]

Bumpity bump...

Has no one done this?

I would really like some help to achieve this...Sergey or Simon can you please tell me if can use this coding with my version?

[Slava B.]

Hi there,
We have started to work on "The phpBB forum integration" feature, And I have some assertion and questions for you:
- we can change the eSyndicat registration thereby: when a visitor creates an account via eSyndiCat registration page, the same account is created in forum automatically
- we can't control the forum code upgrades (forum version upgrades), we would not like to modify forums code, that's why we offer to disable forums registration and use esyndicat registration only.
- but after registration the users can edit own accounts at the forum and in directory, separately.
- we can (I hope :) ) use one user session for directory and for forum, this implyies following: if users login to the forums they get logged in the directory area automatically.

I'm waiting for you questions and suggestions.

[DomainEngineer]

Hi there,
We have started to work on "The phpBB forum integration" feature, And I have some assertion and questions for you:
- we can change the eSyndicat registration thereby: when a visitor creates an account via eSyndiCat registration page, the same account is created in forum automatically
- we can't control the forum code upgrades (forum version upgrades), we would not like to modify forums code, that's why we offer to disable forums registration and use esyndicat registration only.
- but after registration the users can edit own accounts at the forum and in directory, separately.
- we can (I hope :) ) use one user session for directory and for forum, this implyies following: if users login to the forums they get logged in the directory area automatically.

I'm waiting for you questions and suggestions.

This is a great feature. Any updates on this?:good:

[Loren]

Domain Engineer

Sorry didn't see that you had answered me, are you asking us to choose from the list you put?

I certainly don't mind as long as it cuts down some user login.

However thinking on this, if someone wants to just be part of the forum, and not the directory, well I guess it would have to be a separate login.

If its not and is dependant on signing up to be an editor, then, and in my experience I am gonna have spammers back in my forum, not that they can do anything in my directory, but it's a bit different if they go in the forum....hmmmm <_<

[DomainEngineer]

Loren,

I think you meant someone else not me I guess.

I am just a newbie, in no shape to help out anyone :)

[Loren]

Ooops sorry Domain Engineer, I was looking at your quote when I was writing that, I meant Slava B :good:

[websmartpu]

Where can I grab the "phpBB forum integration"?

Thank you

[Slava B.]

Hello Loren,
I works with vBulliten integration now and will complete it next week, after I will start to work with phpBB, it will take about 2 weeks.

[Loren]

Cool, sounds wonderful! :forgive:

[CO2]

Erm, I joined the party late Any news on this phpbb integration yet? ;-)