diff options
| -rw-r--r-- | sql/updates/world/2016_01_01_01_world.sql | 23 |
1 files changed, 23 insertions, 0 deletions
diff --git a/sql/updates/world/2016_01_01_01_world.sql b/sql/updates/world/2016_01_01_01_world.sql new file mode 100644 index 00000000000..c7ba115b05a --- /dev/null +++ b/sql/updates/world/2016_01_01_01_world.sql @@ -0,0 +1,23 @@ +-- +SET @guid=452381; +DELETE FROM `creature` WHERE `guid` BETWEEN @guid+0 AND @guid+17; +INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseid`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`) VALUES +(@guid+0, 63332, 530, 1, 0, 0, 0, 10379.151, -6398.188, 38.531, 3.708341, 300, 0, 0, 0, 0, 0), +(@guid+1, 63080, 530, 1, 0, 0, 0, 9486.943, -6819.356, 16.493, 0.514870, 300, 0, 0, 0, 0, 0), +(@guid+2, 63079, 530, 1, 0, 0, 0, 9488.086, -6821.064, 17.628, 0.299912, 300, 0, 0, 0, 0, 0), +(@guid+3, 68430, 530, 1, 0, 0, 0, 9890.543, -7449.714, 14.966, 1.687187, 300, 0, 0, 0, 0, 0), +(@guid+4, 68086, 530, 1, 0, 0, 0, 9848.347, -7518.210, -9.152, 5.847883, 300, 0, 0, 0, 0, 0), +(@guid+5, 68276, 530, 1, 0, 0, 0, 9844.277, -7526.379, -8.067, 0.434075, 300, 0, 0, 0, 0, 0), +(@guid+6, 68276, 530, 1, 0, 0, 0, 9852.936, -7529.648, -8.071, 1.660291, 300, 0, 0, 0, 0, 0), +(@guid+7, 68276, 530, 1, 0, 0, 0, 9847.937, -7529.427, -8.071, 0.944793, 300, 0, 0, 0, 0, 0), +(@guid+8, 68276, 530, 1, 0, 0, 0, 9857.380, -7526.445, -8.071, 2.448826, 300, 0, 0, 0, 0, 0), +(@guid+9, 68085, 530, 1, 0, 0, 0, 9853.958, -7518.784, -9.152, 3.515100, 300, 0, 0, 0, 0, 0), +(@guid+10, 68084, 530, 1, 0, 0, 0, 9850.879, -7503.450, -4.005, 4.843180, 300, 0, 0, 0, 0, 0), +(@guid+11, 51796, 530, 1, 0, 0, 0, 9845.608, -7503.384, -4.006, 4.791539, 300, 0, 0, 0, 0, 0), +(@guid+12, 51796, 530, 1, 0, 0, 0, 9855.984, -7503.353, -4.002, 4.722929, 300, 0, 0, 0, 0, 0), +(@guid+13, 51796, 530, 1, 0, 0, 0, 9839.472, -7513.527, -8.052, 0.155999, 300, 0, 0, 0, 0, 0), +(@guid+14, 51796, 530, 1, 0, 0, 0, 9862.469, -7513.807, -8.053, 3.122978, 300, 0, 0, 0, 0, 0), +(@guid+15, 51796, 530, 1, 0, 0, 0, 9866.782, -7523.892, -8.075, 3.248112, 300, 0, 0, 0, 0, 0), +(@guid+16, 51796, 530, 1, 0, 0, 0, 9834.982, -7523.855, -8.076, 6.242112, 300, 0, 0, 0, 0, 0), +(@guid+17, 62463, 530, 1, 0, 0, 0, 9831.922, -7406.591, 13.620, 1.300136, 300, 0, 0, 0, 0, 0); +UPDATE `creature_template` SET `InhabitType`=4 WHERE `entry`=63079; |