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 jambo_1969

Yeah - have imported my Admins, but when I click on their profile (or mine) I get that box (extended table with logo in it)..

hmm, can you give me the link so I can check it out?
If you login and see them in the "New Members" area and click on that link does it generate the same page? Or is it only when you click on their "friendly" profile link?

[bart67]

Originally Posted by Dylanblitz

It wont show any new members until you have someone signup. If you go to the scripts home page and see the total number of users as 1, then you wont see any new members. But if you see more then 1 in the total members then it should show some new users. Let me know if it doesn't.

na sorry Dylanblitz when logged out does not show new members and i have 5 or 6 siged up so far but not showing them .

[Dylanblitz]

Ah ok, I found the problem. Small fix so it'll take about 20 minutes for me to fix and test. I'll upload a new package after.
As it's set now, the only time it creates a new member record is if admin authentication is turned on. That's how I did most of my testing so I didn't realize it wasn't creating the record for other scenarios.

[Dylanblitz]

Originally Posted by bart67

na sorry Dylanblitz when logged out does not show new members and i have 5 or 6 siged up so far but not showing them .

I fixed it and uploaded new files. The change files still just overwrites the old files as there's no database changes. There is also a new link in the admin area to rebuild the new members table. Once you overwrite the files go to the admin area and click the link that says Rebuild New Members. That will recreate the new members table. Any new members who signup should now get added to that table.

[bart67]

Originally Posted by Dylanblitz

I fixed it and uploaded new files. The change files still just overwrites the old files as there's no database changes. There is also a new link in the admin area to rebuild the new members table. Once you overwrite the files go to the admin area and click the link that says Rebuild New Members. That will recreate the new members table. Any new members who signup should now get added to that table.

Thanks for finding the bug that worked.

[htscpl]

Originally Posted by Dylanblitz

Okay, the script is not seeing the column called field4 in your userfield table. So either some mod really modified your forum (unlikely), or the forum prefix isn't set right in the configuration settings of my script.

So in my script login, click Admin on the right side, click on Setup Variables, and look at what you set for Forum DB Prefix Name.
Check it against the variable $config['Database']['tableprefix'] in your forum/includes/config.php

In the CnD Comm "Forum DB Prefix Name", I have left it blank because my forums don't have a prefix (from my config.php file):

 // ****** TABLE PREFIX ******
 // Prefix that your vBulletin tables have in the database.
$config['Database']['tableprefix'] = '';

Sorry to be such a pain, but I can't get it the sync to work. The forum has over 17k members... too many to port over one at a time.

[Dylanblitz]

Originally Posted by htscpl

In the CnD Comm "Forum DB Prefix Name", I have left it blank because my forums don't have a prefix (from my config.php file):

 // ****** TABLE PREFIX ******
 // Prefix that your vBulletin tables have in the database.
$config['Database']['tableprefix'] = '';

Sorry to be such a pain, but I can't get it the sync to work. The forum has over 17k members... too many to port over one at a time.

Not being a pain
You never answered, but is my script installed in the same database as the forum? That's the only other reason why I wouldn't see it finding the column. What version of vb are you running?

[htscpl]

CnD Comm has own folder but using same data base with VB 3.6.8 Patch level 2, connected to forum link and flash chat all right. I'm not much of a coder so I have a hard time knowing where to look.

[Dylanblitz]

Originally Posted by htscpl

CnD Comm has own folder but using same data base with VB 3.6.8 Patch level 2, connected to forum link and flash chat all right. I'm not much of a coder so I have a hard time knowing where to look.

Here are the files that should fix your problem.
Use them to replace the

/admin_sync_users.php
/incfiles/signup_top.php

files.

[bart67]

Is there going to be other Versions of this ?
As it would be good if you could add flash videos to your profile like youtube and flv files and it would be class if you could upload the videos as well .

This is far the best script i have seen for VB .