本帖最后由 fulong0 于 2009-12-14 20:10 编辑
我想用APMServ5.2.6建立个开心农场单位局域网玩,准备工作都做好了,就是不会添加开心农场的数据库 数据库如下:
CREATE TABLE `uchome_plug_newfarm` (
`uid` mediumint(8) NOT NULL,
`farmlandstatus` text character set gbk NOT NULL,
`animal` text character set gbk NOT NULL,
`taskid` int(2) NOT NULL default '1',
`charm` int(10) NOT NULL default '0',
`money` int(10) NOT NULL default '0',
`exp` int(10) NOT NULL default '0',
`mc_exp` int(10) NOT NULL default '0',
`fb` int(10) NOT NULL default '0',
`reclaim` smallint(2) NOT NULL default '6',
`package` text character set gbk NOT NULL,
`mc_package` text character set gbk NOT NULL,
`fertilizer` text character set gbk NOT NULL,
`decorative` text character set gbk NOT NULL,
`fruit` text character set gbk NOT NULL,
`dog` text character set gbk NOT NULL,
`nosegay` text character set gbk NOT NULL,
`message` text character set gbk NOT NULL,
`mc_taskid` int(2) NOT NULL default '0',
`mc_taskid1` int(2) NOT NULL default '0',
`mc_log` text character set gbk NOT NULL,
`mc_chat` text character set gbk NOT NULL,
`wenzi` text character set gbk NOT NULL,
`log` text character set gbk NOT NULL,
`bad` text character set gbk NOT NULL,
`repertory` text character set gbk NOT NULL,
`expLimit` VARCHAR(30) NOT NULL DEFAULT '',
`parade` text character set gbk NOT NULL,
`dabian` TINYINT UNSIGNED NOT NULL DEFAULT 0,
PRIMARY KEY (`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;
===========================
日志部分SQL:
先执行
CREATE TABLE `uchome_plug_newfarm_logs` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`uid` int(11) NOT NULL,
`type` tinyint(4) NOT NULL,
`count` tinyint(4) NOT NULL,
`fromid` int(11) NOT NULL,
`time` int(11) NOT NULL,
`cropid` int(11) NOT NULL,
`isread` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;
再执行
update uchome_plug_newfarm set log="";
===========================
VIP部分SQL:
CREATE TABLE `uchome_plug_newfarm_vip` (
`uid` INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
`level` TINYINT UNSIGNED NOT NULL DEFAULT 1,
`vipstatus` TINYINT UNSIGNED NOT NULL DEFAULT 0,
`validtime` INTEGER UNSIGNED NOT NULL DEFAULT 0,
`jointime` INTEGER UNSIGNED NOT NULL DEFAULT 0,
`vippoint` INTEGER UNSIGNED NOT NULL DEFAULT 0,
`endtime` INTEGER UNSIGNED NOT NULL DEFAULT 0,
`rsign` INTEGER UNSIGNED NOT NULL DEFAULT 0,
PRIMARY KEY(`uid`)
)
ENGINE=MyISAM DEFAULT CHARSET=gbk;
请各位高手指点下,告诉我下详细的步骤就好了,如果能远程更是感激不尽。QQ:28000845
问题已经解决,还是要靠自己的啊~!高手除了“云天一”回了我个消息:“叫我问插件作者”,其他人都没理我,不屑一顾啊~!现在我把这弱弱的问题告诉一下新手,省的他们也问那就麻烦了: 登陆你的数据库---》点UCHOUME的数据库---》点数据库最上面的SQL---》粘贴插件作者给你的数据库码---》点执行。OK搞定了..... 好简单的问题啊~!我研究了俩天,郁闷到家了。如果你不会就加QQ问我吧!早8--晚12就此弱问题进行解答。搞难度的别问我,我是自学要成材的主,呵呵! |