XF 1.3 Expire All Warnings

[TeflonDon]

Is there a way to expire all warning points? SQL command maybe? I'm looking to revamp my warning system and would like to start the points from scratch.

Thanks

 

[TeflonDon]

Anyone?

 

[Mike]

There isn't an option to do that. There's potentially a lot of intertwined data here, so warnings should really be removed/expired via the user interface.

 

[TeflonDon]

There isn't an option to do that. There's potentially a lot of intertwined data here, so warnings should really be removed/expired via the user interface.

Is there atleast a way to find out which users have warning points?

 

[Paul B]

You can do it with a query:

SELECT user_id, username, warning_points FROM `xf_user` WHERE warning_points > 0

 

[TeflonDon]

You can do it with a query:

SELECT user_id, username, warning_points FROM `xf_user` WHERE warning_points > 0

Thank you.

 

[TeflonDon]

Just looking at doing this again. Would mass removing all warnings instead of expiring them present any sort of problem? @Brogan ?

 

[Paul B]

Yes, as Mike posted above, it really needs to be done via the UI.