Difference between revisions of "Mediawiki Mendelete User Spam"

Revision as of 07:13, 9 July 2015

Asumsi tables dalam database

wiki_*

Temukan user

select user_id, user_name from wiki_user;

Delete

DELETE FROM `user_groups` WHERE wiki_ug_user = here user ID;
DELETE FROM `user` WHERE wiki_user_id = here user ID;

@@ Line 1: / Line 1: @@
+Asumsi tables dalam database
+ wiki_*
 Temukan user
   select user_id, user_name from wiki_user;
+Delete
-  DELETE FROM `user_groups` WHERE ug_user = here user ID;
+  DELETE FROM `user_groups` WHERE wiki_ug_user = here user ID;
-  DELETE FROM `user` WHERE user_id = here user ID;
+  DELETE FROM `user` WHERE wiki_user_id = here user ID;