diff options
| -rw-r--r-- | sql/updates/world/2014_08_29_06_world_creature_template.sql | 497 |
1 files changed, 497 insertions, 0 deletions
diff --git a/sql/updates/world/2014_08_29_06_world_creature_template.sql b/sql/updates/world/2014_08_29_06_world_creature_template.sql new file mode 100644 index 00000000000..cec02630f22 --- /dev/null +++ b/sql/updates/world/2014_08_29_06_world_creature_template.sql @@ -0,0 +1,497 @@ +UPDATE `creature_template` SET `faction`=103 WHERE `entry`=31543; +UPDATE `creature_template` SET `faction`=103 WHERE `entry`=40143; +UPDATE `creature_template` SET `faction`=103 WHERE `entry`=40144; +UPDATE `creature_template` SET `faction`=103 WHERE `entry`=40145; +UPDATE `creature_template` SET `faction`=114 WHERE `entry`=30808; +UPDATE `creature_template` SET `faction`=114 WHERE `entry`=31875; +UPDATE `creature_template` SET `faction`=114 WHERE `entry`=31878; +UPDATE `creature_template` SET `faction`=1194 WHERE `entry`=22565; +UPDATE `creature_template` SET `faction`=1194 WHERE `entry`=22578; +UPDATE `creature_template` SET `faction`=1194 WHERE `entry`=22686; +UPDATE `creature_template` SET `faction`=1194 WHERE `entry`=22768; +UPDATE `creature_template` SET `faction`=1194 WHERE `entry`=22769; +UPDATE `creature_template` SET `faction`=1194 WHERE `entry`=32044; +UPDATE `creature_template` SET `faction`=1194 WHERE `entry`=32056; +UPDATE `creature_template` SET `faction`=1194 WHERE `entry`=32107; +UPDATE `creature_template` SET `faction`=1194 WHERE `entry`=32108; +UPDATE `creature_template` SET `faction`=1194 WHERE `entry`=32109; +UPDATE `creature_template` SET `faction`=1194 WHERE `entry`=37365; +UPDATE `creature_template` SET `faction`=1194 WHERE `entry`=37377; +UPDATE `creature_template` SET `faction`=1194 WHERE `entry`=37428; +UPDATE `creature_template` SET `faction`=1194 WHERE `entry`=37429; +UPDATE `creature_template` SET `faction`=1194 WHERE `entry`=37430; +UPDATE `creature_template` SET `faction`=12 WHERE `entry`=36088; +UPDATE `creature_template` SET `faction`=1214 WHERE `entry`=22530; +UPDATE `creature_template` SET `faction`=1214 WHERE `entry`=22532; +UPDATE `creature_template` SET `faction`=1214 WHERE `entry`=22534; +UPDATE `creature_template` SET `faction`=1214 WHERE `entry`=22536; +UPDATE `creature_template` SET `faction`=1214 WHERE `entry`=22538; +UPDATE `creature_template` SET `faction`=1214 WHERE `entry`=22539; +UPDATE `creature_template` SET `faction`=1214 WHERE `entry`=22556; +UPDATE `creature_template` SET `faction`=1214 WHERE `entry`=22564; +UPDATE `creature_template` SET `faction`=1214 WHERE `entry`=22566; +UPDATE `creature_template` SET `faction`=1214 WHERE `entry`=22590; +UPDATE `creature_template` SET `faction`=1214 WHERE `entry`=22592; +UPDATE `creature_template` SET `faction`=1214 WHERE `entry`=22594; +UPDATE `creature_template` SET `faction`=1214 WHERE `entry`=22603; +UPDATE `creature_template` SET `faction`=1214 WHERE `entry`=22610; +UPDATE `creature_template` SET `faction`=1214 WHERE `entry`=22612; +UPDATE `creature_template` SET `faction`=1214 WHERE `entry`=22629; +UPDATE `creature_template` SET `faction`=1214 WHERE `entry`=22664; +UPDATE `creature_template` SET `faction`=1214 WHERE `entry`=22669; +UPDATE `creature_template` SET `faction`=1214 WHERE `entry`=22673; +UPDATE `creature_template` SET `faction`=1214 WHERE `entry`=22675; +UPDATE `creature_template` SET `faction`=1214 WHERE `entry`=22677; +UPDATE `creature_template` SET `faction`=1214 WHERE `entry`=22688; +UPDATE `creature_template` SET `faction`=1214 WHERE `entry`=22716; +UPDATE `creature_template` SET `faction`=1214 WHERE `entry`=22718; +UPDATE `creature_template` SET `faction`=1214 WHERE `entry`=22720; +UPDATE `creature_template` SET `faction`=1214 WHERE `entry`=22741; +UPDATE `creature_template` SET `faction`=1214 WHERE `entry`=22746; +UPDATE `creature_template` SET `faction`=1214 WHERE `entry`=22752; +UPDATE `creature_template` SET `faction`=1214 WHERE `entry`=22754; +UPDATE `creature_template` SET `faction`=1214 WHERE `entry`=22755; +UPDATE `creature_template` SET `faction`=1214 WHERE `entry`=22757; +UPDATE `creature_template` SET `faction`=1214 WHERE `entry`=22771; +UPDATE `creature_template` SET `faction`=1214 WHERE `entry`=22773; +UPDATE `creature_template` SET `faction`=1214 WHERE `entry`=22774; +UPDATE `creature_template` SET `faction`=1214 WHERE `entry`=22776; +UPDATE `creature_template` SET `faction`=1214 WHERE `entry`=31822; +UPDATE `creature_template` SET `faction`=1214 WHERE `entry`=31904; +UPDATE `creature_template` SET `faction`=1214 WHERE `entry`=31906; +UPDATE `creature_template` SET `faction`=1214 WHERE `entry`=31928; +UPDATE `creature_template` SET `faction`=1214 WHERE `entry`=31930; +UPDATE `creature_template` SET `faction`=1214 WHERE `entry`=31935; +UPDATE `creature_template` SET `faction`=1214 WHERE `entry`=31937; +UPDATE `creature_template` SET `faction`=1214 WHERE `entry`=31939; +UPDATE `creature_template` SET `faction`=1214 WHERE `entry`=31941; +UPDATE `creature_template` SET `faction`=1214 WHERE `entry`=31943; +UPDATE `creature_template` SET `faction`=1214 WHERE `entry`=31945; +UPDATE `creature_template` SET `faction`=1214 WHERE `entry`=31962; +UPDATE `creature_template` SET `faction`=1214 WHERE `entry`=31985; +UPDATE `creature_template` SET `faction`=1214 WHERE `entry`=31988; +UPDATE `creature_template` SET `faction`=1214 WHERE `entry`=32002; +UPDATE `creature_template` SET `faction`=1214 WHERE `entry`=32012; +UPDATE `creature_template` SET `faction`=1214 WHERE `entry`=32017; +UPDATE `creature_template` SET `faction`=1214 WHERE `entry`=32023; +UPDATE `creature_template` SET `faction`=1214 WHERE `entry`=32058; +UPDATE `creature_template` SET `faction`=1214 WHERE `entry`=32060; +UPDATE `creature_template` SET `faction`=1214 WHERE `entry`=32065; +UPDATE `creature_template` SET `faction`=1214 WHERE `entry`=32067; +UPDATE `creature_template` SET `faction`=1214 WHERE `entry`=32069; +UPDATE `creature_template` SET `faction`=1214 WHERE `entry`=32071; +UPDATE `creature_template` SET `faction`=1214 WHERE `entry`=32073; +UPDATE `creature_template` SET `faction`=1214 WHERE `entry`=32075; +UPDATE `creature_template` SET `faction`=1214 WHERE `entry`=32122; +UPDATE `creature_template` SET `faction`=1214 WHERE `entry`=32124; +UPDATE `creature_template` SET `faction`=1214 WHERE `entry`=32128; +UPDATE `creature_template` SET `faction`=1214 WHERE `entry`=32130; +UPDATE `creature_template` SET `faction`=1214 WHERE `entry`=32132; +UPDATE `creature_template` SET `faction`=1214 WHERE `entry`=32135; +UPDATE `creature_template` SET `faction`=1214 WHERE `entry`=32138; +UPDATE `creature_template` SET `faction`=1214 WHERE `entry`=37246; +UPDATE `creature_template` SET `faction`=1214 WHERE `entry`=37248; +UPDATE `creature_template` SET `faction`=1214 WHERE `entry`=37253; +UPDATE `creature_template` SET `faction`=1214 WHERE `entry`=37255; +UPDATE `creature_template` SET `faction`=1214 WHERE `entry`=37257; +UPDATE `creature_template` SET `faction`=1214 WHERE `entry`=37259; +UPDATE `creature_template` SET `faction`=1214 WHERE `entry`=37261; +UPDATE `creature_template` SET `faction`=1214 WHERE `entry`=37263; +UPDATE `creature_template` SET `faction`=1214 WHERE `entry`=37280; +UPDATE `creature_template` SET `faction`=1214 WHERE `entry`=37304; +UPDATE `creature_template` SET `faction`=1214 WHERE `entry`=37307; +UPDATE `creature_template` SET `faction`=1214 WHERE `entry`=37321; +UPDATE `creature_template` SET `faction`=1214 WHERE `entry`=37331; +UPDATE `creature_template` SET `faction`=1214 WHERE `entry`=37336; +UPDATE `creature_template` SET `faction`=1214 WHERE `entry`=37343; +UPDATE `creature_template` SET `faction`=1214 WHERE `entry`=37363; +UPDATE `creature_template` SET `faction`=1214 WHERE `entry`=37379; +UPDATE `creature_template` SET `faction`=1214 WHERE `entry`=37381; +UPDATE `creature_template` SET `faction`=1214 WHERE `entry`=37386; +UPDATE `creature_template` SET `faction`=1214 WHERE `entry`=37388; +UPDATE `creature_template` SET `faction`=1214 WHERE `entry`=37390; +UPDATE `creature_template` SET `faction`=1214 WHERE `entry`=37392; +UPDATE `creature_template` SET `faction`=1214 WHERE `entry`=37394; +UPDATE `creature_template` SET `faction`=1214 WHERE `entry`=37396; +UPDATE `creature_template` SET `faction`=1214 WHERE `entry`=37446; +UPDATE `creature_template` SET `faction`=1214 WHERE `entry`=37448; +UPDATE `creature_template` SET `faction`=1214 WHERE `entry`=37453; +UPDATE `creature_template` SET `faction`=1214 WHERE `entry`=37455; +UPDATE `creature_template` SET `faction`=1214 WHERE `entry`=37457; +UPDATE `creature_template` SET `faction`=1214 WHERE `entry`=37459; +UPDATE `creature_template` SET `faction`=1214 WHERE `entry`=37461; +UPDATE `creature_template` SET `faction`=1214 WHERE `entry`=37463; +UPDATE `creature_template` SET `faction`=1214 WHERE `entry`=37466; +UPDATE `creature_template` SET `faction`=1215 WHERE `entry`=22553; +UPDATE `creature_template` SET `faction`=1215 WHERE `entry`=31995; +UPDATE `creature_template` SET `faction`=1215 WHERE `entry`=37314; +UPDATE `creature_template` SET `faction`=1216 WHERE `entry`=22525; +UPDATE `creature_template` SET `faction`=1216 WHERE `entry`=22529; +UPDATE `creature_template` SET `faction`=1216 WHERE `entry`=22531; +UPDATE `creature_template` SET `faction`=1216 WHERE `entry`=22533; +UPDATE `creature_template` SET `faction`=1216 WHERE `entry`=22535; +UPDATE `creature_template` SET `faction`=1216 WHERE `entry`=22537; +UPDATE `creature_template` SET `faction`=1216 WHERE `entry`=22563; +UPDATE `creature_template` SET `faction`=1216 WHERE `entry`=22570; +UPDATE `creature_template` SET `faction`=1216 WHERE `entry`=22587; +UPDATE `creature_template` SET `faction`=1216 WHERE `entry`=22591; +UPDATE `creature_template` SET `faction`=1216 WHERE `entry`=22593; +UPDATE `creature_template` SET `faction`=1216 WHERE `entry`=22607; +UPDATE `creature_template` SET `faction`=1216 WHERE `entry`=22611; +UPDATE `creature_template` SET `faction`=1216 WHERE `entry`=22620; +UPDATE `creature_template` SET `faction`=1216 WHERE `entry`=22621; +UPDATE `creature_template` SET `faction`=1216 WHERE `entry`=22632; +UPDATE `creature_template` SET `faction`=1216 WHERE `entry`=22645; +UPDATE `creature_template` SET `faction`=1216 WHERE `entry`=22662; +UPDATE `creature_template` SET `faction`=1216 WHERE `entry`=22663; +UPDATE `creature_template` SET `faction`=1216 WHERE `entry`=22667; +UPDATE `creature_template` SET `faction`=1216 WHERE `entry`=22668; +UPDATE `creature_template` SET `faction`=1216 WHERE `entry`=22671; +UPDATE `creature_template` SET `faction`=1216 WHERE `entry`=22672; +UPDATE `creature_template` SET `faction`=1216 WHERE `entry`=22687; +UPDATE `creature_template` SET `faction`=1216 WHERE `entry`=22692; +UPDATE `creature_template` SET `faction`=1216 WHERE `entry`=22693; +UPDATE `creature_template` SET `faction`=1216 WHERE `entry`=22705; +UPDATE `creature_template` SET `faction`=1216 WHERE `entry`=22709; +UPDATE `creature_template` SET `faction`=1216 WHERE `entry`=22713; +UPDATE `creature_template` SET `faction`=1216 WHERE `entry`=22714; +UPDATE `creature_template` SET `faction`=1216 WHERE `entry`=22717; +UPDATE `creature_template` SET `faction`=1216 WHERE `entry`=22719; +UPDATE `creature_template` SET `faction`=1216 WHERE `entry`=22753; +UPDATE `creature_template` SET `faction`=1216 WHERE `entry`=22756; +UPDATE `creature_template` SET `faction`=1216 WHERE `entry`=22758; +UPDATE `creature_template` SET `faction`=1216 WHERE `entry`=22770; +UPDATE `creature_template` SET `faction`=1216 WHERE `entry`=22772; +UPDATE `creature_template` SET `faction`=1216 WHERE `entry`=22775; +UPDATE `creature_template` SET `faction`=1216 WHERE `entry`=22777; +UPDATE `creature_template` SET `faction`=1216 WHERE `entry`=31905; +UPDATE `creature_template` SET `faction`=1216 WHERE `entry`=31907; +UPDATE `creature_template` SET `faction`=1216 WHERE `entry`=31917; +UPDATE `creature_template` SET `faction`=1216 WHERE `entry`=31919; +UPDATE `creature_template` SET `faction`=1216 WHERE `entry`=31927; +UPDATE `creature_template` SET `faction`=1216 WHERE `entry`=31929; +UPDATE `creature_template` SET `faction`=1216 WHERE `entry`=31931; +UPDATE `creature_template` SET `faction`=1216 WHERE `entry`=31934; +UPDATE `creature_template` SET `faction`=1216 WHERE `entry`=31936; +UPDATE `creature_template` SET `faction`=1216 WHERE `entry`=31938; +UPDATE `creature_template` SET `faction`=1216 WHERE `entry`=31940; +UPDATE `creature_template` SET `faction`=1216 WHERE `entry`=31942; +UPDATE `creature_template` SET `faction`=1216 WHERE `entry`=31944; +UPDATE `creature_template` SET `faction`=1216 WHERE `entry`=31959; +UPDATE `creature_template` SET `faction`=1216 WHERE `entry`=31973; +UPDATE `creature_template` SET `faction`=1216 WHERE `entry`=32010; +UPDATE `creature_template` SET `faction`=1216 WHERE `entry`=32036; +UPDATE `creature_template` SET `faction`=1216 WHERE `entry`=32040; +UPDATE `creature_template` SET `faction`=1216 WHERE `entry`=32055; +UPDATE `creature_template` SET `faction`=1216 WHERE `entry`=32059; +UPDATE `creature_template` SET `faction`=1216 WHERE `entry`=32061; +UPDATE `creature_template` SET `faction`=1216 WHERE `entry`=32062; +UPDATE `creature_template` SET `faction`=1216 WHERE `entry`=32064; +UPDATE `creature_template` SET `faction`=1216 WHERE `entry`=32066; +UPDATE `creature_template` SET `faction`=1216 WHERE `entry`=32068; +UPDATE `creature_template` SET `faction`=1216 WHERE `entry`=32070; +UPDATE `creature_template` SET `faction`=1216 WHERE `entry`=32072; +UPDATE `creature_template` SET `faction`=1216 WHERE `entry`=32074; +UPDATE `creature_template` SET `faction`=1216 WHERE `entry`=32102; +UPDATE `creature_template` SET `faction`=1216 WHERE `entry`=32103; +UPDATE `creature_template` SET `faction`=1216 WHERE `entry`=32121; +UPDATE `creature_template` SET `faction`=1216 WHERE `entry`=32123; +UPDATE `creature_template` SET `faction`=1216 WHERE `entry`=32127; +UPDATE `creature_template` SET `faction`=1216 WHERE `entry`=32129; +UPDATE `creature_template` SET `faction`=1216 WHERE `entry`=32131; +UPDATE `creature_template` SET `faction`=1216 WHERE `entry`=32133; +UPDATE `creature_template` SET `faction`=1216 WHERE `entry`=32134; +UPDATE `creature_template` SET `faction`=1216 WHERE `entry`=32136; +UPDATE `creature_template` SET `faction`=1216 WHERE `entry`=37233; +UPDATE `creature_template` SET `faction`=1216 WHERE `entry`=37235; +UPDATE `creature_template` SET `faction`=1216 WHERE `entry`=37245; +UPDATE `creature_template` SET `faction`=1216 WHERE `entry`=37247; +UPDATE `creature_template` SET `faction`=1216 WHERE `entry`=37249; +UPDATE `creature_template` SET `faction`=1216 WHERE `entry`=37252; +UPDATE `creature_template` SET `faction`=1216 WHERE `entry`=37254; +UPDATE `creature_template` SET `faction`=1216 WHERE `entry`=37256; +UPDATE `creature_template` SET `faction`=1216 WHERE `entry`=37258; +UPDATE `creature_template` SET `faction`=1216 WHERE `entry`=37260; +UPDATE `creature_template` SET `faction`=1216 WHERE `entry`=37262; +UPDATE `creature_template` SET `faction`=1216 WHERE `entry`=37277; +UPDATE `creature_template` SET `faction`=1216 WHERE `entry`=37292; +UPDATE `creature_template` SET `faction`=1216 WHERE `entry`=37329; +UPDATE `creature_template` SET `faction`=1216 WHERE `entry`=37356; +UPDATE `creature_template` SET `faction`=1216 WHERE `entry`=37360; +UPDATE `creature_template` SET `faction`=1216 WHERE `entry`=37376; +UPDATE `creature_template` SET `faction`=1216 WHERE `entry`=37380; +UPDATE `creature_template` SET `faction`=1216 WHERE `entry`=37382; +UPDATE `creature_template` SET `faction`=1216 WHERE `entry`=37383; +UPDATE `creature_template` SET `faction`=1216 WHERE `entry`=37385; +UPDATE `creature_template` SET `faction`=1216 WHERE `entry`=37387; +UPDATE `creature_template` SET `faction`=1216 WHERE `entry`=37389; +UPDATE `creature_template` SET `faction`=1216 WHERE `entry`=37391; +UPDATE `creature_template` SET `faction`=1216 WHERE `entry`=37393; +UPDATE `creature_template` SET `faction`=1216 WHERE `entry`=37395; +UPDATE `creature_template` SET `faction`=1216 WHERE `entry`=37423; +UPDATE `creature_template` SET `faction`=1216 WHERE `entry`=37424; +UPDATE `creature_template` SET `faction`=1216 WHERE `entry`=37445; +UPDATE `creature_template` SET `faction`=1216 WHERE `entry`=37447; +UPDATE `creature_template` SET `faction`=1216 WHERE `entry`=37449; +UPDATE `creature_template` SET `faction`=1216 WHERE `entry`=37452; +UPDATE `creature_template` SET `faction`=1216 WHERE `entry`=37454; +UPDATE `creature_template` SET `faction`=1216 WHERE `entry`=37456; +UPDATE `creature_template` SET `faction`=1216 WHERE `entry`=37458; +UPDATE `creature_template` SET `faction`=1216 WHERE `entry`=37460; +UPDATE `creature_template` SET `faction`=1216 WHERE `entry`=37462; +UPDATE `creature_template` SET `faction`=1216 WHERE `entry`=37464; +UPDATE `creature_template` SET `faction`=1217 WHERE `entry`=22764; +UPDATE `creature_template` SET `faction`=1334 WHERE `entry`=22554; +UPDATE `creature_template` SET `faction`=1334 WHERE `entry`=22600; +UPDATE `creature_template` SET `faction`=1334 WHERE `entry`=31997; +UPDATE `creature_template` SET `faction`=1334 WHERE `entry`=37316; +UPDATE `creature_template` SET `faction`=1335 WHERE `entry`=22549; +UPDATE `creature_template` SET `faction`=1335 WHERE `entry`=22602; +UPDATE `creature_template` SET `faction`=1335 WHERE `entry`=31982; +UPDATE `creature_template` SET `faction`=1335 WHERE `entry`=37301; +UPDATE `creature_template` SET `faction`=1375 WHERE `entry`=18616; +UPDATE `creature_template` SET `faction`=14 WHERE `entry`=19897; +UPDATE `creature_template` SET `faction`=14 WHERE `entry`=20308; +UPDATE `creature_template` SET `faction`=14 WHERE `entry`=20572; +UPDATE `creature_template` SET `faction`=14 WHERE `entry`=20573; +UPDATE `creature_template` SET `faction`=14 WHERE `entry`=22626; +UPDATE `creature_template` SET `faction`=14 WHERE `entry`=22642; +UPDATE `creature_template` SET `faction`=14 WHERE `entry`=25543; +UPDATE `creature_template` SET `faction`=14 WHERE `entry`=29357; +UPDATE `creature_template` SET `faction`=14 WHERE `entry`=30000; +UPDATE `creature_template` SET `faction`=14 WHERE `entry`=30016; +UPDATE `creature_template` SET `faction`=14 WHERE `entry`=30047; +UPDATE `creature_template` SET `faction`=14 WHERE `entry`=30049; +UPDATE `creature_template` SET `faction`=14 WHERE `entry`=30068; +UPDATE `creature_template` SET `faction`=14 WHERE `entry`=30781; +UPDATE `creature_template` SET `faction`=14 WHERE `entry`=30783; +UPDATE `creature_template` SET `faction`=14 WHERE `entry`=30785; +UPDATE `creature_template` SET `faction`=14 WHERE `entry`=30787; +UPDATE `creature_template` SET `faction`=14 WHERE `entry`=31560; +UPDATE `creature_template` SET `faction`=14 WHERE `entry`=31670; +UPDATE `creature_template` SET `faction`=14 WHERE `entry`=31974; +UPDATE `creature_template` SET `faction`=14 WHERE `entry`=32005; +UPDATE `creature_template` SET `faction`=14 WHERE `entry`=32218; +UPDATE `creature_template` SET `faction`=14 WHERE `entry`=33397; +UPDATE `creature_template` SET `faction`=14 WHERE `entry`=34218; +UPDATE `creature_template` SET `faction`=14 WHERE `entry`=34228; +UPDATE `creature_template` SET `faction`=14 WHERE `entry`=35546; +UPDATE `creature_template` SET `faction`=14 WHERE `entry`=35559; +UPDATE `creature_template` SET `faction`=14 WHERE `entry`=35560; +UPDATE `creature_template` SET `faction`=14 WHERE `entry`=36473; +UPDATE `creature_template` SET `faction`=14 WHERE `entry`=36474; +UPDATE `creature_template` SET `faction`=14 WHERE `entry`=36475; +UPDATE `creature_template` SET `faction`=14 WHERE `entry`=37293; +UPDATE `creature_template` SET `faction`=14 WHERE `entry`=37324; +UPDATE `creature_template` SET `faction`=14 WHERE `entry`=38138; +UPDATE `creature_template` SET `faction`=1534 WHERE `entry`=22547; +UPDATE `creature_template` SET `faction`=1534 WHERE `entry`=22579; +UPDATE `creature_template` SET `faction`=1534 WHERE `entry`=31908; +UPDATE `creature_template` SET `faction`=1534 WHERE `entry`=31971; +UPDATE `creature_template` SET `faction`=1534 WHERE `entry`=37290; +UPDATE `creature_template` SET `faction`=1534 WHERE `entry`=37434; +UPDATE `creature_template` SET `faction`=1554 WHERE `entry`=22639; +UPDATE `creature_template` SET `faction`=1594 WHERE `entry`=22627; +UPDATE `creature_template` SET `faction`=1594 WHERE `entry`=31821; +UPDATE `creature_template` SET `faction`=1594 WHERE `entry`=37341; +UPDATE `creature_template` SET `faction`=16 WHERE `entry`=19898; +UPDATE `creature_template` SET `faction`=16 WHERE `entry`=19899; +UPDATE `creature_template` SET `faction`=16 WHERE `entry`=19900; +UPDATE `creature_template` SET `faction`=16 WHERE `entry`=20303; +UPDATE `creature_template` SET `faction`=16 WHERE `entry`=20305; +UPDATE `creature_template` SET `faction`=16 WHERE `entry`=20309; +UPDATE `creature_template` SET `faction`=16 WHERE `entry`=20314; +UPDATE `creature_template` SET `faction`=16 WHERE `entry`=20316; +UPDATE `creature_template` SET `faction`=16 WHERE `entry`=20320; +UPDATE `creature_template` SET `faction`=16 WHERE `entry`=20321; +UPDATE `creature_template` SET `faction`=16 WHERE `entry`=20322; +UPDATE `creature_template` SET `faction`=16 WHERE `entry`=20323; +UPDATE `creature_template` SET `faction`=16 WHERE `entry`=20569; +UPDATE `creature_template` SET `faction`=16 WHERE `entry`=20574; +UPDATE `creature_template` SET `faction`=16 WHERE `entry`=20575; +UPDATE `creature_template` SET `faction`=16 WHERE `entry`=20578; +UPDATE `creature_template` SET `faction`=16 WHERE `entry`=20579; +UPDATE `creature_template` SET `faction`=16 WHERE `entry`=20580; +UPDATE `creature_template` SET `faction`=16 WHERE `entry`=20581; +UPDATE `creature_template` SET `faction`=16 WHERE `entry`=20584; +UPDATE `creature_template` SET `faction`=16 WHERE `entry`=20585; +UPDATE `creature_template` SET `faction`=16 WHERE `entry`=20586; +UPDATE `creature_template` SET `faction`=16 WHERE `entry`=20596; +UPDATE `creature_template` SET `faction`=16 WHERE `entry`=20655; +UPDATE `creature_template` SET `faction`=16 WHERE `entry`=20658; +UPDATE `creature_template` SET `faction`=16 WHERE `entry`=20700; +UPDATE `creature_template` SET `faction`=16 WHERE `entry`=20993; +UPDATE `creature_template` SET `faction`=16 WHERE `entry`=21550; +UPDATE `creature_template` SET `faction`=16 WHERE `entry`=21553; +UPDATE `creature_template` SET `faction`=16 WHERE `entry`=21556; +UPDATE `creature_template` SET `faction`=16 WHERE `entry`=21557; +UPDATE `creature_template` SET `faction`=16 WHERE `entry`=21566; +UPDATE `creature_template` SET `faction`=16 WHERE `entry`=21567; +UPDATE `creature_template` SET `faction`=16 WHERE `entry`=21568; +UPDATE `creature_template` SET `faction`=16 WHERE `entry`=21569; +UPDATE `creature_template` SET `faction`=16 WHERE `entry`=21573; +UPDATE `creature_template` SET `faction`=16 WHERE `entry`=21579; +UPDATE `creature_template` SET `faction`=16 WHERE `entry`=21580; +UPDATE `creature_template` SET `faction`=16 WHERE `entry`=21583; +UPDATE `creature_template` SET `faction`=16 WHERE `entry`=21616; +UPDATE `creature_template` SET `faction`=16 WHERE `entry`=21647; +UPDATE `creature_template` SET `faction`=16 WHERE `entry`=21918; +UPDATE `creature_template` SET `faction`=16 WHERE `entry`=21943; +UPDATE `creature_template` SET `faction`=16 WHERE `entry`=21991; +UPDATE `creature_template` SET `faction`=16 WHERE `entry`=22604; +UPDATE `creature_template` SET `faction`=16 WHERE `entry`=22636; +UPDATE `creature_template` SET `faction`=16 WHERE `entry`=22728; +UPDATE `creature_template` SET `faction`=16 WHERE `entry`=25549; +UPDATE `creature_template` SET `faction`=16 WHERE `entry`=25553; +UPDATE `creature_template` SET `faction`=16 WHERE `entry`=25555; +UPDATE `creature_template` SET `faction`=16 WHERE `entry`=25564; +UPDATE `creature_template` SET `faction`=16 WHERE `entry`=30496; +UPDATE `creature_template` SET `faction`=16 WHERE `entry`=30498; +UPDATE `creature_template` SET `faction`=16 WHERE `entry`=30509; +UPDATE `creature_template` SET `faction`=16 WHERE `entry`=31339; +UPDATE `creature_template` SET `faction`=16 WHERE `entry`=31345; +UPDATE `creature_template` SET `faction`=16 WHERE `entry`=31354; +UPDATE `creature_template` SET `faction`=16 WHERE `entry`=31355; +UPDATE `creature_template` SET `faction`=16 WHERE `entry`=31357; +UPDATE `creature_template` SET `faction`=16 WHERE `entry`=31379; +UPDATE `creature_template` SET `faction`=16 WHERE `entry`=31382; +UPDATE `creature_template` SET `faction`=16 WHERE `entry`=31390; +UPDATE `creature_template` SET `faction`=16 WHERE `entry`=31514; +UPDATE `creature_template` SET `faction`=16 WHERE `entry`=31922; +UPDATE `creature_template` SET `faction`=16 WHERE `entry`=31925; +UPDATE `creature_template` SET `faction`=16 WHERE `entry`=32111; +UPDATE `creature_template` SET `faction`=16 WHERE `entry`=32583; +UPDATE `creature_template` SET `faction`=16 WHERE `entry`=33690; +UPDATE `creature_template` SET `faction`=16 WHERE `entry`=37238; +UPDATE `creature_template` SET `faction`=16 WHERE `entry`=37241; +UPDATE `creature_template` SET `faction`=16 WHERE `entry`=37432; +UPDATE `creature_template` SET `faction`=1638 WHERE `entry`=36083; +UPDATE `creature_template` SET `faction`=168 WHERE `entry`=32796; +UPDATE `creature_template` SET `faction`=1692 WHERE `entry`=21584; +UPDATE `creature_template` SET `faction`=1693 WHERE `entry`=20182; +UPDATE `creature_template` SET `faction`=1713 WHERE `entry`=20186; +UPDATE `creature_template` SET `faction`=1718 WHERE `entry`=20746; +UPDATE `creature_template` SET `faction`=1720 WHERE `entry`=20737; +UPDATE `creature_template` SET `faction`=1720 WHERE `entry`=20738; +UPDATE `creature_template` SET `faction`=1720 WHERE `entry`=20745; +UPDATE `creature_template` SET `faction`=1720 WHERE `entry`=21712; +UPDATE `creature_template` SET `faction`=1720 WHERE `entry`=22166; +UPDATE `creature_template` SET `faction`=1720 WHERE `entry`=22167; +UPDATE `creature_template` SET `faction`=1720 WHERE `entry`=22168; +UPDATE `creature_template` SET `faction`=1720 WHERE `entry`=22171; +UPDATE `creature_template` SET `faction`=1720 WHERE `entry`=22172; +UPDATE `creature_template` SET `faction`=1720 WHERE `entry`=31486; +UPDATE `creature_template` SET `faction`=1720 WHERE `entry`=31490; +UPDATE `creature_template` SET `faction`=1720 WHERE `entry`=31493; +UPDATE `creature_template` SET `faction`=1720 WHERE `entry`=31494; +UPDATE `creature_template` SET `faction`=1720 WHERE `entry`=32192; +UPDATE `creature_template` SET `faction`=1732 WHERE `entry`=35429; +UPDATE `creature_template` SET `faction`=1735 WHERE `entry`=35425; +UPDATE `creature_template` SET `faction`=1747 WHERE `entry`=20550; +UPDATE `creature_template` SET `faction`=1748 WHERE `entry`=22129; +UPDATE `creature_template` SET `faction`=1748 WHERE `entry`=26651; +UPDATE `creature_template` SET `faction`=1780 WHERE `entry`=30759; +UPDATE `creature_template` SET `faction`=1780 WHERE `entry`=30760; +UPDATE `creature_template` SET `faction`=1780 WHERE `entry`=30761; +UPDATE `creature_template` SET `faction`=1814 WHERE `entry`=31593; +UPDATE `creature_template` SET `faction`=1814 WHERE `entry`=31600; +UPDATE `creature_template` SET `faction`=1874 WHERE `entry`=30798; +UPDATE `creature_template` SET `faction`=1885 WHERE `entry`=31664; +UPDATE `creature_template` SET `faction`=1885 WHERE `entry`=31677; +UPDATE `creature_template` SET `faction`=1892 WHERE `entry`=26099; +UPDATE `creature_template` SET `faction`=190 WHERE `entry`=28168; +UPDATE `creature_template` SET `faction`=190 WHERE `entry`=30758; +UPDATE `creature_template` SET `faction`=190 WHERE `entry`=30768; +UPDATE `creature_template` SET `faction`=190 WHERE `entry`=30769; +UPDATE `creature_template` SET `faction`=190 WHERE `entry`=30776; +UPDATE `creature_template` SET `faction`=190 WHERE `entry`=33789; +UPDATE `creature_template` SET `faction`=1998 WHERE `entry`=26338; +UPDATE `creature_template` SET `faction`=1998 WHERE `entry`=26339; +UPDATE `creature_template` SET `faction`=1998 WHERE `entry`=26340; +UPDATE `creature_template` SET `faction`=1998 WHERE `entry`=26341; +UPDATE `creature_template` SET `faction`=1998 WHERE `entry`=26342; +UPDATE `creature_template` SET `faction`=2075 WHERE `entry`=31183; +UPDATE `creature_template` SET `faction`=21 WHERE `entry`=30057; +UPDATE `creature_template` SET `faction`=21 WHERE `entry`=30779; +UPDATE `creature_template` SET `faction`=21 WHERE `entry`=30815; +UPDATE `creature_template` SET `faction`=21 WHERE `entry`=31647; +UPDATE `creature_template` SET `faction`=21 WHERE `entry`=33664; +UPDATE `creature_template` SET `faction`=21 WHERE `entry`=33668; +UPDATE `creature_template` SET `faction`=21 WHERE `entry`=38388; +UPDATE `creature_template` SET `faction`=2120 WHERE `entry`=20583; +UPDATE `creature_template` SET `faction`=2189 WHERE `entry`=35353; +UPDATE `creature_template` SET `faction`=2189 WHERE `entry`=35354; +UPDATE `creature_template` SET `faction`=2189 WHERE `entry`=35355; +UPDATE `creature_template` SET `faction`=2189 WHERE `entry`=35356; +UPDATE `creature_template` SET `faction`=2189 WHERE `entry`=35357; +UPDATE `creature_template` SET `faction`=2189 WHERE `entry`=35358; +UPDATE `creature_template` SET `faction`=233 WHERE `entry`=29635; +UPDATE `creature_template` SET `faction`=26 WHERE `entry`=22694; +UPDATE `creature_template` SET `faction`=26 WHERE `entry`=22781; +UPDATE `creature_template` SET `faction`=26 WHERE `entry`=32110; +UPDATE `creature_template` SET `faction`=26 WHERE `entry`=32142; +UPDATE `creature_template` SET `faction`=26 WHERE `entry`=37431; +UPDATE `creature_template` SET `faction`=26 WHERE `entry`=37472; +UPDATE `creature_template` SET `faction`=35 WHERE `entry`=22599; +UPDATE `creature_template` SET `faction`=35 WHERE `entry`=35417; +UPDATE `creature_template` SET `faction`=35 WHERE `entry`=35419; +UPDATE `creature_template` SET `faction`=35 WHERE `entry`=35421; +UPDATE `creature_template` SET `faction`=35 WHERE `entry`=35436; +UPDATE `creature_template` SET `faction`=35 WHERE `entry`=36357; +UPDATE `creature_template` SET `faction`=35 WHERE `entry`=36358; +UPDATE `creature_template` SET `faction`=37 WHERE `entry`=22625; +UPDATE `creature_template` SET `faction`=37 WHERE `entry`=22631; +UPDATE `creature_template` SET `faction`=37 WHERE `entry`=22637; +UPDATE `creature_template` SET `faction`=37 WHERE `entry`=22643; +UPDATE `creature_template` SET `faction`=37 WHERE `entry`=22725; +UPDATE `creature_template` SET `faction`=37 WHERE `entry`=22788; +UPDATE `creature_template` SET `faction`=37 WHERE `entry`=22789; +UPDATE `creature_template` SET `faction`=37 WHERE `entry`=22790; +UPDATE `creature_template` SET `faction`=37 WHERE `entry`=22791; +UPDATE `creature_template` SET `faction`=37 WHERE `entry`=22792; +UPDATE `creature_template` SET `faction`=37 WHERE `entry`=22793; +UPDATE `creature_template` SET `faction`=37 WHERE `entry`=22794; +UPDATE `creature_template` SET `faction`=37 WHERE `entry`=22795; +UPDATE `creature_template` SET `faction`=37 WHERE `entry`=22796; +UPDATE `creature_template` SET `faction`=37 WHERE `entry`=22797; +UPDATE `creature_template` SET `faction`=37 WHERE `entry`=31998; +UPDATE `creature_template` SET `faction`=37 WHERE `entry`=32027; +UPDATE `creature_template` SET `faction`=37 WHERE `entry`=32054; +UPDATE `creature_template` SET `faction`=37 WHERE `entry`=32120; +UPDATE `creature_template` SET `faction`=37 WHERE `entry`=37317; +UPDATE `creature_template` SET `faction`=37 WHERE `entry`=37347; +UPDATE `creature_template` SET `faction`=37 WHERE `entry`=37375; +UPDATE `creature_template` SET `faction`=37 WHERE `entry`=37443; +UPDATE `creature_template` SET `faction`=370 WHERE `entry`=20571; +UPDATE `creature_template` SET `faction`=370 WHERE `entry`=21620; +UPDATE `creature_template` SET `faction`=39 WHERE `entry`=22555; +UPDATE `creature_template` SET `faction`=39 WHERE `entry`=22785; +UPDATE `creature_template` SET `faction`=39 WHERE `entry`=32000; +UPDATE `creature_template` SET `faction`=39 WHERE `entry`=32146; +UPDATE `creature_template` SET `faction`=39 WHERE `entry`=37319; +UPDATE `creature_template` SET `faction`=39 WHERE `entry`=37476; +UPDATE `creature_template` SET `faction`=40 WHERE `entry`=18432; +UPDATE `creature_template` SET `faction`=41 WHERE `entry`=20540; +UPDATE `creature_template` SET `faction`=51 WHERE `entry`=20176; +UPDATE `creature_template` SET `faction`=51 WHERE `entry`=20178; +UPDATE `creature_template` SET `faction`=58 WHERE `entry`=20687; +UPDATE `creature_template` SET `faction`=58 WHERE `entry`=22322; +UPDATE `creature_template` SET `faction`=614 WHERE `entry`=32795; +UPDATE `creature_template` SET `faction`=7 WHERE `entry`=20171; +UPDATE `creature_template` SET `faction`=778 WHERE `entry`=30814; +UPDATE `creature_template` SET `faction`=80 WHERE `entry`=36086; +UPDATE `creature_template` SET `faction`=84 WHERE `entry`=22601; +UPDATE `creature_template` SET `faction`=90 WHERE `entry`=25566; +UPDATE `creature_template` SET `faction`=90 WHERE `entry`=30763; +UPDATE `creature_template` SET `faction`=90 WHERE `entry`=30773; +UPDATE `creature_template` SET `faction`=90 WHERE `entry`=30793; +UPDATE `creature_template` SET `faction`=90 WHERE `entry`=36301; +UPDATE `creature_template` SET `faction`=90 WHERE `entry`=36302; +UPDATE `creature_template` SET `faction`=90 WHERE `entry`=36303; +UPDATE `creature_template` SET `faction`=91 WHERE `entry`=20689; +UPDATE `creature_template` SET `faction`=91 WHERE `entry`=20702; +UPDATE `creature_template` SET `faction`=91 WHERE `entry`=20703; +UPDATE `creature_template` SET `faction`=91 WHERE `entry`=20704; +UPDATE `creature_template` SET `faction`=91 WHERE `entry`=20705; +UPDATE `creature_template` SET `faction`=974 WHERE `entry`=30756; +UPDATE `creature_template` SET `faction`=99 WHERE `entry`=20549; |