diff options
| -rw-r--r-- | sql/updates/world/2013_01_07_15_world_creature_addon.sql | 38 | ||||
| -rw-r--r-- | sql/updates/world/2013_01_07_16_world_creature_addon.sql | 96 |
2 files changed, 134 insertions, 0 deletions
diff --git a/sql/updates/world/2013_01_07_15_world_creature_addon.sql b/sql/updates/world/2013_01_07_15_world_creature_addon.sql new file mode 100644 index 00000000000..2b5ec6c2413 --- /dev/null +++ b/sql/updates/world/2013_01_07_15_world_creature_addon.sql @@ -0,0 +1,38 @@ +DELETE FROM `creature_template_addon` WHERE `entry`IN (48,1027,1179,1708,3737,3749,3921,6221,7011,7396); +INSERT INTO `creature_template_addon` (`entry`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES +-- Removed Battle Stance Aura, it should be set via SAI, same for any fake mining emotes) +( 48,0,0,1114112,4097,0,''), -- Skeletal Warrior +(1027,0,0,1114112,4097,0,''), -- Bluegill Warrior +(1179,0,0,1114112,4097,0,''), -- Mogrosh Enforcer +(1708,0,0,1114112,4097,0,''), -- Defias Inmate +(3737,0,0,0,285216769,0,''), -- Saltspittle Puddlejumper +(3749,0,0,0,285216769,0,''), -- Foulweald Ursa +(3921,0,0,0,285216769,0,''), -- Thistlefur Ursa +(6221,0,0,1114112,4097,0,''), -- Addled Leper +(7011,0,0,1114112,4097,0,''), -- Earthen Rocksmasher +(7396,0,0,1114112,4097,0,''); -- Earthen Stonebreaker +-- Remove creature_addon templates in favor of general creature_template_addon ones, and possible SAI +DELETE FROM `creature_addon` WHERE `guid` IN ( +-- Skeletal Warrior +4914,5008,5968,5974,5984,5985,5986,5987,5988,5989,6005, +-- Bluegill Warrior +9543,9544,9545,9605,9607,9686,9690,9759,9788,9796,9823,10730,10925,10928,11055,11058, +-- Mogrosh Enforcer +8366,8789,9082,9211,9216,9217,9227,9376, +-- Defias Inmate +79082,79095,79097,79103,79106, +-- Saltspittle Puddlejumper +32919,32920,32921,32922,32923,32924,32925, +-- Foulweld Ursa +33080,33081,33082,33083, +-- Thistlefur Ursa +32440,32441,32442,32443,32445,32446,32447,32448, +-- Addled Leper +2446,2447,2448, +-- Earthen Rocksmasher +28369,28370,28371,28374,28376,28377,28532,28535,28536,28537,28538,28539,28541,28542,28543,28544,28546,28547,28784,28795,28796,28797,28798,28799,29384,29488,29573,29574, +-- Earthen Stonebreaker +27764,27766,27767,27770,27789,27790,27791,33505,33506,33507,33508); +-- Remove Battle Stance Aura as that should already be done via SAI: +UPDATE `creature_addon` SET `auras`='' WHERE `auras`='7165' AND `guid` IN (90212,32617,12218,2443); + diff --git a/sql/updates/world/2013_01_07_16_world_creature_addon.sql b/sql/updates/world/2013_01_07_16_world_creature_addon.sql new file mode 100644 index 00000000000..bd5c17c6f67 --- /dev/null +++ b/sql/updates/world/2013_01_07_16_world_creature_addon.sql @@ -0,0 +1,96 @@ +DELETE FROM `creature_addon` WHERE `guid` IN ( +-- --------------------------------------------------------------- +-- Lightning Shield (12550) +-- --------------------------------------------------------------- +-- Shadowpine Witch +81831,81833,81839,81842,81844,81896, +-- Deadwind Ogre Mage +3964,3980,3982,3994,3995,3996,3999,4038, +-- --------------------------------------------------------------- +-- Demon Armor (13787) +-- --------------------------------------------------------------- +-- Morganth +6268, + -- Shadowmoon Deathshaper +13234,13233,13232,13231,12891,12890, + -- Skeletal Guardian +52616,52620,52622,52643,52644,52647,52649,52650,52653,52683,52837,52852,52853,52934,52997,52998,52999,53000,53003,53005,53006,53007,53009,53010,53092,53093,53095, +-- --------------------------------------------------------------- +-- Chain Heal (1604) +-- --------------------------------------------------------------- +-- Crazed Mana-Wraith +126548,126552, +-- Scarlet Peasant +128784, +-- Scarlet Infantryman +129286,129287, +-- Flesh Behemoth +130392, +-- Marsh Fawn +133083, +-- --------------------------------------------------------------- +-- Stealth Detection (8279) +-- --------------------------------------------------------------- +-- Scarlet Sentinel +45391,45396,48219,48593,48617,48624,49992,51744,51745,52001,52245,52247,52510, +-- Eyeless Watcher +54277,56694,69687,69707,92177,92204,92518, +-- Unseen Servant +92527,92713, +-- --------------------------------------------------------------- +-- Retribution Aura (8990) +-- --------------------------------------------------------------- +-- Crimson Conjuror +54079,54082, +-- Crimson Gallant +54180,54201,54204,54205,54206,54207,54208,54219,54221,54222,54223,54224,54225,54227,54228,54229, +-- Crimson Battle Mage +54230,54231,54232,54233, +-- --------------------------------------------------------------- +-- Frost Armor (18100) +-- --------------------------------------------------------------- +-- Scarlet Archmage +54267,84783,84784,84963,86414,90955,92330,92436,92444,92452, +-- --------------------------------------------------------------- +-- Invisibility and Stealth Detection +-- --------------------------------------------------------------- +-- Ravaged Cadaver +52172,52171,52170,52169,52168,52167,52166,52165,52164,52163,52162,52161,52160,52159,52158,52157,52156,52155,52154,52153,52152,52173,52174,52175,52176,52177,52179,52180,52181,52182, +-- Mangled Cadaver +52183,52184,52185,52186,52187,52188,52189,52190,52191,52192,52193,52194,52195,52196,52197,52198,52199,52200,52201,52202,52203,52204,52205,52206,52207,52208,52209,52210,52211,52212,52213,52214,52215,52216,52217, +-- Ghoul Ravener +53678,53691,53692,53693,53694,53695,53696,53697,53698,53702,53706,53707,53708,53709,53715,53716,53726, +-- Fleshflayer Ghoul +53727,53728,53729,53761,53777,53778,53779,53780,53781,53782, +-- Bloodseeker Bat +49123,49124,49125,49127,49128,49139,49140,49143,49144,49145,49146,49150,49151,49156,49157,49158,49186,49187,49188,49190,49191,49192,51874,91548,91549,91551,91554, +-- Hooktooth Frenzy +49068,49069,49070,49071,49072,49073,49074,49075,49076,49722,49723,49724,49725,49727,49728,49730,49731,51443,51445,51446,51447,51449,51450,51963, +-- Ancient Core Hound +56675,56676,56742, +-- Embalming Slime +128103,128104,128105,128106,128107,128108,128109,128110,128111,128112,128113,128114,128115,128116,128117,128118, +-- Shade of Naxxramas +127755,127757, +-- Stoneskin Gargoyle +127776,127777,127778,127779,127780, +-- Argent Sentry +53857,53863,53864,53868,53869,53875,53895,53896,54751,54752,54753,54755,54756,54757,54758,68491,68500,68931,68963,69677,69679, +-- Aqueous Lord +12869,12868,12867,12866, +-- Amani'shi Guardian +86194,86204,86205,86239,86280,86307,86308,86906,86910,86914,89133,89134,89143,89165,89168,89170,89171,89192,89194,89195,89219,89220,89241,89243,89255,89331, +-- Amani'shi Savage +85580,86132,86162,86913,86915,86916,86918,86920, +-- Amani'shi Handler +86923,86927,89136,89138,89142,89174,89199, +-- Amani'shi Wind Walker +89207,86210, +-- Mage Slayer +126474,126475,126476,126477,126478,126479, +-- Savage Worg +125993,125994,125995,125996,125997,125998, +-- Vigilant Shade +128065); + + |