+- LCKB (https://lckb.dev/forum)
+-- Forum: ** OLD LCKB DATABASE ** (https://lckb.dev/forum/forumdisplay.php?fid=109)
+--- Forum: Release Zone (https://lckb.dev/forum/forumdisplay.php?fid=190)
+---- Forum: Episode 1 Releases (https://lckb.dev/forum/forumdisplay.php?fid=191)
+----- Forum: Server Side (https://lckb.dev/forum/forumdisplay.php?fid=113)
+----- Thread: [Releases] Starter Pack (/showthread.php?tid=227)
- Gothic - 01-16-2012
Oh sry ,
Download link is "Fail"
The Download Link is work i have test.
- julianzzz - 01-16-2012
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
- StyLeRZockeR - 01-17-2012
Gothic u Connector is only for 10 People !
"Error" than "Account is in Use"
- royalz101 - 01-17-2012
I got one problem ... i can not drop or create accessorys on this server .. i made a lil vid of my problem .. doesnt matter if i wanna drop them with seals or not (seals work on armor or weaps .. )
in the vid i only tried with /itemdrop 1717 and 2727 (both rings)
2
btw: i edited the DB thats why i could use the commands after create my char .. (the accessorys didnt worked before i changed that .. )
- robino1996 - 01-17-2012
try ID 2738
- Haanskoopf - 01-17-2012
how the rates are on this server?
- Paramount - 01-17-2012
Why things have to change into a gold?
- trex600 - 01-17-2012
for some reason i get an error when useing the connector ive downloaded both v2 client and server and installed to © useing hamachi too i dont know if you have to use xamp please help thankyou in advance
- emotyp101 - 01-19-2012
Ich bekomme beim erstellen eines neuen Charakters immer die fehlermeldung "Unknown error."
Da kommt sobald ich auf OK drücke beim Charakter erstellen.
Irgend eine Idee wie man es beheben kann?
- Koko - 01-19-2012
Ich bekomme beim erstellen eines neuen Charakters immer die fehlermeldung "Unknown error."
Da kommt sobald ich auf OK drücke beim Charakter erstellen.
Irgend eine Idee wie man es beheben kann?
Read the rules. 1st warning.