Core/Battleground: Implemented blizzlike script for Isle of Conquest, written by gyullo and me, based on Socolin's and Josh's patch -BIG THANKS TO THEM-

Anyway the map is not yet playable, there are issues not related with the script.

I also want to thanks to QAston, linencloth, Shauren and Machiavelli to be so patient with my questions.

3 files changed, 60 insertions, 0 deletions

diff --git a/sql/updates/2011_01_08_2_world_scriptname.sql b/sql/updates/2011_01_08_2_world_scriptname.sql
new file mode 100644
index 00000000000..8c35e0d3712
--- /dev/null
+++ b/sql/updates/2011_01_08_2_world_scriptname.sql
@@ -0,0 +1,30 @@
+DELETE FROM spell_script_names WHERE spell_id IN (66630,66637,66656);
+INSERT INTO spell_script_names (spell_id,ScriptName) VALUES 
+(66630,'spell_gen_gunship_portal'),
+(66637,'spell_gen_gunship_portal'),
+(66656,'spell_gen_parachute_ic');
+
+-- Achievement Mine
+DELETE FROM `achievement_criteria_data` WHERE criteria_id IN (12062,12063,12064,12065);
+INSERT INTO `achievement_criteria_data` (criteria_id,type,ScriptName) VALUES
+(12062,11,'achievement_bg_control_all_nodes'),
+(12063,11,'achievement_bg_control_all_nodes'),
+(12064,11,'achievement_bg_control_all_nodes'),
+(12065,11,'achievement_bg_control_all_nodes');
+
+-- Achievement Four Car Garage
+UPDATE `creature_template` SET `ScriptName`='npc_four_car_garage' WHERE `entry` IN (34802,34793,34775,35069,34776);
+
+-- Achievement Glaive Grave
+DELETE FROM `achievement_criteria_data` WHERE `criteria_id`=12183;
+INSERT INTO `achievement_criteria_data` (criteria_id,type,ScriptName) VALUES (12183,11,'achievement_bg_ic_glaive_grave');
+
+-- Achievement Mowed Down
+DELETE FROM `achievement_criteria_data` WHERE `criteria_id`=12068;
+INSERT INTO `achievement_criteria_data` (criteria_id,type,ScriptName) VALUES (12068,11,'achievement_bg_ic_mowed_down');
+
+-- Achievement Resource Glut
+DELETE FROM `achievement_criteria_data` WHERE criteria_id IN (12060,12061);
+INSERT INTO `achievement_criteria_data` (criteria_id,type,ScriptName) VALUES
+(12060,11,'achievement_bg_ic_resource_glut'),
+(12061,11,'achievement_bg_ic_resource_glut');
\ No newline at end of file
diff --git a/sql/updates/2011_01_08_3_world_trinity_strings.sql b/sql/updates/2011_01_08_3_world_trinity_strings.sql
new file mode 100644
index 00000000000..39c66ba9e41
--- /dev/null
+++ b/sql/updates/2011_01_08_3_world_trinity_strings.sql
@@ -0,0 +1,23 @@
+-- strings used by the BG
+DELETE FROM trinity_string WHERE entry > 1204 AND entry <1225;
+INSERT INTO trinity_string (`entry`,`content_default`) VALUES
+(1205,'The battle will begin in two minutes.'),
+(1206,'The battle will begin in 1 minute.'),
+(1208,'The battle has begun!'),
+(1207,'The battle will begin in 30 seconds!'),
+(1209,'the alliance keep'),
+(1210,'the horde keep'),
+(1211,'%s wins!'),
+(1212,'The west gate of %s is destroyed!'),
+(1213,'The east gate of %s is destroyed!'),
+(1214,'The south gate of %s is destroyed!'),
+(1215,'The north gate of %s is destroyed!'),
+(1216,'$n has assaulted the %s'),
+(1217,'$n has defended the %s'),
+(1218,'$n claims the %s! If left unchallenged, the %s will control it in 1 minute!'),
+(1219,'The %s has taken the %s'),
+(1220,'Workshop'),
+(1221,'Docks'),
+(1222,'Refinery'),
+(1223,'Quarry'),
+(1224,'Hangar');
\ No newline at end of file
diff --git a/sql/updates/2011_1_08_4_world_spell_linked_spell.sql b/sql/updates/2011_1_08_4_world_spell_linked_spell.sql
new file mode 100644
index 00000000000..958d533c14c
--- /dev/null
+++ b/sql/updates/2011_1_08_4_world_spell_linked_spell.sql
@@ -0,0 +1,7 @@
+-- Spells from teleporters
+DELETE FROM `spell_linked_spell` WHERE `spell_trigger` IN (66548, 66549, 66550, 66551);
+INSERT INTO `spell_linked_spell` (`spell_trigger`, `spell_effect`, `type`, `comment`) VALUES
+(66548, 66550, 0, 'Isle of Conquest (IN>OUT)'),
+(66549, 66551, 0, 'Isle of Conquest (OUT>IN)'),
+(66551, -66548, 2, 'Isle of Conquest Teleport (OUT>IN) Debuff limit'),
+(66550, -66549, 2, 'Isle of Conquest Teleport (IN>OUT) Debuff limit');
\ No newline at end of file