Integration with vBulletin - C&D Comm - Social Networking

Here is a social networking script modeled after Myspace. This is a separate script that runs by itself. I have integrated the user login's from vb so that browsing is seamless.

I've been working on this script for a few years now. I built an integration between VB 3.6.x and my script a bit ago so I figured I'd put it out here for people who are going to be on 3.6.8 for a bit. If you like it and would like it to be carried over to 3.7 I'll test theintegration for that too, otherwise I'll just let it die out integration wise.

Please click Mark as Installed if you are using this integration.

Basic highlights of the script:
3 levels of users: Administrator, Moderator, User
Multi Language Support
VBulletin Integration
FlashChat Integration (same DB)
Customizable home page
Background Image/Sound without needing Javascript
Search by area, user particulars, etc
Private Messaging
Public/Private Profile Notices (like bulletins)
Customizable default color scheme easily
Enable/Disable ability to have local background music
Easily turn on/off modules
Simple User Administration
Several sign up verifications available
Single point of registration/login

Requirements
PHP 4.4.7+
Compiled with GD2
MySQL 4.1.x+

Installation is fairly easy. There is an installation instruction file in the zip.

You should turn off registration on the forum and remove the logout/login links. All registration through the script will create forum accounts for new users.

For profile links to work, you need to edit your .htaccess file and add the following lines

RewriteEngine on
RewriteRule ^p_(.*) view_profile.php?urlname=$1

The script does zero modification to your vb tables and files, so if you don't like it you can just delete the cnd_* tables and files and your back to how you were before.

Live Demo
Some admin functionality was disable for the demo site. Cannot delete/ban accounts, cannot change configuration of the script.

Administrator Account
email: admin@cnd-systems.com
pass: password

Moderator Account
email: mod@cnd-systems.com
pass: password

User Account
email: user@cnd-systems.com
pass: password

Version History

1.2.3a - [Thur 10th July 2008]

Fixed typo in sync users and sync pics

v1.2.3 - [Wed 9th July 2008]

Added ability to resend authorization email
Fixed Last post first bug
Added browse all link to header
Added ability for admin to enable/disable browse all link
Fixed problem with images being hidden from friend when the hide images from all but friends privacy setting is set.
Added mood indicator (Modify Profile->Personal Info)
Added photo albums (All users have a My Photos album to start)
Added Admin ability to disable/enable mood indicator
Added Admin ability to set whether users can edit their own comments on peoples notices
Added Admin ability to set whether users can delete their own comments on peoples notices, events, etc
Added Admin ability to set whether notice owner can delete other user comments for their notices
Fixed problem with not stripping slashes from display name on some pages
Sync Users and Sync Pics option in admin area will now move images stored in the database or filesystem

v1.2.2 - [Wed 4th June 2008]

Added ability to add user as administrator (Only primary admin can add/remove administrators)
Added ability to make user/mod/admin primary admin (irreversable besides through database)
Block ability to delete user if they are moderator or admin (Must remove mod/admin permissions first)
Changed forum sync to pull in profile picture from forum if available
Added ability for admin to update users pictures with profile picture from forum
Added ability for admin to set forum/events/calender to open in new window or current
Added ability to login to forum and have session pass login to script

v1.2.1 - [Sat 10th May 2008]

Fixed band images upload when max is set to 0
Fixed user images upload when max is set to 0
Fixed group message edit error
Fixed band upload image error
All music uploads now check post_max_size and use that as limit
Added config item for image size limit
Show post_max_size limit in the admin area
Added selection of admin from forum for linking with C&D Admin account
Added ability for user to set table and body background colors
Added ability for admin to set all but profile page colors
Added ability to operate from seperate database than flashchat
Changed profile layout to try to use external, then custom then default layout
Removed auto deletion of accounts that haven't activated in 2 weeks

v1.2.0 - [Wed 9th Apr 2008]

Modified install script to use an existing forum admin
Rearranged upgrade script
Added external javascript field for profile customizing
Added admin ability to disable external javascript field
Fixed messaging scheme to use less database records

v1.1.2 - [Mon 7th Apr 2008]

Fixed approving band issue
Fixed issue with adding contacts
Fixed some issues with syncing users with forum
Added error checking for reading vbulletin database connection

v1.1.1 - [Fri 4th Apr 2008]

Fixed some issues with syncing users with forum

v1.1.0 - [Thur 3rd Apr 2008]

Added Image Verification to Signup
Added ability to post youtube videos
Added ability to operate from seperate database than vbulletin
Added dubugging mode
Added better error handling
Added ability to have new users be assigned to specific forum group
Added ability to have disabled users be moved to specific forum group
Added ability for admin to delete accounts on C&D or Forum or Both
Added ability for admin to use forum calendar instead of C&D for events
Added basic Install Instructions
Changed cookies to use information pulled from vb database

v.1.0.3 - [Thur 27st Mar 2008]
Added ability to show profile links without htaccess modification (not user friendly links)
Fixed creation of record in New Members list

v.1.0.2 - [Thur 27st Mar 2008]
Fix sync users for special characters in vbulletin
Added ability to sync users by vbulletin group
Modified placement of Sync Users popup

v1.0.1 - [Mon 24st Mar 2008]
Fixed country value in the search qualification
Fixed chat display name error on account edit if chat is not installed
Fixed wrong email subject on account activation page
Fixed case sensitivity for vbulletin queries

No database changes between 1.0.0 and 1.0.1 so you only need to swap files.

v1.0.0 - [Fri 21st Mar 2008]
Initial release

[Dylanblitz]

Originally Posted by PoetJA-1975

Wow! Great demo - I wonder how this seemlessly integrates with vBulletin though - Thanx for the share - You can tell there's been a LOT of work put into the script!

Jacquii.

Thanks for the comments

There's very little integration at the moment between the two. Just the basics to keep the operation and navigation smooth. The main things shared are the login information and the username. I built my script to use the same kind of authentication so it's pretty easy to have my script login for both.
I'll be adding a lot more integration in the future as well as making it capable to run on separate databases.
When I get some spare $$ I'll get another license and setup the integration on the demo site.

[sunnylikbeckham]

its just awosome
and possiblety to use seperate domain for that??
seperate from forum

[Dylanblitz]

Originally Posted by sunnylikbeckham

its just awosome
and possiblety to use seperate domain for that??
seperate from forum

Not sure what you mean by separate domain?
If you are asking if it will run on it's own, yes, it's a stand alone script. I just created a connection into vb.

[jambo_1969]

before I install...

When you sync users - I currently have 10,000+ - what's the impact on server load ?

Can you specify to only bring over one particular usergroup ?

Cheers

[Dylanblitz]

Originally Posted by jambo_1969

before I install...

When you sync users - I currently have 10,000+ - what's the impact on server load ?

Can you specify to only bring over one particular usergroup ?

Cheers

Right now it syncs the whole member list. I'll tweak it so you can import certain groups at a time. Should only take a day or two to code it and test.
I'm not sure about the server load on syncing 10k+. I'd definitely do it at a slow time. The last test I did was on a server with about 1500 forum users and it took only about 5 seconds to sync up.

[jambo_1969]

Originally Posted by Dylanblitz

Right now it syncs the whole member list. I'll tweak it so you can import certain groups at a time. Should only take a day or two to code it and test.
I'm not sure about the server load on syncing 10k+. I'd definitely do it at a slow time. The last test I did was on a server with about 1500 forum users and it took only about 5 seconds to sync up.

Brilliant !

On the face of it - this is one of the best mods I've seen...

Usergroup specific would cap it all off

[htscpl]

Hi, I did the install and edited the paths correctly ( I think) however when I did the 'sync users' I got this error:

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/***/public_html/***/cndcomm/admin_sync_users.php on line 129

And it didn't sync my users into the community so where do I go from here?

Thanks for your help with this as I think this script will be very useful to me.

Henry

[Dylanblitz]

Originally Posted by htscpl

Hi, I did the install and edited the paths correctly ( I think) however when I did the 'sync users' I got this error:

And it didn't sync my users into the community so where do I go from here?

Thanks for your help with this as I think this script will be very useful to me.

Henry

A couple questions to make sure.
You installed this in the same database as the forum?
Did you put anything in the field Forum DB Prefix Name in the Admin Configuration area?

If it's installed in the same database and you didn't put anything in the field then the forum might have been installed with a database prefix and the script is just not finding the tables. It's either that or the user table has been modified and one of the fields I'm querying for is not there. Try using this file to overwrite the current admin_sync_users.php and try running the sync again. It will tell you the exact database error your getting and you can tell me what the error is.

[Dylanblitz]

Originally Posted by jambo_1969

Brilliant !

On the face of it - this is one of the best mods I've seen...

Usergroup specific would cap it all off

I've uploaded the files so that you can sync users by their vb group

[jambo_1969]

Originally Posted by Dylanblitz

I've uploaded the files so that you can sync users by their vb group

Brilliant!

Thanks mate - off to install now !