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
where
-- 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
join account on account.id = characters.player_id
where account.status='banned';
| |||