HG 698.

--HG--
branch : trunk

5 files changed, 26 insertions, 0 deletions

diff --git a/sql/updates/678_world_scripts.sql b/sql/updates/679_world_scripts.sql
index 15d43204734..15d43204734 100644
--- a/sql/updates/678_world_scripts.sql
+++ b/sql/updates/679_world_scripts.sql
diff --git a/sql/updates/683_world_scripts.sql b/sql/updates/683_world_scripts.sql
new file mode 100644
index 00000000000..6463adad08e
--- /dev/null
+++ b/sql/updates/683_world_scripts.sql
@@ -0,0 +1,2 @@
+update quest_template set specialflags=2 where entry=665;
+update creature_template set scriptname='npc_professor_phizzlethorpe' where entry=2768;
\ No newline at end of file
diff --git a/sql/updates/686_world_scripts.sql b/sql/updates/686_world_scripts.sql
new file mode 100644
index 00000000000..b09691841b8
--- /dev/null
+++ b/sql/updates/686_world_scripts.sql
@@ -0,0 +1,16 @@
+UPDATE `quest_template` SET `SpecialFlags` = 2 WHERE `entry` = 1144;
+UPDATE `creature_template` SET `Scriptname`='npc_willix' WHERE entry=4508;
+
+DELETE FROM script_texts WHERE entry BETWEEN -1047000 and -1047010;
+INSERT INTO script_texts (entry, content_default, sound, type, language, comment) VALUES
+(-1047000, 'Phew! Finally,out here. However, it will not become easy. Detain your eyes after annoyance.', 0, 0, 0, 'Willix'),
+(-1047001, 'There on top resides Charlga Razorflank. The damned old Crone.', 0, 0, 0, 'Willix'),
+(-1047002, 'Help! Get this Raging Agam\'ar from me!', 0, 0, 0, 'Willix'),
+(-1047003, 'In this ditch there are Blueleaf Tuber! As if the gold waited only to be dug out, I say it you!', 0, 0, 0, 'Willix'),
+(-1047004, 'Danger is behind every corner.', 0, 0, 0, 'Willix'),
+(-1047005, 'I do not understand how these disgusting animals can live at such a place.... puh as this stinks!', 0, 0, 0, 'Willix'),
+(-1047006, 'I think, I see a way how we come out of this damned thorn tangle.', 0, 0, 0, 'Willix'),
+(-1047007, 'I am glad that we are out again from this damned ditch. However, up here it is not much better!', 0, 0, 0, 'Willix'),
+(-1047008, 'Finally! I am glad that I come, finally out here.', 0, 0, 0, 'Willix'),
+(-1047009, 'I will rather rest a moment and come again to breath, before I return to Ratchet.', 0, 0, 0, 'Willix'),
+(-1047010, 'Many thanks for your help.', 0, 0, 0, 'Willix');
\ No newline at end of file
diff --git a/sql/updates/691_world_scripts.sql b/sql/updates/691_world_scripts.sql
new file mode 100644
index 00000000000..6c26e149e8c
--- /dev/null
+++ b/sql/updates/691_world_scripts.sql
@@ -0,0 +1 @@
+update creature_template set scriptname='npc_earthmender_wilda' where entry=21027;
\ No newline at end of file
diff --git a/sql/updates/692_world.sql b/sql/updates/692_world.sql
new file mode 100644
index 00000000000..634bf6a7f46
--- /dev/null
+++ b/sql/updates/692_world.sql
@@ -0,0 +1,7 @@
+DELETE FROM `spell_proc_event` WHERE `entry` IN ('14144','14148');
+INSERT INTO `spell_proc_event` (`entry`, `SchoolMask`, `SpellFamilyName`, `SpellFamilyMask`, `procFlags`, `procEx`, `ppmRate`, `CustomChance`, `Cooldown`) VALUES
+('14144','0','0','0','2','0','0','0','0'),
+('14148','0','0','0','2','0','0','0','0');
+DELETE FROM `spell_proc_event` WHERE entry = 38164;
+INSERT INTO `spell_proc_event` (`entry`,`SchoolMask`,`SpellFamilyName`,`SpellFamilyMask`,`procFlags`,`procEx`,`ppmRate`,`CustomChance`,`Cooldown`) VALUES
+ (38164,0,0,0,0,1,0,0,60);
\ No newline at end of file