Hey guys,
Can anyone give me a SQL query I can use to delete all negative rep across my whole forum?
Anybody know? It's urgent.
DELETE FROM mybb_reputation WHERE reputation = '-1';
(2012-06-17, 03:50 PM)Yaldaram Wrote: [ -> ]DELETE FROM mybb_reputation WHERE reputation = '-1';
Then you might want to recount... Not sure though.
I guess that would only delete -1 reps, if the forum has -2 or -3, then multiple queries would need to be ran.
This will delete all negitave reputation:
DELETE FROM mybb_reputation WHERE reputation < '0';
Yaldaram's query will only delete -1 reps. If a user has -2 , -3, -4 etc....... His query wont delete those.