Importing MYSQL Column Data for VBCredits from other Database?

[Toupsx]

Originally Posted by Eikinskjaldi

assuming both databases are on the same system:

[sql]
update vbdatabase.user u, otherdatabase.credittable o
set u.newfield1=o.oldfield1, u.newfield2=o.oldfield2
where u.userid=o.userid
[/sql]

I'll try that out.. but how would it connect t the other database? wouldn't it need the host/DB name/user/password?

[Dismounted]

If both databases are on the same server, and the user specified when connecting has permissions to both databases, that query will work.

[Marco van Herwaarden]

"basically the same" is not "the same", hence why it is difficult to provide a solution based on your information. Like already mentioned: are both systems for example use the same userid? So is user "1" also user "1" in the other system. Can you match in some way the userid's between these systems?

A lot more info needed if you want an answer here.

[Toupsx]

Originally Posted by Dismounted

If both databases are on the same server, and the user specified when connecting has permissions to both databases, that query will work.

Don't believe they are, my webhost puts databases on different hosts & such.. one is on 1 host, another on a different host =\

Originally Posted by Marco van Herwaarden

"basically the same" is not "the same", hence why it is difficult to provide a solution based on your information. Like already mentioned: are both systems for example use the same userid? So is user "1" also user "1" in the other system. Can you match in some way the userid's between these systems?

A lot more info needed if you want an answer here.

Yes, all user info matches.. user id on 1 matches the other, username matches the other, etc.

Don't know what info is needed so just ask and I'll provide what I can

[Marco van Herwaarden]

I find it very hard to believe that after importing from SMF to vBulletin with ImpEx, your vBulletin users have the same userid as the SMF userid. This is almost impossible.

[Darkwaltz4]

Hmm, well I just finished taking care of this for Toupsx, but it seems everyone kind of misunderstood my initial suggestion to him..

As impex converts certain columns from the target database (in this case, SMF) into corresponding columns in vBulletin, I figured that somewhere in impex is the definition list for these columns. I just didn't know where to find it in order to add that the 'money' column in SMF user table goes to the 'credits' column in vBulletin's user table.

Thats all that was needed... I've never used impex or played around with it, so if anyone knows this offhand would be useful to know (all the files are NUMBERED which makes it that much harder to guess where to find the definitions). What we ended up doing was using a CSV file with the specific columns to create a series of update queries attached to the importuserid created by impex on the vbulletin user table (that much I knew).