diff options
| author | Rushor <PBienati@web.de> | 2015-10-23 20:49:47 +0200 |
|---|---|---|
| committer | Rushor <PBienati@web.de> | 2015-10-23 20:49:47 +0200 |
| commit | eae956c88da0f49e0c1d777f8785670b6bd52aeb (patch) | |
| tree | 0f53ae3a9f8089ec38c0ee91919f98826f5f1944 | |
| parent | 1c519a74e2f620ac8a35a1b49c1a8010d9f76fca (diff) | |
DB/Creature: Cenarion Circle Reputation
closes #15759
| -rw-r--r-- | sql/updates/world/2015_10_23_01_world.sql | 32 |
1 files changed, 32 insertions, 0 deletions
diff --git a/sql/updates/world/2015_10_23_01_world.sql b/sql/updates/world/2015_10_23_01_world.sql new file mode 100644 index 00000000000..01d4dd4206d --- /dev/null +++ b/sql/updates/world/2015_10_23_01_world.sql @@ -0,0 +1,32 @@ +-- Cenarion Circle Reputation +DELETE FROM `creature_onkill_reputation` WHERE `creature_id` IN (15335, 15727); +INSERT INTO `creature_onkill_reputation` (`creature_id`, `RewOnKillRepFaction1`, `RewOnKillRepFaction2`, `MaxStanding1`, `IsTeamAward1`, `RewOnKillRepValue1`, `MaxStanding2`, `IsTeamAward2`, `RewOnKillRepValue2`, `TeamDependent`) VALUES +(15335, 609, 0, 7, 0, 6, 0, 0, 0, 0), +(15727, 609, 0, 7, 0, 1100, 0, 0, 0, 0); + +DELETE FROM `creature_onkill_reputation` WHERE `creature_id` IN (15355, 15538, 15537, 15389, 15391, 15392, 15385, 15338, 15335, 15390, 15319, 15318, 15323, 15320, 15327, 15325, 15386, 15388, 15317, 15316, 15324, 15336); +INSERT INTO `creature_onkill_reputation` (`creature_id`, `RewOnKillRepFaction1`, `RewOnKillRepFaction2`, `MaxStanding1`, `IsTeamAward1`, `RewOnKillRepValue1`, `MaxStanding2`, `IsTeamAward2`, `RewOnKillRepValue2`, `TeamDependent`) VALUES +(15335, 609, 0, 7, 0, 10, 0, 0, 0, 0), +(15317, 609, 0, 7, 0, 10, 0, 0, 0, 0), +(15316, 609, 0, 7, 0, 10, 0, 0, 0, 0), +(15324, 609, 0, 7, 0, 10, 0, 0, 0, 0), +(15338, 609, 0, 7, 0, 10, 0, 0, 0, 0), +(15386, 609, 0, 7, 0, 10, 0, 0, 0, 0), +(15325, 609, 0, 7, 0, 10, 0, 0, 0, 0), +(15336, 609, 0, 7, 0, 10, 0, 0, 0, 0), +(15327, 609, 0, 7, 0, 10, 0, 0, 0, 0), +(15320, 609, 0, 7, 0, 10, 0, 0, 0, 0), +(15323, 609, 0, 7, 0, 10, 0, 0, 0, 0), +(15318, 609, 0, 7, 0, 10, 0, 0, 0, 0), +(15319, 609, 0, 7, 0, 10, 0, 0, 0, 0), +(15385, 609, 0, 7, 0, 10, 0, 0, 0, 0), +(15390, 609, 0, 7, 0, 10, 0, 0, 0, 0), +(15392, 609, 0, 7, 0, 10, 0, 0, 0, 0), +(15391, 609, 0, 7, 0, 10, 0, 0, 0, 0), +(15389, 609, 0, 7, 0, 10, 0, 0, 0, 0), +(15537, 609, 0, 7, 0, 10, 0, 0, 0, 0), +(15538, 609, 0, 7, 0, 10, 0, 0, 0, 0), +(15355, 609, 0, 7, 0, 10, 0, 0, 0, 0); + +UPDATE `creature_onkill_reputation` SET `RewOnKillRepValue1`=11 WHERE `creature_id` IN (15333, 15461, 15387, 15343); +UPDATE `creature_onkill_reputation` SET `RewOnKillRepFaction2`=609, `MaxStanding2`=7, `RewOnKillRepValue2`=73 WHERE `creature_id` IN (15276, 15275); |