User talk:Kymara: Difference between revisions

Content deleted Content added
imported>Kymara
No edit summary
imported>Kymara
No edit summary
Line 21:
-- remove messages where the target does not correspond to an existing character name
delete postman from postman
left join characters on charactercharacters.charname = postman.target
where charactercharacters.charname is null;
 
-- remove messages where the target account.username is permanently banned (why do this first? it might get more?)
Line 31:
-- remove messages where the target character has an account which is is permanently banned
delete postman from postman
join characters on charactercharacters.charname = postman.target
join account on account.id = characters.player_id
where account.status='banned';
Return to the user page of "Kymara".