Difference between revisions of "Mediawiki Mendelete User Spam"

From OnnoWiki
Jump to navigation Jump to search
 
Line 2: Line 2:
  
 
  wiki_*
 
  wiki_*
 +
 +
Cek struktur database
 +
 +
desc wiki_user;
 +
desc wiki_user_group;
  
 
Temukan user
 
Temukan user

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;