Coppermine 1.2.1 / vBulletin 3.0.0 Integration

Coppermine Gallery 1.21 and vBulletin 3.0.0 Integration
Version 1.0
Compiled by SpeedStreet

I'm not the hacker for this; I am merely the guy who poured through all of the threads on vBulletin.org and the Coppermine Development Forums to come up with one definitive post about integrating vBulletin with Coppermine.

WHAT IT DOES:
At the end of this how-to, you're installations of vBulletin and Coppermine will work together off of the same login. While everyone else wants to see all sorts of integration between the two, I believe this is the first step to making those things happen.

CREDITS:
A big thanks to everyone over at Coppermine for a terrific product and the users that support and mod it on a daily basis. I am merely standing on the shoulders of giants here, folks. Also, Nanobot was the guy over there that did the vB3 Gamma bridge, so the credit for that is all his.

FILES TO EDIT (2):
/bridge/vbulletin3.inc.php (Coppermine)
/include/init.inc.php (Coppermine)

HACK REQUIREMENTS:
vBulletin 3.0.0 Installed and Running
Coppermine 1.2.1 Installed and Running
5 Minutes of your time

SUPPORT THREADS:
Coppermine Gamma Thread (original thread): http://coppermine.sourceforge.net/bo...asc&highlight=
vBulletin.org Hack Thread: https://vborg.vbsupport.ru/showthread.php?p=488062
Coppermine vB 3.0.0 Thread: http://coppermine.sourceforge.net/bo...ic.php?p=20674

FINAL WARNINGS:

There are seem to be some issues with people integrating this with forums located on subdomains (e.g. subaruforums.speedstreet.org). Please reference the Coppermine Gamma Thread above for more info.
Please ensure that Coppermine and vBulletin cookies are NOT named the same thing.

[Siouxfire]

In the 'How to', it says "Save vbulletin3.inc.php to the bridge directory of your Coppermine installation" - What is a bridge directory? I currently have my files placed like this: 1) vBulletin - www.domain.com/forums/ and 2) Coppermine - www.domain.com/gallery/ - so what would the bridge directory be? The root?

[ged]

There is a directory named 'bridge' in your coppermine folder.

[shane801]

Where does this hack/integration stand?

I have the following problems:

1. Login in coppermine takes me to forum home. Login there and return to coppermine and everything is okay. Solution: remove login from coppermine and install a popup that advises users they must be logged in in forum home to use gallery.

2. Logout error in coppermine "an error occurred while attempting to logout, please click here to logout This one was posted before and not addressed.

I installed my coppermine on a seperate database. Seems to work ok though. No other problems than login/out like everyone else.

[DaFire]

the login taking you to the forum is necessary because in fact the forum is processing the login and there is no way to tell the forums login page to redirect you back to the gallery.

I suggest to just add a "Gallery" link to the forums main page

[d3nnis]

hi guys, any one of you using htm version of vbulletin with this mod? I can't seems to logout... I guess those links had been hardcoded to point to .php files... just need to know where to edit it so it will point to .htm files instead. Any help will be appreciated.

[d3nnis]

Originally Posted by d3nnis

hi guys, any one of you using htm version of vbulletin with this mod? I can't seems to logout... I guess those links had been hardcoded to point to .php files... just need to know where to edit it so it will point to .htm files instead. Any help will be appreciated.

anyone? :ninja:

[d3nnis]

bumped!

[Till]

Providing hacks and not supporting them is quite useless. Maybe the moderators could flag hacks that are not supported by the authors as that. Saves time and you don't install stuff that doesn't work right anyway.

I stopped scanning this thread on page 10 or whatever, but I guess since people still have issues, I post my mods.

Here is my setup:
- latest coppermine (1.3.3)
- vbulletin 3.0.6 (German)

The version of Coppermine that I have came with the bridge file for PHP. Since the one provided here didn't work and the file distributed with Coppermine had the cookie fix already applied to, I used it as base of my modifications to make it work.

Warning: The edits are quite techy and I will not support this.

bridge/vbulletin30.inc.php
1) You do all the obvious magic (database settings, ...)
2) Code hacking

Find this (around line 91):

PHP Code:

$got_user = 0;

if ($bbuserid && $bbpassword) {
    // If userid and password exist in cookies we use them to login 


And replace the following query ($sql = ...) and the mysql_num_rows() statement with this:

PHP Code:

$got_user = 0;

if ($bbuserid && $bbpassword) {
    // If userid and password exist in cookies we use them to login
    $sql = "SELECT userid as user_id, username as user_name, usergroupid as mgroup, password, salt ";
    $sql.= "FROM " . $UDB_DB_NAME_PREFIX . VB_TABLE_PREFIX . VB_USER_TABLE . " ";
    $sql.= "WHERE userid='" . addslashes(stripslashes($bbuserid)) . "'";
    if(!($result = db_query($sql, $UDB_DB_LINK_ID))){
        echo 'Error: '.mysql_error().'<br/>';
        echo 'Query: '.$sql.'<br/>';
        echo 'File: '.__FILE__.'<br/>';
        exit;
    }
    if (mysql_num_rows($result) > 0) {
        $USER_DATA = mysql_fetch_array($result);
        if ($bbpassword != md5($USER_DATA['password'] . $USER_DATA['salt'])) {
            $got_user = 1;
        }
    }
... 


So, what did I change here? First of all, I made the $sql query readable. There is an unwritten law that when you write code, you try to break it up after 65 chars (makes printing and reading easier).

Then I added the field "salt" to the SELECT-statement. It's used in vbulletin's login/authentication methods. Last but not least, I changed the if()-statement to check the password stored in the cookie against the password stored in the database.

If you want to have a look at the way vbuelltin does the authentication magic, feel free to browse includes/function-login.php under your vbulletin installation.

Ok, this is it. Not it works for me. Hope this actually helps someone else. If I find anything else, I will post again.

Cheers,
Till

[Till]

Logout doesn't work either.

In bridge/vbulletin30.inc.php, find this:

PHP Code:

// Logout
function udb_logout_page()
{
    $target = 'login.php?&do=logout';
    udb_redirect($target);
} 


Replace with:

PHP Code:

// Logout
function udb_logout_page()
{
    $target = 'login.php?do=logout&u=10';
    udb_redirect($target);
} 


[Marco van Herwaarden]

Originally Posted by Till

Providing hacks and not supporting them is quite useless. Maybe the moderators could flag hacks that are not supported by the authors as that. Saves time and you don't install stuff that doesn't work right anyway.
........
Warning: The edits are quite techy and I will not support this.

A bit of a contradiction this.

And this hack is already flagged as unsupported, see upper right corner.

Anyhow thank you for sharing your modification with the community. They might be usefull for some.