原帖由 守住每一天 于 2006-10-2 23:24 发表
我用着出了点小问题
你能帮我看下吗? 游戏显示名称不对。。其它的都没问题
cs.bj-bbs.com 这是测试的。嘿嘿 还有 我按你说的在 forumdata/cache/里加了一行 在首页顶上有显示 麻烦你看下。。谢 ...
頂樓有寫,你的主机是 MYSQL 4.1 或以上, 或是你安装后,出现???般的乱码,请把最后一行改为:
) ENGINE=MyISAM DEFAULT CHARSET=gbk;
執行前先用
DROP TABLE IF EXISTS `cdb_nkflash`;
之後再
ALTER TABLE cdb_sessions CHANGE action action SMALLINT UNSIGNED NOT NULL DEFAULT '0';
CREATE TABLE cdb_nkflash (
game_id char(15) NOT NULL default '',
game_type tinyint(1) unsigned NOT NULL default '0',
lastplay_time int(10) unsigned NOT NULL default '0',
flash_url char(50) NOT NULL default '',
flash_width smallint(5) unsigned NOT NULL default '500',
flash_height smallint(5) unsigned NOT NULL default '500',
flash_bgcolor char(8) NOT NULL default 'white',
game_title char(20) NOT NULL default '',
play_fee tinyint(2) unsigned NOT NULL default '0',
bonus_rate float unsigned NOT NULL default '1',
rate_limit float unsigned NOT NULL default '1',
score_unit char(6) NOT NULL default '',
game_img char(50) NOT NULL default '',
game_details text NOT NULL,
played_times mediumint(8) unsigned NOT NULL default '0',
favorates char(1) NOT NULL default '0',
medal_id smallint(5) unsigned NOT NULL default '0',
uid_1 mediumint(8) unsigned 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 char(50) NOT NULL default '',
uid_2 mediumint(8) unsigned 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 char(50) NOT NULL default '',
uid_3 mediumint(8) unsigned 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 char(50) NOT NULL default '',
uid_4 mediumint(8) unsigned 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 char(50) NOT NULL default '',
uid_5 mediumint(8) unsigned 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 char(50) NOT NULL default '',
uid_6 mediumint(8) unsigned 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 char(50) NOT NULL default '',
uid_7 mediumint(8) unsigned 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 char(50) NOT NULL default '',
uid_8 mediumint(8) unsigned 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 char(50) NOT NULL default '',
uid_9 mediumint(8) unsigned 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 char(50) NOT NULL default '',
uid_10 mediumint(8) unsigned 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 char(50) NOT NULL default '',
PRIMARY KEY (game_id),
KEY played_times (played_times),
KEY medal_id (medal_id),
KEY lastplay_time (lastplay_time)
) ENGINE=MyISAM DEFAULT CHARSET=gbk; |