DB/CoredevData: Database data for quest "Going Bearback"

Fixes #472

1 files changed, 45 insertions, 0 deletions

diff --git a/sql/updates/world/2011_02_11_0_world_coredevdata.sql b/sql/updates/world/2011_02_11_0_world_coredevdata.sql
new file mode 100644
index 00000000000..70d360c1689
--- /dev/null
+++ b/sql/updates/world/2011_02_11_0_world_coredevdata.sql
@@ -0,0 +1,45 @@
+DELETE FROM `npc_spellclick_spells` WHERE `npc_entry`=29598;
+INSERT INTO `npc_spellclick_spells` (`npc_entry`,`spell_id`,`quest_start`,`quest_start_active`,`quest_end`,`cast_flags`) VALUES
+(29598,54768,0,1,12856,1);
+
+DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=13 AND `SourceEntry`=54798;
+INSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceEntry`,`ConditionTypeOrReference`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`,`Comment`) VALUES
+(13,54798,18,1,29351,1,'FLAMING Arrow Triggered Effect'),
+(13,54798,18,1,29358,1,'FLAMING Arrow Triggered Effect');
+
+-- Not the Blizzlike waypoints, Malcrom has those, but these are temporary
+DELETE FROM `script_waypoint` WHERE `entry`=29602;
+INSERT INTO `script_waypoint` (entry,pointid,location_x,location_y,location_z,waittime) VALUES 
+(29602,1,7085.374,-1938.052,773.318,0),
+(29602,2,7085.374,-1938.052,773.318,0),
+(29602,3,7065.382,-1988.499,768.9483,0),
+(29602,4,7079.698,-2033.11,764.2703,0),
+(29602,5,7068.746,-2081.637,758.4695,0),
+(29602,6,7065.993,-2130.804,756.0863,0),
+(29602,7,7088.311,-2173.474,759.4193,0),
+(29602,8,7124.069,-2207.86,758.3796,0),
+(29602,9,7152.243,-2248.376,759.6431,0),
+(29602,10,7196.352,-2265.138,756.9138,0),
+(29602,11,7234.013,-2297.475,752.4849,0),
+(29602,12,7255.404,-2341.076,751.6851,0),
+(29602,13,7297.881,-2368.091,751.6649,0),
+(29602,14,7304.306,-2416.368,752.8918,0),
+(29602,15,7320.821,-2463.647,750.8485,0),
+(29602,16,7362.996,-2490.504,749.8151,0),
+(29602,17,7409.486,-2475.066,751.9595,0),
+(29602,18,7422.454,-2427.556,752.5062,0),
+(29602,19,7407.287,-2380.342,753.0123,0),
+(29602,20,7366.268,-2303.298,756.0569,0),
+(29602,21,7318.561,-2301.531,754.494,0),
+(29602,22,7280.997,-2270.392,756.3792,0),
+(29602,23,7237.944,-2246.72,756.4333,0),
+(29602,24,7193.829,-2231.046,757.992,0),
+(29602,25,7159.348,-2195.307,760.6475,0),
+(29602,26,7122.389,-2164.836,760.5703,0),
+(29602,27,7112.455,-2116.784,759.8074,0),
+(29602,28,7117.603,-2040.713,767.7001,0),
+(29602,29,7107.043,-2011.189,770.1815,0),
+(29602,30,7103.942,-1985.653,771.1707,0),
+(29602,31,7079.7,-1966.68,769.305,0),
+(29602,32,7080.018,-1948.492,771.6097,0),
+(29602,33,7087.928,-1931.903,773.8726,0);