PHPBB 3 INTEGRATION !!!!!!!

[fsuk]

Seems silly me asking for help on my own module but has anyone else got this error in the backend:

You have an error in your SQL syntax near 'ON DUPLICATE KEY UPDATE wb_group_id = '4', active = 'Enabled'' at line 1

[fsuk]

OK it appears that a function i used requiers SQL 4 and above

[jar]

UPDATE 16/07/08 :

BOTH versions 2.6 and 2.7 are atttched to this post.
Fixed no wb groups in backend

--------------------------------------------------------------------------------------

This mod allows users of a phpbb forum to use their phpbb user name and password to login to website baker.

With this phpbb is the primary software. All the wb user preferences and controls are redundent. If the user makes changes in wb they will be overwriten next time they login. (i plan to remove the preferences menu link).

THIS WILL ONLY WORK IF PHPBB3 AND WB ARE INSTALLED ON THE SAME DATABASE
AND MAKE A BACKUP OF EVERYTHING IF YOU TRY THIS.

2.6 ONLY:
All that needs to be done is for the class.login.php (see attatched) to be uploaded to replace the one in the frameworks folder.

Then you must edit the file replacing all instaces of phpbb3_users with the name of your phpbb users table.
You will also need to change the group_id switch in the authenticate function to reflect your own user groups and preferences.


2.7 ONLY
New Features:
wb backend via Admin Tools
Converts phpbb groups to wb groups
Multiple Group Support
Administer group conversion via wb backend
Administrators of phpbb board automaticly get assigned to WB admin group cannot be overwritten.

Extract the zip folder then install phpbbINT CONTAINED IN wb2.7 phpbb3.zip unless SQL is less then ver 4.1 using the WB backend Module Installer
Add      define('PHPBB_PREFIX', 'phpbb_');     to the config.php file
Upload the reamaining files replacing the existing ones.
See readme and install for details.

NOTE: If a user trys to login before their group is set to Auto Active then the user name will remain disabled until it is enable from the Access menu, even after the group is set to Auto Active

NOTE: If you are using an SQL version previous to 4.1 then you need to use the phpbbINT.zip file attatched instead of the one in the main zip
-------------------------------------------------------------------------

I finaly did it, nearly a weeks work spending all my time learning the in's and outs of wb and phpbb.

How have i done this?

Well firstly i've copied a few functions from phpbb3 specifically
phpbb_check_hash
_hash_encode64
_hash_crypt_private

When a user trys to login to wb a query copies the data for the phpbb user table to the appropriote fields in the wb user table in the authenticate function

Now phpbb uses its own form of encryption which is why i've had to copy some funcitons.

Then it uses the phpbb_check_hash function to check the password in the authenticate function as opposed to using the wb authenthicaiton.

What do you think?

this is just for users ??
the forum files where is it?

how i install the forum ?
in a folder ..  /forum ?

[fsuk]

You can download phpbb 3 here: http://www.phpbb.com/downloads/

You can intall the forum wherever you want but they must share the same database.

All other files are attatched to the first post. You want the middle attatchment.

This mod dosn't integrate them visualy but integrates the User Accounts (User name, password, email address)

As of yet the login isn't integrated so you have to login to each system seperatly, but you use the same user name/password

[cnwb]

I have Downloaded and will check out this out in the next couple days..

Thank you for your hard work!

JohnP

[iyre]

doesnt work for me. using mysql/php v5.xx and phpbb3. Try to install module, and get a blank screen.

[lavric]

Hey fsuk!
Adore your work.
But have some questions about the module:
1. It said that syncronised all the WB accounts, but I don't see them in PHPBB...
2. And also the accounts lost access to WB (except root admin).
3. Tell me which way it sync accounts WB-->PHPBB or PHPBB-->WB
4. And what should I do to completely disconnect WB and PHPBB (if something happens)

[fsuk]

1)
What happens is that when a user tries to login to WB it first searchs the PHPBB user table for a matching username and if found copies the users details from PHPBB to WB and then logs in as normal.

If the username exists in WB and PHPBB it will be overwriten.
If it dosn't exist in WB or PHPBB then the user can't login
If it dosn't exist in WB but does in PHPBB a new user will be created in WB and given the user group(s) as specified in the admin interface

3)
(so basicly PHPBB --> WB)

2)
Part of this intergration is altering the way WB verifys passwords so that it can verify passwords encrypted using PHPBBs method. Unfortunatly this overrides WB's verification so after the install WB won't recognise accounts created in WB. (to prevent total loss of access once linked PHPBB Admin's are automaticly made WB admins)

You need to make sure that in the WB backend for this module (Admin Tools > PHPBB Integration) that you have paired the WB usergroups with the PHPBB usergroups and checked Auto Active.

eg:
You can set Moderators in PHPBB become Editors in WB and the accounts are Auto Active (accounts not disabled)

If you dont set these group pairings when a user tries to login the user details will be copied but they will not be assigned a WB group and the accounts will be disabled.

Note: If a username has been created in WB and has been set as disbabled by default the account needs to enabled in the Access settings even if a group pairing in the WB PHPBB Int admin settings is set to enabled afterwards

4) Part of the integration is altering the encryption used to match PHPBB, if you where to simply replace the changed file and unistalled the backend module then WB would not be able to verify the encypted passwords in the DB.

I have never developed an unistalll method hence why i urge people to backup before trying this (and this is still really a beta, i've been too busy recently to develop it further).

OK to uninstall you could try this but i dont know if it will work and you will lose all existing WB user passwords.

1. In WB backend create a new administrator user (REMEMBER THE USERNAME AND PW)
2. Uninstall the WB PHPBB INT backend module
3. Replace all the files changed in the intergration installation with the original WB ones
4. Login to the WB backend using the new user you just created.
5. Either delete all the other users or set new passwords for them.
(This needs to be done as WB wont be able to verify the existing passwords in the DB as they are encrypted using a different method.)

Nothing needs to be done with PHPBB as it remains unaffected by the integration.

I hope I've answered your questions. Good luck

[lavric]

Thanks for opening eyes explanation 

[fahad4x4]

Thank you for your good work!   

[ahikmahin]

hi there...

today i installed this module...

but.. after install this nothing happen.. 

allthough... now new user cant login after registration!!! 

old WB users can login .... but new users registered with wb cant login!!! even if they request for new password it says "there is no such email in DB " ..but.. when user registered they got auto email with username&pass

so ..strange!!!

and... auto integration doesnt work for me.... user registration on phpbb3..doesnt show in wb!!! or wb users cant login phpbb3!!!

please help me.... Its urgent needed... 

[fsuk]

Did you do the following:
A) Replace login function files with the ones povided
B) Install the backend module
C) Using the backend in WB tools set the group conversions and set the users of these groups to be automatically active and not disabled.

[fsuk]

The fact that your old wb users can login suggests that the you didnt replace the function files

[lavric]

Hello Fsuk!

It was the trouble with login. After all I added your code about group_id to class.login.php and it started to work.

But there is other problem I suffer from. The WYSIWYG editor and other modules doesn't seem to know I'm logged on

Why it could be possible? I know it connected with group_id but don't understand how and also donno what to do...

Save me!

PS Just tried manually to make group_id similar phpbb and wb. doesn't work either.

[fahad4x4]

Hi

Do this work with WebsiteBaker 2.8

[kweitzel]

Hi

Do this work with WebsiteBaker 2.8

you don't need to use a large font to make clear what you would like to know ... why don't you just test it???

cheers

Klaus

[fsuk]

At present im not using 2.8 RC, but when its relased stable and i start to upgrade my sites i will have a look at getting it working and post an update. At the moment im a little busy after starting a new job with a major tech company 


lavric from the sounds of it your running on 2.6? Check you've got the right version, the 2.7 version should'nt need you to directly modify any files except the config.php and replace some existing files.

[fahad4x4]

At present im not using 2.8 RC, but when its relased stable and i start to upgrade my sites i will have a look at getting it working and post an update. At the moment im a little busy after starting a new job with a major tech company 


lavric from the sounds of it your running on 2.6? Check you've got the right version, the 2.7 version should'nt need you to directly modify any files except the config.php and replace some existing files.

Thank you for your answer and waiting for the Stable version

[fahad4x4]

hi

Been issued WB 2.8 released

We are waiting for Upgrading Model

Thank you for your support for us users phpBB3

[fahad4x4]

hi

Been issued WB 2.8 released

We are waiting for Upgrading Model

Thank you for your support for us users phpBB3

I still wait for your reply

[orko3001]

Any news on 2.8 integration? Just wondering if anyone has got anywhere.

Cheers

[fsuk]

At present I have no plans to develop it further, please feel free to do so yourself or start a new thread requesting this development.

[Asmodaios]

Is there any update for PHPBB3 integration for wb 2.8?

Cheers from germany,
Julian

[fsuk]

No sorry.

At present I have no plans to develop it further, please feel free to do so yourself or start a new thread requesting this development.

[Argos]

There's no need to ask for updates all the time. I'm 100% sure we will be informed if there would be an update...