From d2a3f9670f303ad3e27d2860762091db37ab2d2e Mon Sep 17 00:00:00 2001
From: Spp <none@none>
Date: Fri, 12 Mar 2010 18:19:50 +0100
Subject: Move vehicle accesories to DB. Credit to Malcrom and Manuel for the
 idea and original patch

--HG--
branch : trunk
---
 sql/world.sql | 62 +++++++++++++++++++++++++++++++++++++++++++++++++++--------
 1 file changed, 54 insertions(+), 8 deletions(-)

(limited to 'sql/world.sql')

diff --git a/sql/world.sql b/sql/world.sql
index 0ee8ed1362c..805e76841fb 100644
--- a/sql/world.sql
+++ b/sql/world.sql
@@ -14805,14 +14805,14 @@ INSERT INTO `trinity_string` (`entry`,`content_default`,`content_loc1`,`content_
 (5025, 'Type: %u', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
 (5026, 'DisplayID: %u', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
 (5027, 'Name: %s', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
-(6604, 'You cannot say, yell or emote until you become level %d.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
-(6605, 'You cannot whisper until you become level %d.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
-(6606, 'You cannot write to channels until you become level %d.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
-(6607, 'You cannot use auction until you become level %d.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
-(6608, 'You cannot write tickets until you become level %d.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
-(6609, 'You cannot trade until you become level %d.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
-(6610, 'You cannot trade with characters lower than level %d.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
-(6611, 'You cannot send mail until you become level %d.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(6604, 'You cannot say, yell or emote until you become level %d.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(6605, 'You cannot whisper until you become level %d.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(6606, 'You cannot write to channels until you become level %d.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(6607, 'You cannot use auction until you become level %d.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(6608, 'You cannot write tickets until you become level %d.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(6609, 'You cannot trade until you become level %d.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(6610, 'You cannot trade with characters lower than level %d.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(6611, 'You cannot send mail until you become level %d.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
 (6612, 'You cannot send mail to characters lower than level %d.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
 (6613, '|cfff00000[GM Announcement]: %s|r', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
 (6614, 'Notification to GM''s - ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
@@ -14886,6 +14886,52 @@ INSERT INTO `trinity_string` (`entry`,`content_default`,`content_loc1`,`content_
 /*!40000 ALTER TABLE `trinity_string` ENABLE KEYS */;
 UNLOCK TABLES;
 
+--
+-- Table structure for table `vehicle_accessory`
+--
+DROP TABLE IF EXISTS `vehicle_accessory`;
+CREATE TABLE `vehicle_accessory` (
+        `entry` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT 0,
+        `accessory_entry` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT 0,
+        `seat_id` TINYINT(1) SIGNED NOT NULL DEFAULT 0,
+        `minion` TINYINT(1) UNSIGNED NOT NULL DEFAULT 0,
+        `description` TEXT NOT NULL,
+        PRIMARY KEY (`entry`, `seat_id`)
+)
+COLLATE=utf8_general_ci
+ENGINE=MyISAM
+ROW_FORMAT=FIXED
+AVG_ROW_LENGTH=0
+
+
+LOCK TABLES `vehicle_accessory` WRITE;
+INSERT INTO `vehicle_accessory` (`entry`,`accessory_entry`,`seat_id`,`minion`,`description`) VALUES
+(28782,28768,0,0, 'Acherus Deathcharger'),
+(28312,28319,7,1, 'Wintergrasp Siege Engine'),
+(32627,32629,7,1, 'Wintergrasp Siege Engine'),
+(32930,32933,0,1, 'Kologarn'),
+(32930,32934,1,1, 'Kologarn'),
+(33109,33167,1,1, 'Salvaged Demolisher'),
+(33060,33067,7,1, 'Salvaged Siege Engine'),
+(33113,33114,0,1, 'Flame Leviathan'),
+(33113,33114,1,1, 'Flame Leviathan'),
+(33113,33114,2,1, 'Flame Leviathan'),
+(33113,33114,3,1, 'Flame Leviathan'),
+(33113,33139,7,1, 'Flame Leviathan'),
+(33114,33142,1,1, 'Overload Control Device'),       
+(33114,33143,2,1, 'Leviathan Defense Turret'),       
+(33214,33218,1,1, 'Mechanolift 304-A'),      
+(35637,34705,0,0, 'Marshal Jacob Alerius'' Mount'),
+(35633,34702,0,0, 'Ambrose Boltspark''s Mount'),
+(35768,34701,0,0, 'Colosos'' Mount'),
+(34658,34657,0,0, 'Jaelyne Evensong''s Mount'),
+(35636,34703,0,0, 'Lana Stouthammer''s Mount'),
+(35638,35572,0,0, 'Mokra the Skullcrusher''s Mount'),
+(35635,35569,0,0, 'Eressea Dawnsinger''s Mount'),
+(35640,35571,0,0, 'Runok Wildmane''s Mount'),
+(35641,35570,0,0, 'Zul''tore''s Mount'),
+(35634,35617,0,0, 'Deathstalker Visceri''s Mount');
+UNLOCK TABLES;
 --
 -- Table structure for table `version`
 --
-- 
cgit v1.2.3

