From 699ca8dd6537e69e9fb15035f035e5cad39b805c Mon Sep 17 00:00:00 2001
From: Killyana <morphone1@gmail.com>
Date: Sun, 17 Jan 2016 03:47:39 +0100
Subject: DB/Creature: Terrorclaw Reputation on kill reputation

By @Saben65
Closes #16212

(cherry picked from commit 696a66155b5c03daa6478f651bed949f5eca8b60)
---
 sql/updates/world/2016_01_16_04_world.sql                     | 3 +++
 sql/updates/world/2016_01_17_01_world.sql                     | 9 ---------
 sql/updates/world/2016_03_22_13_world_2016_01_16_04_world.sql | 3 ---
 sql/updates/world/2016_03_22_13_world_2016_01_17_01_world.sql | 9 +++++++++
 sql/updates/world/2016_03_22_14_world_2016_01_17_02_world.sql | 4 ++++
 5 files changed, 16 insertions(+), 12 deletions(-)
 create mode 100644 sql/updates/world/2016_01_16_04_world.sql
 delete mode 100644 sql/updates/world/2016_01_17_01_world.sql
 delete mode 100644 sql/updates/world/2016_03_22_13_world_2016_01_16_04_world.sql
 create mode 100644 sql/updates/world/2016_03_22_13_world_2016_01_17_01_world.sql
 create mode 100644 sql/updates/world/2016_03_22_14_world_2016_01_17_02_world.sql

(limited to 'sql')

diff --git a/sql/updates/world/2016_01_16_04_world.sql b/sql/updates/world/2016_01_16_04_world.sql
new file mode 100644
index 00000000000..a6bb7ae185c
--- /dev/null
+++ b/sql/updates/world/2016_01_16_04_world.sql
@@ -0,0 +1,3 @@
+DELETE FROM `spell_script_names` WHERE `spell_id`=53651;
+INSERT INTO `spell_script_names` (`spell_id`, `ScriptName`) VALUES
+(53651, 'spell_pal_light_s_beacon');
diff --git a/sql/updates/world/2016_01_17_01_world.sql b/sql/updates/world/2016_01_17_01_world.sql
deleted file mode 100644
index 8e5bcd22a07..00000000000
--- a/sql/updates/world/2016_01_17_01_world.sql
+++ /dev/null
@@ -1,9 +0,0 @@
---
-DELETE FROM `creature_template_addon` WHERE `entry` IN (21694,21914,17796,17797,20629,20630);
-INSERT INTO `creature_template_addon` (`entry`, `mount`, `bytes1`, `bytes2`, `auras`) VALUES
-(21694,0,0x0,0x1,'18950'), -- 21694 - 18950
-(21914,0,0x0,0x1,'18950'), -- 21914 - 18950
-(17796,0,0x0,0x1,'18950'), -- 17796 - 18950 
-(17797,0,0x0,0x1,'18950'), -- 17797 - 18950 
-(20629,0,0x0,0x1,'18950'), -- 20629 - 18950
-(20630,0,0x0,0x1,'18950'); -- 20630 - 18950
diff --git a/sql/updates/world/2016_03_22_13_world_2016_01_16_04_world.sql b/sql/updates/world/2016_03_22_13_world_2016_01_16_04_world.sql
deleted file mode 100644
index a6bb7ae185c..00000000000
--- a/sql/updates/world/2016_03_22_13_world_2016_01_16_04_world.sql
+++ /dev/null
@@ -1,3 +0,0 @@
-DELETE FROM `spell_script_names` WHERE `spell_id`=53651;
-INSERT INTO `spell_script_names` (`spell_id`, `ScriptName`) VALUES
-(53651, 'spell_pal_light_s_beacon');
diff --git a/sql/updates/world/2016_03_22_13_world_2016_01_17_01_world.sql b/sql/updates/world/2016_03_22_13_world_2016_01_17_01_world.sql
new file mode 100644
index 00000000000..8e5bcd22a07
--- /dev/null
+++ b/sql/updates/world/2016_03_22_13_world_2016_01_17_01_world.sql
@@ -0,0 +1,9 @@
+--
+DELETE FROM `creature_template_addon` WHERE `entry` IN (21694,21914,17796,17797,20629,20630);
+INSERT INTO `creature_template_addon` (`entry`, `mount`, `bytes1`, `bytes2`, `auras`) VALUES
+(21694,0,0x0,0x1,'18950'), -- 21694 - 18950
+(21914,0,0x0,0x1,'18950'), -- 21914 - 18950
+(17796,0,0x0,0x1,'18950'), -- 17796 - 18950 
+(17797,0,0x0,0x1,'18950'), -- 17797 - 18950 
+(20629,0,0x0,0x1,'18950'), -- 20629 - 18950
+(20630,0,0x0,0x1,'18950'); -- 20630 - 18950
diff --git a/sql/updates/world/2016_03_22_14_world_2016_01_17_02_world.sql b/sql/updates/world/2016_03_22_14_world_2016_01_17_02_world.sql
new file mode 100644
index 00000000000..f019b927228
--- /dev/null
+++ b/sql/updates/world/2016_03_22_14_world_2016_01_17_02_world.sql
@@ -0,0 +1,4 @@
+--
+DELETE FROM `creature_onkill_reputation` WHERE `creature_id`=20477;
+INSERT INTO `creature_onkill_reputation` (`creature_id`, `RewOnKillRepFaction1`, `RewOnKillRepFaction2`, `MaxStanding1`, `IsTeamAward1`, `RewOnKillRepValue1`, `MaxStanding2`, `IsTeamAward2`, `RewOnKillRepValue2`, `TeamDependent`) VALUES 
+(20477, 942, 0, 5, 0, 7, 0, 0, 0, 0);
-- 
cgit v1.2.3