diff options
| -rw-r--r-- | sql/updates/world/2013_01_10_04_world_creature_addon.sql | 221 |
1 files changed, 221 insertions, 0 deletions
diff --git a/sql/updates/world/2013_01_10_04_world_creature_addon.sql b/sql/updates/world/2013_01_10_04_world_creature_addon.sql new file mode 100644 index 00000000000..74f2356e7a7 --- /dev/null +++ b/sql/updates/world/2013_01_10_04_world_creature_addon.sql @@ -0,0 +1,221 @@ +DELETE FROM `creature_addon` WHERE `guid` IN +(79195, 79207, 79222, 79227, 126407, 126408, 126409, 126410, 126411, +126412, 71567, 71570, 71575, 71576, 71577, 102518, 102524, 54194, 54195, +54196, 54197, 54198, 54199, 54209, 54254, 54255, 54256, 54809, 54859, +55363, 56312, 56313, 56318, 92035, 101717, 101718, 101739, 101742, +101743, 101744, 101745, 101747, 101751, 101753, 101754, 101755, 101761, +101762, 101764, 101765, 101766, 101767, 101768, 101769, 101773, 101774, +101775, 101776, 101778, 101781, 101782, 101783, 101784, 101785, 101786, +101787, 101788, 101789, 101791, 101792, 101793, 101794, 101795, 101796, +101797, 126391, 126392, 126393, 126394, 126395, 70671, 70679, 70683, +70685, 68923, 68924, 68925, 68926, 68927, 68928, 68929, 135402, 135401, +135400, 135399, 135398, 135397, 135396, 135395, 135394, 135393, 75032, +75034, 75035, 75036, 75038, 75039, 75041, 75044, 75045, 75046, 75047, +75048, 75049, 75052, 75054, 75055, 75056, 75057, 75058, 75059, 75062, +75063, 75069, 75070, 75073, 75074, 75075, 75077, 75078, 75080, 75081, +75082, 75083, 75084, 75085, 75086, 75087, 75088, 75089, 75091, 75095, +75096, 75097, 75098, 75102, 73687, 73688, 73690, 73692, 71705, 71706, +67246, 67247, 133044, 133045, 133046, 133047, 133048, 133049, 133050, +132870, 132871, 132872, 132873, 132874, 132875, 132876, 132877, 132878, +132879, 132880, 132881, 132882, 132883, 132884, 132885, 132886, 132887, +132888, 132889, 132890, 132891, 132892, 132893, 132894, 132895, 132896, +132897, 132898, 132899, 132900, 132901, 132902, 132903, 132904, 132905, +132906, 132907, 79345, 79346, 203436, 203437, 203438, 203439, 203440, +41517, 41518, 41520, 41521, 41522, 41523, 41524, 41525, 41526, 41527, +41528, 41529, 41530, 41531, 41533, 41534, 41535, 41536, 41537, 41538, +41539, 41540, 41541, 41542, 41543, 41544, 41545, 41546, 41547, 41548, +41549, 41550, 41551, 41552, 41553, 41554, 41555, 129911, 129929, 129935, +71272, 71276, 71277, 71279, 71281, 71282, 65563, 65564, 60256, 60258, +60271, 60273, 60274, 60277, 60278, 60279, 72457, 72460, 101350, 101351, +101352, 101353, 101354, 101365, 101366, 101367, 101368, 101369, 101371, +101372, 101373, 101374, 101375, 101376, 101377, 101378, 101379, 101380, +101381, 101382, 101383, 101384, 101385, 101386, 101387, 101389, 101390, +101391, 101392, 101393, 101394, 101395, 101396, 101397, 101398, 101399, +101402, 101403, 101404, 101405, 101407, 101412, 71189, 71190, 70656, +70646, 70644, 70643, 70641, 70635, 70633, 70632, 70624, 70623, 70622, +105663, 105679, 105680, 105697, 105698, 105701, 105703, 105704, 105705, +105706, 105707, 105708, 105709, 105710, 105724, 105726, 105729, 109729, +109730, 109731, 71055, 71061, 71064, 82576, 82583, 82584, 82586, 82593, +82594, 82595, 82598, 28363, 27800, 27798, 27796, 27765, 27728, 27692, +27691, 27568, 33513, 33514, 33515, 33516, 135432, 135431, 135430, +135429, 135428, 135427, 28671, 28670, 28669, 28668, 118222, 118223, +118226, 118227, 118228, 118229, 131095, 131098, 131102, 131104, 71163, +71166, 71167, 71168, 71169, 71171, 58162, 58167, 58170, 58172, 58173, +58183, 58187, 58188, 58193, 58194, 31822, 43670, 56612, 135493, 135492, +135491, 135490, 135488, 135487, 135486, 135485, 135484, 135483, 135482, +135481, 135480, 135479, 135478, 70835, 70839, 66766, 66777, 67386, +67388, 67389, 9365, 9363, 9362, 107198, 107199, 132455, 132456, 135606, +135605, 135604, 135603, 135602, 132650, 132651, 64158, 64159, 64162, +64163, 64170, 64186, 64191, 64195, 64196, 124849, 124850, 124851, +124852, 124853, 124854, 124855, 124856, 124857, 124858, 124859, 124860, +124861, 124862, 124863, 124864, 124865, 124870, 124871, 124872, 124873, +124874, 124875, 124876, 124877, 124878, 124879, 124880, 124881, 124882, +60305, 60330, 60331, 60332, 126397, 126398, 126399, 126400, 135426, +135425, 135424, 135423, 135422, 51560, 51561, 51562, 51563, 51648, +51826, 52055, 52117, 52118, 52120, 52565, 52566, 52567, 52568, 52569, +52570, 52571, 52588, 52589, 52590, 52591, 52592, 52593, 84081, 84263, +84278, 84327, 84595, 84596, 86148, 86151, 86226, 88910, 89436, 89443, +89907, 89908, 89909, 90198, 90199, 90201, 90220, 90255, 90420, 90424, +6001, 5999, 5998, 5995, 68142, 68143, 68144, 68151, 68154, 68157, 68162, +68164, 68166, 68170, 68176, 68177, 68181, 68184, 68185, 69399, 69402, +69404, 62073, 62074, 62075, 62080, 135421, 135420, 14575, 14574, 97435, +97436, 97437, 97438, 97439, 97443, 66878, 66879, 123933, 123936, 123937, +84989, 135438, 135437, 135436, 135435, 135434, 135433, 67912, 67914, +67915, 67917, 67919, 67920, 67924, 135921, 135922, 135681, 135680, +135679, 135678, 135677, 135676, 135675, 74885, 74888, 11056, 10920, +103444, 103474, 135601, 135600, 135599, 135598, 135597, 81249, 81250, +81349, 123754, 123755, 123756, 123758, 123760, 123768, 123769, 123770, +123771, 123772, 123773, 123774, 123775, 123776, 123777, 123778, 123779, +123780, 123781, 123783, 123784, 123785, 123786, 123787, 123788, 123789, +123790, 123793, 123795, 123796, 123797, 123802, 123803, 123804, 123805, +123806, 123807, 123809, 123810, 123825, 123826, 7376, 7375, 7374, 7373, +7372, 6527, 6526, 6525, 6524, 6523, 3348, 3347, 3346, 3345, 39097, +39124, 39150, 39162, 39169, 39171, 39182, 39193, 39217, 39224, 39225, +39235, 39236, 39334, 39337, 39404, 39492, 39495, 39502, 39503, 39504, +39505, 39507, 39508, 39509, 39511, 39692, 39693, 39694, 39695, 39698, +39700, 39702, 39711, 40588, 40614, 40622, 40746, 40771, 40777, 40803, +40805, 40808, 40814, 40815, 40817, 40818, 40821, 122419, 122420, 122421, +122422, 70799, 70800, 84363, 84612, 86147, 86150, 86197, 86383, 89524, +89526, 89527, 89528, 89529, 89774, 89775, 89776, 89777, 89778, 89779, +89780, 89781, 89782, 89783, 89791, 89792, 89793, 89794, 89795, 89796, +89797, 89798, 89810, 89811, 89812, 89813, 89814, 89815, 89816, 89817, +89818, 89819, 90003, 90004, 90005, 90006, 90010, 90011, 90012, 90013, +90235, 90325, 90360, 90361, 90363, 90365, 90369, 77395, 77396, 77397, +77398, 77399, 77400, 77412, 77413, 77415, 77416, 77420, 77421, 77422, +77423, 77424, 77425, 77431, 77446, 77447, 77454, 77455, 77456, 77457, +77458, 77459, 77460, 77462, 77464, 77465, 77466, 77467, 77468, 77469, +77470, 77471, 77472, 77473, 77474, 77475, 77476, 77477, 77478, 82587, +82591, 82596, 82601, 126401, 126402, 126403, 126404, 126405, 126406, +43680, 43674, 56326, 57163, 98042, 98043, 128319, 128320, 128321, +128322, 128323, 128324, 128325, 128326, 128327, 128328, 128329, 128330, +128331, 128332, 128333, 128334, 128335, 128336, 128337, 128338, 128339, +128340, 128341, 128342, 128343, 128344, 128345, 128346, 128347, 128348, +128349, 128350, 135494, 135503, 135502, 135501, 135500, 135499, 135498, +135497, 135496, 135495, 70697, 70698, 103482, 103483, 103485, 103488, +58673, 58684, 58685, 72498, 72499, 72502, 58937, 58938, 58939, 58943, +58946, 58948, 58949, 58952, 58953, 58954, 58955, 135419, 135418, 135417, +135416, 135415, 135414, 135413, 135412, 135411, 135410, 135409, 135408, +135407, 135406, 135405, 135404, 135403, 128137, 128138, 128139, 128140, +128141, 128142, 128143, 128144, 128145, 128146, 128147, 128148, 128149, +128150, 128151, 128152, 128153, 128154, 128155, 128156, 128157, 128158, +128159, 128160, 128161, 128162, 128163, 128164, 128165, 128166, 128167, +128168, 128169, 128170, 202639, 202638, 202637, 135616, 135615, 135614, +135613, 135612, 135611, 85072, 85071, 85070, 85069, 85068, 85067, 85066, +85065, 14740, 49852, 132542, 132544, 132545, 132546, 132543, 132539, +132547, 132540, 132541, 132550, 132548, 132549, 132551, 132552, 68045, +68057, 68068, 46355, 46356, 46357, 46358, 46359, 46360, 46361, 46362, +46363, 46364, 46365, 46366, 46367, 46368, 46369, 46370, 46371, 46372, +46373, 46374, 46375, 46376, 46377, 46378, 46379, 46380, 46381, 46382, +46383, 46384, 46385, 46386, 46387, 46388, 46389, 46390, 46391, 46392); + +DELETE FROM `creature_template_addon` WHERE `entry` IN +(641, 30682, 20089, 30281, 16117, 28221, 30648, 19755, 19337, 16171, +21419, 20929, 20140, 18830, 21728, 22986, 636, 18815, 7456, 29038, +19984, 18272, 17149, 20453, 17467, 19961, 19740, 29036, 24467, 19944, +16335, 7396, 16177, 18207, 27629, 19952, 16867, 14864, 16459, 19792, +18595, 18858, 1179, 890, 16482, 21804, 18117, 32498, 17151, 30680, +16176, 454, 48, 18975, 19415, 17282, 16175, 2738, 18955, 18638, 10928, +16178, 18912, 17645, 17260, 21405, 1027, 32596, 16481, 11328, 6827, +10556, 8960, 31070, 19784, 157, 22082, 16334, 30681, 14869, 26645, +16068, 16460, 19762, 26965, 16912, 20474, 16943, 16174, 16173, 16030, +17269, 16488, 33229, 15351, 21763, 18952, 3681); + +INSERT INTO `creature_template_addon` (`entry`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `auras`) VALUES +(641, 0, 0, 0, 4097, 0, ''), +(30682, 0, 0, 0, 1, 0, '57740'), +(20089, 0, 0, 0, 4097, 0, '34827'), +(30281, 0, 0, 1, 257, 0, ''), +(16117, 0, 0, 0, 4097, 0, ''), +(28221, 0, 0, 0, 1, 0, ''), +(30648, 0, 0, 0, 1, 0, '57560'), +(19755, 0, 0, 0, 4097, 0, ''), +(19337, 0, 0, 0, 4098, 0, ''), +(16171, 0, 0, 0, 1, 0, ''), +(21419, 0, 0, 0, 4097, 0, ''), +(20929, 0, 0, 0, 4097, 333, ''), +(20140, 0, 0, 0, 4097, 0, ''), +(18830, 0, 0, 8, 4097, 0, ''), +(21728, 0, 0, 0, 1, 0, ''), +(22986, 0, 0, 0, 1, 0, ''), +(636, 0, 0, 33554432, 4097, 0, '6408'), +(18815, 0, 0, 0, 257, 0, ''), +(7456, 0, 0, 0, 4097, 0, ''), +(29038, 0, 0, 65536, 1, 0, ''), +(19984, 0, 0, 2, 4097, 0, ''), +(18272, 0, 0, 0, 4097, 28, ''), +(17149, 0, 0, 0, 4097, 0, ''), +(20453, 0, 0, 0, 4097, 28, ''), +(17467, 0, 0, 0, 1, 0, ''), +(19961, 0, 0, 0, 4097, 0, ''), +(19740, 0, 0, 0, 4097, 27, ''), +(29036, 0, 0, 0, 1, 0, ''), +(24467, 0, 0, 7, 0, 0, ''), +(19944, 0, 0, 2, 4097, 333, ''), +(16335, 0, 0, 0, 4097, 233, ''), +(7396, 0, 0, 0, 4097, 0, ''), +(16177, 0, 0, 0, 1, 0, ''), +(18207, 0, 0, 8, 4097, 0, ''), +(27629, 0, 0, 50331648, 0, 0, ''), +(19952, 0, 0, 0, 4097, 0, '12544'), +(16867, 0, 0, 0, 4097, 0, ''), +(14864, 0, 0, 0, 4097, 0, ''), +(16459, 0, 0, 0, 1, 0, ''), +(19792, 0, 0, 8, 4097, 0, ''), +(18595, 0, 0, 0, 4097, 0, ''), +(18858, 0, 0, 0, 4097, 333, ''), +(1179, 0, 0, 0, 4097, 0, ''), +(890, 0, 0, 0, 1, 0, ''), +(16482, 0, 0, 0, 1, 0, ''), +(21804, 0, 0, 0, 1, 0, ''), +(18117, 0, 0, 0, 4097, 0, ''), +(32498, 0, 0, 0, 1, 0, ''), +(17151, 0, 0, 0, 4097, 0, ''), +(30680, 0, 0, 0, 1, 0, '57740'), +(16176, 0, 0, 0, 1, 0, ''), +(454, 0, 0, 0, 4097, 0, ''), +(48, 0, 0, 0, 4097, 0, ''), +(18975, 0, 0, 0, 4097, 0, ''), +(19415, 0, 0, 0, 4097, 0, '13864'), +(17282, 0, 0, 0, 4096, 0, ''), +(16175, 0, 0, 0, 1, 0, ''), +(2738, 0, 2410, 0, 4097, 0, ''), +(18955, 0, 0, 0, 1, 0, ''), +(18638, 0, 0, 8, 4097, 0, ''), +(10928, 0, 0, 0, 1, 0, ''), +(16178, 0, 0, 0, 1, 0, ''), +(18912, 0, 0, 0, 4097, 0, '35230'), +(17645, 0, 0, 0, 1, 0, ''), +(17260, 0, 0, 0, 1, 0, ''), +(21405, 0, 0, 0, 4097, 173, ''), +(1027, 0, 0, 0, 4097, 0, ''), +(32596, 0, 27913, 0, 257, 0, ''), +(16481, 0, 0, 0, 1, 0, ''), +(11328, 0, 0, 0, 4097, 0, ''), +(6827, 0, 0, 0, 1, 0, ''), +(10556, 0, 0, 0, 4096, 0, ''), +(8960, 0, 0, 0, 4097, 0, ''), +(31070, 0, 0, 50331649, 1, 0, ''), +(19784, 0, 0, 7, 4097, 0, ''), +(157, 0, 0, 0, 4097, 0, ''), +(22082, 0, 0, 0, 4097, 333, ''), +(16334, 0, 0, 0, 4097, 233, ''), +(30681, 0, 0, 0, 1, 0, '57740'), +(14869, 0, 0, 0, 4097, 0, ''), +(26645, 0, 0, 0, 257, 69, ''), +(16068, 0, 0, 0, 1, 0, ''), +(16460, 0, 0, 0, 1, 0, ''), +(19762, 0, 0, 7, 4097, 0, ''), +(26965, 0, 0, 0, 1, 0, '31261'), +(16912, 0, 207, 0, 4097, 0, ''), +(20474, 0, 0, 0, 4097, 0, ''), +(16943, 0, 0, 0, 4097, 233, ''), +(16174, 0, 0, 0, 1, 0, ''), +(16173, 0, 0, 0, 1, 0, ''), +(16030, 0, 0, 0, 1, 0, ''), +(17269, 0, 0, 0, 2, 0, ''), +(16488, 0, 0, 0, 1, 0, ''), +(33229, 0, 0, 0, 1, 0, ''), +(15351, 0, 0, 0, 4097, 0, ''), +(21763, 0, 0, 65536, 1, 0, ''), +(18952, 0, 0, 0, 4097, 69, ''), +(3681, 0, 0, 0, 4097, 0, ''); |