【Flash小游戏】柒瑞精品DiscuzX 2.0 插件(GBK) [20111215第5次更新]

往事流音 · 发表于 2012-2-27 16:53:52

MySQL 提示: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'sql_nkflash.sql' at line 1

我的也是。。。。

往事流音 · 发表于 2012-2-27 19:46:37

戦神丶孤焰发表于 2012-2-23 01:30
数据库升级的时候输入：sql_nkflash.sql 确提示You have an error in your SQL syntax; check the manua ...

数据库升级的时候不是输入：sql_nkflash.sq

而是

DROP TABLE IF EXISTS `pre_nkflash`;
CREATE TABLE IF NOT EXISTS `pre_nkflash` (
`game_id` varchar(15) NOT NULL DEFAULT '',
`game_type` char(1) NOT NULL DEFAULT '1',
`lastplay_time` int(10) unsigned NOT NULL DEFAULT '0',
`flash_url` varchar(30) NOT NULL DEFAULT '',
`flash_width` smallint(5) unsigned NOT NULL DEFAULT '500',
`flash_height` smallint(5) unsigned NOT NULL DEFAULT '500',
`flash_bgcolor` varchar(10) NOT NULL DEFAULT '#FFFFFF',
`game_title` varchar(20) NOT NULL DEFAULT '',
`play_fee` smallint(6) NOT NULL DEFAULT '0',
`bonus_rate` float unsigned NOT NULL DEFAULT '1',
`rate_limit` float NOT NULL DEFAULT '1',
`score_unit` varchar(10) NOT NULL DEFAULT '',
`game_img` varchar(30) NOT NULL DEFAULT '',
`game_details` text NOT NULL,
`played_times` smallint(5) unsigned NOT NULL DEFAULT '0',
`favorates` char(1) NOT NULL DEFAULT '0',
`medal_id` smallint(5) unsigned NOT NULL DEFAULT '0',
`uid_1` varchar(11) NOT NULL DEFAULT '0',
`score_1` double unsigned NOT NULL DEFAULT '0',
`level_1` tinyint(3) unsigned NOT NULL DEFAULT '0',
`dateline_1` int(10) unsigned NOT NULL DEFAULT '0',
`others_1` varchar(250) NOT NULL DEFAULT '',
`uid_2` varchar(11) NOT NULL DEFAULT '0',
`score_2` double unsigned NOT NULL DEFAULT '0',
`level_2` tinyint(3) unsigned NOT NULL DEFAULT '0',
`dateline_2` int(10) unsigned NOT NULL DEFAULT '0',
`others_2` varchar(250) NOT NULL DEFAULT '',
`uid_3` varchar(11) NOT NULL DEFAULT '0',
`score_3` double unsigned NOT NULL DEFAULT '0',
`level_3` tinyint(3) unsigned NOT NULL DEFAULT '0',
`dateline_3` int(10) unsigned NOT NULL DEFAULT '0',
`others_3` varchar(250) NOT NULL DEFAULT '',
`uid_4` varchar(11) NOT NULL DEFAULT '0',
`score_4` double unsigned NOT NULL DEFAULT '0',
`level_4` tinyint(3) unsigned NOT NULL DEFAULT '0',
`dateline_4` int(10) unsigned NOT NULL DEFAULT '0',
`others_4` varchar(250) NOT NULL DEFAULT '',
`uid_5` varchar(11) NOT NULL DEFAULT '0',
`score_5` double unsigned NOT NULL DEFAULT '0',
`level_5` tinyint(3) unsigned NOT NULL DEFAULT '0',
`dateline_5` int(10) unsigned NOT NULL DEFAULT '0',
`others_5` varchar(250) NOT NULL DEFAULT '',
`uid_6` varchar(11) NOT NULL DEFAULT '0',
`score_6` double unsigned NOT NULL DEFAULT '0',
`level_6` tinyint(3) unsigned NOT NULL DEFAULT '0',
`dateline_6` int(10) unsigned NOT NULL DEFAULT '0',
`others_6` varchar(250) NOT NULL DEFAULT '',
`uid_7` varchar(11) NOT NULL DEFAULT '0',
`score_7` double unsigned NOT NULL DEFAULT '0',
`level_7` tinyint(3) unsigned NOT NULL DEFAULT '0',
`dateline_7` int(10) unsigned NOT NULL DEFAULT '0',
`others_7` varchar(250) NOT NULL DEFAULT '',
`uid_8` varchar(11) NOT NULL DEFAULT '0',
`score_8` double unsigned NOT NULL DEFAULT '0',
`level_8` tinyint(3) unsigned NOT NULL DEFAULT '0',
`dateline_8` int(10) unsigned NOT NULL DEFAULT '0',
`others_8` varchar(250) NOT NULL DEFAULT '',
`uid_9` varchar(11) NOT NULL DEFAULT '0',
`score_9` double unsigned NOT NULL DEFAULT '0',
`level_9` tinyint(3) unsigned NOT NULL DEFAULT '0',
`dateline_9` int(10) unsigned NOT NULL DEFAULT '0',
`others_9` varchar(250) NOT NULL DEFAULT '',
`uid_10` varchar(11) NOT NULL DEFAULT '0',
`score_10` double unsigned NOT NULL DEFAULT '0',
`level_10` tinyint(3) unsigned NOT NULL DEFAULT '0',
`dateline_10` int(10) unsigned NOT NULL DEFAULT '0',
`others_10` varchar(250) NOT NULL DEFAULT '',
PRIMARY KEY (`game_id`),
KEY `played_times` (`played_times`),
KEY `medal_id` (`medal_id`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;
DROP TABLE IF EXISTS `pre_nkflash_player`;
CREATE TABLE IF NOT EXISTS `pre_nkflash_player` (
`uid` mediumint(8) unsigned NOT NULL DEFAULT '0',
`timestamp` int(10) unsigned NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=gbk;
DROP TABLE IF EXISTS `pre_threadtags`;
CREATE TABLE IF NOT EXISTS `pre_threadtags` (
`tagname` char(20) NOT NULL,
`tid` int(10) unsigned NOT NULL,
KEY `tagname` (`tagname`),
KEY `tid` (`tid`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;

复制代码

l

往事流音 · 发表于 2012-2-27 19:47:20

为什么没有游戏啊

book12345 · 发表于 2012-2-28 16:13:24

求帮我将这档案翻成繁体字~谢谢

jiangmoey · 发表于 2012-4-25 21:04:13

谢谢LZ分享，LZ好人

		自动登录	找回密码
密码			立即注册

[发布] 【Flash小游戏】柒瑞精品DiscuzX 2.0 插件(GBK) [20111215第5次更新]

本帖子中包含更多资源

[发布] 【Flash小游戏】 柒瑞精品DiscuzX 2.0 插件(GBK) [20111215第5次更新]

本帖子中包含更多资源

[发布] 【Flash小游戏】柒瑞精品DiscuzX 2.0 插件(GBK) [20111215第5次更新]