感谢各位站长的支持, 本考试插件即日起免费啦,, 欢迎新站长安装测试和使用, 谢谢您的支持.
如果数据安装失败,请手动导入
CREATE TABLE IF NOT EXISTS `pre_tiny_exam3_buy` (
`bid` int(10) unsigned NOT NULL AUTO_INCREMENT,
`uid` mediumint(8) unsigned NOT NULL,
`pid` mediumint(8) unsigned NOT NULL DEFAULT '0',
`time` int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`bid`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COLLATE = utf8_general_ci;
CREATE TABLE IF NOT EXISTS `pre_tiny_exam3_cate` (
`cid` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
`ucid` mediumint(8) unsigned NOT NULL DEFAULT '0',
`name` varchar(50) NOT NULL,
`sort` smallint(3) unsigned NOT NULL DEFAULT '0',
`description` varchar(255) DEFAULT '',
`icon` varchar(125) DEFAULT '',
`paper_count` mediumint(8) unsigned DEFAULT '0',
`exam_count` int(10) unsigned DEFAULT '0',
`status` tinyint(1) unsigned NOT NULL DEFAULT '0',
`last` varchar(255) DEFAULT '',
PRIMARY KEY (`cid`,`ucid`,`sort`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COLLATE = utf8_general_ci;
CREATE TABLE IF NOT EXISTS `pre_tiny_exam3_exam` (
`eid` mediumint(10) unsigned NOT NULL AUTO_INCREMENT,
`uid` mediumint(8) unsigned NOT NULL DEFAULT '0',
`pid` mediumint(8) unsigned NOT NULL DEFAULT '0',
`cid` mediumint(8) unsigned NOT NULL DEFAULT '0',
`gid` mediumint(8) unsigned NOT NULL DEFAULT '0',
`tid` mediumint(10) unsigned NOT NULL DEFAULT '0',
`display` tinyint(1) unsigned NOT NULL DEFAULT '0',
`sort` mediumint(3) NOT NULL DEFAULT '0',
`subject` text NOT NULL,
`result` varchar(26) NOT NULL DEFAULT '',
`data` text NOT NULL,
`note` text NOT NULL,
`type` tinyint(1) unsigned NOT NULL,
`image` varchar(255) NOT NULL DEFAULT '',
`count_right` mediumint(8) unsigned NOT NULL DEFAULT '0',
`count_wrong` mediumint(8) unsigned NOT NULL DEFAULT '0',
`score` decimal(3,1) unsigned NOT NULL DEFAULT '0.0',
`addtime` int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`eid`,`pid`,`cid`,`gid`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COLLATE = utf8_general_ci;
CREATE TABLE IF NOT EXISTS `pre_tiny_exam3_group` (
`gid` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
`uid` mediumint(8) unsigned NOT NULL DEFAULT '0',
`pid` mediumint(8) unsigned NOT NULL DEFAULT '0',
`name` varchar(80) NOT NULL DEFAULT '',
`sort` mediumint(3) unsigned NOT NULL DEFAULT '0',
`score` decimal(3,1) unsigned NOT NULL DEFAULT '0.0',
`num_max` mediumint(3) DEFAULT NULL,
`content` text NOT NULL,
`assoc` varchar(255) NOT NULL DEFAULT '',
PRIMARY KEY (`gid`,`pid`,`sort`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COLLATE = utf8_general_ci;
CREATE TABLE IF NOT EXISTS `pre_tiny_exam3_log` (
`lid` int(10) unsigned NOT NULL AUTO_INCREMENT,
`uid` int(8) unsigned NOT NULL DEFAULT '0',
`pid` int(8) unsigned NOT NULL DEFAULT '0',
`cid` mediumint(8) unsigned NOT NULL DEFAULT '0',
`score` decimal(4,1) unsigned NOT NULL DEFAULT '0.0',
`starttime` int(10) unsigned NOT NULL DEFAULT '0',
`endtime` int(10) unsigned NOT NULL DEFAULT '0',
`status` tinyint(1) unsigned NOT NULL DEFAULT '0',
`commenttime` int(10) unsigned NOT NULL DEFAULT '0',
`total` decimal(5,1) NOT NULL DEFAULT '0.0',
`comment` varchar(255) NOT NULL DEFAULT '',
`userinfo` varchar(255) NOT NULL DEFAULT '',
PRIMARY KEY (`lid`,`uid`,`pid`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COLLATE = utf8_general_ci;
CREATE TABLE IF NOT EXISTS `pre_tiny_exam3_log_exam` (
`leid` int(10) unsigned NOT NULL AUTO_INCREMENT,
`eid` int(10) unsigned NOT NULL DEFAULT '0',
`lid` int(10) unsigned NOT NULL DEFAULT '0',
`uid` int(8) unsigned NOT NULL DEFAULT '0',
`pid` int(8) unsigned NOT NULL DEFAULT '0',
`cid` mediumint(8) unsigned NOT NULL DEFAULT '0',
`type` tinyint(1) unsigned NOT NULL DEFAULT '0',
`result` varchar(255) NOT NULL DEFAULT '',
`addtime` int(10) unsigned NOT NULL DEFAULT '0',
`status` tinyint(1) NOT NULL DEFAULT '0',
`score` decimal(3,1) unsigned DEFAULT NULL,
`score2` decimal(3,1) unsigned DEFAULT NULL,
PRIMARY KEY (`leid`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COLLATE = utf8_general_ci;
CREATE TABLE IF NOT EXISTS `pre_tiny_exam3_paper` (
`pid` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
`title` varchar(80) NOT NULL DEFAULT '',
`cid` mediumint(8) unsigned NOT NULL DEFAULT '0',
`uid` mediumint(8) unsigned NOT NULL DEFAULT '0',
`fgid` smallint(6) unsigned NOT NULL DEFAULT '0' COMMENT 'friend group',
`username` varchar(15) NOT NULL DEFAULT '',
`starttime` int(10) unsigned NOT NULL DEFAULT '0',
`edittime` int(10) unsigned DEFAULT '0',
`content` text NOT NULL,
`last_time` int(10) unsigned DEFAULT '0',
`last_user` varchar(15) NOT NULL DEFAULT '',
`pv` mediumint(6) unsigned NOT NULL DEFAULT '0',
`submit` mediumint(6) unsigned NOT NULL DEFAULT '0',
`minute` mediumint(6) unsigned DEFAULT NULL,
`pass` mediumint(6) unsigned DEFAULT NULL,
`pwd` varchar(6) NOT NULL DEFAULT '',
`price` mediumint(6) unsigned DEFAULT NULL,
`public` tinyint(1) NOT NULL DEFAULT '0',
`status` tinyint(1) NOT NULL DEFAULT '0',
`color` tinyint(1) unsigned NOT NULL DEFAULT '0',
`delay` smallint(6) unsigned DEFAULT NULL,
`twice` smallint(4) unsigned DEFAULT NULL,
`stick` tinyint(1) NOT NULL DEFAULT '0',
`wait` mediumint(6) unsigned NOT NULL DEFAULT '0',
`addtime` int(10) unsigned NOT NULL DEFAULT '0',
`long` int(10) unsigned NOT NULL DEFAULT '0',
`readgroup` varchar(255) NOT NULL DEFAULT '',
PRIMARY KEY (`pid`,`cid`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COLLATE = utf8_general_ci;
CREATE TABLE IF NOT EXISTS `pre_tiny_exam3_upload` (
`iid` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
`src` char(255) NOT NULL,
`uptime` int(10) unsigned DEFAULT '0',
`status` tinyint(1) unsigned NOT NULL DEFAULT '0',
`uid` mediumint(8) unsigned NOT NULL DEFAULT '0',
`eid` int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`iid`,`src`,`uid`,`eid`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COLLATE = utf8_general_ci;
CREATE TABLE IF NOT EXISTS `pre_tiny_exam3_wrong` (
`wid` int(10) unsigned NOT NULL AUTO_INCREMENT,
`eid` int(10) unsigned NOT NULL DEFAULT '0',
`uid` int(8) unsigned NOT NULL DEFAULT '0',
`pid` int(8) unsigned NOT NULL DEFAULT '0',
`cid` mediumint(8) unsigned NOT NULL DEFAULT '0',
`status` tinyint(1) unsigned NOT NULL DEFAULT '0',
`addtime` int(10) unsigned NOT NULL DEFAULT '0',
`tid` mediumint(10) unsigned NOT NULL DEFAULT '0',
`type` tinyint(1) NOT NULL DEFAULT '0',
`sys_result` varchar(255) NOT NULL DEFAULT '',
`user_result` varchar(255) NOT NULL DEFAULT '',
PRIMARY KEY (`wid`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COLLATE = utf8_general_ci;
-
当前版本
超级版(含手机版)-免费啦
-
2024-02-07 15:27
超级版(含手机版)-免费啦
X3.5 兼容
-
2024-01-06 21:53
超级版(含手机版)-免费啦
install.php 文件中将 替换CHARSET=GBK 为 CHARSET=utf8 COLLATE = utf8_general_ci
-
2019-11-06 19:53
超级版(含手机版)-免费啦
-
2019-07-08 13:46
超级版(含手机版)
更多历史版本信息
X3.5 兼容
install.php 文件中将 替换CHARSET=GBK 为 CHARSET=utf8 COLLATE = utf8_general_ci
修正php7.1
晚上视频功能, 试题中可以上传视频了
当试卷设置说明中添加音视频时, 则手机端下面导航添加一个音频按钮, 可以打开播放窗口, ( *** *** 个视频)
修复bug
修复因更改js ajax引起的中文编码问题
解决无手机版本提示
修正安卓版微信和QQ中提交问题
修正由于上次版本调整手机版引起电脑版无法显示考试结果
手机版增加显示本题解释
---------------------------------------------------------------------------------------------
M1.3.9: \\\"手机版\\\"和\\\"练习模式\\\"页面增加\\\"显示答案\\\"按钮,可以在后台开关
修正手机版交卷产生的错误
修正一部分文件, 数据库未改动
增加可以自定义考生信息输入框, 在打开试卷时候提示录入,同时增加一个相应的数据库字段 ,如下:
tiny_exam3_log表:
userinfo VARCHAR(255)
修正新增加的一伪静态BUG
数据库升级致命错误,重新发布
增加逐题考试模式,优化考试记录功能
题目面板增加缩小按钮,试卷管理增加可查看各选项答题命中率
MP3音乐等播放器代码修正
优化