diff options
| author | XTZGZoReX <none@none> | 2010-08-07 17:30:14 +0200 |
|---|---|---|
| committer | XTZGZoReX <none@none> | 2010-08-07 17:30:14 +0200 |
| commit | aff24e35988d172b2471db7e16a19b24eb891b9b (patch) | |
| tree | fe2b7626bc6e6efe0e3357e0a939b9ee9b82f03f /sql/updates | |
| parent | 431301c1b29103e444b5c534c17543c87a99e481 (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/updates')
| -rw-r--r-- | sql/updates/9237_world_battleground_template.sql | 13 | ||||
| -rw-r--r-- | sql/updates/9237_world_outdoorpvp_template.sql | 8 |
2 files changed, 21 insertions, 0 deletions
diff --git a/sql/updates/9237_world_battleground_template.sql b/sql/updates/9237_world_battleground_template.sql new file mode 100644 index 00000000000..fcf33502167 --- /dev/null +++ b/sql/updates/9237_world_battleground_template.sql @@ -0,0 +1,13 @@ +UPDATE `battleground_template` SET `Comment`= 'Alterac Valley' WHERE `battleground_template`.`id`=1; +UPDATE `battleground_template` SET `Comment`= 'Warsong Gulch' WHERE `battleground_template`.`id`=2; +UPDATE `battleground_template` SET `Comment`= 'Arathi Basin' WHERE `battleground_template`.`id`=3; +UPDATE `battleground_template` SET `Comment`= 'Nagrand Arena' WHERE `battleground_template`.`id`=4; +UPDATE `battleground_template` SET `Comment`= 'Blades''s Edge Arena' WHERE `battleground_template`.`id`=5; +UPDATE `battleground_template` SET `Comment`= 'All Arena' WHERE `battleground_template`.`id`=6; +UPDATE `battleground_template` SET `Comment`= 'Eye of The Storm' WHERE `battleground_template`.`id`=7; +UPDATE `battleground_template` SET `Comment`= 'Ruins of Lordaeron' WHERE `battleground_template`.`id`=8; +UPDATE `battleground_template` SET `Comment`= 'Strand of the Ancients' WHERE `battleground_template`.`id`=9; +UPDATE `battleground_template` SET `Comment`= 'Dalaran Sewers' WHERE `battleground_template`.`id`=10; +UPDATE `battleground_template` SET `Comment`= 'The Ring of Valor' WHERE `battleground_template`.`id`=11; +UPDATE `battleground_template` SET `Comment`= 'Isle of Conquest' WHERE `battleground_template`.`id`=30; +UPDATE `battleground_template` SET `Comment`= 'Random battleground' WHERE `battleground_template`.`id`=32; diff --git a/sql/updates/9237_world_outdoorpvp_template.sql b/sql/updates/9237_world_outdoorpvp_template.sql new file mode 100644 index 00000000000..02e672cb9a2 --- /dev/null +++ b/sql/updates/9237_world_outdoorpvp_template.sql @@ -0,0 +1,8 @@ +DELETE FROM `outdoorpvp_template` WHERE `TypeId` IN (1,2,3,4,5,6);
+INSERT INTO `outdoorpvp_template` (`TypeId`, `ScriptName`, `Comment`) VALUES
+(1, 'outdoorpvp_hp', 'Hellfire Peninsula');
+(2, 'outdoorpvp_na', 'Nagrand');
+(3, 'outdoorpvp_tf', 'Terokkar Forest');
+(4, 'outdoorpvp_zm', 'Zangarmarsh');
+(5, 'outdoorpvp_si', 'Silithus');
+(6, 'outdoorpvp_ep', 'Eastern Plaguelands');
|