Integration with vBulletin - Phpclassifieds integration with vbulletin

Hi

Please see below for working code to integrate vbulletin and phpclassifieds. Phpclassifieds ( http://www.deltascripts.com ) is one of the best classifieds scripts out there, free for non-profit use...


This integration works with vb 3.6 and phpclassifieds 7.1 . Will likely work with vB 3.5 but not tested.

----
Highlights:

"Lead" database is vBulletin.
Automatic login into phpclassifieds if logged in vBulletin (just need to click on login). Automatically creates user if none found.
Automatically updates name/email in phpclassifieds as and when they change in vBulletin.
If needed, the two applications can be "separated" easily later. Only restriction is that passwords for "transferred accounts " will need to be reset in phpclassifieds.

----
NOTE:

* This integration assumes field1 (in vBulletin) contains the "display name". If you wish to use the username instead of field1, just replace $vbulletin->userinfo['field1'] with $vbulletin->userinfo['username'] in member_login.php.

* It assumes no extra mandatory fields in phpclassifieds. The code would be more complicated with that.

* Assumes forums are installed in http://site/forums. If elsewhere, need to change links to the forums in the phpclassifieds templates only.

* Make sure you turn off email verification in PHPClassifieds. Let vBulletin handle that.


----
Installation Instructions:

* Phpclassifieds files to replace: 1
* Phpclassifieds Templates to edit/replace: 4
* SQL query to run: 1
* Product/Plugin in vbulletin: 1
* Install time: ~20 minutes

* Edit the variables on top of member_login.php. If you like, you can also change the vbulletin membergroups who are allowed access (find $usergroupid = $vbulletin->userinfo['usergroupid']; in the file).

* Upload member_login.php to "classifieds-path/".

* Edit PHPClassifieds templates (details in the attached file).

* If not already present, create a unique key on user_email field in phpclass_user table.
SQL Code: CREATE UNIQUE INDEX user_email ON phpclass_user (user_email);

* Import PRODUCT file product-phpclass_integration.xml in vBulletin (Used to "push" email changes to phpclassifieds).

* Go to PLUGIN "Update PHPClassifieds Email", select "Edit", and replace the mysql database/user/password info for the phpclassifieds database. Also, if your phpclassifieds user table is not "phpclass_user", please change it to the value you're using.

* That's it! You're set.

---
Version

1.00b: Original Release

1.02b: Fixes member_login.php file to automatically delete expired ads if auto mode is set. Just Replace the file in "classifieds-path/".

[toolblast]

Originally Posted by BETIServices

My Demo after the install: http://www.betisforum.com/classifieds/

Works well the only thing I would love is a page intergraded with the forum .... wow

http://www.betisforum.com/classifieds/

BETI's goes to the install file... similar to me, except it goes to the install file only when I go to the login php page

[ndahiya]

looks like it is a file permission problem... when you go on the install page, it can not access classifieds/admin/config, which makes it think it needs to install it again... do a clean install of phpclassifieds that works, and then do the integration...

[myplacidcasual]

I'm sure this is a simple problem related to: $vbulletin->userinfo['field1'] and
$vbulletin->userinfo['username'] I just don't really understand where, how and what to change:

My problem is this:

I just don't know where to go to change

But on my site when you go to the member area it says, "Logged in as:" and no user name.

What should I do to fix this.

[ndahiya]

Originally Posted by myplacidcasual

I'm sure this is a simple problem related to: $vbulletin->userinfo['field1'] and
$vbulletin->userinfo['username'] I just don't really understand where, how and what to change:

My problem is this:

I just don't know where to go to change

But on my site when you go to the member area it says, "Logged in as:" and no user name.

What should I do to fix this.

Might be:

* This integration assumes field1 (in vBulletin) contains the "display name". If you wish to use the username instead of field1, just replace $vbulletin->userinfo['field1'] with $vbulletin->userinfo['username'] in member_login.php.


just search for field1 in the file and replace with username (maybe more than 1 instance)...

[myplacidcasual]

Figured it out. I'm sort of a newbie to all the vbulletin features so I'd forgotten that the profile fields are managed in the admin cp and that field 1 simply didn't exist in my vbulletin profile. Yay it works!

[ndahiya]

if someon can work out how to delete a profile in phpclassifieds when a profile is deleted in vbulletin, it'll be super.

the prob i faced is that a php file needs to be called when a user is deleted (coz you do not want to delete direct from db, which will leave orphan info), but can't call php files from a plugin ?

[Greek76]

Your post says its free but when I attempt to download its asks you to buy a license? Am I downloading the wrong one?

[ndahiya]

phpclass is free for non commercial use.... but you can download it and install it without any password etc... deltascripts.com

[parajsa]

how about, if u already used the classified as stand alone, and there some users there, can i make the integration, without lossing this users and their respective ads?

thank u in advanced

[amjadz4]

are you gonna update it to make it work with vbulletin 3.8.1?
thanks! would love to have it!