provocating
02-25-2012, 07:15 PM
FYI, I have to set a range, this way I can keep my database up to PEQ, but still be able to work on quest, zones, etc. Here are a few I have been working on, all stuff gathered from live. The XP probably needs to be set better than what I have it at. I was thinking about doing the negative XP idea on just rewarding based on level, Cavedude can decide that.
SET @task_id=500;
SET @explore_id=500;
SET @id_range=50;
DELETE FROM `tasks` WHERE `id`>=@task_id AND `id`<=@task_id+@id_range;
DELETE FROM `activities` WHERE `taskid`>=@task_id and `taskid`<=@task_id+@id_range;
DELETE FROM `proximities` WHERE `exploreid`>=@explore_id and `exploreid`<=@explore_id+@id_range;
-- Cadale Brohat (224219)
-- Pray for Life
INSERT INTO `tasks` (`id`, `duration`, `title`, `description`, `reward`, `rewardid`, `cashreward`, `xpreward`, `rewardmethod`, `startzone`, `minlevel`, `maxlevel`, `repeatable`) VALUES (@task_id, 0, 'Pray for Life', '[1,What a glorious day to go on patrol! That\'s exactly what you\'ll be doing for the next little while, soldier. You\'re going to start by taking\r\n the time to explore the small prayer pedestal to the left of the entrance. Don\'t do anything fancy, just keep your eyes peeled for any signs of hostile actions in the area.\r\n If you find anything, then you\'ll know what to do. Good luck!][2,Whoa! Hold up a minute! Did you hear the commotion? There\'s been a report of an enemy \r\n unit nearby! Go find them and kill 10 shady treasure sorters, Make sure you get rid of them all, even if it\'s just for the thrill of the hunt. Speaking of which,\r\n go ahead and loot 4 Shiv, while you\'re at it, just so you have something to remember the adventure. You can put them on your wall at home later on.][3,Time to get back to your patrol duties, so explore the Hungry Shark tavern along the southern docks, when you\'re done, you can head back.][4, Aside from that little skirmish you had, your patrol wasn\'t too taxing. That\'s more than can be said for some of the others that were sent on patrol today. In any case, you do have those prizes you collected, so why not deliver 4 Shiv to Welligorn, so they can be stuffed and put on display for you.]', 'Experience and Loot', 0, 94301, 4000000, 0, 224, 32, 0, 0);
INSERT INTO `activities` (`taskid`, `activityid`, `step`, `activitytype`, `text1`, `text2`, `text3`, `goalid`, `goalmethod`, `goalcount`, `delivertonpc`, `zoneid`, `optional`) VALUES (@task_id, 4, 3, 1, 'Welligorn', 'Shivs', '', 52027, 0, 4, 224104, 224, 0);
INSERT INTO `activities` (`taskid`, `activityid`, `step`, `activitytype`, `text1`, `text2`, `text3`, `goalid`, `goalmethod`, `goalcount`, `delivertonpc`, `zoneid`, `optional`) VALUES (@task_id, 0, 0, 5, 'the small prayer pedestal.', '', '', @explore_id, 0, 1, 0, 224, 0);
INSERT INTO `proximities` (`zoneid`, `exploreid`, `minx`, `maxx`, `miny`, `maxy`, `minz`, `maxz`) VALUES (224, @explore_id, 2487.000000, 2549.000000, -2915.000000, -2862.000000, 460.000000, 490.000000);
INSERT INTO `activities` (`taskid`, `activityid`, `step`, `activitytype`, `text1`, `text2`, `text3`, `goalid`, `goalmethod`, `goalcount`, `delivertonpc`, `zoneid`, `optional`) VALUES (@task_id, 1, 1, 2, 'A Shady Treasure Sorter', '', '', 225075, 0, 10, 0, 225, 0);
INSERT INTO `activities` (`taskid`, `activityid`, `step`, `activitytype`, `text1`, `text2`, `text3`, `goalid`, `goalmethod`, `goalcount`, `delivertonpc`, `zoneid`, `optional`) VALUES (@task_id, 2, 1, 3, 'Shivs', '', '', 52027, 0, 4, 0, 225, 0);
SET @explore_id=@explore_id+1;
INSERT INTO `activities` (`taskid`, `activityid`, `step`, `activitytype`, `text1`, `text2`, `text3`, `goalid`, `goalmethod`, `goalcount`, `delivertonpc`, `zoneid`, `optional`) VALUES (@task_id, 3, 2, 5, 'Hungry Shark tavern', '', '', @explore_id, 0, 1, 0, 225, 0);
INSERT INTO `proximities` (`zoneid`, `exploreid`, `minx`, `maxx`, `miny`, `maxy`, `minz`, `maxz`) VALUES (225, @explore_id, -581.000000, -561.000000, -612.000000, -592.000000, 0.000000, 20.000000);
-- Time for Bed
SET @task_id=@task_id+1;
INSERT INTO `tasks` (`id`, `duration`, `title`, `description`, `reward`, `rewardid`, `cashreward`, `xpreward`, `rewardmethod`, `startzone`, `minlevel`, `maxlevel`, `repeatable`) VALUES (@task_id, 0, 'Time for Bed', '[1,The world is growing at an alarming rate and there aren\'t enough plots of land available for everyone and their livestock to live in. That\'s why it\'s up to you to find some new plots of land. Your first target is going to be nearby, which is why you need to explore the sleeping quarters in the southern mines. You\'ll know once you arrive if it\'s a good place of property or not.][2,That wasn\'t the most hospitable place in the world, especially not for a family, but there are plenty of other locations you can visit. This time, why don\'t you explore the ship Oceancrasher at one of the eastern docks,? You\'re bound to get lucky sooner or later and find a suitable living spot.][3,It\'s interesting that there wasn\'t a good area anywhere. You\'re going to have to let the prospective buyers know about it, so speak with Dellthuea, to give them the bad news.]', 'Experience and Loot', 0, 94301, 1300000, 0, 224, 40, 0, 0);
SET @explore_id=@explore_id+1;
INSERT INTO `activities` (`taskid`, `activityid`, `step`, `activitytype`, `text1`, `text2`, `text3`, `goalid`, `goalmethod`, `goalcount`, `delivertonpc`, `zoneid`, `optional`) VALUES (@task_id, 0, 1, 5, 'the sleeping quarters in the southern mines', '', '', @explore_id, 0, 1, 0, 226, 0);
INSERT INTO `proximities` (`zoneid`, `exploreid`, `minx`, `maxx`, `miny`, `maxy`, `minz`, `maxz`) VALUES (226, @explore_id, 10.000000, 30.000000, -120.000000, -100.000000, 0.000000, 2.000000);
INSERT INTO `activities` (`taskid`, `activityid`, `step`, `activitytype`, `text1`, `text2`, `text3`, `goalid`, `goalmethod`, `goalcount`, `delivertonpc`, `zoneid`, `optional`) VALUES (@task_id, 2, 3, 4, 'Dellthuea', '', '', 224106, 0, 1, 0, 224, 0);
SET @explore_id=@explore_id+1;
INSERT INTO `activities` (`taskid`, `activityid`, `step`, `activitytype`, `text1`, `text2`, `text3`, `goalid`, `goalmethod`, `goalcount`, `delivertonpc`, `zoneid`, `optional`) VALUES (@task_id, 1, 2, 5, 'the ship Oceancrasher', '', '', @explore_id, 0, 1, 0, 225, 0);
INSERT INTO `proximities` (`zoneid`, `exploreid`, `minx`, `maxx`, `miny`, `maxy`, `minz`, `maxz`) VALUES (225, @explore_id, -1809.000000, -1770.000000, 214.000000, 263.000000, -40.000000, -20.000000);
-- Ahoy, Ye Bony Mate (Gunthak highest)
SET @task_id=@task_id+1;
INSERT INTO `tasks` (`id`, `duration`, `title`, `description`, `reward`, `rewardid`, `cashreward`, `xpreward`, `rewardmethod`, `startzone`, `minlevel`, `maxlevel`, `repeatable`) VALUES (@task_id, 0, 'Ahoy, Ye Bony Mate', '[1,Ready to go on a hunt? The local landowners are putting together a hunting contest and you\'ve been invited. Though it\'s a group event, you are to go off on your own and kill 10 deadly skeletal sailors. Before they\'ll accept that you actually did the deed yourself, they\'re going to want proof, so make sure you loot 4 Bone Chips, before you return.][2,The hunting went superbly well, it seems, and you\'re on your way to winning. All you need to do now is to deliver 4 Bone Chips to Calambra, so you\'re not disqualified for not fulfilling all the requirements.]', 'Experience and Loot', 0, 94301, 500000, 0, 224, 30, 0, 0);
INSERT INTO `activities` (`taskid`, `activityid`, `step`, `activitytype`, `text1`, `text2`, `text3`, `goalid`, `goalmethod`, `goalcount`, `delivertonpc`, `zoneid`, `optional`) VALUES (@task_id, 0, 1, 2, 'deadly skeletal sailors', '', '', 224213, 0, 10, 0, 224, 0);
INSERT INTO `activities` (`taskid`, `activityid`, `step`, `activitytype`, `text1`, `text2`, `text3`, `goalid`, `goalmethod`, `goalcount`, `delivertonpc`, `zoneid`, `optional`) VALUES (@task_id, 1, 2, 3, '', '', 'Loot 4 bone chips', 13073, 0, 4, 0, 224, 0);
INSERT INTO `activities` (`taskid`, `activityid`, `step`, `activitytype`, `text1`, `text2`, `text3`, `goalid`, `goalmethod`, `goalcount`, `delivertonpc`, `zoneid`, `optional`) VALUES (@task_id, 2, 3, 1, 'Calambra', 'Bone Chips', '', 13073, 0, 4, 224107, 224, 0);
-- Brains over Brawn (Gunthak highest)
SET @task_id=@task_id+1;
INSERT INTO `tasks` (`id`, `duration`, `title`, `description`, `reward`, `rewardid`, `cashreward`, `xpreward`, `rewardmethod`, `startzone`, `minlevel`, `maxlevel`, `repeatable`) VALUES (@task_id, 0, 'Brains Over Brawn', '[1,2,Bounty hunter extraordinaire. How does that sound? It\'s time to test your skills and to do so you\'re going to need to kill 10 pestilent troll zombies, and quickly. You only receive the bounty if you make sure to loot 4 Zombie Skin, though, so don\’t forget. You\'re going to have to prove yourself if you want everyone to start calling you extraordinary.][3,Did you stop to breathe at all? Your prowess in the field of hunting far exceeded everyone\'s expectations. To receive your bounty, just deliver 4 Zombie Skin to Dellthuea.][4,You really are on the path to becoming extraordinary. Everyone believed the title you donned was fictional, but you really are almost worthy to hold the title. Here\'s your bounty, and who knows? If you keep up the good work, there may be more bounties for you to collect in the near future.]', 'Experience and Loot', 0, 78301, 500000, 0, 224, 30, 0, 0);
INSERT INTO `activities` (`taskid`, `activityid`, `step`, `activitytype`, `text1`, `text2`, `text3`, `goalid`, `goalmethod`, `goalcount`, `delivertonpc`, `zoneid`, `optional`) VALUES (@task_id, 0, 1, 2, 'Emaciated Zombie', '', '', 224094, 0, 10, 0, 224, 0);
INSERT INTO `activities` (`taskid`, `activityid`, `step`, `activitytype`, `text1`, `text2`, `text3`, `goalid`, `goalmethod`, `goalcount`, `delivertonpc`, `zoneid`, `optional`) VALUES (@task_id, 1, 1, 3, '', '', 'Loot 4 Zombie Skin', 13074, 0, 4, 0, 224, 0);
INSERT INTO `activities` (`taskid`, `activityid`, `step`, `activitytype`, `text1`, `text2`, `text3`, `goalid`, `goalmethod`, `goalcount`, `delivertonpc`, `zoneid`, `optional`) VALUES (@task_id, 2, 3, 1, 'Dellthuea', 'Zombie Skin', '', 13074, 0, 4, 224106, 0, 0);
-- Don`t Be Scared
SET @task_id=@task_id+1;
INSERT INTO `tasks` (`id`, `duration`, `title`, `description`, `reward`, `rewardid`, `cashreward`, `xpreward`, `rewardmethod`, `startzone`, `minlevel`, `maxlevel`, `repeatable`) VALUES (@task_id, 0, 'Don\'t Be Scared', '[1,Speak with Calambra][2,With what you\'ve just learned, you\'re more than ready to get out there and rid the lands of pests! Go and kill 10 vicious skeletons, and when you\'re done, you\'ll no doubt have a new respect for the tricks of the trade.][3,4,Now that you\'ve had some practice, you\'re ready to step things up a notch. This time, go kill 10 emaciated zombies, and while you\'re there, loot 4 Zombie Skin. That way, you\'ll get a first-hand glimpse of what it is those pests can carry with them.][5,You did a terrific job, better than any exterminator before you. Since you have some extra items on you that aren’t worth a whole lot, you can probably just deliver 4 Zombie Skin to Dellthuea, and be done with them. You\'ve learned all there is about exterminating, for now.]', 'Experience and Loot', 0, 54123, 666000, 0, 224, 30, 0, 0);
INSERT INTO `activities` (`taskid`, `activityid`, `step`, `activitytype`, `text1`, `text2`, `text3`, `goalid`, `goalmethod`, `goalcount`, `delivertonpc`, `zoneid`, `optional`) VALUES (@task_id, 4, 4, 1, 'Dellthuea', 'zombie skin', '', 13074, 0, 4, 224106, 224, 0);
INSERT INTO `activities` (`taskid`, `activityid`, `step`, `activitytype`, `text1`, `text2`, `text3`, `goalid`, `goalmethod`, `goalcount`, `delivertonpc`, `zoneid`, `optional`) VALUES (@task_id, 3, 3, 3, 'zombie skin', '', '', 13074, 0, 4, 0, 224, 0);
INSERT INTO `activities` (`taskid`, `activityid`, `step`, `activitytype`, `text1`, `text2`, `text3`, `goalid`, `goalmethod`, `goalcount`, `delivertonpc`, `zoneid`, `optional`) VALUES (@task_id, 2, 3, 2, 'emaciated zombies', '', '', 224094, 0, 10, 0, 224, 0);
INSERT INTO `activities` (`taskid`, `activityid`, `step`, `activitytype`, `text1`, `text2`, `text3`, `goalid`, `goalmethod`, `goalcount`, `delivertonpc`, `zoneid`, `optional`) VALUES (@task_id, 1, 2, 2, 'vicious skeletons', '', '', 224015, 0, 10, 0, 224, 0);
INSERT INTO `activities` (`taskid`, `activityid`, `step`, `activitytype`, `text1`, `text2`, `text3`, `goalid`, `goalmethod`, `goalcount`, `delivertonpc`, `zoneid`, `optional`) VALUES (@task_id, 0, 1, 4, 'Calambra', '', '', 224107, 0, 1, 0, 224, 0);
-- Gathering Skin
SET @task_id=@task_id+1;
INSERT INTO `tasks` (`id`, `duration`, `title`, `description`, `reward`, `rewardid`, `cashreward`, `xpreward`, `rewardmethod`, `startzone`, `minlevel`, `maxlevel`, `repeatable`) VALUES (@task_id, 0, 'Gathering Skin', '[1,Long ago, a wise man once said that the power of the mind can destroy even the tallest giant. Whether or not that\'s true, you\'re going to visit a pupil of that wise man to learn more about the ways of the world. Make haste to speak with Calambra. When you arrive, you will find that there is more to life than the absent pursuit of wealth.][2,The old wise man\'s words carried his students through the roughest wars and the coldest winters. It taught them a sense of discipline and restraint they had never known existed. But his teachings also pushed them to fight back when the forces of power tried to annihilate the weak. Now it\'s your turn to take the fight to those forces once again. Use the teachings of the old man\'s pupil and kill 10 vicious skeletons.][3,4,What was once thought to be the end of conflicts merely brought more to the table. As it was before, you must continue to defeat the threat of tyranny and kill 10 emaciated zombies. They must not be allowed to take control over these lands and it is up to you to stop them. They\'re protecting their wealth, so take it from them by loot 4 Zombie Skin. Time is of the essence young student.][5,You have reached a peak in your learning. At the very least, you have learned what it is to be a learned student. You have come a long way in a short time and there is indeed a future for you if you continue along the path of enlightenment. For now, deliver 4 Zombie Skin to Dellthuea, for they are behind some of the tyranny that brews in the world. You now have the power to end it.]\r\n', 'Experience and Loot', 0, 54123, 666000, 0, 224, 30, 0, 0);
INSERT INTO `activities` (`taskid`, `activityid`, `step`, `activitytype`, `text1`, `text2`, `text3`, `goalid`, `goalmethod`, `goalcount`, `delivertonpc`, `zoneid`, `optional`) VALUES (@task_id, 0, 1, 4, 'Calambra', '', '', 224107, 0, 1, 0, 224, 0);
INSERT INTO `activities` (`taskid`, `activityid`, `step`, `activitytype`, `text1`, `text2`, `text3`, `goalid`, `goalmethod`, `goalcount`, `delivertonpc`, `zoneid`, `optional`) VALUES (@task_id, 1, 2, 2, 'vicious skeletons', '', '', 224015, 0, 10, 0, 224, 0);
INSERT INTO `activities` (`taskid`, `activityid`, `step`, `activitytype`, `text1`, `text2`, `text3`, `goalid`, `goalmethod`, `goalcount`, `delivertonpc`, `zoneid`, `optional`) VALUES (@task_id, 2, 3, 2, 'emaciated zombies', '', '', 224094, 0, 10, 0, 224, 0);
INSERT INTO `activities` (`taskid`, `activityid`, `step`, `activitytype`, `text1`, `text2`, `text3`, `goalid`, `goalmethod`, `goalcount`, `delivertonpc`, `zoneid`, `optional`) VALUES (@task_id, 3, 3, 3, 'zombie skin', '', '', 13074, 0, 4, 0, 224, 0);
INSERT INTO `activities` (`taskid`, `activityid`, `step`, `activitytype`, `text1`, `text2`, `text3`, `goalid`, `goalmethod`, `goalcount`, `delivertonpc`, `zoneid`, `optional`) VALUES (@task_id, 4, 4, 1, 'Dellthuea', 'zombie skin', '', 13074, 0, 4, 224106, 224, 0);
-- Underhanded Exploration
SET @task_id=@task_id+1;
INSERT INTO `tasks` (`id`, `duration`, `title`, `description`, `reward`, `rewardid`, `cashreward`, `xpreward`, `rewardmethod`, `startzone`, `minlevel`, `maxlevel`, `repeatable`) VALUES (@task_id, 0, 'Underhanded Exploration', '[1,2,Have you ever felt the power rushing through your body as you slam down a sword on a slavering mongel? Perhaps you\'ve wanted to feel the surge of excitement as a burst of magic explodes from your fingertips and eviscerates a worthless bag of bones? Now is your chance. You\'ve been entered in the Go Anywhere, Kill Anything contest being held by the Wayfarer\'s Brotherhood! To guarantee your entry into the event, your going to need to kill 10 subverted miners, and loot 4 Ornate Miner\'s Pick. A Wayfarer\'s Brotherhood representative will use these as your proof of entry. Good Luck!][3,Explore the pier in the southwest section of the crypt][4,You\'re almost halfway done with the contest and your odds of winning are quite good. All you need to do now to remain an active particapant is to kill 10 shady treasure sorters. Get out there and Kill Anything!][5,The second part of the \'Go Anywhere\' portion of the event will require you to deliver 4 Ornate Miner\'s Pick to Fellgandran. Keep up the pace, you\'re past the halfway point.][6,It\'s time to wrap up the \'Go Anywhere\' portion of the event. Why don\'t you hurry on over and explore the western cortyard door in the temple. It\'ll be your last chance to make up lost time before the contest is over, so get going!][7,You\'re in the homestretch now, just on last thing to do! You need to get moving and speak with Calambra. They\'re waiting for you!]', 'Experience and Loot', 0, 176173, 1300000, 0, 224, 44, 0, 0);
INSERT INTO `activities` (`taskid`, `activityid`, `step`, `activitytype`, `text1`, `text2`, `text3`, `goalid`, `goalmethod`, `goalcount`, `delivertonpc`, `zoneid`, `optional`) VALUES (@task_id, 0, 1, 2, 'subverted miners', '', '', 226015, 0, 10, 0, 226, 0);
INSERT INTO `activities` (`taskid`, `activityid`, `step`, `activitytype`, `text1`, `text2`, `text3`, `goalid`, `goalmethod`, `goalcount`, `delivertonpc`, `zoneid`, `optional`) VALUES (@task_id, 1, 1, 3, '', 'Ornate Miner\'s Pick', '', 16393, 0, 4, 0, 226, 0);
SET @explore_id=@explore_id+1;
INSERT INTO `activities` (`taskid`, `activityid`, `step`, `activitytype`, `text1`, `text2`, `text3`, `goalid`, `goalmethod`, `goalcount`, `delivertonpc`, `zoneid`, `optional`) VALUES (@task_id, 2, 2, 5, 'the pier in the southwest section of the crypt', '', '', @explore_id, 0, 1, 0, 227, 0);
INSERT INTO `proximities` (`zoneid`, `exploreid`, `minx`, `maxx`, `miny`, `maxy`, `minz`, `maxz`) VALUES (227, @explore_id, 1467, 1502, -1502, -1274, -132, -130);
INSERT INTO `activities` (`taskid`, `activityid`, `step`, `activitytype`, `text1`, `text2`, `text3`, `goalid`, `goalmethod`, `goalcount`, `delivertonpc`, `zoneid`, `optional`) VALUES (@task_id, 3, 3, 2, 'shady treasure sorters', '', '', 225075, 0, 10, 0, 225, 0);
INSERT INTO `activities` (`taskid`, `activityid`, `step`, `activitytype`, `text1`, `text2`, `text3`, `goalid`, `goalmethod`, `goalcount`, `delivertonpc`, `zoneid`, `optional`) VALUES (@task_id, 4, 4, 1, 'Fellgandran', 'Ornate Miner\'s Pick', '', 16393, 0, 4, 224105, 224, 0);
SET @explore_id=@explore_id+1;
INSERT INTO `activities` (`taskid`, `activityid`, `step`, `activitytype`, `text1`, `text2`, `text3`, `goalid`, `goalmethod`, `goalcount`, `delivertonpc`, `zoneid`, `optional`) VALUES (@task_id, 5, 5, 5, 'the western courtyard door in the temple', '', '', @explore_id, 0, 1, 0, 224, 0);
INSERT INTO `proximities` (`zoneid`, `exploreid`, `minx`, `maxx`, `miny`, `maxy`, `minz`, `maxz`) VALUES (224, @explore_id, 2914.3, 2944, -2805, -2705, 472, 482);
INSERT INTO `activities` (`taskid`, `activityid`, `step`, `activitytype`, `text1`, `text2`, `text3`, `goalid`, `goalmethod`, `goalcount`, `delivertonpc`, `zoneid`, `optional`) VALUES (@task_id, 6, 6, 4, 'Calambra', '', '', 224107, 0, 1, 0, 224, 0);
-- Find the Ore
SET @task_id=@task_id+1;
INSERT INTO `tasks` (`id`, `duration`, `title`, `description`, `reward`, `rewardid`, `cashreward`, `xpreward`, `rewardmethod`, `startzone`, `minlevel`, `maxlevel`, `repeatable`) VALUES (@task_id, 0, 'Find the Ore', '[1,2,Good, you\'ve finally made it. You have been chosen as part of an elite expeditionary force that is going to be heading into the unknown. Your ultimate objective is to rid the areas you visit of hostiles, for a possible increase in the number of homes, farms and livestock those areas. To get started, make your way out and kill 10 subverted miners. Make sure you loot 4 Pristine Ore Sample. and keep a hold of them, they may be needed later on. You\'ll be notified of your next objective when you\'re done.][3,Good, you found those beasts and destroyed them. They would have only have slowed you down otherwise. While you\'re out in that area, it may be worthwhile for you to explore the luggald cave entrance along the northern harbor wall. There\'s no telling what may be there, but it is a possible housing location, so get a move on!][4,Hostilies are all over the place! You\'ve got to kill 10 shrine bruisers, at once! They cannot be allowed to get past your defenses! Hurry!][5,That was almost too close. Now that you have a break in your busy schedule, why not take those samples you collected earlier and deliver 4 Pristine Ore Sample to Calambra. They\'ll be expecting your arrival.][7,You realize you\'re one of the premier expeditionary forces, correct? You\'re the one that\'s got to make the tough choice and visit the most dangerous areas, like this next one. You\'re going to explore the lighthouse on the docks, but be cautious, because there\'s no telling what kinds of monsters are lying in wait.][8,It\'s about time you finished up. Go speak with Dellhuea, to get your compensation, You look like you could use a rest after this.]', 'Experience and Loot', 0, 176173, 1300000, 0, 224, 40, 0, 0);
INSERT INTO `activities` (`taskid`, `activityid`, `step`, `activitytype`, `text1`, `text2`, `text3`, `goalid`, `goalmethod`, `goalcount`, `delivertonpc`, `zoneid`, `optional`) VALUES (@task_id, 0, 1, 2, 'Subverted Miners', '', '', 226016, 0, 10, 0, 226, 0);
INSERT INTO `activities` (`taskid`, `activityid`, `step`, `activitytype`, `text1`, `text2`, `text3`, `goalid`, `goalmethod`, `goalcount`, `delivertonpc`, `zoneid`, `optional`) VALUES (@task_id, 1, 1, 3, '', 'Pristine Ore Samples', '', 63006, 0, 4, 0, 226, 0);
SET @explore_id=@explore_id+1;
INSERT INTO `activities` (`taskid`, `activityid`, `step`, `activitytype`, `text1`, `text2`, `text3`, `goalid`, `goalmethod`, `goalcount`, `delivertonpc`, `zoneid`, `optional`) VALUES (@task_id, 2, 2, 5, 'the luggald cave entrance along the northern harbor wall.', '', '', @explore_id, 0, 1, 0, 225, 0);
INSERT INTO `proximities` (`zoneid`, `exploreid`, `minx`, `maxx`, `miny`, `maxy`, `minz`, `maxz`) VALUES (226, @explore_id, -180, -108, 595.000000, 620.000000, 1.6, 2.0);
INSERT INTO `activities` (`taskid`, `activityid`, `step`, `activitytype`, `text1`, `text2`, `text3`, `goalid`, `goalmethod`, `goalcount`, `delivertonpc`, `zoneid`, `optional`) VALUES (@task_id, 3, 3, 2, 'Shrine Bruisers', '', '', 227008, 0, 10, 0, 227, 0);
INSERT INTO `activities` (`taskid`, `activityid`, `step`, `activitytype`, `text1`, `text2`, `text3`, `goalid`, `goalmethod`, `goalcount`, `delivertonpc`, `zoneid`, `optional`) VALUES (@task_id, 4, 4, 1, 'Pristine Ore Samples', '', '', 63006, 0, 4, 224107, 224, 0);
SET @explore_id=@explore_id+1;
INSERT INTO `activities` (`taskid`, `activityid`, `step`, `activitytype`, `text1`, `text2`, `text3`, `goalid`, `goalmethod`, `goalcount`, `delivertonpc`, `zoneid`, `optional`) VALUES (@task_id, 5, 5, 5, 'the lighthouse on the docks.', '', '', @explore_id, 0, 1, 0, 224, 0);
INSERT INTO `proximities` (`zoneid`, `exploreid`, `minx`, `maxx`, `miny`, `maxy`, `minz`, `maxz`) VALUES (224, @explore_id, -330, -300, 1393, 1423, 1.6, 2.0);
-- Barrenzin (202330)
-- Plane of Knowledge (poknowledge) id 202
-- The Cabilisian Trade Route
SET @task_id=@task_id+1;
INSERT INTO `tasks` (`id`, `duration`, `title`, `description`, `reward`, `rewardid`, `cashreward`, `xpreward`, `rewardmethod`, `startzone`, `minlevel`, `maxlevel`, `repeatable`) VALUES (@task_id, 0, 'The Cabilisian Trade Route', '[1,The Iksar of Cabilis live in a ruined city on their forsaken continent of Kunark. I\'d be inclined to simply leave them there but unfortunately they have a monopoly on several rare resources. Although I\'m not welcome in their city, several of my iksar contacts are able to ferry out goods to my associates.<br><br>But now we have a new problem. The iksar bandits outside the city have begun to waylay my caravans and cut substantially into my profit margin. The Cabilis guards won\'t do anything about it because I\'m not even supposed to be there. So I need you to clear the way.<br><br>Meet Karunku Trogue, my caravan leader in the Field of Bone. She should have more information for you on the bandits\' location.]', 'Loot and Experience', 59943, 176173, -1515, 0, 202, 10, 15, 1);
INSERT INTO `activities` (`taskid`, `activityid`, `step`, `activitytype`, `text1`, `text2`, `text3`, `goalid`, `goalmethod`, `goalcount`, `delivertonpc`, `zoneid`, `optional`) VALUES (@task_id, 0, 1, 4, 'Karunku Trogue', '', '', 78194, 0, 1, 0, 78, 0);
SET @explore_id=@explore_id+1;
INSERT INTO `activities` (`taskid`, `activityid`, `step`, `activitytype`, `text1`, `text2`, `text3`, `goalid`, `goalmethod`, `goalcount`, `delivertonpc`, `zoneid`, `optional`) VALUES (@task_id, 1, 2, 5, 'Camp of the Bandit Lookouts', '', '', @explore_id, 0, 1, 0, 79, 0);
INSERT INTO `proximities` (`zoneid`, `exploreid`, `minx`, `maxx`, `miny`, `maxy`, `minz`, `maxz`) VALUES (79, @explore_id, -2933, -2833, 2744, 2844, -10, 10);
INSERT INTO `activities` (`taskid`, `activityid`, `step`, `activitytype`, `text1`, `text2`, `text3`, `goalid`, `goalmethod`, `goalcount`, `delivertonpc`, `zoneid`, `optional`) VALUES (@task_id, 2, 2, 2, 'Iksar Lookouts', '', '', 1000002, 0, 3, 0, 79, 0);
SET @explore_id=@explore_id+1;
INSERT INTO `activities` (`taskid`, `activityid`, `step`, `activitytype`, `text1`, `text2`, `text3`, `goalid`, `goalmethod`, `goalcount`, `delivertonpc`, `zoneid`, `optional`) VALUES (@task_id, 3, 3, 5, 'Main Bandit Camp', '', '', @explore_id, 0, 1, 0, 79, 0);
INSERT INTO `proximities` (`zoneid`, `exploreid`, `minx`, `maxx`, `miny`, `maxy`, `minz`, `maxz`) VALUES (79, @explore_id, -2624, -2524, 3826, 3866, -30, -15);
INSERT INTO `activities` (`taskid`, `activityid`, `step`, `activitytype`, `text1`, `text2`, `text3`, `goalid`, `goalmethod`, `goalcount`, `delivertonpc`, `zoneid`, `optional`) VALUES (@task_id, 4, 3, 2, 'Iksar Bandits', '', '', 79108, 0, 5, 0, 79, 0);
INSERT INTO `activities` (`taskid`, `activityid`, `step`, `activitytype`, `text1`, `text2`, `text3`, `goalid`, `goalmethod`, `goalcount`, `delivertonpc`, `zoneid`, `optional`) VALUES (@task_id, 5, 4, 2, 'Silliv`Host', '', '', 79153, 0, 1, 0, 79, 0);
INSERT INTO `activities` (`taskid`, `activityid`, `step`, `activitytype`, `text1`, `text2`, `text3`, `goalid`, `goalmethod`, `goalcount`, `delivertonpc`, `zoneid`, `optional`) VALUES (@task_id, 6, 5, 1, 'Barrenzin', 'Silliv`Host Head', '', 36083, 0, 1, 202330, 202, 0);
-- Guard_Gregor (12116)
-- Western Plains of Karana (qey2hh1) id 12
-- Protect the Fishermen (Task #509)
SET @task_id=@task_id+1;
INSERT INTO `tasks` (`id`, `duration`, `title`, `description`, `reward`, `rewardid`, `cashreward`, `xpreward`, `rewardmethod`, `startzone`, `minlevel`, `maxlevel`, `repeatable`) VALUES (@task_id, 0, 'Protect the Fishermen', '[1,Very quickly, you need to speak with Brettaru Tyco, to let them know you\'re the Red Beetle. Your contact will know what it means.][2,Your contact was impressed that you kept your wits about you and didn\'t give away your cover. Now, as to why you\'re here. Your code name is Red Beetle and you\'ve been assigned to explore the fishing settlement near the southern waterfall. This is a very dangerous place where reports suggest there is a rebellion forming. You must go there and determine whether or not this is true.][3,It looks like the insurgents are forming quickly, Red Beetle. It\'s up to you to take the raven to the raven\'s nest and kill 10 gorge hounds, Only after that will you be able to retire from this life of subterfuge. Good Luck]', 'Loot and Experience', 0, 176173, -1520, 4290, 12, 15, 30, 0);
INSERT INTO `activities` (`taskid`, `activityid`, `step`, `activitytype`, `text1`, `text2`, `text3`, `goalid`, `goalmethod`, `goalcount`, `delivertonpc`, `zoneid`, `optional`) VALUES (@task_id, 0, 1, 4, 'Brettaru Tyco', '', '', 15191, 0, 1, 0, 15, 0);
SET @explore_id=@explore_id+1;
INSERT INTO `activities` (`taskid`, `activityid`, `step`, `activitytype`, `text1`, `text2`, `text3`, `goalid`, `goalmethod`, `goalcount`, `delivertonpc`, `zoneid`, `optional`) VALUES (@task_id, 1, 2, 5, 'the fishing settlement near the southern waterfall', '', '', @explore_id, 0, 1, 0, 15, 0);
INSERT INTO `proximities` (`zoneid`, `exploreid`, `minx`, `maxx`, `miny`, `maxy`, `minz`, `maxz`) VALUES (15, @explore_id, -2362, -2303, -3854, -3728, -42, -32);
INSERT INTO `activities` (`taskid`, `activityid`, `step`, `activitytype`, `text1`, `text2`, `text3`, `goalid`, `goalmethod`, `goalcount`, `delivertonpc`, `zoneid`, `optional`) VALUES (@task_id, 2, 3, 2, 'Gorge Hounds', '', '', 15030, 0, 10, 0, 15, 0);
INSERT INTO `activities` (`taskid`, `activityid`, `step`, `activitytype`, `text1`, `text2`, `text3`, `goalid`, `goalmethod`, `goalcount`, `delivertonpc`, `zoneid`, `optional`) VALUES (@task_id, 3, 4, 4, 'Brettaru Tyco', '', '', 15191, 0, 1, 0, 15, 0);
-- Guard_Gregor (12116)
-- Western Plains of Karana (qey2hh1) id 12
-- Danger to the North (Task #510)
SET @task_id=@task_id+1;
INSERT INTO `tasks` (`id`, `duration`, `title`, `description`, `reward`, `rewardid`, `cashreward`, `xpreward`, `rewardmethod`, `startzone`, `minlevel`, `maxlevel`, `repeatable`) VALUES (@task_id, 0, 'Danger to the North', '[1,The world is growing at an alarming rate and there aren\'t enough plots of land available for everyone and their livestock to live in. That\'s why it\'s up to you to find some new plots of land. Your first target is going to be nearby, which is why you need to explore the human village south of the gorge. You\'ll know once you arrive if it\'s a good piece of property or not.][2,That wasn\'t the most hospitable place in the world, especially not for a family, but there are plenty of other locations you can visit. This time, why don\'t you explore the ancient statue in the center of the gorge? You\'re bound to get lucky sooner or later and find a suitable living spot.][3,Talk to Pox Soth]', 'Loot and Experience', 0, 542, -2612, 0, 12, 20, 85, 1);
SET @explore_id=@explore_id+1;
INSERT INTO `activities` (`taskid`, `activityid`, `step`, `activitytype`, `text1`, `text2`, `text3`, `goalid`, `goalmethod`, `goalcount`, `delivertonpc`, `zoneid`, `optional`) VALUES (@task_id, 0, 1, 5, 'the human village', '', '', @explore_id, 0, 1, 0, 15, 0);
INSERT INTO `proximities` (`zoneid`, `exploreid`, `minx`, `maxx`, `miny`, `maxy`, `minz`, `maxz`) VALUES (15, @explore_id, -2665, -2589, 1322, 1451, -.1, 3);
SET @explore_id=@explore_id+1;
INSERT INTO `activities` (`taskid`, `activityid`, `step`, `activitytype`, `text1`, `text2`, `text3`, `goalid`, `goalmethod`, `goalcount`, `delivertonpc`, `zoneid`, `optional`) VALUES (@task_id, 1, 2, 5, 'ancient statue', '', '', @explore_id, 0, 1, 0, 16, 0);
INSERT INTO `proximities` (`zoneid`, `exploreid`, `minx`, `maxx`, `miny`, `maxy`, `minz`, `maxz`) VALUES (16, @explore_id, -665, -615, 405, 446, -100, -97);
INSERT INTO `activities` (`taskid`, `activityid`, `step`, `activitytype`, `text1`, `text2`, `text3`, `goalid`, `goalmethod`, `goalcount`, `delivertonpc`, `zoneid`, `optional`) VALUES (@task_id, 2, 3, 4, 'Pox Soth', '', '', 1000007, 0, 1, 0, 16, 0);
SET @task_id=500;
SET @explore_id=500;
SET @id_range=50;
DELETE FROM `tasks` WHERE `id`>=@task_id AND `id`<=@task_id+@id_range;
DELETE FROM `activities` WHERE `taskid`>=@task_id and `taskid`<=@task_id+@id_range;
DELETE FROM `proximities` WHERE `exploreid`>=@explore_id and `exploreid`<=@explore_id+@id_range;
-- Cadale Brohat (224219)
-- Pray for Life
INSERT INTO `tasks` (`id`, `duration`, `title`, `description`, `reward`, `rewardid`, `cashreward`, `xpreward`, `rewardmethod`, `startzone`, `minlevel`, `maxlevel`, `repeatable`) VALUES (@task_id, 0, 'Pray for Life', '[1,What a glorious day to go on patrol! That\'s exactly what you\'ll be doing for the next little while, soldier. You\'re going to start by taking\r\n the time to explore the small prayer pedestal to the left of the entrance. Don\'t do anything fancy, just keep your eyes peeled for any signs of hostile actions in the area.\r\n If you find anything, then you\'ll know what to do. Good luck!][2,Whoa! Hold up a minute! Did you hear the commotion? There\'s been a report of an enemy \r\n unit nearby! Go find them and kill 10 shady treasure sorters, Make sure you get rid of them all, even if it\'s just for the thrill of the hunt. Speaking of which,\r\n go ahead and loot 4 Shiv, while you\'re at it, just so you have something to remember the adventure. You can put them on your wall at home later on.][3,Time to get back to your patrol duties, so explore the Hungry Shark tavern along the southern docks, when you\'re done, you can head back.][4, Aside from that little skirmish you had, your patrol wasn\'t too taxing. That\'s more than can be said for some of the others that were sent on patrol today. In any case, you do have those prizes you collected, so why not deliver 4 Shiv to Welligorn, so they can be stuffed and put on display for you.]', 'Experience and Loot', 0, 94301, 4000000, 0, 224, 32, 0, 0);
INSERT INTO `activities` (`taskid`, `activityid`, `step`, `activitytype`, `text1`, `text2`, `text3`, `goalid`, `goalmethod`, `goalcount`, `delivertonpc`, `zoneid`, `optional`) VALUES (@task_id, 4, 3, 1, 'Welligorn', 'Shivs', '', 52027, 0, 4, 224104, 224, 0);
INSERT INTO `activities` (`taskid`, `activityid`, `step`, `activitytype`, `text1`, `text2`, `text3`, `goalid`, `goalmethod`, `goalcount`, `delivertonpc`, `zoneid`, `optional`) VALUES (@task_id, 0, 0, 5, 'the small prayer pedestal.', '', '', @explore_id, 0, 1, 0, 224, 0);
INSERT INTO `proximities` (`zoneid`, `exploreid`, `minx`, `maxx`, `miny`, `maxy`, `minz`, `maxz`) VALUES (224, @explore_id, 2487.000000, 2549.000000, -2915.000000, -2862.000000, 460.000000, 490.000000);
INSERT INTO `activities` (`taskid`, `activityid`, `step`, `activitytype`, `text1`, `text2`, `text3`, `goalid`, `goalmethod`, `goalcount`, `delivertonpc`, `zoneid`, `optional`) VALUES (@task_id, 1, 1, 2, 'A Shady Treasure Sorter', '', '', 225075, 0, 10, 0, 225, 0);
INSERT INTO `activities` (`taskid`, `activityid`, `step`, `activitytype`, `text1`, `text2`, `text3`, `goalid`, `goalmethod`, `goalcount`, `delivertonpc`, `zoneid`, `optional`) VALUES (@task_id, 2, 1, 3, 'Shivs', '', '', 52027, 0, 4, 0, 225, 0);
SET @explore_id=@explore_id+1;
INSERT INTO `activities` (`taskid`, `activityid`, `step`, `activitytype`, `text1`, `text2`, `text3`, `goalid`, `goalmethod`, `goalcount`, `delivertonpc`, `zoneid`, `optional`) VALUES (@task_id, 3, 2, 5, 'Hungry Shark tavern', '', '', @explore_id, 0, 1, 0, 225, 0);
INSERT INTO `proximities` (`zoneid`, `exploreid`, `minx`, `maxx`, `miny`, `maxy`, `minz`, `maxz`) VALUES (225, @explore_id, -581.000000, -561.000000, -612.000000, -592.000000, 0.000000, 20.000000);
-- Time for Bed
SET @task_id=@task_id+1;
INSERT INTO `tasks` (`id`, `duration`, `title`, `description`, `reward`, `rewardid`, `cashreward`, `xpreward`, `rewardmethod`, `startzone`, `minlevel`, `maxlevel`, `repeatable`) VALUES (@task_id, 0, 'Time for Bed', '[1,The world is growing at an alarming rate and there aren\'t enough plots of land available for everyone and their livestock to live in. That\'s why it\'s up to you to find some new plots of land. Your first target is going to be nearby, which is why you need to explore the sleeping quarters in the southern mines. You\'ll know once you arrive if it\'s a good place of property or not.][2,That wasn\'t the most hospitable place in the world, especially not for a family, but there are plenty of other locations you can visit. This time, why don\'t you explore the ship Oceancrasher at one of the eastern docks,? You\'re bound to get lucky sooner or later and find a suitable living spot.][3,It\'s interesting that there wasn\'t a good area anywhere. You\'re going to have to let the prospective buyers know about it, so speak with Dellthuea, to give them the bad news.]', 'Experience and Loot', 0, 94301, 1300000, 0, 224, 40, 0, 0);
SET @explore_id=@explore_id+1;
INSERT INTO `activities` (`taskid`, `activityid`, `step`, `activitytype`, `text1`, `text2`, `text3`, `goalid`, `goalmethod`, `goalcount`, `delivertonpc`, `zoneid`, `optional`) VALUES (@task_id, 0, 1, 5, 'the sleeping quarters in the southern mines', '', '', @explore_id, 0, 1, 0, 226, 0);
INSERT INTO `proximities` (`zoneid`, `exploreid`, `minx`, `maxx`, `miny`, `maxy`, `minz`, `maxz`) VALUES (226, @explore_id, 10.000000, 30.000000, -120.000000, -100.000000, 0.000000, 2.000000);
INSERT INTO `activities` (`taskid`, `activityid`, `step`, `activitytype`, `text1`, `text2`, `text3`, `goalid`, `goalmethod`, `goalcount`, `delivertonpc`, `zoneid`, `optional`) VALUES (@task_id, 2, 3, 4, 'Dellthuea', '', '', 224106, 0, 1, 0, 224, 0);
SET @explore_id=@explore_id+1;
INSERT INTO `activities` (`taskid`, `activityid`, `step`, `activitytype`, `text1`, `text2`, `text3`, `goalid`, `goalmethod`, `goalcount`, `delivertonpc`, `zoneid`, `optional`) VALUES (@task_id, 1, 2, 5, 'the ship Oceancrasher', '', '', @explore_id, 0, 1, 0, 225, 0);
INSERT INTO `proximities` (`zoneid`, `exploreid`, `minx`, `maxx`, `miny`, `maxy`, `minz`, `maxz`) VALUES (225, @explore_id, -1809.000000, -1770.000000, 214.000000, 263.000000, -40.000000, -20.000000);
-- Ahoy, Ye Bony Mate (Gunthak highest)
SET @task_id=@task_id+1;
INSERT INTO `tasks` (`id`, `duration`, `title`, `description`, `reward`, `rewardid`, `cashreward`, `xpreward`, `rewardmethod`, `startzone`, `minlevel`, `maxlevel`, `repeatable`) VALUES (@task_id, 0, 'Ahoy, Ye Bony Mate', '[1,Ready to go on a hunt? The local landowners are putting together a hunting contest and you\'ve been invited. Though it\'s a group event, you are to go off on your own and kill 10 deadly skeletal sailors. Before they\'ll accept that you actually did the deed yourself, they\'re going to want proof, so make sure you loot 4 Bone Chips, before you return.][2,The hunting went superbly well, it seems, and you\'re on your way to winning. All you need to do now is to deliver 4 Bone Chips to Calambra, so you\'re not disqualified for not fulfilling all the requirements.]', 'Experience and Loot', 0, 94301, 500000, 0, 224, 30, 0, 0);
INSERT INTO `activities` (`taskid`, `activityid`, `step`, `activitytype`, `text1`, `text2`, `text3`, `goalid`, `goalmethod`, `goalcount`, `delivertonpc`, `zoneid`, `optional`) VALUES (@task_id, 0, 1, 2, 'deadly skeletal sailors', '', '', 224213, 0, 10, 0, 224, 0);
INSERT INTO `activities` (`taskid`, `activityid`, `step`, `activitytype`, `text1`, `text2`, `text3`, `goalid`, `goalmethod`, `goalcount`, `delivertonpc`, `zoneid`, `optional`) VALUES (@task_id, 1, 2, 3, '', '', 'Loot 4 bone chips', 13073, 0, 4, 0, 224, 0);
INSERT INTO `activities` (`taskid`, `activityid`, `step`, `activitytype`, `text1`, `text2`, `text3`, `goalid`, `goalmethod`, `goalcount`, `delivertonpc`, `zoneid`, `optional`) VALUES (@task_id, 2, 3, 1, 'Calambra', 'Bone Chips', '', 13073, 0, 4, 224107, 224, 0);
-- Brains over Brawn (Gunthak highest)
SET @task_id=@task_id+1;
INSERT INTO `tasks` (`id`, `duration`, `title`, `description`, `reward`, `rewardid`, `cashreward`, `xpreward`, `rewardmethod`, `startzone`, `minlevel`, `maxlevel`, `repeatable`) VALUES (@task_id, 0, 'Brains Over Brawn', '[1,2,Bounty hunter extraordinaire. How does that sound? It\'s time to test your skills and to do so you\'re going to need to kill 10 pestilent troll zombies, and quickly. You only receive the bounty if you make sure to loot 4 Zombie Skin, though, so don\’t forget. You\'re going to have to prove yourself if you want everyone to start calling you extraordinary.][3,Did you stop to breathe at all? Your prowess in the field of hunting far exceeded everyone\'s expectations. To receive your bounty, just deliver 4 Zombie Skin to Dellthuea.][4,You really are on the path to becoming extraordinary. Everyone believed the title you donned was fictional, but you really are almost worthy to hold the title. Here\'s your bounty, and who knows? If you keep up the good work, there may be more bounties for you to collect in the near future.]', 'Experience and Loot', 0, 78301, 500000, 0, 224, 30, 0, 0);
INSERT INTO `activities` (`taskid`, `activityid`, `step`, `activitytype`, `text1`, `text2`, `text3`, `goalid`, `goalmethod`, `goalcount`, `delivertonpc`, `zoneid`, `optional`) VALUES (@task_id, 0, 1, 2, 'Emaciated Zombie', '', '', 224094, 0, 10, 0, 224, 0);
INSERT INTO `activities` (`taskid`, `activityid`, `step`, `activitytype`, `text1`, `text2`, `text3`, `goalid`, `goalmethod`, `goalcount`, `delivertonpc`, `zoneid`, `optional`) VALUES (@task_id, 1, 1, 3, '', '', 'Loot 4 Zombie Skin', 13074, 0, 4, 0, 224, 0);
INSERT INTO `activities` (`taskid`, `activityid`, `step`, `activitytype`, `text1`, `text2`, `text3`, `goalid`, `goalmethod`, `goalcount`, `delivertonpc`, `zoneid`, `optional`) VALUES (@task_id, 2, 3, 1, 'Dellthuea', 'Zombie Skin', '', 13074, 0, 4, 224106, 0, 0);
-- Don`t Be Scared
SET @task_id=@task_id+1;
INSERT INTO `tasks` (`id`, `duration`, `title`, `description`, `reward`, `rewardid`, `cashreward`, `xpreward`, `rewardmethod`, `startzone`, `minlevel`, `maxlevel`, `repeatable`) VALUES (@task_id, 0, 'Don\'t Be Scared', '[1,Speak with Calambra][2,With what you\'ve just learned, you\'re more than ready to get out there and rid the lands of pests! Go and kill 10 vicious skeletons, and when you\'re done, you\'ll no doubt have a new respect for the tricks of the trade.][3,4,Now that you\'ve had some practice, you\'re ready to step things up a notch. This time, go kill 10 emaciated zombies, and while you\'re there, loot 4 Zombie Skin. That way, you\'ll get a first-hand glimpse of what it is those pests can carry with them.][5,You did a terrific job, better than any exterminator before you. Since you have some extra items on you that aren’t worth a whole lot, you can probably just deliver 4 Zombie Skin to Dellthuea, and be done with them. You\'ve learned all there is about exterminating, for now.]', 'Experience and Loot', 0, 54123, 666000, 0, 224, 30, 0, 0);
INSERT INTO `activities` (`taskid`, `activityid`, `step`, `activitytype`, `text1`, `text2`, `text3`, `goalid`, `goalmethod`, `goalcount`, `delivertonpc`, `zoneid`, `optional`) VALUES (@task_id, 4, 4, 1, 'Dellthuea', 'zombie skin', '', 13074, 0, 4, 224106, 224, 0);
INSERT INTO `activities` (`taskid`, `activityid`, `step`, `activitytype`, `text1`, `text2`, `text3`, `goalid`, `goalmethod`, `goalcount`, `delivertonpc`, `zoneid`, `optional`) VALUES (@task_id, 3, 3, 3, 'zombie skin', '', '', 13074, 0, 4, 0, 224, 0);
INSERT INTO `activities` (`taskid`, `activityid`, `step`, `activitytype`, `text1`, `text2`, `text3`, `goalid`, `goalmethod`, `goalcount`, `delivertonpc`, `zoneid`, `optional`) VALUES (@task_id, 2, 3, 2, 'emaciated zombies', '', '', 224094, 0, 10, 0, 224, 0);
INSERT INTO `activities` (`taskid`, `activityid`, `step`, `activitytype`, `text1`, `text2`, `text3`, `goalid`, `goalmethod`, `goalcount`, `delivertonpc`, `zoneid`, `optional`) VALUES (@task_id, 1, 2, 2, 'vicious skeletons', '', '', 224015, 0, 10, 0, 224, 0);
INSERT INTO `activities` (`taskid`, `activityid`, `step`, `activitytype`, `text1`, `text2`, `text3`, `goalid`, `goalmethod`, `goalcount`, `delivertonpc`, `zoneid`, `optional`) VALUES (@task_id, 0, 1, 4, 'Calambra', '', '', 224107, 0, 1, 0, 224, 0);
-- Gathering Skin
SET @task_id=@task_id+1;
INSERT INTO `tasks` (`id`, `duration`, `title`, `description`, `reward`, `rewardid`, `cashreward`, `xpreward`, `rewardmethod`, `startzone`, `minlevel`, `maxlevel`, `repeatable`) VALUES (@task_id, 0, 'Gathering Skin', '[1,Long ago, a wise man once said that the power of the mind can destroy even the tallest giant. Whether or not that\'s true, you\'re going to visit a pupil of that wise man to learn more about the ways of the world. Make haste to speak with Calambra. When you arrive, you will find that there is more to life than the absent pursuit of wealth.][2,The old wise man\'s words carried his students through the roughest wars and the coldest winters. It taught them a sense of discipline and restraint they had never known existed. But his teachings also pushed them to fight back when the forces of power tried to annihilate the weak. Now it\'s your turn to take the fight to those forces once again. Use the teachings of the old man\'s pupil and kill 10 vicious skeletons.][3,4,What was once thought to be the end of conflicts merely brought more to the table. As it was before, you must continue to defeat the threat of tyranny and kill 10 emaciated zombies. They must not be allowed to take control over these lands and it is up to you to stop them. They\'re protecting their wealth, so take it from them by loot 4 Zombie Skin. Time is of the essence young student.][5,You have reached a peak in your learning. At the very least, you have learned what it is to be a learned student. You have come a long way in a short time and there is indeed a future for you if you continue along the path of enlightenment. For now, deliver 4 Zombie Skin to Dellthuea, for they are behind some of the tyranny that brews in the world. You now have the power to end it.]\r\n', 'Experience and Loot', 0, 54123, 666000, 0, 224, 30, 0, 0);
INSERT INTO `activities` (`taskid`, `activityid`, `step`, `activitytype`, `text1`, `text2`, `text3`, `goalid`, `goalmethod`, `goalcount`, `delivertonpc`, `zoneid`, `optional`) VALUES (@task_id, 0, 1, 4, 'Calambra', '', '', 224107, 0, 1, 0, 224, 0);
INSERT INTO `activities` (`taskid`, `activityid`, `step`, `activitytype`, `text1`, `text2`, `text3`, `goalid`, `goalmethod`, `goalcount`, `delivertonpc`, `zoneid`, `optional`) VALUES (@task_id, 1, 2, 2, 'vicious skeletons', '', '', 224015, 0, 10, 0, 224, 0);
INSERT INTO `activities` (`taskid`, `activityid`, `step`, `activitytype`, `text1`, `text2`, `text3`, `goalid`, `goalmethod`, `goalcount`, `delivertonpc`, `zoneid`, `optional`) VALUES (@task_id, 2, 3, 2, 'emaciated zombies', '', '', 224094, 0, 10, 0, 224, 0);
INSERT INTO `activities` (`taskid`, `activityid`, `step`, `activitytype`, `text1`, `text2`, `text3`, `goalid`, `goalmethod`, `goalcount`, `delivertonpc`, `zoneid`, `optional`) VALUES (@task_id, 3, 3, 3, 'zombie skin', '', '', 13074, 0, 4, 0, 224, 0);
INSERT INTO `activities` (`taskid`, `activityid`, `step`, `activitytype`, `text1`, `text2`, `text3`, `goalid`, `goalmethod`, `goalcount`, `delivertonpc`, `zoneid`, `optional`) VALUES (@task_id, 4, 4, 1, 'Dellthuea', 'zombie skin', '', 13074, 0, 4, 224106, 224, 0);
-- Underhanded Exploration
SET @task_id=@task_id+1;
INSERT INTO `tasks` (`id`, `duration`, `title`, `description`, `reward`, `rewardid`, `cashreward`, `xpreward`, `rewardmethod`, `startzone`, `minlevel`, `maxlevel`, `repeatable`) VALUES (@task_id, 0, 'Underhanded Exploration', '[1,2,Have you ever felt the power rushing through your body as you slam down a sword on a slavering mongel? Perhaps you\'ve wanted to feel the surge of excitement as a burst of magic explodes from your fingertips and eviscerates a worthless bag of bones? Now is your chance. You\'ve been entered in the Go Anywhere, Kill Anything contest being held by the Wayfarer\'s Brotherhood! To guarantee your entry into the event, your going to need to kill 10 subverted miners, and loot 4 Ornate Miner\'s Pick. A Wayfarer\'s Brotherhood representative will use these as your proof of entry. Good Luck!][3,Explore the pier in the southwest section of the crypt][4,You\'re almost halfway done with the contest and your odds of winning are quite good. All you need to do now to remain an active particapant is to kill 10 shady treasure sorters. Get out there and Kill Anything!][5,The second part of the \'Go Anywhere\' portion of the event will require you to deliver 4 Ornate Miner\'s Pick to Fellgandran. Keep up the pace, you\'re past the halfway point.][6,It\'s time to wrap up the \'Go Anywhere\' portion of the event. Why don\'t you hurry on over and explore the western cortyard door in the temple. It\'ll be your last chance to make up lost time before the contest is over, so get going!][7,You\'re in the homestretch now, just on last thing to do! You need to get moving and speak with Calambra. They\'re waiting for you!]', 'Experience and Loot', 0, 176173, 1300000, 0, 224, 44, 0, 0);
INSERT INTO `activities` (`taskid`, `activityid`, `step`, `activitytype`, `text1`, `text2`, `text3`, `goalid`, `goalmethod`, `goalcount`, `delivertonpc`, `zoneid`, `optional`) VALUES (@task_id, 0, 1, 2, 'subverted miners', '', '', 226015, 0, 10, 0, 226, 0);
INSERT INTO `activities` (`taskid`, `activityid`, `step`, `activitytype`, `text1`, `text2`, `text3`, `goalid`, `goalmethod`, `goalcount`, `delivertonpc`, `zoneid`, `optional`) VALUES (@task_id, 1, 1, 3, '', 'Ornate Miner\'s Pick', '', 16393, 0, 4, 0, 226, 0);
SET @explore_id=@explore_id+1;
INSERT INTO `activities` (`taskid`, `activityid`, `step`, `activitytype`, `text1`, `text2`, `text3`, `goalid`, `goalmethod`, `goalcount`, `delivertonpc`, `zoneid`, `optional`) VALUES (@task_id, 2, 2, 5, 'the pier in the southwest section of the crypt', '', '', @explore_id, 0, 1, 0, 227, 0);
INSERT INTO `proximities` (`zoneid`, `exploreid`, `minx`, `maxx`, `miny`, `maxy`, `minz`, `maxz`) VALUES (227, @explore_id, 1467, 1502, -1502, -1274, -132, -130);
INSERT INTO `activities` (`taskid`, `activityid`, `step`, `activitytype`, `text1`, `text2`, `text3`, `goalid`, `goalmethod`, `goalcount`, `delivertonpc`, `zoneid`, `optional`) VALUES (@task_id, 3, 3, 2, 'shady treasure sorters', '', '', 225075, 0, 10, 0, 225, 0);
INSERT INTO `activities` (`taskid`, `activityid`, `step`, `activitytype`, `text1`, `text2`, `text3`, `goalid`, `goalmethod`, `goalcount`, `delivertonpc`, `zoneid`, `optional`) VALUES (@task_id, 4, 4, 1, 'Fellgandran', 'Ornate Miner\'s Pick', '', 16393, 0, 4, 224105, 224, 0);
SET @explore_id=@explore_id+1;
INSERT INTO `activities` (`taskid`, `activityid`, `step`, `activitytype`, `text1`, `text2`, `text3`, `goalid`, `goalmethod`, `goalcount`, `delivertonpc`, `zoneid`, `optional`) VALUES (@task_id, 5, 5, 5, 'the western courtyard door in the temple', '', '', @explore_id, 0, 1, 0, 224, 0);
INSERT INTO `proximities` (`zoneid`, `exploreid`, `minx`, `maxx`, `miny`, `maxy`, `minz`, `maxz`) VALUES (224, @explore_id, 2914.3, 2944, -2805, -2705, 472, 482);
INSERT INTO `activities` (`taskid`, `activityid`, `step`, `activitytype`, `text1`, `text2`, `text3`, `goalid`, `goalmethod`, `goalcount`, `delivertonpc`, `zoneid`, `optional`) VALUES (@task_id, 6, 6, 4, 'Calambra', '', '', 224107, 0, 1, 0, 224, 0);
-- Find the Ore
SET @task_id=@task_id+1;
INSERT INTO `tasks` (`id`, `duration`, `title`, `description`, `reward`, `rewardid`, `cashreward`, `xpreward`, `rewardmethod`, `startzone`, `minlevel`, `maxlevel`, `repeatable`) VALUES (@task_id, 0, 'Find the Ore', '[1,2,Good, you\'ve finally made it. You have been chosen as part of an elite expeditionary force that is going to be heading into the unknown. Your ultimate objective is to rid the areas you visit of hostiles, for a possible increase in the number of homes, farms and livestock those areas. To get started, make your way out and kill 10 subverted miners. Make sure you loot 4 Pristine Ore Sample. and keep a hold of them, they may be needed later on. You\'ll be notified of your next objective when you\'re done.][3,Good, you found those beasts and destroyed them. They would have only have slowed you down otherwise. While you\'re out in that area, it may be worthwhile for you to explore the luggald cave entrance along the northern harbor wall. There\'s no telling what may be there, but it is a possible housing location, so get a move on!][4,Hostilies are all over the place! You\'ve got to kill 10 shrine bruisers, at once! They cannot be allowed to get past your defenses! Hurry!][5,That was almost too close. Now that you have a break in your busy schedule, why not take those samples you collected earlier and deliver 4 Pristine Ore Sample to Calambra. They\'ll be expecting your arrival.][7,You realize you\'re one of the premier expeditionary forces, correct? You\'re the one that\'s got to make the tough choice and visit the most dangerous areas, like this next one. You\'re going to explore the lighthouse on the docks, but be cautious, because there\'s no telling what kinds of monsters are lying in wait.][8,It\'s about time you finished up. Go speak with Dellhuea, to get your compensation, You look like you could use a rest after this.]', 'Experience and Loot', 0, 176173, 1300000, 0, 224, 40, 0, 0);
INSERT INTO `activities` (`taskid`, `activityid`, `step`, `activitytype`, `text1`, `text2`, `text3`, `goalid`, `goalmethod`, `goalcount`, `delivertonpc`, `zoneid`, `optional`) VALUES (@task_id, 0, 1, 2, 'Subverted Miners', '', '', 226016, 0, 10, 0, 226, 0);
INSERT INTO `activities` (`taskid`, `activityid`, `step`, `activitytype`, `text1`, `text2`, `text3`, `goalid`, `goalmethod`, `goalcount`, `delivertonpc`, `zoneid`, `optional`) VALUES (@task_id, 1, 1, 3, '', 'Pristine Ore Samples', '', 63006, 0, 4, 0, 226, 0);
SET @explore_id=@explore_id+1;
INSERT INTO `activities` (`taskid`, `activityid`, `step`, `activitytype`, `text1`, `text2`, `text3`, `goalid`, `goalmethod`, `goalcount`, `delivertonpc`, `zoneid`, `optional`) VALUES (@task_id, 2, 2, 5, 'the luggald cave entrance along the northern harbor wall.', '', '', @explore_id, 0, 1, 0, 225, 0);
INSERT INTO `proximities` (`zoneid`, `exploreid`, `minx`, `maxx`, `miny`, `maxy`, `minz`, `maxz`) VALUES (226, @explore_id, -180, -108, 595.000000, 620.000000, 1.6, 2.0);
INSERT INTO `activities` (`taskid`, `activityid`, `step`, `activitytype`, `text1`, `text2`, `text3`, `goalid`, `goalmethod`, `goalcount`, `delivertonpc`, `zoneid`, `optional`) VALUES (@task_id, 3, 3, 2, 'Shrine Bruisers', '', '', 227008, 0, 10, 0, 227, 0);
INSERT INTO `activities` (`taskid`, `activityid`, `step`, `activitytype`, `text1`, `text2`, `text3`, `goalid`, `goalmethod`, `goalcount`, `delivertonpc`, `zoneid`, `optional`) VALUES (@task_id, 4, 4, 1, 'Pristine Ore Samples', '', '', 63006, 0, 4, 224107, 224, 0);
SET @explore_id=@explore_id+1;
INSERT INTO `activities` (`taskid`, `activityid`, `step`, `activitytype`, `text1`, `text2`, `text3`, `goalid`, `goalmethod`, `goalcount`, `delivertonpc`, `zoneid`, `optional`) VALUES (@task_id, 5, 5, 5, 'the lighthouse on the docks.', '', '', @explore_id, 0, 1, 0, 224, 0);
INSERT INTO `proximities` (`zoneid`, `exploreid`, `minx`, `maxx`, `miny`, `maxy`, `minz`, `maxz`) VALUES (224, @explore_id, -330, -300, 1393, 1423, 1.6, 2.0);
-- Barrenzin (202330)
-- Plane of Knowledge (poknowledge) id 202
-- The Cabilisian Trade Route
SET @task_id=@task_id+1;
INSERT INTO `tasks` (`id`, `duration`, `title`, `description`, `reward`, `rewardid`, `cashreward`, `xpreward`, `rewardmethod`, `startzone`, `minlevel`, `maxlevel`, `repeatable`) VALUES (@task_id, 0, 'The Cabilisian Trade Route', '[1,The Iksar of Cabilis live in a ruined city on their forsaken continent of Kunark. I\'d be inclined to simply leave them there but unfortunately they have a monopoly on several rare resources. Although I\'m not welcome in their city, several of my iksar contacts are able to ferry out goods to my associates.<br><br>But now we have a new problem. The iksar bandits outside the city have begun to waylay my caravans and cut substantially into my profit margin. The Cabilis guards won\'t do anything about it because I\'m not even supposed to be there. So I need you to clear the way.<br><br>Meet Karunku Trogue, my caravan leader in the Field of Bone. She should have more information for you on the bandits\' location.]', 'Loot and Experience', 59943, 176173, -1515, 0, 202, 10, 15, 1);
INSERT INTO `activities` (`taskid`, `activityid`, `step`, `activitytype`, `text1`, `text2`, `text3`, `goalid`, `goalmethod`, `goalcount`, `delivertonpc`, `zoneid`, `optional`) VALUES (@task_id, 0, 1, 4, 'Karunku Trogue', '', '', 78194, 0, 1, 0, 78, 0);
SET @explore_id=@explore_id+1;
INSERT INTO `activities` (`taskid`, `activityid`, `step`, `activitytype`, `text1`, `text2`, `text3`, `goalid`, `goalmethod`, `goalcount`, `delivertonpc`, `zoneid`, `optional`) VALUES (@task_id, 1, 2, 5, 'Camp of the Bandit Lookouts', '', '', @explore_id, 0, 1, 0, 79, 0);
INSERT INTO `proximities` (`zoneid`, `exploreid`, `minx`, `maxx`, `miny`, `maxy`, `minz`, `maxz`) VALUES (79, @explore_id, -2933, -2833, 2744, 2844, -10, 10);
INSERT INTO `activities` (`taskid`, `activityid`, `step`, `activitytype`, `text1`, `text2`, `text3`, `goalid`, `goalmethod`, `goalcount`, `delivertonpc`, `zoneid`, `optional`) VALUES (@task_id, 2, 2, 2, 'Iksar Lookouts', '', '', 1000002, 0, 3, 0, 79, 0);
SET @explore_id=@explore_id+1;
INSERT INTO `activities` (`taskid`, `activityid`, `step`, `activitytype`, `text1`, `text2`, `text3`, `goalid`, `goalmethod`, `goalcount`, `delivertonpc`, `zoneid`, `optional`) VALUES (@task_id, 3, 3, 5, 'Main Bandit Camp', '', '', @explore_id, 0, 1, 0, 79, 0);
INSERT INTO `proximities` (`zoneid`, `exploreid`, `minx`, `maxx`, `miny`, `maxy`, `minz`, `maxz`) VALUES (79, @explore_id, -2624, -2524, 3826, 3866, -30, -15);
INSERT INTO `activities` (`taskid`, `activityid`, `step`, `activitytype`, `text1`, `text2`, `text3`, `goalid`, `goalmethod`, `goalcount`, `delivertonpc`, `zoneid`, `optional`) VALUES (@task_id, 4, 3, 2, 'Iksar Bandits', '', '', 79108, 0, 5, 0, 79, 0);
INSERT INTO `activities` (`taskid`, `activityid`, `step`, `activitytype`, `text1`, `text2`, `text3`, `goalid`, `goalmethod`, `goalcount`, `delivertonpc`, `zoneid`, `optional`) VALUES (@task_id, 5, 4, 2, 'Silliv`Host', '', '', 79153, 0, 1, 0, 79, 0);
INSERT INTO `activities` (`taskid`, `activityid`, `step`, `activitytype`, `text1`, `text2`, `text3`, `goalid`, `goalmethod`, `goalcount`, `delivertonpc`, `zoneid`, `optional`) VALUES (@task_id, 6, 5, 1, 'Barrenzin', 'Silliv`Host Head', '', 36083, 0, 1, 202330, 202, 0);
-- Guard_Gregor (12116)
-- Western Plains of Karana (qey2hh1) id 12
-- Protect the Fishermen (Task #509)
SET @task_id=@task_id+1;
INSERT INTO `tasks` (`id`, `duration`, `title`, `description`, `reward`, `rewardid`, `cashreward`, `xpreward`, `rewardmethod`, `startzone`, `minlevel`, `maxlevel`, `repeatable`) VALUES (@task_id, 0, 'Protect the Fishermen', '[1,Very quickly, you need to speak with Brettaru Tyco, to let them know you\'re the Red Beetle. Your contact will know what it means.][2,Your contact was impressed that you kept your wits about you and didn\'t give away your cover. Now, as to why you\'re here. Your code name is Red Beetle and you\'ve been assigned to explore the fishing settlement near the southern waterfall. This is a very dangerous place where reports suggest there is a rebellion forming. You must go there and determine whether or not this is true.][3,It looks like the insurgents are forming quickly, Red Beetle. It\'s up to you to take the raven to the raven\'s nest and kill 10 gorge hounds, Only after that will you be able to retire from this life of subterfuge. Good Luck]', 'Loot and Experience', 0, 176173, -1520, 4290, 12, 15, 30, 0);
INSERT INTO `activities` (`taskid`, `activityid`, `step`, `activitytype`, `text1`, `text2`, `text3`, `goalid`, `goalmethod`, `goalcount`, `delivertonpc`, `zoneid`, `optional`) VALUES (@task_id, 0, 1, 4, 'Brettaru Tyco', '', '', 15191, 0, 1, 0, 15, 0);
SET @explore_id=@explore_id+1;
INSERT INTO `activities` (`taskid`, `activityid`, `step`, `activitytype`, `text1`, `text2`, `text3`, `goalid`, `goalmethod`, `goalcount`, `delivertonpc`, `zoneid`, `optional`) VALUES (@task_id, 1, 2, 5, 'the fishing settlement near the southern waterfall', '', '', @explore_id, 0, 1, 0, 15, 0);
INSERT INTO `proximities` (`zoneid`, `exploreid`, `minx`, `maxx`, `miny`, `maxy`, `minz`, `maxz`) VALUES (15, @explore_id, -2362, -2303, -3854, -3728, -42, -32);
INSERT INTO `activities` (`taskid`, `activityid`, `step`, `activitytype`, `text1`, `text2`, `text3`, `goalid`, `goalmethod`, `goalcount`, `delivertonpc`, `zoneid`, `optional`) VALUES (@task_id, 2, 3, 2, 'Gorge Hounds', '', '', 15030, 0, 10, 0, 15, 0);
INSERT INTO `activities` (`taskid`, `activityid`, `step`, `activitytype`, `text1`, `text2`, `text3`, `goalid`, `goalmethod`, `goalcount`, `delivertonpc`, `zoneid`, `optional`) VALUES (@task_id, 3, 4, 4, 'Brettaru Tyco', '', '', 15191, 0, 1, 0, 15, 0);
-- Guard_Gregor (12116)
-- Western Plains of Karana (qey2hh1) id 12
-- Danger to the North (Task #510)
SET @task_id=@task_id+1;
INSERT INTO `tasks` (`id`, `duration`, `title`, `description`, `reward`, `rewardid`, `cashreward`, `xpreward`, `rewardmethod`, `startzone`, `minlevel`, `maxlevel`, `repeatable`) VALUES (@task_id, 0, 'Danger to the North', '[1,The world is growing at an alarming rate and there aren\'t enough plots of land available for everyone and their livestock to live in. That\'s why it\'s up to you to find some new plots of land. Your first target is going to be nearby, which is why you need to explore the human village south of the gorge. You\'ll know once you arrive if it\'s a good piece of property or not.][2,That wasn\'t the most hospitable place in the world, especially not for a family, but there are plenty of other locations you can visit. This time, why don\'t you explore the ancient statue in the center of the gorge? You\'re bound to get lucky sooner or later and find a suitable living spot.][3,Talk to Pox Soth]', 'Loot and Experience', 0, 542, -2612, 0, 12, 20, 85, 1);
SET @explore_id=@explore_id+1;
INSERT INTO `activities` (`taskid`, `activityid`, `step`, `activitytype`, `text1`, `text2`, `text3`, `goalid`, `goalmethod`, `goalcount`, `delivertonpc`, `zoneid`, `optional`) VALUES (@task_id, 0, 1, 5, 'the human village', '', '', @explore_id, 0, 1, 0, 15, 0);
INSERT INTO `proximities` (`zoneid`, `exploreid`, `minx`, `maxx`, `miny`, `maxy`, `minz`, `maxz`) VALUES (15, @explore_id, -2665, -2589, 1322, 1451, -.1, 3);
SET @explore_id=@explore_id+1;
INSERT INTO `activities` (`taskid`, `activityid`, `step`, `activitytype`, `text1`, `text2`, `text3`, `goalid`, `goalmethod`, `goalcount`, `delivertonpc`, `zoneid`, `optional`) VALUES (@task_id, 1, 2, 5, 'ancient statue', '', '', @explore_id, 0, 1, 0, 16, 0);
INSERT INTO `proximities` (`zoneid`, `exploreid`, `minx`, `maxx`, `miny`, `maxy`, `minz`, `maxz`) VALUES (16, @explore_id, -665, -615, 405, 446, -100, -97);
INSERT INTO `activities` (`taskid`, `activityid`, `step`, `activitytype`, `text1`, `text2`, `text3`, `goalid`, `goalmethod`, `goalcount`, `delivertonpc`, `zoneid`, `optional`) VALUES (@task_id, 2, 3, 4, 'Pox Soth', '', '', 1000007, 0, 1, 0, 16, 0);