alright on sunday my forum database was hacked and destroyed along with the backup that was. now i did manage to get a partial backup but i need some script(mysql or php) to go through the db and delete all the unused user id's and to clean some things out. the db is a wreck that i am using right now but speed was of the essence. any thoughts on help thanks again...
ts

i should say the users are deleted but their id #'s still are in tact not sure what the best course of action is

First I must advise that you do backups and put them on your computer rather then online.

Second, The only way to clean the user id's is to manually do it. I'm sure someone can right a script to do so but it would need tobe written to fit the number of users you have. I'm not exactly sure on this, I'm not fluent in MySQL.

And third I recommend looking in any sort of log you have and reporting any unusual IP addresses to the IP's host.

you could do some thing like

[sql]
DELETE FROM user WHERE username=""
[/sql]

if they where deleting user names to delete all the rows with no user name.
make a back up of you back up and try out some stuff on that first though

i already reported the ips to the authorities
the backups are done via a cron'ed script and sent to another host but something must have failed so the backup was incomplete. all i know is what i should have done to ensure that this didnt happen and only can learn from it oh and acid thanks for the suggestion i will look into that query thanks again.

Unfortunally nothing will happen to those people as theirs no hard evidence

Not nessicarily, if he has logs and stuff then that's evident enough.

No its not. Having connection logs of some random ip's connecting is not proof enough that they hacked the server.

oh btw one place was traced to ont. the other to a wireless service provider in North Carolina