Remove all "Warning Points" for all my users

[Deleted member 10469]

Hello, I would like know how remove all Warning Points for all my user please, from xenforo or a sql line. Thanks.

 

[Mike]

Depending on the situation, you can't actually do it via SQL or in bulk. The warnings themselves would need to be expired/deleted via the relevant user's profile page. (The users with warnings could be identified based on the user_id values in the xf_warning table.)

 

[Deleted member 10469]

I can empty xf_warning table for delete all warning without problem please ?

 

[Mike]

No, there are potentially more data related to this and intertwined in other tables, so I couldn't recommend editing the DB directly.

 

[Xon]

I can empty xf_warning table for delete all warning without problem please ?

You should be able bulk update xf_warning.expired_date for all non-expired jobs and then run the cron task to allow all XenForo to expire the warnings.

This should clean up all warnings in bulk.

 

[rafass]

Hello, there are some way to disable the warning system in the board?

 

[Xon]

Hello, there are some way to disable the warning system in the board?

@AndyB 's Remove Warn addon is about the closest you can come to it.

 

[Jeremy]

You do not need an add-on to remove warning link under posts (as that seems it is all the add-on does.). Revoke the necessary permission to warn posts and it will disappear.

 

[rafass]

Thank you!

 

[KSA]

You should be able bulk update xf_warning.expired_date for all non-expired jobs and then run the cron task to allow all XenForo to expire the warnings.

This should clean up all warnings in bulk.

Would you recommend executing this query to have all non-expired warning to expire?

UPDATE `xf_warning` SET `expiry_date` = '1557878400'

 

[Xon]

This would be better (only change the expiry date of non-expired warnings)

UPDATE `xf_warning` SET `expiry_date` = '1557878400' where is_expired = 0

 

[KSA]

This would be better (only change the expiry date of non-expired warnings)

UPDATE `xf_warning` SET `expiry_date` = '1557878400' where is_expired = 0

That is better thanks for pointing that out. One more question if I may. Does expired points mean threshold will start from scratch? or will it consider points already given even if its expired? or threshold action only applies to non-expired points? XF warning system is a bit confusing.

 

[Xon]

It depends. Warning thresholds expire based on time or points, meaning you may still have a bunch of them hanging around.

 

[KSA]

It depends. Warning thresholds expire based on time or points, meaning you may still have a bunch of them hanging around.

We have it set based on time. But to avoid confusion, do you recommend doing something like:

UPDATE `xf_warning` SET `points` = '0'

 

[Xon]

No, as then XenForo will not process the expires

 

[KSA]

No, as then XenForo will not process the expires

cool will leave it that way but how is warning thresholds expire based points? I seem not to be able to find that!

 

[Joe Link]

This would be better (only change the expiry date of non-expired warnings)

UPDATE `xf_warning` SET `expiry_date` = '1557878400' where is_expired = 0

If I wanted to expire all warning points on a specific date, would this be the correct way?

UPDATE `xf_warning` SET `expiry_date` = '1557878400'

 

[Xon]

If I wanted to expire all warning points on a specific date, would this be the correct way?

You'll want to skip already expired warnings, with this sort of query:

UPDATE `xf_warning` SET `expiry_date` = 1557878400 where `expiry_date` < unix_timestamp() or is_expired = 1

 

[Joe Link]

Great, thanks!

 

[Joe Link]

You'll want to skip already expired warnings, with this sort of query:

UPDATE `xf_warning` SET `expiry_date` = 1557878400 where `expiry_date` < unix_timestamp() or is_expired = 1

I'm trying to understand this query, I'm still a bit of an SQL noob

From what I've been a able to gather, it looks like it's going to update warnings which either:

1. Have an expiration date before today's date.
2. Are already expired.

Wouldn't I want the opposite of this if I'm trying to expire all active warnings?

UPDATE `xf_warning` SET `expiry_date` = 1679507455 where `expiry_date` > unix_timestamp() or is_expired = 0