Integration / Bridging ae and Vbulletin

[Prometheus]

OK.
This is going to be long so get some coffee, have shot, light a smoke or whatever you do to endure these threads.


After 3 F***ing days I finally hacked my way to getting a vb mod that works...
Kinda...These files/hacks will bridge your users into VB. (auto log them in.)
BUT...it still does not import their avatars...(I can live with that for now)
When I get that code working I will post it.
This is for 4.1.2...vb versions 3.5.4 thru 3.6.1
(you can hack this for other verions of ae by changing the tables these files look for/call)
I am working the mod for gpldate. (you'll have to pay for that one...lol)
Why VB you ask?...While phpbb is free you get what you pay for..
There is NO comparision. None. Period..
We use vb on many sites and it is just WAY too powerfull of a script not to integrate into an ae, dolphin or gpl or any other site.
Not just the hacks but ease of bridging other scripts like coppermine, wordpress, radioblog etc etc etc..
For those who know vb you know what I mean....
Anyway.. I wish that I could tell you all the changes I made to get this to work but I am just to damn tired...and quite frankly do not remember. If you want you can do a stare and compare with the originals to find the changes..
Instead I have attached the files that I changed to get it to work...
They are a hodgepodge of several files/versions.

Instuctions:

1st: Back up your db.

2nd: You CANNOT have both the phpbb.aemod and vbull.aemod installed at the same time. It will not work...Period... Tried it..Many different ways.It simply freaks.

3rd: upload vbblock.php, vblogin.php and vbregister.php to your forum root.
	(http://yourdomain.com/forum/) 

4th: Go to your aecrapworks admin panel/manage mods and delete the phpbb mod.

5th: Browse to where you downloaded the vbull.aemod.doc attachment rename it to vbull.aemod and upload it to your aecrapworks site.

6th: Hit the "Refresh" button. 
	(Note: if you have a lot of users this will take some time)

Done.

Enjoy.


Peace out.

Todd

[franklaval]

Cool thanks

nice work!!

[franklaval]

please re upload the vbull.aemod files cause it's not the god one you have to export it from the db module table for us do re import it


Thanks

[Prometheus]

Sorry about that...
Very tired that day.

Here it is rename to vbull.aemod

[franklaval]

do we have to put vbb in the same database and if not wan you go to memberlist do you see your members ??

what type of link you have made in the menu_design_xx.inc.php files for the forum??


thanks

[Prometheus]

This is modded so you have to have VB in the same database and ae No alterations were made to any other files but the ones posted. (For this portion anyway)

I have heavly modded my VB script and templates so that when you are in the forum and hit a member link it takes you to their ae profile and not the VB profile and you can send emails, kisses, and from the forum also.
If you want I and post these mods too....
The only reason I didn't it because no one seems to be using VB.. What a shame.
I have also installed coppermine and wordpress and bridged then into VB.
Meaning when you log in to my dating site you are automatically logged into vb and coppermine...and if you are in the gallery and you click a member name link there it also takes you to their ae profile...
Just let me know if you are using any of these addons/scripts and I will take the time to put together the mods for you...

Check out my site and cruse thru the forum and photo gallery and you will see what I am talking about.


Todd

[franklaval]

Ok thanks but still having proplem

Fatal error: Erroneous or empty query result: SELECT userid, usergroupid, membergroupids, username, password, salt FROM vbuser WHERE username = 'franklaval'


Erroneous or empty query result: SELECT userid, usergroupid, membergroupids, username, password, salt FROM vbuser WHERE username = 'franklaval'

whan cliking on the vbulletin link and still not creating user in the user list

do you now why ??

[franklaval]

im using vbb 3.6.4 is it compatible??

[Prometheus]

I guess not since you are getting errors...lol..
Look in your vbuser table and see how the usernames are stored.


You might try changing the:
FROM vbuser WHERE username = 'franklaval'
to FROM vbuser WHERE username = "franklaval"

in the vbull.aemod

You will have to play with that query to get it to pull the usernames.
Plus I am using 4.1.2. vb 3.5.4.

[franklaval]

ok whats the link you are using to auto login ???


and now i installed vbulletin_3-5-4 and still user are not shoing in member list of vbb forum ????