User talk:Kymara

grammar rules for website

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

kymara visited Nalwor forest ne at 10.29

kymara visited Nalwor forest ne at 10.29

kymara visited Afterlife at 10.30

kymara visited Semos plains n at 10.30

kymara changed outfit at 10.30

black death killed kymara at 10.30

kymara reached level 3 at 10.30

kymara killed archer elf at 10.30

kymara reached level 3 at 10.30

kymara killed 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

kymara killed snake at 10.34

armed naga killed kymara at 10.34

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?

Stendhal Quest Histories

Please help us fill in the history you see when you type for example /listquests ArmorforDagobert. To know the names to type in here just inspect yourself or type /listquests.

As an admin you can see your 'quest state' when you inspect yourself.

As a keen player you also know the stages for each quest, and you can check StendhalQuest for a rough structure (though there may be extra stages).

The aim is to have a history entry for each stage of each quest. There may also be history entries for when you have fulfilled the question conditions (i.e. collected the item or killed the creature), but not taken it yet.

Even when the quest is finished there may be a history entry if it is repeatable. And of course, the entry for 'done' is very important :)