Save Username and Passmd5 to extra table

[Noser]

Hi in first

i was trying a long time without some progress so i diceded to make ask te community.

my thing is that i want to save the Username ,password md5 hash and email from the vbulletin registration to a extra database and the table account_data

some one know how to solve this problem

greetings from switzerland
noser

[Noser]

so much proffesionals here and no one can help?

[kh99]

I can't tell you exactly what to do without seeing what your account_data table looks like, but I think you'd just want something like:

INSERT INTO account_data (username, password, email)
SELECT username, password, email FROM user

(of course you'd have to change the field names and add a table prefix to "user", if necessary).

If you already have an existing table with usernames you might have to do something different.

ETA: also, I guess this doesn't work if the new table is in a different database. I don't know how to handle that off the top of my head.

[Noser]

yes i was looking where to insert this query but all i can find in the register.php are request do=register so i dont know where the querys are.

all i want is post username,md5 pass, userlvl 0, ip and email and i want do this with an extra query in the register script from vbulletin since i want 1 registration for vbulletin forum and aion game.

greetz
noser