diff options
| author | Aokromes <Aokromes@users.noreply.github.com> | 2017-03-26 00:16:37 +0100 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2017-03-26 00:16:37 +0100 |
| commit | 5b3819424706ae34a787ba3e8112ff181a744011 (patch) | |
| tree | 65c28d20ca8589889a577bff38ba07be5cd58a81 | |
| parent | e4492dd0bdda6e9f778993c24889c8aea10f79ab (diff) | |
DB/Creature: Fix Verifonix faction and reputation
By offl, Closes #19323
| -rw-r--r-- | sql/updates/world/3.3.5/2017_03_26_01_world_335.sql | 6 |
1 files changed, 6 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2017_03_26_01_world_335.sql b/sql/updates/world/3.3.5/2017_03_26_01_world_335.sql new file mode 100644 index 00000000000..106556ff7e2 --- /dev/null +++ b/sql/updates/world/3.3.5/2017_03_26_01_world_335.sql @@ -0,0 +1,6 @@ +-- Verifonix <The Surveyor> +UPDATE `creature_template` SET `faction`=47 WHERE `entry`=14492; + +DELETE FROM `creature_onkill_reputation` WHERE `creature_id`=14492; +INSERT INTO `creature_onkill_reputation` (`creature_id`,`RewOnKillRepFaction1`,`RewOnKillRepFaction2`,`MaxStanding1`,`IsTeamAward1`,`RewOnKillRepValue1`,`MaxStanding2`,`IsTeamAward2`,`RewOnKillRepValue2`,`TeamDependent`) VALUES +(14492, 21, 0, 5, 0, 5, 0, 0, 0, 0); |