I am afraid this is not as simple as that.
If you are to delete aged warnings (and I believe one should do that), the task is a bit more involved than just deleting the warnings themselves. I believe that you should also reduce the points the member has accumulated, until that time, by the number of points associated with the warning you delete.
I tried to do such a thing, but it gets too complicated for my knowledge of queries. You have to fetch the user id, then go to the warnings table, get the warned_warning_id and from their find how many points are associated with this warning type and subtract these points from the user table. If you can do that, I guess you are solving one of the major issues with this hack.
And of course, the un-banning script will be a welcome improvement too.
Rgds
|