Difference between revisions of "Mediawiki Mendelete User Spam"

From OnnoWiki
Jump to navigation Jump to search
Line 9: Line 9:
 
Delete
 
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;

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;