Searching for MySQL-Query
 

Hello,
I got a small problem. I used SMF Forum before and I had Trade-Feedback Plugin. Now I changed to vBulletin and I have iTrader plugin.
I want to import old feedback to the new. The problem is, that new userids are different from the old.
My idea is that I take the new "user" table and check for login-names and set on the old table the new id. The login is same.

That is what I want:

http://www.imagebanana.com/img/tqa19vae/tables.PNG

I just don't know how to realize this with SQL query. Can someone help me and make a sample for that action? There are about 8.000 users in the table.

Thanks!

If you have used ImpEx to import your SMF forum to vBulletin, then the user table will contain an import_userid column with the old SMF userid.

I know... But we used an other methode and now the userid's aren't same...
I were very thankful to anyone who will tell me how to do it. Maybe I could make it with some php script?

*push*

The best method for this is to write a small php script to query the old table and grab all the user id's and their corresponding usernames. Then store that in an array. Loop through the array and update the new table with the old id's. This is a little risky so be careful of what you do. The code below is a pretty good start to do what you want. Remember that you need to change the information for your database host, username, password, database name. You also need to make sure the right table and field names are used!

Thanks dude, I'll try it!