diff options
| -rw-r--r-- | sql/updates/world/master/2022_01_25_02_world.sql | 217 |
1 files changed, 217 insertions, 0 deletions
diff --git a/sql/updates/world/master/2022_01_25_02_world.sql b/sql/updates/world/master/2022_01_25_02_world.sql new file mode 100644 index 00000000000..a4a46263084 --- /dev/null +++ b/sql/updates/world/master/2022_01_25_02_world.sql @@ -0,0 +1,217 @@ +-- +-- DB/Gameobject - Xmas Gift in Wizard's Sanctum ( and small surroundings ) + +SET @CGUID := 850235; +SET @OGUID := 500418; + +DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+93; +INSERT INTO `gameobject` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnDifficulties`, `PhaseId`, `PhaseGroup`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`, `VerifiedBuild`) VALUES +(@OGUID+0, 187235, 0, 1519, 5154, 0, 0, 0, -9055.580078125, 921.295166015625, 66.15769195556640625, 5.864306926727294921, 0, 0, -0.20791149139404296, 0.978147625923156738, 120, 255, 1, 41488), -- Standing, Exterior, Medium - Xmas (Area: 5154 - Difficulty: 0) +(@OGUID+1, 187235, 0, 1519, 5154, 0, 0, 0, -9002.96875, 877.66839599609375, 64.86025238037109375, 4.886923789978027343, 0, 0, -0.64278697967529296, 0.766044974327087402, 120, 255, 1, 41488), -- Standing, Exterior, Medium - Xmas (Area: 5154 - Difficulty: 0) +(@OGUID+2, 206080, 0, 1519, 5154, 0, 0, 0, -8933.8203125, 972.1929931640625, 117.4789962768554687, 3.420850038528442382, 0, 0, -0.99026775360107421, 0.139175355434417724, 120, 255, 1, 41488), -- XMasGift03 scale 1.5 (Area: 5154 - Difficulty: 0) +(@OGUID+3, 178429, 0, 1519, 5154, 0, 0, 0, -8917.740234375, 862.78497314453125, 101.9110031127929687, 5.340708732604980468, 0, 0, -0.45398998260498046, 0.891006767749786376, 120, 255, 1, 41488), -- XMasGift02 (Area: 5154 - Difficulty: 0) +(@OGUID+4, 178432, 0, 1519, 5154, 0, 0, 0, -8971.3603515625, 901.0419921875, 108.5279998779296875, 2.059488296508789062, 0, 0, 0.857167243957519531, 0.515038192272186279, 120, 255, 1, 41488), -- XMasGift05 (Area: 5154 - Difficulty: 0) +(@OGUID+5, 178432, 0, 1519, 5154, 0, 0, 0, -9004.1396484375, 865.53802490234375, 149.0319976806640625, 2.583080768585205078, 0, 0, 0.961260795593261718, 0.275640487670898437, 120, 255, 1, 41488), -- XMasGift05 (Area: 5154 - Difficulty: 0) +(@OGUID+6, 206084, 0, 1519, 5154, 0, 0, 0, -9013.8701171875, 842.13201904296875, 105.7659988403320312, 5.148722648620605468, 0, 0, -0.53729915618896484, 0.843391716480255126, 120, 255, 1, 41488), -- XMasGift04 scale 1.5 (Area: 5154 - Difficulty: 0) +(@OGUID+7, 178432, 0, 1519, 5154, 0, 0, 0, -9016.4501953125, 890.1090087890625, 29.62059974670410156, 1.029743075370788574, 0, 0, 0.492423057556152343, 0.870355963706970214, 120, 255, 1, 41488), -- XMasGift05 (Area: 5154 - Difficulty: 0) +(@OGUID+8, 206083, 0, 1519, 5154, 0, 0, 0, -9011.7802734375, 842.87200927734375, 105.845001220703125, 2.72271275520324707, 0, 0, 0.978147506713867187, 0.207912087440490722, 120, 255, 1, 41488), -- XMasGift01 scale 1.5 (Area: 5154 - Difficulty: 0) +(@OGUID+9, 178428, 0, 1519, 5154, 0, 0, 0, -8972.8896484375, 902.43597412109375, 108.5279998779296875, 0.174532130360603332, 0, 0, 0.087155342102050781, 0.996194720268249511, 120, 255, 1, 41488), -- XMasGift01 (Area: 5154 - Difficulty: 0) +(@OGUID+10, 206080, 0, 1519, 5154, 0, 0, 0, -9014.4404296875, 844.02099609375, 105.7559967041015625, 3.089183330535888671, 0, 0, 0.99965667724609375, 0.026201646775007247, 120, 255, 1, 41488), -- XMasGift03 scale 1.5 (Area: 5154 - Difficulty: 0) +(@OGUID+11, 206078, 0, 1519, 5154, 0, 0, 0, -9013.23046875, 845.60601806640625, 105.8519973754882812, 5.794494152069091796, 0, 0, -0.24192142486572265, 0.970295846462249755, 120, 255, 1, 41488), -- XMasGift02 scale 1.5 (Area: 5154 - Difficulty: 0) +(@OGUID+12, 187235, 0, 1519, 5154, 0, 0, 0, -9071.94140625, 887.44268798828125, 67.48587799072265625, 1.096506595611572265, 0, 0, 0.521197319030761718, 0.853436231613159179, 120, 255, 1, 41488), -- Standing, Exterior, Medium - Xmas (Area: 5154 - Difficulty: 0) +(@OGUID+13, 206084, 0, 1519, 5154, 0, 0, 0, -8990.1103515625, 845.85797119140625, 29.62059974670410156, 0.680676698684692382, 0, 0, 0.333806037902832031, 0.942641794681549072, 120, 255, 1, 41488), -- XMasGift04 scale 1.5 (Area: 5154 - Difficulty: 0) +(@OGUID+14, 187235, 0, 1519, 5154, 0, 0, 0, -8986.0263671875, 954.234375, 67.51596832275390625, 3.490974664688110351, 0, 0, -0.98478031158447265, 0.173803776502609252, 120, 255, 1, 41488), -- Standing, Exterior, Medium - Xmas (Area: 5154 - Difficulty: 0) +(@OGUID+15, 178428, 0, 1519, 5154, 0, 0, 0, -9020.900390625, 886.70098876953125, 29.62070083618164062, 0.977383077144622802, 0, 0, 0.469470977783203125, 0.882947921752929687, 120, 255, 1, 41488), -- XMasGift01 (Area: 5154 - Difficulty: 0) +(@OGUID+16, 178433, 0, 1519, 5154, 0, 0, 0, -8917.3701171875, 864.73297119140625, 101.9079971313476562, 1.012289404869079589, 0, 0, 0.484808921813964843, 0.87462007999420166, 120, 255, 1, 41488), -- XMasGift06 (Area: 5154 - Difficulty: 0) +(@OGUID+17, 178428, 0, 1519, 5154, 0, 0, 0, -8915.6396484375, 863.36297607421875, 101.90899658203125, 1.396261811256408691, 0, 0, 0.642786979675292968, 0.766044974327087402, 120, 255, 1, 41488), -- XMasGift01 (Area: 5154 - Difficulty: 0) +(@OGUID+18, 187235, 0, 1519, 5154, 0, 0, 0, -9079.9755859375, 898.69097900390625, 67.47487640380859375, 0.137406647205352783, 0, 0, 0.0686492919921875, 0.997640848159790039, 120, 255, 1, 41488), -- Standing, Exterior, Medium - Xmas (Area: 5154 - Difficulty: 0) +(@OGUID+19, 206079, 0, 1519, 5154, 0, 0, 0, -9011.7001953125, 844.56298828125, 105.8820037841796875, 3.508116960525512695, 0, 0, -0.98325443267822265, 0.182238012552261352, 120, 255, 1, 41488), -- XMasGift06 scale 1.5 (Area: 5154 - Difficulty: 0) +(@OGUID+20, 187235, 0, 1519, 5154, 0, 0, 0, -9021.5380859375, 901.03472900390625, 64.86025238037109375, 4.886923789978027343, 0, 0, -0.64278697967529296, 0.766044974327087402, 120, 255, 1, 41488), -- Standing, Exterior, Medium - Xmas (Area: 5154 - Difficulty: 0) +(@OGUID+21, 178431, 0, 1519, 5154, 0, 0, 0, -9003.9296875, 868.60400390625, 149.0319976806640625, 0.506144583225250244, 0, 0, 0.250379562377929687, 0.968147754669189453, 120, 255, 1, 41488), -- XMasGift04 (Area: 5154 - Difficulty: 0) +(@OGUID+22, 178431, 0, 1519, 5154, 0, 0, 0, -9017.33984375, 889.21502685546875, 29.62059974670410156, 3.577930212020874023, 0, 0, -0.97629547119140625, 0.216442063450813293, 120, 255, 1, 41488), -- XMasGift04 (Area: 5154 - Difficulty: 0) +(@OGUID+23, 187235, 0, 1519, 5154, 0, 0, 0, -9011.3037109375, 871.66143798828125, 64.86025238037109375, 5.864306926727294921, 0, 0, -0.20791149139404296, 0.978147625923156738, 120, 255, 1, 41488), -- Standing, Exterior, Medium - Xmas (Area: 5154 - Difficulty: 0) +(@OGUID+24, 178430, 0, 1519, 5154, 0, 0, 0, -9007.23046875, 868.989990234375, 149.0319976806640625, 4.188792228698730468, 0, 0, -0.86602497100830078, 0.50000077486038208, 120, 255, 1, 41488), -- XMasGift03 (Area: 5154 - Difficulty: 0) +(@OGUID+25, 178429, 0, 1519, 5154, 0, 0, 0, -8973.26953125, 901.22100830078125, 108.5279998779296875, 0, 0, 0, 0, 1, 120, 255, 1, 41488), -- XMasGift02 (Area: 5154 - Difficulty: 0) +(@OGUID+26, 178430, 0, 1519, 5154, 0, 0, 0, -8971.669921875, 902.57501220703125, 108.5279998779296875, 5.777040958404541015, 0, 0, -0.25037956237792968, 0.968147754669189453, 120, 255, 1, 41488), -- XMasGift03 (Area: 5154 - Difficulty: 0) +(@OGUID+27, 178432, 0, 1519, 5154, 0, 0, 0, -8985.419921875, 849.572998046875, 29.62070083618164062, 1.082102894783020019, 0, 0, 0.51503753662109375, 0.857167601585388183, 120, 255, 1, 41488), -- XMasGift05 (Area: 5154 - Difficulty: 0) +(@OGUID+28, 178430, 0, 1519, 5154, 0, 0, 0, -8989.150390625, 846.875, 29.62070083618164062, 0.139624491333961486, 0, 0, 0.06975555419921875, 0.997564136981964111, 120, 255, 1, 41488), -- XMasGift03 (Area: 5154 - Difficulty: 0) +(@OGUID+29, 178428, 0, 1519, 5154, 0, 0, 0, -9010.0595703125, 870.197998046875, 149.0319976806640625, 3.473210096359252929, 0, 0, -0.98628520965576171, 0.165049895644187927, 120, 255, 1, 41488), -- XMasGift01 (Area: 5154 - Difficulty: 0) +(@OGUID+30, 178433, 0, 1519, 5154, 0, 0, 0, -9007.6796875, 863.77801513671875, 149.0260009765625, 4.206246376037597656, 0, 0, -0.86162853240966796, 0.50753939151763916, 120, 255, 1, 41488), -- XMasGift06 (Area: 5154 - Difficulty: 0) +(@OGUID+31, 178431, 0, 1519, 5154, 0, 0, 0, -8972.2900390625, 900.57598876953125, 108.5279998779296875, 2.879789113998413085, 0, 0, 0.991444587707519531, 0.130528271198272705, 120, 255, 1, 41488), -- XMasGift04 (Area: 5154 - Difficulty: 0) +(@OGUID+32, 178431, 0, 1519, 5154, 0, 0, 0, -8915.6201171875, 862.38897705078125, 101.910003662109375, 5.672322273254394531, 0, 0, -0.3007049560546875, 0.953717231750488281, 120, 255, 1, 41488), -- XMasGift04 (Area: 5154 - Difficulty: 0) +(@OGUID+33, 178433, 0, 1519, 5154, 0, 0, 0, -8984.51953125, 850.4219970703125, 29.62070083618164062, 0.034906249493360519, 0, 0, 0.017452239990234375, 0.999847710132598876, 120, 255, 1, 41488), -- XMasGift06 (Area: 5154 - Difficulty: 0) +(@OGUID+34, 178430, 0, 1519, 5154, 0, 0, 0, -8916.5498046875, 862.1199951171875, 101.9110031127929687, 3.298687219619750976, 0, 0, -0.99691677093505859, 0.078466430306434631, 120, 255, 1, 41488), -- XMasGift03 (Area: 5154 - Difficulty: 0) +(@OGUID+35, 178431, 0, 1519, 5154, 0, 0, 0, -9013.6298828125, 865.99102783203125, 149.0319976806640625, 4.869470596313476562, 0, 0, -0.64944744110107421, 0.760406434535980224, 120, 255, 1, 41488), -- XMasGift04 (Area: 5154 - Difficulty: 0) +(@OGUID+36, 206079, 0, 1519, 5154, 0, 0, 0, -8932.01953125, 971.52398681640625, 117.3379974365234375, 1.832594871520996093, 0, 0, 0.793353080749511718, 0.608761727809906005, 120, 255, 1, 41488), -- XMasGift06 scale 1.5 (Area: 5154 - Difficulty: 0) +(@OGUID+37, 178428, 0, 1519, 5154, 0, 0, 0, -8918.080078125, 863.89398193359375, 101.90899658203125, 6.265733242034912109, 0, 0, -0.00872611999511718, 0.999961912631988525, 120, 255, 1, 41488), -- XMasGift01 (Area: 5154 - Difficulty: 0) +(@OGUID+38, 187235, 0, 1519, 5154, 0, 0, 0, -9029.875, 895.02777099609375, 64.86025238037109375, 5.864306926727294921, 0, 0, -0.20791149139404296, 0.978147625923156738, 120, 255, 1, 41488), -- Standing, Exterior, Medium - Xmas (Area: 5154 - Difficulty: 0) +(@OGUID+39, 178432, 0, 1519, 5154, 0, 0, 0, -8916.4296875, 864.14801025390625, 101.9079971313476562, 0.890116631984710693, 0, 0, 0.430510520935058593, 0.902585566043853759, 120, 255, 1, 41488), -- XMasGift05 (Area: 5154 - Difficulty: 0) +(@OGUID+40, 178433, 0, 1519, 5154, 0, 0, 0, -9015.1103515625, 867.90802001953125, 149.0319976806640625, 2.495818138122558593, 0, 0, 0.948323249816894531, 0.317305892705917358, 120, 255, 1, 41488), -- XMasGift06 (Area: 5154 - Difficulty: 0) +(@OGUID+41, 187235, 0, 1519, 5154, 0, 0, 0, -9041.0380859375, 932.81597900390625, 66.15769195556640625, 4.886923789978027343, 0, 0, -0.64278697967529296, 0.766044974327087402, 120, 255, 1, 41488), -- Standing, Exterior, Medium - Xmas (Area: 5154 - Difficulty: 0) +(@OGUID+42, 178429, 0, 1519, 5154, 0, 0, 0, -9011.1396484375, 864.47698974609375, 149.0319976806640625, 0, 0, 0, 0, 1, 120, 255, 1, 41488), -- XMasGift02 (Area: 5154 - Difficulty: 0) +(@OGUID+43, 178429, 0, 1519, 5154, 0, 0, 0, -9021.849609375, 886.0419921875, 29.62059974670410156, 4.939284324645996093, 0, 0, -0.6225137710571289, 0.78260880708694458, 120, 255, 1, 41488), -- XMasGift02 (Area: 5154 - Difficulty: 0) +(@OGUID+44, 187235, 0, 1519, 5154, 0, 0, 0, -8993.67578125, 964.9757080078125, 67.5161590576171875, 4.15491485595703125, 0, 0, -0.87436962127685546, 0.485260486602783203, 120, 255, 1, 41488), -- Standing, Exterior, Medium - Xmas (Area: 5154 - Difficulty: 0) +(@OGUID+45, 178428, 0, 1519, 5154, 0, 0, 0, -8994.1201171875, 790.343994140625, 104.022003173828125, 2.076939344406127929, 0, 0, 0.861628532409667968, 0.50753939151763916, 120, 255, 1, 41488), -- XMasGift01 (Area: 5154 - Difficulty: 0) +(@OGUID+46, 178431, 0, 1519, 5154, 0, 0, 0, -8993.099609375, 790.33001708984375, 104.022003173828125, 3.577930212020874023, 0, 0, -0.97629547119140625, 0.216442063450813293, 120, 255, 1, 41488), -- XMasGift04 (Area: 5154 - Difficulty: 0) +(@OGUID+47, 178431, 0, 1519, 5154, 0, 0, 0, -8994.76953125, 789.36297607421875, 104.022003173828125, 4.48549652099609375, 0, 0, -0.7826080322265625, 0.622514784336090087, 120, 255, 1, 41488), -- XMasGift04 (Area: 5154 - Difficulty: 0) +(@OGUID+48, 178432, 0, 1519, 5154, 0, 0, 0, -8992.669921875, 789.29901123046875, 104.022003173828125, 2.321286916732788085, 0, 0, 0.917059898376464843, 0.398749500513076782, 120, 255, 1, 41488), -- XMasGift05 (Area: 5154 - Difficulty: 0) +(@OGUID+49, 178433, 0, 1519, 5154, 0, 0, 0, -8993.6396484375, 788.64599609375, 104.022003173828125, 4.607671737670898437, 0, 0, -0.74314403533935546, 0.669131457805633544, 120, 255, 1, 41488), -- XMasGift06 (Area: 5154 - Difficulty: 0) +(@OGUID+50, 206083, 0, 1519, 5154, 0, 0, 0, -8912.9697265625, 792.18402099609375, 102.839996337890625, 1.082102894783020019, 0, 0, 0.51503753662109375, 0.857167601585388183, 120, 255, 1, 41488), -- XMasGift01 scale 1.5 (Area: 5154 - Difficulty: 0) +(@OGUID+51, 178431, 0, 1519, 5154, 0, 0, 0, -8884.5, 824.07098388671875, 94.85489654541015625, 2.72271275520324707, 0, 0, 0.978147506713867187, 0.207912087440490722, 120, 255, 1, 41488), -- XMasGift04 (Area: 5154 - Difficulty: 0) +(@OGUID+52, 206083, 0, 1519, 5154, 0, 0, 0, -8909.2099609375, 792.5830078125, 102.839996337890625, 3.368495941162109375, 0, 0, -0.99357128143310546, 0.113208353519439697, 120, 255, 1, 41488), -- XMasGift01 scale 1.5 (Area: 5154 - Difficulty: 0) +(@OGUID+53, 206084, 0, 1519, 5154, 0, 0, 0, -8910.4296875, 793.42901611328125, 102.839996337890625, 5.829400539398193359, 0, 0, -0.22495079040527343, 0.974370121955871582, 120, 255, 1, 41488), -- XMasGift04 scale 1.5 (Area: 5154 - Difficulty: 0) +(@OGUID+54, 206082, 0, 1519, 5154, 0, 0, 0, -8911.8603515625, 793.25299072265625, 102.839996337890625, 3.036838293075561523, 0, 0, 0.998628616333007812, 0.052353221923112869, 120, 255, 1, 41488), -- XMasGift05 scale 1.5 (Area: 5154 - Difficulty: 0) +(@OGUID+55, 206080, 0, 1519, 5154, 0, 0, 0, -8908.98046875, 790.12799072265625, 102.839996337890625, 2.268925428390502929, 0, 0, 0.906307220458984375, 0.422619491815567016, 120, 255, 1, 41488), -- XMasGift03 scale 1.5 (Area: 5154 - Difficulty: 0) +(@OGUID+56, 206079, 0, 1519, 5154, 0, 0, 0, -8910.8701171875, 789.9840087890625, 102.839996337890625, 6.056293010711669921, 0, 0, -0.11320304870605468, 0.993571877479553222, 120, 255, 1, 41488), -- XMasGift06 scale 1.5 (Area: 5154 - Difficulty: 0) +(@OGUID+57, 178432, 0, 1519, 5154, 0, 0, 0, -8883.5595703125, 826.56402587890625, 95.59439849853515625, 5.742135047912597656, 0, 0, -0.26723766326904296, 0.96363067626953125, 120, 255, 1, 41488), -- XMasGift05 (Area: 5154 - Difficulty: 0) +(@OGUID+58, 206080, 0, 1519, 5154, 0, 0, 0, -8885.919921875, 825.38897705078125, 93.8927001953125, 4.607671737670898437, 0, 0, -0.74314403533935546, 0.669131457805633544, 120, 255, 1, 41488), -- XMasGift03 scale 1.5 (Area: 5154 - Difficulty: 0) +(@OGUID+59, 206078, 0, 1519, 5154, 0, 0, 0, -8912.3095703125, 790.655029296875, 102.839996337890625, 2.216565132141113281, 0, 0, 0.894933700561523437, 0.44619917869567871, 120, 255, 1, 41488), -- XMasGift02 scale 1.5 (Area: 5154 - Difficulty: 0) +(@OGUID+60, 178432, 0, 1519, 5154, 0, 0, 0, -8935.0498046875, 766.10400390625, 91.0619964599609375, 0.890116631984710693, 0, 0, 0.430510520935058593, 0.902585566043853759, 120, 255, 1, 41488), -- XMasGift05 (Area: 5154 - Difficulty: 0) +(@OGUID+61, 178430, 0, 1519, 5154, 0, 0, 0, -8932.599609375, 766.25299072265625, 92.8199005126953125, 0.645771682262420654, 0, 0, 0.317304611206054687, 0.948323667049407958, 120, 255, 1, 41488), -- XMasGift03 (Area: 5154 - Difficulty: 0) +(@OGUID+62, 178428, 0, 1519, 5154, 0, 0, 0, -8931.0595703125, 767.3070068359375, 92.998199462890625, 3.473210096359252929, 0, 0, -0.98628520965576171, 0.165049895644187927, 120, 255, 1, 41488), -- XMasGift01 (Area: 5154 - Difficulty: 0) +(@OGUID+63, 178433, 0, 1519, 5154, 0, 0, 0, -8931.080078125, 767.34698486328125, 92.5858001708984375, 0.698131442070007324, 0, 0, 0.342020034790039062, 0.939692676067352294, 120, 255, 1, 41488), -- XMasGift06 (Area: 5154 - Difficulty: 0) +(@OGUID+64, 178434, 0, 1519, 5154, 0, 0, 0, -9084.701171875, 829.404541015625, 114.6363906860351562, 0.24434557557106018, 0, 0, 0.121869087219238281, 0.9925462007522583, 120, 255, 1, 41488), -- XMasStocking01 (Area: 5154 - Difficulty: 0) +(@OGUID+65, 178434, 0, 1519, 5154, 0, 0, 0, -9082.40234375, 823.7103271484375, 114.6355133056640625, 0.349065244197845458, 0, 0, 0.173647880554199218, 0.984807789325714111, 120, 255, 1, 41488), -- XMasStocking01 (Area: 5154 - Difficulty: 0) +(@OGUID+66, 178435, 0, 1519, 5154, 0, 0, 0, -9082.826171875, 824.7569580078125, 114.6065292358398437, 0.27925160527229309, 0, 0, 0.139172554016113281, 0.990268170833587646, 120, 255, 1, 41488), -- XMasStocking02 (Area: 5154 - Difficulty: 0) +(@OGUID+67, 178436, 0, 1519, 5154, 0, 0, 0, -9083.2421875, 825.79010009765625, 114.625030517578125, 0.401424884796142578, 0, 0, 0.199367523193359375, 0.979924798011779785, 120, 255, 1, 41488), -- XMasStocking03 (Area: 5154 - Difficulty: 0) +(@OGUID+68, 178436, 0, 1519, 5154, 0, 0, 0, -9085.091796875, 830.36846923828125, 114.6104507446289062, 0.366517573595046997, 0, 0, 0.182234764099121093, 0.98325502872467041, 120, 255, 1, 41488), -- XMasStocking03 (Area: 5154 - Difficulty: 0) +(@OGUID+69, 206084, 0, 1519, 10523, 0, 0, 0, -8934.1396484375, 974.04302978515625, 117.7440032958984375, 5.532694816589355468, 0, 0, -0.3665008544921875, 0.93041771650314331, 120, 255, 1, 41488), -- XMasGift04 scale 1.5 (Area: 10523 - Difficulty: 0) +(@OGUID+70, 206083, 0, 1519, 10523, 0, 0, 0, -8930.8896484375, 972.97198486328125, 117.3850021362304687, 3.94444584846496582, 0, 0, -0.92050457000732421, 0.3907318115234375, 120, 255, 1, 41488), -- XMasGift01 scale 1.5 (Area: 10523 - Difficulty: 0) +(@OGUID+71, 206078, 0, 1519, 10523, 0, 0, 0, -8931.08984375, 974.85198974609375, 117.759002685546875, 2.844882726669311523, 0, 0, 0.989015579223632812, 0.147811368107795715, 120, 255, 1, 41488), -- XMasGift02 scale 1.5 (Area: 10523 - Difficulty: 0) +(@OGUID+72, 206082, 0, 1519, 10523, 0, 0, 0, -8932.8798828125, 975.04302978515625, 117.8720016479492187, 1.762782454490661621, 0, 0, 0.771624565124511718, 0.636078238487243652, 120, 255, 1, 41488), -- XMasGift05 scale 1.5 (Area: 10523 - Difficulty: 0) +-- Boralus +(@OGUID+73, 187567, 1643, 8717, 10017, 0, 0, 0, 1054.15283203125, -470.18402099609375, 15.95283985137939453, 3.024193286895751953, 0, 0, 0.998277664184570312, 0.058665931224822998, 7200, 255, 1, 41488), -- Hanging, Streamer - Xmas (Area: 10017 - Difficulty: 0) +(@OGUID+74, 187235, 1643, 8717, 10017, 0, 0, 0, 1147.8489990234375, -470.8125, 30.41956520080566406, 4.90132904052734375, 0, 0, -0.6372528076171875, 0.770654797554016113, 7200, 255, 1, 41488), -- Standing, Exterior, Medium - Xmas (Area: 10017 - Difficulty: 0) +(@OGUID+75, 187567, 1643, 8717, 10017, 0, 0, 0, 1122.1978759765625, -529.6492919921875, 21.87565231323242187, 2.670159578323364257, 0, 0, 0.972347259521484375, 0.233539745211601257, 7200, 255, 1, 41488), -- Hanging, Streamer - Xmas (Area: 10017 - Difficulty: 0) +(@OGUID+76, 187235, 1643, 8717, 10017, 0, 0, 0, 1124.8350830078125, -595.984375, 17.28391075134277343, 2.185654163360595703, 0, 0, 0.887930870056152343, 0.459976941347122192, 7200, 255, 1, 41488), -- Standing, Exterior, Medium - Xmas (Area: 10017 - Difficulty: 0) +(@OGUID+77, 187235, 1643, 8717, 10017, 0, 0, 0, 1196.15283203125, -524.21356201171875, 28.74283599853515625, 4.967881202697753906, 0, 0, -0.61126041412353515, 0.791429519653320312, 7200, 255, 1, 41488), -- Standing, Exterior, Medium - Xmas (Area: 10017 - Difficulty: 0) +(@OGUID+78, 187567, 1643, 8717, 10017, 0, 0, 0, 1080.8958740234375, -500.401031494140625, 24.55152702331542968, 4.41634368896484375, 0, 0, -0.80366039276123046, 0.595088183879852294, 7200, 255, 1, 41488), -- Hanging, Streamer - Xmas (Area: 10017 - Difficulty: 0) +(@OGUID+79, 187235, 1643, 8717, 10017, 0, 0, 0, 1169.8836669921875, -569.23785400390625, 28.90155982971191406, 3.182281494140625, 0, 0, -0.99979305267333984, 0.020342936739325523, 7200, 255, 1, 41488), -- Standing, Exterior, Medium - Xmas (Area: 10017 - Difficulty: 0) +(@OGUID+80, 187235, 1643, 8717, 10017, 0, 0, 0, 1134.4791259765625, -566.74481201171875, 17.30657386779785156, 3.742372512817382812, 0, 0, -0.95522117614746093, 0.295892685651779174, 7200, 255, 1, 41488), -- Standing, Exterior, Medium - Xmas (Area: 10017 - Difficulty: 0) +(@OGUID+81, 187235, 1643, 8717, 10017, 0, 0, 0, 1222.9410400390625, -554.6788330078125, 29.98164939880371093, 4.592316150665283203, 0, 0, -0.74825954437255859, 0.663406074047088623, 7200, 255, 1, 41488), -- Standing, Exterior, Medium - Xmas (Area: 10017 - Difficulty: 0) +(@OGUID+82, 187567, 1643, 8717, 10017, 0, 0, 0, 1166.7379150390625, -584.8836669921875, 35.39265823364257812, 2.939209222793579101, 0, 0, 0.994884490966796875, 0.101019062101840972, 7200, 255, 1, 41488), -- Hanging, Streamer - Xmas (Area: 10017 - Difficulty: 0) +(@OGUID+83, 187194, 1643, 8717, 10017, 0, 0, 0, 1100.65283203125, -539.0225830078125, 24.90980339050292968, 5.849834918975830078, 0, 0, -0.21498394012451171, 0.97661757469177246, 7200, 255, 1, 41488), -- Hanging, Streamer x3 - Xmas (Area: 10017 - Difficulty: 0) +(@OGUID+84, 187567, 1643, 8717, 10017, 0, 0, 0, 1166.59033203125, -595.484375, 35.34235763549804687, 2.996555328369140625, 0, 0, 0.997371673583984375, 0.072455078363418579, 7200, 255, 1, 41488), -- Hanging, Streamer - Xmas (Area: 10017 - Difficulty: 0) +(@OGUID+85, 187235, 1643, 8717, 10017, 0, 0, 0, 1091.1492919921875, -475.6788330078125, 20.33893203735351562, 3.972543239593505859, 0, 0, -0.91492462158203125, 0.403624773025512695, 7200, 255, 1, 41488), -- Standing, Exterior, Medium - Xmas (Area: 10017 - Difficulty: 0) +(@OGUID+86, 187235, 1643, 8717, 10017, 0, 0, 0, 1164.57470703125, -600.5086669921875, 28.87758064270019531, 3.041571378707885742, 0, 0, 0.998749732971191406, 0.049989841878414154, 7200, 255, 1, 41488), -- Standing, Exterior, Medium - Xmas (Area: 10017 - Difficulty: 0) +(@OGUID+87, 187567, 1643, 8717, 10017, 0, 0, 0, 1170.157958984375, -574.76043701171875, 35.57342147827148437, 2.990242481231689453, 0, 0, 0.997138023376464843, 0.075602829456329345, 7200, 255, 1, 41488), -- Hanging, Streamer - Xmas (Area: 10017 - Difficulty: 0) +(@OGUID+88, 187235, 1643, 8717, 10017, 0, 0, 0, 1148.1910400390625, -581.8524169921875, 20.48902511596679687, 3.052124738693237304, 0, 0, 0.998999595642089843, 0.044719073921442031, 7200, 255, 1, 41488), -- Standing, Exterior, Medium - Xmas (Area: 10017 - Difficulty: 0) +(@OGUID+89, 187567, 1643, 8717, 10017, 0, 0, 0, 1228.595458984375, -502.6788330078125, 38.58544921875, 4.2884674072265625, 0, 0, -0.84004116058349609, 0.542522668838500976, 7200, 255, 1, 41488), -- Hanging, Streamer - Xmas (Area: 10017 - Difficulty: 0) +(@OGUID+90, 187235, 1643, 8717, 10017, 0, 0, 0, 1166.4114990234375, -629.578125, 29.00293731689453125, 5.093719959259033203, 0, 0, -0.5602874755859375, 0.828298211097717285, 7200, 255, 1, 41488), -- Standing, Exterior, Medium - Xmas (Area: 10017 - Difficulty: 0) +-- Paw'don Village +(@OGUID+91, 187194, 870, 5785, 6516, 0, 0, 0, -286.263885498046875, -1681.795166015625, 60.05602264404296875, 3.148900747299194335, 0, 0, -0.99999332427978515, 0.003653962397947907, 120, 255, 1, 41488), -- Hanging, Streamer x3 - Xmas (Area: 6516 - Difficulty: 0) +(@OGUID+92, 187567, 870, 5785, 6516, 0, 0, 0, -271.588531494140625, -1681.6927490234375, 59.18248367309570312, 3.138830423355102539, 0, 0, 0.999999046325683593, 0.001381067908369004, 120, 255, 1, 41488), -- Hanging, Streamer - Xmas (Area: 6516 - Difficulty: 0) +(@OGUID+93, 187191, 870, 5785, 6516, 0, 0, 0, -285.645843505859375, -1685.3629150390625, 53.10683822631835937, 3.173687219619750976, 0, 0, -0.99987125396728515, 0.016046559438109397, 120, 255, 1, 41488); -- Standing, Exterior, Medium - Xmas (Area: 6516 - Difficulty: 0) + +UPDATE `gameobject_template_addon` SET `faction`=114 WHERE `entry`=187191; -- Standing, Exterior, Medium - Xmas + +DELETE FROM `game_event_gameobject` WHERE `eventEntry`=2 AND `guid` BETWEEN @OGUID+0 AND @OGUID+93; +INSERT INTO `game_event_gameobject` (`eventEntry`, `guid`) VALUES +(2, @OGUID+0), +(2, @OGUID+1), +(2, @OGUID+2), +(2, @OGUID+3), +(2, @OGUID+4), +(2, @OGUID+5), +(2, @OGUID+6), +(2, @OGUID+7), +(2, @OGUID+8), +(2, @OGUID+9), +(2, @OGUID+10), +(2, @OGUID+11), +(2, @OGUID+12), +(2, @OGUID+13), +(2, @OGUID+14), +(2, @OGUID+15), +(2, @OGUID+16), +(2, @OGUID+17), +(2, @OGUID+18), +(2, @OGUID+19), +(2, @OGUID+20), +(2, @OGUID+21), +(2, @OGUID+22), +(2, @OGUID+23), +(2, @OGUID+24), +(2, @OGUID+25), +(2, @OGUID+26), +(2, @OGUID+27), +(2, @OGUID+28), +(2, @OGUID+29), +(2, @OGUID+30), +(2, @OGUID+31), +(2, @OGUID+32), +(2, @OGUID+33), +(2, @OGUID+34), +(2, @OGUID+35), +(2, @OGUID+36), +(2, @OGUID+37), +(2, @OGUID+38), +(2, @OGUID+39), +(2, @OGUID+40), +(2, @OGUID+41), +(2, @OGUID+42), +(2, @OGUID+43), +(2, @OGUID+44), +(2, @OGUID+45), +(2, @OGUID+46), +(2, @OGUID+47), +(2, @OGUID+48), +(2, @OGUID+49), +(2, @OGUID+50), +(2, @OGUID+51), +(2, @OGUID+52), +(2, @OGUID+53), +(2, @OGUID+54), +(2, @OGUID+55), +(2, @OGUID+56), +(2, @OGUID+57), +(2, @OGUID+58), +(2, @OGUID+59), +(2, @OGUID+60), +(2, @OGUID+61), +(2, @OGUID+62), +(2, @OGUID+63), +(2, @OGUID+64), +(2, @OGUID+65), +(2, @OGUID+66), +(2, @OGUID+67), +(2, @OGUID+68), +(2, @OGUID+69), +(2, @OGUID+70), +(2, @OGUID+71), +(2, @OGUID+72), +(2, @OGUID+73), +(2, @OGUID+74), +(2, @OGUID+75), +(2, @OGUID+76), +(2, @OGUID+77), +(2, @OGUID+78), +(2, @OGUID+79), +(2, @OGUID+80), +(2, @OGUID+81), +(2, @OGUID+82), +(2, @OGUID+83), +(2, @OGUID+84), +(2, @OGUID+85), +(2, @OGUID+86), +(2, @OGUID+87), +(2, @OGUID+88), +(2, @OGUID+89), +(2, @OGUID+90), +(2, @OGUID+91), +(2, @OGUID+92), +(2, @OGUID+93); + +DELETE FROM `game_event_creature` WHERE `eventEntry`=2 AND `guid` BETWEEN @CGUID+0 AND @CGUID+3; +INSERT INTO `game_event_creature` (`eventEntry`, `guid`) VALUES +(2, @CGUID+0), +(2, @CGUID+1), +(2, @CGUID+2), +(2, @CGUID+3); + +DELETE FROM `creature` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+3; +INSERT INTO `creature` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnDifficulties`, `PhaseId`, `PhaseGroup`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `wander_distance`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `VerifiedBuild`) VALUES +(@CGUID+0, 68, 0, 1519, 10523, 0, 0, 0, 0, 1, -9043.5400390625, 943.0538330078125, 71.2750701904296875, 5.598035335540771484, 120, 0, 0, 17687, 0, 0, 0, 0, 0, 41488), -- Stormwind City Guard (Area: Wizard's Sanctum - Difficulty: 0) (Auras: ) +(@CGUID+1, 68, 0, 1519, 10523, 0, 0, 0, 0, 1, -8996.3701171875, 867.7117919921875, 66.052978515625, 2.761093545379638671, 120, 0, 0, 17687, 0, 0, 0, 0, 0, 41488), -- Stormwind City Guard (Area: Wizard's Sanctum - Difficulty: 0) (Auras: ) +(@CGUID+2, 68, 0, 1519, 10523, 0, 0, 0, 0, 1, -9004.0537109375, 861.99481201171875, 66.0471954345703125, 1.797322630882263183, 120, 0, 0, 17687, 0, 0, 0, 0, 0, 41488), -- Stormwind City Guard (Area: Wizard's Sanctum - Difficulty: 0) (Auras: ) +(@CGUID+3, 68, 0, 1519, 10523, 0, 0, 0, 0, 1, -9003.6796875, 875.42401123046875, 138.6773223876953125, 3.818507671356201171, 120, 0, 0, 17687, 0, 0, 0, 0, 0, 41488); -- Stormwind City Guard (Area: Wizard's Sanctum - Difficulty: 0) (Auras: ) // missing the WP - insert manualy!// |