Difference between revisions of "Mediawiki Mendelete User Spam"
Jump to navigation
Jump to search
Onnowpurbo (talk | contribs) (New page: Temukan user select user_id, user_name from wiki_user; DELETE FROM `user_groups` WHERE ug_user = here user ID; DELETE FROM `user` WHERE user_id = here user ID;) |
Onnowpurbo (talk | contribs) |
||
| (2 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
| + | Asumsi tables dalam database | ||
| + | |||
| + | wiki_* | ||
| + | |||
| + | Cek struktur database | ||
| + | |||
| + | desc wiki_user; | ||
| + | desc wiki_user_group; | ||
| + | |||
Temukan user | Temukan user | ||
select user_id, user_name from wiki_user; | select user_id, user_name from wiki_user; | ||
| + | Delete | ||
| − | DELETE FROM ` | + | DELETE FROM `wiki_user_groups` WHERE ug_user = ID; |
| − | DELETE FROM ` | + | DELETE FROM `wiki_user` WHERE user_id = ID; |
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;