Дополнения для сервера Aion Emu

http://qomp.narod.ru/dnld/forum/servemupat.rar

DROP TABLE IF EXISTS `char_templates`;
CREATE TABLE `char_templates` (
`ClassId` int(11) NOT NULL default '0',
`ClassName` varchar(20) NOT NULL default '',
`RaceId` int(1) NOT NULL default '0',
`STR` int(2) NOT NULL default '0',
`CON` int(2) NOT NULL default '0',
`AGI` int(2) NOT NULL default '0',
`ACC` int(2) NOT NULL default '0',
`INT` int(2) NOT NULL default '0',
`SPR` int(2) NOT NULL default '0',
PRIMARY KEY (`ClassId`)
) ENGINE=MyISAM;
INSERT INTO `char_templates` (`ClassId`, `ClassName`, `RaceId`, `STR`, `CON`, `AGI`, `ACC`, `INT`, `SPR`) VALUES
(1, 'Warrior', 1, 110, 110, 100, 100, 90, 90),
(2, 'Templar', 1, 115, 100, 100, 100, 90, 105),
(3, 'Gladiator', 1, 115, 115, 100, 100, 90, 90),
(4, 'Scout', 1, 100, 100, 110, 110, 90, 90),
(5, 'Ranger', 1, 100, 100, 115, 115, 90, 90),
(6, 'Assassin', 1, 110, 100, 110, 110, 90, 90),
(7, 'Mage', 1, 90, 90, 95, 95, 115, 115),
(8, 'Sorcerer', 1, 90, 90, 95, 95, 120, 110),
(9, 'Spiritmaster', 1, 90, 90, 95, 95, 115, 115),
(10, 'Priest', 1, 95, 95, 100, 100, 100, 110),
(11, 'Cleric', 1, 105, 110, 90, 90, 105, 110),
(12, 'Chanter', 1, 110, 105, 90, 90, 105, 110);

DROP TABLE IF EXISTS `character_skills`;
CREATE TABLE `character_skills` (
`char_obj_id` INT NOT NULL DEFAULT '0',
`skill_id` INT NOT NULL DEFAULT '0',
`skill_level` VARCHAR(5),
`skill_name` VARCHAR(40),
`class_index` SMALLINT(3) NOT NULL DEFAULT '0',
PRIMARY KEY(`char_obj_id`,`skill_id`,`class_index`)
) TYPE=MyISAM;

DROP TABLE IF EXISTS `character_skills_save`;
CREATE TABLE `character_skills_save` (
`char_obj_id` int(11) NOT NULL default '0',
`skill_id` int(11) NOT NULL default '0',
`class_index` SMALLINT(3) NOT NULL default '0',
`end_time` bigint(110) NOT NULL default '0',
`reuse_delay_org` int(11) NOT NULL default '0',
PRIMARY KEY(`char_obj_id`,`skill_id`,`class_index`)
) ENGINE=MyISAM;

DROP TABLE IF EXISTS `character_stats`;
CREATE TABLE `character_stats` (
`char_obj_id` INT(10) NOT NULL,
`class_id` SMALLINT(3) NOT NULL,
`level` TINYINT(2) NOT NULL DEFAULT '1',
PRIMARY KEY (`char_obj_id`,`class_id`)
) TYPE=MyISAM;

DROP TABLE IF EXISTS `character_variables`;
CREATE TABLE `character_variables` (
`obj_id` int(11) NOT NULL default '0',
`type` varchar(86) NOT NULL default '0',
`name` varchar(86) NOT NULL default '0',
`index` int(11) NOT NULL default '0',
`value` varchar(255) NOT NULL default '0',
`expire_time` int(11) NOT NULL default '0',
UNIQUE KEY `prim` (`obj_id`,`type`,`name`,`index`),
KEY `obj_id` (`obj_id`),
KEY `type` (`type`),
KEY `name` (`name`),
KEY `index` (`index`),
KEY `value` (`value`),
KEY `expire_time` (`expire_time`)
) ENGINE=MyISAM;

DROP TABLE IF EXISTS `guild_data`;
CREATE TABLE `guild_data` (
guild_id INT UNSIGNED NOT NULL DEFAULT 0,
guild_name VARCHAR(45),
guild_level TINYINT UNSIGNED NOT NULL DEFAULT 0,
leader_id INT UNSIGNED NOT NULL DEFAULT 0,
PRIMARY KEY (guild_id),
KEY `leader_id` (`leader_id`),
) TYPE=MyISAM;

DROP TABLE IF EXISTS `characters`;
CREATE TABLE `characters` (
`account_name` VARCHAR(45) NOT NULL DEFAULT '',
`obj_Id` INT UNSIGNED NOT NULL DEFAULT 0,
`char_name` VARCHAR(35) NOT NULL DEFAULT '',
`face` TINYINT UNSIGNED DEFAULT NULL,
`hairStyle` TINYINT UNSIGNED DEFAULT NULL,
`hairColor` TINYINT UNSIGNED DEFAULT NULL,
`sex` BOOLEAN DEFAULT NULL,
`heading` MEDIUMINT(6) DEFAULT NULL,
`x` MEDIUMINT(7) DEFAULT NULL,
`y` MEDIUMINT(7) DEFAULT NULL,
`z` MEDIUMINT(7) DEFAULT NULL,
`guildid` INT DEFAULT NULL,
`deletetime` INT UNSIGNED NOT NULL DEFAULT 0,
`title` VARCHAR(16) DEFAULT NULL,
`rec_have` SMALLINT(3) UNSIGNED NOT NULL DEFAULT '0',
`rec_left` SMALLINT(3) UNSIGNED NOT NULL DEFAULT '0',
`accesslevel` INT(4) DEFAULT NULL,
`online` BOOLEAN DEFAULT NULL,
`onlinetime` INT UNSIGNED NOT NULL DEFAULT '0',
`lastAccess` INT UNSIGNED NOT NULL DEFAULT 0,
`guild_privs` INT DEFAULT 0,
`wantspeace` INT DEFAULT 0,
`leaveguild` INT UNSIGNED NOT NULL DEFAULT 0,
`deleteguild` INT UNSIGNED NOT NULL DEFAULT 0,
PRIMARY KEY (obj_Id),
UNIQUE KEY `char_name` (`char_name`),
KEY `guildid` (`guildid`)
) TYPE=MyISAM;

# ================================================================
# General server setting !!! REQUIRED to configure to everyone !!!
# ================================================================

# Register external ip
ExternalHostname=127.0.0.1

# Register internal ip
InternalHostname=127.0.0.1

# The Loginserver host and port
LoginPort=
LoginHost=127.0.0.1

# Database info
Driver=com.mysql.jdbc.Driver
URL=jdbc:mysql://localhost/aion_game
Login=root
Password=

# Character name be only en or ru ignore case
#Default
#CnameTemplate=[A-Za-z0-9\u0410-\u042f\u0430-\u044f]{2,16}
#If You Set En
#CnameTemplate=[A-Za-z0-9]{2,16}
TemplateLang =ru