merging user and password tables.. how?

[Chicago_VLNU_4s]

I'm about to install a system for my site which closely resembles myspace. I need to merge my forum user tables with the myspace login. How can I go about achieving this?

[UltimateOreo!]

You will need to code a bit, but just select from tables.

[Chicago_VLNU_4s]

thanks... but how? Login to phpmyadmin (check). Select my forums (check)... then what table(s) do I export?

**************

well I took my "user" table and replaced it with the "user" table out of the myspace look alike. Tried to use my e-mail address and password that I use for my forums and it doesn't work. Can I get more assistance?

[Dismounted]

Most likely, the password fields are encrypted differently, you will need to change the way your MySpace look-alike to reflect the way it checks passwords.

[Chicago_VLNU_4s]

awww man.... I'm completley new to this but not completley new. The passwords are different though, they look like "8ujt73jui99908edjr7499923urjTUi8ur" when I look at the password field, for example. Is there anymore you can offer me?? Seems like you're the only one who knows how to help... or is interested in helping :P

[UltimateOreo!]

Just use the same field for your myspace page and vbulletin.

[Chicago_VLNU_4s]

same field?? Explain

[Dismounted]

Just use the same field for your myspace page and vbulletin.
Not as simple as that I'm afraid. His MySpace script doesn't check passwords the same way vBulletin does, and is encrypted differently. vBulletin encrypts passwords like this:
md5(md5($password) . $salt);

[Chicago_VLNU_4s]

ok I've attached the following myspace "user" file

user: myspace user table

I was going to attach my forums "user" table but it had too much sensitive data. So maybe someone can download the file and get a better understanding of how that table works and help me further my project :D


http://www.sendspace.com/file/v7ymnr

[Dismounted]

It doesn't matter how your table is structured. You need to change your script so it checks passwords differently.

[Chicago_VLNU_4s]

so when I do this, my users will be able to login using their forum e-mail address and password correct? Well, anyway I should go about this? Cuz you're just throwing this info at me and I still don't know where to start.... only that I need to change the way it checks passwords ..... thanks again

[Dismounted]

so when I do this, my users will be able to login using their forum e-mail address and password correct?
Yes.
Well, anyway I should go about this?
You would start by editing the login script. You might have to get someone else to do this for you.

[Antivirus]

Try checking out the following thread:

https://vborg.vbsupport.ru/showthread.php?t=115380

[Chicago_VLNU_4s]

^^ Thanks, I checked that thread out but it seems to be just a simple login script, no? I already have that.

[Chicago_VLNU_4s]

so ok.... no more help huh?

[Dismounted]

Didn't you read what I said?
You would start by editing the login script. You might have to get someone else to do this for you.

[Chicago_VLNU_4s]

Yeah but look at what you're typing. That's like you asking "How do I drive" and I say "You get in the car and start the key". That's the kind of info you're giving me. As for the getting someone else to do it for me... well I could have thought of that. I want to attempt to do it myself before trying to hire someone.

[Dismounted]

Fine, do you know your PHP well?