aboutsummaryrefslogtreecommitdiff
path: root/sql/updates
diff options
context:
space:
mode:
Diffstat (limited to 'sql/updates')
-rw-r--r--sql/updates/3999_sd2.sql2
-rw-r--r--sql/updates/4000_world_spell_proc_event.sql (renamed from sql/updates/3997_world_spell_proc_event.sql)0
-rw-r--r--sql/updates/4003_world_scritp_waypoint.sql28
-rw-r--r--sql/updates/4006_sd2.sql10
-rw-r--r--sql/updates/4016_world_spell_#dk.sql5
-rw-r--r--sql/updates/4023_world_spell_proc_event.sql4
-rw-r--r--sql/updates/4030_world.sql1
-rw-r--r--sql/updates/4031_world_spell_proc_event.sql5
-rw-r--r--sql/updates/4032_world_spell_proc_event.sql4
9 files changed, 58 insertions, 1 deletions
diff --git a/sql/updates/3999_sd2.sql b/sql/updates/3999_sd2.sql
index 7815b7aa857..aefda08bd2e 100644
--- a/sql/updates/3999_sd2.sql
+++ b/sql/updates/3999_sd2.sql
@@ -2,4 +2,4 @@ DELETE FROM script_texts WHERE entry BETWEEN -1000342 AND -1000340;
INSERT INTO script_texts (entry,content_default,sound,type,language,emote,comment) VALUES
(-1000340, 'We made it! Thanks, $N. I couldn''t have gotten without you.', 0, 0, 0, 0, 'npc_deathstalker_erland - SAY_THANKS'),
(-1000341, 'It''s good to see you again, Erland. What is your report?', 0, 0, 0, 0, 'npc_deathstalker_erland - SAY_RANE'),
-(-1000342, 'Masses of wolves are to the east, and whoever lived at Malden''s Orchard is gone.', 0, 0, 0, 0, 'npc_deathstalker_erland - SAY_ANSWER'),
+(-1000342, 'Masses of wolves are to the east, and whoever lived at Malden''s Orchard is gone.', 0, 0, 0, 0, 'npc_deathstalker_erland - SAY_ANSWER');
diff --git a/sql/updates/3997_world_spell_proc_event.sql b/sql/updates/4000_world_spell_proc_event.sql
index d426dc437cb..d426dc437cb 100644
--- a/sql/updates/3997_world_spell_proc_event.sql
+++ b/sql/updates/4000_world_spell_proc_event.sql
diff --git a/sql/updates/4003_world_scritp_waypoint.sql b/sql/updates/4003_world_scritp_waypoint.sql
new file mode 100644
index 00000000000..603115f72c0
--- /dev/null
+++ b/sql/updates/4003_world_scritp_waypoint.sql
@@ -0,0 +1,28 @@
+DELETE FROM script_waypoint WHERE entry=17969;
+INSERT INTO script_waypoint VALUES
+(17969, 0, -930.048950, 5288.080078, 23.848402, 0, ''),
+(17969, 1, -925.677917, 5296.482910, 18.183748, 0, ''),
+(17969, 2, -924.297180, 5299.016113, 17.710915, 0, ''),
+(17969, 3, -928.390076, 5317.022949, 18.208593, 0, ''),
+(17969, 4, -930.620972, 5329.915039, 18.773422, 0, 'SAY_AMBUSH1'),
+(17969, 5, -931.490295, 5357.654785, 18.027155, 0, 'SAY_PROGRESS'),
+(17969, 6, -934.777771, 5369.341797, 22.278048, 0, ''),
+(17969, 7, -934.521851, 5373.407227, 22.834690, 0, ''),
+(17969, 8, -937.008545, 5382.980469, 22.699078, 0, ''),
+(17969, 9, -941.948059, 5404.141602, 22.669743, 0, ''),
+(17969, 10, -931.244263, 5415.846680, 23.063961, 0, 'at crossroad'),
+(17969, 11, -901.497925, 5420.315430, 24.213270, 0, ''),
+(17969, 12, -860.311707, 5415.617676, 23.671139, 0, ''),
+(17969, 13, -777.988953, 5391.982422, 23.001669, 0, ''),
+(17969, 14, -750.362000, 5385.786621, 22.765791, 0, ''),
+(17969, 15, -731.339417, 5382.449707, 22.517065, 0, ''),
+(17969, 16, -681.235901, 5381.377930, 22.050159, 2500, 'end bridge SAY_AMBUSH2'),
+(17969, 17, -637.944458, 5384.338379, 22.205647, 0, 'SAY_END'),
+(17969, 18, -608.954407, 5408.715332, 21.630386, 0, ''),
+(17969, 19, -598.134277, 5413.608398, 21.412275, 0, ''),
+(17969, 20, -571.268982, 5420.771973, 21.184925, 0, ''),
+(17969, 21, -553.099915, 5424.616211, 21.193716, 0, ''),
+(17969, 22, -524.745483, 5443.945313, 20.977013, 0, ''),
+(17969, 23, -502.984985, 5446.283691, 22.149435, 0, ''),
+(17969, 24, -472.463959, 5449.546875, 22.561453, 0, ''),
+(17969, 25, -454.533264, 5461.302246, 22.602837, 30000, 'quest complete');
diff --git a/sql/updates/4006_sd2.sql b/sql/updates/4006_sd2.sql
new file mode 100644
index 00000000000..8ac01de7acf
--- /dev/null
+++ b/sql/updates/4006_sd2.sql
@@ -0,0 +1,10 @@
+UPDATE creature_template SET ScriptName='' WHERE entry=466;
+UPDATE script_texts SET content_default='UNUSED', language=0, comment='REUSE ME' WHERE entry=-1000005;
+
+UPDATE creature_template SET ScriptName='npc_aged_dying_ancient_kodo' WHERE entry IN (4700, 4701, 4702, 11627);
+
+DELETE FROM script_texts WHERE entry BETWEEN -1000430 AND -1000428;
+INSERT INTO script_texts (entry,content_default,sound,type,language,emote,comment) VALUES
+(-1000428, 'Ah...the wondrous sound of kodos. I love the way they make the ground shake... inspect the beast for me.',0,0,0,0,'kodo round SAY_SMEED_HOME_1'),
+(-1000429, 'Hey, look out with that kodo! You had better inspect that beast before i give you credit!',0,0,0,0,'kodo round SAY_SMEED_HOME_2'),
+(-1000430, 'That kodo sure is a beauty. Wait a minute, where are my bifocals? Perhaps you should inspect the beast for me.',0,0,0,0,'kodo round SAY_SMEED_HOME_3');
diff --git a/sql/updates/4016_world_spell_#dk.sql b/sql/updates/4016_world_spell_#dk.sql
new file mode 100644
index 00000000000..c88b70b8277
--- /dev/null
+++ b/sql/updates/4016_world_spell_#dk.sql
@@ -0,0 +1,5 @@
+DELETE FROM `spell_script_target` WHERE entry IN
+(53110);
+INSERT INTO `spell_script_target` (`entry`, `type`, `targetEntry`) VALUES
+(53110,1,28940);
+
diff --git a/sql/updates/4023_world_spell_proc_event.sql b/sql/updates/4023_world_spell_proc_event.sql
new file mode 100644
index 00000000000..caa53b3c119
--- /dev/null
+++ b/sql/updates/4023_world_spell_proc_event.sql
@@ -0,0 +1,4 @@
+DELETE FROM `spell_proc_event` WHERE `entry` IN (51521, 51522);
+INSERT INTO `spell_proc_event` (`entry`, `SchoolMask`, `SpellFamilyName`, `SpellFamilyMask0`, `SpellFamilyMask1`, `SpellFamilyMask2`, `procFlags`, `procEx`, `ppmRate`, `CustomChance`, `Cooldown`) VALUES
+( 51521, 0x00, 11, 0x00000000, 0x01000000, 0x00000000, 0x00000000, 0x00000000, 0, 0, 0), -- Improved Stormspike
+( 51522, 0x00, 11, 0x00000000, 0x01000000, 0x00000000, 0x00000000, 0x00000000, 0, 0, 0); -- Improved Stormspike \ No newline at end of file
diff --git a/sql/updates/4030_world.sql b/sql/updates/4030_world.sql
new file mode 100644
index 00000000000..579bfa49d23
--- /dev/null
+++ b/sql/updates/4030_world.sql
@@ -0,0 +1 @@
+UPDATE creature_template SET ScriptName='npc_nestlewood_owlkin' WHERE entry=16518;
diff --git a/sql/updates/4031_world_spell_proc_event.sql b/sql/updates/4031_world_spell_proc_event.sql
new file mode 100644
index 00000000000..f887ea24b9e
--- /dev/null
+++ b/sql/updates/4031_world_spell_proc_event.sql
@@ -0,0 +1,5 @@
+DELETE FROM `spell_proc_event` WHERE `entry` IN (51698, 51700, 51701);
+INSERT INTO `spell_proc_event` (`entry`, `SchoolMask`, `SpellFamilyName`, `SpellFamilyMask0`, `SpellFamilyMask1`, `SpellFamilyMask2`, `procFlags`, `procEx`, `ppmRate`, `CustomChance`, `Cooldown`) VALUES
+( 51698, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0, 0, 1), -- Honor Among Thieves
+( 51700, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0, 0, 1), -- Honor Among Thieves
+( 51701, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0, 0, 1); -- Honor Among Thieves
diff --git a/sql/updates/4032_world_spell_proc_event.sql b/sql/updates/4032_world_spell_proc_event.sql
new file mode 100644
index 00000000000..25c0b56ccdb
--- /dev/null
+++ b/sql/updates/4032_world_spell_proc_event.sql
@@ -0,0 +1,4 @@
+DELETE FROM `spell_linked_spell` WHERE `spell_trigger` IN (51209, 50334);
+INSERT INTO `spell_linked_spell` (`spell_trigger`, `spell_effect`, `type`, `comment`) VALUES
+(51209, 55095, 1, 'Hungering cold - frost fever'),
+(50334, 58923, 2, 'Berserk - modify target number aura');