Discuz!新增允许用户浏览个人资料页需要升级的数据库语句

admin · 发表于 2021-7-19 11:33:15

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

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

×

Discuz!新增允许用户浏览个人资料页需要升级的数据库语句：

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

复制代码

©dz插件网所发布的一切资源仅限用于学习和研究目的；不得将上述内容用于商业或者非法用途，否则，一切后果请用户自负。
本站信息来自网络，版权争议与本站无关。您必须在下载后的24个小时之内，从您的电脑中彻底删除上述内容。如果您喜欢该程序，请支持正版软件，得到更好的正版服务。
如有侵权请邮件与我们联系处理:discuz-x@qq.com（手机随时接收邮件）并出示相关证明以便删除。敬请谅解！