# MySQL-Front Dump 1.16 beta # # Host: localhost Database: planeshift #-------------------------------------------------------- # Server version 4.0.18-max-nt # # Table structure for table 'quest_scripts' # CREATE TABLE quest_scripts ( id int(10) unsigned NOT NULL auto_increment, quest_id int(10) unsigned NOT NULL DEFAULT '0', script blob NOT NULL DEFAULT '' , PRIMARY KEY (id) ); # # Dumping data for table 'quest_scripts' # # # Quest: "Rescue the Princess" # INSERT INTO quest_scripts VALUES("1","1","P:give me quest Merchant: Congratulation, you get to save the princess now. Assign Quest ... P: done M: OMG you did it! I can't believe it. Give Mug or Steel Falchion or Claymore "); # # Quest: "Sandwich Quest" # INSERT INTO quest_scripts VALUES("2","2","P: can bring you Merchant: I'm kinda hungry.. bring me a sandwich and hurry if you want a hexa and a mug for your trouble.(I don't need anything right now.) Assign Quest ... P: here you M: Many thanks, this help for my hunger. Give 1 hexa. Give Mug. Give 3 Potion of Healing. "); # # Quest: "Falchion Quest" # INSERT INTO quest_scripts VALUES("3","3","P: can bring you Merchant: Kill the enkidukai who wanders in the forest and bring me his steel falchion.(Don't think I need anything right now.) Assign Quest ... Player gives Merchant Steel Falchion M: Many thanks, brave stranger. This will come in handy if the fans misbehave. Give 1 octa "); # # Quest: "Male Enki Alina Quest" # INSERT INTO quest_scripts VALUES("4","10","P: Greetings MaleEnki: Hail! Would you like to earn a little money? P: No P: Yes M: Well ok then. Have a good day. M: My daughter Alina ran off with the smith and I fear they are up to no good. If you can find out if he really loves her, I'll pay you. Can you do this for me? P: No P: Yes M: Fair enough. I guess I'll just try to find someone else. M: Last time I caught them upstairs above the blacksmith shop. Please hurry up and ask her! Assign Quest. P: Greetings Smith: Go away! We're busy.{her:Alina} P: * P: Do you love Alina S: You are so rude! Go away! Run script(3) kick_you S: Of course I love her! We are going to marry in the morning. P: Greetings MaleEnki: Oh I'm so glad you are back. Did you find him? Does he love her?{him:Smith,her:Alina} P: * P: Smith says Smith does. Smith love Alina. M: That isn't what Thalia told me 5 minutes ago. You're just faking to get the money! Go away! M: Ah! Thank heavens. Perhaps now they will get married! Thanks for your help! Give 25 tria. "); # # Quest: "Male Enki Gold" # INSERT INTO quest_scripts VALUES("5","11","P: Greetings MaleEnki: Hello there. I'm looking for gold ore... Can you find some for me? P: No. P: Yes. M: Ok I guess I'll just try to find someone else to help me. M: Excellent. If you will bring me 5 gold ores, I will reward you handsomely! Assign Quest. ... Player gives MaleEnki 5 Gold Ore. M: Ah these are just what I needed! Thanks so much! (How generous of you to just give me gold. Now go away!) Give Small Battle Axe. "); # # Quest: "Male Enki Trusted Transport" # INSERT INTO quest_scripts VALUES("6","12","P: Greetings MaleEnki: Hello $sir my good friend! Can I trust you to carry out one more thing for me?(I have nothing to say to you!) P: No P: Yes M: I will not bother you anymore M: Greate! I have a glyph that I have agreed to exchange with a special sword that the Smith have made for me. Can you take this to him and bring back the sword? P: No P: Yes M: Come by some other time, when you have time M: Excellent. I will reward you when you return Assign Quest Give Faith ... P: I bring glyph from MaleEnki Smith: I have been waiting for this. Give me the glyph and I give you the sword. Player gives Smith Faith Smith: Here you go Give Gold Falchion. Complete Male Enki Trusted Transport Step 2 ... Player gives Smith Faith Smith: A the glyph from the MaleEnki Give Gold Falchion. Complete Male Enki Trusted Transport Step 2 ... Require completion of Male Enki Trusted Transport Step 2 Player gives MaleEnki Gold Falchion MaleEnki: Thank you my friend Give 2 octa "); # # Quest Test Case Quests # INSERT INTO quest_scripts VALUES("101","101","P: step1 QuestMaster1: Yes, this is step1. [Type 'step3', verify error response. Type 'step4', verify error response. Type 'step2'] Assign Quest. ... P: step two. step2. Q: Yes, this is step2. [You have now completed step2. Type 'step2',verify quest substep can be restarted. Type 'step3'] Complete QuestMaster1 Quest 1 Step 2. ... NoRepeat Require completion of QuestMaster1 Quest 1 Step 2. P: step3. step tree Q: Yes this is step3. Answer Yes or No. [First run type 'no', Second run type 'yes'] P: No. P: Yes Q: This is the answer to No.[Type 'step4'] Complete QuestMaster1 Quest 1 Step 3 Q: This is the answer to Yes.[Type 'step3' verify no repeat substep can't be restarted. ... Type 'step3b'] Complete QuestMaster1 Quest 1 Step 3 ... NoRepeat P: step3b Q: Yes this is step3b. [Type 'step3b', verify quest substep can't be restarted. Type 'step4'] Complete QuestMaster1 Quest 1 Step 4 ... Require completion of QuestMaster1 Quest 1 Step 3 P: step4 Q: Yes, this is step4. [Type 'step4', verify error response. Type 'step2', verify error response. First run type 'step1'] "); INSERT INTO quest_scripts VALUES("102","102","P: quest2 QuestMaster1: Yes, this is QuestMaster1 Quest2. [Type 'done'] Assign Quest. ... P: done. Q: Your done. [First run: Type 'quest2', within 30 sec to verify no quest assigned. Type 'quest2' after 30 sec verify 'QuestMaster1 Quest 2' assigned again. Second run: Type 'quest3'] "); INSERT INTO quest_scripts VALUES("103","103","P: quest3 QuestMaster1: Yes, this is QuestMaster1 Quest3. [Type 'done'] Assign Quest. ... P: done. Q: Your done. [First run: Type 'quest3', within 30 sec of assignment to verify no quest assigned. Type 'quest2' after 30 sec avter assignemnt, verify 'QuestMaster1 Quest 2' assigned again. Second run: Do this from another client.] "); INSERT INTO quest_scripts VALUES("201","201","P: quest1 QuestMaster2: Yes, this is QuestMaster2 Quest1. [Type 'done'] Assign Quest. ... P: done. Q: Your done. [Type 'quest4',verify no quest assigned. Type 'quest2' verify 'QuestMaster1 Quest 2' assigned.] "); INSERT INTO quest_scripts VALUES("202","202","P: quest2 QuestMaster2: Yes, this is QuestMaster2 Quest2. [Type 'done'] Assign Quest. ... P: done. Q: Your done. [Type 'quest5' verify no quest assigned. Type 'quest3',verify 'QuestMaster1 Quest 3' assigned.] "); INSERT INTO quest_scripts VALUES("203","203","P: quest3 QuestMaster2: Yes, this is QuestMaster2 Quest3. [Type 'done'] Assign Quest. ... P: done. Q: Your done. [Type 'quest4',verify 'QuestMaster1 Quest 4' assigned.] "); INSERT INTO quest_scripts VALUES (204,204,'P: quest4\r\n\r\nQuestMaster2: Yes, this is QuestMaster2 Quest4.\r\n\r\nAssign Quest.\r\n\r\n... NoRepeat\r\n\r\nP: step2\r\n\r\nQuestMaster2: Yes, this is step2, it\'s not repeatable.\r\n\r\nP: step2b\r\n\r\nQuestMaster2: Yes, this is step2b, it\'s not repeatable.\r\n\r\nComplete QuestMaster2 Quest 4 Step 2.\r\n\r\n...\r\n\r\nP: done.\r\n\r\nQ: Your done. [Type \'quest5\',verify \'QuestMaster1 Quest 5\' assigned.]\r\n'); INSERT INTO quest_scripts VALUES("205","205","P: quest5 QuestMaster2: Yes, this is QuestMaster2 Quest5. [Type 'done'] Assign Quest. ... P: done. Q: Your done. ");