aboutsummaryrefslogtreecommitdiff
path: root/sql/scripts
diff options
context:
space:
mode:
authorXTZGZoReX <none@none>2010-08-07 17:30:14 +0200
committerXTZGZoReX <none@none>2010-08-07 17:30:14 +0200
commitaff24e35988d172b2471db7e16a19b24eb891b9b (patch)
treefe2b7626bc6e6efe0e3357e0a939b9ee9b82f03f /sql/scripts
parent431301c1b29103e444b5c534c17543c87a99e481 (diff)
* Some cleanups in world_scripts_full.sql.
* SQL updates for `battleground_template`.`Comment` (by Click), and `outdoorpvp_template` content. --HG-- branch : trunk
Diffstat (limited to 'sql/scripts')
-rw-r--r--sql/scripts/world_scripts_full.sql32
1 files changed, 22 insertions, 10 deletions
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 */