Nó không chạy trực tiếp trên client của KingSoft như Hoà quảng cáo đâu :(
cần chứ cái file jxqy.sql cần phải sửa 1 chỗ mơi import vào mysql đc
mởi jxqy.sql lên tìm cụm ENGINE=InnoDB xoá bỏ nó đi rồi import vào mysql.(nó có 2 cụm ENGINE=InnoDB)
<b><font color=red>[Chỉ có thành viên mới xem link được. <a href="register.php"> Nhấp đây để đăng ký thành viên......</a>]</font></b>
/*
MySQL Data Transfer
Source Host: 127.0.0.1
Source Database: jxdb
Target Host: 127.0.0.1
Target Database: jxdb
Date: 2010-12-1 22:31:10
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for account_habitus
-- ----------------------------
DROP TABLE IF EXISTS `account_habitus`;
CREATE TABLE `account_habitus` (
`iid` bigint(32) NOT NULL AUTO_INCREMENT,
`cAccName` varchar(32) NOT NULL,
`iFlag` tinyint(4) DEFAULT NULL,
`iLeftSecond` int(32) DEFAULT '999',
`dBeginDate` datetime DEFAULT NULL,
`iLeftMonth` smallint(6) DEFAULT '999',
`dEndDate` datetime DEFAULT NULL,
`iClientID` bigint(32) unsigned zerofill DEFAULT NULL,
`nExtPoint` bigint(32) unsigned DEFAULT '999',
`dLoginDate` datetime DEFAULT NULL,
`dLoginout` datetime DEFAULT NULL,
PRIMARY KEY (`iid`),
UNIQUE KEY `cAccName` (`cAccName`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Table structure for account_info
-- ----------------------------
DROP TABLE IF EXISTS `account_info`;
CREATE TABLE `account_info` (
`iid` bigint(32) NOT NULL AUTO_INCREMENT,
`cAccName` varchar(32) NOT NULL,
`cPassWord` char(64) NOT NULL,
`cRealName` varchar(32) DEFAULT NULL,
`dBirthDay` datetime DEFAULT NULL,
`cArea` varchar(60) DEFAULT NULL,
`cIDNum` varchar(30) DEFAULT NULL,
`dRegDate` datetime DEFAULT NULL,
`cPhone` varchar(50) DEFAULT NULL,
`iClientID` bigint(32) DEFAULT NULL,
`dLogoutDate` varchar(32) DEFAULT NULL,
`dLoginDate` varchar(32) DEFAULT NULL,
`dLoginout` varchar(32) DEFAULT NULL,
`cSecPassword` varchar(32) NOT NULL,
PRIMARY KEY (`iid`),
UNIQUE KEY `cAccName` (`cAccName`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Table structure for fightskill
-- ----------------------------
DROP TABLE IF EXISTS `fightskill`;
CREATE TABLE `fightskill` (
`iid` bigint(32) unsigned NOT NULL,
`iUId` int(8) NOT NULL,
`iUserId` bigint(32) unsigned NOT NULL,
`iFightSkill` int(32) NOT NULL,
`iFightSkillLevel` int(8) NOT NULL,
PRIMARY KEY (`iid`),
KEY `jxfkidx` (`iUserId`,`iUId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Table structure for itemlist
-- ----------------------------
DROP TABLE IF EXISTS `itemlist`;
CREATE TABLE `itemlist` (
`iid` bigint(32) NOT NULL AUTO_INCREMENT,
`iUid` int(8) NOT NULL,
`iUserId` bigint(32) unsigned NOT NULL,
`iEquipClassCode` int(32) DEFAULT NULL,
`iLocal` int(32) DEFAULT NULL,
`iX` int(32) DEFAULT NULL,
`iY` int(32) DEFAULT NULL,
`iEquipCode` int(32) DEFAULT NULL,
`iParticularType` int(32) DEFAULT NULL,
`iLevel` int(32) DEFAULT NULL,
`iSeries` int(32) DEFAULT NULL,
`iEquipVersion` int(32) DEFAULT NULL,
`iRandSeed` int(32) DEFAULT NULL,
`iParam1` int(32) DEFAULT NULL,
`iParam2` int(32) DEFAULT NULL,
`iParam3` int(32) DEFAULT NULL,
`iParam4` int(32) DEFAULT NULL,
`iParam5` int(32) DEFAULT NULL,
`iParam6` int(32) DEFAULT NULL,
`iLucky` int(32) DEFAULT NULL,
`iIdentify` int(32) DEFAULT NULL,
`iDurability` int(32) DEFAULT NULL,
`idetailtype` int(32) DEFAULT NULL,
`iintensify` int(32) DEFAULT '0',
`iaddskillnum` int(32) DEFAULT '0',
`iaddskillpoint` int(32) DEFAULT '0',
`iMarkPrice` int(32) DEFAULT '0',
PRIMARY KEY (`iid`),
KEY `jxilidx` (`iUserId`,`iUid`)
) ENGINE=InnoDB AUTO_INCREMENT=2120011578 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Table structure for lifeskill
-- ----------------------------
DROP TABLE IF EXISTS `lifeskill`;
CREATE TABLE `lifeskill` (
`iid` bigint(32) unsigned NOT NULL,
`iUid` int(8) NOT NULL,
`iUserId` bigint(32) unsigned NOT NULL,
`iLifeSkill` int(32) NOT NULL,
`iLifeSkillLevel` int(8) NOT NULL,
PRIMARY KEY (`iid`),
KEY `jxlkidx` (`iUserId`,`iUid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Table structure for role_info
-- ----------------------------
DROP TABLE IF EXISTS `role_info`;
CREATE TABLE `role_info` (
`iid` bigint(32) NOT NULL AUTO_INCREMENT,
`cAccName` varchar(32) NOT NULL,
`cUserName` varchar(32) NOT NULL,
`bSex` int(4) NOT NULL,
`cAlias` varchar(32) DEFAULT NULL,
`iSect` int(32) DEFAULT NULL,
`iSectRole` int(32) DEFAULT NULL,
`iGroupRole` int(32) DEFAULT NULL,
`iGroupCode` int(32) DEFAULT NULL,
`cPartnerCode` varchar(32) DEFAULT NULL,
`iMoney` int(32) NOT NULL,
`iFiveProp` int(32) DEFAULT NULL,
`iTeam` int(32) DEFAULT NULL,
`iFightLevel` int(32) DEFAULT NULL,
`iFightExp` int(32) DEFAULT NULL,
`iLeadLevel` int(32) DEFAULT NULL,
`iLeadExp` int(32) DEFAULT NULL,
`iLiveExp` int(32) DEFAULT NULL,
`iPower` int(32) DEFAULT NULL,
`iAgility` int(32) DEFAULT NULL,
`iOuter` int(32) DEFAULT NULL,
`iInside` int(32) DEFAULT NULL,
`iLuck` int(32) DEFAULT NULL,
`iMaxLife` int(32) DEFAULT NULL,
`iMaxStamina` int(32) DEFAULT NULL,
`iMaxInner` int(32) DEFAULT NULL,
`iLeftProp` int(32) DEFAULT NULL,
`iLeftFight` int(32) DEFAULT NULL,
`iLeftLife` int(32) DEFAULT NULL,
`iFirstSect` int(32) DEFAULT NULL,
`iFightMode` int(32) DEFAULT NULL,
`iUseRevive` int(32) DEFAULT NULL,
`iIsExchange` int(32) DEFAULT NULL,
`iPkStatus` int(32) DEFAULT NULL,
`iJoinCount` int(32) DEFAULT NULL,
`iRevivalid` int(32) DEFAULT NULL,
`iRevivalx` int(32) DEFAULT NULL,
`iRevivaly` int(32) DEFAULT NULL,
`iEnterGameId` int(32) DEFAULT NULL,
`iEnterGamex` int(32) DEFAULT NULL,
`iEnterGamey` int(32) DEFAULT NULL,
`iSaveMoney` int(32) DEFAULT NULL,
`iCurLife` int(32) DEFAULT NULL,
`iCurStamina` int(32) DEFAULT NULL,
`iCurInner` int(32) DEFAULT NULL,
`iPKValue` int(32) DEFAULT NULL,
`iFinishGame` int(32) DEFAULT NULL,
`iArmorRes` int(32) DEFAULT NULL,
`iWeaponRes` int(32) DEFAULT NULL,
`iHelmRes` int(32) DEFAULT NULL,
`iSectStat` int(32) DEFAULT NULL,
`iWorldStat` int(32) DEFAULT NULL,
`iKillPeopleNumber` int(32) DEFAULT NULL,
`iForbiddenFlag` int(32) DEFAULT NULL,
`iTongID` int(32) DEFAULT NULL,
`iDoubExpNum` int(32) DEFAULT '0',
`iDoubExpTime` int(32) DEFAULT '0',
`iluckvalue` int(32) DEFAULT '0',
`iprestige` int(32) DEFAULT '0',
`iNewRole` int(32) DEFAULT NULL,
`cMarkAdv` varchar(32) DEFAULT NULL,
PRIMARY KEY (`iid`),
UNIQUE KEY `cUserName` (`cUserName`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Table structure for serverlist
-- ----------------------------
DROP TABLE IF EXISTS `serverlist`;
CREATE TABLE `serverlist` (
`iid` int(32) NOT NULL AUTO_INCREMENT,
`cServerName` varchar(32) DEFAULT NULL,
`cPassword` varchar(32) DEFAULT NULL,
`iClient` bigint(32) DEFAULT NULL,
PRIMARY KEY (`iid`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Table structure for task_list
-- ----------------------------
DROP TABLE IF EXISTS `task_list`;
CREATE TABLE `task_list` (
`iid` bigint(32) unsigned NOT NULL,
`iUid` int(8) NOT NULL,
`iUserId` bigint(32) unsigned NOT NULL,
`iTaskCode` int(8) NOT NULL,
`iDegree` int(8) NOT NULL,
PRIMARY KEY (`iid`),
KEY `jxtlidx` (`iUserId`,`iUid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Table structure for tongdb
-- ----------------------------
DROP TABLE IF EXISTS `tongdb`;
CREATE TABLE `tongdb` (
`iid` bigint(32) NOT NULL AUTO_INCREMENT,
`cName` varchar(32) CHARACTER SET utf8 NOT NULL,
`iCamp` int(8) NOT NULL,
`iMoney` bigint(32) DEFAULT '0',
`iCredit` int(32) DEFAULT '0',
`iLevel` int(8) DEFAULT '0',
`cPassword` varchar(32) CHARACTER SET utf8 DEFAULT NULL,
`cMasterTitle` varchar(32) CHARACTER SET utf8 NOT NULL,
`cDirectorTitle1` varchar(32) CHARACTER SET utf8 NOT NULL,
`cDirectorTitle2` varchar(32) CHARACTER SET utf8 NOT NULL,
`cDirectorTitle3` varchar(32) CHARACTER SET utf8 NOT NULL,
`cDirectorTitle4` varchar(32) CHARACTER SET utf8 NOT NULL,
`cDirectorTitle5` varchar(32) CHARACTER SET utf8 NOT NULL,
`cDirectorTitle6` varchar(32) CHARACTER SET utf8 NOT NULL,
`cDirectorTitle7` varchar(32) CHARACTER SET utf8 NOT NULL,
`cNormalTitle` varchar(32) CHARACTER SET utf8 NOT NULL,
`cManagerTitle1` varchar(32) CHARACTER SET utf8 NOT NULL,
`cManagerTitle2` varchar(32) NOT NULL,
`cManagerTitle3` varchar(32) NOT NULL,
`cManagerTitle4` varchar(32) NOT NULL,
`cManagerTitle5` varchar(32) NOT NULL,
`cManagerTitle6` varchar(32) NOT NULL,
`cManagerTitle7` varchar(32) NOT NULL,
`cManagerTitle8` varchar(32) NOT NULL,
`cManagerTitle9` varchar(32) NOT NULL,
`cManagerTitle10` varchar(32) NOT NULL,
`cManagerTitle11` varchar(32) NOT NULL,
`cManagerTitle12` varchar(32) NOT NULL,
`cManagerTitle13` varchar(32) NOT NULL,
`cManagerTitle14` varchar(32) NOT NULL,
`cManagerTitle15` varchar(32) NOT NULL,
`cManagerTitle16` varchar(32) NOT NULL,
PRIMARY KEY (`iid`,`cName`),
UNIQUE KEY `cName` (`cName`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;
-- ----------------------------
-- Table structure for tongmember
-- ----------------------------
DROP TABLE IF EXISTS `tongmember`;
CREATE TABLE `tongmember` (
`iid` bigint(32) NOT NULL AUTO_INCREMENT,
`cName` varchar(32) CHARACTER SET utf8 NOT NULL,
`iTongId` bigint(32) NOT NULL,
`iMemberClass` int(8) NOT NULL,
`iTitleIndex` bigint(32) NOT NULL,
PRIMARY KEY (`iid`),
UNIQUE KEY `cName` (`cName`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;
-- ----------------------------
-- Records
-- ----------------------------