-- ***** (unholy) = checked, fixed format for TDB or, verified or rejected
-- Fixes the Protodrake riding creatures.
UPDATE `creature_addon` SET `mount`=26882 WHERE `guid` IN (select `guid` from `creature` where `id`=30332);
DELETE FROM `creature` WHERE `id`=30330;
-- transform Horde, NE and Dranei races when entering Old Hillsbrad (wish UDB devs commented their work...-teacher)
DELETE FROM `spell_area` WHERE (`spell` BETWEEN 35480 AND 35483) AND `area`=4100;
INSERT INTO `spell_area` VALUES
(35480,4100,0,0,0,0,690,0,1),
(35481,4100,0,0,0,0,690,1,1),
(35482,4100,0,0,0,0,1032,0,1),
(35483,4100,0,0,0,0,1032,1,1);
-- random
-- SET 0 as reqskill due not being a profession own spell
UPDATE `skill_discovery_template` SET `reqSkillValue`=0 WHERE reqspell=64323;
-- seph
-- Amani War Bear no more obtainable from Zul'Aman after 3.0
-- ***** (unholy) i have read thru blizz patch notes and cant find reference to this, but all sites claim after 3.0
DELETE FROM `gameobject_loot_template` WHERE `item`=33809;
-- add invis flag to some npcs with subname "nothing to see here" (has been verified)
-- UPDATE `creature_template` SET `flags_extra`=`flags_extra`|'128' WHERE `entry` IN ('18818', '18849', '17915', '18275', '19008', '19009', '21236', '21237', '17950');
-- ***** (unholy) simplify the parameter and catch any that have that name
UPDATE `creature_template` SET `flags_extra`=`flags_extra`|128 WHERE `subname`= 'Nothing to See Here';
-- Illidan's Flame of Azzinoth shouldn't be possible to banish
UPDATE `creature_template` SET `mechanic_immune_mask`=`mechanic_immune_mask`|617299803 WHERE `entry`=22997;
-- Veraku was always friendly, should be a Netherwing npc
UPDATE `creature_template` SET `faction_A`=1824, `faction_H`=1824 WHERE `entry`=18544;
-- Supremus Volcano also unattackable
UPDATE `creature_template` SET `unit_flags`=`unit_flags`|2 WHERE `entry`=23085;
-- ***** (unholy) (cant confirm from WDB i have none with this.. only see on wowhead where it is at 500)
-- those should give 500, not 200 (fix by Visorka)
UPDATE `quest_template` SET `RewRepValue1`=500 WHERE `entry` IN (9208,9209,9210);
-- ***** forum (unholy) - hmmm very discriptive.. i guess this is forum fix (already in tdb)
-- DELETE FROM `achievement_criteria_data` WHERE `criteria_id` IN (3680, 9798);
-- INSERT INTO `achievement_criteria_data` VALUES (3680, 0, 0, 0),(9798, 6, 4658, 0),(9798, 11, 0, 0);
-- DELETE FROM `achievement_criteria_data` WHERE `criteria_id` IN (9798);
-- INSERT INTO `achievement_criteria_data` VALUES (9798, 6, 4658, 0),(9798, 5,63034, 0);
-- ****** (unholy) confirmed, adds missing text http://www.wowhead.com/?achievement=2143#screenshots:id=104092
UPDATE `achievement_reward` SET `subject`= 'Leading the Cavalry', `text`= 'I couldn''t help but to notice how good you are with the livestock. With all the activity around here, business has been better than ever for me. I don''t suppose you''d mind looking after this Albino Drake for me? I simply don''t have enough spare minutes in the day to care for all of these animals. Yours, Mei' WHERE entry=2143;
-- ***** (unholy) fix dead mage hunter looting for quest item
-- ***** (unholy) added last 3 missing fields to coinside with TDB
-- ***** (unholy) however, does not work unless there is an eventai
DELETE FROM `npc_spellclick_spells` WHERE `npc_entry`=26477;
INSERT INTO `npc_spellclick_spells` (`npc_entry`,`spell_id`,`quest_start`,`quest_start_active`,`quest_end`,`cast_flags`,`aura_required`,`aura_forbidden`,`user_type`) VALUES
(26477,47096,11999,1,11999,3,0,0,0),
(26477,47096,12000,1,12000,3,0,0,0);
-- ***** (unholy) taxi to ebonhold - (already in tdb)
-- INSERT INTO `npc_spellclick_spells` (`npc_entry`,`spell_id`,`quest_start`,`quest_start_active`,`quest_end`, `cast_flags`) VALUES (29501,54575,12670,1,0,3);
-- ***** (unholy) fix drop rate for diabolical plans alliance & horde quest (TDB is SET at 2%)
-- ***** on offy, it was a grind to get these plans
-- ***** 20% is too high - http://www.wowhead.com/?item=23777
UPDATE `creature_loot_template` SET `ChanceOrQuestChance`=20 WHERE `item` IN (23777, 23797);
-- ***** (unholy) (unrealistic) raises drop rate of Design: Citrine Pendant of Golden Healing from High Inquisitor Whitemane
-- ***** raises drop rate to 1% all across the board for everything else
-- ***** TDB is SET at 10.0%
-- ***** check 4 sites.. range from 0.88 - 8%
-- UPDATE `creature_loot_template` SET `ChanceOrQuestChance`=1,`lootcondition`=0,`condition_value1`=0,`condition_value2`=0 WHERE `item`=20976;
-- UPDATE `creature_loot_template` SET `ChanceOrQuestChance`=100 WHERE `item`=20976 AND `entry`=3977;
-- ***** (unholy) adds the Sprite Darter Egg to drop list of the Sprite Darter
-- ***** (unholy) update fields and values to TDB format
DELETE FROM `creature_loot_template` WHERE `item`=11474;
INSERT INTO `creature_loot_template` (`entry`,`item`,`ChanceOrQuestChance`,`lootmode`,`groupid`,`mincountOrRef`,`maxcount`,`lootcondition`,`condition_value1`,`condition_value2`) VALUES (5278,11474,0,1.5,0,1,1,6,67,0);
-- ***** (unholy) adds CONDITION_QUESTREWARDED to BAELOGs chest for Gni'kiv Medallion
-- ***** (unholy) updated fields and values to TDB format
-- ***** (unholy) quest the hidden chamber
DELETE FROM `gameobject_loot_template` WHERE `item`=7740;
INSERT INTO `gameobject_loot_template` (`entry`,`item`,`ChanceOrQuestChance`,`lootmode`,`groupid`,`mincountOrRef`,`maxcount`,`lootcondition`,`condition_value1`,`condition_value2`) VALUES
(5066,7740,100,0,0,1,1,8,2240,0);
-- ***** (unholy) adds CONDITION_QUESTREWARDED to The Shaft of Tsol on Revelosh
-- ***** (unholy) updated fields and values to TDB format
-- ***** (unholy) quest the hidden chamber
DELETE FROM `creature_loot_template` WHERE `item`=7741;
INSERT INTO `creature_loot_template` (`entry`,`item`,`ChanceOrQuestChance`,`lootmode`,`groupid`,`mincountOrRef`,`maxcount`,`lootcondition`,`condition_value1`,`condition_value2`) VALUES
(6910,7741,100,0,0,1,1,8,2240,0);
-- ***** (unholy) updated to TDB format
-- Fixes quest item drop rates for Daily Quests in Wintergrasp
UPDATE `creature_loot_template` SET `ChanceOrQuestChance`=-100 WHERE `entry`=30842 AND `item`=43323;
UPDATE `creature_loot_template` SET `ChanceOrQuestChance`=-100 WHERE `entry`=30845 AND `item` IN (44809,43324);
UPDATE `creature_loot_template` SET `ChanceOrQuestChance`=-100 WHERE `entry`=30846 AND `item` IN (43322,44808);
UPDATE `creature_loot_template` SET `ChanceOrQuestChance`=-100 WHERE `entry`=30847 AND `item`=43314;
UPDATE `creature_loot_template` SET `ChanceOrQuestChance`=-100 WHERE `entry`=30872 AND `item`=43323;
UPDATE `creature_loot_template` SET `ChanceOrQuestChance`=-100 WHERE `entry`=30873 AND `item`=43314;
UPDATE `creature_loot_template` SET `ChanceOrQuestChance`=-100 WHERE `entry`=30877 AND `item` IN (43322,44808);
-- ***** (unholy) dont know why they are dropping this (this is still good from what i have read)
-- ***** (unholy) http://www.wowwiki.com/Grulloc's_Dragon_Skull
-- DELETE FROM creature_loot_template WHERE item = 32379;
-- ***** (unholy) add missing questitems to gobjects
UPDATE `gameobject_template` SET `questItem1`=12355 WHERE `entry`=177624;
UPDATE `gameobject_template` SET `questItem1`=12343 WHERE `entry`=175329;
UPDATE `gameobject_template` SET `questitem1`=12341 WHERE `entry`=175330;
UPDATE `gameobject_template` SET `questitem1`=12342 WHERE `entry`=175331;
UPDATE `gameobject_template` SET `questItem1`=6912 WHERE `entry`=93192;
-- ***** (unholy) change size to Sprouted Frond link to quest
UPDATE `gameobject_template` SET `size`=0.4, `data1`=2399 WHERE entry=7510;
-- ***** (unholy) set door to open state in BT Prominade
UPDATE `gameobject` SET `state`=1 WHERE `guid`=20563;
-- ***** (unholy) changed phasemask to ramps at lich king dk area (already done in TDB)
-- UPDATE gameobject SET phaseMask = 192 WHERE guid IN (66618, 66617);
-- ***** (unholy) straightened a sign in stormwind
UPDATE `gameobject` SET `position_z`=2.18846 WHERE `guid`=10665;
-- ***** (unholy) spawn temp frozen waterfall for q11281 Mimicking Natures Call
DELETE FROM `gameobject` WHERE `guid`=99711;
INSERT INTO `gameobject` VALUES (99711,300164,571,1,1,2968.91,-4562.97,273.824,0.241747,0,0, 0.120579,0.992704,25,0,1);
-- ***** (unholy) event script for summoning frostgore q11281
DELETE FROM `event_scripts` WHERE `id`=15726;
INSERT INTO `event_scripts` VALUES (15726,0,10,24173,300000,0,2950.317139,-4551.756348,273.647766,5.493704);
-- ***** (unholy) spawned 2 extra sprouted fond
DELETE FROM `gameobject` WHERE `guid`=42936;
DELETE FROM `gameobject` WHERE `guid`=30276;
DELETE FROM `gameobject` WHERE `guid`=67984;
INSERT INTO `gameobject` VALUES
(30276,7510,1,1,1,9504.34,721.465,1255.94,5.87713,0,0,0.999075,-0.0430092,-600,100,1),
(67984,7510,1,1,1,9503.46,720.08,1255.94,5.68628,0,0,0.999075,-0.0430092,-600,100,1),
(42936,7510,1,1,1,9502.75,718.022,1255.94,5.99887,0,0,0.999075,-0.0430092,-600,100,1);
-- ***** (unholy) added missing emotes to q931 the shimmering frond
DELETE FROM `quest_end_scripts` WHERE `id`=931;
INSERT INTO `quest_end_scripts` VALUES
(931,2,0,3,0,2000000093,0,0,0,0),
(931,2,3,0,0,0,9508.016602,715.748535,1255.886230,1.030548),
(931,3,3,0,0,0,9507.664063,718.009216,1255.886230,1.804165),
(931,4,3,0,0,0,9505.555664,719.088440,1256.203613,2.656322),
(931,6,0,0,0,2000000094,0,0,0,0),
(931,6,1,16,0,0,0,0,0,0),
(931,9,3,0,0,0,9506.92,713.766,1255.89,0.279253),
(931,11,9,30276,15,0,9504.34,721.465,1255.94,5.87713),
(931,11,9,67984,15,0,9503.46,720.08,1255.94,5.68628),
(931,11,9,42936,15,0,9502.75,718.022,1255.94,5.99887);
-- ***** (unholy) add 2 text scripts for the shimmering frond
DELETE FROM `db_script_string` WHERE `entry` BETWEEN 2000000093 AND 2000000094;
INSERT INTO `db_script_string` VALUES
(2000000093,'Denalan hurries to his planter.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(2000000094,'I hope this frond takes root...',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
UPDATE `quest_template` SET `CompleteScript`=931 WHERE `entry`=931;
-- ***** (unholy) fix dead mage hunter on q11999&12000 able to loot now
UPDATE `creature` SET `DeathState`=0 WHERE `id`=26477;
UPDATE `creature_addon` SET `bytes1`=7 WHERE `guid` IN (SELECT `guid` FROM `creature` WHERE `id`=26477);
-- ***** (unholy) set so npc is attackable now
UPDATE `creature_template` SET `unit_flags`=`unit_flags`&~256 WHERE `entry`=10316;
-- ***** (unholy) fix health stats and equip gunther arcanus
UPDATE `creature_template` SET `Minhealth`=3189, `Maxhealth`=3189, `equipment_id`=7 WHERE `entry`=1497;
-- ***** (unholy) fixed death state on iruk
UPDATE `creature_addon` SET `bytes1`=7 WHERE `guid`=105531;
UPDATE `creature` SET `DeathState`=0 WHERE `guid`=105531;
-- ***** (unholy) fix william allerton death state and attacking
-- ***** (unholy) i added missing column in values for TDB
DELETE FROM `creature_addon` WHERE guid=99763;
UPDATE `creature` SET `DeathState`=0 WHERE `id`=25385;
DELETE FROM `creature_template_addon` WHERE `entry`=25385;
INSERT INTO `creature_template_addon` VALUES (25385,0,0,7,0,0,0, '');
-- ***** (unholy) place deathstalker razael on a mount, added value for path id for tdb
DELETE FROM `creature_addon` WHERE `guid`=113843;
INSERT INTO `creature_addon` VALUES (113843,0,10718,0,0,0,0, '');
-- ***** (unholy) add banish aura to azaloth, added pth id value for tdb
DELETE FROM `creature_addon` WHERE `guid`=75420;
INSERT INTO `creature_addon` VALUES (75420,0,0,0,0,0,0, '37833 0');
-- ***** (unholy) spawn inscription vendor kul inkspiller
-- ***** (unholy) this reuses an existing guid - 17077 ancestral spirit wolf
DELETE FROM `creature` WHERE `guid`=84645;
INSERT INTO `creature` VALUES (84645,30735,530,1,1,27300,0,220.739,2828.66,145.053,0.384847,300,0,0,2136,5751,0,0);
-- ***** (unholy) spawns jezebel bican inscription vendor
DELETE FROM `creature` WHERE `guid`=135120;
INSERT INTO `creature` VALUES (135120,30734,530,1,1,27299,0,-771.901,2754.23,146.533,2.60872,180,0,0,2136,5751,0,0);
-- ***** (unholy) repositions vhelkur onto runway
UPDATE `creature` SET `position_x`=-5052.04,`position_y`=662.587,`position_z`=89.5709,`orientation`=0.0201144 WHERE `guid`=76114 AND `id`=21801;
-- ***** (unholy) removes aura from azaloth
DELETE FROM `spell_scripts` WHERE `id`=37834;
INSERT INTO `spell_scripts` VALUES (37834,0,14,37833,0,0,0,0,0,0);
-- ***** (unholy) adds gossip to roxi ramrocket & Zidormi
DELETE FROM `npc_gossip` WHERE `npc_guid`=97713;
INSERT INTO `npc_gossip` VALUES (97713,14180);
DELETE FROM `npc_gossip` WHERE `npc_guid`=105234;
INSERT INTO `npc_gossip` VALUES (105234,14065);
-- ***** (unholy) adds gossip to Tharnariun Treetender & Terenthis
DELETE FROM `npc_gossip` WHERE `npc_guid` IN (37294, 37097);
INSERT INTO `npc_gossip` VALUES
(37294,769),
(37097,3334);
-- ***** (unholy) i think this is for tracy (18266)... i dont understand npc_text and use.
UPDATE `npc_text` SET `prob0`=1.0,`text0_1`= 'Oh, no! My Fei Fei would never take someone else\'s things! He\'s a good dog... he just needs attention sometimes. If you give him a treat, then you see!' WHERE `ID`=10689;
/* places when players get ghost mount while dead */
DELETE FROM `spell_area` WHERE `spell` IN (55173,55164);
INSERT INTO `spell_area` VALUES
(55173,210 ,0,0,0,8326,0x0008,2,1),
(55164,210 ,0,0,0,8326,0xFFF7,2,1),
(55173,67 ,0,0,0,8326,0x0008,2,1),
(55164,67 ,0,0,0,8326,0xFFF7,2,1),
(55173,4161,0,0,0,8326,0x0008,2,1),
(55164,4161,0,0,0,8326,0xFFF7,2,1);
-- ***** (unholy) coords for teleport to caverns of time
DELETE FROM `spell_target_position` WHERE `id`=46343;
INSERT INTO `spell_target_position` VALUES (46343, 1, -8167.18, -4766.8, 33.9648, 5.165);
-- ***** (unholy) drop osborne as quest giver for a simple request
DELETE FROM `creature_involvedrelation` WHERE `quest`=8233 AND `id`=918;
-- ***** (unholy) update questgivers/takers
DELETE FROM `gameobject_involvedrelation` WHERE `quest`=2201 AND `id`=112877;
INSERT INTO `gameobject_involvedrelation` (`id`,`quest`) VALUES (112877, 2201);
DELETE FROM `gameobject_questrelation` WHERE `quest`=2204 AND `id`=112877;
INSERT INTO `gameobject_questrelation` (`id`,`quest`) VALUES (112877, 2204);
-- ***** (unholy) updates a meeting with fate (already in TDB)
-- DELETE FROM creature_questrelation WHERE quest = 12755;
-- INSERT INTO creature_questrelation (id, quest) VALUES (28914, 12755);
-- DELETE FROM creature_involvedrelation WHERE quest = 12755;
-- INSERT INTO creature_involvedrelation (id, quest) VALUES (29077, 12755);
-- ***** (unholy) take say script off of wrong quest
DELETE FROM `quest_end_scripts` WHERE `id`=21;
UPDATE `quest_template` SET `Completescript`=0 WHERE `entry`=21;
-- ***** (unholy) add it to correct quest..
DELETE FROM `quest_start_scripts` WHERE `id`=54;
INSERT INTO `quest_start_scripts` VALUES
(54,1,15,6245,0,0,0,0,0,0),
(54,2,1,113,0,0,0,0,0,0),
(54,2,0,0,0,2000000059,0,0,0,0);
-- ***** (unholy) set up right quest to use script
UPDATE `quest_template` SET `Startscript`=54 WHERE `entry`=54;
-- ***** (unholy) updates quest fields of grief adds text scripts
-- ***** (unholy) corrected sql syntax errors for tdb standards
DELETE FROM `quest_end_scripts` WHERE `id`=407;
INSERT INTO `quest_end_scripts` VALUES
(407,19,15,5,1,0,0,0,0,0),
(407,13,3,0,0,0,2288.956543,237.959808,27.089151,2.487725),
(407,10,3,0,0,0,2292.524414,235.225677,27.089151,4.834496),
(407,8,0,0,0,2000000083,0,0,0,0),
(407,6,3,0,0,0,2292.002197,239.481247,27.089151,0.693878),
(407,3,3,0,0,0,2287.974407,236.252792,27.089151,2.661301),
(407,3,15,3287,1,0,0,0,0,0),
(407,0,0,0,0,2000000082,0,0,0,0);
DELETE FROM `db_script_string` WHERE `entry`=2000000082;
DELETE FROM `db_script_string` WHERE `entry`=2000000083;
INSERT INTO `db_script_string` VALUES
(2000000082, 'I. . .I. . .don''t. . .feel. . .right. . .',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(2000000083, 'My mind. . .my flesh. . .I''m. . .rotting. . . .!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
UPDATE `quest_template` SET `CompleteScript`=407 WHERE `entry`=407;
-- ***** (unholy) updates quest a new plague adding text script
DELETE FROM `quest_end_scripts` WHERE `id`=492;
INSERT INTO `quest_end_scripts` VALUES
(492,6,15,5,1,0,0,0,0,0),
(492,2,1,7,0,0,0,0,0,0),
(492,1,0,0,0,2000000084,0,0,0,0);
DELETE FROM `db_script_string` WHERE `entry`=2000000084;
INSERT INTO `db_script_string` VALUES
(2000000084, 'I raise my brew and hope to be rid of the likes of you! Cheers, you no good scoundrel, $N!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
UPDATE `quest_template` SET `CompleteScript`=492 WHERE `entry`=492;
-- ***** (unholy) updates quest Proving Allegiance adds text scripts
DELETE FROM `quest_start_scripts` WHERE `id`=409;
INSERT INTO `quest_start_scripts` VALUES
(409,3,1,25,0,0,0,0,0,0),
(409,1,0,0,0,2000000085,0,0,0,0);
DELETE FROM `db_script_string` WHERE `entry`=2000000085;
INSERT INTO `db_script_string` VALUES
(2000000085, 'Take a Candle of Beckoning from this crate, $N.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
UPDATE `quest_template` SET `StartScript`=409 WHERE `entry`=409;
-- ***** (unholy) updates seek redemption adds text scripts (already in tdb)
-- DELETE FROM quest_end_scripts WHERE id=489;
-- INSERT INTO quest_end_scripts VALUES
-- (489,0,15,3329,0,0,0,0,0,0),
-- (489,1,0,0,0,2000000047,0,0,0,0);
-- ***** (unholy) updates quest Scalding Mornbrew Delivery adds emotes
DELETE FROM `db_script_string` WHERE `entry`=2000000046;
INSERT INTO `db_script_string` VALUES (2000000046, 'Oooooo hot hot hot! If that won''t put spring in your step, I don''t know what will!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
DELETE FROM `quest_end_scripts` WHERE `id`=3364;
INSERT INTO `quest_end_scripts` VALUES
(3364,20,1,0,0,0,0,0,0,0),
(3364,8,1,400,0,0,0,0,0,0),
(3364,8,0,0,0,2000000046,0,0,0,0),
(3364,6,1,7,0,0,0,0,0,0),
(3364,2,1,1,0,0,0,0,0,0),
(3364,2,0,0,0,2000000045,0,0,0,0);
-- ***** (unholy) updates quest Return to Onu adds text scripts
DELETE FROM `quest_end_scripts` WHERE `id`=950;
INSERT INTO `quest_end_scripts` VALUES
(950,1,0,3,0,2000000090,0,0,0,0),
(950,4,0,3,0,2000000091,0,0,0,0),
(950,8,0,0,0,2000000092,0,0,0,0);
DELETE FROM `db_script_string` WHERE `entry` BETWEEN 2000000090 AND 2000000092;
INSERT INTO `db_script_string` VALUES
(2000000090, 'Onu studies the parchment from the Twilight Tome...',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(2000000091, 'Onu is struck by unleashed magic!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(2000000092, 'Hmm...',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
UPDATE `quest_template` SET `CompleteScript`=950 WHERE `entry`=950;
-- ***** (unholy) updates quest The Glowing Fruit adds text and emotes
DELETE FROM `quest_end_scripts` WHERE `id`=930;
INSERT INTO `quest_end_scripts` VALUES
(930,1,0,3,0,2000000086,0,0,0,0),
(930,4,0,0,0,2000000087,0,0,0,0),
(930,4,3,0,0,0,9508.016602,715.748535,1255.886230,1.030548),
(930,5,3,0,0,0,9507.664063,718.009216,1255.886230,1.804165),
(930,6,3,0,0,0,9505.555664,719.088440,1256.203613,2.656322),
(930,8,0,3,0,2000000088,0,0,0,0),
(930,8,1,16,0,0,0,0,0,0),
(930,11,3,0,0,0,9506.92,713.766,1255.89,0.279253),
(930,14,0,3,0,2000000089,0,0,0,0),
(930,14,10,3569,20000,0,9505.13,722.011,1255.94,0.0244875),
(930,14,10,3569,20000,0,9504.13,721.459,1255.94,6.24727),
(930,14,10,3569,20000,0,9504.09,720.294,1255.94,1.00709);
DELETE FROM db_script_string WHERE entry BETWEEN 2000000086 AND 2000000089;
INSERT INTO db_script_string VALUES
(2000000086, 'Denalan removes the seeds from the Glowing Fruit...',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(2000000087, 'Let''s see how these seeds grow in my prepared soil...',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(2000000088, 'Denalan plants fruit seeds.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(2000000089, 'Bogling rises from the soil!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
-- ***** (unholy) updates cards to take off restrictions... verified - wowhead
UPDATE quest_template SET SkillOrClass=0, ZoneOrSort=0, RequiredSkillValue=0 WHERE entry IN (12517, 12798, 12518, 13311);
-- ***** (unholy) updates quest Coldridge Valley Mail Delivery and sets a previous quest
UPDATE quest_template SET PrevQuestId = 179 WHERE entry = 233;