User talk:Kymara: Difference between revisions
Content deleted Content added
imported>Kymara |
imported>Kymara No edit summary |
||
Line 1:
== cleanup postman table ==
;add indices on target and delivered (combined?)
;remove messages where the target does not correspond to an existing character name
:delete postman from postman left join characters on character.charname = postman.target where character.charname is null;
;remove messages where the target account.username is permanently banned (why do this first? it might get more?)
:delete postman from postman join account on account.username = postman.target where account.status='banned';
;remove messages where the target character has an account which is is permanently banned
:delete postman from postman join characters on character.charname = postman.target join account on account.id = characters.player_id where account.status='banned';
;remove any uncaught spam?
:delete from postman where source = 'Harold' and length(message)>1000;
== Quests which ask for a random item to be collected ==
| |||