diff options
author | Killyana <morphone1@gmail.com> | 2017-06-11 11:58:38 +0200 |
---|---|---|
committer | Killyana <morphone1@gmail.com> | 2017-06-11 11:58:38 +0200 |
commit | c210b935942f8f2202f1436f2cf73821614c041d (patch) | |
tree | ee465d051858c9a09f1ccdb81be86eb59b2119d8 | |
parent | b58a364192ee3e30fa8e58f1aca617780321000b (diff) |
DB/Creature: Respawn The Howling Hollow cave
-rw-r--r-- | sql/updates/world/3.3.5/2017_06_11_00_world.sql | 221 |
1 files changed, 221 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2017_06_11_00_world.sql b/sql/updates/world/3.3.5/2017_06_11_00_world.sql new file mode 100644 index 00000000000..7fa7efac78a --- /dev/null +++ b/sql/updates/world/3.3.5/2017_06_11_00_world.sql @@ -0,0 +1,221 @@ +-- +DELETE FROM `creature_addon` WHERE `guid` IN (SELECT `guid` FROM `creature` WHERE `id` IN (30480, 30184)); +DELETE FROM `creature` WHERE `id` IN (30480, 30184); +SET @cguid:= 146875; +DELETE FROM `creature` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+105; +INSERT INTO `creature` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `VerifiedBuild`) VALUES +(@CGUID+0, 30480, 571, 0, 0, 1, 1, 0, 0, 8333.128, -2903.362, 1068.744, 3.473205, 300, 0, 0, 1, 0, 0, 0, 0, 0, -1), +(@CGUID+1, 30480, 571, 0, 0, 1, 1, 0, 0, 8330.487, -2717.754, 1041.095, 4.462733, 300, 0, 0, 1, 0, 0, 0, 0, 0, -1), +(@CGUID+2, 30480, 571, 0, 0, 1, 1, 0, 0, 8287.573, -2697.128, 1034.31, 5.717384, 300, 5, 0, 1, 0, 1, 0, 0, 0, -1), +(@CGUID+3, 30480, 571, 0, 0, 1, 1, 0, 0, 8228.237, -2751.234, 1038.534, 0.1570796, 300, 0, 0, 1, 0, 0, 0, 0, 0, -1), +(@CGUID+4, 30480, 571, 0, 0, 1, 1, 0, 0, 8209.119, -2872.845, 1137.894, 4.904375, 300, 0, 0, 1, 0, 0, 0, 0, 0, -1), +(@CGUID+5, 30480, 571, 0, 0, 1, 1, 0, 0, 8121.109, -2843.202, 1043.863, 1.937315, 300, 0, 0, 1, 0, 0, 0, 0, 0, -1), +(@CGUID+6, 30480, 571, 0, 0, 1, 1, 0, 0, 8143.087, -2823.755, 1058.856, 3.857178, 300, 0, 0, 1, 0, 0, 0, 0, 0, -1), +(@CGUID+7, 30480, 571, 0, 0, 1, 1, 0, 0, 8184.026, -2891.668, 1149.39, 1.692969, 300, 0, 0, 1, 0, 0, 0, 0, 0, -1), +(@CGUID+8, 30480, 571, 0, 0, 1, 1, 0, 0, 8188.662, -2878.425, 1145.069, 0.05235988, 300, 0, 0, 1, 0, 0, 0, 0, 0, -1), +(@CGUID+9, 30480, 571, 0, 0, 1, 1, 0, 0, 8192.58, -2919.089, 1096.676, 1.43117, 300, 0, 0, 1, 0, 0, 0, 0, 0, -1), +(@CGUID+10, 30480, 571, 0, 0, 1, 1, 0, 0, 8159.454, -2934.026, 1077.732, 5.480334, 300, 0, 0, 1, 0, 0, 0, 0, 0, -1), +(@CGUID+11, 30480, 571, 0, 0, 1, 1, 0, 0, 8129.237, -2932.143, 1050.447, 5.143166, 300, 5, 0, 1, 0, 1, 0, 0, 0, -1), +(@CGUID+12, 30480, 571, 0, 0, 1, 1, 0, 0, 8198.808, -2925.632, 1069.171, 2.164208, 300, 0, 0, 1, 0, 0, 0, 0, 0, -1), +(@CGUID+13, 30480, 571, 0, 0, 1, 1, 0, 0, 8152.688, -2913.714, 1050.729, 0.1745329, 300, 0, 0, 1, 0, 0, 0, 0, 0, -1), +(@CGUID+14, 30480, 571, 0, 0, 1, 1, 0, 0, 8255.467, -2890.938, 1079.425, 1.466077, 300, 0, 0, 1, 0, 0, 0, 0, 0, -1), +(@CGUID+15, 30480, 571, 0, 0, 1, 1, 0, 0, 8203.503, -2921.417, 1083.54, 3.892084, 300, 0, 0, 1, 0, 0, 0, 0, 0, -1), +(@CGUID+16, 30480, 571, 0, 0, 1, 1, 0, 0, 8109.108, -2809.142, 1046.794, 5.609255, 300, 0, 0, 1, 0, 0, 0, 0, 0, -1), +(@CGUID+17, 30480, 571, 0, 0, 1, 1, 0, 0, 8076.773, -2789.469, 1049.373, 2.788602, 300, 5, 0, 1, 0, 1, 0, 0, 0, -1), +(@CGUID+18, 30480, 571, 0, 0, 1, 1, 0, 0, 8134.914, -2947.357, 1050.098, 6.161012, 300, 5, 0, 1, 0, 1, 0, 0, 0, -1), +(@CGUID+19, 30480, 571, 0, 0, 1, 1, 0, 0, 8165.256, -2956.116, 1047.651, 2.899055, 300, 5, 0, 1, 0, 1, 0, 0, 0, -1), +(@CGUID+20, 30480, 571, 0, 0, 1, 1, 0, 0, 8175.625, -2958.203, 1076.234, 1.53589, 300, 0, 0, 1, 0, 0, 0, 0, 0, -1), +(@CGUID+21, 30480, 571, 0, 0, 1, 1, 0, 0, 8173.049, -2973.095, 1116.792, 3.403392, 300, 0, 0, 1, 0, 0, 0, 0, 0, -1), +(@CGUID+22, 30480, 571, 0, 0, 1, 1, 0, 0, 8204.446, -2960.962, 1131.007, 4.014257, 300, 0, 0, 1, 0, 0, 0, 0, 0, -1), +(@CGUID+23, 30480, 571, 0, 0, 1, 1, 0, 0, 8198.573, -2997.332, 1120.538, 2.286381, 300, 0, 0, 1, 0, 0, 0, 0, 0, -1), +(@CGUID+24, 30480, 571, 0, 0, 1, 1, 0, 0, 8275.124, -2990.278, 1093.974, 0.7679449, 300, 0, 0, 1, 0, 0, 0, 0, 0, -1), +(@CGUID+25, 30480, 571, 0, 0, 1, 1, 0, 0, 8253.583, -2964.561, 1104.999, 4.153883, 300, 0, 0, 1, 0, 0, 0, 0, 0, -1), +(@CGUID+26, 30480, 571, 0, 0, 1, 1, 0, 0, 8231.741, -2976.32, 1104.101, 3.159046, 300, 0, 0, 1, 0, 0, 0, 0, 0, -1), +(@CGUID+27, 30480, 571, 0, 0, 1, 1, 0, 0, 8248.804, -2908.997, 1113.022, 0.9075712, 300, 0, 0, 1, 0, 0, 0, 0, 0, -1), +(@CGUID+28, 30480, 571, 0, 0, 1, 1, 0, 0, 8166.316, -3031.054, 1140.686, 2.251475, 300, 0, 0, 1, 0, 0, 0, 0, 0, -1), +(@CGUID+29, 30480, 571, 0, 0, 1, 1, 0, 0, 8230.317, -3027.78, 1110.11, 5.497787, 300, 0, 0, 1, 0, 0, 0, 0, 0, -1), +(@CGUID+30, 30480, 571, 0, 0, 1, 1, 0, 0, 8328.509, -2980.29, 1103.399, 1.658063, 300, 0, 0, 1, 0, 0, 0, 0, 0, -1), +(@CGUID+31, 30480, 571, 0, 0, 1, 1, 0, 0, 8329.896, -3020.376, 1097.522, 0.108798, 300, 0, 0, 1, 0, 0, 0, 0, 0, -1), +(@CGUID+32, 30480, 571, 0, 0, 1, 1, 0, 0, 8311.867, -3029.356, 1088.721, 0.5934119, 300, 0, 0, 1, 0, 0, 0, 0, 0, -1), +(@CGUID+33, 30480, 571, 0, 0, 1, 1, 0, 0, 8325.837, -3016.618, 1074.813, 0.3490658, 300, 0, 0, 1, 0, 0, 0, 0, 0, -1), +(@CGUID+34, 30480, 571, 0, 0, 1, 1, 0, 0, 8232.760, -3090.918, 1134.23, 4.548754, 300, 0, 0, 1, 0, 0, 0, 0, 0, -1), +(@CGUID+35, 30480, 571, 0, 0, 1, 1, 0, 0, 8099.323, -2728.992, 1034.551, 2.216964, 300, 0, 0, 1, 0, 0, 0, 0, 0, -1), +(@CGUID+36, 30480, 571, 0, 0, 1, 1, 0, 0, 8087.157, -2735.235, 1028.690, 0.006067, 300, 0, 0, 1, 0, 0, 0, 0, 0, -1), +(@CGUID+37, 30480, 571, 0, 0, 1, 1, 0, 0, 8086.219, -2769.601, 1045.349, 5.751256, 300, 0, 0, 1, 0, 0, 0, 0, 0, -1), +(@CGUID+38, 30480, 571, 0, 0, 1, 1, 0, 0, 8176.860, -2798.434, 1040.756, 0.349065, 300, 5, 0, 1, 0, 1, 0, 0, 0, -1), +(@CGUID+39, 30480, 571, 0, 0, 1, 1, 0, 0, 8148.965, -2700.519, 1045.140, 4.350090, 300, 0, 0, 1, 0, 0, 0, 0, 0, -1), +(@CGUID+40, 30480, 571, 0, 0, 1, 1, 0, 0, 8110.428, -2712.903, 1027.698, 4.350090, 300, 5, 0, 1, 0, 1, 0, 0, 0, -1), +(@CGUID+41, 30480, 571, 0, 0, 1, 1, 0, 0, 8104.877, -2697.322, 1041.500, 5.958585, 300, 0, 0, 1, 0, 0, 0, 0, 0, -1), +(@CGUID+42, 30480, 571, 0, 0, 1, 1, 0, 0, 8256.483, -2762.314, 1036.986, 5.958585, 300, 5, 0, 1, 0, 1, 0, 0, 0, -1), +(@CGUID+43, 30480, 571, 0, 0, 1, 1, 0, 0, 8244.237, -2746.796, 1036.383, 5.958585, 300, 5, 0, 1, 0, 1, 0, 0, 0, -1), +(@CGUID+44, 30480, 571, 0, 0, 1, 1, 0, 0, 8271.992, -2690.975, 1033.933, 5.377370, 300, 0, 0, 1, 0, 0, 0, 0, 0, -1), +(@CGUID+45, 30480, 571, 0, 0, 1, 1, 0, 0, 8339.269, -2730.310, 1040.727, 5.377370, 300, 5, 0, 1, 0, 1, 0, 0, 0, -1), +(@CGUID+46, 30480, 571, 0, 0, 1, 1, 0, 0, 8322.258, -2768.785, 1039.799, 2.840530, 300, 0, 0, 1, 0, 0, 0, 0, 0, -1), +(@CGUID+47, 30480, 571, 0, 0, 1, 1, 0, 0, 8309.421, -2829.082, 1061.309, 2.086541, 300, 0, 0, 1, 0, 0, 0, 0, 0, -1), +(@CGUID+48, 30480, 571, 0, 0, 1, 1, 0, 0, 8326.189, -2921.562, 1067.907, 2.345727, 300, 0, 0, 1, 0, 0, 0, 0, 0, -1), +(@CGUID+49, 30480, 571, 0, 0, 1, 1, 0, 0, 8314.372, -2982.865, 1076.195, 2.345727, 300, 5, 0, 1, 0, 1, 0, 0, 0, -1), +(@CGUID+50, 30480, 571, 0, 0, 1, 1, 0, 0, 8146.372, -2912.182, 1131.296, 5.765297, 300, 0, 0, 1, 0, 0, 0, 0, 0, -1), +(@CGUID+51, 30480, 571, 0, 0, 1, 1, 0, 0, 8106.739, -2805.795, 1061.564, 5.290828, 300, 0, 0, 1, 0, 0, 0, 0, 0, -1), +(@CGUID+52, 30480, 571, 0, 0, 1, 1, 0, 0, 8178.583, -2785.263, 1041.002, 4.010636, 300, 0, 0, 1, 0, 0, 0, 0, 0, -1), +(@CGUID+53, 30480, 571, 0, 0, 1, 1, 0, 0, 8265.039, -2777.956, 1040.088, 1.410967, 300, 0, 0, 1, 0, 0, 0, 0, 0, -1), +(@CGUID+54, 30480, 571, 0, 0, 1, 1, 0, 0, 8336.015, -2780.298, 1049.557, 1.249958, 300, 0, 0, 1, 0, 0, 0, 0, 0, -1), +(@CGUID+55, 30480, 571, 0, 0, 1, 1, 0, 0, 8308.624, -2798.150, 1065.043, 5.864165, 300, 0, 0, 1, 0, 0, 0, 0, 0, -1), +(@CGUID+56, 30480, 571, 0, 0, 1, 1, 0, 0, 8333.112, -2938.967, 1103.618, 5.479302, 300, 0, 0, 1, 0, 0, 0, 0, 0, -1), +(@CGUID+57, 30480, 571, 0, 0, 1, 1, 0, 0, 8267.484, -3032.642, 1092.302, 3.841752, 300, 0, 0, 1, 0, 0, 0, 0, 0, -1), +(@CGUID+58, 30480, 571, 0, 0, 1, 1, 0, 0, 8246.563, -3102.612, 1138.613, 4.658555, 300, 0, 0, 1, 0, 0, 0, 0, 0, -1), +(@CGUID+59, 30480, 571, 0, 0, 1, 1, 0, 0, 8180.411, -3107.633, 1132.353, 2.380900, 300, 0, 0, 1, 0, 0, 0, 0, 0, -1), +(@CGUID+60, 30184, 571, 0, 0, 1, 1, 0, 0, 8344.593, -2890.996, 1081.132, 0.6801507, 300, 10, 0, 1, 0, 1, 0, 0, 0, -1), +(@CGUID+61, 30184, 571, 0, 0, 1, 1, 0, 0, 8320.477, -2809.02, 1046.727, 2.19553, 300, 10, 0, 1, 0, 1, 0, 0, 0, -1), +(@CGUID+62, 30184, 571, 0, 0, 1, 1, 0, 0, 8284.149, -2746.65, 1038.825, 6.164275, 300, 10, 0, 1, 0, 1, 0, 0, 0, -1), +(@CGUID+63, 30184, 571, 0, 0, 1, 1, 0, 0, 8328.509, -2725.506, 1041.372, 4.027562, 300, 10, 0, 1, 0, 1, 0, 0, 0, -1), +(@CGUID+64, 30184, 571, 0, 0, 1, 1, 0, 0, 8281.308, -2806.566, 1056.489, 1.421924, 300, 10, 0, 1, 0, 1, 0, 0, 0, -1), +(@CGUID+65, 30184, 571, 0, 0, 1, 1, 0, 0, 8277.698, -2752.696, 1038.487, 1.139924, 300, 10, 0, 1, 0, 1, 0, 0, 0, -1), +(@CGUID+66, 30184, 571, 0, 0, 1, 1, 0, 0, 8243.591, -2838.734, 1051.914, 3.86713, 300, 10, 0, 1, 0, 1, 0, 0, 0, -1), +(@CGUID+67, 30184, 571, 0, 0, 1, 1, 0, 0, 8276.418, -2734.577, 1054.935, 0.2101707, 300, 10, 0, 1, 0, 1, 0, 0, 0, -1), +(@CGUID+68, 30184, 571, 0, 0, 1, 1, 0, 0, 8231.363, -2731.73, 1051.175, 4.416204, 300, 10, 0, 1, 0, 1, 0, 0, 0, -1), +(@CGUID+69, 30184, 571, 0, 0, 1, 1, 0, 0, 8225.223, -2825.967, 1065.328, 4.495912, 300, 10, 0, 1, 0, 1, 0, 0, 0, -1), +(@CGUID+70, 30184, 571, 0, 0, 1, 1, 0, 0, 8170.941, -2789.856, 1040.329, 2.083205, 300, 10, 0, 1, 0, 1, 0, 0, 0, -1), +(@CGUID+71, 30184, 571, 0, 0, 1, 1, 0, 0, 8185.819, -2717.096, 1032.445, 2.760506, 300, 10, 0, 1, 0, 1, 0, 0, 0, -1), +(@CGUID+72, 30184, 571, 0, 0, 1, 1, 0, 0, 8150.355, -2810.151, 1043.125, 2.439623, 300, 10, 0, 1, 0, 1, 0, 0, 0, -1), +(@CGUID+73, 30184, 571, 0, 0, 1, 1, 0, 0, 8155.528, -2712.651, 1036.978, 5.357143, 300, 10, 0, 1, 0, 1, 0, 0, 0, -1), +(@CGUID+74, 30184, 571, 0, 0, 1, 1, 0, 0, 8136.961, -2770.122, 1055.17, 5.380077, 300, 10, 0, 1, 0, 1, 0, 0, 0, -1), +(@CGUID+75, 30184, 571, 0, 0, 1, 1, 0, 0, 8139.503, -2826.357, 1061.726, 0.156204, 300, 10, 0, 1, 0, 1, 0, 0, 0, -1), +(@CGUID+76, 30184, 571, 0, 0, 1, 1, 0, 0, 8100.817, -2780.72, 1059.205, 1.816895, 300, 10, 0, 1, 0, 1, 0, 0, 0, -1), +(@CGUID+77, 30184, 571, 0, 0, 1, 1, 0, 0, 8236.846, -2895.526, 1058.389, 5.405963, 300, 10, 0, 1, 0, 1, 0, 0, 0, -1), +(@CGUID+78, 30184, 571, 0, 0, 1, 1, 0, 0, 8208.302, -2925.472, 1049.104, 1.702955, 300, 10, 0, 1, 0, 1, 0, 0, 0, -1), +(@CGUID+79, 30184, 571, 0, 0, 1, 1, 0, 0, 8169.957, -2914.233, 1152.92, 2.049704, 300, 10, 0, 1, 0, 1, 0, 0, 0, -1), +(@CGUID+80, 30184, 571, 0, 0, 1, 1, 0, 0, 8054.126, -2918.885, 1964.633, 2.34505, 300, 10, 0, 1, 0, 1, 0, 0, 0, -1), +(@CGUID+81, 30184, 571, 0, 0, 1, 1, 0, 0, 8098.875, -2942.635, 1133.849, 5.478271, 300, 10, 0, 1, 0, 1, 0, 0, 0, -1), +(@CGUID+82, 30184, 571, 0, 0, 1, 1, 0, 0, 8114.484, -2969.281, 1135.374, 3.005317, 300, 10, 0, 1, 0, 1, 0, 0, 0, -1), +(@CGUID+83, 30184, 571, 0, 0, 1, 1, 0, 0, 8086.405, -2977.659, 1138.879, 1.908854, 300, 10, 0, 1, 0, 1, 0, 0, 0, -1), +(@CGUID+84, 30184, 571, 0, 0, 1, 1, 0, 0, 8137.273, -2950.877, 1146.876, 3.086127, 300, 10, 0, 1, 0, 1, 0, 0, 0, -1), +(@CGUID+85, 30184, 571, 0, 0, 1, 1, 0, 0, 8134.375, -3011.064, 1130.302, 5.29131, 300, 10, 0, 1, 0, 1, 0, 0, 0, -1), +(@CGUID+86, 30184, 571, 0, 0, 1, 1, 0, 0, 8201.802, -2942.668, 1097.733, 0.9895276, 300, 10, 0, 1, 0, 1, 0, 0, 0, -1), +(@CGUID+87, 30184, 571, 0, 0, 1, 1, 0, 0, 8280.063, -2970.4, 1077.717, 3.271293, 300, 10, 0, 1, 0, 1, 0, 0, 0, -1), +(@CGUID+88, 30184, 571, 0, 0, 1, 1, 0, 0, 8219.309, -3037.628, 1098.286, 3.015144, 300, 10, 0, 1, 0, 1, 0, 0, 0, -1), +(@CGUID+89, 30184, 571, 0, 0, 1, 1, 0, 0, 8253.314, -2990.276, 1084.481, 5.021625, 300, 10, 0, 1, 0, 1, 0, 0, 0, -1), +(@CGUID+90, 30184, 571, 0, 0, 1, 1, 0, 0, 8242.5, -2912.423, 1089.404, 3.999207, 300, 10, 0, 1, 0, 1, 0, 0, 0, -1), +(@CGUID+91, 30184, 571, 0, 0, 1, 1, 0, 0, 8211.771, -3070.037, 1127.766, 1.769577, 300, 10, 0, 1, 0, 1, 0, 0, 0, -1), +(@CGUID+92, 30184, 571, 0, 0, 1, 1, 0, 0, 8229.682, -3105.194, 1123.312, 1.903227, 300, 10, 0, 1, 0, 1, 0, 0, 0, -1), +(@CGUID+93, 30184, 571, 0, 0, 1, 1, 0, 0, 8330.029, -3020.317, 1092.82, 0.102729, 300, 10, 0, 1, 0, 1, 0, 0, 0, -1), +(@CGUID+94, 30184, 571, 0, 0, 1, 1, 0, 0, 8337.25, -3014.343, 1081.544, 3.683157, 300, 10, 0, 1, 0, 1, 0, 0, 0, -1), +(@CGUID+95, 30184, 571, 0, 0, 1, 1, 0, 0, 8277.126, -3101.834, 1124.499, 4.267029, 300, 10, 0, 1, 0, 1, 0, 0, 0, -1), +(@CGUID+96, 30184, 571, 0, 0, 1, 1, 0, 0, 8340.347, -3033.928, 1096.172, 2.277171, 300, 10, 0, 1, 0, 1, 0, 0, 0, -1), +(@CGUID+97, 30184, 571, 0, 0, 1, 1, 0, 0, 8269.506, -3134.334, 1141.567, 3.935999, 300, 10, 0, 1, 0, 1, 0, 0, 0, -1), +(@CGUID+98, 30184, 571, 0, 0, 1, 1, 0, 0, 8262.71, -3132.451, 1131.732, 2.41951, 300, 10, 0, 1, 0, 1, 0, 0, 0, -1), +(@CGUID+99, 30184, 571, 0, 0, 1, 1, 0, 0, 8322.615, -3105.121, 1123.922, 1.502089, 300, 10, 0, 1, 0, 1, 0, 0, 0, -1), +(@CGUID+100, 30184, 571, 0, 0, 1, 1, 0, 0, 8258.828, -3158.304, 1149.163, 3.404049, 300, 10, 0, 1, 0, 1, 0, 0, 0, -1), +(@CGUID+101, 30184, 571, 0, 0, 1, 1, 0, 0, 8338.535, -2987.913, 1091.492, 5.531283, 300, 10, 0, 1, 0, 1, 0, 0, 0, -1), +(@CGUID+102, 30184, 571, 0, 0, 1, 1, 0, 0, 8267.858, -3034.132, 1077.292, 5.531283, 300, 10, 0, 1, 0, 1, 0, 0, 0, -1), +(@CGUID+103, 30184, 571, 0, 0, 1, 1, 0, 0, 8098.754, -2736.020, 1044.947, 5.531283, 300, 10, 0, 1, 0, 1, 0, 0, 0, -1), +(@CGUID+104, 30184, 571, 0, 0, 1, 1, 0, 0, 8124.942, -2702.110, 1040.577, 5.531283, 300, 10, 0, 1, 0, 1, 0, 0, 0, -1), +(@CGUID+105, 30184, 571, 0, 0, 1, 1, 0, 0, 8061.423, -2923.001, 1140.066, 5.531283, 300, 10, 0, 1, 0, 1, 0, 0, 0, -1); + +DELETE FROM `creature_addon` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+105; +INSERT INTO `creature_addon` (`guid`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `auras`) VALUES +(@CGUID+0, 0, 0, 0, 1, 383, '28126'), +(@CGUID+1, 0, 0, 0, 1, 430, '28126'), +(@CGUID+2, 0, 0, 0, 1, 0, '28126'), +(@CGUID+3, 0, 0, 0, 1, 383, '28126'), +(@CGUID+4, 0, 0, 0, 1, 383, '28126'), +(@CGUID+5, 0, 0, 0, 1, 430, '28126'), +(@CGUID+6, 0, 0, 0, 1, 383, '28126'), +(@CGUID+7, 0, 0, 0, 1, 383, '28126'), +(@CGUID+8, 0, 0, 0, 1, 383, '28126'), +(@CGUID+9, 0, 0, 0, 1, 383, '28126'), +(@CGUID+10, 0, 0, 0, 1, 383, '28126'), +(@CGUID+11, 0, 0, 0, 1, 0, '28126'), +(@CGUID+12, 0, 0, 0, 1, 383, '28126'), +(@CGUID+13, 0, 0, 0, 1, 430, '28126'), +(@CGUID+14, 0, 0, 0, 1, 383, '28126'), +(@CGUID+15, 0, 0, 0, 1, 383, '28126'), +(@CGUID+16, 0, 0, 0, 1, 0, '28126'), +(@CGUID+17, 0, 0, 0, 1, 0, '28126'), +(@CGUID+18, 0, 0, 0, 1, 0, '28126'), +(@CGUID+19, 0, 0, 0, 1, 0, '28126'), +(@CGUID+20, 0, 0, 0, 1, 383, '28126'), +(@CGUID+21, 0, 0, 0, 1, 383, '28126'), +(@CGUID+22, 0, 0, 0, 1, 383, '28126'), +(@CGUID+23, 0, 0, 0, 1, 383, '28126'), +(@CGUID+24, 0, 0, 0, 1, 383, '28126'), +(@CGUID+25, 0, 0, 0, 1, 383, '28126'), +(@CGUID+26, 0, 0, 0, 1, 383, '28126'), +(@CGUID+27, 0, 0, 0, 1, 383, '28126'), +(@CGUID+28, 0, 0, 0, 1, 383, '28126'), +(@CGUID+29, 0, 0, 0, 1, 383, '28126'), +(@CGUID+30, 0, 0, 0, 1, 383, '28126'), +(@CGUID+31, 0, 0, 0, 1, 383, '28126'), +(@CGUID+32, 0, 0, 0, 1, 383, '28126'), +(@CGUID+33, 0, 0, 0, 1, 383, '28126'), +(@CGUID+34, 0, 0, 0, 1, 383, '28126'), +(@CGUID+35, 0, 0, 0, 1, 383, '28126'), +(@CGUID+36, 0, 0, 0, 1, 430, '28126'), +(@CGUID+37, 0, 0, 0, 1, 430, '28126'), +(@CGUID+38, 0, 0, 50331648, 1, 0, '28126'), +(@CGUID+39, 0, 0, 0, 1, 383, '28126'), +(@CGUID+40, 0, 0, 50331648, 1, 0, '28126'), +(@CGUID+41, 0, 0, 0, 1, 383, '28126'), +(@CGUID+42, 0, 0, 50331648, 1, 0, '28126'), +(@CGUID+43, 0, 0, 50331648, 1, 0, '28126'), +(@CGUID+44, 0, 0, 0, 1, 383, '28126'), +(@CGUID+45, 0, 0, 50331648, 1, 0, '28126'), +(@CGUID+46, 0, 0, 0, 1, 430, '28126'), +(@CGUID+47, 0, 0, 0, 1, 383, '28126'), +(@CGUID+48, 0, 0, 0, 1, 430, '28126'), +(@CGUID+49, 0, 0, 50331648, 1, 0, '28126'), +(@CGUID+50, 0, 0, 0, 1, 383, '28126'), +(@CGUID+51, 0, 0, 0, 1, 383, '28126'), +(@CGUID+52, 0, 0, 0, 1, 430, '28126'), +(@CGUID+53, 0, 0, 0, 1, 430, '28126'), +(@CGUID+54, 0, 0, 0, 1, 383, '28126'), +(@CGUID+55, 0, 0, 0, 1, 383, '28126'), +(@CGUID+56, 0, 0, 0, 1, 383, '28126'), +(@CGUID+57, 0, 0, 0, 1, 383, '28126'), +(@CGUID+58, 0, 0, 0, 1, 383, '28126'), +(@CGUID+59, 0, 0, 0, 1, 383, '28126'), +(@CGUID+60, 0, 0, 50331648, 1, 0, ''), +(@CGUID+61, 0, 0, 50331648, 1, 0, ''), +(@CGUID+62, 0, 0, 50331648, 1, 0, ''), +(@CGUID+63, 0, 0, 50331648, 1, 0, ''), +(@CGUID+64, 0, 0, 50331648, 1, 0, ''), +(@CGUID+65, 0, 0, 50331648, 1, 0, ''), +(@CGUID+66, 0, 0, 50331648, 1, 0, ''), +(@CGUID+67, 0, 0, 50331648, 1, 0, ''), +(@CGUID+68, 0, 0, 50331648, 1, 0, ''), +(@CGUID+69, 0, 0, 50331648, 1, 0, ''), +(@CGUID+70, 0, 0, 50331648, 1, 0, ''), +(@CGUID+71, 0, 0, 50331648, 1, 0, ''), +(@CGUID+72, 0, 0, 50331648, 1, 0, ''), +(@CGUID+73, 0, 0, 50331648, 1, 0, ''), +(@CGUID+74, 0, 0, 50331648, 1, 0, ''), +(@CGUID+75, 0, 0, 50331648, 1, 0, ''), +(@CGUID+76, 0, 0, 50331648, 1, 0, ''), +(@CGUID+77, 0, 0, 50331648, 1, 0, ''), +(@CGUID+78, 0, 0, 50331648, 1, 0, ''), +(@CGUID+79, 0, 0, 50331648, 1, 0, ''), +(@CGUID+80, 0, 0, 50331648, 1, 0, ''), +(@CGUID+81, 0, 0, 50331648, 1, 0, ''), +(@CGUID+82, 0, 0, 50331648, 1, 0, ''), +(@CGUID+83, 0, 0, 50331648, 1, 0, ''), +(@CGUID+84, 0, 0, 50331648, 1, 0, ''), +(@CGUID+85, 0, 0, 50331648, 1, 0, ''), +(@CGUID+86, 0, 0, 50331648, 1, 0, ''), +(@CGUID+87, 0, 0, 50331648, 1, 0, ''), +(@CGUID+88, 0, 0, 50331648, 1, 0, ''), +(@CGUID+89, 0, 0, 50331648, 1, 0, ''), +(@CGUID+90, 0, 0, 50331648, 1, 0, ''), +(@CGUID+91, 0, 0, 50331648, 1, 0, ''), +(@CGUID+92, 0, 0, 50331648, 1, 0, ''), +(@CGUID+93, 0, 0, 50331648, 1, 0, ''), +(@CGUID+94, 0, 0, 50331648, 1, 0, ''), +(@CGUID+95, 0, 0, 50331648, 1, 0, ''), +(@CGUID+96, 0, 0, 50331648, 1, 0, ''), +(@CGUID+97, 0, 0, 50331648, 1, 0, ''), +(@CGUID+98, 0, 0, 50331648, 1, 0, ''), +(@CGUID+99, 0, 0, 50331648, 1, 0, ''), +(@CGUID+100, 0, 0, 50331648, 1, 0, ''), +(@CGUID+101, 0, 0, 50331648, 1, 0, ''), +(@CGUID+102, 0, 0, 50331648, 1, 0, ''), +(@CGUID+103, 0, 0, 50331648, 1, 0, ''), +(@CGUID+104, 0, 0, 50331648, 1, 0, ''), +(@CGUID+105, 0, 0, 50331648, 1, 0, ''); |