From aff24e35988d172b2471db7e16a19b24eb891b9b Mon Sep 17 00:00:00 2001 From: XTZGZoReX Date: Sat, 7 Aug 2010 17:30:14 +0200 Subject: * Some cleanups in world_scripts_full.sql. * SQL updates for `battleground_template`.`Comment` (by Click), and `outdoorpvp_template` content. --HG-- branch : trunk --- sql/scripts/world_scripts_full.sql | 32 ++++++++++++++++++++++---------- 1 file changed, 22 insertions(+), 10 deletions(-) (limited to 'sql/scripts') diff --git a/sql/scripts/world_scripts_full.sql b/sql/scripts/world_scripts_full.sql index 2e3b3d39791..812249830fa 100644 --- a/sql/scripts/world_scripts_full.sql +++ b/sql/scripts/world_scripts_full.sql @@ -1,10 +1,12 @@ -- Up to TC2 6928 -- Cleanup first +UPDATE `battleground_template` SET `ScriptName`=''; UPDATE `instance_template` SET `Script`=''; UPDATE `item_template` SET `ScriptName`=''; UPDATE `creature_template` SET `ScriptName`=''; UPDATE `gameobject_template` SET `ScriptName`=''; +UPDATE `outdoorpvp_template` SET `ScriptName`=''; /* AREA TRIGGERS */ DELETE FROM `areatrigger_scripts` WHERE `entry` IN (5284,5285,5286,5287,4871,4872,4873,5108,5332,5338,5334,5340,5369,5423); @@ -1362,6 +1364,7 @@ UPDATE `creature_template` SET `ScriptName`='npc_isla_starmane' WHERE `entry`=18 UPDATE `creature_template` SET `ScriptName`='mob_unkor_the_ruthless' WHERE `entry`=18262; UPDATE `creature_template` SET `ScriptName`='npc_slim' WHERE `entry`=19679; UPDATE `creature_template` SET `ScriptName`='npc_akuno' WHERE `entry`=22377; +UPDATE `creature_template` SET `ScriptName`='npc_skywing' WHERE `entry`=22424; /* THOUSAND NEEDLES */ UPDATE `creature_template` SET `ScriptName`='npc_kanati' WHERE `entry`=10638; @@ -1635,15 +1638,24 @@ UPDATE `creature_template` SET `ScriptName`='mob_batrider' WHERE `entry`=14965; UPDATE `creature_template` SET `ScriptName`='mob_shade_of_jindo' WHERE `entry`=14986; UPDATE `creature_template` SET `ScriptName`='mob_ohgan' WHERE `entry`=14988; -/* EOF */ +DELETE FROM `areatrigger_scripts` WHERE `entry`=3066; +INSERT INTO `areatrigger_scripts` VALUES + (3066,'at_ravenholdt'); -UPDATE `creature_template` SET `ScriptName`='npc_skywing' WHERE `entry`=22424; +/* Moved from world_spell_full.sql to here. */ +UPDATE `creature_template` SET `AIName`='TurretAI',`ScriptName`='' WHERE `entry`=33139; +UPDATE `creature_template` SET `ScriptName`= 'boss_kologarn' WHERE `entry`=32930; +UPDATE `creature_template` SET `ScriptName`= 'boss_flame_leviathan_safety_container' WHERE `entry`=33218; -DELETE FROM areatrigger_scripts WHERE `entry`=3066; -INSERT INTO areatrigger_scripts VALUES - (3066,'at_ravenholdt'); - --- moved from world_spell_full.sql to here -update creature_template set `AIName`='TurretAI',`ScriptName`='' WHERE `entry`=33139; -update creature_template set `ScriptName`= 'boss_kologarn' WHERE `entry`=32930; -update creature_template set `scriptname`= 'boss_flame_leviathan_safety_container' WHERE `entry`=33218; +/* BATTLEGROUNDS */ +/* TODO */ + +/* OUTDOOR PVP */ +UPDATE `outdoorpvp_template` SET `ScriptName`='outdoorpvp_hp' WHERE `TypeId`=1; +UPDATE `outdoorpvp_template` SET `ScriptName`='outdoorpvp_na' WHERE `TypeId`=2; +UPDATE `outdoorpvp_template` SET `ScriptName`='outdoorpvp_tf' WHERE `TypeId`=3; +UPDATE `outdoorpvp_template` SET `ScriptName`='outdoorpvp_zm' WHERE `TypeId`=4; +UPDATE `outdoorpvp_template` SET `ScriptName`='outdoorpvp_si' WHERE `TypeId`=5; +UPDATE `outdoorpvp_template` SET `ScriptName`='outdoorpvp_ep' WHERE `TypeId`=6; + +/* EOF */ -- cgit v1.2.3