How to use the member center template of dedecms member center with the function of earning gold coins by members signing in:
1: Upload the member folder to cover the root directory of the website
2: Add unified header and footer calling templates in the background (see screenshots for specific operations)
Three: Run SQL in the system-SQL command line tool to create the database:
(This is utf-8)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;
(This is gbk)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;
Four: Open the membertempletshead.htm file and add the CSS style file link to the header and footer in this file.
Five: Backstage module management uploads the QQ login plug-in and promotion plug-in and then installs it
The specific installation method is included in the template compressed package!
Screenshot of member center: