织梦dedecms会员中心模板-米微资源分享网

织梦 dedecms 会员中心模板，

模板名称：织梦 dedecms 会员中心模板带会员签到赚金币功能
会员中心使用方法：
一、将 member 文件夹上传覆盖网站根目录
二、后台添加统一页头页尾调用模板（具体操作请见截图）
三、在系统-SQL 命令行工具中运行一下 SQL 创建数据库：
(此为 utf-8)

PHP

    CREATE TABLE IF NOT EXISTS `mubanpu_qiandao` (
      `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
      `username` varchar(100) CHARACTER SET utf8 NOT NULL,
      `mood` text CHARACTER SET utf8 NOT NULL,
      `time` int(10) unsigned NOT NULL,
      `integrate` int(10) unsigned NOT NULL,
      `group` int(10) unsigned NOT NULL,
      `uname` char(60) CHARACTER SET utf8 NOT NULL,
      PRIMARY KEY (`id`),
      KEY `id` (`id`)
    ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=0 ;

(此为 gbk)

PHP

    CREATE TABLE IF NOT EXISTS `mubanpu_qiandao` (
      `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
      `username` varchar(100) CHARACTER SET gbk NOT NULL,
      `mood` text CHARACTER SET gbk NOT NULL,
      `time` int(10) unsigned NOT NULL,
      `integrate` int(10) unsigned NOT NULL,
      `group` int(10) unsigned NOT NULL,
      `uname` char(60) CHARACTER SET gbk NOT NULL,
      PRIMARY KEY (`id`),
      KEY `id` (`id`)
    ) ENGINE=MyISAM  DEFAULT CHARSET=gbk AUTO_INCREMENT=0 ;