maintaining 2 logins and databases with vBulletin

[mytown.ie]

Hi There,

I have purchased and installed vBulletin on http://www.mytown.ie/forums.
You will see that the main version of my site http://www.mytown.ie already has a login area, this allows users to login to access certain features on the site.

When a new user registers with mytown.ie, they will also be registered on vBulletin (my programmer can change the mytown.ie registration script to create entries in both DB tables). The problem is when a user registers on mytown.ie/forums - I also want them to be registered on the main area of mytown.ie - creating a DB entry here. Similarly when a user logs-in to mytown.ie/forums, they should be logged-in to the main area of the site.

I am sure that other sites that have added vBulletin will have had a similar problem, and would therefore appreciate your feedback.

Thanks,

Garry

if you have a custom main page, i would suggest you request a custom bridge ... bridge would be used to connect both systems and work seemlessly...

as you say, others have their vBulletin plugged-in some other software are using 3rd party bridges... usually released by the company that create the other softwares... rare are the bridges created by Jelsoft for other softwares... i know none actually.. the only bridges created here for Wordpress and some other chat scripts are custom from coders on this site.

[mytown.ie]

Thanks for the feedback.

My system is custom built and my programmer would be able to build something that connects from vBulletin into my system. I would like to give him some guidance regarding the vBulletin code though. I have been advised by vBulletin me that I should be able to use a plugin that executes some code when a user registers, they advised me to look on this forum for further help.

Any advice is greatly appreciated.

[jj]

With the fact you are using a custom built page, there should be no problems on dropping your site user table and base the page onto the vbulletin user table.

I wrote a custom "cms" for our page as well, and I'm hooking into the vbulletin user table for authentication on site (the login is handled by vbulletin completely).

Here's a snippet of my custom security/user class

PHP Code:

    function auth_phpbb($data, $passwd) {
        return false;
    }
    function auth_vbulletin($data, $passwd) {
        /*
         * Passwortchecks
         */
        if ($data['salt'] != "") {
            $passwdMD5 = md5( md5( $passwd ) . $data['salt'] );
        } else {
            $passwdMD5 = md5( $passwd );
        }

        if ($passwdMD5 == $data['password']) {
            $_SESSION['oSession']['userinfo'] = array (
                'userid' => $data['userid'],
                'username' => $data['username']
            );
            session_regenerate_id();
            return true;
        } else {
            unset( $_SESSION['oSession']['userinfo'] );
            return false;
        }
    }
    function authenticate($system = 'DEFAULT') {
        if ( $system=='DEFAULT' ) {
            $system='auth_'.$this->config["main"]["authsystem"];
        } else {
            $system='auth_'.$system;
        }
        if (!method_exists($this,$system)) {
            return false;
        }
        if (
            isset($_POST['login']) &&
            is_array($_POST['login']) &&
            !empty($_POST['login']['username']) &&
            !empty($_POST['login']['password'])
        ) {
            $data = $this->getUser(htmlentities(strip_tags($_POST['login']['username']),ENT_QUOTES));
            if (
                $data &&
                (
                    $this->isMemberOfGroup($data['userid'],4) ||     // Mitglieder
                    $this->isMemberOfGroup($data['userid'],6) ||     // Trials
                    $this->isMemberOfGroup($data['userid'],1) ||     // Administratoren
                    $this->isSuperAdmin($data['userid'])            // SuperAdmins
                )
            ) {
                return call_user_method($system, $this, $data, $_POST['login']['password']);
            }
        }
        return false;
    } 


Maybe it's helpfull.

Cheers
Jens

[mytown.ie]

Thanks for that Jens.
So you are suggesting using the vBulletin user table and stop using my existing user DB table?
I have got some fields in my current user DB table which are not catered for in the vBulletin table, do you think it will cause problems adding new fields to the vBulletin table?

I know it is a better solution to have one user table, than have to worry about replicating users from one table to another.

Any further advise is more than welcome.

Cheers,

Garry

[Dismounted]

You can just port your fields over into the vBulletin user table. They will then be able to be accessed globally in vBulletin (if you need to).

[mytown.ie]

OK, i just want to make sure I understand this correctly.

You guys think that they best solution is to add all the required fields to the vBulletin db user table. Then drop my current user db table and move all my sites current login/register/user_account code to look at the vBulletin user db table.

Another question then. If a user logs in to vBulletin forum on my site, I also want them to be logged in to the main area of my site. What changes to code will I have to make to achieve this? Can you advise me of what code/files need to be edited?

Thanks,
Garry

[Dismounted]

Just include global.php - it will handle all session keeping, if there is a session.

[ArbuZz]

It is logical, that if you use vBulletin user table to store your website user account, it'd better if you managed to use vBulletin's auth system also. I wish it was an option for me. In case if that is not possible, have look in this thread: https://vborg.vbsupport.ru/showthrea...t=82836&page=7 and especially at my last experience. I've just accomplished the similar task, although I wish it was somehow more elegant or something. So if you can use vBulletin's auth and db system, then use it.