diff options
| author | Aokromes <aokromes@gmail.com> | 2012-01-05 12:57:34 +0100 |
|---|---|---|
| committer | ZxBiohazardZx <zxbiohazardzx@gmail.com> | 2012-01-05 12:57:50 +0100 |
| commit | fc987e9a2f948c7a68e352fe9a3024730e3ed839 (patch) | |
| tree | 7a497429569c4bb4aabfb05582542424ba5cd743 | |
| parent | 1d3cbe06140b1d7ad7765fa6f3eb38b3e0d75e01 (diff) | |
DB/Reputation: add correct reputation gains for ashen verdict
closes #4353
| -rw-r--r-- | sql/updates/world/2012_01_05_11_world_creature_onkill_reputation.sql | 6 |
1 files changed, 6 insertions, 0 deletions
diff --git a/sql/updates/world/2012_01_05_11_world_creature_onkill_reputation.sql b/sql/updates/world/2012_01_05_11_world_creature_onkill_reputation.sql new file mode 100644 index 00000000000..047c0453608 --- /dev/null +++ b/sql/updates/world/2012_01_05_11_world_creature_onkill_reputation.sql @@ -0,0 +1,6 @@ +-- remade incorrect gain of ashen verdict reputation according to http://www.wowwiki.com/Ashen_Verdict +-- there were incorrect values for trash mobs ( before=25 for kill, must to be 15) +-- for Lich King it must to be 1500 and for Deathbound Wards and Deathspeaker High Priests 45 +UPDATE `creature_onkill_reputation` SET `RewOnKillRepValue1` = 1500 WHERE `creature_id` IN (36597,39166,39167,39168); +UPDATE `creature_onkill_reputation` SET `RewOnKillRepValue1` = 45 WHERE `creature_id` IN (36829,37007); +UPDATE `creature_onkill_reputation` SET `RewOnKillRepValue1` = 15 WHERE `creature_id` IN (36619,36724,36725,36791,36805,36807,36808,36811,36880,36957,36960,36968,36982,37011,37012,37022,37029,37030,37031,37032,37033,37034,37035,37117,37125,37127,37132,37133,37134,37146,37149,37228,37229,37232,37501,37502,37531,37532,37546,37571,37595,37662,37663,37664,37665,37666,37695,37782,37886,37890,37919,37934,37949,38125,38159,38184,38369,38472,38485,38508,38711,38712); |