From: <ma...@us...> - 2012-07-19 15:14:18
|
Revision: 8388 http://planeshift.svn.sourceforge.net/planeshift/?rev=8388&view=rev Author: magodra Date: 2012-07-19 15:14:09 +0000 (Thu, 19 Jul 2012) Log Message: ----------- - Updated use of brain in the test data. Modified Paths: -------------- trunk/src/server/database/mysql/sc_npctypes.sql trunk/src/server/database/mysql/tribe_recipes.sql Modified: trunk/src/server/database/mysql/sc_npctypes.sql =================================================================== --- trunk/src/server/database/mysql/sc_npctypes.sql 2012-07-19 10:46:15 UTC (rev 8387) +++ trunk/src/server/database/mysql/sc_npctypes.sql 2012-07-19 15:14:09 UTC (rev 8388) @@ -849,7 +849,7 @@ <react event="tribe_home:living" behavior="TribeHomeLiving" /> '); -INSERT INTO sc_npctypes VALUES("111","MineingTribe","AbstractTribesman",0,"","","","","","0", +INSERT INTO sc_npctypes VALUES("111","MiningTribe","AbstractTribesman",0,"","","","","","0", '<empty/>'); INSERT INTO sc_npctypes VALUES("112","HuntingTribe","AbstractTribesman",0,"","","","","","0", Modified: trunk/src/server/database/mysql/tribe_recipes.sql =================================================================== --- trunk/src/server/database/mysql/tribe_recipes.sql 2012-07-19 10:46:15 UTC (rev 8387) +++ trunk/src/server/database/mysql/tribe_recipes.sql 2012-07-19 15:14:09 UTC (rev 8388) @@ -79,7 +79,7 @@ INSERT INTO `tribe_recipes` VALUES (100, 'Mining Tribe', '# No requirements', '# The Mining tribe -brain(civilised);aggressivity(peaceful);growth(conservatory);unity(organised);sleepPeriod(diurnal); +brain(MiningTribe);aggressivity(peaceful);growth(conservatory);unity(organised);sleepPeriod(diurnal); # Load recipes loadRecipe(Do Nothing); @@ -90,7 +90,7 @@ INSERT INTO `tribe_recipes` VALUES (101, 'Hunting Tribe', '# No requirements', '# The Hunter tribe -brain(civilised);aggressivity(neutral);growth(conservatory);unity(organised);sleepPeriod(diurnal); +brain(HuntingTribe);aggressivity(neutral);growth(conservatory);unity(organised);sleepPeriod(diurnal); # Load Recipes loadRecipe(Do Nothing); This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site. |
From: <ma...@us...> - 2012-07-25 13:14:46
|
Revision: 8405 http://planeshift.svn.sourceforge.net/planeshift/?rev=8405&view=rev Author: magodra Date: 2012-07-25 12:23:37 +0000 (Wed, 25 Jul 2012) Log Message: ----------- - Added a second group of in region fighters in the hils in npcroom3. Modified Paths: -------------- trunk/src/server/database/mysql/characters.sql trunk/src/server/database/mysql/sc_location_type.sql trunk/src/server/database/mysql/sc_locations.sql trunk/src/server/database/mysql/sc_npc_definitions.sql trunk/src/server/database/mysql/sc_npctypes.sql Modified: trunk/src/server/database/mysql/characters.sql =================================================================== --- trunk/src/server/database/mysql/characters.sql 2012-07-25 12:22:16 UTC (rev 8404) +++ trunk/src/server/database/mysql/characters.sql 2012-07-25 12:23:37 UTC (rev 8405) @@ -158,6 +158,10 @@ INSERT INTO `characters` VALUES (85,'Fighter6','','',3,1,100.00,100.00,100.00,100.00,100.00,100.00,200.00,200.00,100.00,100.00,100.00,100.00,100,100,100,100,100,100,100,100,0,3,-12.00,0.00,-250.00,0.00,0,0,0,0,0,'','',0,NULL,'',1,6,'N',9,0,2,0,0,'Fighting with region','','','',10,'',0,'0000-00-00 00:00:00',0,0); INSERT INTO `characters` VALUES (86,'Fighter7','','',3,1,100.00,100.00,100.00,100.00,100.00,100.00,200.00,200.00,100.00,100.00,100.00,100.00,100,100,100,100,100,100,100,100,0,3,-14.00,0.00,-250.00,0.00,0,0,0,0,0,'','',0,NULL,'',1,6,'N',9,0,2,0,0,'Fighting with region','','','',10,'',0,'0000-00-00 00:00:00',0,0); INSERT INTO `characters` VALUES (87,'Fighter8','','',3,1,100.00,100.00,100.00,100.00,100.00,100.00,200.00,200.00,100.00,100.00,100.00,100.00,100,100,100,100,100,100,100,100,0,3,-16.00,0.00,-250.00,0.00,0,0,0,0,0,'','',0,NULL,'',1,87,'N',9,0,2,0,0,'Fighting with region','','','',10,'',0,'0000-00-00 00:00:00',0,0); +INSERT INTO `characters` VALUES (88,'Fighter9','','',3,1,100.00,100.00,100.00,100.00,100.00,100.00,200.00,200.00,100.00,100.00,100.00,100.00,100,100,100,100,100,100,100,100,0,6,-110.00,0.00,-55.00,0.00,0,0,0,0,0,'','',0,NULL,'',1,6,'N',9,0,2,0,0,'Fighting with region','','','',10,'',0,'0000-00-00 00:00:00',0,0); +INSERT INTO `characters` VALUES (89,'Fighter10','','',3,1,100.00,100.00,100.00,100.00,100.00,100.00,200.00,200.00,100.00,100.00,100.00,100.00,100,100,100,100,100,100,100,100,0,6,-105.00,0.00,-55.00,0.00,0,0,0,0,0,'','',0,NULL,'',1,6,'N',9,0,2,0,0,'Fighting with region','','','',10,'',0,'0000-00-00 00:00:00',0,0); +INSERT INTO `characters` VALUES (90,'Fighter11','','',3,1,100.00,100.00,100.00,100.00,100.00,100.00,200.00,200.00,100.00,100.00,100.00,100.00,100,100,100,100,100,100,100,100,0,6,-100.00,0.00,-55.00,0.00,0,0,0,0,0,'','',0,NULL,'',1,6,'N',9,0,2,0,0,'Fighting with region','','','',10,'',0,'0000-00-00 00:00:00',0,0); +INSERT INTO `characters` VALUES (91,'Fighter12','','',3,1,100.00,100.00,100.00,100.00,100.00,100.00,200.00,200.00,100.00,100.00,100.00,100.00,100,100,100,100,100,100,100,100,0,6,-95.00,0.00,-55.00,0.00,0,0,0,0,0,'','',0,NULL,'',1,87,'N',9,0,2,0,0,'Fighting with region','','','',10,'',0,'0000-00-00 00:00:00',0,0); Modified: trunk/src/server/database/mysql/sc_location_type.sql =================================================================== --- trunk/src/server/database/mysql/sc_location_type.sql 2012-07-25 12:22:16 UTC (rev 8404) +++ trunk/src/server/database/mysql/sc_location_type.sql 2012-07-25 12:23:37 UTC (rev 8405) @@ -30,4 +30,5 @@ INSERT INTO `sc_location_type` VALUES (11,'hunting_ground'); INSERT INTO `sc_location_type` VALUES (12,'sleeping_area'); INSERT INTO `sc_location_type` VALUES (13,'NPC Room South Meadow'); +INSERT INTO `sc_location_type` VALUES (14,'NPC Room North Meadow'); Modified: trunk/src/server/database/mysql/sc_locations.sql =================================================================== --- trunk/src/server/database/mysql/sc_locations.sql 2012-07-25 12:22:16 UTC (rev 8404) +++ trunk/src/server/database/mysql/sc_locations.sql 2012-07-25 12:23:37 UTC (rev 8405) @@ -75,6 +75,11 @@ INSERT INTO `sc_locations` VALUES (49,13, 48, 'Meadow','-40.0', '0.0', '-245.0', 0, 0.0,'', 3); INSERT INTO `sc_locations` VALUES (50,12, -1, 'Sleep','10.0', '0.0', '-260.0', 5, 0.0,'', 3); INSERT INTO `sc_locations` VALUES (51,12, -1, 'Sleep','-40.0', '0.0', '-265.0', 5, 0.0,'', 3); +INSERT INTO `sc_locations` VALUES (52,14, 55, 'Meadow','-30.0', '0.0', '-55.0', 0, 0.0,'', 6); +INSERT INTO `sc_locations` VALUES (53,14, 52, 'Meadow','15.0', '0.0', '-55.0', 0, 0.0,'', 6); +INSERT INTO `sc_locations` VALUES (54,14, 53, 'Meadow','15.0', '5.0', '5.0', 0, 0.0,'', 6); +INSERT INTO `sc_locations` VALUES (55,14, 54, 'Meadow','-30.0', '5.0', '5.0', 0, 0.0,'', 6); +INSERT INTO `sc_locations` VALUES (56,12, -1, 'Sleep','-100.0', '0.0', '70.0', 5, 0.0,'', 6); Modified: trunk/src/server/database/mysql/sc_npc_definitions.sql =================================================================== --- trunk/src/server/database/mysql/sc_npc_definitions.sql 2012-07-25 12:22:16 UTC (rev 8404) +++ trunk/src/server/database/mysql/sc_npc_definitions.sql 2012-07-25 12:23:37 UTC (rev 8405) @@ -62,3 +62,7 @@ INSERT INTO sc_npc_definitions VALUES("85","Fighter6","Fighter6","NPC Room South Meadow","0.00","0.00","0","N","N"); INSERT INTO sc_npc_definitions VALUES("86","Fighter7","Fighter7","NPC Room South Meadow","0.00","0.00","0","N","N"); INSERT INTO sc_npc_definitions VALUES("87","Fighter8","Fighter8","NPC Room South Meadow","0.00","0.00","0","N","N"); +INSERT INTO sc_npc_definitions VALUES("88","Fighter9","Fighter9","NPC Room North Meadow","0.00","0.00","0","N","N"); +INSERT INTO sc_npc_definitions VALUES("89","Fighter10","Fighter10","NPC Room North Meadow","0.00","0.00","0","N","N"); +INSERT INTO sc_npc_definitions VALUES("90","Fighter11","Fighter11","NPC Room North Meadow","0.00","0.00","0","N","N"); +INSERT INTO sc_npc_definitions VALUES("91","Fighter12","Fighter12","NPC Room North Meadow","0.00","0.00","0","N","N"); Modified: trunk/src/server/database/mysql/sc_npctypes.sql =================================================================== --- trunk/src/server/database/mysql/sc_npctypes.sql 2012-07-25 12:22:16 UTC (rev 8404) +++ trunk/src/server/database/mysql/sc_npctypes.sql 2012-07-25 12:23:37 UTC (rev 8405) @@ -1179,3 +1179,15 @@ INSERT INTO sc_npctypes VALUES("128","Fighter8","DoNothing,Move,Nocturnal,Fight",0,"$walk","","","","","0", '<empty/> '); +INSERT INTO sc_npctypes VALUES("129","Fighter9","DoNothing,Move,Diurnal,Fight",0,"$walk","","","","","0", +'<empty/> +'); +INSERT INTO sc_npctypes VALUES("130","Fighter10","DoNothing,Move,Diurnal,Fight",0,"$walk","","","","","0", +'<empty/> +'); +INSERT INTO sc_npctypes VALUES("131","Fighter11","DoNothing,Move,Nocturnal,Fight",0,"$walk","","","","","0", +'<empty/> +'); +INSERT INTO sc_npctypes VALUES("132","Fighter12","DoNothing,Move,Nocturnal,Fight",0,"$walk","","","","","0", +'<empty/> +'); This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site. |
From: <lpa...@us...> - 2012-10-03 19:30:59
|
Revision: 8467 http://planeshift.svn.sourceforge.net/planeshift/?rev=8467&view=rev Author: lpancallo Date: 2012-10-03 19:30:53 +0000 (Wed, 03 Oct 2012) Log Message: ----------- fixed behaviours based on changes to the compare difficulty table. Modified Paths: -------------- trunk/src/server/database/mysql/char_skills.sql trunk/src/server/database/mysql/sc_npctypes.sql Modified: trunk/src/server/database/mysql/char_skills.sql =================================================================== --- trunk/src/server/database/mysql/char_skills.sql 2012-10-03 17:57:47 UTC (rev 8466) +++ trunk/src/server/database/mysql/char_skills.sql 2012-10-03 19:30:53 UTC (rev 8467) @@ -18,17 +18,19 @@ ); -# -# Dumping data for table 'character_skills' -# +# Acraig char INSERT INTO character_skills VALUES("3","0","4","4","3"); + +# vengeance char INSERT INTO character_skills VALUES("2","0","0","0","2"); INSERT INTO character_skills VALUES("2","11","0","0","3"); INSERT INTO character_skills VALUES("2","37","0","0","2"); -INSERT INTO character_skills VALUES("2","15","0","0","60"); +INSERT INTO character_skills VALUES("2","15","0","0","10"); INSERT INTO character_skills VALUES("2","38","0","0","5"); INSERT INTO character_skills VALUES("2","39","0","0","5"); INSERT INTO character_skills VALUES("2","40","0","0","20"); + +# ??? this points to nothing INSERT INTO character_skills VALUES("19","51","0","0","60"); INSERT INTO character_skills VALUES("19","50","0","0","60"); INSERT INTO character_skills VALUES("19","49","0","0","60"); @@ -36,9 +38,8 @@ INSERT INTO character_skills VALUES("19","47","0","0","60"); INSERT INTO character_skills VALUES("19","46","0","0","60"); -# Fighter skills on axe -INSERT INTO character_skills VALUES("6","2","0","0","2"); -INSERT INTO character_skills VALUES("7","2","0","0","2"); +# Fighter1 skills on axe (Fighter2 inherits from Fighter1) +INSERT INTO character_skills VALUES("6","2","0","0","100"); # Tribe skills on mining INSERT INTO character_skills VALUES("20","37","200","200","200"); Modified: trunk/src/server/database/mysql/sc_npctypes.sql =================================================================== --- trunk/src/server/database/mysql/sc_npctypes.sql 2012-10-03 17:57:47 UTC (rev 8466) +++ trunk/src/server/database/mysql/sc_npctypes.sql 2012-10-03 19:30:53 UTC (rev 8467) @@ -165,12 +165,15 @@ <react event="fight defencive" behavior="FightDefencive" /> <!-- Reaction to results of assessments --> -<react event="$target lame" behavior="AssessLame" /> +<react event="$target extremely weaker" behavior="AssessLame" /> +<react event="$target much weaker" behavior="AssessWeaker" /> <react event="$target weaker" behavior="AssessWeaker" /> <react event="$target equal" behavior="AssessEqual" /> <react event="$target stronger" behavior="AssessStronger" /> -<react event="$target powerfull" behavior="AssessPowerfull" />'); +<react event="$target much stronger" behavior="AssessStronger" /> +<react event="$target extremely stronger" behavior="AssessPowerfull" />'); + INSERT INTO sc_npctypes VALUES("9","Answerer","DoNothing",0,"","","","","","1", '<behavior name="turn to face" completion_decay="-1" growth="0" initial="0" > <locate obj="perception" /> This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site. |
From: <lpa...@us...> - 2013-02-10 21:01:36
|
Revision: 8587 http://planeshift.svn.sourceforge.net/planeshift/?rev=8587&view=rev Author: lpancallo Date: 2013-02-10 21:01:27 +0000 (Sun, 10 Feb 2013) Log Message: ----------- added sc_npc_definitions table Modified Paths: -------------- trunk/src/server/database/mysql/delete_npc_checkonly.sql trunk/src/server/database/mysql/deletenpc.sql Modified: trunk/src/server/database/mysql/delete_npc_checkonly.sql =================================================================== --- trunk/src/server/database/mysql/delete_npc_checkonly.sql 2013-02-10 20:30:35 UTC (rev 8586) +++ trunk/src/server/database/mysql/delete_npc_checkonly.sql 2013-02-10 21:01:27 UTC (rev 8587) @@ -1,16 +1,22 @@ # You can use this to check if there are any dependencies on other tables before deleting a monster -set @npcid=100024; +set @npcid=9581169; select count(*) from character_traits where character_id=@npcid; select count(*) from item_instances where char_id_owner=@npcid; select count(*) from character_skills where character_id=@npcid; -select count(*) from npc_knowledge_areas where player_id=@npc_id; -select count(*) from merchant_item_categories where player_id=@npc_id; +select count(*) from npc_knowledge_areas where player_id=@npcid; +select count(*) from merchant_item_categories where player_id=@npcid; +select count(*) from trainer_skills WHERE player_id=@npcid; +select count(*) from characters WHERE player_id=@npcid; +select count(*) from sc_npc_definitions WHERE char_id=@npcid; +#if part of a tribe +select count(*) from tribe_members where member_id=@npcid; + # Others tables you may be interested in checking for sentient NPCs are: # npc_triggers where area=@npc_name; # npc_bad_text where npc=@npc_name; -# npc_knowledge_areas where player_id=@npc_id; +# npc_knowledge_areas where player_id=@npcid; # npc_responses where id>=@min_resp and id<=@max_resp; Modified: trunk/src/server/database/mysql/deletenpc.sql =================================================================== --- trunk/src/server/database/mysql/deletenpc.sql 2013-02-10 20:30:35 UTC (rev 8586) +++ trunk/src/server/database/mysql/deletenpc.sql 2013-02-10 21:01:27 UTC (rev 8587) @@ -1,15 +1,6 @@ # # How to delete an NPC # -# The tables populated by an NPC are: -# -# npc_bad_text -# npc_knowledge_areas -# npc_responses -# npc_triggers -# objects -# player_items -# players # # use this command to know which NPCs are currently loaded # select name from players where alive_ind='Y'; @@ -35,25 +26,9 @@ delete from item_instances where char_id_owner=@npc_id; delete from character_skills where character_id=@npc_id; delete from merchant_item_categories where player_id=@npc_id; -delete from characters where id=@npc_id; +delete from trainer_skills where player_id=@npc_id; +#delete npcclient entries +delete from sc_npc_definitions WHERE char_id=@npc_id; - -# NPC names currently in game -# -# Rabartus Livrandar -# Jefecra Harcrit -# Aleena Arlavin -# Ri\'Miyan Sulka -# Thorian Gronk -# Jayose -# Lori Try\'llyn -# Gayla Grotemey -# Jeyarp Grotemey -# Rinna Voladrand -# Boralis Voladrand -# Dur\'ok - -# Currently not used -# Gurard Anvilforce -# Maynard +delete from characters where id=@npc_id; This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site. |
From: <lpa...@us...> - 2013-02-13 20:26:05
|
Revision: 8592 http://planeshift.svn.sourceforge.net/planeshift/?rev=8592&view=rev Author: lpancallo Date: 2013-02-13 20:25:54 +0000 (Wed, 13 Feb 2013) Log Message: ----------- added same trigger "goldore" to MaleEnki to test priority. Modified Paths: -------------- trunk/src/server/database/mysql/npc_responses.sql trunk/src/server/database/mysql/npc_triggers.sql trunk/src/server/database/mysql/quest_scripts.sql Modified: trunk/src/server/database/mysql/npc_responses.sql =================================================================== --- trunk/src/server/database/mysql/npc_responses.sql 2013-02-13 19:35:04 UTC (rev 8591) +++ trunk/src/server/database/mysql/npc_responses.sql 2013-02-13 20:25:54 UTC (rev 8592) @@ -85,6 +85,10 @@ INSERT INTO `npc_responses` VALUES (46,37,NULL,NULL,NULL,NULL,NULL,'','','','','<response><run script="explore_area" with="Area = \'NPCroom2\'; Range = 100; Exp = 1000;"/></response>','',NULL,NULL,NULL,NULL,NULL,NULL); INSERT INTO `npc_responses` VALUES (47,38,'Ok, I will bring you up by send the \"bring up\" command to the beast.','','','','','','','','','<response><respond/><npccmd cmd=\"bring_up\" /></response>','',0,NULL,NULL,NULL,NULL,NULL); INSERT INTO `npc_responses` VALUES (48,39,'Welcome to the Winch. Tell me to "winch up" to have the winch beast winch up, "winch down" to have the winch beast winch down, or "bring me up" to have the winch beast bring you up.','','','','','','','','','','',0,NULL,NULL,NULL,NULL,NULL); + +INSERT INTO `npc_responses` VALUES (49,40,'Enkidukai are a feline race! Meowwwww','','','','','','','','','','',0,NULL,NULL,NULL,NULL,NULL); +INSERT INTO `npc_responses` VALUES (50,41,'This is the answer from MaleEnki trigger KA','','','','','','','','','','',0,NULL,NULL,NULL,NULL,NULL); + /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; Modified: trunk/src/server/database/mysql/npc_triggers.sql =================================================================== --- trunk/src/server/database/mysql/npc_triggers.sql 2013-02-13 19:35:04 UTC (rev 8591) +++ trunk/src/server/database/mysql/npc_triggers.sql 2013-02-13 20:25:54 UTC (rev 8592) @@ -69,6 +69,8 @@ INSERT INTO `npc_triggers` VALUES (37,'!anyrange',0,'NPCroom2'); INSERT INTO `npc_triggers` VALUES (38,'bring me up',0,'WinchMovers'); INSERT INTO `npc_triggers` VALUES (39,'grettings',0,'WinchMovers'); +INSERT INTO `npc_triggers` VALUES (40,'enkidukai',0,'MaleEnki'); +INSERT INTO `npc_triggers` VALUES (41,'goldore',0,'MaleEnki'); /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; Modified: trunk/src/server/database/mysql/quest_scripts.sql =================================================================== --- trunk/src/server/database/mysql/quest_scripts.sql 2013-02-13 19:35:04 UTC (rev 8591) +++ trunk/src/server/database/mysql/quest_scripts.sql 2013-02-13 20:25:54 UTC (rev 8592) @@ -56,7 +56,7 @@ ('204',204,'P: quest4\n\nQuestMaster2: Yes, this is QuestMaster2 Quest4.\n\nAssign Quest.\n\n... NoRepeat\n\nP: step2\n\nQuestMaster2: Yes, this is step2, it\'s not repeatable.\n\nP: step2b\n\nQuestMaster2: Yes, this is step2b, it\'s not repeatable.\n\nComplete QuestMaster2 Quest 4 Step 2.\n\n... NoRepeat\nRequire completion of QuestMaster2 Quest 4 Step 2.\nP: step3\nQuestMaster2: Yes, this is step3, it\'s not repeatable.\nComplete QuestMaster2 Quest 4 Step 3.\n...\n\nP: done.\n\nQ: Your done. [Type \'quest5\',verify \'QuestMaster1 Quest 5\' assigned.]\n'), ('205',205,'P: quest5\n\nQuestMaster2: Yes, this is QuestMaster2 Quest5. [Type \'done\']\n\nAssign Quest.\n\n...\n\nP: done.\n\nQ: Your done.\n'), ('206',206,'P: quest6\n\nQuestMaster2: Yes, this is QuestMaster2 Quest6. [Type \'done\']\n\nAssign Quest.\n\n...\n\nP: done.\n\nQ: Your done[You should now never be able to start quest6 again].\n'), - ('207',-1,'P: ring\r\nMenu: Can you tell me about rings?\r\n\r\ngeneral: Rings are interesting because they often have magical powers. You should definitely keep them if you find any.\r\n...\r\nP: talad\r\nMenu: Please describe the god Talad for me.\r\n\r\ng: He is best described as drunk in love.\r\n...\r\nP: laanx\r\nMenu: Please describe the god Laanx for me.\r\n\r\ng: Not sure if she is a he or a she, but s/he likes very spiky temples apparently.'), + ('207',-1,'P: ring\r\ngeneral: Rings are interesting because they often have magical powers. You should definitely keep them if you find any.\r\n...\r\nP: talad\r\n\r\ng: He is best described as drunk in love.\r\n...\r\nP: laanx\r\n\r\ng: Not sure if she is a he or a she, but s/he likes very spiky temples apparently.\r\n...\r\nP: goldore\r\n\r\ngeneral: This answer is part of the general KA.'), ('208',207,'# Quest Acquire Lapar\n# ID 1214\n# Quest Description: Smith needs some juiceberry fruit before he will sell you any lapar.\n# Player lockout: 43200\n# 12 hours \n# Quest Lockout: 1800\n# 30 minutes \n# Syntax update 5.11.2008\n# Updated with menu system 11/2008.\n\nP: Give me Lapar.\nMenu: I\'m looking for some Lapar.\n\nSmith: Very well $sir, I have some lapar you can have, but it will cost you. [Levrus chuckles.] Shall we say two hundred tria, and three juiceberry fruit? (/planeshift/data/voice/Levrusacquirelapar/1verywellsir.spx)\nP: No. P: Yes.\nMenu: No, that is too much! Are you kidding me old man? Menu: You hold your lapar dear old man, but I\'ll pay your price.\n\nSmith: That is my price $playerrace, come back if you change your mind. (/planeshift/data/voice/Levrusacquirelapar/2thatismyprice.spx)\nSmith: Excellent! Bring me the fruit, and I\'ll have some lapar ready for you. (/planeshift/data/voice/Levrusacquirelapar/3excellentbringmethefruit.spx)\nAssign Quest.\n\n... NoRepeat\n# Step 2\nPlayer Gives Smith 3 Juiceberry fruit.\nSmith: Very nice, now for the tria, all two hundred of them please. [Levrus holds out his hand with a smile.] (/planeshift/data/voice/Levrusacquirelapar/4verynicenowforthetria.spx)\nComplete Acquire Lapar Step 2.\n\n...\n# Step 3\nRequire Completion of Acquire Lapar Step 2.\nPlayer Gives Smith 200 tria.\nSmith: [The Smith takes the coins and stuffs them into his coin-pouch.] Very well, one bottle of Lapar for the $playerrace. [Smith hands you a bottle.] Use it wisely, it is not as abundant as water. [Smith chuckles as he turns his attention elsewhere.] (/planeshift/data/voice/Levrusacquirelapar/5verywellonebottle.spx)\nGive 1 Lapar. Give 600 Exp.\nComplete Acquire Lapar Step 3.'), ('209',208,'# Quest One Thousand Year Sammich \r\n\r\n# Quest Description: You are hungry. Feed yourself.\r\n\r\n# Quest Category: \r\n\r\n# Description Red Paperclip - an ordinary red paperclip. It might possibly be traded for amazing and unheard-of wonders.\r\n\r\n# Description Sandwich Plate - An ancient chipped plate divided into gaudily coloured sections.\r\n\r\n# Description Artisan Waybread - A fluffy warm loaf of freshly-baked bread.\r\n\r\n# Description Corned Beef - A packet of tender, juicy, wafer thin meat.\r\n\r\n# Description Smoked Provolone - A bundle of creamy white cheese slices that carry a faint smoky aroma.\r\n\r\n# Description Sublime Sandwich - The most perfect sandwich you have ever seen, bar none.\r\n\r\n# Description Condiment Recipe - An old parchment, badly creased and stained but still legible.\r\n\r\n# Description Silver Penny - A unit of currency.\r\n\r\n#--------------------------------------------------------------\r\n\r\n# Version 1.0\r\n\r\n# Author(s): Oomi, UTM\r\n\r\n#--------------------------------------------------------------\r\n\r\n# Parameters (Remarked out for now)\r\n\r\n# player lockout -1\r\n\r\n# quest lockout 500\r\n\r\n# Prerequisites: none\r\n\r\n#--------------------------------------------------------------\r\n\r\n# Notes: \r\n\r\n#-------------------------------------------------------------- \r\n \r\n\r\nP: Give me quest.\r\nMenu: I am hungry for something different. Got any food?\r\n\r\nGertie Hollaback: Yup. (/this/data/voice/sammich/1-yup.spx)\r\n\r\nP: rude question. P: Nice question.\r\nMenu: Can I have some? Menu: Well... what kind?\r\n\r\nG: No, ya ain\'t gunna get yer grubby mitts on my food. What kinda person comes up to a complete stranger an esks for a bite\'a her well earned grub? Now you git yerself off my premises a\'for I have ta blast you off. (/this/data/voice/sammich/2-grubbymitts.spx)\r\nG: [Gertie looks down at her bag, and rummages around a bit.] You like crawdads? (/this/data/voice/sammich/3-crawdads.spx)\r\n\r\nAssign Quest. \r\n\r\n... NoRepeat \r\n\r\n# Step 2\r\n\r\nP: No. P: Yes. P: Don\'t know.\r\nMenu: They are horrid little creatures. Menu: They are delicious. Menu: Do I like what?\r\n\r\nG: What? You just ain\'t got no taste. Get on outta here! (/this/data/voice/sammich/4-notaste.spx)\r\nComplete One Thousand Year Sammich Step 2. Complete One Thousand Year Sammich.\r\n\r\nG: [Gertie rummages around in her bag.] That\'s too bad. I ain\'t got none anyhow. (/this/data/voice/sammich/5-toobad.spx)\r\nComplete One Thousand Year Sammich Step 2.\r\n\r\nG: How am I suppose to know what you like? Don\' ask me no fool questions. (/this/data/voice/sammich/6-whatyoulike.spx)\r\nComplete One Thousand Year Sammich Step 2. \r\n \r\n\r\n... NoRepeat \r\n\r\n# Step 3\r\n\r\nRequire completion of One Thousand Year Sammich Step 2.\r\n\r\nP: give me food.\r\nMenu: So, where CAN a body get a snack around here?\r\n\r\nG: Well, I just had a right tasty sammich. Yup, I did. Thick an\' juicy, one-o\'-a-kind like ya done ne\'er had bee-for. [Gertie stares off into the distance and pulls a folded red wire out of her pocket.] (/this/data/voice/sammich/7-tastysammich.spx)\r\nComplete One Thousand Year Sammich Step 3. \r\n\r\n... NoRepeat \r\n\r\n# Step 4\r\n\r\nRequire completion of One Thousand Year Sammich Step 3.\r\n\r\nP: about sammich.\r\nMenu: Well, that sounds nice. Where do I learn more about this \"sammich\"?\r\n\r\nG: [Gertie unfolds the wire and uses it to pick her teeth with great gusto.] Hmmm. Dwarves is real fond o\' they food. Try askin\' one. Oh, here, have a toothpicker. I\'m done with it. [Gertie wipes off the red wire, folds it back up, and hands it to you.] (/this/data/voice/sammich/8-dwarvesfond.spx)\r\nGive 1 Red Paperclip.\r\nComplete One Thousand Year Sammich Step 4. \r\n\r\n... NoRepeat \r\n\r\n# Step 5.\r\n\r\nRequire completion of One Thousand Year Sammich Step 4.\r\n\r\nP: Gertie sent me.\r\nMenu: I\'m starving! Gertie told me you made the best sandwiches around.\r\n\r\nReginald Hartlepool: [Reginald arches an eyebrow.] So, the lowly come to me once again with the desire to sample the fabled festival of sumptuousness that is the pride and heritage of my ancestors? Of course you are. My family\'s wondrous delectables are legendary in these lands. This astounding recipe has been handed down through generations of Hartlepools, each keeping the secrets of those who came before. And so it has come to me, Reginald HH Hartlepool the Third. As you can see, I have used it wisely. [Reginald grins and pats his protruding belly. As he does so, the button on his pants makes a loud pop and goes flying into the air.] (/this/data/voice/sammich/1Sothelowly-1.spx|/this/data/voice/sammich/1Sothelowly-2.spx)\r\n\r\nComplete One Thousand Year Sammich Step 5. \r\n \r\n\r\n...\r\n\r\n...\r\n\r\n... NoRepeat \r\n\r\n# Step 6, 7, [8 for lock]. 6 and 7 will make small branches that will merge a little later. 6 will be the harder branch, though it seems to start off nicer.\r\n\r\nP: you fat. P: lost something.\r\nMenu: You like your own food a little too much, chubby. Menu: You seem to have lost something.\r\n\r\nRequire completion of One Thousand Year Sammich Step 5.\r\n\r\nReginald Hartlepool: [Reginald looks down and gasps, grabbing his pants before they fall down. He pats his pockets awkwardly with his free hand as if looking for something, but stops and looks at you in dismay.] Alas... you may be right on that count. It will not be the first time our great Sandwich of sandwiches has brought a Hartlepool to his knees in shame. Woe is upon my family once again as I stand before you, shed of my pride and nearly my pants for the love of the finest sandwich ever constructed. Anguish and pity is upon me as my worthy ancestors look upon this catastrophe that has befallen my unworthy garment fastener. Misery shall become my name, for I have not a single bit of string, nor a bent bit of metal to repair this onerous calamity.(/this/data/voice/sammich/2Reginaldlooksdown-1.spx|/this/data/voice/sammich/2Reginaldlooksdown-2.spx)\r\n\r\nComplete One Thousand Year Sammich Step 6. Complete One Thousand Year Sammich Step 8.\r\n\r\nRequire completion of One Thousand Year Sammich Step 5.\r\n\r\nReginald Hartlepool: [Reginald looks down and gasps, grabbing his pants before they fall down. He pats his pockets awkwardly with his free hand as if looking for something, but stops and looks at you forlornly.] Oh, good gracious! What an embarrassing predicament. It seems my lust for flavourful delicacies has overcome the fortitude of my slacks, and here I sit without the means to repair the travesty that has become of said garment. If you have something... anything to aid me in this most momentous time of need, I will reward you most graciously.(/this/data/voice/sammich/3ohgoodgracious.spx)\r\n\r\nComplete One Thousand Year Sammich Step 7. Complete One Thousand Year Sammich Step 8. \r\n\r\n... NoRepeat \r\n\r\n# Step 9 - branch from 6. \"You are fat\"\r\n\r\nRequire completion of One Thousand Year Sammich Step 6.\r\n\r\nP: Have paperclip.\r\nMenu: I do have a red paperclip, but it will cost you.\r\n\r\nReginald Hartlepool: I will pay any price you name. I will do anything you ask to save my fallen pride. [Reginald closes his eyes, seeming to brace for the worst.] (/this/data/voice/sammich/4Iwillpayanyprice.spx)\r\nComplete One Thousand Year Sammich Step 9. \r\n\r\n... NoRepeat \r\n\r\n# Step 10\r\n\r\nRequire completion of One Thousand Year Sammich Step 9.\r\n\r\nP: sammich.\r\nMenu: It will cost you... a sammich!\r\n\r\nReginald Hartlepool: [Reginald looks aghast for a moment and almost drops his pants before he seems to realise what you asked for.] Wait... just a sandwich? Very well. I do not have one, but on my honour as a Hartlepool, I will tell you where to procure one in exchange for the paperclip. (/this/data/voice/sammich/5Waitjustasandwich.spx)\r\nComplete One Thousand Year Sammich Step 10. \r\n\r\n... NoRepeat \r\n\r\n# Step 11\r\n\r\nRequire completion of One Thousand Year Sammich Step 10.\r\n\r\nPlayer gives Reginald Hartlepool 1 Red Paperclip.\r\nMenu: Give Reginald your Red Paperclip.\r\n\r\nReginald Hartlepool: [Reginald takes the red paperclip and affixes it to his wayward trousers. He grins as the thing holds.] Wondrous And even a little stylish. Why, red paperclip trouser afixers might just become the new style! Thank you oh so much. Ah, yes, your \'sammich\'. Gertie that you conversed with before coming to me should have more. I sold her quite a few of my best creations. I don\'t know why she didn\'t just give you one in the first place. Here, take a few coins, as I am sure she will not part with such wondrous and savoury feasts cheaply. (/this/data/voice/sammich/6wondrousandeven.spx)\r\nGive 10 Silver Penny.\r\nComplete One Thousand Year Sammich Step 11. \r\n\r\n... NoRepeat \r\n\r\n# Step 12 - talk to the Gertie again.\r\n\r\nRequire completion of One Thousand Year Sammich Step 11.\r\n\r\nP: About sammich.\r\nMenu: Reginald told me you have the sandwiches.\r\n\r\nGertie Hollaback: Ya, so? (/this/data/voice/sammich/9-yeahso.spx)\r\nComplete One Thousand Year Sammich Step 12. \r\n\r\n... NoRepeat \r\n\r\n# Step 13\r\n\r\nRequire completion of One Thousand Year Sammich Step 12.\r\n\r\nP: more about sammich.\r\nMenu: Why didn\'t you tell me you had one?\r\n\r\nG: You asked whar you could larn about one. Ya din\'it ask if I had one. If you asked that, I would\'a said, \'Sure I \'as got one, but it\'ll cost ya five, no, ten silver pennies.\' You got ten silver pennies on you? Hand em over and you got yourself a sammich. (/this/data/voice/sammich/10-youasked.spx)\r\nComplete One Thousand Year Sammich Step 13. \r\n\r\n... NoRepeat \r\n\r\n# Step 14 - End branch.\r\n\r\nRequire completion of One Thousand Year Sammich Step 13.\r\n\r\nPlayer gives Gertie Hollaback 10 Silver Penny.\r\nMenu: Give Gertie the 10 Silver Pennies.\r\n\r\nG: Lemme count these har coins first. One...two...tree...five... [Gertie glances up at you and closes her hand.] Ten. All here. Here is yar sammich. (/this/data/voice/sammich/11-lemmecount.spx)\r\nGive 1 Sublime Sandwich. Give 10000 Exp.\r\nComplete One Thousand Year Sammich Step 14. Complete One Thousand Year Sammich. \r\n\r\n... NoRepeat \r\n\r\n# Step 15 - branch from 7 \"lost something\"\r\n\r\nRequire completion of One Thousand Year Sammich Step 7.\r\n\r\nP: Have paperclip.\r\nMenu: I happen to have this odd little bit of metal; would it help?\r\n\r\nReginald Hartlepool: [Reginald claps his hands together in joy, then quickly grabs at his falling trousers again.] Oh please, if you would be so kind as to give me this wonderful object, I shall, I shall... [Reginald lowers his voice to a whisper.] I shall help you to learn the secret of the Sandwich! (/this/data/voice/sammich/7ohplease.spx)\r\nComplete One Thousand Year Sammich Step 15. \r\n\r\n... NoRepeat \r\n\r\n# Step 16\r\n\r\nRequire completion of One Thousand Year Sammich Step 15.\r\n\r\nPlayer gives Reginald Hartlepool 1 Red Paperclip.\r\nMenu: Give Reginald your Red Paperclip.\r\n\r\nReginald Hartlepool: Alas, I have no children to whom I may pass on the marvellous lore of the Sandwich. Since you have proven yourself a remarkably considerate and compassionate being, I have chosen to pass my knowledge on to you. However, you must learn the lore just as a child of my own getting would be required to do. I hereby present to you that which has been passed down in my family for generations unnumbered. I give you... the Sandwich Plate! [Reginald gingerly places an elderly serving plate in your hands. It is quite chipped and contains four sections, each in a different, and somewhat gaudy, colour.] When you have given this magnificent object the reverence due to it, tell me you are ready and I will impart its sublime knowledge to you. (/this/data/voice/sammich/8alasihavenochildren-1.spx|/this/data/voice/sammich/8alasihavenochildren-2.spx)\r\nGive 1 Sandwich Plate.\r\nComplete One Thousand Year Sammich Step 16. \r\n\r\n... \r\n\r\n# Step 17\r\n\r\nRequire completion of One Thousand Year Sammich Step 16.\r\n\r\nP: Ready.\r\nMenu: I am ready to learn all that you have to teach me. Please begin.\r\n\r\nReginald Hartlepool: [Reginald clears his throat.] Ahem! This was first done by my great great great grandsire, nearly five hundred years ago. Every part of the Sandwich has its proper place during assembly. The bread is placed in the fuchsia section in the centre. The meat must always reside in the cerulean section, just there. Cheese finds its proper place in the ochre section. [Reginald suddenly glares at you.] Remove your filthy thumb from the ochre section AT ONCE! (/this/data/voice/sammich/9ahem.spx)\r\n\r\nComplete One Thousand Year Sammich Step 17. \r\n\r\n... \r\n\r\n# Step 18\r\n\r\nRequire completion of One Thousand Year Sammich Step 17.\r\n\r\nP: removes thumb.\r\nMenu: $playername removes $his thumb quickly under Reginald\'s watchful eye.\r\n\r\nReginald Hartlepool: That\'s better. Now to continue, the last and most important section is the chartreuse section. This section contains the condiment. It is the condiment which binds the Sandwich together into a cohesive whole that is better than the sum of its respective parts. Your next task will be to collect the finest representatives of each of these four ingredients and return to me once you have them. Then and only then will the next mystery be revealed unto you.(/this/data/voice/sammich/10thatsbetter.spx)\r\n\r\nComplete One Thousand Year Sammich Step 18. \r\n\r\n... \r\n\r\n# Step 19\r\n\r\nRequire completion of One Thousand Year Sammich Step 18.\r\n\r\nP: next step.\r\nMenu: What must I do first, oh grand Sandwich Master?\r\n\r\nReginald Hartlepool: I am so glad you asked. Find Butch, the Baker, and get his finest bread. Artisan Waybread only, if you please. Then go to Loudon, the butcher, to procure some of his finest cuts of meat. Corned Beef, nothing else will do. Finally, you will travel to Cabot, purveyor of the finest cheeses. What will you get there? Why, only the finest Smoked Provolone! When you have all these things, you will return to me and I will give you the Final Secret! (/this/data/voice/sammich/11iamsogladyou.spx)\r\n\r\nComplete One Thousand Year Sammich Step 19. \r\n\r\n... \r\n \r\n\r\n# Step 20\r\n\r\nRequire completion of One Thousand Year Sammich Step 19.\r\n\r\nP: Got bread.\r\nMenu: Reginald sent me for some of your finest bread.\r\n\r\nButch: Ah yes, we have ze fineszt breadz in all ze landz! Come, come, look upon my cre-a-see-onz and name ze bread you need.\r\n\r\nComplete One Thousand Year Sammich Step 20. \r\n\r\n... NoRepeat \r\n\r\n# Step 21\r\n\r\nP: *. P: Artisan Waybread.\r\nMenu: Ummm... cinnamon rolls? Menu: ?=Name your bread\r\n\r\nRequire completion of One Thousand Year Sammich Step 20.\r\n\r\nButch: No no, Rezhinald deed not send you here to buy ZAT!\r\n\r\nRequire completion of One Thousand Year Sammich Step 20.\r\n\r\nButch: Ah Yez! Ze fineszt Arteesan Waybread, she is yours to take. Go quickly, now, so she does not go stale on you.\r\n\r\nGive 1 Artisan Waybread.\r\n\r\nComplete One Thousand Year Sammich Step 21. \r\n\r\n... \r\n\r\n# Step 22\r\n\r\nRequire completion of One Thousand Year Sammich Step 19.\r\n\r\nP: Got meat.\r\nMenu: Got any meat?\r\n\r\nLoudon: That I do! Only the finest meat. What cut would you be looking for today?\r\n\r\nComplete One Thousand Year Sammich Step 22. \r\n\r\n... NoRepeat \r\n\r\n# Step 23\r\n\r\nP: *. P: corned beef.\r\nMenu: Would pickled consumer be good on a sandwich? Menu: ?=Name your meat\r\n\r\nRequire completion of One Thousand Year Sammich Step 22.\r\n\r\nLoudon: What? No no no. that will not do at all.\r\n\r\nRequire completion of One Thousand Year Sammich Step 22.\r\n\r\nLoudon: Ah ha! You must be making one of Reginald\'s famed Sublime Sandwiches. Here are your cuts.\r\n\r\nGive 1 Corned Beef.\r\n\r\nComplete One Thousand Year Sammich Step 23. \r\n\r\n... \r\n\r\n# Step 24 - Last option, breaking the chain up to test the bother of reclicking the npc.\r\n\r\nRequire completion of One Thousand Year Sammich Step 19.\r\n\r\nP: Got cheese.\r\n\r\nMenu: Hello, Cabot. Would you have some fresh cheese for Reginald\'s sandwich?\r\n\r\nCabot: So, it is the famed $playername, come to sample my wares. Well then, I say, No cheese for you! That is, unless you can perfectly name the cheese you wish to have. No.... I want you to spell it.... backwards!\r\n\r\nComplete One Thousand Year Sammich Step 24. \r\n\r\n... NoRepeat \r\n\r\n# Step 25\r\n\r\nP: *. P: Clue. P: enolovorp dekoms.\r\nMenu: Backwards? Are you insane? Menu: Can I have a clue? Menu: ?=Name your cheese\r\n\r\nRequire completion of One Thousand Year Sammich Step 24.\r\n\r\nCabot: You obviously do not understand the importance of the cheese. Come back when you know what you are really searching for.\r\n\r\nRequire completion of One Thousand Year Sammich Step 24.\r\n\r\nCabot: Ha! Too hard for you, is it? Well, I can tell you that the last word is... Dekoms!\r\n\r\nRequire completion of One Thousand Year Sammich Step 24.\r\n\r\nCabot: The Smoked Provolone! Wonderful choice. Let me package that right up for you. [Newman wraps the cheese quickly and hands it to you.]\r\n\r\nGive 1 Smoked Provolone.\r\n\r\nComplete One Thousand Year Sammich Step 25. \r\n\r\n... \r\n\r\n# Step 26.\r\n\r\nRequire completion of One Thousand Year Sammich Step 21.\r\n\r\nRequire completion of One Thousand Year Sammich Step 23.\r\n\r\nRequire completion of One Thousand Year Sammich Step 25.\r\n\r\nP: Have things.\r\nMenu: I have procured all the ingredients.\r\n\r\nReginald Hartlepool: Very good! You are now ready for the final lesson. Give me the ingredients and the Sandwich plate, if you please. (/this/data/voice/sammich/12verygood.spx)\r\n\r\nComplete One Thousand Year Sammich Step 26. \r\n\r\n... NoRepeat \r\n\r\n#Step 27\r\n\r\nRequire completion of One Thousand Year Sammich Step 26.\r\n\r\nPlayer gives Reginald Hartlepool 1 Sandwich Plate, 1 Artisan Waybread, 1 Corned Beef, 1 Smoked Provolone.\r\nMenu: Give Reginald the 3 ingredients you have gathered and the plate.\r\n\r\nReginald Hartlepool: Observe carefully as I put the ingredients in their proper sections on the Sandwich Plate. Now tell me, my good apprentice, which section is empty? (/this/data/voice/sammich/13observecarefully.spx)\r\n\r\nComplete One Thousand Year Sammich Step 27. \r\n\r\n... NoRepeat \r\n\r\n# Step 28\r\n\r\nP: *. P: chartreuse section. chartreuse.\r\nMenu: The one without anything in it? Menu: The chartreuse section appears to be empty.\r\n\r\nRequire completion of One Thousand Year Sammich Step 26.\r\n\r\nReginald Hartlepool: I have no patience for such sarcastic drivel. (/this/data/voice/sammich/14ihavenopatience.spx)\r\n\r\nRequire completion of One Thousand Year Sammich Step 26.\r\n\r\nReginald Hartlepool: Absolutely correct! You have learned well. The Sandwich is nothing without its condiment. Now, pay attention whilst I deliver the tasty denouement to its proper location. [Reginald pulls a small glass jar from his pocket, gingerly removes the cork from it, then dribbles a few drops of dark golden liquid onto the proper section.] The Sandwich is now ready for assembly. Put the condiment on both sides of the bread, then lightly drape the meat across both halves of the bread. Next, delicately place the cheese in a similar fashion. At last, we may unite the two halves and admire the completed Sandwich. [Reginald holds the sandwich aloft for a moment and stares at it with moist eyes.] Words cannot adequately express my pride in your achievements but perhaps these gifts will. They hold your future, young one. (/this/data/voice/sammich/15absolutelycorrect-1.spx|/this/data/voice/sammich/15absolutelycorrect-2.spx)\r\n\r\nGive 1 Sandwich Plate. Give 1 Condiment Recipe.\r\n\r\nComplete One Thousand Year Sammich Step 28. \r\n\r\n... \r\n\r\n# Step 29 Reginald goes Scottish\r\n\r\nRequire completion of One Thousand Year Sammich Step 28.\r\n\r\nP: hungry.\r\nMenu: But I\'m STILL hungry!\r\n\r\nReginald Hartlepool: [Reginald turns beet red and starts sputtering.] Ye ingrate! Ye... ye... pasty-faced git! I gi\' ye all I knoo and ye ken do nowt but whinge! Och, tae it then and away wi\' ye! [Reginald throws the sammich in the general direction of your head.] (/this/data/voice/sammich/16yeingrate.spx)\r\n\r\nGive 1 Sublime Sandwich. Give 40000 Exp.\r\n\r\nComplete One Thousand Year Sammich Step 29.\r\n'), ('210',209,'P:can I help\r\nMenu: I\'ll solve a riddle for a tria.\r\n\r\nMerchant: Ok that is fun. I like riddles. What is my favorite color?\r\n\r\nAssign Quest\r\n\r\n...\r\n\r\nP: *. P: blue\r\nMenu: That isn\'t a riddle, little man. Menu: ?=Favorite color\r\n\r\nM: I don\'t care what you think of my riddle! What is my favorite color?\r\nM: Yes, blue is my favorite color. Isn\'t it a wonderful color? Here is your reward.\r\nGive 1 tria.\r\n'), This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site. |
From: <ma...@us...> - 2013-02-27 19:07:06
|
Revision: 8617 http://planeshift.svn.sourceforge.net/planeshift/?rev=8617&view=rev Author: magodra Date: 2013-02-27 19:06:58 +0000 (Wed, 27 Feb 2013) Log Message: ----------- - Updated DB tables that didn't have drop. (PS#5913) Modified Paths: -------------- trunk/src/server/database/mysql/character_factions.sql trunk/src/server/database/mysql/character_variables.sql trunk/src/server/database/mysql/item_stats.sql trunk/src/server/database/mysql/loot_modifiers_restrains.sql trunk/src/server/database/mysql/quest_scripts.sql trunk/src/server/database/mysql/quests.sql Modified: trunk/src/server/database/mysql/character_factions.sql =================================================================== --- trunk/src/server/database/mysql/character_factions.sql 2013-02-27 18:42:39 UTC (rev 8616) +++ trunk/src/server/database/mysql/character_factions.sql 2013-02-27 19:06:58 UTC (rev 8617) @@ -1,5 +1,5 @@ - -CREATE TABLE IF NOT EXISTS `character_factions` ( +DROP TABLE IF EXISTS `character_factions`; +CREATE TABLE `character_factions` ( `character_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'The PID of the character this faction is assigned to', `faction_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'The id of the faction the points are for', `value` int(10) NOT NULL DEFAULT '0' COMMENT 'The amount of points in this faction', Modified: trunk/src/server/database/mysql/character_variables.sql =================================================================== --- trunk/src/server/database/mysql/character_variables.sql 2013-02-27 18:42:39 UTC (rev 8616) +++ trunk/src/server/database/mysql/character_variables.sql 2013-02-27 19:06:58 UTC (rev 8617) @@ -1,4 +1,5 @@ -CREATE TABLE IF NOT EXISTS `character_variables` ( +DROP TABLE IF EXISTS `character_variables`; +CREATE TABLE `character_variables` ( `character_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'The character this variable is assigned to', `name` varchar(255) NOT NULL COMMENT 'The name of the variable', `value` varchar(255) NOT NULL COMMENT 'The value of the variable', Modified: trunk/src/server/database/mysql/item_stats.sql =================================================================== --- trunk/src/server/database/mysql/item_stats.sql 2013-02-27 18:42:39 UTC (rev 8616) +++ trunk/src/server/database/mysql/item_stats.sql 2013-02-27 19:06:58 UTC (rev 8617) @@ -19,9 +19,9 @@ -- Table structure for table `item_stats` -- -DROP TABLE IF EXISTS `item_stats`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; +DROP TABLE IF EXISTS `item_stats`; CREATE TABLE `item_stats` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `stat_type` char(1) NOT NULL DEFAULT 'B', Modified: trunk/src/server/database/mysql/loot_modifiers_restrains.sql =================================================================== --- trunk/src/server/database/mysql/loot_modifiers_restrains.sql 2013-02-27 18:42:39 UTC (rev 8616) +++ trunk/src/server/database/mysql/loot_modifiers_restrains.sql 2013-02-27 19:06:58 UTC (rev 8617) @@ -2,6 +2,7 @@ # Table structure for table loot_modifiers_restrains # +DROP TABLE IF EXISTS `loot_modifiers_restrains`; CREATE TABLE `planeshift`.`loot_modifiers_restrains` ( `loot_modifier_id` INTEGER NOT NULL COMMENT 'The id of the loot modifier rule', `item_id` INTEGER NOT NULL COMMENT 'The id of the item included in the loot modifier rule', Modified: trunk/src/server/database/mysql/quest_scripts.sql =================================================================== --- trunk/src/server/database/mysql/quest_scripts.sql 2013-02-27 18:42:39 UTC (rev 8616) +++ trunk/src/server/database/mysql/quest_scripts.sql 2013-02-27 19:06:58 UTC (rev 8617) @@ -14,12 +14,12 @@ /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0*/; -DROP TABLE IF EXISTS `quest_scripts`; # # Table structure for table 'quest_scripts' # +DROP TABLE IF EXISTS `quest_scripts`; CREATE TABLE `quest_scripts` ( `id` int(10) unsigned NOT NULL auto_increment, `quest_id` int(10) NOT NULL default '0' COMMENT 'FK to quests table, or -1 for KA scripts.', Modified: trunk/src/server/database/mysql/quests.sql =================================================================== --- trunk/src/server/database/mysql/quests.sql 2013-02-27 18:42:39 UTC (rev 8616) +++ trunk/src/server/database/mysql/quests.sql 2013-02-27 19:06:58 UTC (rev 8617) @@ -19,9 +19,9 @@ -- Table structure for table `quests` -- -DROP TABLE IF EXISTS `quests`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; +DROP TABLE IF EXISTS `quests`; CREATE TABLE `quests` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(40) NOT NULL DEFAULT '', This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site. |
From: <ma...@us...> - 2013-04-07 21:01:16
|
Revision: 8682 http://planeshift.svn.sourceforge.net/planeshift/?rev=8682&view=rev Author: magodra Date: 2013-04-07 21:01:00 +0000 (Sun, 07 Apr 2013) Log Message: ----------- - Added test quest for familiar. Modified Paths: -------------- trunk/src/server/database/mysql/quest_scripts.sql trunk/src/server/database/mysql/quests.sql Modified: trunk/src/server/database/mysql/quest_scripts.sql =================================================================== --- trunk/src/server/database/mysql/quest_scripts.sql 2013-04-07 18:48:39 UTC (rev 8681) +++ trunk/src/server/database/mysql/quest_scripts.sql 2013-04-07 21:01:00 UTC (rev 8682) @@ -60,7 +60,8 @@ ('208',207,'# Quest Acquire Lapar\n# ID 1214\n# Quest Description: Smith needs some juiceberry fruit before he will sell you any lapar.\n# Player lockout: 43200\n# 12 hours \n# Quest Lockout: 1800\n# 30 minutes \n# Syntax update 5.11.2008\n# Updated with menu system 11/2008.\n\nP: Give me Lapar.\nMenu: I\'m looking for some Lapar.\n\nSmith: Very well $sir, I have some lapar you can have, but it will cost you. [Levrus chuckles.] Shall we say two hundred tria, and three juiceberry fruit? (/planeshift/data/voice/Levrusacquirelapar/1verywellsir.spx)\nP: No. P: Yes.\nMenu: No, that is too much! Are you kidding me old man? Menu: You hold your lapar dear old man, but I\'ll pay your price.\n\nSmith: That is my price $playerrace, come back if you change your mind. (/planeshift/data/voice/Levrusacquirelapar/2thatismyprice.spx)\nSmith: Excellent! Bring me the fruit, and I\'ll have some lapar ready for you. (/planeshift/data/voice/Levrusacquirelapar/3excellentbringmethefruit.spx)\nAssign Quest.\n\n... NoRepeat\n# Step 2\nPlayer Gives Smith 3 Juiceberry fruit.\nSmith: Very nice, now for the tria, all two hundred of them please. [Levrus holds out his hand with a smile.] (/planeshift/data/voice/Levrusacquirelapar/4verynicenowforthetria.spx)\nComplete Acquire Lapar Step 2.\n\n...\n# Step 3\nRequire Completion of Acquire Lapar Step 2.\nPlayer Gives Smith 200 tria.\nSmith: [The Smith takes the coins and stuffs them into his coin-pouch.] Very well, one bottle of Lapar for the $playerrace. [Smith hands you a bottle.] Use it wisely, it is not as abundant as water. [Smith chuckles as he turns his attention elsewhere.] (/planeshift/data/voice/Levrusacquirelapar/5verywellonebottle.spx)\nGive 1 Lapar. Give 600 Exp.\nComplete Acquire Lapar Step 3.'), ('209',208,'# Quest One Thousand Year Sammich \r\n\r\n# Quest Description: You are hungry. Feed yourself.\r\n\r\n# Quest Category: \r\n\r\n# Description Red Paperclip - an ordinary red paperclip. It might possibly be traded for amazing and unheard-of wonders.\r\n\r\n# Description Sandwich Plate - An ancient chipped plate divided into gaudily coloured sections.\r\n\r\n# Description Artisan Waybread - A fluffy warm loaf of freshly-baked bread.\r\n\r\n# Description Corned Beef - A packet of tender, juicy, wafer thin meat.\r\n\r\n# Description Smoked Provolone - A bundle of creamy white cheese slices that carry a faint smoky aroma.\r\n\r\n# Description Sublime Sandwich - The most perfect sandwich you have ever seen, bar none.\r\n\r\n# Description Condiment Recipe - An old parchment, badly creased and stained but still legible.\r\n\r\n# Description Silver Penny - A unit of currency.\r\n\r\n#--------------------------------------------------------------\r\n\r\n# Version 1.0\r\n\r\n# Author(s): Oomi, UTM\r\n\r\n#--------------------------------------------------------------\r\n\r\n# Parameters (Remarked out for now)\r\n\r\n# player lockout -1\r\n\r\n# quest lockout 500\r\n\r\n# Prerequisites: none\r\n\r\n#--------------------------------------------------------------\r\n\r\n# Notes: \r\n\r\n#-------------------------------------------------------------- \r\n \r\n\r\nP: Give me quest.\r\nMenu: I am hungry for something different. Got any food?\r\n\r\nGertie Hollaback: Yup. (/this/data/voice/sammich/1-yup.spx)\r\n\r\nP: rude question. P: Nice question.\r\nMenu: Can I have some? Menu: Well... what kind?\r\n\r\nG: No, ya ain\'t gunna get yer grubby mitts on my food. What kinda person comes up to a complete stranger an esks for a bite\'a her well earned grub? Now you git yerself off my premises a\'for I have ta blast you off. (/this/data/voice/sammich/2-grubbymitts.spx)\r\nG: [Gertie looks down at her bag, and rummages around a bit.] You like crawdads? (/this/data/voice/sammich/3-crawdads.spx)\r\n\r\nAssign Quest. \r\n\r\n... NoRepeat \r\n\r\n# Step 2\r\n\r\nP: No. P: Yes. P: Don\'t know.\r\nMenu: They are horrid little creatures. Menu: They are delicious. Menu: Do I like what?\r\n\r\nG: What? You just ain\'t got no taste. Get on outta here! (/this/data/voice/sammich/4-notaste.spx)\r\nComplete One Thousand Year Sammich Step 2. Complete One Thousand Year Sammich.\r\n\r\nG: [Gertie rummages around in her bag.] That\'s too bad. I ain\'t got none anyhow. (/this/data/voice/sammich/5-toobad.spx)\r\nComplete One Thousand Year Sammich Step 2.\r\n\r\nG: How am I suppose to know what you like? Don\' ask me no fool questions. (/this/data/voice/sammich/6-whatyoulike.spx)\r\nComplete One Thousand Year Sammich Step 2. \r\n \r\n\r\n... NoRepeat \r\n\r\n# Step 3\r\n\r\nRequire completion of One Thousand Year Sammich Step 2.\r\n\r\nP: give me food.\r\nMenu: So, where CAN a body get a snack around here?\r\n\r\nG: Well, I just had a right tasty sammich. Yup, I did. Thick an\' juicy, one-o\'-a-kind like ya done ne\'er had bee-for. [Gertie stares off into the distance and pulls a folded red wire out of her pocket.] (/this/data/voice/sammich/7-tastysammich.spx)\r\nComplete One Thousand Year Sammich Step 3. \r\n\r\n... NoRepeat \r\n\r\n# Step 4\r\n\r\nRequire completion of One Thousand Year Sammich Step 3.\r\n\r\nP: about sammich.\r\nMenu: Well, that sounds nice. Where do I learn more about this \"sammich\"?\r\n\r\nG: [Gertie unfolds the wire and uses it to pick her teeth with great gusto.] Hmmm. Dwarves is real fond o\' they food. Try askin\' one. Oh, here, have a toothpicker. I\'m done with it. [Gertie wipes off the red wire, folds it back up, and hands it to you.] (/this/data/voice/sammich/8-dwarvesfond.spx)\r\nGive 1 Red Paperclip.\r\nComplete One Thousand Year Sammich Step 4. \r\n\r\n... NoRepeat \r\n\r\n# Step 5.\r\n\r\nRequire completion of One Thousand Year Sammich Step 4.\r\n\r\nP: Gertie sent me.\r\nMenu: I\'m starving! Gertie told me you made the best sandwiches around.\r\n\r\nReginald Hartlepool: [Reginald arches an eyebrow.] So, the lowly come to me once again with the desire to sample the fabled festival of sumptuousness that is the pride and heritage of my ancestors? Of course you are. My family\'s wondrous delectables are legendary in these lands. This astounding recipe has been handed down through generations of Hartlepools, each keeping the secrets of those who came before. And so it has come to me, Reginald HH Hartlepool the Third. As you can see, I have used it wisely. [Reginald grins and pats his protruding belly. As he does so, the button on his pants makes a loud pop and goes flying into the air.] (/this/data/voice/sammich/1Sothelowly-1.spx|/this/data/voice/sammich/1Sothelowly-2.spx)\r\n\r\nComplete One Thousand Year Sammich Step 5. \r\n \r\n\r\n...\r\n\r\n...\r\n\r\n... NoRepeat \r\n\r\n# Step 6, 7, [8 for lock]. 6 and 7 will make small branches that will merge a little later. 6 will be the harder branch, though it seems to start off nicer.\r\n\r\nP: you fat. P: lost something.\r\nMenu: You like your own food a little too much, chubby. Menu: You seem to have lost something.\r\n\r\nRequire completion of One Thousand Year Sammich Step 5.\r\n\r\nReginald Hartlepool: [Reginald looks down and gasps, grabbing his pants before they fall down. He pats his pockets awkwardly with his free hand as if looking for something, but stops and looks at you in dismay.] Alas... you may be right on that count. It will not be the first time our great Sandwich of sandwiches has brought a Hartlepool to his knees in shame. Woe is upon my family once again as I stand before you, shed of my pride and nearly my pants for the love of the finest sandwich ever constructed. Anguish and pity is upon me as my worthy ancestors look upon this catastrophe that has befallen my unworthy garment fastener. Misery shall become my name, for I have not a single bit of string, nor a bent bit of metal to repair this onerous calamity.(/this/data/voice/sammich/2Reginaldlooksdown-1.spx|/this/data/voice/sammich/2Reginaldlooksdown-2.spx)\r\n\r\nComplete One Thousand Year Sammich Step 6. Complete One Thousand Year Sammich Step 8.\r\n\r\nRequire completion of One Thousand Year Sammich Step 5.\r\n\r\nReginald Hartlepool: [Reginald looks down and gasps, grabbing his pants before they fall down. He pats his pockets awkwardly with his free hand as if looking for something, but stops and looks at you forlornly.] Oh, good gracious! What an embarrassing predicament. It seems my lust for flavourful delicacies has overcome the fortitude of my slacks, and here I sit without the means to repair the travesty that has become of said garment. If you have something... anything to aid me in this most momentous time of need, I will reward you most graciously.(/this/data/voice/sammich/3ohgoodgracious.spx)\r\n\r\nComplete One Thousand Year Sammich Step 7. Complete One Thousand Year Sammich Step 8. \r\n\r\n... NoRepeat \r\n\r\n# Step 9 - branch from 6. \"You are fat\"\r\n\r\nRequire completion of One Thousand Year Sammich Step 6.\r\n\r\nP: Have paperclip.\r\nMenu: I do have a red paperclip, but it will cost you.\r\n\r\nReginald Hartlepool: I will pay any price you name. I will do anything you ask to save my fallen pride. [Reginald closes his eyes, seeming to brace for the worst.] (/this/data/voice/sammich/4Iwillpayanyprice.spx)\r\nComplete One Thousand Year Sammich Step 9. \r\n\r\n... NoRepeat \r\n\r\n# Step 10\r\n\r\nRequire completion of One Thousand Year Sammich Step 9.\r\n\r\nP: sammich.\r\nMenu: It will cost you... a sammich!\r\n\r\nReginald Hartlepool: [Reginald looks aghast for a moment and almost drops his pants before he seems to realise what you asked for.] Wait... just a sandwich? Very well. I do not have one, but on my honour as a Hartlepool, I will tell you where to procure one in exchange for the paperclip. (/this/data/voice/sammich/5Waitjustasandwich.spx)\r\nComplete One Thousand Year Sammich Step 10. \r\n\r\n... NoRepeat \r\n\r\n# Step 11\r\n\r\nRequire completion of One Thousand Year Sammich Step 10.\r\n\r\nPlayer gives Reginald Hartlepool 1 Red Paperclip.\r\nMenu: Give Reginald your Red Paperclip.\r\n\r\nReginald Hartlepool: [Reginald takes the red paperclip and affixes it to his wayward trousers. He grins as the thing holds.] Wondrous And even a little stylish. Why, red paperclip trouser afixers might just become the new style! Thank you oh so much. Ah, yes, your \'sammich\'. Gertie that you conversed with before coming to me should have more. I sold her quite a few of my best creations. I don\'t know why she didn\'t just give you one in the first place. Here, take a few coins, as I am sure she will not part with such wondrous and savoury feasts cheaply. (/this/data/voice/sammich/6wondrousandeven.spx)\r\nGive 10 Silver Penny.\r\nComplete One Thousand Year Sammich Step 11. \r\n\r\n... NoRepeat \r\n\r\n# Step 12 - talk to the Gertie again.\r\n\r\nRequire completion of One Thousand Year Sammich Step 11.\r\n\r\nP: About sammich.\r\nMenu: Reginald told me you have the sandwiches.\r\n\r\nGertie Hollaback: Ya, so? (/this/data/voice/sammich/9-yeahso.spx)\r\nComplete One Thousand Year Sammich Step 12. \r\n\r\n... NoRepeat \r\n\r\n# Step 13\r\n\r\nRequire completion of One Thousand Year Sammich Step 12.\r\n\r\nP: more about sammich.\r\nMenu: Why didn\'t you tell me you had one?\r\n\r\nG: You asked whar you could larn about one. Ya din\'it ask if I had one. If you asked that, I would\'a said, \'Sure I \'as got one, but it\'ll cost ya five, no, ten silver pennies.\' You got ten silver pennies on you? Hand em over and you got yourself a sammich. (/this/data/voice/sammich/10-youasked.spx)\r\nComplete One Thousand Year Sammich Step 13. \r\n\r\n... NoRepeat \r\n\r\n# Step 14 - End branch.\r\n\r\nRequire completion of One Thousand Year Sammich Step 13.\r\n\r\nPlayer gives Gertie Hollaback 10 Silver Penny.\r\nMenu: Give Gertie the 10 Silver Pennies.\r\n\r\nG: Lemme count these har coins first. One...two...tree...five... [Gertie glances up at you and closes her hand.] Ten. All here. Here is yar sammich. (/this/data/voice/sammich/11-lemmecount.spx)\r\nGive 1 Sublime Sandwich. Give 10000 Exp.\r\nComplete One Thousand Year Sammich Step 14. Complete One Thousand Year Sammich. \r\n\r\n... NoRepeat \r\n\r\n# Step 15 - branch from 7 \"lost something\"\r\n\r\nRequire completion of One Thousand Year Sammich Step 7.\r\n\r\nP: Have paperclip.\r\nMenu: I happen to have this odd little bit of metal; would it help?\r\n\r\nReginald Hartlepool: [Reginald claps his hands together in joy, then quickly grabs at his falling trousers again.] Oh please, if you would be so kind as to give me this wonderful object, I shall, I shall... [Reginald lowers his voice to a whisper.] I shall help you to learn the secret of the Sandwich! (/this/data/voice/sammich/7ohplease.spx)\r\nComplete One Thousand Year Sammich Step 15. \r\n\r\n... NoRepeat \r\n\r\n# Step 16\r\n\r\nRequire completion of One Thousand Year Sammich Step 15.\r\n\r\nPlayer gives Reginald Hartlepool 1 Red Paperclip.\r\nMenu: Give Reginald your Red Paperclip.\r\n\r\nReginald Hartlepool: Alas, I have no children to whom I may pass on the marvellous lore of the Sandwich. Since you have proven yourself a remarkably considerate and compassionate being, I have chosen to pass my knowledge on to you. However, you must learn the lore just as a child of my own getting would be required to do. I hereby present to you that which has been passed down in my family for generations unnumbered. I give you... the Sandwich Plate! [Reginald gingerly places an elderly serving plate in your hands. It is quite chipped and contains four sections, each in a different, and somewhat gaudy, colour.] When you have given this magnificent object the reverence due to it, tell me you are ready and I will impart its sublime knowledge to you. (/this/data/voice/sammich/8alasihavenochildren-1.spx|/this/data/voice/sammich/8alasihavenochildren-2.spx)\r\nGive 1 Sandwich Plate.\r\nComplete One Thousand Year Sammich Step 16. \r\n\r\n... \r\n\r\n# Step 17\r\n\r\nRequire completion of One Thousand Year Sammich Step 16.\r\n\r\nP: Ready.\r\nMenu: I am ready to learn all that you have to teach me. Please begin.\r\n\r\nReginald Hartlepool: [Reginald clears his throat.] Ahem! This was first done by my great great great grandsire, nearly five hundred years ago. Every part of the Sandwich has its proper place during assembly. The bread is placed in the fuchsia section in the centre. The meat must always reside in the cerulean section, just there. Cheese finds its proper place in the ochre section. [Reginald suddenly glares at you.] Remove your filthy thumb from the ochre section AT ONCE! (/this/data/voice/sammich/9ahem.spx)\r\n\r\nComplete One Thousand Year Sammich Step 17. \r\n\r\n... \r\n\r\n# Step 18\r\n\r\nRequire completion of One Thousand Year Sammich Step 17.\r\n\r\nP: removes thumb.\r\nMenu: $playername removes $his thumb quickly under Reginald\'s watchful eye.\r\n\r\nReginald Hartlepool: That\'s better. Now to continue, the last and most important section is the chartreuse section. This section contains the condiment. It is the condiment which binds the Sandwich together into a cohesive whole that is better than the sum of its respective parts. Your next task will be to collect the finest representatives of each of these four ingredients and return to me once you have them. Then and only then will the next mystery be revealed unto you.(/this/data/voice/sammich/10thatsbetter.spx)\r\n\r\nComplete One Thousand Year Sammich Step 18. \r\n\r\n... \r\n\r\n# Step 19\r\n\r\nRequire completion of One Thousand Year Sammich Step 18.\r\n\r\nP: next step.\r\nMenu: What must I do first, oh grand Sandwich Master?\r\n\r\nReginald Hartlepool: I am so glad you asked. Find Butch, the Baker, and get his finest bread. Artisan Waybread only, if you please. Then go to Loudon, the butcher, to procure some of his finest cuts of meat. Corned Beef, nothing else will do. Finally, you will travel to Cabot, purveyor of the finest cheeses. What will you get there? Why, only the finest Smoked Provolone! When you have all these things, you will return to me and I will give you the Final Secret! (/this/data/voice/sammich/11iamsogladyou.spx)\r\n\r\nComplete One Thousand Year Sammich Step 19. \r\n\r\n... \r\n \r\n\r\n# Step 20\r\n\r\nRequire completion of One Thousand Year Sammich Step 19.\r\n\r\nP: Got bread.\r\nMenu: Reginald sent me for some of your finest bread.\r\n\r\nButch: Ah yes, we have ze fineszt breadz in all ze landz! Come, come, look upon my cre-a-see-onz and name ze bread you need.\r\n\r\nComplete One Thousand Year Sammich Step 20. \r\n\r\n... NoRepeat \r\n\r\n# Step 21\r\n\r\nP: *. P: Artisan Waybread.\r\nMenu: Ummm... cinnamon rolls? Menu: ?=Name your bread\r\n\r\nRequire completion of One Thousand Year Sammich Step 20.\r\n\r\nButch: No no, Rezhinald deed not send you here to buy ZAT!\r\n\r\nRequire completion of One Thousand Year Sammich Step 20.\r\n\r\nButch: Ah Yez! Ze fineszt Arteesan Waybread, she is yours to take. Go quickly, now, so she does not go stale on you.\r\n\r\nGive 1 Artisan Waybread.\r\n\r\nComplete One Thousand Year Sammich Step 21. \r\n\r\n... \r\n\r\n# Step 22\r\n\r\nRequire completion of One Thousand Year Sammich Step 19.\r\n\r\nP: Got meat.\r\nMenu: Got any meat?\r\n\r\nLoudon: That I do! Only the finest meat. What cut would you be looking for today?\r\n\r\nComplete One Thousand Year Sammich Step 22. \r\n\r\n... NoRepeat \r\n\r\n# Step 23\r\n\r\nP: *. P: corned beef.\r\nMenu: Would pickled consumer be good on a sandwich? Menu: ?=Name your meat\r\n\r\nRequire completion of One Thousand Year Sammich Step 22.\r\n\r\nLoudon: What? No no no. that will not do at all.\r\n\r\nRequire completion of One Thousand Year Sammich Step 22.\r\n\r\nLoudon: Ah ha! You must be making one of Reginald\'s famed Sublime Sandwiches. Here are your cuts.\r\n\r\nGive 1 Corned Beef.\r\n\r\nComplete One Thousand Year Sammich Step 23. \r\n\r\n... \r\n\r\n# Step 24 - Last option, breaking the chain up to test the bother of reclicking the npc.\r\n\r\nRequire completion of One Thousand Year Sammich Step 19.\r\n\r\nP: Got cheese.\r\n\r\nMenu: Hello, Cabot. Would you have some fresh cheese for Reginald\'s sandwich?\r\n\r\nCabot: So, it is the famed $playername, come to sample my wares. Well then, I say, No cheese for you! That is, unless you can perfectly name the cheese you wish to have. No.... I want you to spell it.... backwards!\r\n\r\nComplete One Thousand Year Sammich Step 24. \r\n\r\n... NoRepeat \r\n\r\n# Step 25\r\n\r\nP: *. P: Clue. P: enolovorp dekoms.\r\nMenu: Backwards? Are you insane? Menu: Can I have a clue? Menu: ?=Name your cheese\r\n\r\nRequire completion of One Thousand Year Sammich Step 24.\r\n\r\nCabot: You obviously do not understand the importance of the cheese. Come back when you know what you are really searching for.\r\n\r\nRequire completion of One Thousand Year Sammich Step 24.\r\n\r\nCabot: Ha! Too hard for you, is it? Well, I can tell you that the last word is... Dekoms!\r\n\r\nRequire completion of One Thousand Year Sammich Step 24.\r\n\r\nCabot: The Smoked Provolone! Wonderful choice. Let me package that right up for you. [Newman wraps the cheese quickly and hands it to you.]\r\n\r\nGive 1 Smoked Provolone.\r\n\r\nComplete One Thousand Year Sammich Step 25. \r\n\r\n... \r\n\r\n# Step 26.\r\n\r\nRequire completion of One Thousand Year Sammich Step 21.\r\n\r\nRequire completion of One Thousand Year Sammich Step 23.\r\n\r\nRequire completion of One Thousand Year Sammich Step 25.\r\n\r\nP: Have things.\r\nMenu: I have procured all the ingredients.\r\n\r\nReginald Hartlepool: Very good! You are now ready for the final lesson. Give me the ingredients and the Sandwich plate, if you please. (/this/data/voice/sammich/12verygood.spx)\r\n\r\nComplete One Thousand Year Sammich Step 26. \r\n\r\n... NoRepeat \r\n\r\n#Step 27\r\n\r\nRequire completion of One Thousand Year Sammich Step 26.\r\n\r\nPlayer gives Reginald Hartlepool 1 Sandwich Plate, 1 Artisan Waybread, 1 Corned Beef, 1 Smoked Provolone.\r\nMenu: Give Reginald the 3 ingredients you have gathered and the plate.\r\n\r\nReginald Hartlepool: Observe carefully as I put the ingredients in their proper sections on the Sandwich Plate. Now tell me, my good apprentice, which section is empty? (/this/data/voice/sammich/13observecarefully.spx)\r\n\r\nComplete One Thousand Year Sammich Step 27. \r\n\r\n... NoRepeat \r\n\r\n# Step 28\r\n\r\nP: *. P: chartreuse section. chartreuse.\r\nMenu: The one without anything in it? Menu: The chartreuse section appears to be empty.\r\n\r\nRequire completion of One Thousand Year Sammich Step 26.\r\n\r\nReginald Hartlepool: I have no patience for such sarcastic drivel. (/this/data/voice/sammich/14ihavenopatience.spx)\r\n\r\nRequire completion of One Thousand Year Sammich Step 26.\r\n\r\nReginald Hartlepool: Absolutely correct! You have learned well. The Sandwich is nothing without its condiment. Now, pay attention whilst I deliver the tasty denouement to its proper location. [Reginald pulls a small glass jar from his pocket, gingerly removes the cork from it, then dribbles a few drops of dark golden liquid onto the proper section.] The Sandwich is now ready for assembly. Put the condiment on both sides of the bread, then lightly drape the meat across both halves of the bread. Next, delicately place the cheese in a similar fashion. At last, we may unite the two halves and admire the completed Sandwich. [Reginald holds the sandwich aloft for a moment and stares at it with moist eyes.] Words cannot adequately express my pride in your achievements but perhaps these gifts will. They hold your future, young one. (/this/data/voice/sammich/15absolutelycorrect-1.spx|/this/data/voice/sammich/15absolutelycorrect-2.spx)\r\n\r\nGive 1 Sandwich Plate. Give 1 Condiment Recipe.\r\n\r\nComplete One Thousand Year Sammich Step 28. \r\n\r\n... \r\n\r\n# Step 29 Reginald goes Scottish\r\n\r\nRequire completion of One Thousand Year Sammich Step 28.\r\n\r\nP: hungry.\r\nMenu: But I\'m STILL hungry!\r\n\r\nReginald Hartlepool: [Reginald turns beet red and starts sputtering.] Ye ingrate! Ye... ye... pasty-faced git! I gi\' ye all I knoo and ye ken do nowt but whinge! Och, tae it then and away wi\' ye! [Reginald throws the sammich in the general direction of your head.] (/this/data/voice/sammich/16yeingrate.spx)\r\n\r\nGive 1 Sublime Sandwich. Give 40000 Exp.\r\n\r\nComplete One Thousand Year Sammich Step 29.\r\n'), ('210',209,'P:can I help\r\nMenu: I\'ll solve a riddle for a tria.\r\n\r\nMerchant: Ok that is fun. I like riddles. What is my favorite color?\r\n\r\nAssign Quest\r\n\r\n...\r\n\r\nP: *. P: blue\r\nMenu: That isn\'t a riddle, little man. Menu: ?=Favorite color\r\n\r\nM: I don\'t care what you think of my riddle! What is my favorite color?\r\nM: Yes, blue is my favorite color. Isn\'t it a wonderful color? Here is your reward.\r\nGive 1 tria.\r\n'), - ('211',210,'P:can tell fortune\r\nMenu: I\'ve heard you can read the future.\r\n\r\nSmith: Pay me 5 tria and I\'ll tell you about your love life.\r\n\r\nPlayer gives Smith 5 tria.\r\nMenu: Give him 5 tria for your fortune.\r\n\r\nSmith: Huzzah! Payment for services has been received... Now let me read your future...\r\n\r\nAssign Quest\r\n\r\n...\r\n\r\nP: tell fortune\r\nMenu: So??? What\'s going to happen in my love life?\r\n\r\nSmith: You are coding a game for goodness sakes! One doesn\'t have to be a psychic to know your love life is going to suffer. Now go away!\r\n'); + ('211',210,'P:can tell fortune\r\nMenu: I\'ve heard you can read the future.\r\n\r\nSmith: Pay me 5 tria and I\'ll tell you about your love life.\r\n\r\nPlayer gives Smith 5 tria.\r\nMenu: Give him 5 tria for your fortune.\r\n\r\nSmith: Huzzah! Payment for services has been received... Now let me read your future...\r\n\r\nAssign Quest\r\n\r\n...\r\n\r\nP: tell fortune\r\nMenu: So??? What\'s going to happen in my love life?\r\n\r\nSmith: You are coding a game for goodness sakes! One doesn\'t have to be a psychic to know your love life is going to suffer. Now go away!\r\n'), + ('212',211,'P:give me familiar\r\nMenu:Could you give me a familiar?\r\n\r\nMerchant: Yes\r\nGive 1 Ring of Familiar.\r\nRun Script create_familiar.\r\n'); /*!40000 ALTER TABLE `quest_scripts` ENABLE KEYS*/; UNLOCK TABLES; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS*/; Modified: trunk/src/server/database/mysql/quests.sql =================================================================== --- trunk/src/server/database/mysql/quests.sql 2013-04-07 18:48:39 UTC (rev 8681) +++ trunk/src/server/database/mysql/quests.sql 2013-04-07 21:01:00 UTC (rev 8682) @@ -69,6 +69,7 @@ INSERT INTO `quests` VALUES (208,'One Thousand Year Sammich','Long complex demo quest','',0,0,0,0,0,'Test4',''); INSERT INTO `quests` VALUES (209,'Puzzle Quest','Answer the merchant\'s question with BLUE to complete this quest.','',0,0,0,0,0,'Newbie',''); INSERT INTO `quests` VALUES (210,'Fortune Quest','Give the merchant 5 tria and he will tell your fortune.','',0,0,0,0,0,'Newbie',''); +INSERT INTO `quests` VALUES (211,'Familiar Quest','Ask for a familiar and he will give you.','',0,0,0,0,0,'Newbie',''); /*!40000 ALTER TABLE `quests` ENABLE KEYS */; UNLOCK TABLES; /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site. |
From: <lpa...@us...> - 2013-09-21 21:27:58
|
Revision: 8808 http://sourceforge.net/p/planeshift/code/8808 Author: lpancallo Date: 2013-09-21 21:27:56 +0000 (Sat, 21 Sep 2013) Log Message: ----------- Added sample guild to test data. Modified Paths: -------------- trunk/src/server/database/mysql/characters.sql trunk/src/server/database/mysql/guildlevels.sql trunk/src/server/database/mysql/guilds.sql Modified: trunk/src/server/database/mysql/characters.sql =================================================================== --- trunk/src/server/database/mysql/characters.sql 2013-09-18 11:01:37 UTC (rev 8807) +++ trunk/src/server/database/mysql/characters.sql 2013-09-21 21:27:56 UTC (rev 8808) @@ -90,8 +90,11 @@ # INSERT INTO `characters` VALUES (1,'Guest','Char','',0,0,144.00,40.00,44.00,40.00,40.00,40.00,0.00,100.00,0.00,100.00,216.00,200.00,34,40,10,134,100,100,100,100,0,3,-43.86,-0.01,-152.30,1.50,0,0,0,0,0,NULL,NULL,0,'2006-11-20 19:43:10','',0,0,'N',3,2604,0,180,18,'Was born in a jar','','','',10,'',0,'2001-10-10 00:00:00',0,0); -INSERT INTO `characters` VALUES (2,'Vengeance','IsMine','',0,0,300.00,60.00,60.00,60.00,60.00,60.00,0.00,280.00,0.00,120.00,200.00,200.00,34,40,10,134,0,0,0,0,0,3,-32.03,0.00,-154.36,0.49,0,0,0,0,0,NULL,NULL,0,'2007-03-27 05:52:44','',0,0,'N',1,14985,0,150,10,'Grew up on a ice mountain','','','',10,'<category attribute=\"Lifecycle\" name=\"Daylight\" value=\"10\" /><category attribute=\"Type\" name=\"Animal\" value=\"5\" />',3,'2006-11-29 21:55:15',0,0); -INSERT INTO `characters` VALUES (3,'Acraig','Newfie','',2,0,144.00,40.00,44.00,40.00,40.00,40.00,0.00,100.00,0.00,100.00,216.00,200.00,34,40,10,134,100,100,100,100,0,3,-61.32,-0.01,-187.16,0.00,0,0,0,0,0,NULL,NULL,0,'2006-11-29 21:55:15','',0,0,'N',5,3798,0,150,1000,'description','','','',1000,'',0,'2001-10-10 00:00:00',0,0); +INSERT INTO `characters` VALUES (2,'Vengeance','IsMine','',0,0,300.00,60.00,60.00,60.00,60.00,60.00,0.00,280.00,0.00,120.00,200.00,200.00,34,40,10,134,0,0,0,0,0,3,-32.03,0.00,-154.36,0.49,444,9,0,0,0,NULL,NULL,0,'2007-03-27 05:52:44','',0,0,'N',1,14985,0,150,10,'Grew up on a ice mountain','','','',10,'<category attribute=\"Lifecycle\" name=\"Daylight\" value=\"10\" /><category attribute=\"Type\" name=\"Animal\" value=\"5\" />',3,'2006-11-29 21:55:15',0,0); +INSERT INTO `characters` VALUES (3,'Acraig','Newfie','',2,0,144.00,40.00,44.00,40.00,40.00,40.00,0.00,100.00,0.00,100.00,216.00,200.00,34,40,10,134,100,100,100,100,0,3,-61.32,-0.01,-187.16,0.00,444,5,0,0,0,NULL,NULL,0,'2006-11-29 21:55:15','',0,0,'N',5,3798,0,150,1000,'description','','','',1000,'',0,'2001-10-10 00:00:00',0,0); +INSERT INTO `characters` VALUES (16,'Guildie','One','',2,0,144.00,40.00,44.00,40.00,40.00,40.00,0.00,100.00,0.00,100.00,216.00,200.00,34,40,10,134,100,100,100,100,0,3,-61.32,-0.01,-187.16,0.00,444,4,0,0,0,NULL,NULL,0,'2006-11-29 21:55:15','',0,0,'N',5,3798,0,150,1000,'I love my guild','','','',1000,'',0,'2001-10-10 00:00:00',0,0); +INSERT INTO `characters` VALUES (17,'Guilder','Two','',2,0,144.00,40.00,44.00,40.00,40.00,40.00,0.00,100.00,0.00,100.00,216.00,200.00,34,40,10,134,100,100,100,100,0,3,-61.32,-0.01,-187.16,0.00,444,3,0,0,0,NULL,NULL,0,'2006-11-29 21:55:15','',0,0,'N',5,3798,0,150,1000,'My guild is the best','','','',1000,'',0,'2001-10-10 00:00:00',0,0); +INSERT INTO `characters` VALUES (18,'Guildor','Three','',2,0,144.00,40.00,44.00,40.00,40.00,40.00,0.00,100.00,0.00,100.00,216.00,200.00,34,40,10,134,100,100,100,100,0,3,-61.32,-0.01,-187.16,0.00,444,2,0,0,0,NULL,NULL,0,'2006-11-29 21:55:15','',0,0,'N',5,3798,0,150,1000,'I\'m proud to be in this guild','','','',1000,'',0,'2001-10-10 00:00:00',0,0); INSERT INTO `characters` VALUES (4,'MaleEnki','','',1,1,44.00,40.00,44.00,40.00,40.00,40.00,50.00,100.00,100.00,100.00,100.00,100.00,100,100,100,100,100,100,100,100,0,3,-1.00,0.00,-179.00,0.00,0,0,0,0,0,'','',0,NULL,'',1,4,'N',9,0,0,0,0,'description','','','',10,'',0,'0000-00-00 00:00:00',0,0); INSERT INTO `characters` VALUES (5,'Smith','','',7,1,44.00,40.00,44.00,40.00,40.00,40.00,50.00,100.00,100.00,100.00,100.00,100.00,100,100,100,100,100,100,100,100,0,3,-53.54,0.00,-155.11,0.00,0,0,0,0,0,'','',0,NULL,'',1,5,'N',9,0,0,0,0,'description','','','',10,'',0,'0000-00-00 00:00:00',0,0); Modified: trunk/src/server/database/mysql/guildlevels.sql =================================================================== --- trunk/src/server/database/mysql/guildlevels.sql 2013-09-18 11:01:37 UTC (rev 8807) +++ trunk/src/server/database/mysql/guildlevels.sql 2013-09-21 21:27:56 UTC (rev 8808) @@ -21,15 +21,15 @@ # Dumping data for table 'guildlevels' # -INSERT INTO guildlevels VALUES("1","9","Maximus",65535); -INSERT INTO guildlevels VALUES("1","8","Mogul",3); -INSERT INTO guildlevels VALUES("1","7","Grand Master",3); -INSERT INTO guildlevels VALUES("1","6","High Master",3); -INSERT INTO guildlevels VALUES("1","5","Master",3); -INSERT INTO guildlevels VALUES("1","4","Peon",3); -INSERT INTO guildlevels VALUES("1","3","Adept",3); -INSERT INTO guildlevels VALUES("1","2","Novice",3); -INSERT INTO guildlevels VALUES("1","1","Apprentice",3); +INSERT INTO guildlevels VALUES("444","9","Maximus",65535); +INSERT INTO guildlevels VALUES("444","8","Mogul",3); +INSERT INTO guildlevels VALUES("444","7","Grand Master",3); +INSERT INTO guildlevels VALUES("444","6","High Master",3); +INSERT INTO guildlevels VALUES("444","5","Master",3); +INSERT INTO guildlevels VALUES("444","4","Peon",3); +INSERT INTO guildlevels VALUES("444","3","Adept",3); +INSERT INTO guildlevels VALUES("444","2","Novice",3); +INSERT INTO guildlevels VALUES("444","1","Apprentice",3); INSERT INTO guildlevels VALUES("11","9","Maximus",65535); INSERT INTO guildlevels VALUES("11","8","Mogul",3); INSERT INTO guildlevels VALUES("11","7","Grand Master",3); Modified: trunk/src/server/database/mysql/guilds.sql =================================================================== --- trunk/src/server/database/mysql/guilds.sql 2013-09-18 11:01:37 UTC (rev 8807) +++ trunk/src/server/database/mysql/guilds.sql 2013-09-21 21:27:56 UTC (rev 8808) @@ -34,8 +34,4 @@ # Dumping data for table 'guilds' # -# 2010-Apr-05 They do not meet the start criteria so they will be delted. This cause the server to crash. -# For now disable them -# -#INSERT INTO guilds VALUES("1","Insomniac Developers","2","www.yahoo.com","2002-05-08 00:07:37","0","N",100,"Guild MOTD", 1, 1, 1, 1, 1); -#INSERT INTO guilds VALUES("11","Karmic Fanboys","1","www.linux.org","2003-07-25 00:07:37","0","N",100,"", 1, 0, 0, 0, 0); +INSERT INTO guilds VALUES("444","Insomniac Developers","2","www.planeshift.it","2002-05-08 00:07:37","0","N",100,"Guild MOTD", 1, 1, 1, 1, 1); This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site. |
From: <ma...@us...> - 2013-11-24 12:32:58
|
Revision: 9028 http://sourceforge.net/p/planeshift/code/9028 Author: magodra Date: 2013-11-24 12:32:55 +0000 (Sun, 24 Nov 2013) Log Message: ----------- - Added test data for scaled NPCs. Modified Paths: -------------- trunk/src/server/database/mysql/character_variables.sql trunk/src/server/database/mysql/characters.sql trunk/src/server/database/mysql/sc_npc_definitions.sql trunk/src/server/database/mysql/sc_npctypes.sql Modified: trunk/src/server/database/mysql/character_variables.sql =================================================================== --- trunk/src/server/database/mysql/character_variables.sql 2013-11-24 12:24:07 UTC (rev 9027) +++ trunk/src/server/database/mysql/character_variables.sql 2013-11-24 12:32:55 UTC (rev 9028) @@ -7,3 +7,7 @@ KEY `character_id` (`character_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Used to store variables for a character'; + +INSERT INTO character_variables VALUES("104","scale","0.5"); # Small mover +INSERT INTO character_variables VALUES("105","scale","1.5"); # Large mover +INSERT INTO character_variables VALUES("106","scale","2.0"); # Huge mover Modified: trunk/src/server/database/mysql/characters.sql =================================================================== --- trunk/src/server/database/mysql/characters.sql 2013-11-24 12:24:07 UTC (rev 9027) +++ trunk/src/server/database/mysql/characters.sql 2013-11-24 12:32:55 UTC (rev 9028) @@ -171,6 +171,9 @@ INSERT INTO `characters` VALUES (101,'NPC Fighter 2','','',3,1,100.00,100.00,100.00,100.00,100.00,100.00,200.00,200.00,100.00,100.00,100.00,100.00,100,100,100,100,100,100,100,100,0,3,25.00,0.00,-175.00,0.00,0,0,0,0,0,'','',0,NULL,'',1,6,'N',9,0,2,0,0,'Attacking nearest NPC','','','',10,'',0,'0000-00-00 00:00:00',0,0); INSERT INTO `characters` VALUES (102,'NPC Fighter 3','','',3,1,100.00,100.00,100.00,100.00,100.00,100.00,200.00,200.00,100.00,100.00,100.00,100.00,100,100,100,100,100,100,100,100,0,3,25.00,0.00,-170.00,0.00,0,0,0,0,0,'','',0,NULL,'',1,6,'N',9,0,2,0,0,'Attacking nearest NPC','','','',10,'',0,'0000-00-00 00:00:00',0,0); INSERT INTO `characters` VALUES (103,'NPC Fighter 4','','',3,1,100.00,100.00,100.00,100.00,100.00,100.00,200.00,200.00,100.00,100.00,100.00,100.00,100,100,100,100,100,100,100,100,0,3,20.00,0.00,-175.00,0.00,0,0,0,0,0,'','',0,NULL,'',1,6,'N',9,0,2,0,0,'Attacking nearest NPC','','','',10,'',0,'0000-00-00 00:00:00',0,0); +INSERT INTO `characters` VALUES (104,'Small Mover','','',7,1,44.00,40.00,44.00,40.00,40.00,40.00,50.00,100.00,100.00,100.00,100.00,100.00,100,100,100,100,100,100,100,100,0,3,-20.00,0.00,-160.00,0.00,0,0,0,0,0,'','',0,NULL,'',1,104,'N',9,0,0,0,0,'Used to test movement.','','','',500,'',0,'0000-00-00 00:00:00',0,0); +INSERT INTO `characters` VALUES (105,'Large Mover','','',7,1,44.00,40.00,44.00,40.00,40.00,40.00,50.00,100.00,100.00,100.00,100.00,100.00,100,100,100,100,100,100,100,100,0,3,-20.00,0.00,-170.00,0.00,0,0,0,0,0,'','',0,NULL,'',1,105,'N',9,0,0,0,0,'Used to test movement.','','','',500,'',0,'0000-00-00 00:00:00',0,0); +INSERT INTO `characters` VALUES (106,'Huge Mover','','',7,1,44.00,40.00,44.00,40.00,40.00,40.00,50.00,100.00,100.00,100.00,100.00,100.00,100,100,100,100,100,100,100,100,0,3,-20.00,0.00,-180.00,0.00,0,0,0,0,0,'','',0,NULL,'',1,106,'N',9,0,0,0,0,'Used to test movement.','','','',500,'',0,'0000-00-00 00:00:00',0,0); /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; Modified: trunk/src/server/database/mysql/sc_npc_definitions.sql =================================================================== --- trunk/src/server/database/mysql/sc_npc_definitions.sql 2013-11-24 12:24:07 UTC (rev 9027) +++ trunk/src/server/database/mysql/sc_npc_definitions.sql 2013-11-24 12:32:55 UTC (rev 9028) @@ -71,3 +71,6 @@ INSERT INTO sc_npc_definitions VALUES("101","NPC Fighter 2","FightNearestNPC","npc_battlefield","0.00","0.00","0","N","N"); INSERT INTO sc_npc_definitions VALUES("102","NPC Fighter 3","FightNearestNPC","npc_battlefield","0.00","0.00","0","N","N"); INSERT INTO sc_npc_definitions VALUES("103","NPC Fighter 4","FightNearestNPC","npc_battlefield","0.00","0.00","0","N","N"); +INSERT INTO sc_npc_definitions VALUES("104","Small Mover","SizeMove","","0.00","0.00","0","N","N"); +INSERT INTO sc_npc_definitions VALUES("105","Large Mover","SizeMove","","0.00","0.00","0","N","N"); +INSERT INTO sc_npc_definitions VALUES("106","Huge Mover","SizeMove","","0.00","0.00","0","N","N"); Modified: trunk/src/server/database/mysql/sc_npctypes.sql =================================================================== --- trunk/src/server/database/mysql/sc_npctypes.sql 2013-11-24 12:24:07 UTC (rev 9027) +++ trunk/src/server/database/mysql/sc_npctypes.sql 2013-11-24 12:32:55 UTC (rev 9028) @@ -1388,3 +1388,6 @@ <react event="death" behavior="FightNearestNPC" absolute="0" /> <react event="death" behavior="Loot" range="5" />'); + +INSERT INTO sc_npctypes VALUES("143","SizeMove","MoveTest2",0,"$run","","","","","0", +'<empty/>'); This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site. |
From: <lpa...@us...> - 2013-12-24 18:21:24
|
Revision: 9106 http://sourceforge.net/p/planeshift/code/9106 Author: lpancallo Date: 2013-12-24 18:21:21 +0000 (Tue, 24 Dec 2013) Log Message: ----------- Added new test game board with pieces already placed Modified Paths: -------------- trunk/src/server/database/mysql/action_locations.sql trunk/src/server/database/mysql/gameboards.sql Modified: trunk/src/server/database/mysql/action_locations.sql =================================================================== --- trunk/src/server/database/mysql/action_locations.sql 2013-12-24 18:19:24 UTC (rev 9105) +++ trunk/src/server/database/mysql/action_locations.sql 2013-12-24 18:21:21 UTC (rev 9106) @@ -36,3 +36,4 @@ INSERT INTO `action_locations` VALUES (12,0,'Rainmaker game','NPCroom','npc1_Box08',0,-9.00,0.79,-217.21,4294967295,4,'SELECT','EXAMINE','<Examine><GameBoard Name=\'Weather game\' EndGame=\'Yes\' Script=\'rain\' /><Description>Magic puzzle that makes it rain. Make a simple r shape with the game pieces.</Description></Examine>','Y'); INSERT INTO `action_locations` VALUES (13,0,'One Two Three','NPCroom','npc1_Box07',0,-16.17,0.70,-217.06,4294967295,4,'SELECT','EXAMINE','<Examine><GameBoard Name=\'One Two Three\' EndGame=\'Yes\' Script=\'mechanism\' Param0=\'npc1_Box08\' Param1=\'0,5,0\' Param2=\'\' /><Description>Tests specific pieces rule. Put tile 1 in 0,0, tile 2 in 1,0 and tile 3 in 2,0 . When solved the next wooden box should move.</Description></Examine>','Y'); INSERT INTO `action_locations` VALUES (14, 0, 'simpleAL', 'NPCroom', 'npc1_trunk00', '0', '0', '0', '0', '4294967295', '0', 'SELECT', 'EXAMINE', 'A nice looking tree', 'Y'); +INSERT INTO `action_locations` VALUES (15,0,'Already Placed Pieces','NPCroom','npc1_Box20',0,2.73,0.01,-241.63,4294967295,4,'SELECT','EXAMINE','<Examine><GameBoard Name=\'Already Placed Pieces\' EndGame=\'Yes\' Script=\'minigame_win\' /><Description>Moved to pieces to specific locations.</Description></Examine>','Y'); Modified: trunk/src/server/database/mysql/gameboards.sql =================================================================== --- trunk/src/server/database/mysql/gameboards.sql 2013-12-24 18:19:24 UTC (rev 9105) +++ trunk/src/server/database/mysql/gameboards.sql 2013-12-24 18:21:21 UTC (rev 9106) @@ -47,4 +47,6 @@ INSERT INTO `gameboards` VALUES ('Tic Tac Toe', 3, 3, '000000000', '12', 2, 'White,Plain', '<GameRules><Rules PlayerTurns=\"StrictOrdered\" MoveType=\"PlaceOnly\" MoveTo=\"Vacancy\" /></GameRules>', '<MGEndGame><EndGame Coords=\"relative\" SourceTile=\"A\"><Coord Col=\"1\" Row=\"0\" Tile=\"F\" /><Coord Col=\"2\" Row=\"0\" Tile=\"F\" /></EndGame><EndGame Coords=\"relative\" SourceTile=\"A\"><Coord Col=\"0\" Row=\"1\" Tile=\"F\" /><Coord Col=\"0\" Row=\"2\" Tile=\"F\" /></EndGame><EndGame Coords=\"relative\" SourceTile=\"A\"><Coord Col=\"1\" Row=\"1\" Tile=\"F\" /><Coord Col=\"2\" Row=\"2\" Tile=\"F\" /></EndGame><EndGame Coords=\"relative\" SourceTile=\"A\"><Coord Col=\"-1\" Row=\"1\" Tile=\"F\" /><Coord Col=\"-2\" Row=\"2\" Tile=\"F\" /></EndGame></MGEndGame>'); INSERT INTO `gameboards` VALUES ('Weather game', 6, 6, '000000000000000000000000000000000000', '1', 1, 'Black,Plain', '<GameRules><Rules MoveDirection=\"Cross\" MoveDistance=\"2\" MoveTo=\"Vacancy\" /></GameRules>', '<MGEndGame><EndGame Coords=\"absolute\"><Coord Col=\"0\" Row=\"0\" Tile=\"A\" /><Coord Col=\"1\" Row=\"0\" Tile=\"A\" /><Coord Col=\"2\" Row=\"0\" Tile=\"A\" /><Coord Col=\"0\" Row=\"1\" Tile=\"A\" /><Coord Col=\"0\" Row=\"2\" Tile=\"A\" /></EndGame></MGEndGame>'); INSERT INTO `gameboards` VALUES ('One Two Three', 3, 3, '000000000', '123', 1, 'Black,Plain', '', '<MGEndGame><EndGame Coords=\"absolute\"><Coord Col=\"0\" Row=\"0\" Tile=\"S\" Piece=\"1\" /><Coord Col=\"1\" Row=\"0\" Tile=\"S\" Piece=\"2\" /><Coord Col=\"2\" Row=\"0\" Tile=\"S\" Piece=\"3\" /></EndGame></MGEndGame>'); +INSERT INTO `gameboards` VALUES ('Already Placed Pieces', 5, 5, 'FF0FF6FFFEFFBFF7FFF3FF0FF', '123456789ABCDE', 1, 'Black,Plain', '<GameRules><Rules MoveType=\"MoveOnly\" MoveTo=\"Vacancy\" /></GameRules>', '<MGEndGame><EndGame Coords=\"absolute\"><Coord Col=\"2\" Row=\"0\" Tile=\"S\" Piece=\"B\" /><Coord Col=\"2\" Row=\"4\" Tile=\"S\" Piece=\"3\" /><Coord Col=\"0\" Row=\"1\" Tile=\"S\" Piece=\"6\" /><Coord Col=\"0\" Row=\"3\" Tile=\"S\" Piece=\"7\" /><Coord Col=\"4\" Row=\"1\" Tile=\"S\" Piece=\"E\" /></EndGame></MGEndGame>'); + This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site. |
From: <lpa...@us...> - 2014-03-26 15:51:46
|
Revision: 9355 http://sourceforge.net/p/planeshift/code/9355 Author: lpancallo Date: 2014-03-26 15:51:43 +0000 (Wed, 26 Mar 2014) Log Message: ----------- sample monster for scale issue. consumer, fighter12. Modified Paths: -------------- trunk/src/server/database/mysql/characters.sql trunk/src/server/database/mysql/race_info.sql Modified: trunk/src/server/database/mysql/characters.sql =================================================================== --- trunk/src/server/database/mysql/characters.sql 2014-03-25 00:15:25 UTC (rev 9354) +++ trunk/src/server/database/mysql/characters.sql 2014-03-26 15:51:43 UTC (rev 9355) @@ -167,7 +167,7 @@ INSERT INTO `characters` VALUES (88,'Fighter9','','',3,1,100.00,100.00,100.00,100.00,100.00,100.00,200.00,200.00,100.00,100.00,100.00,100.00,100,100,100,100,100,100,100,100,0,6,-110.00,0.00,-55.00,0.00,0,0,0,0,0,'','',0,NULL,0.0,'',1,6,'N',9,0,2,0,0,'Fighting with region','','','',10,'',0,'0000-00-00 00:00:00',0,0); INSERT INTO `characters` VALUES (89,'Fighter10','','',3,1,100.00,100.00,100.00,100.00,100.00,100.00,200.00,200.00,100.00,100.00,100.00,100.00,100,100,100,100,100,100,100,100,0,6,-105.00,0.00,-55.00,0.00,0,0,0,0,0,'','',0,NULL,0.0,'',1,6,'N',9,0,2,0,0,'Fighting with region','','','',10,'',0,'0000-00-00 00:00:00',0,0); INSERT INTO `characters` VALUES (90,'Fighter11','','',3,1,100.00,100.00,100.00,100.00,100.00,100.00,200.00,200.00,100.00,100.00,100.00,100.00,100,100,100,100,100,100,100,100,0,6,-100.00,0.00,-55.00,0.00,0,0,0,0,0,'','',0,NULL,0.0,'',1,6,'N',9,0,2,0,0,'Fighting with region','','','',10,'',0,'0000-00-00 00:00:00',0,0); -INSERT INTO `characters` VALUES (91,'Fighter12','','',3,1,100.00,100.00,100.00,100.00,100.00,100.00,200.00,200.00,100.00,100.00,100.00,100.00,100,100,100,100,100,100,100,100,0,6,-95.00,0.00,-55.00,0.00,0,0,0,0,0,'','',0,NULL,0.0,'',1,87,'N',9,0,2,0,0,'Fighting with region','','','',10,'',0,'0000-00-00 00:00:00',0,0); +INSERT INTO `characters` VALUES (91,'Fighter12','','',28,1,100.00,50.00,200.00,100.00,100.00,100.00,200.00,200.00,100.00,100.00,100.00,100.00,100,100,100,100,100,100,100,100,0,6,-95.00,0.00,-55.00,0.00,0,0,0,0,0,'','',0,NULL,0.0,'',1,87,'N',9,0,2,0,0,'Fighting with region','','','',10,'',0,'0000-00-00 00:00:00',0,0); INSERT INTO `characters` VALUES (92,'SpellMaster2','','',3,1,100.00,100.00,100.00,100.00,100.00,100.00,200.00,200.00,100.00,100.00,100.00,100.00,100,100,100,100,100,100,100,100,0,3,-25.00,0.00,-145.00,0.00,0,0,0,0,0,'','',0,NULL,0.0,'',1,0,'N',9,0,2,0,0,'Used to test NPC spell operations.','','','',10,'',0,'0000-00-00 00:00:00',0,0); INSERT INTO `characters` VALUES (100,'NPC Fighter 1','','',3,1,100.00,100.00,100.00,100.00,100.00,100.00,200.00,200.00,100.00,100.00,100.00,100.00,100,100,100,100,100,100,100,100,0,3,20.00,0.00,-170.00,0.00,0,0,0,0,0,'','',0,NULL,0.0,'',1,6,'N',9,0,2,0,0,'Attacking nearest NPC','','','',10,'',0,'0000-00-00 00:00:00',0,0); INSERT INTO `characters` VALUES (101,'NPC Fighter 2','','',3,1,100.00,100.00,100.00,100.00,100.00,100.00,200.00,200.00,100.00,100.00,100.00,100.00,100,100,100,100,100,100,100,100,0,3,25.00,0.00,-175.00,0.00,0,0,0,0,0,'','',0,NULL,0.0,'',1,6,'N',9,0,2,0,0,'Attacking nearest NPC','','','',10,'',0,'0000-00-00 00:00:00',0,0); Modified: trunk/src/server/database/mysql/race_info.sql =================================================================== --- trunk/src/server/database/mysql/race_info.sql 2014-03-25 00:15:25 UTC (rev 9354) +++ trunk/src/server/database/mysql/race_info.sql 2014-03-26 15:51:43 UTC (rev 9355) @@ -85,7 +85,7 @@ INSERT INTO `race_info` VALUES (25,'Rat','stonebm','M',0.8,1.4,0.6,'',100,50,50,50,50,50,50,1.5,1,10,10,0,0,'','','','','',14,0.92,1); INSERT INTO `race_info` VALUES (26,'Grendol','stonebm','M',0.8,1.4,0.6,'',100,50,50,50,50,50,50,1.5,1,10,10,0,0,'','','','','',15,0.92,1); INSERT INTO `race_info` VALUES (27,'Gobble','stonebm','M',0.8,1.4,0.6,'',100,50,50,50,50,50,50,1.5,1,10,10,0,0,'','','','','',16,0.92,1); -INSERT INTO `race_info` VALUES (28,'Consumer','stonebm','M',0.8,1.4,0.6,'',100,50,50,50,50,50,50,1.5,1,10,10,0,0,'','','','','',17,0.92,1); +INSERT INTO `race_info` VALUES (28,'Consumer','consumer','N',0.8,1.4,0.6,'',100,50,50,50,50,50,50,1.5,1,10,10,0,0,'','','','','',17,0.1,1); INSERT INTO `race_info` VALUES (29,'Trepor','stonebm','M',0.8,1.4,0.6,'',100,50,50,50,50,50,50,1.5,1,10,10,0,0,'','','','','',18,0.92,1); INSERT INTO `race_info` VALUES (30,'Ulbernaut','stonebm','M',0.8,1.4,0.6,'',100,50,50,50,50,50,50,1.5,1,10,10,0,0,'','','','','',19,0.92,1); INSERT INTO `race_info` VALUES (31,'Tefusang','stonebm','M',0.8,1.4,0.6,'',100,50,50,50,50,50,50,2,1.5,10,10,0,0,'','','','','',20,0.92,1); This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site. |
From: <rav...@us...> - 2016-12-16 00:47:41
|
Revision: 9976 http://sourceforge.net/p/planeshift/code/9976 Author: ravna-ps Date: 2016-12-16 00:47:39 +0000 (Fri, 16 Dec 2016) Log Message: ----------- Added: made a database table for server news in the WC, which the main sites server news can then read from. Modified Paths: -------------- trunk/src/server/database/mysql/upgrade_schema.sql Added Paths: ----------- trunk/src/server/database/mysql/wc_servernews.sql Modified: trunk/src/server/database/mysql/upgrade_schema.sql =================================================================== --- trunk/src/server/database/mysql/upgrade_schema.sql 2016-12-13 22:37:19 UTC (rev 9975) +++ trunk/src/server/database/mysql/upgrade_schema.sql 2016-12-16 00:47:39 UTC (rev 9976) @@ -1881,6 +1881,8 @@ ALTER TABLE accounts ADD COLUMN `Machine_type` char(6) DEFAULT NULL AFTER OS_platform; UPDATE `server_options` SET `option_value`='1280' WHERE `option_name`='db_version'; +SOURCE wc_servernews.sql; + # Insert your upgrade before this line. Remember when you set a new db_version # to update the server_options.sql file and update psserver.cpp as well. # This to ensure that everything is working if you use the create_all.sql to Added: trunk/src/server/database/mysql/wc_servernews.sql =================================================================== --- trunk/src/server/database/mysql/wc_servernews.sql (rev 0) +++ trunk/src/server/database/mysql/wc_servernews.sql 2016-12-16 00:47:39 UTC (rev 9976) @@ -0,0 +1,17 @@ +-- +-- Table structure for table `wc_servernews` +-- + +DROP TABLE IF EXISTS `wc_servernews`; +CREATE TABLE `wc_servernews` ( + `id` int(10) NOT NULL auto_increment, + `news` text , + UNIQUE KEY `id` (`id`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1; + +# +# Dumping data for table wc_servernews +# + +# The system only expects 1 single entry, using ID 1 +INSERT INTO `wc_servernews` VALUES (1, 'Server News'); \ No newline at end of file Property changes on: trunk/src/server/database/mysql/wc_servernews.sql ___________________________________________________________________ Added: svn:mime-type ## -0,0 +1 ## +text/plain \ No newline at end of property Added: svn:eol-style ## -0,0 +1 ## +native \ No newline at end of property This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site. |
From: <lpa...@us...> - 2022-01-01 20:37:52
|
Revision: 10010 http://sourceforge.net/p/planeshift/code/10010 Author: lpancallo Date: 2022-01-01 20:37:49 +0000 (Sat, 01 Jan 2022) Log Message: ----------- new item for testing improved list of tables on delete character Modified Paths: -------------- trunk/src/server/database/mysql/deletechar.sql trunk/src/server/database/mysql/item_instances.sql Modified: trunk/src/server/database/mysql/deletechar.sql =================================================================== --- trunk/src/server/database/mysql/deletechar.sql 2022-01-01 19:05:23 UTC (rev 10009) +++ trunk/src/server/database/mysql/deletechar.sql 2022-01-01 20:37:49 UTC (rev 10010) @@ -4,10 +4,15 @@ # The tables populated by a char are: # # characters +# character_discoveries +# character_events +# character_factions # character_glyphs # character_quests +# character_relationships # character_skills # character_traits +# character_variables # item_instances # player_spells # @@ -35,10 +40,16 @@ # perform deletion for one char only set @player_id=9242522; +delete from character_discoveries where character_id=@player_id; +delete from character_events where player_id=@player_id; +delete from character_factions where character_id=@player_id; +delete from character_glyphs where player_id=@player_id; +delete from character_quests where player_id=@player_id; +delete from character_relationships where character_id=@player_id; +delete from character_skills where character_id=@player_id; +delete from character_traits where character_id=@player_id; +delete from character_variables where character_id=@player_id; +delete from item_instances where char_id_owner=@player_id; delete from player_spells where player_id=@player_id; -delete from item_instances where char_id_owner=@player_id; -delete from character_traits where character_id=@player_id; -delete from character_skills where character_id=@player_id; -delete from character_quests where player_id=@player_id; -delete from character_glyphs where player_id=@player_id; + delete from characters where id=@player_id; Modified: trunk/src/server/database/mysql/item_instances.sql =================================================================== --- trunk/src/server/database/mysql/item_instances.sql 2022-01-01 19:05:23 UTC (rev 10009) +++ trunk/src/server/database/mysql/item_instances.sql 2022-01-01 20:37:49 UTC (rev 10010) @@ -151,6 +151,7 @@ # Key and lock for entrance INSERT INTO `item_instances` VALUES (95,0,0,0,0,1,0,0,0,3,-56,-1,-148,0,0,0,0,50,50,420,0,'LOCKED,SECURITYLOCK,UNPICKABLE',0,-1,'','','',NULL,'0',0,0,0); INSERT INTO `item_instances` VALUES (96,0,0,0,0,1,0,0,0,3,-54,1,-148,0,0,0,0,50,50,413,0,'KEY',0,-1,'95','','',NULL,'0',0,0,0); +INSERT INTO `item_instances` VALUES (97,0,0,0,0,1,0,0,0,3,-56,-1,-148,0,0,0,0,50,50,420,0,'LOCKED,LOCKABLE',0,-1,'','','',NULL,'0',0,0,0); # Items on ground INSERT INTO `item_instances` VALUES (100,0,0,0,0,1,0,0,0,3,-2.72,0.37,-182.03,0,90,0,0,50,50,74,0,'NOPICKUP',0,-1,'','','',NULL,'0',0,0,0); This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site. |