Difference between revisions of "Mediawiki Mendelete User Spam"

Latest revision as of 07:24, 9 July 2015

Asumsi tables dalam database

wiki_*

Cek struktur database

desc wiki_user;
desc wiki_user_group;

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 2: / Line 2: @@
   wiki_*
+Cek struktur database
+ desc wiki_user;
+ desc wiki_user_group;
 Temukan user
@@ Line 9: / Line 14: @@
 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;