diff options
Diffstat (limited to 'sql/updates')
| -rw-r--r-- | sql/updates/3999_sd2.sql | 2 | ||||
| -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.sql | 28 | ||||
| -rw-r--r-- | sql/updates/4006_sd2.sql | 10 | ||||
| -rw-r--r-- | sql/updates/4016_world_spell_#dk.sql | 5 | ||||
| -rw-r--r-- | sql/updates/4023_world_spell_proc_event.sql | 4 | ||||
| -rw-r--r-- | sql/updates/4030_world.sql | 1 | ||||
| -rw-r--r-- | sql/updates/4031_world_spell_proc_event.sql | 5 | ||||
| -rw-r--r-- | sql/updates/4032_world_spell_proc_event.sql | 4 |
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'); |
