认证用户组临时解决方案

Jump to bottom Edit New page

Nroskill edited this page Jun 19, 2017 · 2 revisions

定时跑脚本

USE `forum`;
UPDATE `flarum_users_groups` 
SET `group_id` = 5 
WHERE `group_id` = 6 AND `user_id` in (
    SELECT `id` 
    FROM `flarum_users`
    WHERE `is_activated` = 1 AND email LIKE '%@cnu.edu.cn'
);