快速開啟道具會員權限 for discuz5.5
說明:
第1段SET所有用戶組
第2至最後SET個別用戶組複製內容到剪貼板
代碼:
UPDATE `cdb_usergroups` SET `magicsdiscount` = '0',`allowmagics` = '2',`maxmagicsweight` = '100';
UPDATE `cdb_usergroups` SET `magicsdiscount` = '1',`allowmagics` = '2',`maxmagicsweight` = '65533' WHERE `groupid` =1;
UPDATE `cdb_usergroups` SET `magicsdiscount` = '4',`allowmagics` = '2',`maxmagicsweight` = '50000' WHERE `groupid` =2;
UPDATE `cdb_usergroups` SET `magicsdiscount` = '5',`allowmagics` = '2',`maxmagicsweight` = '40000' WHERE `groupid` =3;
UPDATE `cdb_usergroups` SET `magicsdiscount` = '0',`allowmagics` = '0',`maxmagicsweight` = '0' WHERE `groupid` =4;
UPDATE `cdb_usergroups` SET `magicsdiscount` = '0',`allowmagics` = '0',`maxmagicsweight` = '0' WHERE `groupid` =5;
UPDATE `cdb_usergroups` SET `magicsdiscount` = '0',`allowmagics` = '0',`maxmagicsweight` = '0' WHERE `groupid` =6;
UPDATE `cdb_usergroups` SET `magicsdiscount` = '0',`allowmagics` = '0',`maxmagicsweight` = '0' WHERE `groupid` =7;
UPDATE `cdb_usergroups` SET `magicsdiscount` = '0',`allowmagics` = '0',`maxmagicsweight` = '0' WHERE `groupid` =8;