XF 2.2 Warning points query


Hey folks! I need to run a specific MySQL query --

I want to switch all 'expired' warning points to being current. We don't use an expiry policy on warning points, but some legacy points from previous iterations of the forums are shown as expired. I'd like everybody to show their current totals.

i.e. this score should be 14 not 8:

Screen Shot 2021-04-30 at 11.29.22 PM.webp

What would the MySQL query be for that?

Thanks in advance!
Top Bottom