I originally asked this on AlliedModders, but didn't get the answer I needed. (Original thread here - https://forums.alliedmods.net/showthread.php?t=291573)

What I would like to do is set it so when a player reaches a certain number of bans, their ban is automatically upgraded to a permanent ban.

So for example, on my servers we have a rule that your 6th ban is permanent, regardless of the reason. That means the first 5 aren't permanent (unless they are hacking), but ban number 6 always will be permanent.

On the original thread, I was told "you can do this yourself with a mysql query" but when I asked how to do that I got no response.

So could someone explain how to do this?