shopxo问答插件升级v3.0的方法

1. 先到商城后台，左侧 工具->sql控制台 执行以下sql

# v3.0.0
# 问答评论 - 问答
CREATE TABLE IF NOT EXISTS `{PREFIX}plugins_ask_comments` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '自增id',
`user_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '用户id',
`ask_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '问答id',
`ask_comments_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '问答评论id',
`reply_comments_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '一级回复评论id',
`status` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '状态（0待审核、1已审核、2已隐藏）',
`md5_key` char(32) NOT NULL DEFAULT '' COMMENT '数据唯一md5key',
`content` text COMMENT '评论内容',
`comments_count` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '评论总数',
`give_thumbs_count` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '点赞总数',
`add_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '添加时间',
`upd_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
PRIMARY KEY (`id`),
KEY `user_id` (`user_id`),
KEY `ask_id` (`ask_id`),
KEY `ask_comments_id` (`ask_comments_id`),
KEY `reply_comments_id` (`reply_comments_id`),
KEY `status` (`status`),
KEY `md5_key` (`md5_key`),
KEY `comments_count` (`comments_count`),
KEY `give_thumbs_count` (`give_thumbs_count`)
) ENGINE=InnoDB DEFAULT CHARSET={CHARSET} ROW_FORMAT=DYNAMIC COMMENT='问答评论 - 问答';
# 问答点赞 - 问答
CREATE TABLE IF NOT EXISTS `{PREFIX}plugins_ask_give_thumbs` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '自增id',
`user_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '用户id',
`ask_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '问答id',
`ask_comments_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '问答评论id',
`add_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '添加时间',
PRIMARY KEY (`id`),
KEY `user_id` (`user_id`),
KEY `ask_id` (`ask_id`),
KEY `ask_comments_id` (`ask_comments_id`)
) ENGINE=InnoDB DEFAULT CHARSET={CHARSET} ROW_FORMAT=DYNAMIC COMMENT='问答点赞 - 问答';
# 问答发布奖励积分日志
CREATE TABLE IF NOT EXISTS `{PREFIX}plugins_ask_give_integral_log` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '自增id',
`ask_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '问答id',
`user_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '用户id',
`integral` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '奖励积分',
`add_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '添加时间',
PRIMARY KEY (`id`),
KEY `ask_id` (`ask_id`),
KEY `user_id` (`user_id`),
KEY `integral` (`integral`),
KEY `add_time` (`add_time`)
) ENGINE=InnoDB DEFAULT CHARSET={CHARSET} ROW_FORMAT=DYNAMIC COMMENT='问答发布奖励积分日志 - 问答';
# 问答评论奖励积分日志
CREATE TABLE IF NOT EXISTS `{PREFIX}plugins_ask_comments_give_integral_log` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '自增id',
`ask_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '问答id',
`comments_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '评论id',
`user_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '用户id',
`integral` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '奖励积分',
`add_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '添加时间',
PRIMARY KEY (`id`),
KEY `ask_id` (`ask_id`),
KEY `comments_id` (`comments_id`),
KEY `user_id` (`user_id`),
KEY `integral` (`integral`),
KEY `add_time` (`add_time`)
) ENGINE=InnoDB DEFAULT CHARSET={CHARSET} ROW_FORMAT=DYNAMIC COMMENT='问答评论奖励积分日志 - 问答';
# 问答点赞奖励积分日志
CREATE TABLE IF NOT EXISTS `{PREFIX}plugins_ask_thumbs_give_integral_log` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '自增id',
`ask_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '问答id',
`comments_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '问答id',
`user_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '用户id',
`integral` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '奖励积分',
`add_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '添加时间',
PRIMARY KEY (`id`),
KEY `ask_id` (`ask_id`),
KEY `comments_id` (`comments_id`),
KEY `user_id` (`user_id`),
KEY `integral` (`integral`),
KEY `add_time` (`add_time`)
) ENGINE=InnoDB DEFAULT CHARSET={CHARSET} ROW_FORMAT=DYNAMIC COMMENT='问答点赞奖励积分日志 - 问答';
# 表重命名
RENAME TABLE `{PREFIX}answer` TO `{PREFIX}plugins_ask`;
RENAME TABLE `{PREFIX}plugins_answers_goods` TO `{PREFIX}plugins_ask_goods`;
RENAME TABLE `{PREFIX}plugins_answers_slider` TO `{PREFIX}plugins_ask_slider`;
# 插件名称
UPDATE `{PREFIX}plugins` SET `plugins`='ask' WHERE `plugins`='answers';
UPDATE `{PREFIX}attachment` SET `path_type`='plugins_ask' WHERE `path_type`='plugins_answers';
# 问答新增评论和点赞总数
ALTER TABLE `{PREFIX}plugins_ask` add `comments_count` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '评论总数' after `access_count`;
ALTER TABLE `{PREFIX}plugins_ask` add `give_thumbs_count` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '点赞总数' after `comments_count`;
# 问答新增商品id
ALTER TABLE `{PREFIX}plugins_ask` add `goods_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '商品id' after `user_id`;

2. 然后再去商店在线安装问答增强版插件

疯狂暗示打赏按钮

本文标签：

声明：本文由代码号注册/游客用户【阿兰】供稿发布，本站不对用户发布的shopxo问答插件升级v3.0的方法信息内容原创度和真实性等负责。如内容侵犯您的版权或其他权益，请留言并加以说明。站长审查之后若情况属实会及时为您删除。同时遵循 CC 4.0 BY-SA 版权协议，尊重和保护作者的劳动成果，转载请标明出处链接和本声明内容。本文作者：阿兰» https://www.ebingou.cn/dmh/16546.html

很赞哦！ ()