User talk:Kymara: Difference between revisions
Jump to navigation
Jump to search
Content deleted Content added
imported>Kymara |
imported>Kymara No edit summary |
||
| Line 1: | Line 1: | ||
== |
== converting xml path nodes to java == |
||
sed 's|</parameter>|));|' node > node2 |
|||
please help me select the best rules by rewriting the sentences below where incorrect |
|||
sed 's|<parameter name="node[0-9]*">|nodes.add(new Node(|' node2 > node3 |
|||
;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 == |
== cleanup postman table == |
||
Revision as of 12:55, 31 October 2010
converting xml path nodes to java
sed 's|</parameter>|));|' node > node2 sed 's|<parameter name="node[0-9]*">|nodes.add(new Node(|' node2 > node3
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?