Difference between revisions of "Mediawiki Mendelete User Spam"

Revision as of 07:24, 9 July 2015

Asumsi tables dalam database

wiki_*

Temukan user

select user_id, user_name from wiki_user;

Delete

DELETE FROM `wiki_user_groups` WHERE ug_user = ID;
DELETE FROM `wiki_user` WHERE user_id = ID;

@@ Line 9: / Line 9: @@
 Delete
-  DELETE FROM `user_groups` WHERE wiki_ug_user = here user ID;
+  DELETE FROM `wiki_user_groups` WHERE ug_user = ID;
-  DELETE FROM `user` WHERE wiki_user_id = here user ID;
+  DELETE FROM `wiki_user` WHERE user_id = ID;