User talk:Kymara

grammar rules for website

please help me select the best rules by rewriting the sentences below where incorrect

kymara visited Nalwor forest ne at 10.29

kymara visited Afterlife at 10.30

kymara visited the Afterlife at 10.30 don't think this can easily be done except as a special case

kymara visited Semos plains n at 10.30

kymara changed outfit at 10.30

black death killed kymara at 10.30

A black death killed kymara at 10.30

kymara reached level 3 at 10.30

kymara killed archer elf at 10.30

kymara killed an archer elf at 10.30

kymara reached level 3 at 10.30

kymara killed kobold at 10.31

kymara killed a kobold at 10.31

kymara completed the Daily quest at 10.31

kymara reached level 4 at 10.31

A snake poisoned kymara at 10.33

A armed naga poisoned kymara at 10.34

An armed naga poisoned kymara at 10.34

kymara killed snake at 10.34

kymara killed a snake at 10.34

armed naga killed kymara at 10.34

An armed naga killed kymara at 10.34

kymara completed the Deathmatch quest at 10.44

kymara completed the Deathmatch at 10.44 worth it?

tiger killed Atlan at 10.55

A tiger killed Atlan at 10.55

Summary:

• When they kill, poison or are killed, creatures need a/an infront of the name depending on if they start with a vowel
• Players should be named alone without a/an
• Perhaps there are some zone special cases like the afterlife to think about
• Is it okay to call deathmatch a quest?

cleanup postman table

<source lang="sql"> CREATE TABLE IF NOT EXISTS temp_postman ( source VARCHAR(64),

target     VARCHAR(64),
message    TEXT);

LOAD DATA LOCAL INFILE '/home/katie/workspace/stendhal/postmantable.csv' INTO TABLE temp_postman FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\n';

insert into postman (source, target, message, timedate, messagetype, delivered) select source, target, message, '2010-07-20 00:00:00', 'P', 0 from temp_postman;

-- yes thats a lie about the message type, some came from npcs update postman set messagetype = 'N' where source in ('MrTaxman','Dagobert','Harold','Wilfred');

-- 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 characters.charname = postman.target where characters.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 characters.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;

-- postman used to be case sensitive on target and so there were some really ancient messages in there delete postman from postman join characters ON characters.charname = postman.target where characters.charname not like binary postman.target;

-- empty messages (1 was delivered was from new version) delete from postman where message = and delivered =0;

</source>

Stuff to do, over time

• Correct some of the warnings in findbugs:
  • Blackjack
  • Help tomi string append
  • Portal cast
• Review golden orc sword quest that's in feature requests
• Create quests pointing to dungeons
• Postman on website
• one player area access portals in banks
• equipment refactoring (right click equip, swapping items over existing items in slots)
• quest histories - can we get some smart default methods in? or use existing actions?