diff options
| -rw-r--r-- | sql/updates/world/2014_08_29_07_world_creature_template.sql | 82 |
1 files changed, 82 insertions, 0 deletions
diff --git a/sql/updates/world/2014_08_29_07_world_creature_template.sql b/sql/updates/world/2014_08_29_07_world_creature_template.sql new file mode 100644 index 00000000000..04e4e339d87 --- /dev/null +++ b/sql/updates/world/2014_08_29_07_world_creature_template.sql @@ -0,0 +1,82 @@ +UPDATE `creature_template` SET `faction` = 14 WHERE `entry` = 2070; -- should have been 2153 +UPDATE `creature_template` SET `faction` = 14 WHERE `entry` = 2071; -- should have been 2153 +UPDATE `creature_template` SET `faction` = 14 WHERE `entry` = 2237; -- should have been 2153 +UPDATE `creature_template` SET `faction` = 44 WHERE `entry` = 2165; -- should have been 2154 +UPDATE `creature_template` SET `faction` = 35 WHERE `entry` = 35085; -- should have been 2159 +UPDATE `creature_template` SET `faction` = 35 WHERE `entry` = 35086; -- should have been 2159 +UPDATE `creature_template` SET `faction` = 35 WHERE `entry` = 35088; -- should have been 2159 +UPDATE `creature_template` SET `faction` = 35 WHERE `entry` = 35091; -- should have been 2159 +UPDATE `creature_template` SET `faction` = 69 WHERE `entry` = 3442; -- should have been 2160 +UPDATE `creature_template` SET `faction` = 35 WHERE `entry` = 23211; -- should have been 2161 +UPDATE `creature_template` SET `faction` = 1194 WHERE `entry` = 16134; -- should have been 2167 +UPDATE `creature_template` SET `faction` = 132 WHERE `entry` = 4646; -- should have been 2183 +UPDATE `creature_template` SET `faction` = 132 WHERE `entry` = 4647; -- should have been 2183 +UPDATE `creature_template` SET `faction` = 132 WHERE `entry` = 4648; -- should have been 2183 +UPDATE `creature_template` SET `faction` = 132 WHERE `entry` = 4649; -- should have been 2183 +UPDATE `creature_template` SET `faction` = 132 WHERE `entry` = 4651; -- should have been 2183 +UPDATE `creature_template` SET `faction` = 132 WHERE `entry` = 4652; -- should have been 2183 +UPDATE `creature_template` SET `faction` = 132 WHERE `entry` = 4653; -- should have been 2183 +UPDATE `creature_template` SET `faction` = 132 WHERE `entry` = 4661; -- should have been 2183 +UPDATE `creature_template` SET `faction` = 133 WHERE `entry` = 4638; -- should have been 2184 +UPDATE `creature_template` SET `faction` = 133 WHERE `entry` = 4639; -- should have been 2184 +UPDATE `creature_template` SET `faction` = 133 WHERE `entry` = 4640; -- should have been 2184 +UPDATE `creature_template` SET `faction` = 133 WHERE `entry` = 4641; -- should have been 2184 +UPDATE `creature_template` SET `faction` = 133 WHERE `entry` = 4642; -- should have been 2184 +UPDATE `creature_template` SET `faction` = 133 WHERE `entry` = 4643; -- should have been 2184 +UPDATE `creature_template` SET `faction` = 133 WHERE `entry` = 4644; -- should have been 2184 +UPDATE `creature_template` SET `faction` = 133 WHERE `entry` = 4645; -- should have been 2184 +UPDATE `creature_template` SET `faction` = 14 WHERE `entry` = 428; -- should have been 2200 +UPDATE `creature_template` SET `faction` = 35 WHERE `entry` = 32870; -- should have been 2201 +UPDATE `creature_template` SET `faction` = 74 WHERE `entry` = 6190; -- should have been 2205 +UPDATE `creature_template` SET `faction` = 74 WHERE `entry` = 6195; -- should have been 2205 +UPDATE `creature_template` SET `faction` = 22 WHERE `entry` = 2349; -- should have been 2213 +UPDATE `creature_template` SET `faction` = 475 WHERE `entry` = 9460; -- should have been 2240 +UPDATE `creature_template` SET `faction` = 994 WHERE `entry` = 15187; -- should have been 2252 +UPDATE `creature_template` SET `faction` = 994 WHERE `entry` = 15188; -- should have been 2252 +UPDATE `creature_template` SET `faction` = 35 WHERE `entry` = 3000; -- should have been 2263 +UPDATE `creature_template` SET `faction` = 35 WHERE `entry` = 9117; -- should have been 2263 +UPDATE `creature_template` SET `faction` = 474 WHERE `entry` = 10302; -- should have been 2263 +UPDATE `creature_template` SET `faction` = 474 WHERE `entry` = 10583; -- should have been 2263 +UPDATE `creature_template` SET `faction` = 35 WHERE `entry` = 10977; -- should have been 2263 +UPDATE `creature_template` SET `faction` = 35 WHERE `entry` = 12959; -- should have been 2263 +UPDATE `creature_template` SET `faction` = 35 WHERE `entry` = 9270; -- should have been 2263 +UPDATE `creature_template` SET `faction` = 35 WHERE `entry` = 9271; -- should have been 2263 +UPDATE `creature_template` SET `faction` = 35 WHERE `entry` = 9997; -- should have been 2263 +UPDATE `creature_template` SET `faction` = 16 WHERE `entry` = 11858; -- should have been 2266 +UPDATE `creature_template` SET `faction` = 16 WHERE `entry` = 11910; -- should have been 2266 +UPDATE `creature_template` SET `faction` = 16 WHERE `entry` = 11911; -- should have been 2266 +UPDATE `creature_template` SET `faction` = 16 WHERE `entry` = 11912; -- should have been 2266 +UPDATE `creature_template` SET `faction` = 16 WHERE `entry` = 11913; -- should have been 2266 +UPDATE `creature_template` SET `faction` = 62 WHERE `entry` = 1034; -- should have been 2273 +UPDATE `creature_template` SET `faction` = 62 WHERE `entry` = 1035; -- should have been 2273 +UPDATE `creature_template` SET `faction` = 62 WHERE `entry` = 1036; -- should have been 2273 +UPDATE `creature_template` SET `faction` = 62 WHERE `entry` = 1038; -- should have been 2273 +UPDATE `creature_template` SET `faction` = 62 WHERE `entry` = 1057; -- should have been 2273 +UPDATE `creature_template` SET `faction` = 35 WHERE `entry` = 7013; -- should have been 2313 +UPDATE `creature_template` SET `faction` = 48 WHERE `entry` = 1016; -- should have been 2358 +UPDATE `creature_template` SET `faction` = 48 WHERE `entry` = 1019; -- should have been 2358 +UPDATE `creature_template` SET `faction` = 48 WHERE `entry` = 6505; -- should have been 2358 +UPDATE `creature_template` SET `faction` = 48 WHERE `entry` = 6506; -- should have been 2358 +UPDATE `creature_template` SET `faction` = 16 WHERE `entry` = 7431; -- should have been 2358 +UPDATE `creature_template` SET `faction` = 16 WHERE `entry` = 7432; -- should have been 2358 +UPDATE `creature_template` SET `faction` = 814 WHERE `entry` = 11194; -- should have been 2363 +UPDATE `creature_template` SET `faction` = 1625 WHERE `entry` = 16378; -- should have been 2363 +UPDATE `creature_template` SET `faction` = 2073 WHERE `entry` = 28247; -- should have been 2363 +UPDATE `creature_template` SET `faction` = 1475 WHERE `entry` = 14622; -- should have been 2364 +UPDATE `creature_template` SET `faction` = 24 WHERE `entry` = 206; -- should have been 2375 +UPDATE `creature_template` SET `faction` = 24 WHERE `entry` = 920; -- should have been 2375 +UPDATE `creature_template` SET `faction` = 32 WHERE `entry` = 11466; -- should have been 2468 +UPDATE `creature_template` SET `faction` = 14 WHERE `entry` = 11486; -- should have been 2468 +UPDATE `creature_template` SET `faction` = 1354 WHERE `entry` = 14355; -- should have been 2468 +UPDATE `creature_template` SET `faction` = 32 WHERE `entry` = 14358; -- should have been 2468 +UPDATE `creature_template` SET `faction` = 7 WHERE `entry` = 14361; -- should have been 2468 +UPDATE `creature_template` SET `faction` = 71 WHERE `entry` = 14364; -- should have been 2468 +UPDATE `creature_template` SET `faction` = 32 WHERE `entry` = 14368; -- should have been 2468 +UPDATE `creature_template` SET `faction` = 32 WHERE `entry` = 14369; -- should have been 2468 +UPDATE `creature_template` SET `faction` = 32 WHERE `entry` = 14371; -- should have been 2468 +UPDATE `creature_template` SET `faction` = 32 WHERE `entry` = 14381; -- should have been 2468 +UPDATE `creature_template` SET `faction` = 32 WHERE `entry` = 14382; -- should have been 2468 +UPDATE `creature_template` SET `faction` = 32 WHERE `entry` = 14383; -- should have been 2468 +UPDATE `creature_template` SET `faction` = 35 WHERE `entry` = 15774; -- should have been 2468 +UPDATE `creature_template` SET `faction` = 1354 WHERE `entry` = 16032; -- should have been 2468 +UPDATE `creature_template` SET `faction` = 126 WHERE `entry` = 3188; -- should have been 2663 |