discuz6.1 卸载勋章中心的方法
卸载勋章中心6.1出现错误。怎么办,不要紧看好:
登陆PhpMyAdmin:
执行如下语句:
Drop TABLE IF EXISTS cdb_membermedal;
Drop TABLE IF EXISTS cdb_memberprice;
Delete FROM cdb_crons Where filename='medalcenter.inc.php';
这样就成功了
OK了,想重新装的话,只要在浏览器中输入:http://yourURL/ mc_install.php即可
===========
附:卸载后升级数据库方法,不想升级可不执行
Drop TABLE IF EXISTS cdb_membermedal;
Create TABLE cdb_membermedal (
uid mediumint(8) unsigned NOT NULL,
medalid smallint(5) unsigned NOT NULL,
outtime int(10) NOT NULL default '-1',
KEY uid (uid),
KEY medalid (medalid)
) TYPE=MyISAM;
Drop TABLE IF EXISTS cdb_memberprice;
Create TABLE cdb_memberprice (
uid mediumint(8) unsigned NOT NULL,
username char(15) NOT NULL,
medalid smallint(6) unsigned NOT NULL,
price int(10) NOT NULL,
pricetime int(10) NOT NULL,
KEY uid (uid),
KEY medalid (medalid),
KEY price (price)
) type=MyISAM;
Alter TABLE cdb_medals ADD type tinyint(2) UNSIGNED NOT NULL DEFAULT '1';
Alter TABLE cdb_medals ADD groupid int(8) UNSIGNED NOT NULL DEFAULT '0';
Alter TABLE cdb_medals ADD price int(8) UNSIGNED NOT NULL DEFAULT '0';
Alter TABLE cdb_medals ADD endtime int(10) UNSIGNED NOT NULL DEFAULT '0';
Alter TABLE cdb_medals ADD outtime int(10) NOT NULL DEFAULT '-1';
Insert INTO cdb_crons ( cronid , available , type , name , filename , lastrun , nextrun , weekday , day , hour , minute )
VALUES (
NULL , '1', 'system', ' 勋章中心配置文件', 'medalcenter.inc.php', '0', '0', '-1', '-1', '0', '0'
);