It Does Not Help me with these files
ok I finished all that what do I put in navi for database my server name
[Err] 1046 - No database selected
[Err] /*
Navicat MySQL Data Transfer
Source Server : wokf
Source Server Version : 60004
Source Host : localhost:3306
Source Database : wokf
Target Server Type : MYSQL
Target Server Version : 60004
File Encoding : 65001
Date: 2012-12-10 13:13:13
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for `accountmaxlevel`
-- ----------------------------
DROP TABLE IF EXISTS `accountmaxlevel`;
CREATE TABLE `accountmaxlevel` (
`szAccountName` varchar(36) CHARACTER SET latin1 NOT NULL,
`Level` int(11) unsigned NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci ROW_FORMAT=DYNAMIC;
-- ----------------------------
-- Records of accountmaxlevel
-- ----------------------------
-- ----------------------------
-- Table structure for `arrestrole`
-- ----------------------------
DROP TABLE IF EXISTS `arrestrole`;
CREATE TABLE `arrestrole` (
`dwRoleID` int(11) unsigned NOT NULL DEFAULT '0',
`nSlaughter` int(11) NOT NULL,
`nLevel` int(11) NOT NULL,
`dwBloodDebt` int(11) unsigned NOT NULL,
`dwKillRep` int(11) unsigned NOT NULL,
`dwGuildID` int(11) unsigned NOT NULL,
`dwMateRoleID` int(11) unsigned NOT NULL,
`dwMapCrc` int(11) unsigned NOT NULL,
`wTileX` int(11) NOT NULL,
`wTileZ` int(11) NOT NULL,
`bOnline` tinyint(4) unsigned NOT NULL,
`bSex` tinyint(4) unsigned NOT NULL,
`eShape` tinyint(4) unsigned NOT NULL,
UNIQUE KEY `dwRoleID` (`dwRoleID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- ----------------------------
-- Records of arrestrole
-- ----------------------------
-- ----------------------------
-- Table structure for `banned`
-- ----------------------------
DROP TABLE IF EXISTS `banned`;
CREATE TABLE `banned` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`ip` varchar(255) NOT NULL DEFAULT '',
`time` varchar(255) NOT NULL DEFAULT '',
`long` varchar(255) NOT NULL DEFAULT '',
`reason` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb3;
-- ----------------------------
-- Records of banned
-- ----------------------------
-- ----------------------------
-- Table structure for `bbs`
-- ----------------------------
DROP TABLE IF EXISTS `bbs`;
CREATE TABLE `bbs` (
`dwCRC` int(11) unsigned NOT NULL,
`dwCharID` int(11) unsigned NOT NULL,
`dwParam` int(11) unsigned zerofill NOT NULL,
`szCharacter` varchar(300) NOT NULL,
UNIQUE KEY `dwCharID` (`dwCharID`,`dwParam`),
KEY `dwCRC` (`dwCRC`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- ----------------------------
-- Records of bbs
-- ----------------------------
-- ----------------------------
-- Table structure for `country`
-- ----------------------------
DROP TABLE IF EXISTS `country`;
CREATE TABLE `country` (
`eCountry` int(11) NOT NULL COMMENT '¹ú¼ÒID',
`dwKingID` int(11) unsigned NOT NULL COMMENT '¹úÖ÷ID',
`nPower` int(11) NOT NULL DEFAULT '0' COMMENT '¹ú¼Ò¹úÁ¦',
`nMoney` int(11) NOT NULL DEFAULT '0' COMMENT '¹ú¼Ò×ʽð',
`dwKingTransferTime` int(11) unsigned NOT NULL COMMENT 'ÉϴθüÌæ¹úÖ÷µÄʱ¼ä',
`eInterior` int(11) DEFAULT NULL COMMENT 'µ±Ç°ÕýÔÚÖ´ÐеÄÄÚÕþ',
`dwInteriorStartTime` int(11) unsigned NOT NULL COMMENT '¸ÃÄÚÕþ¿ªÊ¼µÄʱ¼ä',
`eActivity` int(11) DEFAULT NULL COMMENT 'µ±Ç°ÕýÔÚÖ´ÐеĻ',
`dwActivityStartTime` int(11) unsigned NOT NULL COMMENT '¸ÃÄÚÕþ¿ªÊ¼µÄʱ¼ä',
`nInteriorTimes` int(11) NOT NULL COMMENT 'ÄÚÕþÊ£Óà´ÎÊý',
`nMuteTimes` int(11) NOT NULL COMMENT '½ûÑÔÊ£Óà´ÎÊý',
`nAppointTimes` int(11) NOT NULL COMMENT 'ίÈÎÊ£Óà´ÎÊý',
`nActivityTimes` int(11) NOT NULL COMMENT '»î¶¯Ê£Óà´ÎÊý',
`nWarStatus` int(11) DEFAULT NULL COMMENT '¹úÕ½½á¹û',
`bGrantSalary` tinyint(1) NOT NULL COMMENT '±¾ÖÜÊÇ·ñ·¢·Å¹ýٺ»',
`dwGrantSalaryTime` int(11) unsigned NOT NULL DEFAULT '4294967295' COMMENT '·¢·Åٺ»µÄʱ¼ä',
`dwAttDiffRaceSetTime` int(11) unsigned NOT NULL DEFAULT '4294967295' COMMENT 'ÉÏÒ»´Î·¢²¼¹¥¿ËÒì×åÕ½µÄʱ¼ä',
`dwRobSetTime` int(11) unsigned NOT NULL DEFAULT '
[Err] 1046 - No database selected
[Err] CREATE TABLE `item_mall` (
`dwMallItemID` int(11) unsigned NOT NULL AUTO_INCREMENT,
`dwItemTypeID` int(11) unsigned NOT NULL,
`dwLargessTypeID` int(11) unsigned NOT NULL DEFAULT '4294967295',
`nItemNum` smallint(6) unsigned NOT NULL,
`nLargessNum` smallint(6) unsigned NOT NULL,
`dwPrice` int(11) unsigned NOT NULL,
`dwEndTime` int(11) unsigned NOT NULL DEFAULT '4294967295',
`wMallItemNum` smallint(6) unsigned NOT NULL DEFAULT '65535',
`wSellNum` int(11) unsigned NOT NULL,
`bHot` tinyint(4) unsigned NOT NULL,
`bNew` tinyint(4) unsigned NOT NULL,
`bRebate` tinyint(4) unsigned NOT NULL,
`wKind` mediumint(9) unsigned NOT NULL DEFAULT '0',
UNIQUE KEY `dwMallItemID` (`dwMallItemID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;
-- ----------------------------
-- Records of item_mall
-- ----------------------------
-- ----------------------------
-- Table structure for `limited_item`
-- ----------------------------
DROP TABLE IF EXISTS `limited_item`;
CREATE TABLE `limited_item` (
`dwTypeID` int(11) unsigned NOT NULL COMMENT '???dwTypeID',
`nNumLimited` int(11) unsigned NOT NULL COMMENT '???????',
`nNumPresent` int(11) unsigned NOT NULL COMMENT '?????????????',
PRIMARY KEY (`dwTypeID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- ----------------------------
-- Records of limited_item
-- ----------------------------
-- ----------------------------
-- Table structure for `login_log`
-- ----------------------------
DROP TABLE IF EXISTS `login_log`;
CREATE TABLE `login_log` (
`dwID` int(11) unsigned NOT NULL AUTO_INCREMENT,
`dwAccountID` int(11) unsigned NOT NULL,
`szAccountName` varchar(50) NOT NULL,
`szIP` varchar(16) NOT NULL,
`time` datetime NOT NULL,
`logout_Time` datetime DEFAULT NULL,
PRIMARY KEY (`dwID`),
KEY `dwAccountID` (`dwAccountID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COMMENT='µÇÈë¼Ç¼';
-- ----------------------------
-- Records of login_log
-- ----------------------------
-- ----------------------------
-- Table structure for `log_cardfill`
-- ----------------------------
DROP TABLE IF EXISTS `log_cardfill`;
CREATE TABLE `log_cardfill` (
`Uuid` char(36) NOT NULL,
`szAccount` char(36) DEFAULT NULL,
`szCardPwd` char(36) DEFAULT NULL,
`nCardType` int(11) DEFAULT NULL,
`dwRoleID` int(11) unsigned DEFAULT NULL,
`dwWorldCrc` int(11) unsigned DEFAULT NULL,
`dwErrorCode` int(11) DEFAULT NULL,
`nPoint` int(11) DEFAULT NULL,
`nYuanbao` int(11) DEFAULT NULL,
`time` datetime DEFAULT NULL,
PRIMARY KEY (`Uuid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 ROW_FORMAT=FIXED;
-- ----------------------------
-- Records of log_cardfill
-- ----------------------------
-- ----------------------------
-- Table structure for `log_cheatplayer`
-- ----------------------------
DROP TABLE IF EXISTS `log_cheatplayer`;
CREATE TABLE `log_cheatplayer` (
`dwRoleID` int(11) NOT NULL,
`szProcessName` varchar(64) NOT NULL,
`dwAccountID` int(11) unsigned NOT NULL,
`szRoleName` varchar(36) NOT NULL,
`dwMapNameCrc` int(11) unsigned NOT NULL,
`dwLevel` int(11) unsigned NOT NULL,
`dwDiscoveryTime` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
KEY `dwRoleID` (`dwRoleID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- ----------------------------
-- Records of log_cheatplayer
-- ----------------------------
-- ----------------------------
-- Table structure for `log_cheatrole`
-- ----------------------------
DROP TABLE IF EXISTS `log_cheatrole`;
CREATE TABLE `log_cheatrole` (
`dwID` int(11) unsigned NOT NULL COMMENT '??ID',
`time` date NOT NULL COMMENT '???????????',
KEY `dwID` (`dwID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
-- ----------------------------
-- Records of log_cheatrole
-- ----------------------------
-- ----------------------------
-- Table structure for `log_gm`
-- ----------------------------
DROP TABLE IF EXISTS `log_gm`;
CREATE TABLE `log_gm` (
`dwRoleID` int(11) unsigned NOT NULL,
`szComman
[Msg] Finished - Unsuccessfully
------------------------------------
mysql details in all config files including login server what does this mean please