diff options
| author | joschiwald <joschiwald@online.de> | 2014-01-07 00:06:30 +0100 |
|---|---|---|
| committer | joschiwald <joschiwald@online.de> | 2014-01-07 00:06:30 +0100 |
| commit | 2b9234b32aa203cbb9a85dc50c78bbab7b4a81ef (patch) | |
| tree | 99c01a9c402c77b8d73de15045023ed0f6f176fd | |
| parent | a60ba240b7bbaec7b8a1b7791948e3f19a9692be (diff) | |
DB: update some creature templates
| -rw-r--r-- | sql/updates/world/2014_01_07_00_world_creature_template.sql | 19 |
1 files changed, 19 insertions, 0 deletions
diff --git a/sql/updates/world/2014_01_07_00_world_creature_template.sql b/sql/updates/world/2014_01_07_00_world_creature_template.sql new file mode 100644 index 00000000000..2b4bce350d9 --- /dev/null +++ b/sql/updates/world/2014_01_07_00_world_creature_template.sql @@ -0,0 +1,19 @@ +UPDATE `creature_template` SET `dmg_multiplier`=7.5 WHERE `entry` IN (32386,32358,32377,32398,32409,32400,32417,32429,32438,32422,32357,32471,32481,32475,32447,32495,32501); + +UPDATE `creature_template` SET `dmg_multiplier`=13 WHERE `entry` IN (31673,31674); + +UPDATE `creature_template` SET `exp`=2 WHERE `entry` IN (35543,35521,35539,35306,35541,35530,40420,31539,34918,35407,40424,40418,35529,35524,35537,35520,31540,35533,35401,35310,35308,35522,35538,35527,35534,35528,35542,35536,35535,35525,35519,35531,40422); + +UPDATE `creature_template` SET `faction_A`=1921, `faction_H`=1921 WHERE `entry`=25335; +UPDATE `creature_template` SET `faction_A`=1978, `faction_H`=1978 WHERE `entry`=25338; +UPDATE `creature_template` SET `faction_A`=1982, `faction_H`=1982 WHERE `entry`=25451; +UPDATE `creature_template` SET `faction_A`=634, `faction_H`=634 WHERE `entry`=26093; +UPDATE `creature_template` SET `faction_A`=29, `faction_H`=29 WHERE `entry` IN (26537,26539); +UPDATE `creature_template` SET `faction_A`=35, `faction_H`=35 WHERE `entry`=27135; +UPDATE `creature_template` SET `faction_A`=974, `faction_H`=974 WHERE `entry`=27860; +UPDATE `creature_template` SET `faction_A`=11, `faction_H`=11 WHERE `entry` IN (29292,29293,29294,29295); +UPDATE `creature_template` SET `faction_A`=21, `faction_H`=21 WHERE `entry`=32263; +UPDATE `creature_template` SET `faction_A`=16, `faction_H`=16 WHERE `entry`=32487; +UPDATE `creature_template` SET `faction_A`=14, `faction_H`=14 WHERE `entry`=33785; +UPDATE `creature_template` SET `faction_A`=68, `faction_H`=68 WHERE `entry`=33996; +UPDATE `creature_template` SET `faction_A`=1771, `faction_H`=1771 WHERE `entry` IN (37069,37549,36940,37550,36941,37551); |