VB Forum

[MetallicWarfare]

Hello,


I have a quick question:

I have a website where people must register to get more features/ options. Also i use vbulletin as forum. But i dislike the fact that registered users of my website must register twice (once for my website and the second time for vbulletin) when they want to use the forum. The question is:

How can i use the data that i store in the mysql database of registered users for auto registration for vbulletin. And of course auto login

[charlie019]

I have never done this the way you are talking about but I think it will work, the same.

What I would do is have the login script on your site, really login and register on the forum.

To do this you would need to change the variables on the sites login page to the forums login page. (or an easier way use a iframe)

After you have the login / register mysql info and variables ready, all you need to do now is change the variables on the hiddent content pages, and possibly config.php.

I hope I explained this well.

(It would have been easier if you described it better and gave a link)

Cheers

I hope

[alexgeek]

the login script used is not overly complicated,
adding the VB script to it wouldn't be hard

[Daniel]

This is a database question:

Moved to MySQL Forum

[MetallicWarfare]

oh ok il give it a try i supose.

[alexgeek]

Originally Posted by DanDoughty

This is a database question:

Moved to MySQL Forum

Isn't more of a php one? This is combining two php scripts so they use the same session.

[MetallicWarfare]

Originally Posted by alexgeek

Isn't more of a php one? This is combining two php scripts so they use the same session.

OWNED!

lol alex do you know how this can be done? like of by hand? im having trouble

[alexgeek]

i've never really looked at the vb log in script
send it to me on msn in a min

[MetallicWarfare]

ok give me a min also im creating the training page lol for my game. and i have to re-download it >.<

[split-visionz]

Well heres the code to the login form copied out of my template....

Code: Select all

<!-- login form -->
        <form action="FORUM_DIRECTORY/login.php?do=login" method="post" onsubmit="md5hash(vb_login_password, vb_login_md5password, vb_login_md5password_utf, 0)">
        <script type="text/javascript" src="FORUM_DIRECTORY/clientscript/vbulletin_md5.js?v=365"></script>
        <table cellpadding="0" cellspacing="3" border="0">
        <tr>
            <td class="smallfont"><label for="navbar_username">User Name</label></td>
            <td><input type="text" class="bginput" style="font-size: 11px" name="vb_login_username" id="navbar_username" size="10" accesskey="u" tabindex="101" value="User Name" onfocus="if (this.value == 'User Name') this.value = '';" /></td>
            <td class="smallfont" colspan="2" nowrap="nowrap"><label for="cb_cookieuser_navbar"><input type="checkbox" name="cookieuser" value="1" tabindex="103" id="cb_cookieuser_navbar" accesskey="c" />Remember Me?</label></td>
        </tr>
        <tr>
            <td class="smallfont"><label for="navbar_password">Password</label></td>
            <td><input type="password" class="bginput" style="font-size: 11px" name="vb_login_password" id="navbar_password" size="10" tabindex="102" /></td>
            <td><input type="submit" class="button" value="Log in" tabindex="104" title="Enter your username and password in the boxes provided to login, or click the 'register' button to create a profile for yourself." accesskey="s" /></td>
        </tr>
        </table>
        <input type="hidden" name="s" value="" />
        <input type="hidden" name="do" value="login" />        
        <input type="hidden" name="vb_login_md5password" />
        <input type="hidden" name="vb_login_md5password_utf" />
        </form>
        <!-- / login form -->

Change the 'FORUM_DIRECTORY/' to your forum directory.... and then within your pages just include the 'globals.php' from VB and you can check to see if the user id is set to make sure they are logged in....

Code: Select all

 <?php
//change to forum directory, include globals and then check to see if logged in
chdir("./FORUM_DIRECTORY');
require_once("./global.php");
chdir("../");

if (!$vbulletin->userinfo['userid']){
//user not logged in
}
else{
//user is logged in....
}

?>

[alexgeek]

quite easy then

[split-visionz]

You can easily get access to the users name, user groups and things like that with a call to get the info out of the user table as well...

Code: Select all

    
$id=$vbulletin->userinfo['userid'];
$user = $vbulletin->db->query_first("SELECT * FROM user WHERE userid='$id'");

//now $user holds all data about the user.. everything from their profiles to usergroups and so on
//ex..the users name....
echo $user['username'];

[Daniel]

How can i use the data that i store in the mysql database of registered users for auto registration for vbulletin. And of course auto login

So no alex - it is a SQL question - don't challenge a moderator - we know what we're doing... usually

[MetallicWarfare]

lol thanks il give it another go then. il wait for you on msn alex some time roday but il give it a go and il write here if i get stuck again

[split-visionz]

If I were you, I would use vb's database as the main database for the site and put all of your tables in there. It would be alot easier then inserting and converting the opposite.

[MetallicWarfare]

^ completely confused now

do you have msn?

[split-visionz]

nope..lol. I only use AIM.. But Im about to take off anyways lol.

What I said was in response to what Dan quoted from your first post...

It would be easier to do the opposite of what your saying and just use the VB database and login system on the main site

[MetallicWarfare]

yea but i needed it to connect to my site

[split-visionz]

How much info is in your database yet when your sites not live? Just create a script that inserts the same tables you have in your sites DB into the VB database.
Then in all your pages just include "globals.php" that I talked about before. If you include that then your already connected to the VB database so all mysql calls will be on that database. Or you can use $vbulletin->db->query(""); to make your SQL calls.

Or are you using a sepereate full blown CMS on the main site?

[MetallicWarfare]

well we are working from my database which has about 133 tables but it also uses a cms which is modified completely. i dont know much about mysql or sql is there any chance you could help me?