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]

Originally Posted by UltimateOreo!

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:

PHP Code:

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


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.