DB/Spawns: Crystal Web Cavern & Garm Cavern By K3

1 files changed, 120 insertions, 0 deletions

diff --git a/sql/updates/world/2011_04_17_05_world_creature.sql b/sql/updates/world/2011_04_17_05_world_creature.sql
new file mode 100644
index 00000000000..16c5418d6da
--- /dev/null
+++ b/sql/updates/world/2011_04_17_05_world_creature.sql
@@ -0,0 +1,120 @@
+-- Spawns for Crystalweb Cavern
+-- Snowblind Digger
+SET @GUID=152040; -- Need 57
+DELETE FROM `creature` WHERE `id` IN (29407,29409,29412,29413);
+INSERT INTO `creature` (`guid`,`id`,`map`,`spawnMask`,`phaseMask`,`modelid`,`equipment_id`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`spawndist`,`currentwaypoint`,`curhealth`,`curmana`,`DeathState`,`MovementType`,`npcflag`,`unit_flags`,`dynamicflags`) VALUES
+(117812,29413,571,1,1,0,0,6304.011,-1012.982,413.2471,2.827433,300,0,0,1,0,0,0,0,0,0), -- Updated Spawn with Sniffed Position
+(117813,29413,571,1,1,0,0,6447,-1004.23,433.973,3.21141,300,0,0,11001,0,0,0,0,0,0),
+(117814,29413,571,1,1,0,0,6694.82,-1049.95,408.713,4.79241,300,0,0,11001,0,0,0,0,0,0),
+(@GUID+0,29413,571,1,1,0,0,6549.784,-1268.647,398.4628,4.380776,300,0,0,1,0,0,0,0,0,0),
+(@GUID+1,29413,571,1,1,0,0,6594.707,-1254.841,396.956,0.1745329,300,0,0,1,0,0,0,0,0,0),
+(@GUID+2,29413,571,1,1,0,0,6577.69,-1234.807,401.2381,1.919862,300,0,0,1,0,0,0,0,0,0),
+(@GUID+3,29413,571,1,1,0,0,6505.765,-1010.692,437.3392,2.146755,300,0,0,1,0,0,0,0,0,0),
+(@GUID+4,29413,571,1,1,0,0,6617.206,-1275.861,394.5572,0.03490658,300,0,0,1,0,0,0,0,0,0),
+(@GUID+5,29413,571,1,1,0,0,6607.412,-1271.927,395.044,4.310963,300,0,0,1,0,0,0,0,0,0),
+(@GUID+6,29413,571,1,1,0,0,6618.625,-1289.63,395.3728,0.2617994,300,0,0,1,0,0,0,0,0,0),
+(@GUID+7,29413,571,1,1,0,0,6598.191,-1286.431,394.4492,0.3316126,300,0,0,1,0,0,0,0,0,0),
+(@GUID+8,29413,571,1,1,0,0,6695.96,-1041.137,412.2228,-1.350969,300,0,0,1,0,0,0,0,0,0),
+(@GUID+9,29413,571,1,1,0,0,6598.955,-1012.957,429.1754,6.230914,300,0,0,1,0,0,0,0,0,0),
+(@GUID+10,29413,571,1,1,0,0,6550.22,-1296.998,395.8197,5.305801,300,0,0,1,0,0,0,0,0,0),
+(@GUID+11,29413,571,1,1,0,0,6562.411,-1279.173,394.7112,4.572762,300,0,0,1,0,0,0,0,0,0),
+(@GUID+12,29413,571,1,1,0,0,6582.667,-1295.584,396.0742,3.769911,300,0,0,1,0,0,0,0,0,0),
+(@GUID+13,29413,571,1,1,0,0,6572.444,-1251.02,397.3442,1.40402,300,0,0,1,0,0,0,0,0,0),
+(@GUID+14,29413,571,1,1,0,0,6554.481,-1243.797,398.5085,4.45059,300,0,0,1,0,0,0,0,0,0),
+(@GUID+15,29413,571,1,1,0,0,6671.676,-1297.581,395.9203,0.1032045,300,0,0,1,0,0,0,0,0,0),
+-- Crystalweb Spitter
+(117781,29412,571,1,1,26223,0,6519.95,-1027.48,433.737,0.175263,300,0,0,11379,0,0,0,0,0,0),
+(117782,29412,571,1,1,26223,0,6742.73,-1543.87,365.316,2.23402,300,0,0,11379,0,0,0,0,0,0),
+(117783,29412,571,1,1,26223,0,6669.02,-1082.85,400.338,5.49205,300,5,0,11379,0,0,1,0,0,0),
+(@GUID+16,0,29412,571,1,1,0,0,6685.524,-1304.507,395.6901,1.574838,300,0,0,1,0,0,0,0,0,0),
+(@GUID+17,29412,571,1,1,0,0,6585.083,-1121.508,410.5753,5.966588,300,0,0,1,0,0,0,0,0,0),
+(@GUID+18,29412,571,1,1,0,0,6691.913,-1491.667,377.6763,1.820203,300,0,0,1,0,0,0,0,0,0),
+(@GUID+19,29412,571,1,1,0,0,6658.331,-1299.063,396.7297,2.80998,300,0,0,1,0,0,0,0,0,0),
+(@GUID+20,29412,571,1,1,0,0,6645.377,-1164.97,399.7607,5.235988,300,0,0,1,0,0,0,0,0,0),
+(@GUID+21,29412,571,1,1,0,0,6665.021,-1076.323,402.5284,4.24115,300,0,0,1,0,0,0,0,0,0),
+(@GUID+22,29412,571,1,1,0,0,6706.143,-1073.628,391.6251,0.781437,300,0,0,1,0,0,0,0,0,0),
+(@GUID+23,29412,571,1,1,0,0,6638.069,-1253.051,395.669,4.049164,300,0,0,1,0,0,0,0,0,0),
+(@GUID+24,29412,571,1,1,0,0,6599.83,-1024.043,428.5868,3.237097,300,0,0,1,0,0,0,0,0,0),
+(@GUID+25,29412,571,1,1,0,0,6538.664,-1043.781,428.86,0.1047198,300,0,0,1,0,0,0,0,0,0),
+(@GUID+26,29412,571,1,1,0,0,6684.955,-1351.482,394.3488,6.021386,300,0,0,1,0,0,0,0,0,0),
+(@GUID+27,29412,571,1,1,0,0,6712.782,-1482.948,377.3944,1.758111,300,0,0,1,0,0,0,0,0,0),
+(@GUID+28,29412,571,1,1,0,0,6615.511,-1116.219,411.492,4.632286,300,0,0,1,0,0,0,0,0,0),
+-- ---------------
+-- -- Garm Cave --
+-- ---------------
+-- Snowblind Devotee
+(117305,29407,571,1,1,27185,0,6297.12,-1425.6,426.168,2.28638,300,0,0,11001,3643,0,0,0,0,0),
+(117306,29407,571,1,1,27174,0,6297.26,-1406.99,425.576,3.66519,300,0,0,11001,3643,0,0,0,0,0),
+(117307,29407,571,1,1,27174,0,6278.49,-1425.38,425.555,1.02974,300,0,0,11001,3643,0,0,0,0,0),
+(117308,29407,571,1,1,27174,0,6292.41,-1374.15,425.467,1.57504,300,5,0,11001,3643,0,1,0,0,0),
+(117309,29407,571,1,1,27174,0,6293.24,-1367.46,425.361,3.45575,300,0,0,11001,3643,0,0,0,0,0),
+(117310,29407,571,1,1,27185,0,6310.95,-1762.18,457.459,1.51755,300,5,0,11001,3643,0,1,0,0,0),
+(@GUID+29,29407,571,1,1,0,0,6434.24,-1737.51,432.217,5.46288,300,0,0,1,0,0,0,0,0,0),
+(@GUID+30,29407,571,1,1,0,0,6319.8,-1661.22,457.449,0.837758,300,0,0,1,0,0,0,0,0,0),
+(@GUID+31,29407,571,1,1,0,0,6289.97,-1599.25,425.883,4.57276,300,0,0,1,0,0,0,0,0,0),
+(@GUID+32,29407,571,1,1,0,0,6483.06,-1634.21,464.794,2.37365,300,0,0,1,0,0,0,0,0,0),
+(@GUID+33,29407,571,1,1,0,0,6475.38,-1631.87,464.816,0.279253,300,0,0,1,0,0,0,0,0,0),
+(@GUID+34,29407,571,1,1,0,0,6458.55,-1661.17,434.631,4.08083,300,0,0,1,0,0,0,0,0,0),
+(@GUID+35,29407,571,1,1,0,0,6518.89,-1646.07,426.105,5.11381,300,0,0,1,0,0,0,0,0,0),
+(@GUID+36,29407,571,1,1,0,0,6273.52,-1604.35,424.533,5.55015,300,0,0,1,0,0,0,0,0,0),
+(@GUID+37,29407,571,1,1,0,0,6425.83,-1670.41,471.519,2.25148,300,0,0,1,0,0,0,0,0,0),
+(@GUID+38,29407,571,1,1,0,0,6428.22,-1705.45,434.128,0.488692,300,0,0,1,0,0,0,0,0,0),
+(@GUID+39,29407,571,1,1,0,0,6541.62,-1654.47,453.662,5.96903,300,0,0,1,0,0,0,0,0,0),
+(@GUID+40,29407,571,1,1,0,0,6403.41,-1717.79,431.839,4.60767,300,0,0,1,0,0,0,0,0,0),
+(@GUID+41,29407,571,1,1,0,0,6441.19,-1758.54,432.217,3.26377,300,0,0,1,0,0,0,0,0,0),
+(@GUID+42,29407,571,1,1,0,0,6471.03,-1753.78,432.738,1.18682,300,0,0,1,0,0,0,0,0,0),
+(@GUID+43,29407,571,1,1,0,0,6459.88,-1762.25,432.217,0.925025,300,0,0,1,0,0,0,0,0,0),
+(@GUID+44,29407,571,1,1,0,0,6414.89,-1738.78,432.217,0.401426,300,0,0,1,0,0,0,0,0,0),
+(@GUID+45,29407,571,1,1,0,0,6408.04,-1729.23,432.211,2.47837,300,0,0,1,0,0,0,0,0,0),
+(@GUID+46,29407,571,1,1,0,0,6514.17,-1749.59,436.202,5.86431,300,0,0,1,0,0,0,0,0,0),
+(@GUID+47,29407,571,1,1,0,0,6519.56,-1747.13,436.252,4.41568,300,0,0,1,0,0,0,0,0,0),
+-- Garm Watcher
+(117614,29409,571,1,1,24842,0,6381.32,-1648.28,420.067,1.16937,300,5,0,11770,0,0,1,0,0,0),
+(@GUID+48,29409,571,1,1,0,0,6479.16,-1642.7,465.234,1.20397,300,0,0,1,0,0,0,0,0,0),
+(@GUID+49,29409,571,1,1,0,0,6410.43,-1613.44,421.331,3.10776,300,0,0,1,0,0,0,0,0,0),
+(@GUID+50,29409,571,1,1,0,0,6446.13,-1641.86,418.539,3.43956,300,0,0,1,0,0,0,0,0,0),
+(@GUID+51,29409,571,1,1,0,0,6480.65,-1717.4,434.573,2.00713,300,0,0,1,0,0,0,0,0,0),
+(@GUID+52,29409,571,1,1,0,0,6503.1,-1677.39,432.951,3.56047,300,0,0,1,0,0,0,0,0,0),
+(@GUID+53,29409,571,1,1,0,0,6316.56,-1528.47,428.335,1.8326,300,0,0,1,0,0,0,0,0,0),
+(@GUID+54,29409,571,1,1,0,0,6285.07,-1554.58,423.336,2.21657,300,0,0,1,0,0,0,0,0,0),
+(@GUID+55,29409,571,1,1,0,0,6544.34,-1675.45,452.674,3.63029,300,0,0,1,0,0,0,0,0,0),
+(@GUID+56,29409,571,1,1,0,0,6429.06,-1736.25,479.353,0.855211,300,0,0,1,0,0,0,0,0,0),
+(@GUID+57,29409,571,1,1,0,0,6522.09,-1735.2,436.308,0.615843,300,0,0,1,0,0,0,0,0,0);
+
+-- Template updates
+UPDATE `creature_template` SET `speed_run`=1.19048 WHERE `entry` IN (29413,29412); -- Snowblind Digger
+UPDATE `creature_template` SET `speed_run`=1.19048 WHERE `entry`=29412; -- Crystalweb Spitter
+UPDATE `creature_template` SET `speed_run`=1.19048 WHERE `entry`=29407; -- Snowblind Devotee
+UPDATE `creature_template` SET `dynamicflags`=`dynamicflags`|32,`speed_run`=1.19048 WHERE `entry`=29546; -- K3 Snow Runner
+UPDATE `creature_template` SET `speed_run`=1.19048 WHERE `entry`=29618; -- Snowblind Follower
+UPDATE `creature_template` SET `exp`=0,`unit_flags`=`unit_flags`|33554432,`speed_run`=1.19048 WHERE `entry`=29475; -- Improved Land Mine
+UPDATE `creature_template` SET `unit_flags`=`unit_flags`|32768,`speed_walk`=1.6,`speed_run`=1.42857 WHERE `entry`=29409; -- Garm Watcher
+
+
+-- Model data
+UPDATE `creature_model_info` SET `bounding_radius`=0.372,`combat_reach`=0,`gender`=0 WHERE `modelid`=27183; -- Snowblind Digger
+UPDATE `creature_model_info` SET `bounding_radius`=0.372,`combat_reach`=0,`gender`=0 WHERE `modelid`=27185; -- Snowblind Devotee
+UPDATE `creature_model_info` SET `bounding_radius`=0.31,`combat_reach`=0,`gender`=0 WHERE `modelid`=27172; -- Snowblind Follower
+UPDATE `creature_model_info` SET `bounding_radius`=0.372,`combat_reach`=0,`gender`=0 WHERE `modelid`=27181; -- Snowblind Follower
+UPDATE `creature_model_info` SET `bounding_radius`=0.62,`combat_reach`=6,`gender`=0 WHERE `modelid`=24857; -- Garm Invader
+UPDATE `creature_model_info` SET `bounding_radius`=0.62,`combat_reach`=6,`gender`=0 WHERE `modelid`=24842; -- Garm Watcher
+
+-- Addon data for creature 29413 (Snowblind Digger)
+DELETE FROM `creature_template_addon` WHERE `entry` IN (29413,29412,29407,29546,29618,29475,29619,29409);
+INSERT INTO `creature_template_addon` (`entry`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES
+(29413,0,0,1,0, NULL), -- Snowblind Digger
+(29412,0,0,1,0,NULL), -- Crystalweb Spitter
+(29407,0,0,1,0, NULL), -- Snowblind Devotee
+(29546,0,0,1,0, NULL), -- K3 Snow Runner.
+(29618,0,0,1,0, NULL), -- Snowblind Follower
+(29475,0,0,1,0, NULL), -- Improved Land Mine
+(29619,0,0,1,0, NULL), -- Garm Invader
+(29409,0,0,1,0, NULL); -- Garm Watcher
+
+-- Camp Fires in the Cave
+SET @OGUID=151892;
+DELETE FROM `gameobject` WHERE `id` IN (192131,192130,192129);
+INSERT INTO `gameobject` (`guid`,`id`,`map`,`spawnMask`,`phaseMask`,`position_x`,`position_y`,`position_z`,`orientation`,`rotation0`,`rotation1`,`rotation2`,`rotation3`,`spawntimesecs`,`animprogress`,`state`) VALUES
+(@OGUID+0,192129,571,1,1,6601.13,-1285.09,394.554,-0.951203,0,0,-0.951203,0.889017,0,0,0),
+(@OGUID+1,192130,571,1,1,6606.31,-1273.52,394.595,-0.854712,0.0864091,0.0250797,-0.416438,0.904701,0,0,0),
+(@OGUID+2,192131,571,1,1,6562.62,-1285.12,394.856,-0.95405,-0.0144057,0.0048542,-0.459116,0.888246,0,0,0);