| <![CDATA[---- securely deleting a user from the wakkawikki
SET @delete_user = 'KillUser';
SET @delete_to = 'NewOwnerOfOldPages';
DELETE FROM wakka_users WHERE name = @delete_user;
DELETE FROM wakka_acls WHERE page_tag = @delete_user;
-- pages that don't have an owner and user now, update to a new one
UPDATE wakka_pages SET owner = @delete_to WHERE owner = @delete_user;
UPDATE wakka_pages SET user = @delete_to WHERE user = @delete_user;
---- securely deleting a wakkawikki-page:
SET @delete_page = 'PrunePage';
-- kill page itself
DELETE FROM wakka_pages WHERE tag = @delete_page;
-- kill acls for it
DELETE FROM wakka_acls WHERE page_tag = @delete_page;
-- kill links to and from it
DELETE FROM wakka_links WHERE from_tag = @delete_page;
DELETE FROM wakka_links WHERE to_tag = @delete_page;
---- securely renaming a wakkawikki-page:
SET @rename_from = 'OldnamedPage';
SET @rename_to = 'NewNamedPage';
-- rename page
UPDATE wakka_pages SET tag = @rename_to WHERE tag = @rename_from;
-- update acl
UPDATE wakka_acls SET page_tag = @rename_to WHERE page_tag = @rename_from;
-- update links
UPDATE wakka_links SET from_tag = @rename_to WHERE from_tag = @rename_from;
---- give user the ownership of his own wakka-page back
---- helps from locking users out of their own nickpage.
SET @user_page = 'MyNickPage';
UPDATE wakka_pages set owner = @user_page where tag = @user_page;
-- and let everyone registered read it again
UPDATE wakka_acls SET list='§' WHERE page_tag = @user_page;
---- check for nick-pages that other users claimed before the right owner could:
-- hmmmmm go on?!
-- superfluous. Current branch creates UserPage as soon as a new User is created.
---- referrer spam stuff. Brute force.
-- generic delete
-- zap countries
delete from wakka_referrers where referrer like "%.to";
delete from wakka_referrers where referrer like "%.to/%";
delete from wakka_referrers where referrer like "%.cc";
delete from wakka_referrers where referrer like "%.cc/%";
delete from wakka_referrers where referrer like "%.ro";
delete from wakka_referrers where referrer like "%.ro/%";
delete from wakka_referrers where referrer like "%.pl";
delete from wakka_referrers where referrer like "%.pl/%";
-- zap keywords/sitenames
delete from wakka_referrers where referrer like "%rape%";
delete from wakka_referrers where referrer like "%incest%";
delete from wakka_referrers where referrer like "%yaboo.dk%";
delete from wakka_referrers where referrer like "%.ya.com%";
delete from wakka_referrers where referrer like "%.terra.es%";
delete from wakka_referrers where referrer like "%.mooo.com%";
delete from wakka_referrers where referrer like "%.wanadoo.es%";
delete from wakka_referrers where referrer like "%filthserver%";
delete from wakka_referrers where referrer like "%beastiality%";
delete from wakka_referrers where referrer like "%bestiality%";
delete from wakka_referrers where referrer like "%freeservers%";
delete from wakka_referrers where referrer like "%sexushost%";]]> |