Arianne

User talk:Kymara: Difference between revisions

← Older editNewer edit →
Content deleted Content added
VisualWikitext
imported>Kymara
No edit summary
imported>Kymara
No edit summary
Line 1:
== cleanup postman table ==
<source lang="sql">
;-- add indices on target and delivered (combined?)▼
 
-- remove messages where the target does not correspond to an existing character name
▲;add indices on target and delivered (combined?)
delete postman from postman
left join characters on character.charname = postman.target
where character.charname is null;
 
;-- remove messages where the target doesaccount.username is permanently banned (why notdo correspondthis tofirst? anit existingmight characterget namemore?)
:delete postman from postman left join characters on character.charname = postman.target where character.charname is null;
join account on account.username = postman.target
where account.status='banned';
 
;-- remove messages where the target account.usernamecharacter ishas permanentlyan bannedaccount (whywhich dois thisis first?permanently it might get more?)banned
:delete postman from postman join account on account.username = postman.target where account.status='banned';
join characters on character.charname = postman.target
 
join account on account.id = characters.player_id
;remove messages where the target character has an account which is is permanently banned
where account.status='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;
 
▲;-- remove any uncaught spam?
delete from postman
where source = 'Harold'
and length(message)>1000;
 
</source>
 
== Quests which ask for a random item to be collected ==
Retrieved from "https://meet.konsthol.eu/w/index.php?title=User_talk:Kymara"
Return to the user page of "Kymara".