From c7221536ded8b43baacad2d320f5b9cc979f52f9 Mon Sep 17 00:00:00 2001 From: Aokromes Date: Sun, 27 Apr 2014 21:11:14 +0200 Subject: DB/Creature Fix even more hard modes values I have this is annoying thing? --- .../2014_04_27_09_world_creature_template.sql | 23 ++++++++++++++++++++++ 1 file changed, 23 insertions(+) create mode 100644 sql/updates/world/2014_04_27_09_world_creature_template.sql (limited to 'sql') diff --git a/sql/updates/world/2014_04_27_09_world_creature_template.sql b/sql/updates/world/2014_04_27_09_world_creature_template.sql new file mode 100644 index 00000000000..05da0b277c7 --- /dev/null +++ b/sql/updates/world/2014_04_27_09_world_creature_template.sql @@ -0,0 +1,23 @@ +-- +UPDATE `creature_template` SET `difficulty_entry_3`=37262 WHERE `entry`=13427; +UPDATE `creature_template` SET `difficulty_entry_3`=37258 WHERE `entry`=13426; +UPDATE `creature_template` SET `faction_A`=1215, `faction_H`=1215, `npcflag`=1048577 WHERE `entry`=31979; +UPDATE `creature_template` SET `faction_A`=21, `faction_H`=21 WHERE `entry`=29853; +UPDATE `creature_template` SET `faction_A`=114, `faction_H`=114 WHERE `entry`=34110; +UPDATE `creature_template` SET `faction_A`=1335, `faction_H`=1335, `npcflag`=4226 WHERE `entry`=32022; +UPDATE `creature_template` SET `faction_A`=1732, `faction_H`=1732, `npcflag`=16777216 WHERE `entry`=35410; +UPDATE `creature_template` SET `faction_A`=1534, `faction_H`=1534 WHERE `entry`=32006; +UPDATE `creature_template` SET `faction_A`=1534, `faction_H`=1534 WHERE `entry`=37325; +UPDATE `creature_template` SET `faction_A`=84, `faction_H`=84 WHERE `entry`=31919; +UPDATE `creature_template` SET `faction_A`=84, `faction_H`=84 WHERE `entry`=37235; +UPDATE `creature_template` SET `faction_A`=58, `faction_H`=58 WHERE `entry`=31917; +UPDATE `creature_template` SET `faction_A`=58, `faction_H`=58 WHERE `entry`=37233; +UPDATE `creature_template` SET `faction_A`=1217, `faction_H`=1217 WHERE `entry`=31934; +UPDATE `creature_template` SET `faction_A`=1217, `faction_H`=1217 WHERE `entry`=37252; +UPDATE `creature_template` SET `faction_A`=85, `faction_H`=85 WHERE `entry`=31962; +UPDATE `creature_template` SET `faction_A`=85, `faction_H`=85 WHERE `entry`=31943; +UPDATE `creature_template` SET `faction_A`=85, `faction_H`=85, `unit_class`=2 WHERE `entry`=37363; +UPDATE `creature_template` SET `faction_A`=1872, `faction_H`=1872, `npcflag`=4225 WHERE `entry`=30799; +UPDATE `creature_template` SET `faction_A`=1872, `faction_H`=1872, `npcflag`=129 WHERE `entry`=30797; +UPDATE `creature_template` SET `faction_A`=1872, `faction_H`=1872, `npcflag`=129 WHERE `entry`=30801; +UPDATE `creature_template` SET `faction_A`=1216, `faction_H`=1216, `npcflag`=3, `exp`=1 WHERE `entry`=31954; -- cgit v1.2.3