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
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;
Stuff to do, over time
- Correct some of the warnings in findbugs:
BlackjackHelp 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)
- Stendhal Quest Histories - can we get some smart default methods in? or use existing actions?