From d75011c4a86f56175b15cbb93069d376ef085592 Mon Sep 17 00:00:00 2001 From: XTZGZoReX Date: Sun, 8 Aug 2010 22:05:28 +0200 Subject: * Fix SQL errors, again thanks to Machiavelli. --HG-- branch : trunk --- sql/base/world_database.sql | 10 +++++----- sql/updates/9237_world_outdoorpvp_template.sql | 10 +++++----- 2 files changed, 10 insertions(+), 10 deletions(-) (limited to 'sql') diff --git a/sql/base/world_database.sql b/sql/base/world_database.sql index d3d2ea81f6e..ba969897616 100644 --- a/sql/base/world_database.sql +++ b/sql/base/world_database.sql @@ -3863,11 +3863,11 @@ CREATE TABLE `outdoorpvp_template` ( LOCK TABLES `outdoorpvp_template` WRITE; /*!40000 ALTER TABLE `outdoorpvp_template` DISABLE KEYS */; INSERT INTO `outdoorpvp_template` (`TypeId`, `Comment`) VALUES -(1, 'Hellfire Peninsula'); -(2, 'Nagrand'); -(3, 'Terokkar Forest'); -(4, 'Zangarmarsh'); -(5, 'Silithus'); +(1, 'Hellfire Peninsula'), +(2, 'Nagrand'), +(3, 'Terokkar Forest'), +(4, 'Zangarmarsh'), +(5, 'Silithus'), (6, 'Eastern Plaguelands'); /*!40000 ALTER TABLE `outdoorpvp_template` ENABLE KEYS */; UNLOCK TABLES; diff --git a/sql/updates/9237_world_outdoorpvp_template.sql b/sql/updates/9237_world_outdoorpvp_template.sql index 02e672cb9a2..9753369cbca 100644 --- a/sql/updates/9237_world_outdoorpvp_template.sql +++ b/sql/updates/9237_world_outdoorpvp_template.sql @@ -1,8 +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'); +(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'); -- cgit v1.2.3