01-16-2012, 09:36 PM
i have error excute the "newproject_db.sql"
im using files v2.0 got from the link on the 1st page.
[Err] 1005 - Cant create table .\newproject_db\t_pd4rank.frm (errno: 121)
[Err] INSERT INTO `t_notice` VALUES (28, 26, 2);
INSERT INTO `t_notice` VALUES (28, 35, 1);
INSERT INTO `t_notice` VALUES (28, 55, 1);
INSERT INTO `t_notice` VALUES (31, 18, 3);
INSERT INTO `t_notice` VALUES (31, 26, 3);
INSERT INTO `t_notice` VALUES (31, 35, 3);
INSERT INTO `t_notice` VALUES (31, 55, 3);
INSERT INTO `t_notice` VALUES (32, 18, 2);
INSERT INTO `t_notice` VALUES (32, 26, 2);
INSERT INTO `t_notice` VALUES (32, 35, 2);
INSERT INTO `t_notice` VALUES (32, 55, 2);
INSERT INTO `t_notice` VALUES (1, 26, 2);
INSERT INTO `t_notice` VALUES (2, 26, 3);
INSERT INTO `t_notice` VALUES (15, 26, 3);
INSERT INTO `t_notice` VALUES (16, 26, 3);
INSERT INTO `t_notice` VALUES (17, 26, 3);
INSERT INTO `t_notice` VALUES (18, 26, 1);
INSERT INTO `t_notice` VALUES (29, 26, 2);
INSERT INTO `t_notice` VALUES (30, 26, 1);
INSERT INTO `t_notice` VALUES (33, 26, 1);
INSERT INTO `t_notice` VALUES (34, 26, 1);
INSERT INTO `t_notice` VALUES (35, 26, 1);
INSERT INTO `t_notice` VALUES (36, 1, 1);
INSERT INTO `t_notice` VALUES (36, 26, 1);
INSERT INTO `t_notice` VALUES (37, 26, 1);
INSERT INTO `t_notice` VALUES (38, 26, 1);
INSERT INTO `t_notice` VALUES (39, 1, 1);
INSERT INTO `t_notice` VALUES (39, 26, 1);
INSERT INTO `t_notice` VALUES (40, 26, 1);
INSERT INTO `t_notice` VALUES (41, 26, 1);
INSERT INTO `t_notice` VALUES (42, 26, 3);
INSERT INTO `t_notice` VALUES (43, 26, 1);
INSERT INTO `t_notice` VALUES (44, 26, 2);
INSERT INTO `t_notice` VALUES (45, 26, 3);
INSERT INTO `t_notice` VALUES (46, 26, 1);
INSERT INTO `t_notice` VALUES (47, 26, 1);
-- ----------------------------
-- Table structure for `t_nscard`
-- ----------------------------
DROP TABLE IF EXISTS `t_nscard`;
CREATE TABLE `t_nscard` (
`a_user_index` int(11) NOT NULL DEFAULT 0,
`a_usetime` datetime NOT NULL DEFAULT 0000-00-00 00:00:00,
PRIMARY KEY (`a_user_index`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of t_nscard
-- ----------------------------
INSERT INTO `t_nscard` VALUES (129, 2010-08-24 20:22:17);
-- ----------------------------
-- Table structure for `t_ocn_goo_promotion_2008`
-- ----------------------------
DROP TABLE IF EXISTS `t_ocn_goo_promotion_2008`;
CREATE TABLE `t_ocn_goo_promotion_2008` (
`a_index` int(11) NOT NULL AUTO_INCREMENT,
`a_user_index` int(11) DEFAULT 0,
`a_server` int(11) DEFAULT 0,
`a_char_index` int(11) DEFAULT 0,
PRIMARY KEY (`a_index`),
UNIQUE KEY `a_user_index` (`a_user_index`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of t_ocn_goo_promotion_2008
-- ----------------------------
INSERT INTO `t_ocn_goo_promotion_2008` VALUES (1, 135, 1, 633);
INSERT INTO `t_ocn_goo_promotion_2008` VALUES (2, 143, 1, 636);
INSERT INTO `t_ocn_goo_promotion_2008` VALUES (3, 144, 1, 637);
INSERT INTO `t_ocn_goo_promotion_2008` VALUES (4, 146, 1, 641);
INSERT INTO `t_ocn_goo_promotion_2008` VALUES (5, 148, 1, 642);
-- ----------------------------
-- Table structure for `t_pcbang`
-- ----------------------------
DROP TABLE IF EXISTS `t_pcbang`;
CREATE TABLE `t_pcbang` (
`a_index` int(3) NOT NULL AUTO_INCREMENT,
`a_ip` char(15) DEFAULT NULL,
`a_enable` tinyint(4) DEFAULT 0,
PRIMARY KEY (`a_index`),
UNIQUE KEY `a_ip` (`a_ip`),
KEY `a_index` (`a_index`,`a_ip`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of t_pcbang
-- ----------------------------
INSERT INTO `t_pcbang` VALUES (1, 192.168.1.188, 1);
INSERT INTO `t_pcbang` VALUES (2, 211.181.248.135, 1);
INSERT INTO `t_pcbang` VALUES (3, 211.181.248.128, 1);
INSERT INTO `t_pcbang` VALUES (4, 61.195.149.81, 1);
INSERT INTO `t_pcbang` VALUES (5, 61.118.1
[Err] 1062 - Duplicate entry 36 for key 1
[Err] INSERT INTO `t_pddata06` VALUES (16, 0, 0, 0, 0);
INSERT INTO `t_pddata06` VALUES (26, 0, 0, 0, 0);
INSERT INTO `t_pddata06` VALUES (36, 0, 0, 0, 0);
INSERT INTO `t_pddata06` VALUES (46, 0, 0, 0, 0);
-- ----------------------------
-- Table structure for `t_pddata07`
-- ----------------------------
DROP TABLE IF EXISTS `t_pddata07`;
CREATE TABLE `t_pddata07` (
`a_char_index` int(11) NOT NULL DEFAULT 0,
`a_pd3_count` int(11) NOT NULL DEFAULT 0,
`a_pd3_time` int(11) NOT NULL DEFAULT 0,
`a_pd4_count` int(11) NOT NULL DEFAULT 0,
`a_pd4_time` int(11) NOT NULL DEFAULT 0,
PRIMARY KEY (`a_char_index`)
) ENGINE=MyISAM AUTO_INCREMENT=109 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of t_pddata07
-- ----------------------------
INSERT INTO `t_pddata07` VALUES (7, 0, 0, 0, 0);
INSERT INTO `t_pddata07` VALUES (17, 0, 0, 0, 0);
INSERT INTO `t_pddata07` VALUES (27, 0, 0, 0, 0);
INSERT INTO `t_pddata07` VALUES (37, 0, 0, 0, 0);
INSERT INTO `t_pddata07` VALUES (47, 0, 0, 0, 0);
-- ----------------------------
-- Table structure for `t_pddata08`
-- ----------------------------
DROP TABLE IF EXISTS `t_pddata08`;
CREATE TABLE `t_pddata08` (
`a_char_index` int(11) NOT NULL DEFAULT 0,
`a_pd3_count` int(11) NOT NULL DEFAULT 0,
`a_pd3_time` int(11) NOT NULL DEFAULT 0,
`a_pd4_count` int(11) NOT NULL DEFAULT 0,
`a_pd4_time` int(11) NOT NULL DEFAULT 0,
PRIMARY KEY (`a_char_index`)
) ENGINE=MyISAM AUTO_INCREMENT=109 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of t_pddata08
-- ----------------------------
INSERT INTO `t_pddata08` VALUES (8, 0, 0, 0, 0);
INSERT INTO `t_pddata08` VALUES (18, 0, 0, 0, 0);
INSERT INTO `t_pddata08` VALUES (28, 0, 0, 0, 0);
-- ----------------------------
-- Table structure for `t_pddata09`
-- ----------------------------
DROP TABLE IF EXISTS `t_pddata09`;
CREATE TABLE `t_pddata09` (
`a_char_index` int(11) NOT NULL DEFAULT 0,
`a_pd3_count` int(11) NOT NULL DEFAULT 0,
`a_pd3_time` int(11) NOT NULL DEFAULT 0,
`a_pd4_count` int(11) NOT NULL DEFAULT 0,
`a_pd4_time` int(11) NOT NULL DEFAULT 0,
PRIMARY KEY (`a_char_index`)
) ENGINE=MyISAM AUTO_INCREMENT=109 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of t_pddata09
-- ----------------------------
INSERT INTO `t_pddata09` VALUES (9, 0, 0, 0, 0);
INSERT INTO `t_pddata09` VALUES (19, 0, 0, 0, 0);
INSERT INTO `t_pddata09` VALUES (29, 0, 0, 0, 0);
-- ----------------------------
-- Table structure for `t_pet`
-- ----------------------------
DROP TABLE IF EXISTS `t_pet`;
CREATE TABLE `t_pet` (
`a_index` int(11) NOT NULL AUTO_INCREMENT,
`a_owner` int(11) NOT NULL DEFAULT 0,
`a_enable` tinyint(4) NOT NULL DEFAULT 0,
`a_lastupdate` int(11) NOT NULL DEFAULT 0,
`a_type` tinyint(4) NOT NULL DEFAULT 0,
`a_level` int(11) NOT NULL DEFAULT 1,
`a_hp` int(11) NOT NULL DEFAULT 100,
`a_hungry` int(11) NOT NULL DEFAULT 100,
`a_sympathy` int(11) NOT NULL DEFAULT 100,
`a_exp` bigint(20) NOT NULL DEFAULT 0,
`a_ability` int(11) NOT NULL DEFAULT 0,
`a_skill_index` varchar(255) NOT NULL DEFAULT ,
`a_skill_level` varchar(255) NOT NULL DEFAULT ,
`a_time_rebirth` int(11) NOT NULL DEFAULT 0,
`a_index_old` int(11) NOT NULL DEFAULT 0,
`a_color` char(2) NOT NULL DEFAULT 0,
`a_pet_turnto_npc` int(11) DEFAULT 0,
`a_pet_size` int(11) NOT NULL DEFAULT 10,
PRIMARY KEY (`a_index`),
KEY `idx_owner` (`a_owner`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of t_pet
-- ----------------------------
INSERT INTO `t_pet` VALUES (3, 32, 1, 1311272125, 35, 58, 100, 0, 52, 19613, 57, , , 0, 0, 0, 0, 10);
INSERT INTO `t_pet` VALUES (4, 4, 2, 1322433777, 17, 4, 61,
[Err] 1062 - Duplicate entry 32-33 for key 1
[Err] INSERT INTO `t_questdata02` VALUES (12, 45, 3, 0, 0, 0);
INSERT INTO `t_questdata02` VALUES (22, 37, 2, 1, 0, 0);
INSERT INTO `t_questdata02` VALUES (22, 40, 2, 1, 0, 0);
INSERT INTO `t_questdata02` VALUES (32, 33, 2, 1, 0, 0);
INSERT INTO `t_questdata02` VALUES (32, 39, 3, 0, 0, 0);
INSERT INTO `t_questdata02` VALUES (32, 41, 3, 0, 0, 0);
INSERT INTO `t_questdata02` VALUES (32, 45, 3, 0, 0, 0);
INSERT INTO `t_questdata02` VALUES (42, 33, 4, 0, 0, 0);
INSERT INTO `t_questdata02` VALUES (42, 41, 4, 0, 0, 0);
INSERT INTO `t_questdata02` VALUES (62, 45, 2, 0, 0, 0);
-- ----------------------------
-- Table structure for `t_questdata03`
-- ----------------------------
DROP TABLE IF EXISTS `t_questdata03`;
CREATE TABLE `t_questdata03` (
`a_char_index` int(11) NOT NULL DEFAULT 0,
`a_quest_index` int(11) NOT NULL DEFAULT 0,
`a_state` tinyint(4) NOT NULL DEFAULT 0,
`a_value0` int(11) NOT NULL DEFAULT 0,
`a_value1` int(11) NOT NULL DEFAULT 0,
`a_value2` int(11) NOT NULL DEFAULT 0,
PRIMARY KEY (`a_char_index`,`a_quest_index`),
KEY `idx_char_index` (`a_char_index`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of t_questdata03
-- ----------------------------
INSERT INTO `t_questdata03` VALUES (13, 45, 2, 0, 0, 0);
INSERT INTO `t_questdata03` VALUES (33, 33, 4, 0, 0, 0);
INSERT INTO `t_questdata03` VALUES (33, 36, 4, 0, 0, 0);
INSERT INTO `t_questdata03` VALUES (33, 40, 4, 0, 0, 0);
INSERT INTO `t_questdata03` VALUES (33, 41, 4, 0, 0, 0);
INSERT INTO `t_questdata03` VALUES (33, 48, 4, 0, 0, 0);
INSERT INTO `t_questdata03` VALUES (33, 57, 4, 0, 0, 0);
INSERT INTO `t_questdata03` VALUES (33, 155, 4, 0, 0, 0);
INSERT INTO `t_questdata03` VALUES (33, 181, 3, 0, 0, 0);
INSERT INTO `t_questdata03` VALUES (43, 33, 4, 0, 0, 0);
INSERT INTO `t_questdata03` VALUES (43, 34, 4, 0, 0, 0);
INSERT INTO `t_questdata03` VALUES (43, 36, 4, 0, 0, 0);
INSERT INTO `t_questdata03` VALUES (43, 40, 4, 0, 0, 0);
INSERT INTO `t_questdata03` VALUES (43, 41, 4, 0, 0, 0);
INSERT INTO `t_questdata03` VALUES (43, 155, 3, 1, 0, 0);
INSERT INTO `t_questdata03` VALUES (63, 45, 3, 0, 0, 0);
-- ----------------------------
-- Table structure for `t_questdata04`
-- ----------------------------
DROP TABLE IF EXISTS `t_questdata04`;
CREATE TABLE `t_questdata04` (
`a_char_index` int(11) NOT NULL DEFAULT 0,
`a_quest_index` int(11) NOT NULL DEFAULT 0,
`a_state` tinyint(4) NOT NULL DEFAULT 0,
`a_value0` int(11) NOT NULL DEFAULT 0,
`a_value1` int(11) NOT NULL DEFAULT 0,
`a_value2` int(11) NOT NULL DEFAULT 0,
PRIMARY KEY (`a_char_index`,`a_quest_index`),
KEY `idx_char_index` (`a_char_index`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of t_questdata04
-- ----------------------------
INSERT INTO `t_questdata04` VALUES (14, 45, 3, 0, 0, 0);
INSERT INTO `t_questdata04` VALUES (24, 45, 2, 0, 0, 0);
INSERT INTO `t_questdata04` VALUES (34, 45, 2, 0, 0, 0);
INSERT INTO `t_questdata04` VALUES (44, 155, 3, 0, 0, 0);
INSERT INTO `t_questdata04` VALUES (44, 178, 3, 1, 0, 0);
INSERT INTO `t_questdata04` VALUES (44, 179, 3, 1, 0, 0);
INSERT INTO `t_questdata04` VALUES (44, 180, 3, 1, 0, 0);
INSERT INTO `t_questdata04` VALUES (44, 181, 3, 1, 0, 0);
-- ----------------------------
-- Table structure for `t_questdata05`
-- ----------------------------
DROP TABLE IF EXISTS `t_questdata05`;
CREATE TABLE `t_questdata05` (
`a_char_index` int(11) NOT NULL DEFAULT 0,
`a_quest_index` int(11) NOT NULL DEFAULT 0,
`a_state` tinyint(4) NOT NULL DEFAULT 0,
`a_value0` int
[Err] 1062 - Duplicate entry 29-40 for key 1
[Err] INSERT INTO `t_questdata09` VALUES (29, 1, 3, 6, 0, 0);
INSERT INTO `t_questdata09` VALUES (29, 2, 3, 10, 0, 0);
INSERT INTO `t_questdata09` VALUES (29, 3, 3, 12, 0, 0);
INSERT INTO `t_questdata09` VALUES (29, 33, 2, 0, 0, 0);
INSERT INTO `t_questdata09` VALUES (29, 36, 3, 1, 0, 0);
INSERT INTO `t_questdata09` VALUES (29, 40, 3, 1, 0, 0);
INSERT INTO `t_questdata09` VALUES (29, 41, 3, 1, 0, 0);
INSERT INTO `t_questdata09` VALUES (39, 45, 2, 0, 0, 0);
-- ----------------------------
-- Table structure for `t_quickslot00`
-- ----------------------------
DROP TABLE IF EXISTS `t_quickslot00`;
CREATE TABLE `t_quickslot00` (
`a_char_idx` int(11) NOT NULL DEFAULT 0,
`a_page_idx` tinyint(4) NOT NULL DEFAULT 0,
`a_slot` varchar(255) NOT NULL DEFAULT -1 -1 -1 -1 -1 -1 -1 -1 -1 -1,
PRIMARY KEY (`a_char_idx`,`a_page_idx`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of t_quickslot00
-- ----------------------------
INSERT INTO `t_quickslot00` VALUES (10, 0, 0 122 0 119 0 125 -1 -1 -1 -1 -1 2 1 3 -1 2 1 2 1 3 );
INSERT INTO `t_quickslot00` VALUES (10, 1, -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 );
INSERT INTO `t_quickslot00` VALUES (10, 2, -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 );
INSERT INTO `t_quickslot00` VALUES (20, 0, 0 53 0 59 1 4 -1 2 3 3 1 3 -1 -1 -1 -1 -1 -1 );
INSERT INTO `t_quickslot00` VALUES (20, 1, -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 );
INSERT INTO `t_quickslot00` VALUES (20, 2, -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 );
INSERT INTO `t_quickslot00` VALUES (30, 0, 0 14 2 12 0 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 );
INSERT INTO `t_quickslot00` VALUES (30, 1, -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 );
INSERT INTO `t_quickslot00` VALUES (30, 2, -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 );
INSERT INTO `t_quickslot00` VALUES (40, 0, 0 1 1 4 1 5 1 6 1 7 1 3 1 30);
INSERT INTO `t_quickslot00` VALUES (40, 1, -1 -1 -1 -1 -1 -1 -1 -1 -1 -1);
INSERT INTO `t_quickslot00` VALUES (40, 2, -1 -1 -1 -1 -1 -1 -1 -1 -1 -1);
-- ----------------------------
-- Table structure for `t_quickslot01`
-- ----------------------------
DROP TABLE IF EXISTS `t_quickslot01`;
CREATE TABLE `t_quickslot01` (
`a_char_idx` int(11) NOT NULL DEFAULT 0,
`a_page_idx` tinyint(4) NOT NULL DEFAULT 0,
`a_slot` varchar(255) NOT NULL DEFAULT -1 -1 -1 -1 -1 -1 -1 -1 -1 -1,
PRIMARY KEY (`a_char_idx`,`a_page_idx`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of t_quickslot01
-- ----------------------------
INSERT INTO `t_quickslot01` VALUES (1, 0, 2 12 3 2 15 1 0 122 0 119 0 116 1 1 1 30 1 4 2 17 1 -1 -1 -1 );
INSERT INTO `t_quickslot01` VALUES (1, 1, -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 );
INSERT INTO `t_quickslot01` VALUES (1, 2, -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 );
INSERT INTO `t_quickslot01` VALUES (11, 0, 0 53 1 4 1 5 1 6 1 7 1 3 1 30 -1 -1 -1 -1 -1 );
INSERT INTO `t_quickslot01` VALUES (11, 1, -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 );
INSERT INTO `t_quickslot01` VALUES (11, 2, -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 );
INSERT INTO `t_quickslot01` VALUES (21, 0, 2 1 2 -1 0 125 0 119 0 116 -1 -1 1 26 2 2 1 1 3 2 1 4 1 40 );
INSERT INTO `t_quickslot01` VALUES (21, 1, -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 );
INSERT INTO `t_quickslot01` VALUES (21, 2, -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 );
INSERT INTO `t_quickslot01` VALUES (31, 0, 7 1 3 1 1 -1 -1 -1 -1 -1 -1 -1 -1 -1);
INSERT INTO `t_quickslot01` VALUES (31, 1, -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1);
INSERT INTO `t_quickslot01` VALUES (31, 2, -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1);
INSERT INTO `t_quickslot01` VALUES (41, 0, 0 14 1 4 1 5 1 6 1 7 1 3 1 30 -1 -1 -1 -1 -1 );
INSERT INTO `t_quickslot01` VALUES (41, 1, -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 );
INSERT INTO `t_quickslot01` VALUES (41, 2, -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1
[Err] 1062 - Duplicate entry 35-0 for key 1
[Err] INSERT INTO `t_quickslot05` VALUES (25, 2, -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 );
INSERT INTO `t_quickslot05` VALUES (35, 0, 0 1 1 4 1 5 1 6 1 7 1 3 1 30 -1 -1 -1 -1 -1 );
INSERT INTO `t_quickslot05` VALUES (35, 1, -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 );
INSERT INTO `t_quickslot05` VALUES (35, 2, -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 );
INSERT INTO `t_quickslot05` VALUES (45, 0, 0 1 1 4 1 5 1 6 1 7 1 3 1 30 -1 -1 -1 -1 -1 );
INSERT INTO `t_quickslot05` VALUES (45, 1, -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 );
INSERT INTO `t_quickslot05` VALUES (45, 2, -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 );
-- ----------------------------
-- Table structure for `t_quickslot06`
-- ----------------------------
DROP TABLE IF EXISTS `t_quickslot06`;
CREATE TABLE `t_quickslot06` (
`a_char_idx` int(11) NOT NULL DEFAULT 0,
`a_page_idx` tinyint(4) NOT NULL DEFAULT 0,
`a_slot` varchar(255) NOT NULL DEFAULT -1 -1 -1 -1 -1 -1 -1 -1 -1 -1,
PRIMARY KEY (`a_char_idx`,`a_page_idx`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of t_quickslot06
-- ----------------------------
INSERT INTO `t_quickslot06` VALUES (6, 0, 0 116 1 4 1 5 1 6 1 7 1 3 1 30 -1 -1 -1 -1 -1 );
INSERT INTO `t_quickslot06` VALUES (6, 1, -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 );
INSERT INTO `t_quickslot06` VALUES (6, 2, -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 );
INSERT INTO `t_quickslot06` VALUES (16, 0, 0 46 -1 -1 -1 -1 -1 -1 0 168 -1 0 20 0 17 1 40 );
INSERT INTO `t_quickslot06` VALUES (16, 1, 1 23 -1 1 3 -1 1 5 -1 -1 -1 -1 -1 -1 1 40 );
INSERT INTO `t_quickslot06` VALUES (16, 2, -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 );
INSERT INTO `t_quickslot06` VALUES (26, 0, 0 116 1 4 1 5 1 6 1 7 1 3 1 30 -1 -1 -1 -1 -1 );
INSERT INTO `t_quickslot06` VALUES (26, 1, -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 );
INSERT INTO `t_quickslot06` VALUES (26, 2, -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 );
INSERT INTO `t_quickslot06` VALUES (36, 0, 0 1 1 4 1 5 1 6 1 7 1 3 1 30 -1 -1 -1 -1 -1 );
INSERT INTO `t_quickslot06` VALUES (36, 1, -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 );
INSERT INTO `t_quickslot06` VALUES (36, 2, -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 );
INSERT INTO `t_quickslot06` VALUES (46, 0, 0 53 1 4 1 5 1 6 1 7 1 3 1 30 -1 -1 -1 -1 -1 );
INSERT INTO `t_quickslot06` VALUES (46, 1, -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 );
INSERT INTO `t_quickslot06` VALUES (46, 2, -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 );
-- ----------------------------
-- Table structure for `t_quickslot07`
-- ----------------------------
DROP TABLE IF EXISTS `t_quickslot07`;
CREATE TABLE `t_quickslot07` (
`a_char_idx` int(11) NOT NULL DEFAULT 0,
`a_page_idx` tinyint(4) NOT NULL DEFAULT 0,
`a_slot` varchar(255) NOT NULL DEFAULT -1 -1 -1 -1 -1 -1 -1 -1 -1 -1,
PRIMARY KEY (`a_char_idx`,`a_page_idx`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of t_quickslot07
-- ----------------------------
INSERT INTO `t_quickslot07` VALUES (7, 0, 0 2 0 3 1 5 1 6 1 7 1 3 1 30 -1 -1 -1 -1 -1 );
INSERT INTO `t_quickslot07` VALUES (7, 1, -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 );
INSERT INTO `t_quickslot07` VALUES (7, 2, -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 );
INSERT INTO `t_quickslot07` VALUES (17, 0, 0 53 1 4 1 5 1 6 1 7 1 3 1 30 2 1 2 2 5 3 2 2 0 1 40 -1 );
INSERT INTO `t_quickslot07` VALUES (17, 1, -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 );
INSERT INTO `t_quickslot07` VALUES (17, 2, -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 );
INSERT INTO `t_quickslot07` VALUES (27, 0, 2 3 0 2 3 1 0 174 0 173 0 172 -1 0 50 0 31 0 32 0 35 0 403 0 34 );
INSERT INTO `t_quickslot07` VALUES (27, 1, -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 );
INSERT INTO `t_quickslot07` VALUES (27, 2, -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 );
INSERT INTO `t_quickslot07` VALUES (37, 0, 0 1 1 4 1 5 1 6 1 7 1 3 1 30 -1 -1 -1 -1 -1 );
INSERT INTO `t_quickslot07` VALUES (37, 1, -1 -1
[Err] 1050 - Table t_stash03 already exists
[Err] CREATE TABLE `t_stash03` (
`a_index` int(11) NOT NULL AUTO_INCREMENT,
`a_user_idx` int(11) NOT NULL DEFAULT 0,
`a_item_idx` int(11) NOT NULL DEFAULT -1,
`a_plus` int(11) NOT NULL DEFAULT 0,
`a_wear_pos` tinyint(3) NOT NULL DEFAULT -1,
`a_flag` int(11) NOT NULL DEFAULT 0,
`a_serial` varchar(255) NOT NULL DEFAULT ,
`a_count` bigint(20) NOT NULL DEFAULT 0,
`a_used` int(11) NOT NULL DEFAULT -1,
`a_item_option0` smallint(6) NOT NULL DEFAULT 0,
`a_item_option1` smallint(6) NOT NULL DEFAULT 0,
`a_item_option2` smallint(6) NOT NULL DEFAULT 0,
`a_item_option3` smallint(6) NOT NULL DEFAULT 0,
`a_item_option4` smallint(6) NOT NULL DEFAULT 0,
`a_used_2` int(11) NOT NULL DEFAULT -1,
PRIMARY KEY (`a_index`),
KEY `idx_user_idx` (`a_user_idx`),
KEY `idx_item_idx` (`a_item_idx`)
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of t_stash03
-- ----------------------------
INSERT INTO `t_stash03` VALUES (3, 2003, 786, 0, -1, 0, LRBQ0807a, 2, -1, 0, 0, 0, 0, 0, -1);
INSERT INTO `t_stash03` VALUES (4, 2003, 391, 0, -1, 0, LRBRFP06J, 1, -1, 0, 0, 0, 0, 0, -1);
INSERT INTO `t_stash03` VALUES (5, 2003, 43, 0, -1, 0, LRBRFP00h, 50, -1, 0, 0, 0, 0, 0, -1);
INSERT INTO `t_stash03` VALUES (6, 2003, 484, 0, -1, 0, LRBRFP07o, 50, -1, 0, 0, 0, 0, 0, -1);
INSERT INTO `t_stash03` VALUES (7, 2003, 43, 0, -1, 0, LRBRFP00h, 50, -1, 0, 0, 0, 0, 0, -1);
INSERT INTO `t_stash03` VALUES (8, 2003, 484, 0, -1, 0, LRBRFP07o, 50, -1, 0, 0, 0, 0, 0, -1);
INSERT INTO `t_stash03` VALUES (9, 2003, 43, 0, -1, 0, LRBRFQ00h, 50, -1, 0, 0, 0, 0, 0, -1);
INSERT INTO `t_stash03` VALUES (10, 2003, 484, 0, -1, 0, LRBRFQ07o, 50, -1, 0, 0, 0, 0, 0, -1);
INSERT INTO `t_stash03` VALUES (11, 2003, 43, 0, -1, 0, LRBRFQ00h, 50, -1, 0, 0, 0, 0, 0, -1);
INSERT INTO `t_stash03` VALUES (12, 2003, 484, 0, -1, 0, LRBRFQ07o, 50, -1, 0, 0, 0, 0, 0, -1);
INSERT INTO `t_stash03` VALUES (13, 2003, 43, 0, -1, 0, LRBRFQ00h, 50, -1, 0, 0, 0, 0, 0, -1);
INSERT INTO `t_stash03` VALUES (14, 2003, 484, 0, -1, 0, LRBRFQ07o, 50, -1, 0, 0, 0, 0, 0, -1);
INSERT INTO `t_stash03` VALUES (15, 2003, 43, 0, -1, 0, LRBRFQ00h, 50, -1, 0, 0, 0, 0, 0, -1);
INSERT INTO `t_stash03` VALUES (16, 2003, 484, 0, -1, 0, LRBRFQ07o, 50, -1, 0, 0, 0, 0, 0, -1);
INSERT INTO `t_stash03` VALUES (17, 2003, 43, 0, -1, 0, LRBRFQ00h, 50, -1, 0, 0, 0, 0, 0, -1);
INSERT INTO `t_stash03` VALUES (18, 2003, 484, 0, -1, 0, LRBRFQ07o, 50, -1, 0, 0, 0, 0, 0, -1);
INSERT INTO `t_stash03` VALUES (19, 2003, 43, 0, -1, 0, LRBRFQ00h, 50, -1, 0, 0, 0, 0, 0, -1);
INSERT INTO `t_stash03` VALUES (20, 2003, 484, 0, -1, 0, LRBRFQ07o, 50, -1, 0, 0, 0, 0, 0, -1);
INSERT INTO `t_stash03` VALUES (21, 2003, 43, 0, -1, 0, LRBRFQ00h, 50, -1, 0, 0, 0, 0, 0, -1);
INSERT INTO `t_stash03` VALUES (22, 2003, 484, 0, -1, 0, LRBRFQ07o, 50, -1, 0, 0, 0, 0, 0, -1);
INSERT INTO `t_stash03` VALUES (23, 2003, 43, 0, -1, 0, LRBRFR00h, 50, -1, 0, 0, 0, 0, 0, -1);
INSERT INTO `t_stash03` VALUES (24, 2003, 484, 0, -1, 0, LRBRFR07o, 50, -1, 0, 0, 0, 0, 0, -1);
-- ----------------------------
-- Table structure for `t_stash04`
-- ----------------------------
DROP TABLE IF EXISTS `t_stash04`;
CREATE TABLE `t_stash04` (
`a_index` int(11) NOT NULL AUTO_INCREMENT,
`a_user_idx` int(11) NOT NULL DEFAULT 0,
`a_item_idx` int(11) NOT NULL DEFAULT -1,
[Err] 1062 - Duplicate entry 114 for key 1
[Err] INSERT INTO `t_users` VALUES (114, KewPco0L, , 2005, 2011-11-25 23:40:52, 2011-11-27 23:03:02, 1, 1, 1, -1, 347684, 0, 0, , 0, , 0);
INSERT INTO `t_users` VALUES (115, Basti, , 2004, 2011-11-25 23:41:13, 2012-01-14 11:24:22, 1, 1, 1, -1, 1143157, 0, 0, , 0, , 0);
INSERT INTO `t_users` VALUES (117, tommyro, , 2006, 2011-11-26 15:41:12, 2011-11-27 05:07:08, 1, 1, 1, -1, 240035, 0, 0, , 0, , 0);
INSERT INTO `t_users` VALUES (118, Berga16, , 2007, 2011-11-26 21:11:01, 2011-11-28 01:44:19, 1, 1, 1, -1, 220431, 0, 0, , 0, , 0);
INSERT INTO `t_users` VALUES (119, eulerian, , 2008, 2011-11-26 21:11:55, 2011-11-27 20:57:01, 1, 1, 1, -1, 846871, 0, 0, , 0, , 0);
INSERT INTO `t_users` VALUES (120, mifi, , 2009, 2011-11-26 21:22:13, 2011-11-26 21:37:22, 1, 1, 1, -1, 18163, 0, 0, , 0, , 0);
INSERT INTO `t_users` VALUES (121, Moebe, , 2010, 2011-11-26 21:23:46, 2011-11-27 18:04:57, 1, 1, 1, -1, 152780, 0, 0, , 0, , 0);
INSERT INTO `t_users` VALUES (122, Gothic, , 2011, 2011-11-26 21:42:32, 2011-11-26 21:44:24, 1, 1, 1, -1, 2238, 0, 0, , 0, , 0);
INSERT INTO `t_users` VALUES (123, xxbashyxx, , 2012, 2011-11-26 21:47:19, 2011-11-27 15:39:11, 1, 1, 1, -1, 11509, 0, 0, , 0, , 0);
INSERT INTO `t_users` VALUES (124, socki, , 2015, 2011-11-26 23:17:51, 2011-11-28 02:15:40, 1, 1, 1, -1, 862702, 0, 0, , 0, , 0);
INSERT INTO `t_users` VALUES (125, Azalee, , 2016, 2011-11-27 00:36:06, 2011-11-27 23:29:26, 1, 1, 1, -1, 196461, 0, 0, , 0, , 0);
INSERT INTO `t_users` VALUES (126, Desperater, , 2017, 2011-11-27 02:49:32, 2011-11-27 03:02:08, 1, 1, 1, -1, 15130, 0, 0, , 0, , 0);
INSERT INTO `t_users` VALUES (129, Toneyhok, , 2025, 2011-11-27 14:46:48, 2011-11-27 22:20:27, 1, 1, 1, -1, 308703, 0, 0, , 0, , 0);
INSERT INTO `t_users` VALUES (127, bunbury14, , 2019, 2011-11-27 05:06:13, 2011-11-27 05:36:47, 1, 1, 1, -1, 15983, 0, 0, , 0, , 0);
INSERT INTO `t_users` VALUES (132, lcgmbh, , 2028, 2011-11-27 20:11:37, 2011-11-27 20:28:26, 1, 1, 1, -1, 20174, 0, 0, , 0, , 0);
INSERT INTO `t_users` VALUES (128, talon55, , 2023, 2011-11-27 14:43:10, 2011-11-27 19:51:25, 1, 1, 1, -1, 85319, 0, 0, , 0, , 0);
INSERT INTO `t_users` VALUES (131, DeviceGM, , 2027, 2011-11-27 18:30:44, 2011-11-27 21:15:00, 1, 1, 1, -1, 90374, 0, 0, , 0, , 0);
INSERT INTO `t_users` VALUES (130, hakitari, , 2026, 2011-11-27 18:10:34, 2011-11-27 20:36:36, 1, 1, 1, -1, 83102, 0, 0, , 0, , 0);
INSERT INTO `t_users` VALUES (133, pitufo, , 2021, 2011-11-27 20:51:18, 2011-11-27 21:01:42, 1, 1, 1, -1, 2686, 0, 0, , 0, , 0);
INSERT INTO `t_users` VALUES (134, Germanski, , 2022, 2011-11-27 22:09:43, 2011-11-27 22:29:37, 1, 1, 1, -1, 23863, 0, 0, , 0, , 0);
INSERT INTO `t_users` VALUES (135, test, , 2029, 2012-01-09 10:58:09, 2012-01-09 17:07:46, 1, 1, 1, -1, 59140, 0, 0, , 0, , 0);
-- ----------------------------
-- Table structure for `t_users_block`
-- ----------------------------
DROP TABLE IF EXISTS `t_users_block`;
CREATE TABLE `t_users_block` (
`a_index` int(1) unsigned NOT NULL AUTO_INCREMENT,
`a_idname` varchar(30) DEFAULT NULL,
`a_portal_idx` int(11) NOT NULL DEFAULT -1,
`a_game_idx` int(11) DEFAULT -1,
`a_admin_name` varchar(30) DEFAULT admin,
`a_contents` text,
`a_reason` int(11) NOT NULL DEFAULT 0,
`a_modify_date` datetime NOT NULL DEFAULT 2000-01-01 00:00:00,
`a_detail` varchar(255) DEFAULT NULL,
PRIMARY KEY (`
[Msg] Finished - Unsuccessfully
--------------------------------------------------
another here : 2
