Keazain
18-02-09, 01:28 PM
This is a full working quest for arcemu 3.0.9 from keazain. You can copy this below fields and edit your own Quest settings and i explain how you do and what you can do etc.
You will need 6 inserts for making 1 new quest working on 3.0.9 and higher!
first you need to make a NPC!
1. find a character ingame you want to use as your NPC Display.
2. say: .npc i
3. look what Display ID your npc have and write this down (examble: Display ID: 29259 = Spirit Healer)
4. now, use this line below (copy this below line to youe notepad) and change those rows that i have edited for you!
insert into `creature_names` values ('YOUR NPC ENTRY "NUMBER" ID YOU WANT','NAME OF YOUR QUEST/NPC HERE','','','0','7','0','0','0','MALE DISPLAY ID HERE','FEMALE DISPLAY ID HERE','0','0','0','1','1','1',NULL);
5. when that is done, continue from here.
6. Now you need to make your proto, this is needed to make your NPC visible ingame and spawnable!
7. Now copy this below line under your first line in notepad! and remember to edit your entry number (the same as in `creature_names` table)
insert into `creature_proto` values ('YOUR NPC ENTRY "NUMBER" ID SAME AS IN FIRST LINE','80','80','35','133','133','0','1','2','2000 ','0','3','3.87','0','0','0','0','0','0','0','0',' 0','0','0','0','1','1','0','0','0','0','0','2.5',' 8','14','0','0','0','0','0','0','0');
8. Now your NPC is ready to get spawned ingame and your players can go to NPC and Talk!
9. Now your need to make your Quest finisher and starter for database to know what entrys it have to call from, you need to tell your table what entry your quest is in and what quest it have to run from!
10. Now copy those two below line`s and paste to your notepad below your firsat pasted lines and edit to fit your NPC ID
insert into `creature_quest_finisher` (`id`, `quest`) values ('YOUR NPC ENTRY "NUMBER" ID SAME AS IN YOUR NPC','QUEST ID OF YOUR CHOICE');
insert into `creature_quest_starter` (`id`, `quest`) values ('YOUR NPC ENTRY "NUMBER" ID SAME AS IN YOUR NPC','THE SAME QUEST ID HERE');
11. Now you have the first important lines ready. We now want to make the quest that you want your players to have.
12. Look at this below insert, here you make your quest. First give your ID entry like in ID from quest finish and quest start. After that make your text fields (text in red) chose the text you want the quest box field to show.
Now make your choice of spells and items you want your NPC to reward the player with. In this quest you get 4 castspells for riding Time-Lost Proto-Drake and Mekgineer's Chopper. You also GOT those two mounts after you NPC have casted this spells on your players.
Last we have chosen NPC to give player 50,000 gold free and 1 dynamite for fun.
13. Now look at the fields and make your own items and spells you want your quest NPC to cast on your players in startreward or after your obstacle course etc.
14. Now copy this insert field and paste it into your notepad below the other lines and continue to this last insert bellow.
insert into `quests` values ('THE SAME QUEST ID HERE','0','0','0','1','7','0','0','0','0','0','0', '0','0','0','0','0','0','0','Welcomer','Dear $n. Welcome to our Server.\r\nTake our Reward and enjoy your Stay!','Talk to me Again!','Complete Quest for your reward!','','Bye Bye ...','','','','','0','0','0','0','0','0','0','0',' 0','0','0','0','0','0','0','0','33690','51306','67 4','33388','0','0','0','0','0','0','0','0','0','0' ,'0','0','127034','127033','18588','0','0','0','0' ,'0','0','0','0','0','0','0','0','0','0','0','0',' 0','0','500000000','0','4036','51617','0','0','0', '0','0','0','0','0','0','','0','0','0','0','','1', '0','0','0','0','0','0','0','1','3000','0','30','0 ','0','0','0','0','0','0','0','0','0','0','0','0', '0','0','0','0','0','0','0','0');
15. This bellow text is to your gossip text, NOT important, but nice to have...
16. Copy this last line and paste this to your notepad bellow your other lines.
insert into trainer_defs values ('YOUR NPC ENTRY "NUMBER" ID HERE', '0', '0', '0', '0', '0', '0', '0', 'Hello $N! Ready for some Quest?', '0', '0');
17. Now you have ALL lines ready to load to your Database for your new quest!!!
18. Now you have you desired CUSTOM QUEST made of your own. Open your Database and load this SQL into your DB and restart your server.
19. Now you just need to spawn your NPC (say: .npc spawn NPC-ID 1)
20. Your quest is now ready and works fine!
EXAMBLE BELLOW:
************************************************** ************************************************** ********************
insert into `creature_names` values
('990000200','Reward Quest','','','0','7','0','0','0',NULL,'24191','0', '0','0','1','1','1',NULL);
insert into `creature_proto` values
('990000200','80','80','35','133','133','0','1.3', '2','2000','0','3','3.87','0','0','0','0','0','0', '0','0','0','0','0','0','1','1','0','0','0','0','0 ','2.5','8','14','0','0','0','0','0','0','0');
insert into `creature_quest_finisher` (`id`, `quest`) values('990000200','990000201');
insert into `creature_quest_starter` (`id`, `quest`) values('990000200','990000201');
insert into `quests` values ('990000201','0','0','0','1','7','0','0','0','0',' 0','0','0','0','0','0','0','0','0','Welcomer','Dea r $n. Welcome to our Server.\r\nTake our Reward and enjoy your Stay!','Talk to me Again!','Complete Quest for your reward!','','Bye Bye ...','','','','','0','0','0','0','0','0','0','0',' 0','0','0','0','0','0','0','0','33690','51306','67 4','33388','0','0','0','0','0','0','0','0','0','0' ,'0','0','127034','127033','18588','0','0','0','0' ,'0','0','0','0','0','0','0','0','0','0','0','0',' 0','0','500000000','4294967295','4036','51617','0' ,'0','0','0','0','0','0','0','0','','0','0','0','0 ','','1','0','0','0','0','0','0','0','1','3000','0 ','30','0','0','0','0','0','0','0','0','0','0','0' ,'0','0','0','0','0','0','0','0','0','0');
insert into trainer_defs values
('990000200', '0', '0', '0', '0', '0', '0', '0', 'Hello $N! Ready for some Rewards!', '0', '0');
************************************************** ************************************************** ********************
You just need to use this insert`s i have done and remake to make your own custom quests, with this quest you can make Gold Quests, Welcome Rewarder, Item Quests, Spell Quests, Skill Quests etc.
Hope this can help you making your own FUN Custom Quests :)
Best regards from Keazain ;)
You will need 6 inserts for making 1 new quest working on 3.0.9 and higher!
first you need to make a NPC!
1. find a character ingame you want to use as your NPC Display.
2. say: .npc i
3. look what Display ID your npc have and write this down (examble: Display ID: 29259 = Spirit Healer)
4. now, use this line below (copy this below line to youe notepad) and change those rows that i have edited for you!
insert into `creature_names` values ('YOUR NPC ENTRY "NUMBER" ID YOU WANT','NAME OF YOUR QUEST/NPC HERE','','','0','7','0','0','0','MALE DISPLAY ID HERE','FEMALE DISPLAY ID HERE','0','0','0','1','1','1',NULL);
5. when that is done, continue from here.
6. Now you need to make your proto, this is needed to make your NPC visible ingame and spawnable!
7. Now copy this below line under your first line in notepad! and remember to edit your entry number (the same as in `creature_names` table)
insert into `creature_proto` values ('YOUR NPC ENTRY "NUMBER" ID SAME AS IN FIRST LINE','80','80','35','133','133','0','1','2','2000 ','0','3','3.87','0','0','0','0','0','0','0','0',' 0','0','0','0','1','1','0','0','0','0','0','2.5',' 8','14','0','0','0','0','0','0','0');
8. Now your NPC is ready to get spawned ingame and your players can go to NPC and Talk!
9. Now your need to make your Quest finisher and starter for database to know what entrys it have to call from, you need to tell your table what entry your quest is in and what quest it have to run from!
10. Now copy those two below line`s and paste to your notepad below your firsat pasted lines and edit to fit your NPC ID
insert into `creature_quest_finisher` (`id`, `quest`) values ('YOUR NPC ENTRY "NUMBER" ID SAME AS IN YOUR NPC','QUEST ID OF YOUR CHOICE');
insert into `creature_quest_starter` (`id`, `quest`) values ('YOUR NPC ENTRY "NUMBER" ID SAME AS IN YOUR NPC','THE SAME QUEST ID HERE');
11. Now you have the first important lines ready. We now want to make the quest that you want your players to have.
12. Look at this below insert, here you make your quest. First give your ID entry like in ID from quest finish and quest start. After that make your text fields (text in red) chose the text you want the quest box field to show.
Now make your choice of spells and items you want your NPC to reward the player with. In this quest you get 4 castspells for riding Time-Lost Proto-Drake and Mekgineer's Chopper. You also GOT those two mounts after you NPC have casted this spells on your players.
Last we have chosen NPC to give player 50,000 gold free and 1 dynamite for fun.
13. Now look at the fields and make your own items and spells you want your quest NPC to cast on your players in startreward or after your obstacle course etc.
14. Now copy this insert field and paste it into your notepad below the other lines and continue to this last insert bellow.
insert into `quests` values ('THE SAME QUEST ID HERE','0','0','0','1','7','0','0','0','0','0','0', '0','0','0','0','0','0','0','Welcomer','Dear $n. Welcome to our Server.\r\nTake our Reward and enjoy your Stay!','Talk to me Again!','Complete Quest for your reward!','','Bye Bye ...','','','','','0','0','0','0','0','0','0','0',' 0','0','0','0','0','0','0','0','33690','51306','67 4','33388','0','0','0','0','0','0','0','0','0','0' ,'0','0','127034','127033','18588','0','0','0','0' ,'0','0','0','0','0','0','0','0','0','0','0','0',' 0','0','500000000','0','4036','51617','0','0','0', '0','0','0','0','0','0','','0','0','0','0','','1', '0','0','0','0','0','0','0','1','3000','0','30','0 ','0','0','0','0','0','0','0','0','0','0','0','0', '0','0','0','0','0','0','0','0');
15. This bellow text is to your gossip text, NOT important, but nice to have...
16. Copy this last line and paste this to your notepad bellow your other lines.
insert into trainer_defs values ('YOUR NPC ENTRY "NUMBER" ID HERE', '0', '0', '0', '0', '0', '0', '0', 'Hello $N! Ready for some Quest?', '0', '0');
17. Now you have ALL lines ready to load to your Database for your new quest!!!
18. Now you have you desired CUSTOM QUEST made of your own. Open your Database and load this SQL into your DB and restart your server.
19. Now you just need to spawn your NPC (say: .npc spawn NPC-ID 1)
20. Your quest is now ready and works fine!
EXAMBLE BELLOW:
************************************************** ************************************************** ********************
insert into `creature_names` values
('990000200','Reward Quest','','','0','7','0','0','0',NULL,'24191','0', '0','0','1','1','1',NULL);
insert into `creature_proto` values
('990000200','80','80','35','133','133','0','1.3', '2','2000','0','3','3.87','0','0','0','0','0','0', '0','0','0','0','0','0','1','1','0','0','0','0','0 ','2.5','8','14','0','0','0','0','0','0','0');
insert into `creature_quest_finisher` (`id`, `quest`) values('990000200','990000201');
insert into `creature_quest_starter` (`id`, `quest`) values('990000200','990000201');
insert into `quests` values ('990000201','0','0','0','1','7','0','0','0','0',' 0','0','0','0','0','0','0','0','0','Welcomer','Dea r $n. Welcome to our Server.\r\nTake our Reward and enjoy your Stay!','Talk to me Again!','Complete Quest for your reward!','','Bye Bye ...','','','','','0','0','0','0','0','0','0','0',' 0','0','0','0','0','0','0','0','33690','51306','67 4','33388','0','0','0','0','0','0','0','0','0','0' ,'0','0','127034','127033','18588','0','0','0','0' ,'0','0','0','0','0','0','0','0','0','0','0','0',' 0','0','500000000','4294967295','4036','51617','0' ,'0','0','0','0','0','0','0','0','','0','0','0','0 ','','1','0','0','0','0','0','0','0','1','3000','0 ','30','0','0','0','0','0','0','0','0','0','0','0' ,'0','0','0','0','0','0','0','0','0','0');
insert into trainer_defs values
('990000200', '0', '0', '0', '0', '0', '0', '0', 'Hello $N! Ready for some Rewards!', '0', '0');
************************************************** ************************************************** ********************
You just need to use this insert`s i have done and remake to make your own custom quests, with this quest you can make Gold Quests, Welcome Rewarder, Item Quests, Spell Quests, Skill Quests etc.
Hope this can help you making your own FUN Custom Quests :)
Best regards from Keazain ;)