search

xackery / rebuildeq-v1

Rebuild Everquest
GNU Lesser General Public License v3.0
1 stars 0 forks source link

Pet Discipline Feat #1115

Closed xackery closed 8 years ago

xackery commented 8 years ago 
UPDATE `peq`.`items` SET `notransfer`=1 WHERE  `id`=10542 OR id = 10539 OR id = 10540 OR id = 105041;

REPLACE INTO `peq`.`tasks` (`id`, `title`, `description`, `reward`, `xpreward`, `rewardmethod`, `repeatable`) VALUES (301, 'Pet Discipline', '[1, Talk to Joyce in the Temple of SolRo to learn about obtaining a Clay Bracelet.][2, Kill 10 Goblins in Lake Rathetear][3, Kill 10 Goblins in Ocean of Tears][4,5, Give a Clay Bracelet and 5x Bottle of Experience to Joyce to claim your reward.]', 'Pet Discipline', 1000, 0, 0);

INSERT INTO `peq`.`activities` (`taskid`, `step`, `activitytype`, `text1`, `goalid`, `zoneid`) VALUES (301, 1, 4, 'Joyce in SolRo Temple', 80035, 80);

INSERT INTO goallists (listid, entry) VALUES (205, 69001), (205, 69003), (205, 69009), (205, 69012), (205, 69027), (205, 69028), (205, 69029), (205, 69035), (205, 69036), (205, 69038), (205, 69045), (205, 69046), (205, 69047), (205, 69052), (205, 69058), (205, 69059), (205, 69095), (205, 69102), (205, 69103), (205, 69104), (205, 69107), (205, 69108), (205, 69114), (205, 69117), (205, 69145), (205, 69148);

REPLACE INTO `peq`.`activities` (`taskid`, `activityid`, `step`, `activitytype`, `text1`, `goalid`, `goalmethod`, `goalcount`, `zoneid`) VALUES (301, 1, 2, 2, 'Goblins in Lake Rathetear', 204, 1, 10, 51);

REPLACE INTO `peq`.`goallists` (`listid`, `entry`) VALUES 
(204, 51013), (204, 51014), (204, 51015), (204, 51016), (204, 51017), (204, 51018), (204, 51019), (204, 51020), (204, 51021), (204, 51027), (204, 51031), (204, 51034), (204, 51042), (204, 51050), (204, 51102), (204, 51103), (204, 51104), (204, 51108), (204, 51137);

REPLACE INTO `peq`.`activities` (`taskid`, `activityid`, `step`, `activitytype`, `text1`, `goalid`, `goalmethod`, `goalcount`, `zoneid`) VALUES (301, 2, 3, 2, 'Goblins in Ocean of Tears', 205, 1, 20, 69);

INSERT INTO goallists (listid, entry) VALUES (205, 69001), (205, 69003), (205, 69009), (205, 69012), (205, 69027), (205, 69028), (205, 69029), (205, 69035), (205, 69036), (205, 69038), (205, 69045), (205, 69046), (205, 69047), (205, 69052), (205, 69058), (205, 69059), (205, 69095), (205, 69102), (205, 69103), (205, 69104), (205, 69107), (205, 69108), (205, 69114), (205, 69117), (205, 69145), (205, 69148);

REPLACE INTO `peq`.`activities` (`taskid`, `activityid`, `step`, `activitytype`, `text1`, `text2`, `goalid`, `delivertonpc`, `zoneid`) VALUES (301, 3, 4, 1, 'Joyce', 'Clay Bracelet', 2359, 80035, 80);

REPLACE INTO `peq`.`activities` (`taskid`, `activityid`, `step`, `activitytype`, `text1`, `text2`, `goalid`, `goalcount`, `delivertonpc`, `zoneid`) VALUES (301, 4, 4, 1, 'Joyce', 'Full Bottle of Experience', 100001, 5, 80035, 80);
xackery commented 8 years ago

UPDATE items SET notransfer=1 WHERE id=10542 OR id = 10539 OR id = 10540 OR id = 105041;

REPLACE INTO tasks (id, title, description, reward, xpreward, rewardmethod, repeatable) VALUES (301, 'Pet Discipline', '[1, Talk to Joyce in the Temple of SolRo to learn about obtaining a Clay Bracelet.][2, Kill 10 Goblins in Lake Rathetear][3, Kill 10 Goblins in Ocean of Tears][4,5, Give a Clay Bracelet and 5x Bottle of Experience to Joyce to claim your reward.]', 'Pet Discipline', 1000, 0, 0);

REPLACE INTO activities (taskid, step, activitytype, text1, goalid, zoneid) VALUES (301, 1, 4, 'Joyce in SolRo Temple', 80035, 80);

REPLACE INTO goallists (listid, entry) VALUES (205, 69001), (205, 69003), (205, 69009), (205, 69012), (205, 69027), (205, 69028), (205, 69029), (205, 69035), (205, 69036), (205, 69038), (205, 69045), (205, 69046), (205, 69047), (205, 69052), (205, 69058), (205, 69059), (205, 69095), (205, 69102), (205, 69103), (205, 69104), (205, 69107), (205, 69108), (205, 69114), (205, 69117), (205, 69145), (205, 69148);

REPLACE INTO activities (taskid, activityid, step, activitytype, text1, goalid, goalmethod, goalcount, zoneid) VALUES (301, 1, 2, 2, 'Goblins in Lake Rathetear', 204, 1, 10, 51);

REPLACE INTO goallists (listid, entry) VALUES (204, 51013), (204, 51014), (204, 51015), (204, 51016), (204, 51017), (204, 51018), (204, 51019), (204, 51020), (204, 51021), (204, 51027), (204, 51031), (204, 51034), (204, 51042), (204, 51050), (204, 51102), (204, 51103), (204, 51104), (204, 51108), (204, 51137);

REPLACE INTO activities (taskid, activityid, step, activitytype, text1, goalid, goalmethod, goalcount, zoneid) VALUES (301, 2, 3, 2, 'Goblins in Ocean of Tears', 205, 1, 20, 69);

REPLACE INTO goallists (listid, entry) VALUES (205, 69001), (205, 69003), (205, 69009), (205, 69012), (205, 69027), (205, 69028), (205, 69029), (205, 69035), (205, 69036), (205, 69038), (205, 69045), (205, 69046), (205, 69047), (205, 69052), (205, 69058), (205, 69059), (205, 69095), (205, 69102), (205, 69103), (205, 69104), (205, 69107), (205, 69108), (205, 69114), (205, 69117), (205, 69145), (205, 69148);

REPLACE INTO activities (taskid, activityid, step, activitytype, text1, text2, goalid, delivertonpc, zoneid) VALUES (301, 3, 4, 1, 'Joyce', 'Clay Bracelet', 2359, 80035, 80);

REPLACE INTO activities (taskid, activityid, step, activitytype, text1, text2, goalid, goalcount, delivertonpc, zoneid) VALUES (301, 4, 4, 1, 'Joyce', 'Full Bottle of Experience', 100001, 5, 80035, 80);

xackery commented 8 years ago

added