AlirezaAbsolut
commented
8 years ago I've got to fix the problem quests, hope to be useful: -Quest : Calligraphed Sigil (31168)>>>>>>>http://www.wowhead.com/quest=31168 -Quest : The Art of the Monk (31169)>>>>>http://www.wowhead.com/quest=31169
[SQL Code] >> DB = World
/*
01 Quest : Calligraphed Sigil (31168)
> http://www.wowhead.com/quest=31168
02 Quest : The Art of the Monk (31169)
> http://www.wowhead.com/quest=31169
> Authored by AlirezaAbsolut [https://github.com/AlirezaAbsolut
*/
-- Edit Quest : Calligraphed Sigil (31168)
update `quest_template` set `RequestItemsText` = 'Ah, you have come. Good.$B$BI am learning so much - your people have a wealth of knowledge unmatched anywhere I have seen. As much as I am humbled by that fact, I hope that I may teach you of our ways, as well.', `OfferRewardText` = 'I was warned that not all of your people would be welcoming, but I have found quite the opposite - not only have I been welcomed, but I have learned so much from you.$B$BYou seem quite promising as a young monk, and I hope I can teach you much of our ways, as your people have taught me of yours.', `RequiredClasses` = 512 where `Id` = 31168;
delete from `creature_queststarter` where `quest` = 31168;
insert into `creature_queststarter` (`id`, `quest`) values
(2077, 31168);
delete from `creature_queststarter` where `id` = 63331 and `quest` = 28723;
insert into `creature_queststarter` (`id`, `quest`) values
(63331, 28723);
delete from `quest_poi` where `questId` = 31168;
delete from `quest_poi_points` where `questId` = 31168;
insert into `quest_poi` (`questId`, `id`, `objIndex`, `mapid`, `WorldMapAreaId`, `FloorId`, `unk3`, `unk4`) values
(31168, 0, -1, 1, 41, 0, 0, 1);
insert into `quest_poi_points` (`questId`, `id`, `idx`, `x`, `y`) values
(31168, 0, 0, 10529, 784);
-- add creature laoxi (63331)
set @CGUID = xxx;
delete from `creature` where `id` = 63331;
insert into `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`) values
(@CGUID, 63331, 1, 1, 1, 0, 1, 10529.57, 784.489, 1329.5992, 3.27115, 300, 0, 0, 0, 0, 0, 0, 0, 0);
-- Edit Quest : The Art of the Monk (31169)
update `quest_template` set `OfferRewardText` = 'You''ve proven a capable student. When it is time to resume your training, return to me and I will show you other techniques.' where `Id` = 31169;
delete from `quest_poi` where `questId` = 31169;
delete from `quest_poi_points` where `questId` = 31169;
insert into `quest_poi` (`questId`, `id`, `objIndex`, `mapid`, `WorldMapAreaId`, `FloorId`, `unk3`, `unk4`) values
(31169, 0, -1, 1, 41, 0, 0, 1),
(31169, 1, 0, 1, 41, 0, 0, 1),
(31169, 2, 1, 1, 41, 0, 0, 1);
insert into `quest_poi_points` (`questId`, `id`, `idx`, `x`, `y`) values
(31169, 0, 0, 10480, 825),
(31169, 1, 0, 10476, 720),
(31169, 1, 1, 10519, 732),
(31169, 1, 2, 10538, 745),
(31169, 1, 3, 10569, 775),
(31169, 1, 4, 10581, 812),
(31169, 1, 5, 10551, 862),
(31169, 1, 6, 10500, 892),
(31169, 1, 7, 10464, 893),
(31169, 1, 8, 10427, 868),
(31169, 1, 9, 10414, 812),
(31169, 1, 10, 10420, 775),
(31169, 1, 11, 10451, 738),
(31169, 2, 0, 10470, 707),
(31169, 2, 1, 10525, 714),
(31169, 2, 2, 10569, 738),
(31169, 2, 3, 10581, 782),
(31169, 2, 4, 10575, 812),
(31169, 2, 5, 10544, 868),
(31169, 2, 6, 10513, 880),
(31169, 2, 7, 10470, 887),
(31169, 2, 8, 10427, 880),
(31169, 2, 9, 10402, 850),
(31169, 2, 10, 10408, 794),
(31169, 2, 11, 10439, 732);
SkyFire
JustZerooo
Hi, I've got to fix the problem quests, hope to be useful:
[SQL Code] >>> Database = Wolrd