Discuz!

In the anti-spam settings, I want to turn on "Forcing new users to verify and activate their email address" and "Forcing new users to upload avatars", but after setting them up, old members can no longer see the "Reply" button. Only the "Post" button is visible.

I know that if you click "Post", you will be prompted to re-verify your email and upload an avatar. However, old members have already verified their email and their avatar is clearly in use, so why are they subject to this setting? Constraints?

So I thought, can I batch modify the email verification status and avatar upload status of existing members to "Yes", so that the anti-spam settings will not affect old members, but only restrict new members.

Q: Which field in which table indicates whether the user has verified the email address and uploaded the avatar?

Q: Please provide SQL code to modify these two parameters in batches.

Explain the implementation method:

common_member emailstatus avatarstatus is activated for all 1, or has an avatar

Batch modification method:

Discuz! command( Red part)

update table name set item = whether to verify where uid <= the latest registered old member ID value

update cdb_common_member set emailstatus = 1 where uid <= 100