From 1fc5c0d6d7200048009f99c2cb4d3fd12858ed2f Mon Sep 17 00:00:00 2001
From: Neo2003 <none@none>
Date: Mon, 6 Oct 2008 04:48:59 -0500
Subject: [svn] * Little fix in RandomMovementGenerator * Updated to 6731 and
 680

--HG--
branch : trunk
rename : 6721-676 => 6731-680
---
 sql/mangos.sql          | 2 ++
 sql/updates/19_pack.sql | 4 ++++
 2 files changed, 6 insertions(+)
 create mode 100644 sql/updates/19_pack.sql

(limited to 'sql')

diff --git a/sql/mangos.sql b/sql/mangos.sql
index 686c581e9f7..14e084afd5b 100644
--- a/sql/mangos.sql
+++ b/sql/mangos.sql
@@ -2338,6 +2338,7 @@ INSERT INTO `mangos_string` VALUES
 (328,'Characters at account %s (Id: %u)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
 (329,'  %s (GUID %u)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
 (330,'No players found!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
+(331,'Extended item cost %u not exist',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
 (400,'|cffff0000[System Message]:|rScripts reloaded',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
 (401,'You change security level of %s to %i.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
 (402,'%s changed your security level to %i.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
@@ -10485,6 +10486,7 @@ UNLOCK TABLES;
 DROP TABLE IF EXISTS `quest_template`;
 CREATE TABLE `quest_template` (
   `entry` mediumint(8) unsigned NOT NULL default '0',
+  `Method` tinyint(3) unsigned NOT NULL default '2',
   `ZoneOrSort` smallint(6) NOT NULL default '0',
   `SkillOrClass` smallint(6) NOT NULL default '0',
   `MinLevel` tinyint(3) unsigned NOT NULL default '0',
diff --git a/sql/updates/19_pack.sql b/sql/updates/19_pack.sql
new file mode 100644
index 00000000000..3a43f43a955
--- /dev/null
+++ b/sql/updates/19_pack.sql
@@ -0,0 +1,4 @@
+ALTER TABLE `quest_template` ADD COLUMN `Method` tinyint(3) unsigned NOT NULL default '2' AFTER `entry`;
+DELETE FROM mangos_string WHERE entry IN (331);
+INSERT INTO mangos_string VALUES
+(331,'Extended item cost %u not exist',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
-- 
cgit v1.2.3