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