SQL Question

[Wir3tap]

Ok, our vbulletin site recently got hacked, we have pretty much moved everything onto our new site. (New Forum and Database, Same Cpanel.)

Here is the tricky question.

Our Old Forum, the database is still fine and had the old userid's. When we imported into our new forum our userid's got completely changed. This messed up our awarded medals. We imported the awarded medals table but they are still linked to the old forums userid.

How can I make a sql query to do this?

Heres the info:
New Forum: _forumsv2
Old Forum: _tourny

Tables in Old Forum _tourny:
users - userid, and username are the 2 fields. (Only reason bringing into user id and name is to match up something for the new forum.)

Tables in New Forum _forumsv2:
users - userid, and username (Userid to get the new medals to use THIS ID instead of the Old userid in old forums. And Username which is the common connection between the 2.
award_user - userid (This still has the old user id's in and needs to be updated to reflect the new user id's. This is the only important field in this table.)

Please help!

Thanks!

[Zachery]

When you did the export, something messed up. You should reexport.

You didn't use impex to move servers or something did you? That'd do what you're running into.


You should just be moving servers: http://www.vbulletin.com/docs/html/m...rsion=40200603

[Lynne]

Why are you importing the database instead of just moving over a copy of it?

[Wir3tap]

We didn't know where the hack was that was the problem. So we created a new forums. Also the problem we had was the old vbulletin forums was provided to us by the hosting service we used. Since they changed owners our support ran out, and in that time we bought our own vbulletin license.

If I just made a duplicate copy of the database how many errors are going to pop up lol

[Lynne]

Well, if you made a duplicate copy of the database, then you wouldn't have userid issues. I'd say it is worth a try.

[Wir3tap]

Ok tonight, I have tried to reinstall a vbulletin over it, Everytime the login screen comes up with the old database, after logging in I get the old hacked message. So it's something in our database, and just trying to get a script that might change UserID Numbers might be the easiest.

[kh99]

If you haven't already, try to disable plugins, by editing your includes/config.php and inserting this line:

define('DISABLE_HOOKS', 1);

near the top just under the <?php line. If that stops the message then the hack is in a plugin, and you can probably go to the plugin manager and figure out which one.


If that doesn't work, try downloading and running this: www.vbulletin.org/forum/showthread.php?t=281080

[Wir3tap]

Fix it just performed a miracle. Thank you very much!!!