Mediawiki Mendelete User Spam: Difference between revisions

Latest revision as of 00: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 1: / Line 1: @@
+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 `user_groups` WHERE ug_user = here user ID;
+  DELETE FROM `wiki_user_groups` WHERE ug_user = ID;
-  DELETE FROM `user` WHERE user_id = here user ID;
+  DELETE FROM `wiki_user` WHERE user_id = ID;