自:
http://www.discuz.net/th...1-1-1.html論壇問卷，可以方便進行社區調查或收集會員資料。還可以用來製作簡單的論壇試題，帶計分功能。
以前做過一個，不過修改超複雜，而且容易出錯，估計可以排到[超難]安裝這類。因此這個五一重新寫了個問卷，利用了後台接口。所以目前安裝非常簡單，上傳文件+SQL就可以完成。不兼容之前的版本~以前安裝過5。0那個的請刪除掉。
升級數據庫：
mysql4.0 或以下
複製程式
CREATE TABLE `cdb_ques` (
`qid` int(10) unsigned NOT NULL auto_increment,
`subject` varchar(255) NOT NULL default '',
`dateline` int(10) NOT NULL default Ɔ',
`uid` mediumint(8) NOT NULL default Ɔ',
`username` varchar(255) NOT NULL default '',
`exp` int(10) NOT NULL default Ɔ',
`person` mediumint(8) NOT NULL default ཐ',
`stop` tinyint(1) NOT NULL default Ɔ',
`price` tinyint(1) NOT NULL default Ɔ',
PRIMARY KEY (`qid`)
) ENGINE=MyISAM;
CREATE TABLE `cdb_quesoption` (
`id` int(10) unsigned NOT NULL auto_increment,
`qid` int(10) unsigned NOT NULL,
`type` text NOT NULL default '',
`check` mediumtext NOT NULL default '',
`question` mediumtext NOT NULL default '',
`key` mediumtext NOT NULL default '',
`open` tinyint(1) NOT NULL default Ƈ',
`mark` mediumint(8) NOT NULL default Ɔ',
`amust` tinyint(1) NOT NULL default Ƈ',
`answeruser` mediumtext NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM;
CREATE TABLE `cdb_queslog` (
`lid` int(10) unsigned NOT NULL auto_increment,
`uid` int(10) unsigned NOT NULL default Ɔ',
`username` varchar(255) NOT NULL default '',
`dateline` int(10) NOT NULL default Ɔ',
`qid` int(10) unsigned NOT NULL,
`id` int(10) unsigned NOT NULL default Ɔ',
`answer` mediumtext NOT NULL default '',
`mark` mediumint(8) NOT NULL default Ɔ',
KEY (`lid`)
) TYPE=MyISAM;
mysql 4.1或以上
複製程式
CREATE TABLE `cdb_ques` (
`qid` int(10) unsigned NOT NULL auto_increment,
`subject` varchar(255) NOT NULL default '',
`dateline` int(10) NOT NULL default Ɔ',
`uid` mediumint(8) NOT NULL default Ɔ',
`username` varchar(255) NOT NULL default '',
`exp` int(10) NOT NULL default Ɔ',
`person` mediumint(8) NOT NULL default ཐ',
`stop` tinyint(1) NOT NULL default Ɔ',
`price` tinyint(1) NOT NULL default Ɔ',
PRIMARY KEY (`qid`)
) ENGINE=MyISAM DEFAULT CHARSET=big5;
CREATE TABLE `cdb_quesoption` (
`id` int(10) unsigned NOT NULL auto_increment,
`qid` int(10) unsigned NOT NULL,
`type` text NOT NULL default '',
`check` mediumtext NOT NULL default '',
`question` mediumtext NOT NULL default '',
`key` mediumtext NOT NULL default '',
`open` tinyint(1) NOT NULL default Ƈ',
`mark` mediumint(8) NOT NULL default Ɔ',
`amust` tinyint(1) NOT NULL default Ƈ',
`answeruser` mediumtext NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=big5;
CREATE TABLE `cdb_queslog` (
`lid` int(10) unsigned NOT NULL auto_increment,
`uid` int(10) unsigned NOT NULL default Ɔ',
`username` varchar(255) NOT NULL default '',
`dateline` int(10) NOT NULL default Ɔ',
`qid` int(10) unsigned NOT NULL,
`id` int(10) unsigned NOT NULL default Ɔ',
`answer` mediumtext NOT NULL default '',
`mark` mediumint(8) NOT NULL default Ɔ',
KEY (`lid`)
) TYPE=MyISAM DEFAULT CHARSET=big5;
