Mediawiki Mendelete User Spam - Revision history

Onnowpurbo at 00:24, 9 July 2015

2015-07-09T00:24:37Z

← Older revision		Revision as of 00:24, 9 July 2015
Line 2:		Line 2:

	wiki_*		wiki_*

			Cek struktur database

			desc wiki_user;
			desc wiki_user_group;

	Temukan user		Temukan user

Onnowpurbo at 00:24, 9 July 2015

2015-07-09T00:24:07Z

← Older revision		Revision as of 00:24, 9 July 2015
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;

Onnowpurbo at 00:13, 9 July 2015

2015-07-09T00:13:56Z

← Older revision		Revision as of 00:13, 9 July 2015
Line 1:		Line 1:
			Asumsi tables dalam database

			wiki_*

	Temukan user		Temukan user

	select user_id, user_name from wiki_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;

Onnowpurbo: 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;

2015-07-09T00:13:27Z

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;

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;