* Prepare SQL directories

--HG--
branch : trunk
rename : sql/updates/8770_world_areatrigger_scripts.sql => sql/updates/3.3.3a_old/8770_world_areatrigger_scripts.sql
rename : sql/updates/8770_world_script_waypoints.sql => sql/updates/3.3.3a_old/8770_world_script_waypoints.sql
rename : sql/updates/8770_world_scriptname.sql => sql/updates/3.3.3a_old/8770_world_scriptname.sql
rename : sql/updates/8790_world_locales_item_set_names.sql => sql/updates/3.3.3a_old/8790_world_locales_item_set_names.sql
rename : sql/updates/8816_world_spell_bonus_data.sql => sql/updates/3.3.3a_old/8816_world_spell_bonus_data.sql
rename : sql/updates/8821_world_spell_dbc.sql => sql/updates/3.3.3a_old/8821_world_spell_dbc.sql
rename : sql/updates/8836_world_spell_linked_spell.sql => sql/updates/3.3.3a_old/8836_world_spell_linked_spell.sql
rename : sql/updates/8842_world_script_texts.sql => sql/updates/3.3.3a_old/8842_world_script_texts.sql
rename : sql/updates/8842_world_scriptname.sql => sql/updates/3.3.3a_old/8842_world_scriptname.sql
rename : sql/updates/8843_world_scriptname.sql => sql/updates/3.3.3a_old/8843_world_scriptname.sql

10 files changed, 51 insertions, 0 deletions

diff --git a/sql/updates/3.3.3a_old/8770_world_areatrigger_scripts.sql b/sql/updates/3.3.3a_old/8770_world_areatrigger_scripts.sql
new file mode 100644
index 00000000000..044725b3a5f
--- /dev/null
+++ b/sql/updates/3.3.3a_old/8770_world_areatrigger_scripts.sql
@@ -0,0 +1,4 @@
+DELETE FROM `areatrigger_scripts` WHERE `entry` IN (5369,5423);
+INSERT INTO `areatrigger_scripts` (`entry`,`ScriptName`) VALUES
+(5369, 'at_RX_214_repair_o_matic_station'),
+(5423, 'at_RX_214_repair_o_matic_station');
diff --git a/sql/updates/3.3.3a_old/8770_world_script_waypoints.sql b/sql/updates/3.3.3a_old/8770_world_script_waypoints.sql
new file mode 100644
index 00000000000..c2418f6da33
--- /dev/null
+++ b/sql/updates/3.3.3a_old/8770_world_script_waypoints.sql
@@ -0,0 +1,9 @@
+-- Waypoints for Mimron Inferno
+DELETE FROM `script_waypoint` WHERE `entry`=33370;
+INSERT INTO `script_waypoint` (`entry`, `pointid`, `location_x`, `location_y`, `location_z`, `waittime`, `point_comment`) VALUES
+(33370, 1, 331.674, -68.6878, 409.804, 0, '0'),
+(33370, 2, 274.578, -92.1829, 409.804, 0, '0'),
+(33370, 3, 226.433, -66.6652, 409.793, 0, '0'),
+(33370, 4, 206.092, -34.7447, 409.801, 0, '0'),
+(33370, 5, 240.208, 1.10346, 409.802, 0, '0'),
+(33370, 6, 337.199, 11.7051, 409.802, 0, '0');
diff --git a/sql/updates/3.3.3a_old/8770_world_scriptname.sql b/sql/updates/3.3.3a_old/8770_world_scriptname.sql
new file mode 100644
index 00000000000..e173f7e41f2
--- /dev/null
+++ b/sql/updates/3.3.3a_old/8770_world_scriptname.sql
@@ -0,0 +1,12 @@
+UPDATE `creature_template` SET `ScriptName`= 'npc_thorims_hammer' WHERE `entry`=33365;
+UPDATE `creature_template` SET `ScriptName`= 'npc_mimirons_inferno' WHERE `entry`=33370;
+UPDATE `creature_template` SET `ScriptName`= 'npc_hodirs_fury' WHERE `entry`=33312;
+UPDATE `creature_template` SET `ScriptName`= 'npc_freyas_ward' WHERE `entry`=33367;
+UPDATE `creature_template` SET `ScriptName`= 'npc_lorekeeper' WHERE `entry`=33686;
+UPDATE `creature_template` SET `ScriptName`= 'npc_brann_bronzebeard' WHERE `entry`=33579;
+UPDATE `creature_template` SET `ScriptName`= 'npc_freya_ward_summon' WHERE `entry`=34275;
+UPDATE `creature_template` SET `ScriptName`= 'npc_mechanolift' WHERE `entry`=33214;
+UPDATE `gameobject_template` SET `ScriptName`= 'go_ulduar_tower' WHERE `entry`=194375;
+UPDATE `gameobject_template` SET `ScriptName`= 'go_ulduar_tower' WHERE `entry`=194371;
+UPDATE `gameobject_template` SET `ScriptName`= 'go_ulduar_tower' WHERE `entry`=194370;
+UPDATE `gameobject_template` SET `ScriptName`= 'go_ulduar_tower' WHERE `entry`=194377;
diff --git a/sql/updates/3.3.3a_old/8790_world_locales_item_set_names.sql b/sql/updates/3.3.3a_old/8790_world_locales_item_set_names.sql
new file mode 100644
index 00000000000..4f6015ac749
--- /dev/null
+++ b/sql/updates/3.3.3a_old/8790_world_locales_item_set_names.sql
@@ -0,0 +1,2 @@
+DROP TABLE IF EXISTS `locales_item_set_names`;
+RENAME TABLE `locales_item_set_name` TO `locales_item_set_names`;
diff --git a/sql/updates/3.3.3a_old/8816_world_spell_bonus_data.sql b/sql/updates/3.3.3a_old/8816_world_spell_bonus_data.sql
new file mode 100644
index 00000000000..67d01d19b77
--- /dev/null
+++ b/sql/updates/3.3.3a_old/8816_world_spell_bonus_data.sql
@@ -0,0 +1,4 @@
+DELETE FROM `spell_bonus_data` WHERE `entry` IN (45284,45297);
+INSERT INTO `spell_bonus_data` (`entry`,`direct_bonus`,`dot_bonus`,`ap_bonus`,`ap_dot_bonus`,`comments`) VALUES
+(45284,0.357,-1,-1,-1,'Shaman - LO Lightning Bolt'),
+(45297,0.285,-1,-1,-1,'Shaman - LO Chain Lightning');
diff --git a/sql/updates/3.3.3a_old/8821_world_spell_dbc.sql b/sql/updates/3.3.3a_old/8821_world_spell_dbc.sql
new file mode 100644
index 00000000000..903a932edaf
--- /dev/null
+++ b/sql/updates/3.3.3a_old/8821_world_spell_dbc.sql
@@ -0,0 +1,8 @@
+-- Add serverside spells place holders for future development
+DELETE FROM `spell_dbc` WHERE `Id` IN (11202,25359,40145,45767,71098);
+INSERT INTO `spell_dbc` (`Id`,`Comment`) VALUES
+(11202, 'Item 3776 spellid_1 serverside spell'),
+(25359, 'Item 21293 spellid_2 serverside spell'),
+(40145, 'Quest 11000 RewSpellCast serverside spell'),
+(45767, 'Quest 11670 RewSpellCast serverside spell'),
+(71098, 'Quest 24451 RewSpellCast serverside spell');
diff --git a/sql/updates/3.3.3a_old/8836_world_spell_linked_spell.sql b/sql/updates/3.3.3a_old/8836_world_spell_linked_spell.sql
new file mode 100644
index 00000000000..64c3c66c9e1
--- /dev/null
+++ b/sql/updates/3.3.3a_old/8836_world_spell_linked_spell.sql
@@ -0,0 +1,3 @@
+-- Make the Ardent Defender heal (66235) trigger the visuals (66233)
+DELETE FROM `spell_linked_spell` WHERE `spell_trigger`=66235;
+INSERT INTO `spell_linked_spell` (`spell_trigger`,`spell_effect`,`type`,`comment`) VALUES (66235,66233,0, 'Ardent Defender Visuals');
diff --git a/sql/updates/3.3.3a_old/8842_world_script_texts.sql b/sql/updates/3.3.3a_old/8842_world_script_texts.sql
new file mode 100644
index 00000000000..617b61a694f
--- /dev/null
+++ b/sql/updates/3.3.3a_old/8842_world_script_texts.sql
@@ -0,0 +1,5 @@
+DELETE FROM script_texts where entry IN (-1000474, -1000475, -1000476);
+INSERT INTO script_texts (`npc_entry`, `entry`, `content_default`, `type`, `language`, `comment`) VALUE
+(17375, -1000474, '[Fulborg] The Stillpine furbolgs will not soon forget your bravery!', 0, 0, 'Stillpine Capitive free say text 1'),
+(17375, -1000475, '[Fulborg] Thank you, $N', 0, 0, 'Stillpine Capitive free say text 2'),
+(17375, -1000476, '[Fulborg] Those remaining at Stillpine Hold will welcome you as a hero!', 0, 0, 'Stillpine Capitive free say text 3');
diff --git a/sql/updates/3.3.3a_old/8842_world_scriptname.sql b/sql/updates/3.3.3a_old/8842_world_scriptname.sql
new file mode 100644
index 00000000000..5ef8e4b6aa9
--- /dev/null
+++ b/sql/updates/3.3.3a_old/8842_world_scriptname.sql
@@ -0,0 +1,2 @@
+UPDATE `creature_template` SET `ScriptName`='npc_stillpine_capitive' where `entry`=17375;
+UPDATE `gameobject_template` SET `ScriptName`='go_stillpine_cage' WHERE `entry`=181714;
diff --git a/sql/updates/3.3.3a_old/8843_world_scriptname.sql b/sql/updates/3.3.3a_old/8843_world_scriptname.sql
new file mode 100644
index 00000000000..4517544d99d
--- /dev/null
+++ b/sql/updates/3.3.3a_old/8843_world_scriptname.sql
@@ -0,0 +1,2 @@
+UPDATE `gameobject_template` SET `ScriptName`='go_bristlelimb_cage' WHERE `entry`=181714;
+