Discuz!X3.5新增允许用户上传头像功能需要升级的数据库语句

admin · 发表于 2021-6-30 10:56:31

马上注册，免费下载更多dz插件网资源。

您需要登录才可以下载或查看，没有账号？立即注册

×

Discuz!X3.5新增允许用户上传头像功能需要升级的数据库语句：

ALTER TABLE `pre_common_usergroup_field` ADD `allowavatarupload` tinyint(1) unsigned NOT NULL DEFAULT '0' AFTER `allowimgcontent`;
UPDATE `pre_common_usergroup_field` SET `allowavatarupload` = '1' WHERE `pre_common_usergroup_field`.`groupid` = 1;
UPDATE `pre_common_usergroup_field` SET `allowavatarupload` = '1' WHERE `pre_common_usergroup_field`.`groupid` = 2;
UPDATE `pre_common_usergroup_field` SET `allowavatarupload` = '1' WHERE `pre_common_usergroup_field`.`groupid` = 3;
UPDATE `pre_common_usergroup_field` SET `allowavatarupload` = '0' WHERE `pre_common_usergroup_field`.`groupid` = 4;
UPDATE `pre_common_usergroup_field` SET `allowavatarupload` = '0' WHERE `pre_common_usergroup_field`.`groupid` = 5;
UPDATE `pre_common_usergroup_field` SET `allowavatarupload` = '0' WHERE `pre_common_usergroup_field`.`groupid` = 6;
UPDATE `pre_common_usergroup_field` SET `allowavatarupload` = '0' WHERE `pre_common_usergroup_field`.`groupid` = 7;
UPDATE `pre_common_usergroup_field` SET `allowavatarupload` = '0' WHERE `pre_common_usergroup_field`.`groupid` = 8;
UPDATE `pre_common_usergroup_field` SET `allowavatarupload` = '0' WHERE `pre_common_usergroup_field`.`groupid` = 9;
UPDATE `pre_common_usergroup_field` SET `allowavatarupload` = '1' WHERE `pre_common_usergroup_field`.`groupid` = 10;
UPDATE `pre_common_usergroup_field` SET `allowavatarupload` = '1' WHERE `pre_common_usergroup_field`.`groupid` = 11;
UPDATE `pre_common_usergroup_field` SET `allowavatarupload` = '1' WHERE `pre_common_usergroup_field`.`groupid` = 12;
UPDATE `pre_common_usergroup_field` SET `allowavatarupload` = '1' WHERE `pre_common_usergroup_field`.`groupid` = 13;
UPDATE `pre_common_usergroup_field` SET `allowavatarupload` = '1' WHERE `pre_common_usergroup_field`.`groupid` = 14;
UPDATE `pre_common_usergroup_field` SET `allowavatarupload` = '1' WHERE `pre_common_usergroup_field`.`groupid` = 15;
UPDATE `pre_common_usergroup_field` SET `allowavatarupload` = '1' WHERE `pre_common_usergroup_field`.`groupid` = 16;
UPDATE `pre_common_usergroup_field` SET `allowavatarupload` = '1' WHERE `pre_common_usergroup_field`.`groupid` = 17;
UPDATE `pre_common_usergroup_field` SET `allowavatarupload` = '1' WHERE `pre_common_usergroup_field`.`groupid` = 18;
UPDATE `pre_common_usergroup_field` SET `allowavatarupload` = '1' WHERE `pre_common_usergroup_field`.`groupid` = 19;

复制代码

©DZ插件网所发布的一切资源仅限用于学习和研究目的；不得将上述内容用于商业或者非法用途，否则，一切后果请用户自负。
网站部分内容来源于网络，版权争议与本站无关。您必须在下载后的24个小时之内，从您的电脑中彻底删除上述内容。如果您喜欢该程序，请支持正版软件，得到更好的正版服务。
您在本站任何的赞助购买、下载、查阅、回复等行为等均表示接受并同意签订《DZ插件网免责声明协议》。
如有侵权请邮件与我们联系处理: discuzaddons@vip.qq.com 并出示相关证明以便删除。敬请谅解！