aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorAokromes <Aokromes@users.noreply.github.com>2017-03-26 00:16:37 +0100
committerfunjoker <funjoker109@gmail.com>2020-04-24 17:18:50 +0200
commit4ee1d4b44b0ffa33ed9e9682b8aae54c50c08770 (patch)
treeca9347a3c3f5f5b6c78363b264dfec2c03fe1a25
parentbe0de1ce704c9e7ce3df9d56ba185b026e418b40 (diff)
DB/Creature: Fix Verifonix faction and reputation
By offl, Closes #19323 (cherry picked from commit 5b3819424706ae34a787ba3e8112ff181a744011)
-rw-r--r--sql/updates/world/master/2020_04_16_03_world_2017_03_26_01_world_335.sql6
1 files changed, 6 insertions, 0 deletions
diff --git a/sql/updates/world/master/2020_04_16_03_world_2017_03_26_01_world_335.sql b/sql/updates/world/master/2020_04_16_03_world_2017_03_26_01_world_335.sql
new file mode 100644
index 00000000000..106556ff7e2
--- /dev/null
+++ b/sql/updates/world/master/2020_04_16_03_world_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);