积分兑奖插件 1.0

帮帮忙解决下啊

这个不错，增强互动功能！

1# freespy


这个不错,哎就是我站上没人,郁闷ing.....

有一张图片放错路劲……

怎么说奖品描述不能为空，怎么添加都是这个问题无法解决呀！？？？？楼主

问题得到解决，感谢楼主，辛苦~~~辛苦！

a不能用啊！

顶呀，太谢谢你了

MySQL Error
Message: MySQL Query Error
SQL: CREATE TABLE IF NOT EXISTS uchome_award_info ( `id` int(4) unsigned NOT NULL auto_increment, `awardno` varchar(16) collate gbk_bin NOT NULL COMMENT '奖品编号', `awardname` varchar(20) collate gbk_bin NOT NULL COMMENT '奖品名称', `credit` int(4) NOT NULL COMMENT '所需积分', `remain` smallint(6) unsigned default '0' COMMENT '剩余数量', `exchange` smallint(6) unsigned default '0' COMMENT '已兑换数量', `isopen` tinyint(1) NOT NULL COMMENT '开启标志 1：可以兑换 0：不可以', `awardimg` varchar(255) collate gbk_bin NOT NULL COMMENT '奖品图片', `description` text collate gbk_bin NOT NULL COMMENT '奖品简介', `orders` int(4) default NULL COMMENT '排序', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=gbk COLLATE=gbk_bin COMMENT='奖品分类信息表';
Error: 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 'collate gbk_bin NOT NULL COMMENT '奖品编号', `awardname` var
Errno.: 1064

MySQL Error
Message: MySQL Query Error
SQL: CREATE TABLE IF NOT EXISTS uchome_award_info ( `id` int(4) unsigned NOT NULL auto_increment, `awardno` varchar(16) collate gbk_bin NOT NULL COMMENT '奖品编号', `awardname` varchar(20) collate gbk_bin NOT NULL COMMENT '奖品名称', `credit` int(4) NOT NULL COMMENT '所需积分', `remain` smallint(6) unsigned default '0' COMMENT '剩余数量', `exchange` smallint(6) unsigned default '0' COMMENT '已兑换数量', `isopen` tinyint(1) NOT NULL COMMENT '开启标志 1：可以兑换 0：不可以', `awardimg` varchar(255) collate gbk_bin NOT NULL COMMENT '奖品图片', `description` text collate gbk_bin NOT NULL COMMENT '奖品简介', `orders` int(4) default NULL COMMENT '排序', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=gbk COLLATE=gbk_bin COMMENT='奖品分类信息表';
Error: 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 'collate gbk_bin NOT NULL COMMENT '奖品编号', `awardname` var
Errno.: 1064


为什么我安装出现上面的代码呢？