+- 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: Release - starter pack (/showthread.php?tid=763)
- xadas - 07-27-2012
kann mal einer mal die gilde in gang bekommen ich kann keine gilde erstellenund wie kann man denn shop (item Shop) mit sachen selber füllen
mfg
at first u need the cashop 3.0 than u have to update your server ( Gameserver, Database (!?), Connector (!?),....) and then u need the Catalog Editor 3.....
- alinux - 07-29-2012
why i cant execute sql files ? i get errors... ?
i get this when i try to import your 3 database files with navicat
[Err] 1046 - No database selected
[Err]
Navicat MySQL Data Transfer
Source Server SkyLight LC
Source Server Version 50516
Source Host localhost3306
Source Database newproject_data
Target Server Type MYSQL
Target Server Version 50516
File Encoding 65001
Date 2012-05-02 134724
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for `bg_user`
-- ----------------------------
DROP TABLE IF EXISTS `bg_user`;
CREATE TABLE `bg_user` (
`user_code` int(4) unsigned NOT NULL AUTO_INCREMENT,
`user_id` varchar(60) NOT NULL DEFAULT '',
`name` varchar(50) NOT NULL DEFAULT '',
`FamilyName` varchar(30) NOT NULL DEFAULT '',
`nickname` varchar(30) DEFAULT NULL,
`sub_name` varchar(30) NOT NULL DEFAULT '',
`sub_FamilyName` varchar(30) NOT NULL DEFAULT '',
`jumin` varchar(14) NOT NULL DEFAULT '000000-0000000',
`[CeNsOrEd]` char(1) NOT NULL DEFAULT 'M',
`passwd` varchar(60) NOT NULL DEFAULT '',
`passwd_hint` char(2) NOT NULL DEFAULT '00',
`passwd_text` varchar(120) DEFAULT NULL,
`passwd_answer` varchar(150) DEFAULT NULL,
`birth` varchar(10) DEFAULT NULL,
`birth_type` char(1) NOT NULL DEFAULT 'S',
`email` varchar(50) NOT NULL DEFAULT '',
`zipcode` varchar(10) DEFAULT NULL,
`address` varchar(200) DEFAULT NULL,
`region` varchar(10) NOT NULL DEFAULT '00',
`job` char(2) NOT NULL DEFAULT '00',
`phone` varchar(20) DEFAULT NULL,
`portable` varchar(20) DEFAULT NULL,
`wear_item` varchar(255) NOT NULL DEFAULT '0 0 0 0 0 0 0 0 0 0 0 0 0 1 1 1 0 0',
`gamvatar_item` varchar(34) NOT NULL DEFAULT '0 0 0 0 0 1 0',
`chk_adult` char(1) NOT NULL DEFAULT 'N',
`chk_email` char(1) NOT NULL DEFAULT 'Y',
`chk_memo` char(1) NOT NULL DEFAULT 'Y',
`chk_invitation` char(1) NOT NULL DEFAULT 'Y',
`chk_service` char(1) NOT NULL DEFAULT 'N',
`chk_service_bak` char(1) NOT NULL DEFAULT 'N',
`chk_SMS` char(1) NOT NULL DEFAULT 'Y',
`chk_parent` char(1) NOT NULL DEFAULT 'N',
`parent_name` varchar(30) DEFAULT NULL,
`parent_jumin` varchar(14) DEFAULT NULL,
`parent_phone` varchar(15) DEFAULT NULL,
`agree_method` char(1) DEFAULT NULL,
`parent_email` varchar(40) DEFAULT NULL,
`partner_user_id` varchar(30) DEFAULT NULL,
`partner_id` char(2) DEFAULT 'LC',
`site_id` char(2) NOT NULL DEFAULT 'LC',
`create_date` datetime NOT NULL DEFAULT '0000-00-00 000000',
`update_date` datetime DEFAULT '0000-00-00 000000',
`login_date` datetime DEFAULT NULL,
`logout_date` datetime DEFAULT NULL,
`login_count` smallint(2) unsigned NOT NULL DEFAULT '0',
`chk_tester` char(1) NOT NULL DEFAULT 'N',
`chk_tester1` char(1) NOT NULL DEFAULT 'N',
`chk_dup` char(1) NOT NULL DEFAULT 'N',
`chk_error` char(1) NOT NULL DEFAULT 'N',
`intro` varchar(255) DEFAULT NULL,
`chk_realname` char(1) NOT NULL DEFAULT 'Y',
`vote_id` varchar(30) DEFAULT NULL,
`chk_campaign` char(1) DEFAULT 'N',
`join_key` varchar(15) DEFAULT NULL,
`chk_closebeta` char(1) NOT NULL DEFAULT 'N',
PRIMARY KEY (`user_code`),
UNIQUE KEY `bg_user_id_idx` (`user_id`),
KEY `bg_user_login_idx` (`passwd`,`chk_service`,`chk_adult`,`chk_parent`,`jumin`,`chk_tester`,`nickname`,`name`),
KEY `bg_user_jumin_idx` (`jumin`),
KEY `bg_user_nickname_idx` (`nickname`),
KEY `bg_user_passwd_idx` (`passwd`),
KEY `bg_user_chkservice_idx` (`chk_service`),
KEY `bg_user_chkadult_idx` (`chk_adult`),
KEY `bg_user_partner_id_idx` (`partner_id`),
KEY `bg_user_site_id_idx` (`site_id`),
KEY `bg_user_create_date_idx` (`create_date`),
KEY `bg_user_name_idx` (`name`,`FamilyName`),
KEY `bg_user_chk_campaign` (`chk_campaign`)
) ENGINE=MyISAM AUTO_INCREMENT=173 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of bg_user
-- ----------------------------
-- ----------------------------
-- Table structure for `t_action`
-- ----------------------------
DROP TABLE IF EXISTS `t_action`;
CREATE TABLE `t_action` (
`a_index` int(11) NOT NULL DEFAULT '0',
`a_type` tinyint(4) NOT NULL DEFAULT '0',
[Msg] Finished - Unsuccessfully
--------------------------------------------------
- kevin - 07-30-2012
Other bug please help me :
clean you DB
- Creep - 07-30-2012
clean you DB
man just use the db from gothics pack but u only have to execute the t_guild part then it should work
- Accubens3 - 07-31-2012
Please help me guys
- halohalo - 07-31-2012
Image a bit small, try posting it here: 2
- Douglas Farias - 07-31-2012
look where stop game server =0
- thenightismy - 07-31-2012
alter könnt ihr das nicht selbst lösen
- Cruzaders - 07-31-2012
can't run dcs >.> damn haha
- rambokilllll - 08-01-2012
pls load the client on a other site maybe mediafire cause deposite is crap