aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorAokromes <jipr@hotmail.com>2014-01-27 08:47:25 +0100
committerAokromes <jipr@hotmail.com>2014-01-27 08:47:25 +0100
commitc7310d2b1fa5fc0f6c654c88feb2d3b5863f0eb3 (patch)
tree103b7e0c63525b6ec9cb78884a9ab5a48758b970
parent22508d197fc708d560cd515fbe6ce521dece93e2 (diff)
DB/Creature: Fix some factions and levels
Updates #11501
-rw-r--r--sql/updates/world/2014_01_27_07_world_creature_template.sql3
1 files changed, 3 insertions, 0 deletions
diff --git a/sql/updates/world/2014_01_27_07_world_creature_template.sql b/sql/updates/world/2014_01_27_07_world_creature_template.sql
new file mode 100644
index 00000000000..6da1a479c5e
--- /dev/null
+++ b/sql/updates/world/2014_01_27_07_world_creature_template.sql
@@ -0,0 +1,3 @@
+--
+UPDATE `creature_template` SET `faction_A` = 83, `faction_H` = 83 WHERE `entry` = 38095; -- Sniffs confirm 37034 faction 83.
+UPDATE `creature_template` SET `minlevel`=80, `maxlevel`=80, `faction_A`=83, `faction_H`=83 WHERE `entry`=35407; -- Sniffs confirm 34918 faction 83, copy level from normal mode.