Discuz! X modify "email verification status" and "Avatar Upload status" in batches.

Discuz! X modify "email verification status" and "Avatar Upload status" in batches.

In the anti-irrigation settings, you want to enable "force new user verification to activate the mailbox" and "force new users to upload the avatar". However, after the settings, the old members cannot see the "reply" button. Only the "post" button is displayed. I know that if you click "post", you will be prompted to re-verify the mailbox and upload the avatar. However, the old members have already verified the mailbox and the Avatar is clearly in use, why is it subject to this setting? So I wonder if I can change the existing member's email verification status and Avatar Upload status to "yes" in batches, so that the anti-irrigation settings will not affect old members, only new members are restricted. Q: Which table indicates whether the user has verified the email address and uploaded the avatar? Q: For SQL code, you can modify these two parameters in batches. Implementation method: If common_member emailstatus avatarstatus is set to 1, it is activated or has an avatar. Batch modification method: Discuz! X the background webmaster executes database commands (in red) Update table name set project = verify where uid <= newly registered Old Member ID value Update cdb_common_member set emailstatus = 1 where uid <= 100