Show mangos.sql syntax highlighted
-- MySQL dump 10.11
--
-- Host: localhost Database: mangos
-- ------------------------------------------------------
-- Server version 5.0.38-Ubuntu_0ubuntu1-log
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
--
-- Table structure for table `areatrigger_involvedrelation`
--
DROP TABLE IF EXISTS `areatrigger_involvedrelation`;
CREATE TABLE `areatrigger_involvedrelation` (
`id` int(11) unsigned NOT NULL default '0' COMMENT 'Identifier',
`quest` int(11) unsigned NOT NULL default '0' COMMENT 'Quest Identifier',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Trigger System';
--
-- Dumping data for table `areatrigger_involvedrelation`
--
LOCK TABLES `areatrigger_involvedrelation` WRITE;
/*!40000 ALTER TABLE `areatrigger_involvedrelation` DISABLE KEYS */;
/*!40000 ALTER TABLE `areatrigger_involvedrelation` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `areatrigger_tavern`
--
DROP TABLE IF EXISTS `areatrigger_tavern`;
CREATE TABLE `areatrigger_tavern` (
`id` int(11) unsigned NOT NULL default '0' COMMENT 'Identifier',
`name` text,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Trigger System';
--
-- Dumping data for table `areatrigger_tavern`
--
LOCK TABLES `areatrigger_tavern` WRITE;
/*!40000 ALTER TABLE `areatrigger_tavern` DISABLE KEYS */;
/*!40000 ALTER TABLE `areatrigger_tavern` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `areatrigger_template`
--
DROP TABLE IF EXISTS `areatrigger_template`;
CREATE TABLE `areatrigger_template` (
`id` int(11) unsigned NOT NULL default '0' COMMENT 'Identifier',
`name` text,
`required_level` tinyint(3) unsigned NOT NULL default '0',
`required_item` int(11) unsigned NOT NULL default '0',
`trigger_map` int(11) unsigned NOT NULL default '0',
`trigger_position_x` float NOT NULL default '0',
`trigger_position_y` float NOT NULL default '0',
`trigger_position_z` float NOT NULL default '0',
`target_map` int(11) unsigned NOT NULL default '0',
`target_position_x` float NOT NULL default '0',
`target_position_y` float NOT NULL default '0',
`target_position_z` float NOT NULL default '0',
`target_orientation` float NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Trigger System';
--
-- Dumping data for table `areatrigger_template`
--
LOCK TABLES `areatrigger_template` WRITE;
/*!40000 ALTER TABLE `areatrigger_template` DISABLE KEYS */;
/*!40000 ALTER TABLE `areatrigger_template` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `arena_team`
--
DROP TABLE IF EXISTS `arena_team`;
CREATE TABLE `arena_team` (
`arenateamid` int(10) unsigned NOT NULL default '0',
`name` char(255) NOT NULL,
`captainguid` int(10) unsigned NOT NULL default '0',
`type` tinyint(3) unsigned NOT NULL default '0',
`EmblemStyle` int(10) unsigned NOT NULL default '0',
`EmblemColor` int(10) unsigned NOT NULL default '0',
`BorderStyle` int(10) unsigned NOT NULL default '0',
`BorderColor` int(10) unsigned NOT NULL default '0',
`BackgroundColor` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`arenateamid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Dumping data for table `arena_team`
--
LOCK TABLES `arena_team` WRITE;
/*!40000 ALTER TABLE `arena_team` DISABLE KEYS */;
/*!40000 ALTER TABLE `arena_team` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `arena_team_member`
--
DROP TABLE IF EXISTS `arena_team_member`;
CREATE TABLE `arena_team_member` (
`arenateamid` int(10) unsigned NOT NULL default '0',
`guid` int(10) unsigned NOT NULL default '0',
`played_week` int(10) unsigned NOT NULL default '0',
`wons_week` int(10) unsigned NOT NULL default '0',
`played_season` int(10) unsigned NOT NULL default '0',
`wons_season` int(10) unsigned NOT NULL default '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Dumping data for table `arena_team_member`
--
LOCK TABLES `arena_team_member` WRITE;
/*!40000 ALTER TABLE `arena_team_member` DISABLE KEYS */;
/*!40000 ALTER TABLE `arena_team_member` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `arena_team_stats`
--
DROP TABLE IF EXISTS `arena_team_stats`;
CREATE TABLE `arena_team_stats` (
`arenateamid` int(10) unsigned NOT NULL default '0',
`rating` int(10) unsigned NOT NULL default '0',
`games` int(10) unsigned NOT NULL default '0',
`wins` int(10) unsigned NOT NULL default '0',
`played` int(10) unsigned NOT NULL default '0',
`wins2` int(10) unsigned NOT NULL default '0',
`rank` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`arenateamid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Dumping data for table `arena_team_stats`
--
LOCK TABLES `arena_team_stats` WRITE;
/*!40000 ALTER TABLE `arena_team_stats` DISABLE KEYS */;
/*!40000 ALTER TABLE `arena_team_stats` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `auctionhouse`
--
DROP TABLE IF EXISTS `auctionhouse`;
CREATE TABLE `auctionhouse` (
`id` int(11) unsigned NOT NULL default '0',
`auctioneerguid` int(11) unsigned NOT NULL default '0',
`itemguid` int(11) unsigned NOT NULL default '0',
`item_template` int(11) unsigned NOT NULL default '0' COMMENT 'Item Identifier',
`itemowner` int(11) unsigned NOT NULL default '0',
`buyoutprice` int(11) NOT NULL default '0',
`time` bigint(40) NOT NULL default '0',
`buyguid` int(11) unsigned NOT NULL default '0',
`lastbid` int(11) NOT NULL default '0',
`startbid` int(11) NOT NULL default '0',
`deposit` int(11) NOT NULL default '0',
`location` tinyint(3) unsigned NOT NULL default '3',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Dumping data for table `auctionhouse`
--
LOCK TABLES `auctionhouse` WRITE;
/*!40000 ALTER TABLE `auctionhouse` DISABLE KEYS */;
/*!40000 ALTER TABLE `auctionhouse` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `battleground_template`
--
DROP TABLE IF EXISTS `battleground_template`;
CREATE TABLE `battleground_template` (
`id` int(11) unsigned NOT NULL,
`MaxPlayersPerTeam` int(11) NOT NULL,
`MinLvl` int(11) NOT NULL,
`MaxLvl` int(11) NOT NULL,
`AllianceStartLoc` int(11) unsigned NOT NULL,
`AllianceStartO` float NOT NULL,
`HordeStartLoc` int(11) unsigned NOT NULL,
`HordeStartO` float NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `battleground_template`
--
LOCK TABLES `battleground_template` WRITE;
/*!40000 ALTER TABLE `battleground_template` DISABLE KEYS */;
INSERT INTO `battleground_template` VALUES
(1,0,0,0,611,2.72532,610,2.27452),
(2,0,0,0,769,3.14159,770,3.14159),
(4,2,10,70,929,0,936,3.14159),
(3,0,0,0,890,3.40156,889,0.263892),
(5,2,10,70,939,0,940,3.14159),
(6,2,10,70,0,0,0,0),
(7,0,0,0,1103,3.40156,1104,0.263892),
(8,2,10,70,1258,0,1259,3.14159);
/*!40000 ALTER TABLE `battleground_template` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `bugreport`
--
DROP TABLE IF EXISTS `bugreport`;
CREATE TABLE `bugreport` (
`id` int(11) NOT NULL auto_increment COMMENT 'Identifier',
`type` varchar(255) NOT NULL default '',
`content` varchar(255) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Debug System';
--
-- Dumping data for table `bugreport`
--
LOCK TABLES `bugreport` WRITE;
/*!40000 ALTER TABLE `bugreport` DISABLE KEYS */;
/*!40000 ALTER TABLE `bugreport` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `character`
--
DROP TABLE IF EXISTS `character`;
CREATE TABLE `character` (
`guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
`account` int(11) unsigned NOT NULL default '0' COMMENT 'Account Identifier',
`data` longtext,
`name` varchar(12) NOT NULL default '',
`race` tinyint(3) unsigned NOT NULL default '0',
`class` tinyint(3) unsigned NOT NULL default '0',
`position_x` float NOT NULL default '0',
`position_y` float NOT NULL default '0',
`position_z` float NOT NULL default '0',
`map` int(11) unsigned NOT NULL default '0' COMMENT 'Map Identifier',
`orientation` float NOT NULL default '0',
`taximask` longtext,
`online` tinyint(3) unsigned NOT NULL default '0',
`cinematic` tinyint(3) unsigned NOT NULL default '0',
`totaltime` int(11) unsigned NOT NULL default '0',
`leveltime` int(11) unsigned NOT NULL default '0',
`logout_time` int(11) NOT NULL default '0',
`is_logout_resting` tinyint(3) NOT NULL default '0',
`rest_bonus` float NOT NULL default '0',
`resettalents_cost` int(11) unsigned NOT NULL default '0',
`resettalents_time` bigint(20) unsigned NOT NULL default '0',
`trans_x` float NOT NULL default '0',
`trans_y` float NOT NULL default '0',
`trans_z` float NOT NULL default '0',
`trans_o` float NOT NULL default '0',
`transguid` bigint(20) unsigned NOT NULL default '0',
`gmstate` tinyint(3) unsigned NOT NULL default '0',
`stable_slots` tinyint(1) unsigned NOT NULL default '0',
`at_login` int(11) unsigned NOT NULL default '0',
`zone` int(11) unsigned NOT NULL default '0',
`last_honor_date` int(11) unsigned NOT NULL default '0',
`pending_kills` int(11) NOT NULL default '0',
`last_kill_date` int(11) unsigned NOT NULL default '0',
PRIMARY KEY (`guid`),
KEY `idx_account` (`account`),
KEY `idx_online` (`online`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
--
-- Dumping data for table `character`
--
LOCK TABLES `character` WRITE;
/*!40000 ALTER TABLE `character` DISABLE KEYS */;
/*!40000 ALTER TABLE `character` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `character_action`
--
DROP TABLE IF EXISTS `character_action`;
CREATE TABLE `character_action` (
`guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
`button` tinyint(3) unsigned NOT NULL default '0',
`action` smallint(5) unsigned NOT NULL default '0',
`type` tinyint(3) unsigned NOT NULL default '0',
`misc` tinyint(3) unsigned NOT NULL default '0',
PRIMARY KEY (`guid`,`button`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
--
-- Dumping data for table `character_action`
--
LOCK TABLES `character_action` WRITE;
/*!40000 ALTER TABLE `character_action` DISABLE KEYS */;
/*!40000 ALTER TABLE `character_action` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `character_aura`
--
DROP TABLE IF EXISTS `character_aura`;
CREATE TABLE `character_aura` (
`guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
`caster_guid` bigint(20) unsigned NOT NULL default '0' COMMENT 'Full Global Unique Identifier',
`spell` int(11) unsigned NOT NULL default '0',
`effect_index` int(11) unsigned NOT NULL default '0',
`amount` int(11) NOT NULL default '0',
`remaintime` int(11) NOT NULL default '0',
PRIMARY KEY (`guid`,`spell`,`effect_index`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
--
-- Dumping data for table `character_aura`
--
LOCK TABLES `character_aura` WRITE;
/*!40000 ALTER TABLE `character_aura` DISABLE KEYS */;
/*!40000 ALTER TABLE `character_aura` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `character_gifts`
--
DROP TABLE IF EXISTS `character_gifts`;
CREATE TABLE `character_gifts` (
`guid` int(20) unsigned NOT NULL default '0',
`item_guid` int(11) unsigned NOT NULL default '0',
`entry` int(20) unsigned NOT NULL default '0',
`flags` int(20) unsigned NOT NULL default '0',
PRIMARY KEY (`item_guid`),
KEY `idx_guid` (`guid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Dumping data for table `character_gifts`
--
LOCK TABLES `character_gifts` WRITE;
/*!40000 ALTER TABLE `character_gifts` DISABLE KEYS */;
/*!40000 ALTER TABLE `character_gifts` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `character_homebind`
--
DROP TABLE IF EXISTS `character_homebind`;
CREATE TABLE `character_homebind` (
`guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
`map` int(11) unsigned NOT NULL default '0' COMMENT 'Map Identifier',
`zone` int(11) unsigned NOT NULL default '0' COMMENT 'Zone Identifier',
`position_x` float NOT NULL default '0',
`position_y` float NOT NULL default '0',
`position_z` float NOT NULL default '0',
PRIMARY KEY (`guid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
--
-- Dumping data for table `character_homebind`
--
LOCK TABLES `character_homebind` WRITE;
/*!40000 ALTER TABLE `character_homebind` DISABLE KEYS */;
/*!40000 ALTER TABLE `character_homebind` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `character_instance`
--
DROP TABLE IF EXISTS `character_instance`;
CREATE TABLE `character_instance` (
`guid` int(11) unsigned NOT NULL default '0',
`map` int(11) unsigned NOT NULL default '0',
`instance` bigint(40) NOT NULL default '0',
`leader` int(11) unsigned NOT NULL default '0',
PRIMARY KEY (`guid`,`map`),
KEY `instance` (`instance`),
KEY `leader` (`leader`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Dumping data for table `character_instance`
--
LOCK TABLES `character_instance` WRITE;
/*!40000 ALTER TABLE `character_instance` DISABLE KEYS */;
/*!40000 ALTER TABLE `character_instance` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `character_inventory`
--
DROP TABLE IF EXISTS `character_inventory`;
CREATE TABLE `character_inventory` (
`guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
`bag` int(11) unsigned NOT NULL default '0',
`slot` tinyint(3) unsigned NOT NULL default '0',
`item` int(11) unsigned NOT NULL default '0' COMMENT 'Item Global Unique Identifier',
`item_template` int(11) unsigned NOT NULL default '0' COMMENT 'Item Identifier',
PRIMARY KEY (`item`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
--
-- Dumping data for table `character_inventory`
--
LOCK TABLES `character_inventory` WRITE;
/*!40000 ALTER TABLE `character_inventory` DISABLE KEYS */;
/*!40000 ALTER TABLE `character_inventory` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `character_kill`
--
DROP TABLE IF EXISTS `character_kill`;
CREATE TABLE `character_kill` (
`guid` int(11) NOT NULL default '0',
`victim_guid` int(11) NOT NULL default '0',
`count` tinyint(3) NOT NULL default '0',
PRIMARY KEY (`guid`,`victim_guid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Kills Yesterday';
--
-- Dumping data for table `character_kill`
--
LOCK TABLES `character_kill` WRITE;
/*!40000 ALTER TABLE `character_kill` DISABLE KEYS */;
/*!40000 ALTER TABLE `character_kill` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `character_pet`
--
DROP TABLE IF EXISTS `character_pet`;
CREATE TABLE `character_pet` (
`id` int(11) unsigned NOT NULL default '0',
`entry` int(11) unsigned NOT NULL default '0',
`owner` int(11) unsigned NOT NULL default '0',
`modelid` int(11) unsigned default '0',
`CreatedBySpell` int(11) unsigned NOT NULL default '0',
`PetType` tinyint(3) unsigned NOT NULL default '0',
`level` int(11) unsigned NOT NULL default '1',
`exp` int(11) unsigned NOT NULL default '0',
`nextlvlexp` int(11) unsigned NOT NULL default '100',
`Reactstate` tinyint(1) unsigned NOT NULL default '0',
`Commandstate` tinyint(1) unsigned NOT NULL default '1',
`loyaltypoints` int(11) NOT NULL default '0',
`loyalty` int(11) unsigned NOT NULL default '0',
`trainpoint` int(11) NOT NULL default '0',
`name` varchar(100) default 'Pet',
`renamed` tinyint(1) unsigned NOT NULL default '0',
`slot` int(11) unsigned NOT NULL default '0',
`curhealth` int(11) unsigned NOT NULL default '1',
`curmana` int(11) unsigned NOT NULL default '0',
`curhappiness` int(11) unsigned NOT NULL default '0',
`savetime` bigint(20) unsigned NOT NULL default '0',
`resettalents_cost` int(11) unsigned NOT NULL default '0',
`resettalents_time` bigint(20) unsigned NOT NULL default '0',
`ABData` longtext,
`TeachSpelldata` longtext,
PRIMARY KEY (`id`),
KEY `owner` (`owner`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Pet System';
--
-- Dumping data for table `character_pet`
--
LOCK TABLES `character_pet` WRITE;
/*!40000 ALTER TABLE `character_pet` DISABLE KEYS */;
/*!40000 ALTER TABLE `character_pet` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `character_queststatus`
--
DROP TABLE IF EXISTS `character_queststatus`;
CREATE TABLE `character_queststatus` (
`guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
`quest` int(11) unsigned NOT NULL default '0' COMMENT 'Quest Identifier',
`status` int(11) unsigned NOT NULL default '0',
`rewarded` tinyint(1) unsigned NOT NULL default '0',
`explored` tinyint(1) unsigned NOT NULL default '0',
`timer` bigint(20) unsigned NOT NULL default '0',
`mobcount1` int(11) unsigned NOT NULL default '0',
`mobcount2` int(11) unsigned NOT NULL default '0',
`mobcount3` int(11) unsigned NOT NULL default '0',
`mobcount4` int(11) unsigned NOT NULL default '0',
`itemcount1` int(11) unsigned NOT NULL default '0',
`itemcount2` int(11) unsigned NOT NULL default '0',
`itemcount3` int(11) unsigned NOT NULL default '0',
`itemcount4` int(11) unsigned NOT NULL default '0',
PRIMARY KEY (`guid`,`quest`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
--
-- Dumping data for table `character_queststatus`
--
LOCK TABLES `character_queststatus` WRITE;
/*!40000 ALTER TABLE `character_queststatus` DISABLE KEYS */;
/*!40000 ALTER TABLE `character_queststatus` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `character_reputation`
--
DROP TABLE IF EXISTS `character_reputation`;
CREATE TABLE `character_reputation` (
`guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
`faction` int(11) unsigned NOT NULL default '0',
`standing` int(11) NOT NULL default '0',
`flags` int(11) NOT NULL default '0',
PRIMARY KEY (`guid`,`faction`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
--
-- Dumping data for table `character_reputation`
--
LOCK TABLES `character_reputation` WRITE;
/*!40000 ALTER TABLE `character_reputation` DISABLE KEYS */;
/*!40000 ALTER TABLE `character_reputation` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `character_social`
--
DROP TABLE IF EXISTS `character_social`;
CREATE TABLE `character_social` (
`guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
`name` varchar(21) NOT NULL default '',
`friend` int(11) unsigned NOT NULL default '0' COMMENT 'Character Global Unique Identifier',
`flags` varchar(21) NOT NULL default '',
PRIMARY KEY (`guid`,`friend`,`flags`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
--
-- Dumping data for table `character_social`
--
LOCK TABLES `character_social` WRITE;
/*!40000 ALTER TABLE `character_social` DISABLE KEYS */;
/*!40000 ALTER TABLE `character_social` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `character_spell`
--
DROP TABLE IF EXISTS `character_spell`;
CREATE TABLE `character_spell` (
`guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
`spell` int(11) unsigned NOT NULL default '0' COMMENT 'Spell Identifier',
`slot` int(11) unsigned NOT NULL default '0',
`active` tinyint(3) unsigned NOT NULL default '1',
PRIMARY KEY (`guid`,`spell`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
--
-- Dumping data for table `character_spell`
--
LOCK TABLES `character_spell` WRITE;
/*!40000 ALTER TABLE `character_spell` DISABLE KEYS */;
/*!40000 ALTER TABLE `character_spell` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `character_spell_cooldown`
--
DROP TABLE IF EXISTS `character_spell_cooldown`;
CREATE TABLE `character_spell_cooldown` (
`guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier, Low part',
`spell` int(11) unsigned NOT NULL default '0' COMMENT 'Spell Identifier',
`item` int(11) unsigned NOT NULL default '0' COMMENT 'Item Identifier',
`time` bigint(20) unsigned NOT NULL default '0',
PRIMARY KEY (`guid`,`spell`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Dumping data for table `character_spell_cooldown`
--
LOCK TABLES `character_spell_cooldown` WRITE;
/*!40000 ALTER TABLE `character_spell_cooldown` DISABLE KEYS */;
/*!40000 ALTER TABLE `character_spell_cooldown` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `character_ticket`
--
DROP TABLE IF EXISTS `character_ticket`;
CREATE TABLE `character_ticket` (
`ticket_id` int(11) NOT NULL auto_increment,
`guid` int(11) unsigned NOT NULL default '0',
`ticket_text` text,
`ticket_category` int(1) NOT NULL default '0',
PRIMARY KEY (`ticket_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
--
-- Dumping data for table `character_ticket`
--
LOCK TABLES `character_ticket` WRITE;
/*!40000 ALTER TABLE `character_ticket` DISABLE KEYS */;
/*!40000 ALTER TABLE `character_ticket` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `character_tutorial`
--
DROP TABLE IF EXISTS `character_tutorial`;
CREATE TABLE `character_tutorial` (
`guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
`tut0` int(11) unsigned NOT NULL default '0',
`tut1` int(11) unsigned NOT NULL default '0',
`tut2` int(11) unsigned NOT NULL default '0',
`tut3` int(11) unsigned NOT NULL default '0',
`tut4` int(11) unsigned NOT NULL default '0',
`tut5` int(11) unsigned NOT NULL default '0',
`tut6` int(11) unsigned NOT NULL default '0',
`tut7` int(11) unsigned NOT NULL default '0',
PRIMARY KEY (`guid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
--
-- Dumping data for table `character_tutorial`
--
LOCK TABLES `character_tutorial` WRITE;
/*!40000 ALTER TABLE `character_tutorial` DISABLE KEYS */;
/*!40000 ALTER TABLE `character_tutorial` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `command`
--
DROP TABLE IF EXISTS `command`;
CREATE TABLE `command` (
`name` varchar(50) NOT NULL default '',
`security` tinyint(3) unsigned NOT NULL default '0',
`help` longtext,
PRIMARY KEY (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Chat System';
--
-- Dumping data for table `command`
--
LOCK TABLES `command` WRITE;
/*!40000 ALTER TABLE `command` DISABLE KEYS */;
INSERT INTO `command` VALUES
('acct',0,'Syntax: .acct\r\n\r\nDisplay the access level of your account.'),
('addgo',2,'Syntax: .addgo #id <lootID> <spawntimeSecs>\r\n\r\nAdd a game object from game object templates to the world at your current location using the #id.\r\nlootID specifies the loot-template to be used and spawntimesecs sets the spawntime, both are optional.\r\n\r\nNote: this is a copy of .gameobject.'),
('additem',3,'Syntax: .additem #itemid/[#itemname]/#shift-click-item-link #itemcount\r\n\r\nAdds the specified number of items of id #itemid (or exact (!) name $itemname in brackets, or link created by shift-click at item in inventory or recipe) to your or selected character inventory. If #itemcount is omitted, only one item will be added.\r\n.'),
('additemset',3,'Syntax: .additemset #itemsetid\r\n\r\nAdd items from itemset of id #itemsetid to your or selected character inventory. Will add by one example each item from itemset.'),
('addmove',2,'Syntax: .addmove #creature_guid [#waittime]\r\n\r\nAdd your current location as a waypoint for creature with guid #creature_guid. And optional add wait time.'),
('addquest',3,'Syntax: .addquest #quest_id\r\n\r\nAdd to character quest log quest #quest_id. Quest started from item can\'t be added by this command but correct .additem call provided in command output.'),
('addtele',3,'Syntax: .addtele $name\r\n\r\nAdd current your position to .tele command target locations list with name $name.'),
('addspw',2,'Syntax: .addspw #creatureid\r\n\r\nSpawn a creature by the given template id of #creatureid.'),
('addweapon',3,'Not yet implemented.'),
('addvendoritem',2,'Syntax: .addvendoritem #itemId <#maxcount><#incrtime>\r\n\r\nAdd item #itemid to item list of selected vendor. Also optionally set max count item in vendor item list and time to item count restoring.'),
('delvendoritem',2,'Syntax: .delvendoritem #itemId\r\n\r\nRemove item #itemid from item list of selected vendor.'),
('allowmove',3,'Syntax: .allowmove\r\n\r\nEnable or disable movement for the selected creature.'),
('anim',2,'Syntax: .anim #emoteid\r\n\r\nPlay emote #emoteid for your character.'),
('announce',1,'Syntax: .announce $MessageToBroadcast\r\n\r\nSend a global message to all players online in chat log.'),
('notify',1,'Syntax: .notify $MessageToBroadcast\r\n\r\nSend a global message to all players online in screen.'),
('aura',3,'Syntax: .aura #spellid\r\n\r\nAdd the aura from spell #spellid to the selected Unit.'),
('ban',3,'Syntax is: ban <account|ip|character> $NameOrIp $bantime $reason\r\nBan account or IP and kick player.\r\n$bantime: negative value leads to permban, otherwise use a timestring like \"4d20h3s\".'),
('unban',3,'Syntax is: unban <account|ip|character> $NameOrIp\r\nUnban account or IP.'),
('bank',3,'Syntax: .bank\r\n\r\nShow your bank inventory.'),
('changelevel',2,'Syntax: .changelevel #level\r\n\r\nChange the level of the selected creature to #level.\r\n\r\n#level may range from 1 to 63.'),
('commands',0,'Syntax: .commands\r\n\r\nDisplay a list of available commands for your account level.'),
('cooldown',3,'Syntax: .cooldown [#spell_id]\r\n\r\nRemove all (if spell_id not provided) or #spel_id spell cooldown from selected character or you (if no selection).'),
('createguild',3,'Syntax: .createguild $GuildLeaderName $GuildName\r\n\r\nCreate a guild named $GuildName with the player $GuildLeaderName as leader.'),
('cshutdown',3,'Syntax: .cshutdown Cancels shutdown'),
('delete',2,'Syntax: .delete\r\n\r\nDelete the selected creature from the world.'),
('delobject',2,'Syntax: .delobject #go_guid\r\nDelete gameobject with guid #go_guid.'),
('deltele',3,'Syntax: .deltele $name\r\n\r\nRemove location with name $name for .tele command locations list.'),
('delticket',2,'Syntax: .delticket all\r\n .delticket #num\r\n .delticket $character_name\r\n\rall to dalete all tickets at server, $character_name to delete ticket of this character, #num to delete ticket #num.'),
('demorph',2,'Syntax: .demorph\r\n\r\nDemorph the selected player.'),
('die',3,'Syntax: .die\r\n\r\nKill the selected player. If no player is selected, it will kill you.'),
('dismount',0,'Syntax: .dismount\r\n\r\nDismount you, if you are mounted.'),
('setmodel',2,'Syntax: .setmodel #displayid\r\n\r\nChange the model id of the selected creature to #displayid.'),
('distance',3,'Syntax: .distance\r\n\r\nDisplay the distance from your character to the selected creature.'),
('playemote',3,'Syntax: .playemote #emoteid\r\n\r\nMake the selected creature emote with an emote of id #emoteid.'),
('textemote',3,'Syntax: .text #emoteid\r\n\r\nMake the selected creature to do textemote with an emote of id #emoteid.'),
('explorecheat',3,'Syntax: .explorecheat #flag\r\n\r\nReveal or hide all maps for the selected player. If no player is selected, hide or reveal maps to you.\r\n\r\nUse a #flag of value 1 to reveal, use a #flag value of 0 to hide all maps.'),
('factionid',2,'Syntax: .factionid #factionid\r\n\r\nSet the faction of the selected creature to #factionid.'),
('gameobject',3,'Syntax: .gameobject #id <lootID> <spawntimeSecs>\r\n\r\nAdd a game object from game object templates to the world at your current location using the #id.\r\nlootID specifies the loot-template to be used and spawntimeSecs sets the spawntime, both are optional.'),
('getvalue',3,'Syntax: .getvalue #field #isInt\r\n\r\nGet the field #field of the selected creature. If no creature is selected, get the content of your field.\r\n\r\nUse a #isInt of value 1 if the expected field content is an integer.'),
('gm',1,'Syntax: .gm on/off\r\n\r\nEnable or Disable GM MODE'),
('gocreature',2,'Syntax: .gocreature #creature_guid\r\nTeleport your character to creature with guid #creature_guid.\r\n.gocreature #creature_name\r\nTeleport your character to creature with this name.\r\n.gocreature id #creature_id\r\nTeleport your character to a creature that was spawned from the template with this entry.\r\n*If* more than one creature is found, then you are teleported to the first that is found inside the database.'),
('gogrid',1,'Syntax: .gogrid #gridX #gridY [#mapId]\n\nTeleport the gm to center of grid with provided indexes at map #mapId (or current map if it not provided).'),
('goobject',1,'Syntax: .goobject #object_guid\r\nTeleport your character to gameobject with guid #object_guid'),
('goname',1,'Syntax: .goname $charactername\r\n\r\nTeleport to the given character. Either specify the character name or click on the character\'s portrait, e.g. when you are in a group.'),
('goxy',1,'Syntax: .goxy #x #y [#mapid]\r\n\r\nTeleport player to point with (#x,#y) coordinates at ground(water) level at map #mapid or same map if #mapid not provided.'),
('goxyz',1,'Syntax: .goxyz #x #y #z [#mapid]\r\n\r\nTeleport player to point with (#x,#y,#z) coordinates at ground(water) level at map #mapid or same map if #mapid not provided.'),
('gps',1,'Syntax: .gps\r\n\r\nDisplay the position information for a selected character or creature. Position information includes X, Y, Z, and orientation, map Id and zone Id'),
('groupgo',1,'Syntax: .groupgo $charactername\r\n\r\nTeleport the given character and his group to you.'),
('grouptele',1,'Syntax: .grouptele #location\r\n\r\nTeleport a selected player and his group members to a given location.'),
('guid',2,'Syntax: .guid\r\n\r\nDisplay the GUID for the selected character.'),
('help',0,'Syntax: .help $command\r\n\r\nDisplay usage instructions for the given $command.'),
('hidearea',3,'Syntax: .hidearea #areaid\r\n\r\nHide the area of #areaid to the selected character. If no character is selected, hide this area to you.'),
('honor',2,'Syntax: .honor $command [$value] Various honor related commands. Use .help honor $command to get help on specific parameter usage. Supported parameters include add, addkill, flushkills, update'),
('honor add',2,'Syntax: .honor add $amount\r\n\r\nAdd a certain amount of honor (gained today) to the selected player.'),
('honor addkill',2,'Syntax: .honor addkikll\r\n\r\nAdd the targeted unit as one of your pvp kills today (you only get honor if it\'s a racial leader or a player)'),
('honor flushkills',2,'Syntax: .honor flushkills\r\n\r\nClear today\'s kills from the player limit storage (immediately) and from the DB (on next save) for the selected player.'),
('honor update',2,'Syntax: .honor update\r\n\r\nForce the yesterday\'s honor fields to be updated with today\'s data, which will get reset for the selected player.'),
('hover',3,'Syntax: .hover #flag\r\n\r\nEnable or disable hover mode for your character.\r\n\r\nUse a #flag of value 1 to enable, use a #flag value of 0 to disable hover.'),
('idleshutdown',3,'Syntax: .idleshutdown #delay|cancel\r\n\r\nShut the server down after #delay seconds if no active connections are present (no players) or cancel the shutdown if cancel value is used.'),
('info',0,'Syntax: .info\r\n\r\nDisplay the number of connected players.'),
('itemmove',2,'Syntax: .itemmove #sourceslotid #destinationslotid\r\n\r\nMove an item from slots #sourceslotid to #destinationslotid in your inventory\r\n\r\nNot yet implemented'),
('kick',2,'Syntax: .kick [$charactername]\r\n\r\nKick the given character name from the world. If no character name is provided then the selected player (except for yourself) will be kicked.'),
('learn',3,'Syntax: .learn #parameter\r\n\r\nSelected character learn a spell of id #parameter.'),
('learn all',3,'Syntax: .learn all\r\n\r\nLearn all big set different spell maybe useful for Administaror.'),
('learn all_crafts',2,'Syntax: .learn crafts\r\n\r\nLearn all professions and recipes.'),
('learn all_gm',2,'Syntax: .learn all_gm\r\n\r\nLearn all default spells for Game Masters.'),
('learn all_lang',1,'Syntax: .learn all_lang\r\n\r\nLearn all languages'),
('learn all_myclass',3,'Syntax: .learn all_myclass\r\n\r\nLearn all spells and talents available for his class.'),
('learn all_myspells',3,'Syntax: .learn all_myspells\r\n\r\nLearn all spells (except talents and spells with first rank learned as talent) available for his class.'),
('learn all_mytalents',3,'Syntax: .learn all_mytalents\r\n\r\nLearn all talents (and spells with first rank learned as talent) available for his class.'),
('setskill',3,'Syntax: .setskill #skill #level [#max]\r\n\r\nSet a skill of id #skill with a current skill value of #level and a maximum value of #max (or equal current maximum if not provide) for the selected character. If no character is selected, you learn the skill.'),
('levelup',3,'Syntax: .levelup [$playername] [#numberoflevels]\r\n\r\nIncrease/decrease the level of character with $playername (or the selected if not name provided) by #numberoflevels Or +1 if no #numberoflevels provided). If #numberoflevels is omitted, the level will be increase by 1. If #numberoflevels is 0, the same level will be restarted. If no character is selected and name not provided, increase your level. Command can be used for offline character. All stats and dependent values recalculated. At level decrease talents can be reset if need. Also at level decrease equipped items with greater level requirement can be lost.'),
('linkgrave',3,'Syntax: .linkgrave #graveyard_id [alliance|horde]\r\n\r\nLink current zone to graveyard for any (or alliance/horde faction ghosts). This let character ghost from zone teleport to graveyard after die if graveyard is nearest from linked to zone and accept ghost of this faction. Add only single graveyard at another map and only if no graveyards linked (or planned linked at same map).'),
('listcreature',3,'Syntax: .listcreature #creature_id [#max_count]\r\n\r\nOutput creatures with creature id #creature_id found in world. Output creature guids and coordinates sorted by distance from character. Will be output maximum #max_count creatures. If #max_count not provided use 10 as default value.'),
('listgm',0,'Syntax: .listgm\r\n\r\nDisplay a list of available Game Masters.'),
('listitem',3,'Syntax: .listitem #item_id [#max_count]\r\n\r\nOutput items with item id #item_id found in all character inventories, mails and auctions. Output item guids, item owner guid, owner account and owner name. Will be output maximum #max_count items. If #max_count not provided use 10 as default value.'),
('listobject',3,'Syntax: .listobject #gameobject_id [#max_count]\r\n\r\nOutput gameobjects with gameobject id #gameobject_id found in world. Output gameobject guids and coordinates sorted by distance from character. Will be output maximum #max_count gameobject. If #max_count not provided use 10 as default value.'),
('loadscripts',3,'Syntax: .loadscripts $scriptlibraryname\r\n\r\nUnload current and load the script library $scriptlibraryname or reload current if $scriptlibraryname omitted, in case you changed it while the server was running.'),
('lockaccount',0,'Syntax: .lockaccount [on|off]\r\n\r\nAllow login from account only from current used IP or remove this requirement.'),
('lookupitem',3,'Syntax: .lookupitem $itemname\r\n\r\nLooks up an item by $itemname, and returns all matches with their Item ID\'s.'),
('lookupitemset',3,'Syntax: .lookupitemset $itemname\r\n\r\nLooks up an item set by $itemname, and returns all matches with their Item set ID\'s.'),
('lookupcreature',3,'Syntax: .lookupcreature $namepart\r\n\r\nLooks up a creature by $namepart, and returns all matches with their creature ID\'s.'),
('lookupobject',3,'Syntax: .lookupobject $objname\r\n\r\nLooks up an gameobject by $objname, and returns all matches with their Gameobject ID\'s.'),
('lookupquest',3,'Syntax: .lookupquest $namepart\r\n\r\nLooks up a quest by $namepart, and returns all matches with their quest ID\'s.'),
('lookupskill',3,'Syntax: .lookupskill $$namepart\r\n\r\nLooks up a skill by $namepart, and returns all matches with their skill ID\'s.'),
('lookupspell',3,'Syntax: .lookupspell $namepart\r\n\r\nLooks up a spell by $namepart, and returns all matches with their spell ID\'s.'),
('lookuptele',1,'Syntax: .lookuptele $substring\r\n\r\nSearch and output all .tele command locations with provide $substring in name.'),
('maxskill',3,'Syntax: .maxskill\r\nSets all skills of the targeted player to their maximum values for its current level.'),
('Mod32Value',3,'Syntax: .Mod32Value #field #value\r\n\r\nAdd #value to field #field of your character.'),
('modify',1,'Syntax: .modify $parameter $value\r\n\r\nModify the value of various parameters. Use .help modify $parameter to get help on specific parameter usage.\r\n\r\nSupported parameters include hp, mana, rage, energy, money, speed, swim, scale, bit, bwalk, aspeed, faction, spell, tp and honor.'),
('modify aspeed',1,'Syntax: .modify aspeed #rate\r\n\r\nModify all speeds -run,swim,run back,swim back- of the selected player to \"normalbase speed for this move type\"*rate. If no player is selected, modify your speed.\r\n\r\n #rate may range from 0.1 to 10.'),
('modify bit',1,'Syntax: .modify bit #field #bit\r\n\r\nToggle the #bit bit of the #field field for the selected player. If no player is selected, modify your character.'),
('modify bwalk',1,'Syntax: .modify bwalk #rate\r\n\r\nModify the speed of the selected player while running backwards to \"normal walk back speed\"*rate. If no player is selected, modify your speed.\r\n\r\n #rate may range from 0.1 to 10.'),
('modify energy',1,'Syntax: .modify energy #energy\r\n\r\nModify the energy of the selected player. If no player is selected, modify your energy.'),
('modify faction',1,'Syntax: .modify faction #factionid #flagid #npcflagid #dynamicflagid\r\n\r\nModify the faction and flags of the selected creature. Without arguments, display the faction and flags of the selected creature.'),
('modify money',1,'Syntax:\r\n.modify money #money\r\n.money #money\r\n\r\nAdd or remove money to the selected player. If no player is selected, modify your money.\r\n\r\n #gold can be negative to remove money.'),
('modify mount',1,'Syntax:\r\n.modify mount #id #speed\r\nDisplay selected player as mounted at #id creature and set speed to #speed value.'),
('modify hp',1,'Syntax: .modify hp #newhp\r\n\r\nModify the hp of the selected player. If no player is selected, modify your hp.'),
('modify mana',1,'Syntax: .modify mana #newmana\r\n\r\nModify the mana of the selected player. If no player is selected, modify your mana.'),
('modify rage',1,'Syntax: .modify rage #newrage\r\n\r\nModify the rage of the selected player. If no player is selected, modify your rage.'),
('modify scale',1,''),
('modify speed',1,'Syntax:\r\n.modify speed #rate\r\n.speed #rate\r\n\r\nModify the running speed of the selected player to \"normal base run speed\"*rate. If no player is selected, modify your speed.\r\n\r\n #rate may range from 0.1 to 10.'),
('modify spell',1,''),
('modify swim',1,'Syntax: .modify swim #rate\r\n\r\nModify the swim speed of the selected player to \"normal swim speed\"*rate. If no player is selected, modify your speed.\r\n\r\n #rate may range from 0.1 to 10.'),
('modify titles',1,'Syntax:\n.modify titles #mask\n.titles #mask\n\nAllows user to use all titles from #mask.\n\n #mask=0 disables the title-choose-field'),
('modify honor',1,'Syntax: .modify honor $amount\r\n\r\nAdded $amount to the selected player\'s total honor points.'),
('money',1,'Syntax:\r\n.modify money #money\r\n.money #money\r\n\r\nAdd or remove money to the selected player. If no player is selected, modify your money.\r\n\r\n #gold can be negative to remove money.'),
('morph',2,'Syntax: .morph #displayid\r\n\r\nChange your current model id to #displayid.'),
('movecreature',2,'Syntax: .movecreature [#creature_guid]\r\n\r\nMove the targeted creature spawn point to your coordinates.'),
('moveobject',2,'Syntax: .moveobject #goguid [#x #y #z]\r\n\r\nMove gameobject #goguid to character coordinates (or to (#x,#y,#z) coordinates if its provide).'),
('mute',1,'Syntax: .mute $playerName $timeInMinutes\r\n\r\nDisible chat messaging for any character from account of character $playerName at $timeInMinutes minutes.'),
('unmute',1,'Syntax: .unmute $playerName\r\n\r\nRestore chat messaging for any character from account of character $playerName.'),
('name',2,'Syntax: .name $name\r\n\r\nChange the name of the selected creature or character to $name.\r\n\r\nCommand disabled.'),
('namego',1,'Syntax: .namego $charactername\r\n\r\nTeleport the given character to you.'),
('nametele',1,'Syntax: .nametele #playername #location\r\n\r\nTeleport a player to a given location.'),
('neargrave',3,'Syntax: .neargrave [alliance|horde]\r\n\r\nFind nearest graveyard linked to zone (or only nearest from accepts alliance or horde faction ghosts).'),
('npcflag',2,'Syntax: .npcflag #npcflag\r\n\r\nSet the NPC flags of creature template of the selected creature and selected creature to #npcflag. NPC flags will applied to all creatures of selected creature template after server restart or grid unload/load.'),
('npcinfo',3,'Syntax: .npcinfo\r\n\r\nDisplay a list of details for the selected creature.\r\n\r\nThe list includes:\r\n- GUID, Faction, NPC flags, Entry ID, Model ID,\r\n- Level,\r\n- Health (current/maximum),\n\r\n- Field flags, dynamic flags, faction template, \r\n- Position information,\r\n- and the creature type, e.g. if the creature is a vendor.'),
('npcinfoset',3,'Syntax: .npcinfoset\r\n\r\nTODO: Write me.'),
('password',0,'Syntax: .password $old_password $new_password $new_password\r\n\r\nChange your account password.'),
('pinfo',2,'Syntax: .pinfo [$player_name] [rep]\r\n\r\nOutput account information for selected player or player find by $player_name. If \"rep\" parameter provided show reputation information for player.'),
('playsound',1,'Syntax: .playsound #soundid\r\n\r\nPlay sound with #soundid.\r\nSound will be play only for you. Other players do not hear this.\r\nWarning: client may have more 5000 sounds...'),
('recall',1,'Syntax: .recall [$playername]\r\n\r\nTeleport $playername or selected player to the place where he has been before last use of a teleportation command. If no $playername is entered and no player is selected, it will teleport you.'),
('reload',3,'Syntax: .reload table_name\r\n\r\nReload table `table_name` if reload support added for this table and this table can be _safe_ reloaded.'),
('reload all',3,'Syntax: .reload all\r\n\r\nReload all tables with reload support added and that can be _safe_ reloaded.'),
('reload all_area',3,'Syntax: .reload all_area\r\n\r\nReload all `areatrigger_*` tables if reload support added for this table and this table can be _safe_ reloaded.'),
('reload all_loot',3,'Syntax: .reload all_loot\r\n\r\nReload all `*_loot_template` tables. This can be slow operation with lags for server run.'),
('reload all_quest',3,'Syntax: .reload all_quest\r\n\r\nReload all quest related tables if reload support added for this table and this table can be _safe_ reloaded.'),
('reload all_spell',3,'Syntax: .reload all\r\n\r\nReload all `spell_*` tables with reload support added and that can be _safe_ reloaded.'),
('removequest',3,'Syntax: .removequest #quest_id\r\n\r\nSet quest #quest_id state to not completed and not active (and remove from active quest list) for selected player.'),
('reset honor',3,'Syntax:\r\n.reset honor [Playername]\r\n Reset all honor data for targeted character.'),
('reset level',3,'Syntax:\r\n.reset level [Playername]\r\n Reset level to 1 including reset stats and talents. Equipped items with greater level requirement can be lost.'),
('reset spells',3,'Syntax:\r\n.reset spells [Playername]\r\n Removes all non-original spells from spellbook.\r\n. Playername can be name of offline character.'),
('reset stats',3,'Syntax:\r\n.reset stats [Playername]\r\n Resets(recalculate) all stats of the targeted player to their original values at current level.'),
('reset talents',3,'Syntax:\r\n.reset talents [Playername]\r\n Removes all talents of the targeted player. Playername can be name of offline character.'),
('resetall',3,'Syntax: .resetall spells\r\n\r\nSyntax: .resetall talents\r\n\r\nRequest reset spells or talents at next login each existed character.'),
('respawn',3,'Syntax: .respawn\r\n\r\nRespawn all nearest creatures and GO without waiting respawn time expiration.'),
('revive',3,'Syntax: .revive\r\n\r\nRevive the selected player. If no player is selected, it will revive you.'),
('save',0,'Syntax: .save\r\n\r\nSaves your character.'),
('saveall',1,'Syntax: .saveall\r\n\r\nSave all characters in game.'),
('security',3,'Syntax: .security $name #level\r\n\r\nSet the security level of player $name to a level of #level.\r\n\r\n#level may range from 0 to 5.'),
('sendmail',1,'Syntax: .sendmail #playername #subject #text\r\n\r\nSend a mail to a player. Note: subject may not contain spaces.'),
('setmovetype',2,'Syntax: .setmovetype [#creature_guid] stay/random/way [NODEL]\r\n\r\nSet for creature pointed by #creature_guid (or selected if #creature_guid not provided) movement type and move it to respawn position (if creature alive). Any existing waypoints for creature will be removed from the database if you do not use NODEL. If the creature is dead then movement type will applied at creature respawn.\r\nMake sure you use NODEL, if you want to keep the waypoints.'),
('setvalue',3,'Syntax: .setvalue #field #value #isInt\r\n\r\nSet the field #field of the selected creature with value #value. If no creature is selected, set the content of your field.\r\n\r\nUse a #isInt of value 1 if #value is an integer.'),
('showarea',3,'Syntax: .showarea #areaid\r\n\r\nReveal the area of #areaid to the selected character. If no character is selected, reveal this area to you.'),
('showhonor',0,'Syntax: .showhonor\r\n\r\nDisplay your honor ranking.'),
('shutdown',3,'Syntax: .shutdown seconds'),
('speed',1,'Syntax:\r\n.modify speed #rate\r\n.speed #rate\r\n\r\nModify the running speed of the selected player to \"normal base run speed\"*rate. If no player is selected, modify your speed.\r\n\r\n #rate may range from 0.1 to 10.'),
('standstate',2,'Syntax: .standstate #emoteid\r\n\r\nChange the emote of your character while standing to #emoteid.'),
('start',0,'Syntax: .start\r\n\r\nTeleport you to the starting area of your character.'),
('subname',2,'Syntax: .subname $Name\r\n\r\nChange the subname of the selected creature or player to $Name.\r\n\r\nCommand disabled.'),
('targetobject',2,'Syntax: .targetobject [#go_id|#go_name_part]\r\n\r\nLocate and show position nearest gameobject. If #go_id or #go_name_part provide then locate and show position of nearest gameobject with gameobject template id #go_id or name included #go_name_part as part.'),
('taxicheat',1,'Syntax: .taxicheat on/off\r\n\r\nTemporary grant access or remove to all taxi routes for the selected character. If no character is selected, hide or reveal all routes to you.\r\n\r\nVisited taxi nodes sill accessible after removing access.'),
('ticket',2,'Syntax: .ticket on\r\n .ticket off\r\n .ticket #num\r\n .ticket $character_name\r\n\r\non/off for GMs to show or not a new ticket directly, $character_name to show ticket of this character, #num to show ticket #num.'),
('transport',3,'Not yet implemented.'),
('turnobject',2,'Syntax: .turnobject #goguid \r\n\r\nSet for gameobject #goguid orientation same as current character orientation.'),
('unaura',3,'Syntax: .unaura #spellid\r\n\r\nRemove aura due to spell #spellid from the selected Unit.'),
('baninfo',3,'Syntax is: baninfo <account|ip|character>\r\nWatch full information about a specific ban.'),
('banlist',3,'Syntax is: banlist <account|ip|character> $NameOrIp\r\nsearches the banlist for a pattern.'),
('unlearn',3,'Syntax: .unlearn #startspell #endspell\r\n\r\nUnlearn for selected player the range of spells between id #startspell and #endspell. If no #endspell is provided, just unlearn spell of id #startspell.'),
('update',3,'Syntax: .update #field #value\r\n\r\nUpdate the field #field of the selected character or creature with value #value.\r\n\r\nIf no #value is provided, display the content of field #field.'),
('visible',1,'Syntax: .visible on/off\r\n\r\nOutput current visibility state or make GM visible(on) and invisible(off) for other players.'),
('wchange',3,'Syntax: .wchange #weathertype #status\r\n\r\nSet current weather to #weathertype with an intensity of #status.\r\n\r\n#weathertype can be 1 for rain, 2 for snow, and 3 for sand. #status can be 0 for disabled, and 1 for enabled.'),
('whispers',1,'Syntax: .whispers on|off\r\nEnable/disable accepting whispers by GM from players. By default use mangosd.conf setting.'),
('spawndist',2,'Syntax: .spawndist #dist\r\n\r\nAdjust spawndistance of selected creature to dist.'),
('spawntime',2,'Syntax: .spawntime #time \r\n\r\nAdjust spawntime of selected creature to time.'),
('titles',1,'Syntax:\n.modify titles #mask\n.titles #mask\n\nAllows user to use all titles from #mask.\n\n #mask=0 disables the title-choose-field'),
('wp',2,'Using WP Command:\r\nEach Waypoint Command has it\'s own description!'),
('wp add',2,'Syntax: .wp add [#creature_guid or Select a Creature]'),
('wp modify',2,'Syntax: .wp modify [#creature_guid or Select a Creature]\r\nadd - Add a waypoint after the selected visual\r\nimport $filename for selected npc\r\nexport $filename for selected npc\r\nwaittime $time\r\nemote ID\r\nspell ID\r\ntext1| text2| text3| text4| text5 <text>\r\nmodel1 ID\r\nmodel2 ID\r\naiscript $Name\r\nmove(moves wp to player pos)\r\ndel (deletes the wp)\r\n\r\nOnly one parameter per time!'),
('wp show',2,'Syntax: .wp show [#creature_guid or Select a Creature]\r\non\r\nfirst\r\nlast\r\noff\r\ninfo\r\n\r\nFor using info you have to do first show on and than select a Visual-Waypoint and do the show info!'),
('npcwhisper', '1', 'Syntax: .npcwhisper #playerguid #text\r\nMake the selected npc whisper #text to #playerguid.');
/*!40000 ALTER TABLE `command` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `corpse`
--
DROP TABLE IF EXISTS `corpse`;
CREATE TABLE `corpse` (
`guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
`player` int(11) unsigned NOT NULL default '0' COMMENT 'Character Global Unique Identifier',
`position_x` float NOT NULL default '0',
`position_y` float NOT NULL default '0',
`position_z` float NOT NULL default '0',
`orientation` float NOT NULL default '0',
`zone` int(11) unsigned NOT NULL default '38' COMMENT 'Zone Identifier',
`map` int(11) unsigned NOT NULL default '0' COMMENT 'Map Identifier',
`data` longtext,
`time` timestamp NOT NULL default '0000-00-00 00:00:00',
`bones_flag` tinyint(3) NOT NULL default '0',
`instance` int(11) unsigned NOT NULL default '0',
PRIMARY KEY (`guid`),
KEY `idx_bones_flag` (`bones_flag`),
KEY `instance` (`instance`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Death System';
--
-- Dumping data for table `corpse`
--
LOCK TABLES `corpse` WRITE;
/*!40000 ALTER TABLE `corpse` DISABLE KEYS */;
/*!40000 ALTER TABLE `corpse` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `creature`
--
DROP TABLE IF EXISTS `creature`;
CREATE TABLE `creature` (
`guid` int(11) unsigned NOT NULL auto_increment COMMENT 'Global Unique Identifier',
`id` int(11) unsigned NOT NULL default '0' COMMENT 'Creature Identifier',
`map` int(11) unsigned NOT NULL default '0' COMMENT 'Map Identifier',
`position_x` float NOT NULL default '0',
`position_y` float NOT NULL default '0',
`position_z` float NOT NULL default '0',
`orientation` float NOT NULL default '0',
`spawntimesecs` int(11) unsigned NOT NULL default '120',
`spawndist` float NOT NULL default '5',
`currentwaypoint` int(11) unsigned NOT NULL default '0',
`spawn_position_x` float NOT NULL default '0',
`spawn_position_y` float NOT NULL default '0',
`spawn_position_z` float NOT NULL default '0',
`spawn_orientation` float NOT NULL default '0',
`curhealth` int(11) unsigned NOT NULL default '1',
`curmana` int(11) unsigned NOT NULL default '0',
`DeathState` tinyint(3) unsigned NOT NULL default '0',
`MovementType` tinyint(3) unsigned NOT NULL default '0',
`auras` longtext,
PRIMARY KEY (`guid`),
KEY `idx_map` (`map`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Creature System';
--
-- Dumping data for table `creature`
--
LOCK TABLES `creature` WRITE;
/*!40000 ALTER TABLE `creature` DISABLE KEYS */;
/*!40000 ALTER TABLE `creature` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `creature_addon`
--
DROP TABLE IF EXISTS `creature_addon`;
CREATE TABLE `creature_addon` (
`guid` int(11) NOT NULL default '0',
`RefId` int(11) NOT NULL default '0',
`mount` int(11) unsigned NOT NULL default '0',
`bytes0` int(11) unsigned NOT NULL default '0',
`bytes1` int(11) unsigned NOT NULL default '0',
`bytes2` int(11) unsigned NOT NULL default '0',
`emote` int(11) unsigned NOT NULL default '0',
`aura` int(11) unsigned NOT NULL default '0',
`auraflags` int(11) unsigned NOT NULL default '0',
`auralevels` int(11) unsigned NOT NULL default '0',
`auraapplications` int(11) unsigned NOT NULL default '0',
`aurastate` int(11) unsigned NOT NULL default '0',
UNIQUE KEY `guid` (`guid`),
KEY `emote` (`emote`,`RefId`,`mount`,`aura`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `creature_addon`
--
LOCK TABLES `creature_addon` WRITE;
/*!40000 ALTER TABLE `creature_addon` DISABLE KEYS */;
/*!40000 ALTER TABLE `creature_addon` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `creature_involvedrelation`
--
DROP TABLE IF EXISTS `creature_involvedrelation`;
CREATE TABLE `creature_involvedrelation` (
`id` int(11) unsigned NOT NULL default '0' COMMENT 'Identifier',
`quest` int(11) unsigned NOT NULL default '0' COMMENT 'Quest Identifier',
PRIMARY KEY (`id`,`quest`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Creature System';
--
-- Dumping data for table `creature_involvedrelation`
--
LOCK TABLES `creature_involvedrelation` WRITE;
/*!40000 ALTER TABLE `creature_involvedrelation` DISABLE KEYS */;
/*!40000 ALTER TABLE `creature_involvedrelation` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `creature_loot_template`
--
DROP TABLE IF EXISTS `creature_loot_template`;
CREATE TABLE `creature_loot_template` (
`entry` int(11) unsigned NOT NULL default '0',
`item` int(11) unsigned NOT NULL default '0',
`ChanceOrRef` float NOT NULL default '100',
`QuestChanceOrGroup` tinyint(3) NOT NULL default '0',
`mincount` tinyint(3) unsigned NOT NULL default '1',
`maxcount` tinyint(3) unsigned NOT NULL default '1',
`quest_freeforall` tinyint(3) unsigned NOT NULL default '1',
PRIMARY KEY (`entry`,`item`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Loot System';
--
-- Dumping data for table `creature_loot_template`
--
LOCK TABLES `creature_loot_template` WRITE;
/*!40000 ALTER TABLE `creature_loot_template` DISABLE KEYS */;
/*!40000 ALTER TABLE `creature_loot_template` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `creature_movement`
--
DROP TABLE IF EXISTS `creature_movement`;
CREATE TABLE `creature_movement` (
`id` int(11) unsigned NOT NULL default '0' COMMENT 'Identifier',
`point` int(11) unsigned NOT NULL default '0',
`position_x` float NOT NULL default '0',
`position_y` float NOT NULL default '0',
`position_z` float NOT NULL default '0',
`waittime` int(5) unsigned NOT NULL default '0',
`text1` varchar(255) default NULL,
`text2` varchar(255) default NULL,
`text3` varchar(255) default NULL,
`text4` varchar(255) default NULL,
`text5` varchar(255) default NULL,
`aiscript` varchar(255) default NULL,
`emote` int(10) unsigned default '0',
`spell` int(5) unsigned default '0',
`wpguid` int(11) default '0',
`orientation` float default '0',
`model1` int(11) default '0',
`model2` int(11) default '0',
PRIMARY KEY (`id`,`point`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Creature System';
--
-- Dumping data for table `creature_movement`
--
LOCK TABLES `creature_movement` WRITE;
/*!40000 ALTER TABLE `creature_movement` DISABLE KEYS */;
/*!40000 ALTER TABLE `creature_movement` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `creature_onkill_reputation`
--
DROP TABLE IF EXISTS `creature_onkill_reputation`;
CREATE TABLE `creature_onkill_reputation` (
`creature_id` int(10) unsigned NOT NULL default '0' COMMENT 'Creature Identifier',
`RewOnKillRepFaction1` int(10) default '0',
`RewOnKillRepFaction2` int(10) default '0',
`MaxStanding1` tinyint(1) default '0',
`IsTeamAward1` tinyint(1) default '0',
`RewOnKillRepValue1` int(10) default '0',
`MaxStanding2` tinyint(1) default '0',
`IsTeamAward2` tinyint(1) default '0',
`RewOnKillRepValue2` int(10) default '0',
`TeamDependent` tinyint(1) unsigned NOT NULL default '0',
PRIMARY KEY (`creature_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Creature OnKill Reputation gain';
--
-- Dumping data for table `creature_onkill_reputation`
--
LOCK TABLES `creature_onkill_reputation` WRITE;
/*!40000 ALTER TABLE `creature_onkill_reputation` DISABLE KEYS */;
/*!40000 ALTER TABLE `creature_onkill_reputation` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `creature_questrelation`
--
DROP TABLE IF EXISTS `creature_questrelation`;
CREATE TABLE `creature_questrelation` (
`id` int(11) unsigned NOT NULL default '0' COMMENT 'Identifier',
`quest` int(11) unsigned NOT NULL default '0' COMMENT 'Quest Identifier',
PRIMARY KEY (`id`,`quest`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Creature System';
--
-- Dumping data for table `creature_questrelation`
--
LOCK TABLES `creature_questrelation` WRITE;
/*!40000 ALTER TABLE `creature_questrelation` DISABLE KEYS */;
/*!40000 ALTER TABLE `creature_questrelation` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `creature_respawn`
--
DROP TABLE IF EXISTS `creature_respawn`;
CREATE TABLE `creature_respawn` (
`guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
`respawntime` bigint(40) NOT NULL default '0',
`instance` int(11) unsigned NOT NULL default '0',
PRIMARY KEY (`guid`,`instance`),
KEY `instance` (`instance`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Grid Loading System';
--
-- Dumping data for table `creature_respawn`
--
LOCK TABLES `creature_respawn` WRITE;
/*!40000 ALTER TABLE `creature_respawn` DISABLE KEYS */;
/*!40000 ALTER TABLE `creature_respawn` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `creature_template`
--
DROP TABLE IF EXISTS `creature_template`;
CREATE TABLE `creature_template` (
`entry` int(11) unsigned NOT NULL default '0',
`modelid_m` int(11) unsigned default '0',
`modelid_f` int(11) unsigned default '0',
`name` varchar(100) NOT NULL default '0',
`subname` varchar(100) default NULL,
`minlevel` tinyint(3) unsigned default '1',
`maxlevel` tinyint(3) unsigned default '1',
`minhealth` int(5) unsigned default '0',
`maxhealth` int(5) unsigned default '0',
`minmana` int(5) unsigned default '0',
`maxmana` int(5) unsigned default '0',
`armor` int(10) unsigned NOT NULL default '0',
`faction` int(4) unsigned default '0',
`npcflag` int(4) unsigned default '0',
`speed` float default '0',
`rank` tinyint(3) unsigned default '0',
`mindmg` float default '0',
`maxdmg` float default '0',
`dmgschool` tinyint(1) not NULL default 0,
`attackpower` int(10) unsigned NOT NULL default '0',
`baseattacktime` int(4) unsigned default '0',
`rangeattacktime` int(4) unsigned default '0',
`flags` int(11) unsigned default '0',
`dynamicflags` int(11) unsigned default '0',
`size` float default '0',
`family` int(11) default '0',
`bounding_radius` float default '0',
`trainer_type` tinyint(3) default '0',
`trainer_spell` int(11) unsigned default '0',
`class` tinyint(3) unsigned default '0',
`race` tinyint(3) unsigned default '0',
`minrangedmg` float NOT NULL default '0',
`maxrangedmg` float NOT NULL default '0',
`rangedattackpower` smallint(5) unsigned NOT NULL default '0',
`combat_reach` float NOT NULL default '0',
`type` tinyint(3) unsigned default '0',
`civilian` tinyint(3) unsigned NOT NULL default '0',
`flag1` int(11) unsigned default '0',
`equipmodel1` int(10) unsigned NOT NULL default '0',
`equipmodel2` int(10) unsigned NOT NULL default '0',
`equipmodel3` int(10) unsigned NOT NULL default '0',
`equipinfo1` int(10) unsigned NOT NULL default '0',
`equipinfo2` int(10) unsigned NOT NULL default '0',
`equipinfo3` int(10) unsigned NOT NULL default '0',
`equipslot1` int(11) NOT NULL default '0',
`equipslot2` int(11) NOT NULL default '0',
`equipslot3` int(11) NOT NULL default '0',
`lootid` int(10) unsigned NOT NULL default '0',
`pickpocketloot` int(10) unsigned NOT NULL default '0',
`skinloot` int(10) unsigned NOT NULL default '0',
`resistance1` int(10) unsigned NOT NULL default '0',
`resistance2` int(10) unsigned NOT NULL default '0',
`resistance3` int(10) unsigned NOT NULL default '0',
`resistance4` int(10) unsigned NOT NULL default '0',
`resistance5` int(10) unsigned NOT NULL default '0',
`resistance6` int(10) unsigned NOT NULL default '0',
`spell1` int(11) unsigned NOT NULL default '0',
`spell2` int(11) unsigned NOT NULL default '0',
`spell3` int(11) unsigned NOT NULL default '0',
`spell4` int(11) unsigned NOT NULL default '0',
`mingold` int(30) unsigned NOT NULL default '0',
`maxgold` int(30) unsigned NOT NULL default '0',
`AIName` varchar(128) NOT NULL default '',
`MovementType` tinyint(3) unsigned NOT NULL default '0',
`InhabitType` tinyint(1) unsigned NOT NULL default '3',
`RacialLeader` tinyint(1) unsigned NOT NULL default '0',
`ScriptName` varchar(128) NOT NULL default '',
PRIMARY KEY (`entry`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Creature System';
--
-- Dumping data for table `creature_template`
--
LOCK TABLES `creature_template` WRITE;
/*!40000 ALTER TABLE `creature_template` DISABLE KEYS */;
INSERT INTO `creature_template` VALUES
(1,10045,0,'Waypoint (Only GM can see it)','Visual',1,1,64,64,0,0,0,35,0,0.91,0,14,15,0,100,2000,2200,4096,0,0.5,8,2,0,0,0,0,1.76,2.42,100,2.56,8,1,5242886,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,3,0,'');
/*!40000 ALTER TABLE `creature_template` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `disenchant_loot_template`
--
DROP TABLE IF EXISTS `disenchant_loot_template`;
CREATE TABLE `disenchant_loot_template` (
`entry` int(11) unsigned NOT NULL default '0' COMMENT 'Recommended id selection: item_level*100 + item_quality',
`item` int(11) unsigned NOT NULL default '0',
`ChanceOrRef` float NOT NULL default '100',
`QuestChanceOrGroup` tinyint(3) NOT NULL default '0',
`mincount` tinyint(3) unsigned NOT NULL default '1',
`maxcount` tinyint(3) unsigned NOT NULL default '1',
`quest_freeforall` tinyint(3) unsigned NOT NULL default '1',
PRIMARY KEY (`entry`,`item`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Loot System';
--
-- Dumping data for table `disenchant_loot_template`
--
LOCK TABLES `disenchant_loot_template` WRITE;
/*!40000 ALTER TABLE `disenchant_loot_template` DISABLE KEYS */;
/*!40000 ALTER TABLE `disenchant_loot_template` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `exploration_basexp`
--
DROP TABLE IF EXISTS `exploration_basexp`;
CREATE TABLE `exploration_basexp` (
`level` tinyint(2) NOT NULL default '0',
`basexp` int(11) NOT NULL default '0',
PRIMARY KEY (`level`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Exploration System';
--
-- Dumping data for table `exploration_basexp`
--
LOCK TABLES `exploration_basexp` WRITE;
/*!40000 ALTER TABLE `exploration_basexp` DISABLE KEYS */;
INSERT INTO `exploration_basexp` VALUES
(0,0),
(1,5),
(2,15),
(3,25),
(4,35),
(5,45),
(6,55),
(7,65),
(8,70),
(9,80),
(10,85),
(11,90),
(12,90),
(13,90),
(14,100),
(15,105),
(16,115),
(17,125),
(18,135),
(19,145),
(20,155),
(21,165),
(22,175),
(23,185),
(24,195),
(25,200),
(26,210),
(27,220),
(28,230),
(29,240),
(30,245),
(31,250),
(32,255),
(33,265),
(34,270),
(35,275),
(36,280),
(37,285),
(38,285),
(39,300),
(40,315),
(41,330),
(42,345),
(43,360),
(44,375),
(45,390),
(46,405),
(47,420),
(48,440),
(49,455),
(50,470),
(51,490),
(52,510),
(53,530),
(54,540),
(55,560),
(56,580),
(57,600),
(58,620),
(59,640),
(60,660),
(61,970),
(62,1000),
(63,1050),
(64,1080),
(65,1100),
(66,1130),
(67,1160),
(68,1200),
(69,1230),
(70,1250);
/*!40000 ALTER TABLE `exploration_basexp` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `fishing_loot_template`
--
DROP TABLE IF EXISTS `fishing_loot_template`;
CREATE TABLE `fishing_loot_template` (
`entry` int(11) unsigned NOT NULL default '0',
`item` int(11) unsigned NOT NULL default '0',
`ChanceOrRef` float NOT NULL default '100',
`QuestChanceOrGroup` tinyint(3) NOT NULL default '0',
`mincount` tinyint(3) unsigned NOT NULL default '1',
`maxcount` tinyint(3) unsigned NOT NULL default '1',
`quest_freeforall` tinyint(3) unsigned NOT NULL default '1',
PRIMARY KEY (`entry`,`item`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Loot System';
--
-- Dumping data for table `fishing_loot_template`
--
LOCK TABLES `fishing_loot_template` WRITE;
/*!40000 ALTER TABLE `fishing_loot_template` DISABLE KEYS */;
/*!40000 ALTER TABLE `fishing_loot_template` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `game_event`
--
DROP TABLE IF EXISTS `game_event`;
CREATE TABLE `game_event` (
`entry` mediumint(8) unsigned NOT NULL COMMENT 'Entry of the game event',
`start` timestamp NOT NULL default '0000-00-00 00:00:00' COMMENT 'Absolute start date, the event will never start before',
`end` timestamp NOT NULL default '0000-00-00 00:00:00' COMMENT 'Absolute end date, the event will never start afler',
`occurence` bigint(20) unsigned NOT NULL default '86400' COMMENT 'Delay in hours between occurences of the event',
`length` bigint(20) unsigned NOT NULL default '43200' COMMENT 'Length in hours of the event',
`description` varchar(255) default NULL COMMENT 'Description of the event displayed in console',
PRIMARY KEY (`entry`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `game_event`
--
LOCK TABLES `game_event` WRITE;
/*!40000 ALTER TABLE `game_event` DISABLE KEYS */;
/*!40000 ALTER TABLE `game_event` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `game_event_creature`
--
DROP TABLE IF EXISTS `game_event_creature`;
CREATE TABLE `game_event_creature` (
`guid` int(10) unsigned NOT NULL,
`event` mediumint(9) NOT NULL default '0' COMMENT 'Put negatives values to remove during event',
PRIMARY KEY (`guid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `game_event_creature`
--
LOCK TABLES `game_event_creature` WRITE;
/*!40000 ALTER TABLE `game_event_creature` DISABLE KEYS */;
/*!40000 ALTER TABLE `game_event_creature` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `game_event_gameobject`
--
DROP TABLE IF EXISTS `game_event_gameobject`;
CREATE TABLE `game_event_gameobject` (
`guid` int(10) unsigned NOT NULL,
`event` mediumint(9) NOT NULL default '0' COMMENT 'Put negatives values to remove during event',
PRIMARY KEY (`guid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `game_event_gameobject`
--
LOCK TABLES `game_event_gameobject` WRITE;
/*!40000 ALTER TABLE `game_event_gameobject` DISABLE KEYS */;
/*!40000 ALTER TABLE `game_event_gameobject` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `game_graveyard_zone`
--
DROP TABLE IF EXISTS `game_graveyard_zone`;
CREATE TABLE `game_graveyard_zone` (
`id` int(11) unsigned NOT NULL default '0',
`ghost_map` int(11) unsigned NOT NULL default '0',
`ghost_zone` int(11) unsigned NOT NULL default '0',
`faction` int(11) unsigned NOT NULL default '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Trigger System';
--
-- Dumping data for table `game_graveyard_zone`
--
LOCK TABLES `game_graveyard_zone` WRITE;
/*!40000 ALTER TABLE `game_graveyard_zone` DISABLE KEYS */;
/*!40000 ALTER TABLE `game_graveyard_zone` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `game_tele`
--
DROP TABLE IF EXISTS `game_tele`;
CREATE TABLE `game_tele` (
`id` int(11) unsigned NOT NULL auto_increment,
`position_x` float NOT NULL default '0',
`position_y` float NOT NULL default '0',
`position_z` float NOT NULL default '0',
`orientation` float NOT NULL default '0',
`map` int(11) unsigned NOT NULL default '0',
`name` varchar(100) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Tele Command';
--
-- Dumping data for table `game_tele`
--
LOCK TABLES `game_tele` WRITE;
/*!40000 ALTER TABLE `game_tele` DISABLE KEYS */;
/*!40000 ALTER TABLE `game_tele` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `game_weather`
--
DROP TABLE IF EXISTS `game_weather`;
CREATE TABLE `game_weather` (
`zone` int(11) unsigned NOT NULL default '0',
`spring_rain_chance` tinyint(3) unsigned NOT NULL default '25',
`spring_snow_chance` tinyint(3) unsigned NOT NULL default '25',
`spring_storm_chance` tinyint(3) unsigned NOT NULL default '25',
`summer_rain_chance` tinyint(3) unsigned NOT NULL default '25',
`summer_snow_chance` tinyint(3) unsigned NOT NULL default '25',
`summer_storm_chance` tinyint(3) unsigned NOT NULL default '25',
`fall_rain_chance` tinyint(3) unsigned NOT NULL default '25',
`fall_snow_chance` tinyint(3) unsigned NOT NULL default '25',
`fall_storm_chance` tinyint(3) unsigned NOT NULL default '25',
`winter_rain_chance` tinyint(3) unsigned NOT NULL default '25',
`winter_snow_chance` tinyint(3) unsigned NOT NULL default '25',
`winter_storm_chance` tinyint(3) unsigned NOT NULL default '25',
PRIMARY KEY (`zone`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Weather System';
--
-- Dumping data for table `game_weather`
--
LOCK TABLES `game_weather` WRITE;
/*!40000 ALTER TABLE `game_weather` DISABLE KEYS */;
/*!40000 ALTER TABLE `game_weather` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `gameobject`
--
DROP TABLE IF EXISTS `gameobject`;
CREATE TABLE `gameobject` (
`guid` int(11) unsigned NOT NULL auto_increment COMMENT 'Global Unique Identifier',
`id` int(11) unsigned NOT NULL default '0' COMMENT 'Gameobject Identifier',
`map` int(11) unsigned NOT NULL default '0' COMMENT 'Map Identifier',
`position_x` float NOT NULL default '0',
`position_y` float NOT NULL default '0',
`position_z` float NOT NULL default '0',
`orientation` float NOT NULL default '0',
`rotation0` float NOT NULL default '0',
`rotation1` float NOT NULL default '0',
`rotation2` float NOT NULL default '0',
`rotation3` float NOT NULL default '0',
`loot` int(11) unsigned NOT NULL default '0',
`spawntimesecs` int(11) unsigned NOT NULL default '0',
`animprogress` int(11) unsigned NOT NULL default '0',
`dynflags` int(11) unsigned NOT NULL default '0',
PRIMARY KEY (`guid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Gameobject System';
--
-- Dumping data for table `gameobject`
--
LOCK TABLES `gameobject` WRITE;
/*!40000 ALTER TABLE `gameobject` DISABLE KEYS */;
/*!40000 ALTER TABLE `gameobject` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `gameobject_involvedrelation`
--
DROP TABLE IF EXISTS `gameobject_involvedrelation`;
CREATE TABLE `gameobject_involvedrelation` (
`id` int(11) unsigned NOT NULL default '0',
`quest` int(11) unsigned NOT NULL default '0' COMMENT 'Quest Identifier',
PRIMARY KEY (`id`,`quest`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `gameobject_involvedrelation`
--
LOCK TABLES `gameobject_involvedrelation` WRITE;
/*!40000 ALTER TABLE `gameobject_involvedrelation` DISABLE KEYS */;
/*!40000 ALTER TABLE `gameobject_involvedrelation` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `gameobject_loot_template`
--
DROP TABLE IF EXISTS `gameobject_loot_template`;
CREATE TABLE `gameobject_loot_template` (
`entry` int(11) unsigned NOT NULL default '0',
`item` int(11) unsigned NOT NULL default '0',
`ChanceOrRef` float NOT NULL default '100',
`QuestChanceOrGroup` tinyint(3) NOT NULL default '0',
`mincount` tinyint(3) unsigned NOT NULL default '1',
`maxcount` tinyint(3) unsigned NOT NULL default '1',
`quest_freeforall` tinyint(3) unsigned NOT NULL default '1',
PRIMARY KEY (`entry`,`item`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Loot System';
--
-- Dumping data for table `gameobject_loot_template`
--
LOCK TABLES `gameobject_loot_template` WRITE;
/*!40000 ALTER TABLE `gameobject_loot_template` DISABLE KEYS */;
/*!40000 ALTER TABLE `gameobject_loot_template` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `gameobject_questrelation`
--
DROP TABLE IF EXISTS `gameobject_questrelation`;
CREATE TABLE `gameobject_questrelation` (
`id` int(11) unsigned NOT NULL default '0',
`quest` int(11) unsigned NOT NULL default '0' COMMENT 'Quest Identifier',
PRIMARY KEY (`id`,`quest`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `gameobject_questrelation`
--
LOCK TABLES `gameobject_questrelation` WRITE;
/*!40000 ALTER TABLE `gameobject_questrelation` DISABLE KEYS */;
/*!40000 ALTER TABLE `gameobject_questrelation` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `gameobject_respawn`
--
DROP TABLE IF EXISTS `gameobject_respawn`;
CREATE TABLE `gameobject_respawn` (
`guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
`respawntime` bigint(40) NOT NULL default '0',
`instance` int(11) unsigned NOT NULL default '0',
PRIMARY KEY (`guid`,`instance`),
KEY `instance` (`instance`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Grid Loading System';
--
-- Dumping data for table `gameobject_respawn`
--
LOCK TABLES `gameobject_respawn` WRITE;
/*!40000 ALTER TABLE `gameobject_respawn` DISABLE KEYS */;
/*!40000 ALTER TABLE `gameobject_respawn` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `gameobject_template`
--
DROP TABLE IF EXISTS `gameobject_template`;
CREATE TABLE `gameobject_template` (
`entry` int(20) unsigned NOT NULL default '0',
`type` int(11) unsigned NOT NULL default '0',
`displayId` int(11) unsigned NOT NULL default '0',
`name` varchar(100) NOT NULL default '0',
`faction` int(4) unsigned NOT NULL default '0',
`flags` int(4) unsigned NOT NULL default '0',
`size` float NOT NULL default '1',
`sound0` int(11) unsigned NOT NULL default '0',
`sound1` int(11) unsigned NOT NULL default '0',
`sound2` int(11) unsigned NOT NULL default '0',
`sound3` int(11) unsigned NOT NULL default '0',
`sound4` int(11) unsigned NOT NULL default '0',
`sound5` int(11) unsigned NOT NULL default '0',
`sound6` int(11) unsigned NOT NULL default '0',
`sound7` int(11) unsigned NOT NULL default '0',
`sound8` int(11) unsigned NOT NULL default '0',
`sound9` int(11) unsigned NOT NULL default '0',
`sound10` int(11) unsigned NOT NULL default '0',
`sound11` int(11) unsigned NOT NULL default '0',
`sound12` int(11) unsigned NOT NULL default '0',
`sound13` int(11) unsigned NOT NULL default '0',
`sound14` int(11) unsigned NOT NULL default '0',
`sound15` int(11) unsigned NOT NULL default '0',
`sound16` int(11) unsigned NOT NULL default '0',
`sound17` int(11) unsigned NOT NULL default '0',
`sound18` int(11) unsigned NOT NULL default '0',
`sound19` int(11) unsigned NOT NULL default '0',
`sound20` int(11) unsigned NOT NULL default '0',
`sound21` int(11) unsigned NOT NULL default '0',
`sound22` int(11) unsigned NOT NULL default '0',
`sound23` int(11) unsigned NOT NULL default '0',
`ScriptName` varchar(100) NOT NULL default '',
PRIMARY KEY (`entry`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Gameobject System';
--
-- Dumping data for table `gameobject_template`
--
LOCK TABLES `gameobject_template` WRITE;
/*!40000 ALTER TABLE `gameobject_template` DISABLE KEYS */;
/*!40000 ALTER TABLE `gameobject_template` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `group`
--
DROP TABLE IF EXISTS `group`;
CREATE TABLE `group` (
`leaderGuid` int(20) NOT NULL,
`mainTank` int(20) NOT NULL,
`mainAssistant` int(20) NOT NULL,
`lootMethod` tinyint(4) NOT NULL,
`looterGuid` int(20) NOT NULL,
`lootThreshold` tinyint(4) NOT NULL,
`icon1` bigint(20) NOT NULL,
`icon2` bigint(20) NOT NULL,
`icon3` bigint(20) NOT NULL,
`icon4` bigint(20) NOT NULL,
`icon5` bigint(20) NOT NULL,
`icon6` bigint(20) NOT NULL,
`icon7` bigint(20) NOT NULL,
`icon8` bigint(20) NOT NULL,
`isRaid` tinyint(1) NOT NULL,
PRIMARY KEY (`leaderGuid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Groups';
--
-- Dumping data for table `group`
--
LOCK TABLES `group` WRITE;
/*!40000 ALTER TABLE `group` DISABLE KEYS */;
/*!40000 ALTER TABLE `group` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `group_member`
--
DROP TABLE IF EXISTS `group_member`;
CREATE TABLE `group_member` (
`leaderGuid` int(20) NOT NULL,
`memberGuid` int(20) NOT NULL,
`assistant` tinyint(1) NOT NULL,
`subgroup` smallint(6) NOT NULL,
PRIMARY KEY (`leaderGuid`,`memberGuid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Groups';
--
-- Dumping data for table `group_member`
--
LOCK TABLES `group_member` WRITE;
/*!40000 ALTER TABLE `group_member` DISABLE KEYS */;
/*!40000 ALTER TABLE `group_member` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `guild`
--
DROP TABLE IF EXISTS `guild`;
CREATE TABLE `guild` (
`guildid` int(6) unsigned NOT NULL default '0',
`name` varchar(255) NOT NULL default '',
`leaderguid` int(6) unsigned NOT NULL default '0',
`EmblemStyle` int(5) NOT NULL default '0',
`EmblemColor` int(5) NOT NULL default '0',
`BorderStyle` int(5) NOT NULL default '0',
`BorderColor` int(5) NOT NULL default '0',
`BackgroundColor` int(5) NOT NULL default '0',
`info` text NOT NULL,
`MOTD` varchar(255) NOT NULL default '',
`createdate` datetime default NULL,
PRIMARY KEY (`guildid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Guild System';
--
-- Dumping data for table `guild`
--
LOCK TABLES `guild` WRITE;
/*!40000 ALTER TABLE `guild` DISABLE KEYS */;
/*!40000 ALTER TABLE `guild` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `guild_member`
--
DROP TABLE IF EXISTS `guild_member`;
CREATE TABLE `guild_member` (
`guildid` int(6) unsigned NOT NULL default '0',
`guid` int(6) NOT NULL default '0',
`rank` tinyint(2) unsigned NOT NULL default '0',
`Pnote` varchar(255) NOT NULL default '',
`OFFnote` varchar(255) NOT NULL default ''
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Guild System';
--
-- Dumping data for table `guild_member`
--
LOCK TABLES `guild_member` WRITE;
/*!40000 ALTER TABLE `guild_member` DISABLE KEYS */;
/*!40000 ALTER TABLE `guild_member` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `guild_rank`
--
DROP TABLE IF EXISTS `guild_rank`;
CREATE TABLE `guild_rank` (
`guildid` int(6) unsigned NOT NULL default '0',
`rid` int(11) unsigned NOT NULL,
`rname` varchar(255) NOT NULL default '',
`rights` int(3) unsigned NOT NULL default '0',
PRIMARY KEY (`guildid`,`rid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Guild System';
--
-- Dumping data for table `guild_rank`
--
LOCK TABLES `guild_rank` WRITE;
/*!40000 ALTER TABLE `guild_rank` DISABLE KEYS */;
/*!40000 ALTER TABLE `guild_rank` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `instance`
--
DROP TABLE IF EXISTS `instance`;
CREATE TABLE `instance` (
`id` int(11) unsigned NOT NULL default '0',
`map` int(11) unsigned NOT NULL default '0',
`resettime` bigint(40) NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `map` (`map`),
KEY `resettime` (`resettime`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Dumping data for table `instance`
--
LOCK TABLES `instance` WRITE;
/*!40000 ALTER TABLE `instance` DISABLE KEYS */;
/*!40000 ALTER TABLE `instance` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `instance_template`
--
DROP TABLE IF EXISTS `instance_template`;
CREATE TABLE `instance_template` (
`map` int(11) unsigned NOT NULL,
`levelMin` int(11) unsigned NOT NULL default '0',
`levelMax` int(11) unsigned NOT NULL default '0',
`maxPlayers` int(11) unsigned NOT NULL default '0',
`reset_delay` int(20) unsigned NOT NULL default '0',
`startLocX` float default NULL,
`startLocY` float default NULL,
`startLocZ` float default NULL,
`startLocO` float default NULL,
PRIMARY KEY (`map`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `instance_template`
--
LOCK TABLES `instance_template` WRITE;
/*!40000 ALTER TABLE `instance_template` DISABLE KEYS */;
INSERT INTO `instance_template` VALUES
(33,22,30,10,7200,NULL,NULL,NULL,NULL),
(34,24,32,10,7200,NULL,NULL,NULL,NULL),
(36,15,20,10,7200,NULL,NULL,NULL,NULL),
(43,15,21,10,7200,NULL,NULL,NULL,NULL),
(47,29,38,10,7200,NULL,NULL,NULL,NULL),
(48,24,32,10,7200,NULL,NULL,NULL,NULL),
(70,35,47,10,7200,NULL,NULL,NULL,NULL),
(90,29,38,10,7200,NULL,NULL,NULL,NULL),
(109,45,55,10,7200,NULL,NULL,NULL,NULL),
(129,37,46,10,7200,NULL,NULL,NULL,NULL),
(189,34,45,10,7200,NULL,NULL,NULL,NULL),
(209,44,54,10,7200,NULL,NULL,NULL,NULL),
(229,58,0,10,120000,78.5083,-225.044,49.839,5.1),
(230,52,0,5,7200,NULL,NULL,NULL,NULL),
(249,60,0,40,432000,NULL,NULL,NULL,NULL),
(289,57,0,5,7200,NULL,NULL,NULL,NULL),
(309,60,0,20,259200,NULL,NULL,NULL,NULL),
(329,58,60,5,7200,NULL,NULL,NULL,NULL),
(349,46,55,10,7200,NULL,NULL,NULL,NULL),
(389,13,18,10,7200,NULL,NULL,NULL,NULL),
(409,60,0,40,604800,NULL,NULL,NULL,NULL),
(429,55,60,5,7200,NULL,NULL,NULL,NULL),
(469,60,0,40,604800,NULL,NULL,NULL,NULL),
(509,60,0,20,259200,NULL,NULL,NULL,NULL),
(531,60,0,40,604800,NULL,NULL,NULL,NULL),
(533,60,0,40,604800,NULL,NULL,NULL,NULL);
/*!40000 ALTER TABLE `instance_template` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `item_enchantment_template`
--
DROP TABLE IF EXISTS `item_enchantment_template`;
CREATE TABLE `item_enchantment_template` (
`entry` int(11) unsigned NOT NULL default '0',
`ench` int(10) unsigned NOT NULL default '0',
`chance` float unsigned NOT NULL default '0',
PRIMARY KEY (`entry`,`ench`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Item Random Enchantment System';
--
-- Dumping data for table `item_enchantment_template`
--
LOCK TABLES `item_enchantment_template` WRITE;
/*!40000 ALTER TABLE `item_enchantment_template` DISABLE KEYS */;
/*!40000 ALTER TABLE `item_enchantment_template` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `item_instance`
--
DROP TABLE IF EXISTS `item_instance`;
CREATE TABLE `item_instance` (
`guid` int(11) unsigned NOT NULL default '0',
`owner_guid` int(11) unsigned NOT NULL default '0',
`data` longtext,
PRIMARY KEY (`guid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Item System';
--
-- Dumping data for table `item_instance`
--
LOCK TABLES `item_instance` WRITE;
/*!40000 ALTER TABLE `item_instance` DISABLE KEYS */;
/*!40000 ALTER TABLE `item_instance` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `item_loot_template`
--
DROP TABLE IF EXISTS `item_loot_template`;
CREATE TABLE `item_loot_template` (
`entry` int(11) unsigned NOT NULL default '0',
`item` int(11) unsigned NOT NULL default '0',
`ChanceOrRef` float NOT NULL default '100',
`QuestChanceOrGroup` tinyint(3) NOT NULL default '0',
`mincount` tinyint(3) unsigned NOT NULL default '1',
`maxcount` tinyint(3) unsigned NOT NULL default '1',
`quest_freeforall` tinyint(3) unsigned NOT NULL default '1',
PRIMARY KEY (`entry`,`item`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Loot System';
--
-- Dumping data for table `item_loot_template`
--
LOCK TABLES `item_loot_template` WRITE;
/*!40000 ALTER TABLE `item_loot_template` DISABLE KEYS */;
/*!40000 ALTER TABLE `item_loot_template` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `item_template`
--
DROP TABLE IF EXISTS `item_template`;
CREATE TABLE `item_template` (
`entry` int(255) unsigned NOT NULL default '0',
`class` tinyint(3) unsigned NOT NULL default '0',
`subclass` tinyint(3) unsigned NOT NULL default '0',
`unk0` int(10) NOT NULL default '-1',
`name` varchar(255) NOT NULL default '',
`displayid` int(11) unsigned NOT NULL default '0',
`Quality` tinyint(3) unsigned NOT NULL default '0',
`Flags` int(30) unsigned NOT NULL default '0',
`BuyCount` tinyint(3) unsigned NOT NULL default '1',
`BuyPrice` int(30) unsigned NOT NULL default '0',
`SellPrice` int(30) unsigned NOT NULL default '0',
`InventoryType` tinyint(3) unsigned NOT NULL default '0',
`AllowableClass` mediumint(9) NOT NULL default '0',
`AllowableRace` mediumint(9) NOT NULL default '0',
`ItemLevel` int(30) unsigned NOT NULL default '0',
`RequiredLevel` tinyint(3) unsigned NOT NULL default '0',
`RequiredSkill` int(30) unsigned NOT NULL default '0',
`RequiredSkillRank` int(30) unsigned NOT NULL default '0',
`requiredspell` int(30) unsigned NOT NULL default '0',
`requiredhonorrank` int(30) unsigned NOT NULL default '0',
`RequiredCityRank` int(30) unsigned NOT NULL default '0',
`RequiredReputationFaction` int(30) unsigned NOT NULL default '0',
`RequiredReputationRank` int(30) unsigned NOT NULL default '0',
`maxcount` smallint(5) unsigned NOT NULL default '0',
`stackable` smallint(5) unsigned NOT NULL default '0',
`ContainerSlots` tinyint(3) unsigned NOT NULL default '0',
`stat_type1` tinyint(4) unsigned NOT NULL default '0',
`stat_value1` smallint(6) NOT NULL default '0',
`stat_type2` tinyint(4) unsigned NOT NULL default '0',
`stat_value2` smallint(6) NOT NULL default '0',
`stat_type3` tinyint(4) unsigned NOT NULL default '0',
`stat_value3` smallint(6) NOT NULL default '0',
`stat_type4` tinyint(4) unsigned NOT NULL default '0',
`stat_value4` smallint(6) NOT NULL default '0',
`stat_type5` tinyint(4) unsigned NOT NULL default '0',
`stat_value5` smallint(6) NOT NULL default '0',
`stat_type6` tinyint(4) unsigned NOT NULL default '0',
`stat_value6` smallint(6) NOT NULL default '0',
`stat_type7` tinyint(4) unsigned NOT NULL default '0',
`stat_value7` smallint(6) NOT NULL default '0',
`stat_type8` tinyint(4) unsigned NOT NULL default '0',
`stat_value8` smallint(6) NOT NULL default '0',
`stat_type9` tinyint(4) unsigned NOT NULL default '0',
`stat_value9` smallint(6) NOT NULL default '0',
`stat_type10` tinyint(4) unsigned NOT NULL default '0',
`stat_value10` smallint(6) NOT NULL default '0',
`dmg_min1` float NOT NULL default '0',
`dmg_max1` float NOT NULL default '0',
`dmg_type1` tinyint(3) unsigned NOT NULL default '0',
`dmg_min2` float NOT NULL default '0',
`dmg_max2` float NOT NULL default '0',
`dmg_type2` tinyint(3) unsigned NOT NULL default '0',
`dmg_min3` float NOT NULL default '0',
`dmg_max3` float NOT NULL default '0',
`dmg_type3` tinyint(3) unsigned NOT NULL default '0',
`dmg_min4` float NOT NULL default '0',
`dmg_max4` float NOT NULL default '0',
`dmg_type4` tinyint(3) unsigned NOT NULL default '0',
`dmg_min5` float NOT NULL default '0',
`dmg_max5` float NOT NULL default '0',
`dmg_type5` tinyint(3) unsigned NOT NULL default '0',
`armor` int(30) unsigned NOT NULL default '0',
`holy_res` int(30) unsigned NOT NULL default '0',
`fire_res` int(30) unsigned NOT NULL default '0',
`nature_res` int(30) unsigned NOT NULL default '0',
`frost_res` int(30) unsigned NOT NULL default '0',
`shadow_res` int(30) unsigned NOT NULL default '0',
`arcane_res` int(30) unsigned NOT NULL default '0',
`delay` int(11) unsigned NOT NULL default '1000',
`ammo_type` int(30) unsigned NOT NULL default '0',
`RangedModRange` float NOT NULL default '0',
`spellid_1` int(30) unsigned NOT NULL default '0',
`spelltrigger_1` int(30) unsigned NOT NULL default '0',
`spellcharges_1` int(30) NOT NULL default '0',
`spellcooldown_1` int(30) NOT NULL default '-1',
`spellcategory_1` int(30) unsigned NOT NULL default '0',
`spellcategorycooldown_1` int(30) NOT NULL default '-1',
`spellid_2` int(30) unsigned NOT NULL default '0',
`spelltrigger_2` int(30) unsigned NOT NULL default '0',
`spellcharges_2` int(30) NOT NULL default '0',
`spellcooldown_2` int(30) NOT NULL default '-1',
`spellcategory_2` int(30) unsigned NOT NULL default '0',
`spellcategorycooldown_2` int(30) NOT NULL default '-1',
`spellid_3` int(30) unsigned NOT NULL default '0',
`spelltrigger_3` int(30) unsigned NOT NULL default '0',
`spellcharges_3` int(30) NOT NULL default '0',
`spellcooldown_3` int(30) NOT NULL default '-1',
`spellcategory_3` int(30) unsigned NOT NULL default '0',
`spellcategorycooldown_3` int(30) NOT NULL default '-1',
`spellid_4` int(30) unsigned NOT NULL default '0',
`spelltrigger_4` int(30) unsigned NOT NULL default '0',
`spellcharges_4` int(30) NOT NULL default '0',
`spellcooldown_4` int(30) NOT NULL default '-1',
`spellcategory_4` int(30) unsigned NOT NULL default '0',
`spellcategorycooldown_4` int(30) NOT NULL default '-1',
`spellid_5` int(30) unsigned NOT NULL default '0',
`spelltrigger_5` int(30) unsigned NOT NULL default '0',
`spellcharges_5` int(30) NOT NULL default '0',
`spellcooldown_5` int(30) NOT NULL default '-1',
`spellcategory_5` int(30) unsigned NOT NULL default '0',
`spellcategorycooldown_5` int(30) NOT NULL default '-1',
`bonding` tinyint(3) unsigned NOT NULL default '0',
`description` varchar(255) NOT NULL default '',
`PageText` int(30) unsigned NOT NULL default '0',
`LanguageID` int(30) unsigned NOT NULL default '0',
`PageMaterial` int(30) unsigned NOT NULL default '0',
`startquest` int(30) unsigned NOT NULL default '0',
`lockid` int(30) unsigned NOT NULL default '0',
`Material` int(30) NOT NULL default '0',
`sheath` int(30) unsigned NOT NULL default '0',
`RandomProperty` int(30) unsigned NOT NULL default '0',
`RandomSuffix` int(30) unsigned NOT NULL default '0',
`block` int(30) unsigned NOT NULL default '0',
`itemset` int(30) unsigned NOT NULL default '0',
`MaxDurability` int(30) unsigned NOT NULL default '0',
`area` int(30) unsigned NOT NULL default '0',
`Map` int(10) NOT NULL default '0',
`BagFamily` int(10) NOT NULL default '0',
`TotemCategory` int(10) NOT NULL default '0',
`socketColor_1` int(10) NOT NULL default '0',
`socketContent_1` int(10) NOT NULL default '0',
`socketColor_2` int(10) NOT NULL default '0',
`socketContent_2` int(10) NOT NULL default '0',
`socketColor_3` int(10) NOT NULL default '0',
`socketContent_3` int(10) NOT NULL default '0',
`socketBonus` int(10) NOT NULL default '0',
`GemProperties` int(10) NOT NULL default '0',
`ExtendedCost` int(10) NOT NULL default '0',
`RequiredDisenchantSkill` int(10) NOT NULL default '-1',
`ArmorDamageModifier` float NOT NULL default '0',
`ScriptName` varchar(100) NOT NULL default '',
`DisenchantID` int(11) unsigned NOT NULL default '0',
PRIMARY KEY (`entry`),
KEY `items_index` (`class`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Item System';
--
-- Dumping data for table `item_template`
--
LOCK TABLES `item_template` WRITE;
/*!40000 ALTER TABLE `item_template` DISABLE KEYS */;
INSERT INTO `item_template` VALUES
(65020,0,0,-1,'Tough Jerky',2473,1,0,6,25,1,0,2047,255,5,1,0,0,0,0,0,0,0,0,20,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1000,0,0,433,0,-1,0,11,1000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-1,0,'internalItemHandler',0),
(65021,0,0,-1,'Refreshing Spring Water',18084,1,0,6,25,1,0,2047,255,5,1,0,0,0,0,0,0,0,0,20,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1000,0,0,430,0,-1,0,59,1000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-1,0,'internalItemHandler',0),
(65022,0,0,-1,'Darnassian Bleu',6353,1,0,6,25,1,0,2047,255,5,1,0,0,0,0,0,0,0,0,20,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1000,0,0,433,0,-1,0,11,1000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-1,0,'internalItemHandler',0),
(65023,2,16,-1,'Small Throwing Knife',16754,1,0,1,15,0,25,2047,255,3,1,0,0,0,0,0,0,0,0,200,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,3,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,2000,4,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-1,0,'internalItemHandler',0),
(65024,2,16,-1,'Crude Throwing Axe',20777,1,0,1,15,0,25,2047,255,3,1,0,0,0,0,0,0,0,0,200,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,3,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,2000,4,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-1,0,'internalItemHandler',0),
(65025,0,0,-1,'Shiny Red Apple',6410,1,0,6,25,1,0,2047,255,5,1,0,0,0,0,0,0,0,0,20,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1000,0,0,433,0,-1,0,11,100,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-1,0,'internalItemHandler',0),
(65026,0,0,-1,'Tough Hunk of Bread',6399,1,0,6,25,1,0,2047,255,5,1,0,0,0,0,0,0,0,0,20,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1000,0,0,433,0,-1,0,11,1000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-1,0,'internalItemHandler',0),
(65027,0,0,-1,'Forest Mushroom Cap',15852,1,0,6,25,1,0,2047,255,5,1,0,0,0,0,0,0,0,0,20,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1000,0,0,433,0,-1,0,11,1000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-1,0,'internalItemHandler',0),
(25,2,7,-1,'Worn Shortsword',1542,1,0,1,35,7,21,32767,511,2,1,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,3,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1900,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,1,0,0,0,1,3,0,0,0,0,20,0,0,0,0,0,0,0,0,0,0,0,0,0,-1,0,'internalItemHandler',0),
(39,4,1,-1,'Recruit\'s Pants',9892,0,0,1,5,1,7,32767,511,1,1,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,0,0,0,0,7,0,0,0,0,0,25,0,0,0,0,0,0,0,0,0,0,0,0,0,-1,0,'internalItemHandler',0),
(40,4,0,-1,'Recruit\'s Boots',10141,1,0,1,4,1,8,32767,511,1,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,0,0,0,0,7,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-1,0,'internalItemHandler',0),
(38,4,0,-1,'Recruit\'s Shirt',9891,1,0,1,1,1,4,0,0,1,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,0,0,0,0,7,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-1,0,'internalItemHandler',0),
(2362,4,6,-1,'Worn Wooden Shield',18730,0,0,1,7,1,14,32767,511,1,1,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,5,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,0,0,0,0,1,4,0,0,1,0,20,0,0,0,0,0,0,0,0,0,0,0,0,0,-1,0,'internalItemHandler',0),
(6948,15,0,-1,'Hearthstone',6418,1,64,1,0,0,0,32767,511,1,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,8690,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,'',0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-1,0,'internalItemHandler',0),
(14646,12,0,-1,'Northshire Gift Voucher',18499,1,0,1,0,0,0,2047,255,1,1,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,4,'',0,0,0,5805,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-1,0,'internalItemHandler',0),
(14647,12,0,-1,'Coldridge Valley Gift Voucher',18499,1,0,1,0,0,0,2047,255,1,1,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,4,'',0,0,0,5841,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-1,0,'internalItemHandler',0),
(14648,12,0,-1,'Shadowglen Gift Voucher',18499,1,0,1,0,0,0,2047,255,1,1,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,4,'',0,0,0,5842,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-1,0,'internalItemHandler',0),
(14649,12,0,-1,'Valley of Trials Gift Voucher',18499,1,0,1,0,0,0,2047,255,1,1,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,4,'',0,0,0,5843,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-1,0,'internalItemHandler',0),
(14650,12,0,-1,'Camp Narache Gift Voucher',18499,1,0,1,0,0,0,2047,255,1,1,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,4,'',0,0,0,5844,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-1,0,'internalItemHandler',0),
(14651,12,0,-1,'Deathknell Gift Voucher',18499,1,0,1,0,0,0,2047,255,1,1,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,4,'',0,0,0,5847,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-1,0,'internalItemHandler',0),
(43,4,0,-1,'Squire\'s Boots',10272,1,0,1,4,1,8,2047,255,1,1,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,0,0,0,0,7,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-1,0,'internalItemHandler',0),
(44,4,1,-1,'Squire\'s Pants',9937,0,0,1,4,1,7,2047,255,1,1,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,2,0,0,0,0,0,0,1000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,0,0,0,0,7,0,0,0,0,0,25,0,0,0,0,0,0,0,0,0,0,0,0,0,-1,0,'internalItemHandler',0),
(45,4,0,-1,'Squire\'s Shirt',3265,1,0,1,1,1,4,2047,255,1,1,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,0,0,0,0,7,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-1,0,'internalItemHandler',0),
(47,4,0,-1,'Footpad\'s Shoes',9915,1,0,1,4,1,8,2047,255,1,1,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,0,0,0,0,7,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-1,0,'internalItemHandler',0),
(48,4,1,-1,'Footpad\'s Pants',9913,0,0,1,4,1,7,2047,255,1,1,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,2,0,0,0,0,0,0,1000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,0,0,0,0,7,0,0,0,0,0,25,0,0,0,0,0,0,0,0,0,0,0,0,0,-1,0,'internalItemHandler',0),
(49,4,0,-1,'Footpad\'s Shirt',9906,1,0,1,1,1,4,2047,255,1,1,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,0,0,0,0,7,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-1,0,'internalItemHandler',0),
(51,4,0,-1,'Neophyte\'s Boots',9946,1,0,1,5,1,8,2047,255,1,1,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,0,0,0,0,7,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-1,0,'internalItemHandler',0),
(52,4,1,-1,'Neophyte\'s Pants',9945,0,0,1,5,1,7,2047,255,1,1,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,2,0,0,0,0,0,0,1000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,0,0,0,0,7,0,0,0,0,0,25,0,0,0,0,0,0,0,0,0,0,0,0,0,-1,0,'internalItemHandler',0),
(53,4,0,-1,'Neophyte\'s Shirt',9944,1,0,1,1,1,4,2047,255,1,1,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,0,0,0,0,7,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-1,0,'internalItemHandler',0),
(55,4,0,-1,'Apprentice\'s Boots',9929,1,0,1,5,1,8,2047,255,1,1,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,0,0,0,0,7,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-1,0,'internalItemHandler',0),
(56,4,1,-1,'Apprentice\'s Robe',12647,0,0,1,5,1,20,2047,255,1,1,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,3,0,0,0,0,0,0,1000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,0,0,0,0,7,0,0,0,0,0,35,0,0,0,0,0,0,0,0,0,0,0,0,0,-1,0,'internalItemHandler',0),
(57,4,1,-1,'Acolyte\'s Robe',12645,0,0,1,5,1,20,2047,255,1,1,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,3,0,0,0,0,0,0,1000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,0,0,0,0,7,0,0,0,0,0,35,0,0,0,0,0,0,0,0,0,0,0,0,0,-1,0,'internalItemHandler',0),
(59,4,0,-1,'Acolyte\'s Shoes',3261,1,0,1,5,1,8,2047,255,1,1,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,0,0,0,0,7,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-1,0,'internalItemHandler',0),
(35,2,10,-1,'Bent Staff',472,1,0,1,47,9,17,2047,255,2,1,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,3,5,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,2900,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,0,0,0,0,2,2,0,0,0,0,25,0,0,0,0,0,0,0,0,0,0,0,0,0,-1,0,'internalItemHandler',0),
(36,2,4,-1,'Worn Mace',5194,1,0,1,38,7,21,2047,255,2,1,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,3,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1900,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,0,0,0,0,2,3,0,0,0,0,20,0,0,0,0,0,0,0,0,0,0,0,0,0,-1,0,'internalItemHandler',0),
(37,2,0,-1,'Worn Axe',14029,1,0,1,38,7,21,2047,255,2,1,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,3,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,2000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,0,0,0,0,1,3,0,0,0,0,20,0,0,0,0,0,0,0,0,0,0,0,0,0,-1,0,'internalItemHandler',0),
(2361,2,5,-1,'Battleworn Hammer',8690,1,0,1,45,9,17,2047,255,2,1,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,3,5,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,2900,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,0,0,0,0,2,1,0,0,0,0,25,0,0,0,0,0,0,0,0,0,0,0,0,0,-1,0,'internalItemHandler',0),
(2092,2,15,-1,'Worn Dagger',6442,1,0,1,35,7,13,2047,255,2,1,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1600,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,0,0,0,0,1,3,0,0,0,0,16,0,0,0,0,0,0,0,0,0,0,0,0,0,-1,0,'internalItemHandler',0),
(6096,4,0,-1,'Apprentice\'s Shirt',2163,1,0,1,1,1,4,2047,255,1,1,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,0,0,0,0,7,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-1,0,'internalItemHandler',0),
(6097,4,0,-1,'Acolyte\'s Shirt',2470,1,0,1,1,1,4,2047,255,1,1,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,0,0,0,0,7,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-1,0,'internalItemHandler',0),
(6098,4,1,-1,'Neophyte\'s Robe',12679,0,0,1,4,1,20,2047,255,1,1,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,3,0,0,0,0,0,0,1000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,0,0,0,0,7,0,0,0,0,0,35,0,0,0,0,0,0,0,0,0,0,0,0,0,-1,0,'internalItemHandler',0),
(1395,4,1,-1,'Apprentice\'s Pants',9924,0,0,1,5,1,7,2047,255,1,1,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,2,0,0,0,0,0,0,1000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,0,0,0,0,7,0,0,0,0,0,25,0,0,0,0,0,0,0,0,0,0,0,0,0,-1,0,'internalItemHandler',0),
(1396,4,1,-1,'Acolyte\'s Pants',3260,0,0,1,4,1,7,2047,255,1,1,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,2,0,0,0,0,0,0,1000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,0,0,0,0,7,0,0,0,0,0,25,0,0,0,0,0,0,0,0,0,0,0,0,0,-1,0,'internalItemHandler',0),
(6125,4,0,-1,'Brawler\'s Harness',9995,1,0,1,1,1,4,2047,255,1,1,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,0,0,0,0,7,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-1,0,'internalItemHandler',0),
(6126,4,1,-1,'Trapper\'s Pants',10002,0,0,1,5,1,7,2047,255,1,1,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,2,0,0,0,0,0,0,1000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,0,0,0,0,7,0,0,0,0,0,25,0,0,0,0,0,0,0,0,0,0,0,0,0,-1,0,'internalItemHandler',0),
(6127,4,0,-1,'Trapper\'s Boots',10003,1,0,1,5,1,8,2047,255,1,1,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,0,0,0,0,7,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-1,0,'internalItemHandler',0),
(6129,4,1,-1,'Acolyte\'s Robe',12646,0,0,1,5,1,20,2047,255,1,1,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,3,0,0,0,0,0,0,1000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,0,0,0,0,7,0,0,0,0,0,35,0,0,0,0,0,0,0,0,0,0,0,0,0,-1,0,'internalItemHandler',0),
(139,4,1,-1,'Brawler\'s Pants',9988,0,0,1,4,1,7,2047,255,1,1,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,2,0,0,0,0,0,0,1000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,0,0,0,0,7,0,0,0,0,0,25,0,0,0,0,0,0,0,0,0,0,0,0,0,-1,0,'internalItemHandler',0),
(140,4,0,-1,'Brawler\'s Boots',9992,1,0,1,4,1,8,2047,255,1,1,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,0,0,0,0,7,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-1,0,'internalItemHandler',0),
(127,4,0,-1,'Trapper\'s Shirt',9996,1,0,1,1,1,4,2047,255,1,1,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,0,0,0,0,7,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-1,0,'internalItemHandler',0),
(120,4,1,-1,'Thug Pants',10006,0,0,1,4,1,7,2047,255,1,1,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,2,0,0,0,0,0,0,1000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,0,0,0,0,7,0,0,0,0,0,25,0,0,0,0,0,0,0,0,0,0,0,0,0,-1,0,'internalItemHandler',0),
(121,4,0,-1,'Thug Boots',10008,1,0,1,4,1,8,2047,255,1,1,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,0,0,0,0,7,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-1,0,'internalItemHandler',0),
(147,4,1,-1,'Rugged Trapper\'s Pants',9975,0,0,1,5,1,7,2047,255,1,1,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,2,0,0,0,0,0,0,1000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,0,0,0,0,7,0,0,0,0,0,25,0,0,0,0,0,0,0,0,0,0,0,0,0,-1,0,'internalItemHandler',0),
(148,4,0,-1,'Rugged Trapper\'s Shirt',9976,1,0,1,1,1,4,2047,255,1,1,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,0,0,0,0,7,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-1,0,'internalItemHandler',0),
(153,4,2,-1,'Primitive Kilt',10050,0,0,1,5,1,7,2047,255,1,1,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,14,0,0,0,0,0,0,1000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,0,0,0,0,8,0,0,0,0,0,30,0,0,0,0,0,0,0,0,0,0,0,0,0,-1,0,'internalItemHandler',0),
(154,4,0,-1,'Primitive Mantle',10058,1,0,1,1,1,4,2047,255,1,1,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,0,0,0,0,7,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-1,0,'internalItemHandler',0),
(2101,1,2,-1,'Light Quiver',21328,1,0,1,4,1,18,2047,255,1,1,0,0,0,0,0,0,0,0,1,6,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1000,0,0,14824,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,'',0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-1,0,'internalItemHandler',0),
(2102,1,3,-1,'Small Ammo Pouch',1816,1,0,1,4,1,18,2047,255,1,1,0,0,0,0,0,0,0,0,1,6,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1000,0,0,14824,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,'',0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-1,0,'internalItemHandler',0),
(2105,4,0,-1,'Thug Shirt',10005,1,0,1,5,1,4,2047,255,1,1,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,0,0,0,0,7,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-1,0,'internalItemHandler',0),
(2504,2,2,-1,'Worn Shortbow',8106,1,0,1,29,5,15,2047,255,2,1,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,2,5,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,2300,2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,0,0,0,0,2,0,0,0,0,0,20,0,0,0,0,0,0,0,0,0,0,0,0,0,-1,0,'internalItemHandler',0),
(2508,2,3,-1,'Old Blunderbuss',6606,1,0,1,27,5,26,2047,255,2,1,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,2,5,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,2300,3,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,0,0,0,0,1,0,0,0,0,0,20,0,0,0,0,0,0,0,0,0,0,0,0,0,-1,0,'internalItemHandler',0),
(2512,6,2,-1,'Rough Arrow',5996,1,0,1,10,0,24,2047,255,5,1,0,0,0,0,0,0,0,0,200,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,3000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,0,0,0,0,2,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,-1,0,'internalItemHandler',0),
(2516,6,3,-1,'Light Shot',5998,1,0,1,10,0,24,2047,255,5,1,0,0,0,0,0,0,0,0,200,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,3000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,0,0,0,0,2,0,0,0,0,0,0,0,0,2,0,0,0,0,0,0,0,0,0,0,-1,0,'internalItemHandler',0),
(3661,2,10,-1,'Handcrafted Staff',18530,1,0,1,45,9,17,2047,255,2,1,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,3,5,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,2900,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,0,0,0,0,2,2,0,0,0,0,25,0,0,0,0,0,0,0,0,0,0,0,0,0,-1,0,'internalItemHandler',0),
(6119,4,1,-1,'Neophyte\'s Robe',12681,0,0,1,4,1,20,2047,255,1,1,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,3,0,0,0,0,0,0,1000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,0,0,0,0,7,0,0,0,0,0,35,0,0,0,0,0,0,0,0,0,0,0,0,0,-1,0,'internalItemHandler',0),
(6123,4,1,-1,'Novice\'s Robe',12683,0,0,1,4,1,20,2047,255,1,1,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,3,0,0,0,0,0,0,1000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,0,0,0,0,7,0,0,0,0,0,35,0,0,0,0,0,0,0,0,0,0,0,0,0,-1,0,'internalItemHandler',0),
(6124,4,1,-1,'Novice\'s Pants',9987,0,0,1,5,1,7,2047,255,1,1,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,2,0,0,0,0,0,0,1000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,0,0,0,0,7,0,0,0,0,0,25,0,0,0,0,0,0,0,0,0,0,0,0,0,-1,0,'internalItemHandler',0),
(6134,4,0,-1,'Primitive Mantle',10108,1,0,1,1,1,4,2047,255,1,1,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,0,0,0,0,7,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-1,0,'internalItemHandler',0),
(6135,4,2,-1,'Primitive Kilt',10109,0,0,1,5,1,7,2047,255,1,1,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,14,0,0,0,0,0,0,1000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,0,0,0,0,8,0,0,0,0,0,30,0,0,0,0,0,0,0,0,0,0,0,0,0,-1,0,'internalItemHandler',0),
(6139,4,1,-1,'Novice\'s Robe',12684,0,0,1,4,1,20,2047,255,1,1,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,3,0,0,0,0,0,0,1000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,0,0,0,0,7,0,0,0,0,0,35,0,0,0,0,0,0,0,0,0,0,0,0,0,-1,0,'internalItemHandler',0),
(6140,4,1,-1,'Apprentice\'s Robe',12649,0,0,1,4,1,20,2047,255,1,1,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,3,0,0,0,0,0,0,1000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,0,0,0,0,7,0,0,0,0,0,35,0,0,0,0,0,0,0,0,0,0,0,0,0,-1,0,'internalItemHandler',0),
(6144,4,1,-1,'Neophyte\'s Robe',12680,0,0,1,5,1,20,2047,255,1,1,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,3,0,0,0,0,0,0,1000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,0,0,0,0,7,0,0,0,0,0,35,0,0,0,0,0,0,0,0,0,0,0,0,0,-1,0,'internalItemHandler',0),
(12282,2,1,-1,'Worn Battleaxe',22291,1,0,1,43,8,17,2047,255,2,1,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,3,5,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,2900,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,0,0,0,0,1,1,0,0,0,0,25,0,0,0,0,0,0,0,0,0,0,0,0,0,-1,0,'internalItemHandler',0);
/*!40000 ALTER TABLE `item_template` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `item_text`
--
DROP TABLE IF EXISTS `item_text`;
CREATE TABLE `item_text` (
`id` int(11) NOT NULL default '0',
`text` longtext,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Item System';
--
-- Dumping data for table `item_text`
--
LOCK TABLES `item_text` WRITE;
/*!40000 ALTER TABLE `item_text` DISABLE KEYS */;
/*!40000 ALTER TABLE `item_text` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `mail`
--
DROP TABLE IF EXISTS `mail`;
CREATE TABLE `mail` (
`id` int(11) unsigned NOT NULL default '0' COMMENT 'Identifier',
`messageType` tinyint(3) unsigned NOT NULL default '0',
`sender` int(11) unsigned NOT NULL default '0' COMMENT 'Character Global Unique Identifier',
`receiver` int(11) unsigned NOT NULL default '0' COMMENT 'Character Global Unique Identifier',
`subject` longtext,
`itemTextId` int(11) unsigned NOT NULL default '0',
`item_guid` int(11) unsigned NOT NULL default '0' COMMENT 'Mail Item Global Unique Identifier',
`item_template` int(11) unsigned NOT NULL default '0' COMMENT 'Item Identifier',
`expire_time` bigint(40) NOT NULL default '0',
`deliver_time` bigint(40) NOT NULL default '0',
`money` int(11) unsigned NOT NULL default '0',
`cod` int(11) unsigned NOT NULL default '0',
`checked` tinyint(3) unsigned NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `idx_receiver` (`receiver`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Mail System';
--
-- Dumping data for table `mail`
--
LOCK TABLES `mail` WRITE;
/*!40000 ALTER TABLE `mail` DISABLE KEYS */;
/*!40000 ALTER TABLE `mail` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `npc_gossip`
--
DROP TABLE IF EXISTS `npc_gossip`;
CREATE TABLE `npc_gossip` (
`id` int(11) NOT NULL default '0',
`npc_guid` int(11) NOT NULL default '0',
`gossip_type` int(11) NOT NULL default '0',
`textid` int(30) NOT NULL default '0',
`option_count` int(30) default NULL,
PRIMARY KEY (`id`,`npc_guid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `npc_gossip`
--
LOCK TABLES `npc_gossip` WRITE;
/*!40000 ALTER TABLE `npc_gossip` DISABLE KEYS */;
/*!40000 ALTER TABLE `npc_gossip` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `npc_gossip_textid`
--
DROP TABLE IF EXISTS `npc_gossip_textid`;
CREATE TABLE `npc_gossip_textid` (
`zoneid` int(11) unsigned NOT NULL default '0',
`action` int(3) unsigned NOT NULL default '0',
`textid` int(11) unsigned NOT NULL default '0',
KEY `zoneid` (`zoneid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `npc_gossip_textid`
--
LOCK TABLES `npc_gossip_textid` WRITE;
/*!40000 ALTER TABLE `npc_gossip_textid` DISABLE KEYS */;
/*!40000 ALTER TABLE `npc_gossip_textid` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `npc_option`
--
DROP TABLE IF EXISTS `npc_option`;
CREATE TABLE `npc_option` (
`id` int(11) unsigned NOT NULL default '0',
`gossip_id` int(11) unsigned NOT NULL default '0',
`npcflag` int(11) unsigned NOT NULL default '0',
`icon` int(11) unsigned NOT NULL default '0',
`action` int(11) unsigned NOT NULL default '0',
`option` text,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `npc_option`
--
LOCK TABLES `npc_option` WRITE;
/*!40000 ALTER TABLE `npc_option` DISABLE KEYS */;
/*!40000 ALTER TABLE `npc_option` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `npc_text`
--
DROP TABLE IF EXISTS `npc_text`;
CREATE TABLE `npc_text` (
`ID` int(11) NOT NULL default '0',
`text0_0` longtext,
`text0_1` longtext,
`lang0` bigint(20) unsigned NOT NULL default '0',
`prob0` float NOT NULL default '0',
`em0_0` bigint(20) unsigned NOT NULL default '0',
`em0_1` bigint(20) unsigned NOT NULL default '0',
`em0_2` bigint(20) unsigned NOT NULL default '0',
`em0_3` bigint(20) unsigned NOT NULL default '0',
`em0_4` bigint(20) unsigned NOT NULL default '0',
`em0_5` bigint(20) unsigned NOT NULL default '0',
`text1_0` longtext,
`text1_1` longtext,
`lang1` bigint(20) unsigned NOT NULL default '0',
`prob1` float NOT NULL default '0',
`em1_0` bigint(20) unsigned NOT NULL default '0',
`em1_1` bigint(20) unsigned NOT NULL default '0',
`em1_2` bigint(20) unsigned NOT NULL default '0',
`em1_3` bigint(20) unsigned NOT NULL default '0',
`em1_4` bigint(20) unsigned NOT NULL default '0',
`em1_5` bigint(20) unsigned NOT NULL default '0',
`text2_0` longtext,
`text2_1` longtext,
`lang2` bigint(20) unsigned NOT NULL default '0',
`prob2` float NOT NULL default '0',
`em2_0` bigint(20) unsigned NOT NULL default '0',
`em2_1` bigint(20) unsigned NOT NULL default '0',
`em2_2` bigint(20) unsigned NOT NULL default '0',
`em2_3` bigint(20) unsigned NOT NULL default '0',
`em2_4` bigint(20) unsigned NOT NULL default '0',
`em2_5` bigint(20) unsigned NOT NULL default '0',
`text3_0` longtext,
`text3_1` longtext,
`lang3` bigint(20) unsigned NOT NULL default '0',
`prob3` float NOT NULL default '0',
`em3_0` bigint(20) unsigned NOT NULL default '0',
`em3_1` bigint(20) unsigned NOT NULL default '0',
`em3_2` bigint(20) unsigned NOT NULL default '0',
`em3_3` bigint(20) unsigned NOT NULL default '0',
`em3_4` bigint(20) unsigned NOT NULL default '0',
`em3_5` bigint(20) unsigned NOT NULL default '0',
`text4_0` longtext,
`text4_1` longtext,
`lang4` bigint(20) unsigned NOT NULL default '0',
`prob4` float NOT NULL default '0',
`em4_0` bigint(20) unsigned NOT NULL default '0',
`em4_1` bigint(20) unsigned NOT NULL default '0',
`em4_2` bigint(20) unsigned NOT NULL default '0',
`em4_3` bigint(20) unsigned NOT NULL default '0',
`em4_4` bigint(20) unsigned NOT NULL default '0',
`em4_5` bigint(20) unsigned NOT NULL default '0',
`text5_0` longtext,
`text5_1` longtext,
`lang5` bigint(20) unsigned NOT NULL default '0',
`prob5` float NOT NULL default '0',
`em5_0` bigint(20) unsigned NOT NULL default '0',
`em5_1` bigint(20) unsigned NOT NULL default '0',
`em5_2` bigint(20) unsigned NOT NULL default '0',
`em5_3` bigint(20) unsigned NOT NULL default '0',
`em5_4` bigint(20) unsigned NOT NULL default '0',
`em5_5` bigint(20) unsigned NOT NULL default '0',
`text6_0` longtext,
`text6_1` longtext,
`lang6` bigint(20) unsigned NOT NULL default '0',
`prob6` float NOT NULL default '0',
`em6_0` bigint(20) unsigned NOT NULL default '0',
`em6_1` bigint(20) unsigned NOT NULL default '0',
`em6_2` bigint(20) unsigned NOT NULL default '0',
`em6_3` bigint(20) unsigned NOT NULL default '0',
`em6_4` bigint(20) unsigned NOT NULL default '0',
`em6_5` bigint(20) unsigned NOT NULL default '0',
`text7_0` longtext,
`text7_1` longtext,
`lang7` bigint(20) unsigned NOT NULL default '0',
`prob7` float NOT NULL default '0',
`em7_0` bigint(20) unsigned NOT NULL default '0',
`em7_1` bigint(20) unsigned NOT NULL default '0',
`em7_2` bigint(20) unsigned NOT NULL default '0',
`em7_3` bigint(20) unsigned NOT NULL default '0',
`em7_4` bigint(20) unsigned NOT NULL default '0',
`em7_5` bigint(20) unsigned NOT NULL default '0',
PRIMARY KEY (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `npc_text`
--
LOCK TABLES `npc_text` WRITE;
/*!40000 ALTER TABLE `npc_text` DISABLE KEYS */;
/*!40000 ALTER TABLE `npc_text` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `npc_trainer`
--
DROP TABLE IF EXISTS `npc_trainer`;
CREATE TABLE `npc_trainer` (
`entry` int(11) NOT NULL default '0',
`spell` int(11) NOT NULL default '0',
`spellcost` int(11) default '0',
`reqskill` int(11) unsigned default '0',
`reqskillvalue` int(11) unsigned default '0',
`reqlevel` int(11) unsigned default '0',
UNIQUE KEY `entry_spell` (`entry`,`spell`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `npc_trainer`
--
LOCK TABLES `npc_trainer` WRITE;
/*!40000 ALTER TABLE `npc_trainer` DISABLE KEYS */;
/*!40000 ALTER TABLE `npc_trainer` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `npc_vendor`
--
DROP TABLE IF EXISTS `npc_vendor`;
CREATE TABLE `npc_vendor` (
`entry` int(11) unsigned NOT NULL default '0',
`item` int(11) unsigned NOT NULL default '0',
`maxcount` tinyint(3) unsigned NOT NULL default '0',
`incrtime` int(11) unsigned NOT NULL default '0',
PRIMARY KEY (`entry`,`item`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Npc System';
--
-- Dumping data for table `npc_vendor`
--
LOCK TABLES `npc_vendor` WRITE;
/*!40000 ALTER TABLE `npc_vendor` DISABLE KEYS */;
/*!40000 ALTER TABLE `npc_vendor` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `page_text`
--
DROP TABLE IF EXISTS `page_text`;
CREATE TABLE `page_text` (
`entry` int(11) NOT NULL default '0',
`text` longtext,
`next_page` bigint(20) unsigned NOT NULL default '0',
PRIMARY KEY (`entry`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Item System';
--
-- Dumping data for table `page_text`
--
LOCK TABLES `page_text` WRITE;
/*!40000 ALTE