aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorAokromes <Aokromes@users.noreply.github.com>2014-04-27 21:11:14 +0200
committerAokromes <Aokromes@users.noreply.github.com>2014-04-27 21:11:14 +0200
commitc7221536ded8b43baacad2d320f5b9cc979f52f9 (patch)
treea4c66125a112eeab90e686fedb7ec57e765ed5e3
parent6caa8e309ad1a59df48dbb25a640ca4dfb548248 (diff)
DB/Creature Fix even more hard modes values
I have this is annoying thing?
-rw-r--r--sql/updates/world/2014_04_27_09_world_creature_template.sql23
1 files changed, 23 insertions, 0 deletions
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;