diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/base/world_database.sql | 25 | ||||
| -rw-r--r-- | sql/scripts/world_scripts_full.sql | 20 | ||||
| -rw-r--r-- | sql/updates/2011_01_08_2_world_scriptname.sql | 30 | ||||
| -rw-r--r-- | sql/updates/2011_01_08_3_world_trinity_strings.sql | 23 | ||||
| -rw-r--r-- | sql/updates/2011_1_08_4_world_spell_linked_spell.sql | 7 |
5 files changed, 103 insertions, 2 deletions
diff --git a/sql/base/world_database.sql b/sql/base/world_database.sql index e845959fc68..4c11db78192 100644 --- a/sql/base/world_database.sql +++ b/sql/base/world_database.sql @@ -18130,6 +18130,11 @@ INSERT INTO `spell_linked_spell` (`spell_trigger`,`spell_effect`,`type`,`comment ( 71480, 71483, 1, 'Blood-Queen: Bloodbolt Splash'), ( 71952, 70995, 1, 'Blood-Queen: Presence of the Darkfallen'), ( 71390, 71341, 0, 'Blood-Queen: Pact of the Darkfallen'), +--- Isle of Conquest +( 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'), -- Warsong Gulch ( 54861,-23335, 0, 'Drop Flag on Nitro Boost WSG'), ( 54861,-23333, 0, 'Drop Flag on Nitro Boost WSG'), @@ -27480,6 +27485,26 @@ INSERT INTO `trinity_string` (`entry`,`content_default`,`content_loc1`,`content_ (1133, '| Character | BanDate | UnbanDate | Banned By | Ban Reason |', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL), (1200, 'You try to view cinemitic %u but it doesn''t exist.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL), (1201, 'You try to view movie %u but it doesn''t exist.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL), +(1205, 'The battle will begin in two minutes.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL), +(1206, 'The battle will begin in 1 minute.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL), +(1208, 'The battle has begun!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),, +(1207, 'The battle will begin in 30 seconds!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL), +(1209, 'the alliance keep', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL), +(1210, 'the horde keep', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL), +(1211, '%s wins!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL), +(1212, 'The west gate of %s is destroyed!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL), +(1213, 'The east gate of %s is destroyed!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL), +(1214, 'The south gate of %s is destroyed!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL), +(1215, 'The north gate of %s is destroyed!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL), +(1216, '$n has assaulted the %s', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL), +(1217, '$n has defended the %s', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL), +(1218, '$n claims the %s! If left unchallenged, the %s will control it in 1 minute!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL), +(1219, 'The %s has taken the %s', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL), +(1220, 'Workshop', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL), +(1221, 'Docks', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL), +(1222, 'Refinery', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL), +(1223, 'Quarry', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL), +(1224, 'Hangar', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL), (1300, 'Alliance', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL), (1301, 'Horde', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL), (1302, '%s was destroyed by the %s!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL), diff --git a/sql/scripts/world_scripts_full.sql b/sql/scripts/world_scripts_full.sql index d1d1c7d2dae..10c751218ee 100644 --- a/sql/scripts/world_scripts_full.sql +++ b/sql/scripts/world_scripts_full.sql @@ -867,6 +867,9 @@ UPDATE `creature_template` SET `ScriptName`='boss_blood_queen_lana_thel' WHERE ` /* IRONFORGE */ UPDATE `creature_template` SET `ScriptName`='npc_royal_historian_archesonus' WHERE `entry`=8879; +/* ISLE OF CONQUEST */ +UPDATE `creature_template` SET `ScriptName`='npc_four_car_garage' WHERE `entry` IN (34802,34793,34775,35069,34776); + /* ISLE OF QUEL'DANAS */ UPDATE `creature_template` SET `ScriptName`='npc_converted_sentry' WHERE `entry`=24981; UPDATE `creature_template` SET `ScriptName`='npc_greengill_slave' WHERE `entry`=25084; @@ -1748,7 +1751,7 @@ UPDATE `outdoorpvp_template` SET `ScriptName`='outdoorpvp_si' WHERE `TypeId`=5; UPDATE `outdoorpvp_template` SET `ScriptName`='outdoorpvp_ep' WHERE `TypeId`=6; /* ACHIEVEMENTS */ -DELETE FROM `achievement_criteria_data` WHERE `criteria_id` IN (3693,6641,6642,6643,6644,3804,3805,3806,3807,3808,3809,3810,3811,3812,3813,1234,1239,5605,5606,12778,13036,13035,13037,12977,12967,12986,12982,12993,12780,13012,13011,13013) AND `type` IN (0,11); +DELETE FROM `achievement_criteria_data` WHERE `criteria_id` IN (3693,6641,6642,6643,6644,3804,3805,3806,3807,3808,3809,3810,3811,3812,3813,1234,1239,5605,5606,12778,13036,13035,13037,12977,12967,12986,12982,12993,12780,13012,13011,13013,12062,12063,12064,12065,12183,12068,12060,12061) AND `type` IN (0,11); INSERT INTO `achievement_criteria_data` (`criteria_id`,`type`,`value1`,`value2`,`ScriptName`) VALUES (3693,11,0,0, 'achievement_storm_glory'), (6641,11,0,0, 'achievement_school_of_hard_knocks'), @@ -1781,7 +1784,16 @@ INSERT INTO `achievement_criteria_data` (`criteria_id`,`type`,`value1`,`value2`, (12780,11,0,0, 'achievement_once_bitten_twice_shy_n'), (13012,11,0,0, 'achievement_once_bitten_twice_shy_n'), (13011,11,0,0, 'achievement_once_bitten_twice_shy_v'), -(13013,11,0,0, 'achievement_once_bitten_twice_shy_v'); +(13013,11,0,0, 'achievement_once_bitten_twice_shy_v'), +(12062,11,0,0, 'achievement_bg_control_all_nodes'), +(12063,11,0,0, 'achievement_bg_control_all_nodes'), +(12064,11,0,0, 'achievement_bg_control_all_nodes'), +(12065,11,0,0, 'achievement_bg_control_all_nodes'), +(12183,11,0,0, 'achievement_bg_ic_glaive_grave'), +(12068,11,0,0, 'achievement_bg_ic_mowed_down'), +(12060,11,0,0, 'achievement_bg_ic_resource_glut'), +(12061,11,0,0, 'achievement_bg_ic_resource_glut'); + /* SPELLS */ INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES @@ -1939,6 +1951,10 @@ INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES ( 71900, 'spell_blood_queen_bloodbolt'), ( 71901, 'spell_blood_queen_bloodbolt'), ( 71902, 'spell_blood_queen_bloodbolt'), +-- Isle of Conquest +( 66630, 'spell_gen_gunship_portal'), +( 66637, 'spell_gen_gunship_portal'), +( 66656, 'spell_gen_parachute_ic'), -- Trial of Crusader ( 66118, 'spell_gen_leeching_swarm'), ( 67630, 'spell_gen_leeching_swarm'), 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 |