Skocz do zawartości

  • 👋 Witaj na MPCForum!

    Przeglądasz forum jako gość, co oznacza, że wiele świetnych funkcji jest jeszcze przed Tobą! 😎

    • ✅ Pełny dostęp do działów i ukrytych treści
    • ✅ Możliwość pisania i odpowiadania w tematach
    • ✅ System prywatnych wiadomości
    • ✅ Zbieranie reputacji i rozwijanie swojego profilu
    • ✅ Członkostwo w jednej z największych społeczności graczy

    👉 Dołączenie zajmie Ci mniej niż minutę – a zyskasz znacznie więcej!

    Zarejestruj się teraz

Nie możesz stworzyć postaci

Pitos

Rekomendowane odpowiedzi

lazarus.1988 Budowniczy

lazarus.1988

Opublikowano
Budowniczy

lazarus.1988

Opublikowano
Wyczyść całkiem bazy i wgraj te zapytania:




/*

Navicat MySQL Data Transfer

 

Source Server         : test

Source Server Version : 50535

Source Host           : ***

Source Database       : player

 

Target Server Type    : MYSQL

Target Server Version : 50535

File Encoding         : 65001

 

Date: 2015-06-12 09:41:33

*/

 

SET FOREIGN_KEY_CHECKS=0;

 

-- ----------------------------

-- Table structure for affect

-- ----------------------------

DROP TABLE IF EXISTS `affect`;

CREATE TABLE `affect` (

  `dwPID` int(10) unsigned NOT NULL DEFAULT '0',

  `bType` smallint(5) unsigned NOT NULL DEFAULT '0',

  `bApplyOn` tinyint(4) unsigned NOT NULL DEFAULT '0',

  `lApplyValue` int(11) NOT NULL DEFAULT '0',

  `dwFlag` int(10) unsigned NOT NULL DEFAULT '0',

  `lDuration` int(11) NOT NULL DEFAULT '0',

  `lSPCost` int(11) NOT NULL DEFAULT '0',

  PRIMARY KEY (`dwPID`,`bType`,`bApplyOn`,`lApplyValue`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

 

-- ----------------------------

-- Table structure for banword

-- ----------------------------

DROP TABLE IF EXISTS `banword`;

CREATE TABLE `banword` (

  `word` varbinary(24) NOT NULL DEFAULT '',

  PRIMARY KEY (`word`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

 

-- ----------------------------

-- Table structure for card

-- ----------------------------

DROP TABLE IF EXISTS `card`;

CREATE TABLE `card` (

  `id` int(11) NOT NULL AUTO_INCREMENT,

  `cash` varchar(255) DEFAULT NULL,

  `prices` varchar(255) DEFAULT NULL,

  `no` varchar(255) DEFAULT NULL,

  `pwd` varchar(255) DEFAULT NULL,

  `lock` int(11) DEFAULT NULL,

  PRIMARY KEY (`id`)

) ENGINE=MyISAM AUTO_INCREMENT=1693 DEFAULT CHARSET=big5;

 

-- ----------------------------

-- Table structure for event071115_name

-- ----------------------------

DROP TABLE IF EXISTS `event071115_name`;

CREATE TABLE `event071115_name` (

  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,

  `ruid` int(11) NOT NULL DEFAULT '0',

  `account` varchar(50) NOT NULL DEFAULT '',

  `uid` int(8) NOT NULL DEFAULT '0',

  `username` varchar(50) NOT NULL DEFAULT '',

  `account_id` int(8) NOT NULL DEFAULT '0',

  `player_id` int(8) NOT NULL DEFAULT '0',

  `old_name` varchar(50) NOT NULL DEFAULT '',

  `new_name` varchar(50) NOT NULL DEFAULT '',

  `ipaddress` varchar(16) NOT NULL DEFAULT '',

  `datetime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',

  PRIMARY KEY (`id`),

  KEY `old_name` (`old_name`),

  KEY `new_name` (`new_name`)

) ENGINE=MyISAM AUTO_INCREMENT=693 DEFAULT CHARSET=latin1;

 

-- ----------------------------

-- Table structure for guild

-- ----------------------------

DROP TABLE IF EXISTS `guild`;

CREATE TABLE `guild` (

  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,

  `name` varchar(12) NOT NULL DEFAULT '',

  `sp` smallint(6) NOT NULL DEFAULT '1000',

  `master` int(10) unsigned NOT NULL DEFAULT '0',

  `level` tinyint(2) DEFAULT NULL,

  `exp` int(11) DEFAULT NULL,

  `skill_point` tinyint(2) NOT NULL DEFAULT '0',

  `skill` tinyblob,

  `win` int(11) NOT NULL DEFAULT '0',

  `draw` int(11) NOT NULL DEFAULT '0',

  `loss` int(11) NOT NULL DEFAULT '0',

  `ladder_point` int(11) NOT NULL DEFAULT '0',

  `gold` int(11) NOT NULL DEFAULT '0',

  PRIMARY KEY (`id`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

 

-- ----------------------------

-- Table structure for guild_comment

-- ----------------------------

DROP TABLE IF EXISTS `guild_comment`;

CREATE TABLE `guild_comment` (

  `id` int(11) NOT NULL AUTO_INCREMENT,

  `guild_id` int(10) unsigned DEFAULT NULL,

  `name` varchar(8) DEFAULT NULL,

  `notice` tinyint(4) DEFAULT NULL,

  `content` varchar(50) DEFAULT NULL,

  `time` datetime DEFAULT NULL,

  PRIMARY KEY (`id`),

  KEY `aaa` (`notice`,`id`,`guild_id`),

  KEY `guild_id` (`guild_id`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

 

-- ----------------------------

-- Table structure for guild_grade

-- ----------------------------

DROP TABLE IF EXISTS `guild_grade`;

CREATE TABLE `guild_grade` (

  `guild_id` int(11) NOT NULL DEFAULT '0',

  `grade` tinyint(4) NOT NULL DEFAULT '0',

  `name` varchar(8) NOT NULL DEFAULT '',

  `auth` set('ADD_MEMBER','REMOVE_MEMEBER','NOTICE','USE_SKILL') DEFAULT NULL,

  PRIMARY KEY (`guild_id`,`grade`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

 

-- ----------------------------

-- Table structure for guild_member

-- ----------------------------

DROP TABLE IF EXISTS `guild_member`;

CREATE TABLE `guild_member` (

  `pid` int(10) unsigned NOT NULL DEFAULT '0',

  `guild_id` int(10) unsigned NOT NULL DEFAULT '0',

  `grade` tinyint(2) DEFAULT NULL,

  `is_general` tinyint(1) NOT NULL DEFAULT '0',

  `offer` int(10) unsigned DEFAULT NULL,

  PRIMARY KEY (`guild_id`,`pid`),

  UNIQUE KEY `pid` (`pid`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

 

-- ----------------------------

-- Table structure for guild_war

-- ----------------------------

DROP TABLE IF EXISTS `guild_war`;

CREATE TABLE `guild_war` (

  `id_from` int(11) NOT NULL DEFAULT '0',

  `id_to` int(11) NOT NULL DEFAULT '0',

  PRIMARY KEY (`id_from`,`id_to`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

 

-- ----------------------------

-- Table structure for guild_war_bet

-- ----------------------------

DROP TABLE IF EXISTS `guild_war_bet`;

CREATE TABLE `guild_war_bet` (

  `login` varchar(24) NOT NULL DEFAULT '',

  `gold` int(10) unsigned NOT NULL DEFAULT '0',

  `guild` int(11) NOT NULL DEFAULT '0',

  `war_id` int(10) unsigned NOT NULL DEFAULT '0',

  PRIMARY KEY (`war_id`,`login`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

 

-- ----------------------------

-- Table structure for guild_war_reservation

-- ----------------------------

DROP TABLE IF EXISTS `guild_war_reservation`;

CREATE TABLE `guild_war_reservation` (

  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,

  `guild1` int(10) unsigned NOT NULL DEFAULT '0',

  `guild2` int(10) unsigned NOT NULL DEFAULT '0',

  `time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',

  `type` tinyint(2) unsigned NOT NULL DEFAULT '0',

  `warprice` int(10) unsigned NOT NULL DEFAULT '0',

  `initscore` int(10) unsigned NOT NULL DEFAULT '0',

  `started` tinyint(1) NOT NULL DEFAULT '0',

  `bet_from` int(10) unsigned NOT NULL DEFAULT '0',

  `bet_to` int(10) unsigned NOT NULL DEFAULT '0',

  `winner` int(11) NOT NULL DEFAULT '-1',

  `power1` int(11) NOT NULL DEFAULT '0',

  `power2` int(11) NOT NULL DEFAULT '0',

  `handicap` int(11) NOT NULL DEFAULT '0',

  `result1` int(11) NOT NULL DEFAULT '0',

  `result2` int(11) NOT NULL DEFAULT '0',

  PRIMARY KEY (`id`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

 

-- ----------------------------

-- Table structure for horse_name

-- ----------------------------

DROP TABLE IF EXISTS `horse_name`;

CREATE TABLE `horse_name` (

  `id` int(11) NOT NULL DEFAULT '0',

  `name` varchar(24) CHARACTER SET utf8 COLLATE utf8_polish_ci NOT NULL DEFAULT 'NONAME',

  PRIMARY KEY (`id`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

 

-- ----------------------------

-- Table structure for item

-- ----------------------------

DROP TABLE IF EXISTS `item`;

CREATE TABLE `item` (

  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,

  `owner_id` int(11) unsigned NOT NULL DEFAULT '0',

  `window` enum('INVENTORY','EQUIPMENT','SAFEBOX','MALL') NOT NULL DEFAULT 'INVENTORY',

  `pos` smallint(5) unsigned NOT NULL DEFAULT '0',

  `count` tinyint(3) unsigned NOT NULL DEFAULT '0',

  `vnum` int(11) unsigned NOT NULL DEFAULT '0',

  `socket0` int(10) unsigned NOT NULL DEFAULT '0',

  `socket1` int(10) unsigned NOT NULL DEFAULT '0',

  `socket2` int(10) unsigned NOT NULL DEFAULT '0',

  `socket3` int(10) unsigned NOT NULL DEFAULT '0',

  `socket4` int(10) unsigned NOT NULL DEFAULT '0',

  `socket5` int(10) unsigned NOT NULL DEFAULT '0',

  `attrtype0` tinyint(4) NOT NULL DEFAULT '0',

  `attrvalue0` smallint(6) NOT NULL DEFAULT '0',

  `attrtype1` tinyint(4) NOT NULL DEFAULT '0',

  `attrvalue1` smallint(6) NOT NULL DEFAULT '0',

  `attrtype2` tinyint(4) NOT NULL DEFAULT '0',

  `attrvalue2` smallint(6) NOT NULL DEFAULT '0',

  `attrtype3` tinyint(4) NOT NULL DEFAULT '0',

  `attrvalue3` smallint(6) NOT NULL DEFAULT '0',

  `attrtype4` tinyint(4) NOT NULL DEFAULT '0',

  `attrvalue4` smallint(6) NOT NULL DEFAULT '0',

  `attrtype5` tinyint(4) NOT NULL DEFAULT '0',

  `attrvalue5` smallint(6) NOT NULL DEFAULT '0',

  `attrtype6` tinyint(4) NOT NULL DEFAULT '0',

  `attrvalue6` smallint(6) NOT NULL DEFAULT '0',

  PRIMARY KEY (`id`),

  KEY `owner_id_idx` (`owner_id`),

  KEY `item_vnum_index` (`vnum`)

) ENGINE=MyISAM AUTO_INCREMENT=110000107 DEFAULT CHARSET=latin1;

 

-- ----------------------------

-- Table structure for item_attr

-- ----------------------------

DROP TABLE IF EXISTS `item_attr`;

CREATE TABLE `item_attr` (

  `apply` enum('MAX_HP','MAX_SP','CON','INT','STR','DEX','ATT_SPEED','MOV_SPEED','CAST_SPEED','HP_REGEN','SP_REGEN','POISON_PCT','STUN_PCT','SLOW_PCT','CRITICAL_PCT','PENETRATE_PCT','ATTBONUS_HUMAN','ATTBONUS_ANIMAL','ATTBONUS_ORC','ATTBONUS_MILGYO','ATTBONUS_UNDEAD','ATTBONUS_DEVIL','STEAL_HP','STEAL_SP','MANA_BURN_PCT','DAMAGE_SP_RECOVER','BLOCK','DODGE','RESIST_SWORD','RESIST_TWOHAND','RESIST_DAGGER','RESIST_BELL','RESIST_FAN','RESIST_BOW','RESIST_FIRE','RESIST_ELEC','RESIST_MAGIC','RESIST_WIND','REFLECT_MELEE','REFLECT_CURSE','POISON_REDUCE','KILL_SP_RECOVER','EXP_DOUBLE_BONUS','GOLD_DOUBLE_BONUS','ITEM_DROP_BONUS','POTION_BONUS','KILL_HP_RECOVER','IMMUNE_STUN','IMMUNE_SLOW','IMMUNE_FALL','SKILL','BOW_DISTANCE','ATT_GRADE_BONUS','DEF_GRADE_BONUS','MAGIC_ATT_GRADE','MAGIC_DEF_GRADE','CURSE_PCT','MAX_STAMINA','ATT_BONUS_TO_WARRIOR','ATT_BONUS_TO_ASSASSIN','ATT_BONUS_TO_SURA','ATT_BONUS_TO_SHAMAN','NORMAL_HIT_DEFEND_BONUS','SKILL_DEFEND_BONUS','NOUSE1','NOUSE2''NOUSE3','NOUSE4','NOUSE5','NOUSE6','NOUSE7','NOUSE8','NOUSE9','NOUSE10','NOUSE11','NOUSE12','NOUSE13','NOUSE14','RESIST_WARRIOR','RESIST_ASSASSIN','RESIST_SURA','RESIST_SHAMAN') NOT NULL DEFAULT 'MAX_HP',

  `prob` varchar(100) NOT NULL DEFAULT '',

  `lv1` varchar(100) NOT NULL DEFAULT '',

  `lv2` varchar(100) NOT NULL DEFAULT '',

  `lv3` varchar(100) NOT NULL DEFAULT '',

  `lv4` varchar(100) NOT NULL DEFAULT '',

  `lv5` varchar(100) NOT NULL DEFAULT '',

  `weapon` varchar(100) NOT NULL DEFAULT '',

  `body` varchar(100) NOT NULL DEFAULT '',

  `wrist` varchar(100) NOT NULL DEFAULT '',

  `foots` varchar(100) NOT NULL DEFAULT '',

  `neck` varchar(100) NOT NULL DEFAULT '',

  `head` varchar(100) NOT NULL DEFAULT '',

  `shield` varchar(100) NOT NULL DEFAULT '',

  `ear` varchar(100) NOT NULL DEFAULT ''

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

 

-- ----------------------------

-- Table structure for item_attr_rare

-- ----------------------------

DROP TABLE IF EXISTS `item_attr_rare`;

CREATE TABLE `item_attr_rare` (

  `apply` enum('MAX_HP','MAX_SP','CON','INT','STR','DEX','ATT_SPEED','MOV_SPEED','CAST_SPEED','HP_REGEN','SP_REGEN','POISON_PCT','STUN_PCT','SLOW_PCT','CRITICAL_PCT','PENETRATE_PCT','ATTBONUS_HUMAN','ATTBONUS_ANIMAL','ATTBONUS_ORC','ATTBONUS_MILGYO','ATTBONUS_UNDEAD','ATTBONUS_DEVIL','STEAL_HP','STEAL_SP','MANA_BURN_PCT','DAMAGE_SP_RECOVER','BLOCK','DODGE','RESIST_SWORD','RESIST_TWOHAND','RESIST_DAGGER','RESIST_BELL','RESIST_FAN','RESIST_BOW','RESIST_FIRE','RESIST_ELEC','RESIST_MAGIC','RESIST_WIND','REFLECT_MELEE','REFLECT_CURSE','POISON_REDUCE','KILL_SP_RECOVER','EXP_DOUBLE_BONUS','GOLD_DOUBLE_BONUS','ITEM_DROP_BONUS','POTION_BONUS','KILL_HP_RECOVER','IMMUNE_STUN','IMMUNE_SLOW','IMMUNE_FALL','SKILL','BOW_DISTANCE','ATT_GRADE_BONUS','DEF_GRADE_BONUS','MAGIC_ATT_GRADE','MAGIC_DEF_GRADE','CURSE_PCT','MAX_STAMINA','ATT_BONUS_TO_WARRIOR','ATT_BONUS_TO_ASSASSIN','ATT_BONUS_TO_SURA','ATT_BONUS_TO_SHAMAN','ATT_BONUS_TO_MONSTER','NORMAL_HIT_DEFEND_BONUS','SKILL_DEFEND_BONUS','NOUSE2''NOUSE3','NOUSE4','NOUSE5','NOUSE6','NOUSE7','NOUSE8','NOUSE9','NOUSE10','NOUSE11','NOUSE12','NOUSE13','NOUSE14','RESIST_WARRIOR','RESIST_ASSASSIN','RESIST_SURA','RESIST_SHAMAN') NOT NULL DEFAULT 'MAX_HP',

  `prob` varchar(100) NOT NULL DEFAULT '',

  `lv1` varchar(100) NOT NULL DEFAULT '',

  `lv2` varchar(100) NOT NULL DEFAULT '',

  `lv3` varchar(100) NOT NULL DEFAULT '',

  `lv4` varchar(100) NOT NULL DEFAULT '',

  `lv5` varchar(100) NOT NULL DEFAULT '',

  `weapon` varchar(100) NOT NULL DEFAULT '',

  `body` varchar(100) NOT NULL DEFAULT '',

  `wrist` varchar(100) NOT NULL DEFAULT '',

  `foots` varchar(100) NOT NULL DEFAULT '',

  `neck` varchar(100) NOT NULL DEFAULT '',

  `head` varchar(100) NOT NULL DEFAULT '',

  `shield` varchar(100) NOT NULL DEFAULT '',

  `ear` varchar(100) NOT NULL DEFAULT ''

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

 

-- ----------------------------

-- Table structure for item_award

-- ----------------------------

DROP TABLE IF EXISTS `item_award`;

CREATE TABLE `item_award` (

  `id` int(11) NOT NULL AUTO_INCREMENT,

  `pid` int(10) unsigned NOT NULL DEFAULT '0',

  `login` varchar(30) NOT NULL DEFAULT '',

  `vnum` int(6) unsigned NOT NULL DEFAULT '0',

  `count` int(10) unsigned NOT NULL DEFAULT '0',

  `given_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',

  `taken_time` datetime DEFAULT NULL,

  `item_id` int(11) DEFAULT NULL,

  `why` varchar(128) DEFAULT NULL,

  `socket0` int(11) NOT NULL DEFAULT '0',

  `socket1` int(11) NOT NULL DEFAULT '0',

  `socket2` int(11) NOT NULL DEFAULT '0',

  `mall` tinyint(1) NOT NULL DEFAULT '0',

  PRIMARY KEY (`id`),

  KEY `pid_idx` (`pid`),

  KEY `given_time_idx` (`given_time`),

  KEY `taken_time_idx` (`taken_time`)

) ENGINE=MyISAM AUTO_INCREMENT=60 DEFAULT CHARSET=latin1;

 

-- ----------------------------

-- Table structure for item_proto

-- ----------------------------

DROP TABLE IF EXISTS `item_proto`;

CREATE TABLE `item_proto` (

  `vnum` int(11) unsigned NOT NULL DEFAULT '0',

  `name` varchar(36) CHARACTER SET latin2 NOT NULL DEFAULT 'Noname',

  `locale_name` varbinary(36) NOT NULL DEFAULT 'Noname',

  `type` tinyint(2) NOT NULL DEFAULT '0',

  `subtype` tinyint(2) NOT NULL DEFAULT '0',

  `weight` tinyint(3) DEFAULT '0',

  `size` tinyint(3) DEFAULT '0',

  `antiflag` int(11) DEFAULT '0',

  `flag` int(11) DEFAULT '0',

  `wearflag` int(11) DEFAULT '0',

  `immuneflag` set('PARA','CURSE','STUN','SLEEP','SLOW','POISON','TERROR') NOT NULL DEFAULT '',

  `gold` int(11) DEFAULT '0',

  `shop_buy_price` int(10) unsigned NOT NULL DEFAULT '0',

  `refined_vnum` int(10) unsigned NOT NULL DEFAULT '0',

  `refine_set` smallint(11) unsigned NOT NULL DEFAULT '0',

  `refine_set2` smallint(5) unsigned NOT NULL DEFAULT '0',

  `magic_pct` tinyint(4) NOT NULL DEFAULT '0',

  `limittype0` tinyint(4) DEFAULT '0',

  `limitvalue0` int(11) DEFAULT '0',

  `limittype1` tinyint(4) DEFAULT '0',

  `limitvalue1` int(11) DEFAULT '0',

  `applytype0` tinyint(4) DEFAULT '0',

  `applyvalue0` int(11) DEFAULT '0',

  `applytype1` tinyint(4) DEFAULT '0',

  `applyvalue1` int(11) DEFAULT '0',

  `applytype2` tinyint(4) DEFAULT '0',

  `applyvalue2` int(11) DEFAULT '0',

  `value0` int(11) DEFAULT '0',

  `value1` int(11) DEFAULT '0',

  `value2` int(11) DEFAULT '0',

  `value3` int(11) DEFAULT '0',

  `value4` int(11) DEFAULT '0',

  `value5` int(11) DEFAULT '0',

  `socket0` tinyint(4) DEFAULT '-1',

  `socket1` tinyint(4) DEFAULT '-1',

  `socket2` tinyint(4) DEFAULT '-1',

  `socket3` tinyint(4) DEFAULT '-1',

  `socket4` tinyint(4) DEFAULT '-1',

  `socket5` tinyint(4) DEFAULT '-1',

  `specular` tinyint(4) NOT NULL DEFAULT '0',

  `socket_pct` tinyint(4) NOT NULL DEFAULT '0',

  `addon_type` smallint(6) NOT NULL DEFAULT '0',

  PRIMARY KEY (`vnum`),

  KEY `id` (`vnum`) USING BTREE

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

 

-- ----------------------------

-- Table structure for land

-- ----------------------------

DROP TABLE IF EXISTS `land`;

CREATE TABLE `land` (

  `id` int(11) NOT NULL AUTO_INCREMENT,

  `map_index` int(11) NOT NULL DEFAULT '0',

  `x` int(11) NOT NULL DEFAULT '0',

  `y` int(11) NOT NULL DEFAULT '0',

  `width` int(11) NOT NULL DEFAULT '0',

  `height` int(11) NOT NULL DEFAULT '0',

  `guild_id` int(10) unsigned NOT NULL DEFAULT '0',

  `guild_level_limit` tinyint(4) NOT NULL DEFAULT '0',

  `price` int(10) unsigned NOT NULL DEFAULT '0',

  `enable` enum('YES','NO') NOT NULL DEFAULT 'NO',

  PRIMARY KEY (`id`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

 

-- ----------------------------

-- Table structure for lotto_list

-- ----------------------------

DROP TABLE IF EXISTS `lotto_list`;

CREATE TABLE `lotto_list` (

  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,

  `server` varchar(20) DEFAULT NULL,

  `pid` int(10) unsigned DEFAULT NULL,

  `time` datetime DEFAULT NULL,

  PRIMARY KEY (`id`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

 

-- ----------------------------

-- Table structure for marriage

-- ----------------------------

DROP TABLE IF EXISTS `marriage`;

CREATE TABLE `marriage` (

  `is_married` tinyint(4) NOT NULL DEFAULT '1',

  `pid1` int(10) unsigned NOT NULL DEFAULT '0',

  `pid2` int(10) unsigned NOT NULL DEFAULT '0',

  `love_point` int(11) DEFAULT NULL,

  `time` int(10) unsigned NOT NULL DEFAULT '0',

  PRIMARY KEY (`is_married`,`pid1`,`pid2`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

 

-- ----------------------------

-- Table structure for messenger_list

-- ----------------------------

DROP TABLE IF EXISTS `messenger_list`;

CREATE TABLE `messenger_list` (

  `account` varchar(12) NOT NULL DEFAULT '',

  `companion` varchar(12) NOT NULL DEFAULT '',

  PRIMARY KEY (`account`,`companion`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

 

-- ----------------------------

-- Table structure for mob_proto

-- ----------------------------

DROP TABLE IF EXISTS `mob_proto`;

CREATE TABLE `mob_proto` (

  `vnum` int(11) NOT NULL DEFAULT '0',

  `name` varchar(24) CHARACTER SET latin1 NOT NULL DEFAULT 'Noname',

  `locale_name` varbinary(24) NOT NULL DEFAULT 'Noname',

  `rank` tinyint(2) NOT NULL DEFAULT '0',

  `type` tinyint(2) NOT NULL DEFAULT '0',

  `battle_type` tinyint(1) NOT NULL DEFAULT '0',

  `level` smallint(3) NOT NULL DEFAULT '1',

  `size` enum('SMALL','MEDIUM','BIG') CHARACTER SET latin1 NOT NULL DEFAULT 'SMALL',

  `ai_flag` set('AGGR','NOMOVE','COWARD','NOATTSHINSU','NOATTCHUNJO','NOATTJINNO','ATTMOB','BERSERK','STONESKIN','GODSPEED','DEATHBLOW','REVIVE') CHARACTER SET latin1 DEFAULT NULL,

  `mount_capacity` tinyint(2) NOT NULL DEFAULT '0',

  `setRaceFlag` set('ANIMAL','UNDEAD','DEVIL','HUMAN','ORC','MILGYO','INSECT','FIRE','ICE','DESERT') CHARACTER SET latin1 NOT NULL DEFAULT '',

  `setImmuneFlag` set('STUN','SLOW','FALL','CURSE','POISON','TERROR') CHARACTER SET latin1 NOT NULL DEFAULT '',

  `empire` tinyint(4) NOT NULL DEFAULT '0',

  `folder` varchar(100) CHARACTER SET latin1 NOT NULL DEFAULT '',

  `on_click` tinyint(4) NOT NULL DEFAULT '0',

  `st` smallint(5) unsigned NOT NULL DEFAULT '0',

  `dx` smallint(5) unsigned NOT NULL DEFAULT '0',

  `ht` smallint(5) unsigned NOT NULL DEFAULT '0',

  `iq` smallint(5) unsigned NOT NULL DEFAULT '0',

  `damage_min` smallint(5) unsigned NOT NULL DEFAULT '0',

  `damage_max` smallint(5) unsigned NOT NULL DEFAULT '0',

  `max_hp` int(10) unsigned NOT NULL DEFAULT '0',

  `regen_cycle` tinyint(3) unsigned NOT NULL DEFAULT '0',

  `regen_percent` tinyint(3) unsigned NOT NULL DEFAULT '0',

  `gold_min` int(11) NOT NULL DEFAULT '0',

  `gold_max` int(11) NOT NULL DEFAULT '0',

  `exp` int(10) unsigned NOT NULL DEFAULT '0',

  `def` smallint(5) unsigned NOT NULL DEFAULT '0',

  `attack_speed` smallint(6) unsigned NOT NULL DEFAULT '100',

  `move_speed` smallint(6) unsigned NOT NULL DEFAULT '100',

  `aggressive_hp_pct` tinyint(3) unsigned NOT NULL DEFAULT '0',

  `aggressive_sight` smallint(10) unsigned NOT NULL DEFAULT '0',

  `attack_range` smallint(5) unsigned NOT NULL DEFAULT '0',

  `drop_item` int(10) unsigned NOT NULL DEFAULT '0',

  `resurrection_vnum` int(10) unsigned NOT NULL DEFAULT '0',

  `enchant_curse` tinyint(4) unsigned NOT NULL DEFAULT '0',

  `enchant_slow` tinyint(4) unsigned NOT NULL DEFAULT '0',

  `enchant_poison` tinyint(4) unsigned NOT NULL DEFAULT '0',

  `enchant_stun` tinyint(3) unsigned NOT NULL DEFAULT '0',

  `enchant_critical` tinyint(3) unsigned NOT NULL DEFAULT '0',

  `enchant_penetrate` tinyint(3) unsigned NOT NULL DEFAULT '0',

  `resist_sword` tinyint(4) NOT NULL DEFAULT '0',

  `resist_twohand` tinyint(4) NOT NULL DEFAULT '0',

  `resist_dagger` tinyint(4) NOT NULL DEFAULT '0',

  `resist_bell` tinyint(4) NOT NULL DEFAULT '0',

  `resist_fan` tinyint(4) NOT NULL DEFAULT '0',

  `resist_bow` tinyint(4) NOT NULL DEFAULT '0',

  `resist_fire` tinyint(4) NOT NULL DEFAULT '0',

  `resist_elect` tinyint(4) NOT NULL DEFAULT '0',

  `resist_magic` tinyint(4) NOT NULL DEFAULT '0',

  `resist_wind` tinyint(4) NOT NULL DEFAULT '0',

  `resist_poison` tinyint(4) NOT NULL DEFAULT '0',

  `dam_multiply` float DEFAULT NULL,

  `summon` int(11) DEFAULT NULL,

  `drain_sp` int(11) DEFAULT NULL,

  `mob_color` int(10) unsigned DEFAULT NULL,

  `polymorph_item` int(10) unsigned NOT NULL DEFAULT '0',

  `skill_level0` tinyint(3) unsigned DEFAULT NULL,

  `skill_vnum0` int(10) unsigned DEFAULT NULL,

  `skill_level1` tinyint(3) unsigned DEFAULT NULL,

  `skill_vnum1` int(10) unsigned DEFAULT NULL,

  `skill_level2` tinyint(3) unsigned DEFAULT NULL,

  `skill_vnum2` int(10) unsigned DEFAULT NULL,

  `skill_level3` tinyint(3) unsigned DEFAULT NULL,

  `skill_vnum3` int(10) unsigned DEFAULT NULL,

  `skill_level4` tinyint(3) unsigned DEFAULT NULL,

  `skill_vnum4` int(10) unsigned DEFAULT NULL,

  `sp_berserk` tinyint(4) NOT NULL DEFAULT '0',

  `sp_stoneskin` tinyint(4) NOT NULL DEFAULT '0',

  `sp_godspeed` tinyint(4) NOT NULL DEFAULT '0',

  `sp_deathblow` tinyint(4) NOT NULL DEFAULT '0',

  `sp_revive` tinyint(4) NOT NULL DEFAULT '0',

  PRIMARY KEY (`vnum`)

) ENGINE=MyISAM DEFAULT CHARSET=latin2 COLLATE=latin2_bin;

 

 

-- ----------------------------

-- Table structure for monarch

-- ----------------------------

DROP TABLE IF EXISTS `monarch`;

CREATE TABLE `monarch` (

  `empire` int(10) unsigned NOT NULL DEFAULT '0',

  `pid` int(10) unsigned DEFAULT NULL,

  `windate` datetime DEFAULT NULL,

  `money` bigint(20) unsigned DEFAULT NULL,

  PRIMARY KEY (`empire`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

 

-- ----------------------------

-- Table structure for monarch_candidacy

-- ----------------------------

DROP TABLE IF EXISTS `monarch_candidacy`;

CREATE TABLE `monarch_candidacy` (

  `pid` int(10) unsigned NOT NULL DEFAULT '0',

  `name` varchar(16) DEFAULT NULL,

  `date` datetime DEFAULT '0000-00-00 00:00:00',

  `windate` datetime DEFAULT NULL,

  PRIMARY KEY (`pid`)

) ENGINE=MyISAM DEFAULT CHARSET=big5;

 

-- ----------------------------

-- Table structure for monarch_election

-- ----------------------------

DROP TABLE IF EXISTS `monarch_election`;

CREATE TABLE `monarch_election` (

  `pid` int(10) unsigned NOT NULL DEFAULT '0',

  `selectedpid` int(10) unsigned DEFAULT '0',

  `electiondata` datetime DEFAULT '0000-00-00 00:00:00',

  PRIMARY KEY (`pid`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

 

-- ----------------------------

-- Table structure for myshop_pricelist

-- ----------------------------

DROP TABLE IF EXISTS `myshop_pricelist`;

CREATE TABLE `myshop_pricelist` (

  `owner_id` int(11) unsigned NOT NULL DEFAULT '0',

  `item_vnum` int(11) unsigned NOT NULL DEFAULT '0',

  `price` int(10) unsigned NOT NULL DEFAULT '0',

  UNIQUE KEY `list_id` (`owner_id`,`item_vnum`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

 

-- ----------------------------

-- Table structure for object

-- ----------------------------

DROP TABLE IF EXISTS `object`;

CREATE TABLE `object` (

  `id` int(11) NOT NULL AUTO_INCREMENT,

  `land_id` int(11) NOT NULL DEFAULT '0',

  `vnum` int(10) unsigned NOT NULL DEFAULT '0',

  `map_index` int(11) NOT NULL DEFAULT '0',

  `x` int(11) NOT NULL DEFAULT '0',

  `y` int(11) NOT NULL DEFAULT '0',

  `x_rot` float NOT NULL DEFAULT '0',

  `y_rot` float NOT NULL DEFAULT '0',

  `z_rot` float NOT NULL DEFAULT '0',

  `life` int(11) NOT NULL DEFAULT '0',

  PRIMARY KEY (`id`)

) ENGINE=MyISAM AUTO_INCREMENT=175 DEFAULT CHARSET=latin1;

 

-- ----------------------------

-- Table structure for object_proto

-- ----------------------------

DROP TABLE IF EXISTS `object_proto`;

CREATE TABLE `object_proto` (

  `vnum` int(10) unsigned NOT NULL DEFAULT '0',

  `name` varchar(32) NOT NULL DEFAULT '',

  `price` int(10) unsigned NOT NULL DEFAULT '0',

  `materials` varchar(64) NOT NULL DEFAULT '',

  `upgrade_vnum` int(10) unsigned NOT NULL DEFAULT '0',

  `upgrade_limit_time` int(10) unsigned NOT NULL DEFAULT '0',

  `life` int(11) NOT NULL DEFAULT '0',

  `reg_1` int(11) NOT NULL DEFAULT '0',

  `reg_2` int(11) NOT NULL DEFAULT '0',

  `reg_3` int(11) NOT NULL DEFAULT '0',

  `reg_4` int(11) NOT NULL DEFAULT '0',

  `npc` int(10) unsigned NOT NULL DEFAULT '0',

  `group_vnum` int(10) unsigned NOT NULL DEFAULT '0',

  `dependent_group` int(10) unsigned NOT NULL DEFAULT '0',

  PRIMARY KEY (`vnum`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

 

-- ----------------------------

-- Table structure for pcbang_ip

-- ----------------------------

DROP TABLE IF EXISTS `pcbang_ip`;

CREATE TABLE `pcbang_ip` (

  `id` int(11) NOT NULL AUTO_INCREMENT,

  `pcbang_id` int(11) NOT NULL DEFAULT '0',

  `ip` varchar(15) NOT NULL DEFAULT '000.000.000.000',

  PRIMARY KEY (`id`),

  UNIQUE KEY `ip` (`ip`),

  KEY `pcbang_id` (`pcbang_id`)

) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

 

-- ----------------------------

-- Table structure for player

-- ----------------------------

DROP TABLE IF EXISTS `player`;

CREATE TABLE `player` (

  `id` int(11) NOT NULL AUTO_INCREMENT,

  `account_id` int(11) NOT NULL DEFAULT '0',

  `name` varchar(18) CHARACTER SET big5 NOT NULL DEFAULT 'NONAME',

  `job` tinyint(2) unsigned NOT NULL DEFAULT '0',

  `voice` tinyint(1) unsigned NOT NULL DEFAULT '0',

  `dir` tinyint(2) NOT NULL DEFAULT '0',

  `x` int(11) NOT NULL DEFAULT '0',

  `y` int(11) NOT NULL DEFAULT '0',

  `z` int(11) NOT NULL DEFAULT '0',

  `map_index` int(11) NOT NULL DEFAULT '0',

  `exit_x` int(11) NOT NULL DEFAULT '0',

  `exit_y` int(11) NOT NULL DEFAULT '0',

  `exit_map_index` int(11) NOT NULL DEFAULT '0',

  `hp` smallint(4) unsigned NOT NULL DEFAULT '0',

  `mp` smallint(4) unsigned NOT NULL DEFAULT '0',

  `stamina` smallint(6) unsigned NOT NULL DEFAULT '0',

  `random_hp` smallint(5) unsigned NOT NULL DEFAULT '0',

  `random_sp` smallint(5) unsigned NOT NULL DEFAULT '0',

  `playtime` int(11) NOT NULL DEFAULT '0',

  `level` tinyint(2) unsigned NOT NULL DEFAULT '0',

  `level_step` tinyint(1) NOT NULL DEFAULT '0',

  `st` smallint(3) NOT NULL DEFAULT '0',

  `ht` smallint(3) NOT NULL DEFAULT '0',

  `dx` smallint(3) NOT NULL DEFAULT '0',

  `iq` smallint(3) NOT NULL DEFAULT '0',

  `exp` int(11) unsigned NOT NULL DEFAULT '0',

  `gold` int(50) unsigned NOT NULL DEFAULT '0',

  `stat_point` smallint(3) NOT NULL DEFAULT '0',

  `skill_point` smallint(3) NOT NULL DEFAULT '0',

  `quickslot` tinyblob,

  `ip` varchar(16) CHARACTER SET big5 DEFAULT '0.0.0.0',

  `part_main` smallint(6) NOT NULL DEFAULT '0',

  `part_base` tinyint(4) NOT NULL DEFAULT '0',

  `part_hair` smallint(4) NOT NULL DEFAULT '0',

  `skill_group` tinyint(4) NOT NULL DEFAULT '0',

  `skill_level` blob,

  `alignment` int(11) NOT NULL DEFAULT '0',

  `last_play` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',

  `change_name` tinyint(1) NOT NULL DEFAULT '0',

  `mobile` varchar(12) CHARACTER SET big5 DEFAULT '',

  `sub_skill_point` smallint(3) NOT NULL DEFAULT '0',

  `stat_reset_count` tinyint(4) NOT NULL DEFAULT '0',

  `horse_hp` smallint(4) NOT NULL DEFAULT '0',

  `horse_stamina` smallint(4) NOT NULL DEFAULT '0',

  `horse_level` tinyint(2) unsigned NOT NULL DEFAULT '0',

  `horse_hp_droptime` int(10) unsigned NOT NULL DEFAULT '0',

  `horse_riding` tinyint(1) NOT NULL DEFAULT '0',

  `horse_skill_point` smallint(3) NOT NULL DEFAULT '0',

  `admin` tinyint(2) NOT NULL,

  `usunieta` tinyint(2) NOT NULL,

  `isAdmin` tinyint(2) NOT NULL,

  PRIMARY KEY (`id`),

  UNIQUE KEY `name` (`name`),

  KEY `account_id_idx` (`account_id`)

) ENGINE=MyISAM AUTO_INCREMENT=17 DEFAULT CHARSET=latin1;

 

-- ----------------------------

-- Table structure for player_deleted

-- ----------------------------

DROP TABLE IF EXISTS `player_deleted`;

CREATE TABLE `player_deleted` (

  `id` int(11) NOT NULL AUTO_INCREMENT,

  `account_id` int(11) NOT NULL DEFAULT '0',

  `name` varchar(18) CHARACTER SET big5 NOT NULL DEFAULT 'NONAME',

  `job` tinyint(2) unsigned NOT NULL DEFAULT '0',

  `voice` tinyint(1) unsigned NOT NULL DEFAULT '0',

  `dir` tinyint(2) NOT NULL DEFAULT '0',

  `x` int(11) NOT NULL DEFAULT '0',

  `y` int(11) NOT NULL DEFAULT '0',

  `z` int(11) NOT NULL DEFAULT '0',

  `map_index` int(11) NOT NULL DEFAULT '0',

  `exit_x` int(11) NOT NULL DEFAULT '0',

  `exit_y` int(11) NOT NULL DEFAULT '0',

  `exit_map_index` int(11) NOT NULL DEFAULT '0',

  `hp` smallint(4) NOT NULL DEFAULT '0',

  `mp` smallint(4) NOT NULL DEFAULT '0',

  `stamina` smallint(6) NOT NULL DEFAULT '0',

  `random_hp` smallint(5) unsigned NOT NULL DEFAULT '0',

  `random_sp` smallint(5) unsigned NOT NULL DEFAULT '0',

  `playtime` int(11) NOT NULL DEFAULT '0',

  `level` tinyint(2) unsigned NOT NULL DEFAULT '0',

  `level_step` tinyint(1) NOT NULL DEFAULT '0',

  `st` smallint(3) NOT NULL DEFAULT '0',

  `ht` smallint(3) NOT NULL DEFAULT '0',

  `dx` smallint(3) NOT NULL DEFAULT '0',

  `iq` smallint(3) NOT NULL DEFAULT '0',

  `exp` int(11) NOT NULL DEFAULT '0',

  `gold` int(50) NOT NULL DEFAULT '0',

  `stat_point` smallint(3) NOT NULL DEFAULT '0',

  `skill_point` smallint(3) NOT NULL DEFAULT '0',

  `quickslot` tinyblob,

  `ip` varchar(16) CHARACTER SET big5 DEFAULT '0.0.0.0',

  `part_main` smallint(6) NOT NULL DEFAULT '0',

  `part_base` tinyint(4) NOT NULL DEFAULT '0',

  `part_hair` smallint(4) NOT NULL DEFAULT '0',

  `skill_group` tinyint(4) NOT NULL DEFAULT '0',

  `skill_level` blob,

  `alignment` int(11) NOT NULL DEFAULT '0',

  `last_play` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',

  `change_name` tinyint(1) NOT NULL DEFAULT '0',

  `mobile` varchar(12) CHARACTER SET big5 DEFAULT '',

  `sub_skill_point` smallint(3) NOT NULL DEFAULT '0',

  `stat_reset_count` tinyint(4) NOT NULL DEFAULT '0',

  `horse_hp` smallint(4) NOT NULL DEFAULT '0',

  `horse_stamina` smallint(4) NOT NULL DEFAULT '0',

  `horse_level` tinyint(2) unsigned NOT NULL DEFAULT '30',

  `horse_hp_droptime` int(10) unsigned NOT NULL DEFAULT '0',

  `horse_riding` tinyint(1) NOT NULL DEFAULT '0',

  `horse_skill_point` smallint(3) NOT NULL DEFAULT '0',

  `admin` tinyint(2) NOT NULL,

  `usunieta` tinyint(2) NOT NULL,

  `isAdmin` tinyint(2) NOT NULL,

  PRIMARY KEY (`id`),

  UNIQUE KEY `name` (`name`),

  KEY `account_id_idx` (`account_id`)

) ENGINE=MyISAM AUTO_INCREMENT=16 DEFAULT CHARSET=latin1;

 

-- ----------------------------

-- Table structure for player_index

-- ----------------------------

DROP TABLE IF EXISTS `player_index`;

CREATE TABLE `player_index` (

  `id` int(11) NOT NULL DEFAULT '0',

  `pid1` int(11) NOT NULL DEFAULT '0',

  `pid2` int(11) NOT NULL DEFAULT '0',

  `pid3` int(11) NOT NULL DEFAULT '0',

  `pid4` int(11) NOT NULL DEFAULT '0',

  `empire` tinyint(4) NOT NULL DEFAULT '0',

  PRIMARY KEY (`id`),

  KEY `pid1_key` (`pid1`),

  KEY `pid2_key` (`pid2`),

  KEY `pid3_key` (`pid3`),

  KEY `pid4_key` (`pid4`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

 

-- ----------------------------

-- Table structure for quest

-- ----------------------------

DROP TABLE IF EXISTS `quest`;

CREATE TABLE `quest` (

  `dwPID` int(10) unsigned NOT NULL DEFAULT '0',

  `szName` varchar(32) NOT NULL DEFAULT '',

  `szState` varchar(64) NOT NULL DEFAULT '',

  `lValue` varchar(11) NOT NULL DEFAULT '0',

  PRIMARY KEY (`dwPID`,`szName`,`szState`),

  KEY `pid_idx` (`dwPID`),

  KEY `name_idx` (`szName`),

  KEY `state_idx` (`szState`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

 

-- ----------------------------

-- Table structure for refine_proto

-- ----------------------------

DROP TABLE IF EXISTS `refine_proto`;

CREATE TABLE `refine_proto` (

  `id` int(11) NOT NULL AUTO_INCREMENT,

  `vnum0` int(10) unsigned NOT NULL DEFAULT '0',

  `count0` smallint(6) NOT NULL DEFAULT '0',

  `vnum1` int(10) unsigned NOT NULL DEFAULT '0',

  `count1` smallint(6) NOT NULL DEFAULT '0',

  `vnum2` int(10) unsigned NOT NULL DEFAULT '0',

  `count2` smallint(6) NOT NULL DEFAULT '0',

  `vnum3` int(10) unsigned NOT NULL DEFAULT '0',

  `count3` smallint(6) NOT NULL DEFAULT '0',

  `vnum4` int(10) unsigned NOT NULL DEFAULT '0',

  `count4` smallint(6) NOT NULL DEFAULT '0',

  `cost` int(11) NOT NULL DEFAULT '0',

  `src_vnum` int(10) unsigned NOT NULL DEFAULT '0',

  `result_vnum` int(10) unsigned NOT NULL DEFAULT '0',

  `prob` smallint(6) NOT NULL DEFAULT '100',

  PRIMARY KEY (`id`)

) ENGINE=MyISAM AUTO_INCREMENT=703 DEFAULT CHARSET=latin1;

 

-- ----------------------------

-- Table structure for safebox

-- ----------------------------

DROP TABLE IF EXISTS `safebox`;

CREATE TABLE `safebox` (

  `account_id` int(10) unsigned NOT NULL DEFAULT '0',

  `size` tinyint(3) unsigned NOT NULL DEFAULT '0',

  `password` varchar(6) NOT NULL DEFAULT '',

  `gold` int(11) NOT NULL DEFAULT '0',

  PRIMARY KEY (`account_id`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

 

-- ----------------------------

-- Table structure for shop

-- ----------------------------

DROP TABLE IF EXISTS `shop`;

CREATE TABLE `shop` (

  `vnum` int(11) NOT NULL DEFAULT '0',

  `name` varchar(32) NOT NULL DEFAULT 'Noname',

  `npc_vnum` mediumint(6) NOT NULL DEFAULT '0',

  PRIMARY KEY (`vnum`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

 

-- ----------------------------

-- Table structure for shop_class

-- ----------------------------

DROP TABLE IF EXISTS `shop_class`;

CREATE TABLE `shop_class` (

  `classid` int(11) NOT NULL AUTO_INCREMENT,

  `classname` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,

  PRIMARY KEY (`classid`)

) ENGINE=MyISAM AUTO_INCREMENT=14 DEFAULT CHARSET=big5;

 

-- ----------------------------

-- Table structure for shop_item

-- ----------------------------

DROP TABLE IF EXISTS `shop_item`;

CREATE TABLE `shop_item` (

  `shop_vnum` int(11) NOT NULL DEFAULT '0',

  `item_vnum` int(11) NOT NULL DEFAULT '0',

  `count` tinyint(4) unsigned NOT NULL DEFAULT '1',

  KEY `vnum_unique` (`shop_vnum`,`item_vnum`,`count`) USING BTREE

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

 

-- ----------------------------

-- Table structure for skill_proto

-- ----------------------------

DROP TABLE IF EXISTS `skill_proto`;

CREATE TABLE `skill_proto` (

  `dwVnum` int(11) NOT NULL DEFAULT '0',

  `szName` varbinary(32) NOT NULL DEFAULT '',

  `bType` tinyint(4) NOT NULL DEFAULT '0',

  `bLevelStep` tinyint(4) NOT NULL DEFAULT '0',

  `bMaxLevel` tinyint(4) NOT NULL DEFAULT '0',

  `bLevelLimit` tinyint(3) unsigned NOT NULL DEFAULT '0',

  `szPointOn` varchar(100) NOT NULL DEFAULT '0',

  `szPointPoly` varchar(100) NOT NULL DEFAULT '',

  `szSPCostPoly` varchar(100) NOT NULL DEFAULT '',

  `szDurationPoly` varchar(100) NOT NULL DEFAULT '',

  `szDurationSPCostPoly` varchar(100) NOT NULL DEFAULT '',

  `szCooldownPoly` varchar(100) NOT NULL DEFAULT '',

  `szMasterBonusPoly` varchar(100) NOT NULL DEFAULT '',

  `szAttackGradePoly` varchar(100) NOT NULL DEFAULT '',

  `setFlag` set('ATTACK','USE_MELEE_DAMAGE','COMPUTE_ATTGRADE','SELFONLY','USE_MAGIC_DAMAGE','USE_HP_AS_COST','COMPUTE_MAGIC_DAMAGE','SPLASH','GIVE_PENALTY','USE_ARROW_DAMAGE','PENETRATE','IGNORE_TARGET_RATING','ATTACK_SLOW','ATTACK_STUN','HP_ABSORB','SP_ABSORB','ATTACK_FIRE_CONT','REMOVE_BAD_AFFECT','REMOVE_GOOD_AFFECT','CRUSH','ATTACK_POISON','TOGGLE','DISABLE_BY_POINT_UP','CRUSH_LONG') DEFAULT NULL,

  `setAffectFlag` enum('YMIR','INVISIBILITY','SPAWN','POISON','SLOW','STUN','DUNGEON_READY','FORCE_VISIBLE','BUILDING_CONSTRUCTION_SMALL','BUILDING_CONSTRUCTION_LARGE','BUILDING_UPGRADE','MOV_SPEED_POTION','ATT_SPEED_POTION','FISH_MIDE','JEONGWIHON','GEOMGYEONG','CHEONGEUN','GYEONGGONG','EUNHYUNG','GWIGUM','TERROR','JUMAGAP','HOSIN','BOHO','KWAESOK','MANASHIELD','MUYEONG','REVIVE_INVISIBLE','FIRE','GICHEON','JEUNGRYEOK') NOT NULL DEFAULT 'YMIR',

  `szPointOn2` varchar(100) NOT NULL DEFAULT 'NONE',

  `szPointPoly2` varchar(100) NOT NULL DEFAULT '',

  `szDurationPoly2` varchar(100) NOT NULL DEFAULT '',

  `setAffectFlag2` enum('YMIR','INVISIBILITY','SPAWN','POISON','SLOW','STUN','DUNGEON_READY','FORCE_VISIBLE','BUILDING_CONSTRUCTION_SMALL','BUILDING_CONSTRUCTION_LARGE','BUILDING_UPGRADE','MOV_SPEED_POTION','ATT_SPEED_POTION','FISH_MIDE','JEONGWIHON','GEOMGYEONG','CHEONGEUN','GYEONGGONG','EUNHYUNG','GWIGUM','TERROR','JUMAGAP','HOSIN','BOHO','KWAESOK','MANASHIELD') NOT NULL DEFAULT 'YMIR',

  `szPointOn3` varchar(100) NOT NULL DEFAULT 'NONE',

  `szPointPoly3` varchar(100) NOT NULL DEFAULT '',

  `szDurationPoly3` varchar(100) NOT NULL DEFAULT '',

  `szGrandMasterAddSPCostPoly` varchar(100) NOT NULL DEFAULT '',

  `prerequisiteSkillVnum` int(11) NOT NULL DEFAULT '0',

  `prerequisiteSkillLevel` int(11) NOT NULL DEFAULT '0',

  `eSkillType` enum('NORMAL','MELEE','RANGE','MAGIC') NOT NULL DEFAULT 'NORMAL',

  `iMaxHit` tinyint(4) NOT NULL DEFAULT '0',

  `szSplashAroundDamageAdjustPoly` varchar(100) NOT NULL DEFAULT '1',

  `dwTargetRange` int(11) NOT NULL DEFAULT '1000',

  `dwSplashRange` int(10) unsigned NOT NULL DEFAULT '0',

  PRIMARY KEY (`dwVnum`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

 

-- ----------------------------

-- Table structure for sms_pool

-- ----------------------------

DROP TABLE IF EXISTS `sms_pool`;

CREATE TABLE `sms_pool` (

  `id` int(11) NOT NULL AUTO_INCREMENT,

  `server` int(11) NOT NULL DEFAULT '0',

  `sender` varchar(32) DEFAULT NULL,

  `receiver` varchar(100) NOT NULL DEFAULT '',

  `mobile` varchar(32) DEFAULT NULL,

  `sent` enum('N','Y') NOT NULL DEFAULT 'N',

  `msg` varchar(80) DEFAULT NULL,

  PRIMARY KEY (`id`),

  KEY `sent_idx` (`sent`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

 

-- ----------------------------

-- Table structure for string

-- ----------------------------

DROP TABLE IF EXISTS `string`;

CREATE TABLE `string` (

  `name` varchar(64) NOT NULL DEFAULT '',

  `text` text,

  PRIMARY KEY (`name`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1;


 




SET FOREIGN_KEY_CHECKS=0;

 

-- ----------------------------

-- Table structure for account

-- ----------------------------

DROP TABLE IF EXISTS `account`;

CREATE TABLE `account` (

  `id` int(11) NOT NULL AUTO_INCREMENT,

  `login` varchar(30) NOT NULL DEFAULT '',

  `password` varchar(45) NOT NULL DEFAULT '',

  `real_name` varchar(16) NOT NULL DEFAULT '',

  `social_id` varchar(7) NOT NULL DEFAULT '',

  `email` varchar(64) NOT NULL DEFAULT '',

  `phone1` varchar(16) NOT NULL,

  `phone2` varchar(16) NOT NULL,

  `address` varchar(128) NOT NULL,

  `zipcode` varchar(7) NOT NULL DEFAULT '',

  `create_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',

  `question1` varchar(48) CHARACTER SET utf8 COLLATE utf8_polish_ci NOT NULL,

  `answer1` varchar(48) NOT NULL,

  `question2` varchar(48) NOT NULL,

  `answer2` varchar(48) CHARACTER SET utf8 COLLATE utf8_polish_ci NOT NULL,

  `is_testor` tinyint(1) NOT NULL DEFAULT '0',

  `status` varchar(8) NOT NULL DEFAULT 'OK',

  `banlength` enum('SECOND','MINUTE','HOUR','DAY','WEEK','MONTH','YEAR','PERM') NOT NULL,

  `bantime` int(10) NOT NULL,

  `baned` varchar(50) NOT NULL,

  `securitycode` varchar(192) NOT NULL DEFAULT '',

  `newsletter` tinyint(1) NOT NULL DEFAULT '0',

  `empire` tinyint(4) NOT NULL DEFAULT '0',

  `name_checked` tinyint(1) NOT NULL DEFAULT '0',

  `availDt` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',

  `mileage` int(11) NOT NULL DEFAULT '0',

  `cash` int(11) NOT NULL DEFAULT '0',

  `gold_expire` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',

  `silver_expire` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',

  `safebox_expire` datetime NOT NULL DEFAULT '2017-01-01 19:00:00',

  `autoloot_expire` datetime NOT NULL DEFAULT '2017-01-01 19:00:00',

  `fish_mind_expire` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',

  `marriage_fast_expire` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',

  `money_drop_rate_expire` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',

  `ttl_cash` int(11) NOT NULL DEFAULT '0',

  `ttl_mileage` int(11) NOT NULL DEFAULT '0',

  `channel_company` varchar(30) NOT NULL DEFAULT '',

  `powod` varchar(100) NOT NULL,

  `do` date NOT NULL,

  `grupa` varchar(200) NOT NULL,

  `admin` varchar(22) NOT NULL,

  `page_access` tinyint(1) unsigned NOT NULL DEFAULT '0',

  `ban_expire` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',

  `referer` int(11) NOT NULL,

  `last_play` datetime DEFAULT NULL,

  `new_email` varchar(64) DEFAULT NULL,

  `key` varchar(64) DEFAULT NULL,

  `flags` int(11) NOT NULL DEFAULT '0',

  `key_expire` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',

  `vip_expire` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',

  `site_exhaust` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',

  PRIMARY KEY (`id`),

  UNIQUE KEY `login` (`login`),

  KEY `social_id` (`social_id`)

) ENGINE=MyISAM AUTO_INCREMENT=12 DEFAULT CHARSET=big5;

 

-- ----------------------------

-- Table structure for account_baq

-- ----------------------------

DROP TABLE IF EXISTS `account_baq`;

CREATE TABLE `account_baq` (

  `id` int(11) NOT NULL AUTO_INCREMENT,

  `login` varchar(30) CHARACTER SET ascii NOT NULL DEFAULT '',

  `password` varchar(45) CHARACTER SET ascii NOT NULL DEFAULT '',

  `real_name` varchar(16) CHARACTER SET ascii DEFAULT '',

  `social_id` varchar(13) CHARACTER SET ascii NOT NULL DEFAULT '',

  `email` varchar(64) CHARACTER SET ascii NOT NULL DEFAULT '',

  `phone1` varchar(16) CHARACTER SET ascii DEFAULT NULL,

  `phone2` varchar(16) CHARACTER SET ascii DEFAULT NULL,

  `address` varchar(128) CHARACTER SET ascii DEFAULT NULL,

  `zipcode` varchar(7) CHARACTER SET ascii DEFAULT '',

  `create_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',

  `question1` varchar(48) CHARACTER SET ascii DEFAULT NULL,

  `answer1` varchar(48) CHARACTER SET ascii DEFAULT NULL,

  `question2` varchar(48) CHARACTER SET ascii DEFAULT NULL,

  `answer2` varchar(48) CHARACTER SET ascii DEFAULT NULL,

  `is_testor` tinyint(1) NOT NULL DEFAULT '0',

  `status` varchar(8) CHARACTER SET ascii NOT NULL DEFAULT 'OK',

  `securitycode` varchar(192) CHARACTER SET ascii DEFAULT '',

  `newsletter` tinyint(1) DEFAULT '0',

  `empire` tinyint(4) NOT NULL DEFAULT '0',

  `name_checked` tinyint(1) NOT NULL DEFAULT '0',

  `availDt` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',

  `mileage` int(11) NOT NULL DEFAULT '0',

  `cash` int(11) NOT NULL DEFAULT '0',

  `gold_expire` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',

  `silver_expire` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',

  `safebox_expire` datetime NOT NULL DEFAULT '2020-01-01 01:00:00',

  `autoloot_expire` datetime DEFAULT '2020-01-01 01:00:00',

  `fish_mind_expire` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',

  `marriage_fast_expire` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',

  `money_drop_rate_expire` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',

  `ttl_cash` int(11) NOT NULL DEFAULT '0',

  `ttl_mileage` int(11) NOT NULL DEFAULT '0',

  `channel_company` varchar(30) CHARACTER SET ascii NOT NULL DEFAULT '',

  `last_play` datetime NOT NULL,

  `coins` int(11) NOT NULL DEFAULT '0',

  `web_admin` int(1) NOT NULL DEFAULT '0',

  `web_ip` varchar(15) CHARACTER SET ascii NOT NULL,

  `web_aktiviert` varchar(32) CHARACTER SET ascii NOT NULL,

  `coin` int(11) NOT NULL,

  `checksum` varchar(50) COLLATE utf8_polish_ci NOT NULL,

  PRIMARY KEY (`id`),

  UNIQUE KEY `login` (`login`),

  KEY `social_id` (`social_id`)

) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_polish_ci;

 

-- ----------------------------

-- Table structure for block_exception

-- ----------------------------

DROP TABLE IF EXISTS `block_exception`;

CREATE TABLE `block_exception` (

  `login` int(11) DEFAULT NULL

) ENGINE=MyISAM DEFAULT CHARSET=big5;

 

 

-- ----------------------------

-- Table structure for gmhost

-- ----------------------------

DROP TABLE IF EXISTS `gmhost`;

CREATE TABLE `gmhost` (

  `mIP` varchar(16) NOT NULL DEFAULT '',

  PRIMARY KEY (`mIP`)

) ENGINE=MyISAM DEFAULT CHARSET=big5;

 

-- ----------------------------

-- Table structure for gmlist

-- ----------------------------

DROP TABLE IF EXISTS `gmlist`;

CREATE TABLE `gmlist` (

  `mID` int(10) unsigned NOT NULL AUTO_INCREMENT,

  `mAccount` varchar(16) NOT NULL DEFAULT '',

  `mName` varchar(16) NOT NULL DEFAULT '',

  `mContactIP` varchar(16) NOT NULL DEFAULT '',

  `mServerIP` varchar(16) NOT NULL DEFAULT 'ALL',

  `mAuthority` enum('IMPLEMENTOR','HIGH_WIZARD','GOD','LOW_WIZARD','PLAYER') DEFAULT 'PLAYER',

  PRIMARY KEY (`mID`)

) ENGINE=MyISAM AUTO_INCREMENT=69019168 DEFAULT CHARSET=big5;

 

-- ----------------------------

-- Table structure for iptocountry

-- ----------------------------

DROP TABLE IF EXISTS `iptocountry`;

CREATE TABLE `iptocountry` (

  `IP_FROM` varchar(16) DEFAULT NULL,

  `IP_TO` varchar(16) DEFAULT NULL,

  `COUNTRY_NAME` varchar(16) DEFAULT NULL

) ENGINE=MyISAM DEFAULT CHARSET=big5;

 

-- ----------------------------

-- Table structure for locale

-- ----------------------------

DROP TABLE IF EXISTS `locale`;

CREATE TABLE `locale` (

  `mKey` varchar(255) NOT NULL DEFAULT '',

  `mValue` varchar(255) NOT NULL DEFAULT '',

  PRIMARY KEY (`mKey`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

 

-- ----------------------------

-- Table structure for locale_bug

-- ----------------------------

DROP TABLE IF EXISTS `locale_bug`;

CREATE TABLE `locale_bug` (

  `mKey` varchar(255) NOT NULL DEFAULT '',

  `mValue` varchar(255) NOT NULL DEFAULT '',

  PRIMARY KEY (`mKey`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

 

 

-- ----------------------------

-- Table structure for spam_db

-- ----------------------------

DROP TABLE IF EXISTS `spam_db`;

CREATE TABLE `spam_db` (

  `type` set('GOOD','SPAM') NOT NULL DEFAULT 'SPAM',

  `word` varchar(256) NOT NULL,

  `score` int(11) NOT NULL DEFAULT '10',

  PRIMARY KEY (`word`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1;


 




/*

Navicat MySQL Data Transfer

 

Source Server         : test

Source Server Version : 50535

Source Host           : ***

Source Database       : common

 

Target Server Type    : MYSQL

Target Server Version : 50535

File Encoding         : 65001

 

Date: 2015-06-12 09:47:13

*/

 

SET FOREIGN_KEY_CHECKS=0;

 

-- ----------------------------

-- Table structure for gmhost

-- ----------------------------

DROP TABLE IF EXISTS `gmhost`;

CREATE TABLE `gmhost` (

  `mIP` varchar(16) NOT NULL DEFAULT '',

  PRIMARY KEY (`mIP`)

) ENGINE=MyISAM DEFAULT CHARSET=big5;

 

-- ----------------------------

-- Table structure for gmlist

-- ----------------------------

DROP TABLE IF EXISTS `gmlist`;

CREATE TABLE `gmlist` (

  `mID` int(10) unsigned NOT NULL AUTO_INCREMENT,

  `mAccount` varchar(16) NOT NULL DEFAULT '',

  `mName` varchar(16) NOT NULL DEFAULT '',

  `mContactIP` varchar(16) NOT NULL DEFAULT '',

  `mServerIP` varchar(16) NOT NULL DEFAULT 'ALL',

  `mAuthority` enum('IMPLEMENTOR','HIGH_WIZARD','GOD','LOW_WIZARD','PLAYER') DEFAULT 'PLAYER',

  PRIMARY KEY (`mID`)

) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=big5;

 

-- ----------------------------

-- Table structure for locale

-- ----------------------------

DROP TABLE IF EXISTS `locale`;

CREATE TABLE `locale` (

  `mKey` varchar(255) NOT NULL DEFAULT '',

  `mValue` varchar(255) NOT NULL DEFAULT '',

  PRIMARY KEY (`mKey`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

 

-- ----------------------------

-- Table structure for locale_bug

-- ----------------------------

DROP TABLE IF EXISTS `locale_bug`;

CREATE TABLE `locale_bug` (

  `mKey` varchar(255) NOT NULL DEFAULT '',

  `mValue` varchar(255) NOT NULL DEFAULT '',

  PRIMARY KEY (`mKey`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

 

-- ----------------------------

-- Table structure for spam_db

-- ----------------------------

DROP TABLE IF EXISTS `spam_db`;

CREATE TABLE `spam_db` (

  `type` set('GOOD','SPAM') NOT NULL DEFAULT 'SPAM',

  `word` varchar(256) NOT NULL,

  `score` int(11) NOT NULL DEFAULT '10',

  PRIMARY KEY (`word`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

arijh2.jpg

Noresta Weteran

Noresta

Opublikowano
Weteran

Noresta

Opublikowano

Teraz mi serwer nie uruchamia :]

 

Podaj ponownie syserry bo jakieś zmiany zaszły napewno skoro serwer działał a teraz nie działa :)

‎

Pitos Pasjonat

Pitos

Opublikowano
Pasjonat

Pitos

  • Autor
Opublikowano

post-1344813-0-16606000-1434315604.jpg

I zaden proces sie nie uruchamia :D

syser db

 

SYSERR: Jun 14 23:01:59 :: Start: TABLE_POSTFIX not configured use default
SYSERR: Jun 14 23:01:59 :: InitializeLocalization: InitializeLocalization() ==> DirectQuery failed(SELECT mValue, mKey FROM locale)
SYSERR: Jun 14 23:01:59 :: QueryLocaleSet: cannot set locale euckr by 'mysql_set_character_set', errno 2013 Lost connection to MySQL server at 'sending authentication information', system error: 32
 

Bez nazwy-1.png

Zarchiwizowany

Ten temat przebywa obecnie w archiwum. Dodawanie nowych odpowiedzi zostało zablokowane.

Tematy
×
×
  • Dodaj nową pozycję...