diff options
| -rw-r--r-- | sql/updates/world/2014_09_07_02_world_npc_factions_335.sql | 249 |
1 files changed, 249 insertions, 0 deletions
diff --git a/sql/updates/world/2014_09_07_02_world_npc_factions_335.sql b/sql/updates/world/2014_09_07_02_world_npc_factions_335.sql new file mode 100644 index 00000000000..1451f39785b --- /dev/null +++ b/sql/updates/world/2014_09_07_02_world_npc_factions_335.sql @@ -0,0 +1,249 @@ +UPDATE `creature_template` SET `faction`=107 WHERE `entry`=8127; -- Antu'sul <Overseer of Sul> +UPDATE `creature_template` SET `faction`=1078 WHERE `entry`=23568; -- Captain Darill +UPDATE `creature_template` SET `faction`=11 WHERE `entry`=2386; -- Southshore Guard +UPDATE `creature_template` SET `faction`=1194 WHERE `entry`=19666; -- Shadow Lord Xiraxis +UPDATE `creature_template` SET `faction`=12 WHERE `entry`=8856; -- Tyrion's Spybot +UPDATE `creature_template` SET `faction`=120 WHERE `entry`=2487; -- Fleet Master Seahorn <Blackwater Raiders> +UPDATE `creature_template` SET `faction`=123 WHERE `entry`=11616; -- Nathaniel Dumah +UPDATE `creature_template` SET `faction`=123 WHERE `entry`=1892; -- Moonrage Watcher +UPDATE `creature_template` SET `faction`=123 WHERE `entry`=1893; -- Moonrage Sentry +UPDATE `creature_template` SET `faction`=123 WHERE `entry`=1896; -- Moonrage Elder +UPDATE `creature_template` SET `faction`=123 WHERE `entry`=2269; -- Hillsbrad Miner +UPDATE `creature_template` SET `faction`=123 WHERE `entry`=2270; -- Hillsbrad Sentry +UPDATE `creature_template` SET `faction`=123 WHERE `entry`=2503; -- Hillsbrad Foreman +UPDATE `creature_template` SET `faction`=123 WHERE `entry`=3529; -- Moonrage Armorer +UPDATE `creature_template` SET `faction`=123 WHERE `entry`=3531; -- Moonrage Tailor +UPDATE `creature_template` SET `faction`=125 WHERE `entry`=8582; -- Kadrak +UPDATE `creature_template` SET `faction`=128 WHERE `entry`=8282; -- Highlord Mastrogonde +UPDATE `creature_template` SET `faction`=1354 WHERE `entry`=11486; -- Prince Tortheldrin +UPDATE `creature_template` SET `faction`=1354 WHERE `entry`=14358; -- Shen'dralar Ancient +UPDATE `creature_template` SET `faction`=1354 WHERE `entry`=14361; -- Shen'dralar Wisp +UPDATE `creature_template` SET `faction`=1355 WHERE `entry`=14368; -- Lorekeeper Lydros +UPDATE `creature_template` SET `faction`=1355 WHERE `entry`=14369; -- Shen'dralar Zealot +UPDATE `creature_template` SET `faction`=1355 WHERE `entry`=14371; -- Shen'dralar Provisioner +UPDATE `creature_template` SET `faction`=1355 WHERE `entry`=14381; -- Lorekeeper Javon +UPDATE `creature_template` SET `faction`=1355 WHERE `entry`=14382; -- Lorekeeper Mykos +UPDATE `creature_template` SET `faction`=1355 WHERE `entry`=14383; -- Lorekeeper Kildrath +UPDATE `creature_template` SET `faction`=14 WHERE `entry`=17429; -- Fel Orc Neophyte +UPDATE `creature_template` SET `faction`=14 WHERE `entry`=2385; -- Feral Mountain Lion +UPDATE `creature_template` SET `faction`=14 WHERE `entry`=24410; -- Vazruden the Herald Image +UPDATE `creature_template` SET `faction`=14 WHERE `entry`=26943; -- Battered Drakkari Berserker +UPDATE `creature_template` SET `faction`=14 WHERE `entry`=30012; -- Victorious Challenger +UPDATE `creature_template` SET `faction`=14 WHERE `entry`=3245; -- Ornery Plainstrider +UPDATE `creature_template` SET `faction`=14 WHERE `entry`=33564; -- Ironforge Valiant +UPDATE `creature_template` SET `faction`=14 WHERE `entry`=33739; -- Exodar Champion +UPDATE `creature_template` SET `faction`=14 WHERE `entry`=33749; -- Undercity Champion +UPDATE `creature_template` SET `faction`=14 WHERE `entry`=40142; -- Halion <The Twilight Destroyer> +UPDATE `creature_template` SET `faction`=14 WHERE `entry`=5089; -- Balos Jacken +UPDATE `creature_template` SET `faction`=14 WHERE `entry`=5431; -- Surf Glider +UPDATE `creature_template` SET `faction`=14 WHERE `entry`=5676; -- Summoned Voidwalker +UPDATE `creature_template` SET `faction`=14 WHERE `entry`=5677; -- Summoned Succubus +UPDATE `creature_template` SET `faction`=14 WHERE `entry`=7093; -- Vile Ooze +UPDATE `creature_template` SET `faction`=14 WHERE `entry`=832; -- Dust Devil +UPDATE `creature_template` SET `faction`=14 WHERE `entry`=8596; -- Plaguehound Runt +UPDATE `creature_template` SET `faction`=14 WHERE `entry`=8600; -- Plaguebat +UPDATE `creature_template` SET `faction`=149 WHERE `entry`=4834; -- Theramore Infiltrator +UPDATE `creature_template` SET `faction`=1576 WHERE `entry`=8563; -- Woodsman +UPDATE `creature_template` SET `faction`=1576 WHERE `entry`=8565; -- Pathstrider +UPDATE `creature_template` SET `faction`=1577 WHERE `entry`=15107; -- Arathi Horse +UPDATE `creature_template` SET `faction`=16 WHERE `entry`=15552; -- Doctor Weavil +UPDATE `creature_template` SET `faction`=16 WHERE `entry`=24410; -- Vazruden the Herald Image +UPDATE `creature_template` SET `faction`=16 WHERE `entry`=27655; -- Mage-Lord Urom +UPDATE `creature_template` SET `faction`=16 WHERE `entry`=37068; -- Spiritual Reflection +UPDATE `creature_template` SET `faction`=16 WHERE `entry`=37107; -- Spiritual Reflection +UPDATE `creature_template` SET `faction`=16 WHERE `entry`=37230; -- Spire Frostwyrm +UPDATE `creature_template` SET `faction`=16 WHERE `entry`=4067; -- Twilight Runner +UPDATE `creature_template` SET `faction`=16 WHERE `entry`=5300; -- Frayfeather Hippogryph +UPDATE `creature_template` SET `faction`=16 WHERE `entry`=5304; -- Frayfeather Stagwing +UPDATE `creature_template` SET `faction`=1605 WHERE `entry`=8197; -- Chronalis +UPDATE `creature_template` SET `faction`=1605 WHERE `entry`=8198; -- Tick +UPDATE `creature_template` SET `faction`=1606 WHERE `entry`=10600; -- Thontek Rumblehoof +UPDATE `creature_template` SET `faction`=1622 WHERE `entry`=4923; -- Guard Jarad +UPDATE `creature_template` SET `faction`=1625 WHERE `entry`=11102; -- Argent Rider <The Argent Dawn> +UPDATE `creature_template` SET `faction`=1630 WHERE `entry`=16300; -- Risen Creeper +UPDATE `creature_template` SET `faction`=1630 WHERE `entry`=16301; -- Risen Hungerer +UPDATE `creature_template` SET `faction`=1630 WHERE `entry`=16309; -- Gangled Cannibal +UPDATE `creature_template` SET `faction`=1630 WHERE `entry`=16322; -- Gangled Flesheater +UPDATE `creature_template` SET `faction`=1638 WHERE `entry`=17106; -- Vindicator Palanaar +UPDATE `creature_template` SET `faction`=1639 WHERE `entry`=17587; -- Draenei Youngling +UPDATE `creature_template` SET `faction`=1692 WHERE `entry`=24576; -- Riplash Myrmidon +UPDATE `creature_template` SET `faction`=1692 WHERE `entry`=24901; -- Maddened Frosthorn +UPDATE `creature_template` SET `faction`=1692 WHERE `entry`=29829; -- Drakkari Earthshaker +UPDATE `creature_template` SET `faction`=1718 WHERE `entry`=19215; -- Infernal Relay (Hellfire) +UPDATE `creature_template` SET `faction`=1732 WHERE `entry`=32712; -- The Amazing Zanzo +UPDATE `creature_template` SET `faction`=1732 WHERE `entry`=40502; -- Zalazane +UPDATE `creature_template` SET `faction`=1733 WHERE `entry`=16781; -- Midsummer Celebrant +UPDATE `creature_template` SET `faction`=1735 WHERE `entry`=26221; -- Earthen Ring Elder <The Earthen Ring> +UPDATE `creature_template` SET `faction`=1754 WHERE `entry`=18944; -- Fel Soldier +UPDATE `creature_template` SET `faction`=1754 WHERE `entry`=19005; -- Wrath Master +UPDATE `creature_template` SET `faction`=1756 WHERE `entry`=16831; -- Nethergarde Infantry +UPDATE `creature_template` SET `faction`=1756 WHERE `entry`=16842; -- Honor Hold Defender +UPDATE `creature_template` SET `faction`=1770 WHERE `entry`=29801; -- Bouldercrag the Rockshaper +UPDATE `creature_template` SET `faction`=1770 WHERE `entry`=30152; -- Bruor Ironbane +UPDATE `creature_template` SET `faction`=1770 WHERE `entry`=37577; -- Freed Horde Slave +UPDATE `creature_template` SET `faction`=1770 WHERE `entry`=37579; -- Freed Horde Slave +UPDATE `creature_template` SET `faction`=1770 WHERE `entry`=37580; -- Martin Victus +UPDATE `creature_template` SET `faction`=1770 WHERE `entry`=37581; -- Gorkun Ironskull +UPDATE `creature_template` SET `faction`=1771 WHERE `entry`=23750; -- Proto-Whelp Hatchling +UPDATE `creature_template` SET `faction`=1771 WHERE `entry`=38487; -- Fallen Warrior +UPDATE `creature_template` SET `faction`=1812 WHERE `entry`=29910; -- K3 Bruiser +UPDATE `creature_template` SET `faction`=1814 WHERE `entry`=26623; -- Scourge Brute +UPDATE `creature_template` SET `faction`=1814 WHERE `entry`=26635; -- Risen Drakkari Warrior +UPDATE `creature_template` SET `faction`=1847 WHERE `entry`=31326; -- Death Knight Initiate <Host of Suffering> +UPDATE `creature_template` SET `faction`=1847 WHERE `entry`=31327; -- Death Knight Initiate <Host of Suffering> +UPDATE `creature_template` SET `faction`=1878 WHERE `entry`=20465; -- Underbog Frenzy +UPDATE `creature_template` SET `faction`=189 WHERE `entry`=3816; -- Wild Buck +UPDATE `creature_template` SET `faction`=1892 WHERE `entry`=26170; -- Thassarian +UPDATE `creature_template` SET `faction`=1892 WHERE `entry`=582; -- Old Blanchy +UPDATE `creature_template` SET `faction`=190 WHERE `entry`=2098; -- Ram +UPDATE `creature_template` SET `faction`=190 WHERE `entry`=8883; -- Riding Horse +UPDATE `creature_template` SET `faction`=1953 WHERE `entry`=24954; -- Aged Magnataur +UPDATE `creature_template` SET `faction`=1965 WHERE `entry`=26639; -- Drakkari Shaman +UPDATE `creature_template` SET `faction`=1965 WHERE `entry`=30922; -- Umbral Brute +UPDATE `creature_template` SET `faction`=1965 WHERE `entry`=33139; -- Flame Leviathan Turret +UPDATE `creature_template` SET `faction`=1981 WHERE `entry`=26488; -- Taunka Pack Kodo +UPDATE `creature_template` SET `faction`=1991 WHERE `entry`=26126; -- Bone Warrior +UPDATE `creature_template` SET `faction`=2004 WHERE `entry`=26448; -- Stars' Rest Sentinel +UPDATE `creature_template` SET `faction`=2047 WHERE `entry`=25636; -- Captured Tuskarr Prisoner +UPDATE `creature_template` SET `faction`=2050 WHERE `entry`=29194; -- Amal'thazad +UPDATE `creature_template` SET `faction`=2050 WHERE `entry`=29195; -- Lady Alistra +UPDATE `creature_template` SET `faction`=2050 WHERE `entry`=29246; -- Highlord Darion Mograine +UPDATE `creature_template` SET `faction`=2070 WHERE `entry`=28028; -- Argent Shieldman +UPDATE `creature_template` SET `faction`=2070 WHERE `entry`=28029; -- Argent Crusader +UPDATE `creature_template` SET `faction`=2075 WHERE `entry`=28167; -- Stratholme Citizen +UPDATE `creature_template` SET `faction`=2075 WHERE `entry`=28169; -- Stratholme Resident +UPDATE `creature_template` SET `faction`=21 WHERE `entry`=1848; -- Lord Maldazzar +UPDATE `creature_template` SET `faction`=2104 WHERE `entry`=28471; -- Lady Alistra +UPDATE `creature_template` SET `faction`=2104 WHERE `entry`=28490; -- Disciple of Frost +UPDATE `creature_template` SET `faction`=2131 WHERE `entry`=38493; -- Argent Crusader +UPDATE `creature_template` SET `faction`=2209 WHERE `entry`=37011; -- The Damned +UPDATE `creature_template` SET `faction`=230 WHERE `entry`=7855; -- Southsea Pirate +UPDATE `creature_template` SET `faction`=230 WHERE `entry`=7856; -- Southsea Freebooter +UPDATE `creature_template` SET `faction`=231 WHERE `entry`=11806; -- Sentinel Onaeya +UPDATE `creature_template` SET `faction`=231 WHERE `entry`=17312; -- Magwin +UPDATE `creature_template` SET `faction`=24 WHERE `entry`=3868; -- Blood Seeker +UPDATE `creature_template` SET `faction`=24 WHERE `entry`=3873; -- Tormented Officer +UPDATE `creature_template` SET `faction`=24 WHERE `entry`=3887; -- Baron Silverlaine +UPDATE `creature_template` SET `faction`=24 WHERE `entry`=4278; -- Commander Springvale +UPDATE `creature_template` SET `faction`=29 WHERE `entry`=10050; -- Seikwa <Stable Master> +UPDATE `creature_template` SET `faction`=29 WHERE `entry`=13476; -- Balai Lok'Wein <Potions, Scrolls & Reagents> +UPDATE `creature_template` SET `faction`=29 WHERE `entry`=30611; -- Greela "The Grunt" Crankchain <Arena Organizer> +UPDATE `creature_template` SET `faction`=29 WHERE `entry`=3464; -- Gazrog +UPDATE `creature_template` SET `faction`=29 WHERE `entry`=6747; -- Innkeeper Kauth <Innkeeper> +UPDATE `creature_template` SET `faction`=290 WHERE `entry`=1706; -- Defias Prisoner +UPDATE `creature_template` SET `faction`=31 WHERE `entry`=16927; -- Stonescythe Whelp +UPDATE `creature_template` SET `faction`=35 WHERE `entry`=15694; -- Stormwind Reveler +UPDATE `creature_template` SET `faction`=35 WHERE `entry`=15719; -- Thunder Bluff Reveler +UPDATE `creature_template` SET `faction`=35 WHERE `entry`=15905; -- Darnassus Reveler +UPDATE `creature_template` SET `faction`=35 WHERE `entry`=15906; -- Ironforge Reveler +UPDATE `creature_template` SET `faction`=35 WHERE `entry`=15907; -- Undercity Reveler +UPDATE `creature_template` SET `faction`=35 WHERE `entry`=15908; -- Orgrimmar Reveler +UPDATE `creature_template` SET `faction`=35 WHERE `entry`=19912; -- Zeggon Botsnap <Arena Battlemaster> +UPDATE `creature_template` SET `faction`=35 WHERE `entry`=23131; -- Blood Knight Honor Guard +UPDATE `creature_template` SET `faction`=35 WHERE `entry`=26816; -- Focus Wizard +UPDATE `creature_template` SET `faction`=35 WHERE `entry`=2768; -- Professor Phizzlethorpe <Blackwater Raiders> +UPDATE `creature_template` SET `faction`=35 WHERE `entry`=29501; -- Scourge Gryphon +UPDATE `creature_template` SET `faction`=35 WHERE `entry`=29; -- Kanrethad <Master of Death> +UPDATE `creature_template` SET `faction`=35 WHERE `entry`=30352; -- Skybreaker Marine +UPDATE `creature_template` SET `faction`=35 WHERE `entry`=30755; -- Kor'kron Reaver +UPDATE `creature_template` SET `faction`=35 WHERE `entry`=31238; -- Hira Snowdawn <Cold Weather Flying Trainer> +UPDATE `creature_template` SET `faction`=35 WHERE `entry`=34984; -- World Trigger (Not Floating) +UPDATE `creature_template` SET `faction`=35 WHERE `entry`=35496; -- Rueben Lauren <Cloth Armor Merchant> +UPDATE `creature_template` SET `faction`=35 WHERE `entry`=35498; -- Horace Hunderland <Plate Armor Merchant> +UPDATE `creature_template` SET `faction`=35 WHERE `entry`=40199; -- Tiki Warrior +UPDATE `creature_template` SET `faction`=35 WHERE `entry`=40274; -- Restless Zombie +UPDATE `creature_template` SET `faction`=35 WHERE `entry`=7271; -- Witch Doctor Zum'rah +UPDATE `creature_template` SET `faction`=35 WHERE `entry`=9034; -- Hate'rel +UPDATE `creature_template` SET `faction`=35 WHERE `entry`=9035; -- Anger'rel +UPDATE `creature_template` SET `faction`=35 WHERE `entry`=9036; -- Vile'rel +UPDATE `creature_template` SET `faction`=35 WHERE `entry`=9037; -- Gloom'rel +UPDATE `creature_template` SET `faction`=35 WHERE `entry`=9038; -- Seeth'rel +UPDATE `creature_template` SET `faction`=35 WHERE `entry`=9039; -- Doom'rel +UPDATE `creature_template` SET `faction`=35 WHERE `entry`=9040; -- Dope'rel +UPDATE `creature_template` SET `faction`=38 WHERE `entry`=8211; -- Old Cliff Jumper +UPDATE `creature_template` SET `faction`=40 WHERE `entry`=10299; -- Scarshield Infiltrator <Scarshield Legion> +UPDATE `creature_template` SET `faction`=40 WHERE `entry`=334; -- Gath'Ilzogg <Warlord of the Blackrock Clan> +UPDATE `creature_template` SET `faction`=412 WHERE `entry`=15108; -- Forsaken Horse +UPDATE `creature_template` SET `faction`=413 WHERE `entry`=3251; -- Silithid Grub +UPDATE `creature_template` SET `faction`=413 WHERE `entry`=3252; -- Silithid Swarmer +UPDATE `creature_template` SET `faction`=416 WHERE `entry`=4857; -- Stone Keeper +UPDATE `creature_template` SET `faction`=44 WHERE `entry`=2356; -- Elder Gray Bear +UPDATE `creature_template` SET `faction`=45 WHERE `entry`=7034; -- Firegut Ogre Mage +UPDATE `creature_template` SET `faction`=45 WHERE `entry`=7035; -- Firegut Brute +UPDATE `creature_template` SET `faction`=475 WHERE `entry`=7407; -- Chief Engineer Bilgewhizzle <Gadgetzan Water Co.> +UPDATE `creature_template` SET `faction`=48 WHERE `entry`=2560; -- Highland Thrasher +UPDATE `creature_template` SET `faction`=48 WHERE `entry`=2561; -- Highland Fleshstalker +UPDATE `creature_template` SET `faction`=534 WHERE `entry`=15351; -- Alliance Brigadier General +UPDATE `creature_template` SET `faction`=534 WHERE `entry`=8436; -- Zamael Lunthistle +UPDATE `creature_template` SET `faction`=54 WHERE `entry`=8929; -- Princess Moira Bronzebeard <Princess of Ironforge> +UPDATE `creature_template` SET `faction`=55 WHERE `entry`=10301; -- Jaron Stoneshaper <Explorers' League> +UPDATE `creature_template` SET `faction`=55 WHERE `entry`=12617; -- Khaelyn Steelwing <Gryphon Master> +UPDATE `creature_template` SET `faction`=57 WHERE `entry`=1476; -- Hargin Mundar +UPDATE `creature_template` SET `faction`=575 WHERE `entry`=5856; -- Glassweb Spider +UPDATE `creature_template` SET `faction`=64 WHERE `entry`=39275; -- Gnomeregan Medic +UPDATE `creature_template` SET `faction`=655 WHERE `entry`=9524; -- Kolkar Invader +UPDATE `creature_template` SET `faction`=674 WHERE `entry`=5843; -- Slave Worker +UPDATE `creature_template` SET `faction`=68 WHERE `entry`=12636; -- Georgia <Bat Handler> +UPDATE `creature_template` SET `faction`=7 WHERE `entry`=32573; -- Valgarde Captive +UPDATE `creature_template` SET `faction`=7 WHERE `entry`=946; -- Frostmane Novice +UPDATE `creature_template` SET `faction`=714 WHERE `entry`=16580; -- Thrallmar Grunt +UPDATE `creature_template` SET `faction`=714 WHERE `entry`=16582; -- Thrallmar Marksman +UPDATE `creature_template` SET `faction`=735 WHERE `entry`=10043; -- Ribbly's Crony +UPDATE `creature_template` SET `faction`=754 WHERE `entry`=14621; -- Overseer Maltorius +UPDATE `creature_template` SET `faction`=775 WHERE `entry`=24484; -- Brewfest Reveler +UPDATE `creature_template` SET `faction`=775 WHERE `entry`=27811; -- Brew Vendor <Brew of the Month Club> +UPDATE `creature_template` SET `faction`=775 WHERE `entry`=27813; -- Brew Vendor <Brew of the Month Club> +UPDATE `creature_template` SET `faction`=775 WHERE `entry`=27817; -- Brew Vendor <Brew of the Month Club> +UPDATE `creature_template` SET `faction`=776 WHERE `entry`=15192; -- Anachronos +UPDATE `creature_template` SET `faction`=79 WHERE `entry`=4054; -- Laughing Sister +UPDATE `creature_template` SET `faction`=79 WHERE `entry`=7939; -- Feathermoon Sentinel +UPDATE `creature_template` SET `faction`=794 WHERE `entry`=11034; -- Lord Maxwell Tyrosus <The Argent Dawn> +UPDATE `creature_template` SET `faction`=794 WHERE `entry`=11036; -- Leonid Barthalomew the Revered <The Argent Dawn> +UPDATE `creature_template` SET `faction`=794 WHERE `entry`=11039; -- Duke Nicholas Zverenhoff <The Argent Dawn> +UPDATE `creature_template` SET `faction`=794 WHERE `entry`=11063; -- Carlin Redpath <The Argent Dawn> +UPDATE `creature_template` SET `faction`=80 WHERE `entry`=10300; -- Ranshalla +UPDATE `creature_template` SET `faction`=80 WHERE `entry`=11079; -- Wynd Nightchaser +UPDATE `creature_template` SET `faction`=80 WHERE `entry`=2084; -- Natheril Raincaller <General Goods> +UPDATE `creature_template` SET `faction`=80 WHERE `entry`=2303; -- Lyranne Feathersong <Food & Drink> +UPDATE `creature_template` SET `faction`=80 WHERE `entry`=3779; -- Syurana <Trade Supplies> +UPDATE `creature_template` SET `faction`=80 WHERE `entry`=3845; -- Shindrell Swiftfire +UPDATE `creature_template` SET `faction`=80 WHERE `entry`=3847; -- Orendil Broadleaf +UPDATE `creature_template` SET `faction`=814 WHERE `entry`=10839; -- Argent Officer Garush <The Argent Dawn> +UPDATE `creature_template` SET `faction`=814 WHERE `entry`=10840; -- Argent Officer Pureheart <The Argent Dawn> +UPDATE `creature_template` SET `faction`=814 WHERE `entry`=10857; -- Argent Quartermaster Lightspark <The Argent Dawn> +UPDATE `creature_template` SET `faction`=814 WHERE `entry`=11536; -- Quartermaster Miranda Breechlock <The Argent Dawn> +UPDATE `creature_template` SET `faction`=83 WHERE `entry`=1740; -- Deathguard Saltain +UPDATE `creature_template` SET `faction`=83 WHERE `entry`=3084; -- Bluffwatcher +UPDATE `creature_template` SET `faction`=83 WHERE `entry`=5724; -- Ageron Kargal +UPDATE `creature_template` SET `faction`=84 WHERE `entry`=4961; -- Dashel Stonefist +UPDATE `creature_template` SET `faction`=84 WHERE `entry`=6090; -- Bartleby <Drunk> +UPDATE `creature_template` SET `faction`=875 WHERE `entry`=39715; -- Ejector Mechano-Tank +UPDATE `creature_template` SET `faction`=89 WHERE `entry`=10418; -- Crimson Guardsman +UPDATE `creature_template` SET `faction`=89 WHERE `entry`=10605; -- Scarlet Medic +UPDATE `creature_template` SET `faction`=89 WHERE `entry`=1831; -- Scarlet Hunter +UPDATE `creature_template` SET `faction`=89 WHERE `entry`=1835; -- Scarlet Invoker +UPDATE `creature_template` SET `faction`=90 WHERE `entry`=9776; -- Flamekin Spitter +UPDATE `creature_template` SET `faction`=90 WHERE `entry`=9778; -- Flamekin Torcher +UPDATE `creature_template` SET `faction`=90 WHERE `entry`=9779; -- Flamekin Rager +UPDATE `creature_template` SET `faction`=93 WHERE `entry`=4016; -- Fey Dragon +UPDATE `creature_template` SET `faction`=974 WHERE `entry`=36830; -- Wrathbone Laborer + +-- diff entries update +UPDATE `creature_template` SET `faction`=14 WHERE `entry`=18603; +UPDATE `creature_template` SET `faction`=14 WHERE `entry`=40143; +UPDATE `creature_template` SET `faction`=14 WHERE `entry`=40144; +UPDATE `creature_template` SET `faction`=14 WHERE `entry`=40145; +UPDATE `creature_template` SET `faction`=16 WHERE `entry`=31560; +UPDATE `creature_template` SET `faction`=16 WHERE `entry`=38444; +UPDATE `creature_template` SET `faction`=1692 WHERE `entry`=30926; +UPDATE `creature_template` SET `faction`=1770 WHERE `entry`=37614; +UPDATE `creature_template` SET `faction`=1770 WHERE `entry`=37618; +UPDATE `creature_template` SET `faction`=1770 WHERE `entry`=37619; +UPDATE `creature_template` SET `faction`=1770 WHERE `entry`=37620; +UPDATE `creature_template` SET `faction`=1814 WHERE `entry`=31355; +UPDATE `creature_template` SET `faction`=1814 WHERE `entry`=31357; +UPDATE `creature_template` SET `faction`=1878 WHERE `entry`=21943; +UPDATE `creature_template` SET `faction`=1965 WHERE `entry`=31345; +UPDATE `creature_template` SET `faction`=1965 WHERE `entry`=34111; +UPDATE `creature_template` SET `faction`=2209 WHERE `entry`=38061; +UPDATE `creature_template` SET `faction`=974 WHERE `entry`=37638; |