sidanlovehan
28-07-13, 01:40 PM
Mình nhận đông từ sứ giả HD toàn dis server. bạn nào biết cách fix thì chỉ mình với, thanks nhiều.
đây là cái Jxaccount của mình:
/*
MySQL Data Transfer
Source Host: localhost
Source Database: jxaccount
Target Host: localhost
Target Database: jxaccount
Date: 12/06/2013 12:07:17 SA
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for account
-- ----------------------------
DROP TABLE IF EXISTS `account`;
CREATE TABLE IF NOT EXISTS `account` (
`accid` int(10) NOT NULL auto_increment,
`loginName` char(32) NOT NULL,
`password_hash` char(64) NOT NULL,
`xu` int(6) NOT NULL default '0',
`Coin` int(14) DEFAULT '0',
`cPhone` char(32) NOT NULL,
`cEMail` char(32) default NULL,
`cRealName` char(32) default NULL COMMENT 'CMTND',
`cQuestion` varchar(50) default NULL,
`cAnswer` varchar(50) default NULL,
`time` varchar(20) default NULL,
`checkMember` int(1) NOT NULL default '1',
`LockState` int(1) NOT NULL default '0',
`lockpassword` int(8) NOT NULL default '0',
`safecode` int(12) DEFAULT NULL,
PRIMARY KEY (`accid`),
UNIQUE KEY `loginName` (`loginName`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `account`
--
-- ----------------------------
-- Table structure for `serverlist`
-- ----------------------------
DROP TABLE IF EXISTS `serverlist`;
CREATE TABLE `serverlist` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`servername` varchar(50) CHARACTER SET utf8 NOT NULL DEFAULT '',
`interfaceurl` varchar(100) CHARACTER SET utf8 NOT NULL DEFAULT '',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=gb2312;
-- ----------------------------
-- Table structure for jxsf8_paycoin
-- ----------------------------
DROP TABLE IF EXISTS `jxsf8_paycoin`;
CREATE TABLE `jxsf8_paycoin` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`account` varchar(50) CHARACTER SET utf8 NOT NULL DEFAULT '',
`addcoin` int(11) unsigned NOT NULL DEFAULT '0',
`jbcoin` int(11) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=gb2312;
-- ----------------------------
-- Table structure for jxsf8_paylog
-- ----------------------------
DROP TABLE IF EXISTS `jxsf8_paylog`;
CREATE TABLE `jxsf8_paylog` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`account` varchar(50) CHARACTER SET utf8 NOT NULL DEFAULT '',
`addcoin` int(11) unsigned NOT NULL DEFAULT '0',
`time` datetime NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=gb2312;
-- ----------------------------
-- Records
-- ----------------------------
và đây là script:
local tbTuiGuangYuan = Npc:GetClass("tuiguangyuan");
tbTuiGuangYuan.TaskGourp = 3026;
tbTuiGuangYuan.TaskGourp1 = 3028;
tbTuiGuangYuan.TaskId_TanThu = 1;
tbTuiGuangYuan.tbItemInfo = {bForceBind=1,};
.......................
function tbTuiGuangYuan:NhanXuNapThe_OK()
if me.CountFreeBagCell() < 25 then
Dialog:Say("Phải Có 25 Ô Trống Trong Túi Hà nh Trang");
return 0;
end
local nRet = me.GetUserPayCoin();
local nSoXu = math.floor(nRet/10000)
if nRet ~= 0 then
local nCount1 = me.GetTask(self.TaskGourp, self.TaskId_TanThu);
if nCount1 < 1 then
me.AddJbCoin(-1*nRet)
me.AddStackItem(18,10,11,2,nil,nSoXu)
me.Msg("<color=yellow>Nháºn <color=green>Quà Nạp Lần Äầu")
self:NhanXuNapThe_OK_Lan1()
bạn nào giúp phát
đây là cái Jxaccount của mình:
/*
MySQL Data Transfer
Source Host: localhost
Source Database: jxaccount
Target Host: localhost
Target Database: jxaccount
Date: 12/06/2013 12:07:17 SA
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for account
-- ----------------------------
DROP TABLE IF EXISTS `account`;
CREATE TABLE IF NOT EXISTS `account` (
`accid` int(10) NOT NULL auto_increment,
`loginName` char(32) NOT NULL,
`password_hash` char(64) NOT NULL,
`xu` int(6) NOT NULL default '0',
`Coin` int(14) DEFAULT '0',
`cPhone` char(32) NOT NULL,
`cEMail` char(32) default NULL,
`cRealName` char(32) default NULL COMMENT 'CMTND',
`cQuestion` varchar(50) default NULL,
`cAnswer` varchar(50) default NULL,
`time` varchar(20) default NULL,
`checkMember` int(1) NOT NULL default '1',
`LockState` int(1) NOT NULL default '0',
`lockpassword` int(8) NOT NULL default '0',
`safecode` int(12) DEFAULT NULL,
PRIMARY KEY (`accid`),
UNIQUE KEY `loginName` (`loginName`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `account`
--
-- ----------------------------
-- Table structure for `serverlist`
-- ----------------------------
DROP TABLE IF EXISTS `serverlist`;
CREATE TABLE `serverlist` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`servername` varchar(50) CHARACTER SET utf8 NOT NULL DEFAULT '',
`interfaceurl` varchar(100) CHARACTER SET utf8 NOT NULL DEFAULT '',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=gb2312;
-- ----------------------------
-- Table structure for jxsf8_paycoin
-- ----------------------------
DROP TABLE IF EXISTS `jxsf8_paycoin`;
CREATE TABLE `jxsf8_paycoin` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`account` varchar(50) CHARACTER SET utf8 NOT NULL DEFAULT '',
`addcoin` int(11) unsigned NOT NULL DEFAULT '0',
`jbcoin` int(11) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=gb2312;
-- ----------------------------
-- Table structure for jxsf8_paylog
-- ----------------------------
DROP TABLE IF EXISTS `jxsf8_paylog`;
CREATE TABLE `jxsf8_paylog` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`account` varchar(50) CHARACTER SET utf8 NOT NULL DEFAULT '',
`addcoin` int(11) unsigned NOT NULL DEFAULT '0',
`time` datetime NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=gb2312;
-- ----------------------------
-- Records
-- ----------------------------
và đây là script:
local tbTuiGuangYuan = Npc:GetClass("tuiguangyuan");
tbTuiGuangYuan.TaskGourp = 3026;
tbTuiGuangYuan.TaskGourp1 = 3028;
tbTuiGuangYuan.TaskId_TanThu = 1;
tbTuiGuangYuan.tbItemInfo = {bForceBind=1,};
.......................
function tbTuiGuangYuan:NhanXuNapThe_OK()
if me.CountFreeBagCell() < 25 then
Dialog:Say("Phải Có 25 Ô Trống Trong Túi Hà nh Trang");
return 0;
end
local nRet = me.GetUserPayCoin();
local nSoXu = math.floor(nRet/10000)
if nRet ~= 0 then
local nCount1 = me.GetTask(self.TaskGourp, self.TaskId_TanThu);
if nCount1 < 1 then
me.AddJbCoin(-1*nRet)
me.AddStackItem(18,10,11,2,nil,nSoXu)
me.Msg("<color=yellow>Nháºn <color=green>Quà Nạp Lần Äầu")
self:NhanXuNapThe_OK_Lan1()
bạn nào giúp phát