[Werewolf_UK]

I think the title explains it all really. I would like to see a feature added where a players ban is automatically upgraded to a permanent ban if they reach a target number of bans.

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.

At the moment this requires the admins to check the bans page to make sure the player is banned, and occasionally we have players reach 7th or 8th bans before someone realizes they should have been perma-banned before then.

All this feature would be is a way to automate the process.

[friagram]

you can do this yourself with a mysql query

[Werewolf_UK]

Originally Posted by friagram you can do this yourself with a mysql query

If so, how would I go about setting that up?

Also even if it is possible to do, it wouldn't hurt to add the option to the front end so that people who don't know how to do this can do it too. And for the sake of convenience.

[Werewolf_UK]

Necro-bumping. Still looking for help with this.

Specifically, how would I set up a mysql query to do this?

[Werewolf_UK]

Necro-Bumping again. See above posts.

[good_live]

Originally Posted by sgt_phsco If so, how would I go about setting that up?

You should create a Trigger on Insert into the bans table. Just count the existing ban entries for that userid and change banlength to permanent if there are x-1 ban entries.

I haven't looked into the db structure of sb, so i can't give you the complete query.

[Werewolf_UK]

Finally got this working thanks to u/GeneralGrenade over on r/PHPhelp

Solution was to create a trigger with the following:

IF (SELECT COUNT(bid) FROM `sb_bans` WHERE authid = NEW.authid) > 4 THEN
SET NEW.length = 0;
SET NEW.reason = CONCAT(NEW.reason, ' - 6th ban so permanent');
END IF