[Gammix]

GBan System
This is a simple and easy SQLite based ban system. I am using this instead of SAMP ban system which is crappy in my opinion!
This has IP. Range detection, thanks to R@f for that; With a nice temporary ban system, where you can either ban a player for 0 days i.e. Permanent or for any number of days upto a year (365 days)!

And i also made a nice textdraw when a player gets banned, this will be shown:


This is the ban dialog when you type in the command: /ban


You can also search for a ban and UnBan if needed to: /searchban


Required Libraries & Credits
KickBan Fix Include - https://github.com/Agneese-Saini/SA-...kickbanfix.inc
I-ZCMD include - https://sampforum.blast.hk/showthread.php?tid=576114
EasyDialog include (by Emmet_) - https://github.com/Agneese-Saini/SA-...easydialog.inc
Sscanf2 plugin - https://sampforum.blast.hk/showthread.php?tid=602923
TimeStampToDate include - https://sampforum.blast.hk/showthread.php?tid=347605

Download
https://github.com/Agneese-Saini/SA-...ripts/gban.pwn

[Logic_]

Leap Year support?

[Gammix]

Quote:

Originally Posted by Logic_ Leap Year support?

I am pretty sure this does have leap year support: https://sampforum.blast.hk/showthread.php?tid=347605

[Dayrion]

Ban_GetLongIP -> What is this for? Same question for BAN_MASK.
Thanks for answering me

[coool]

Looks nice.

[Eoussama]

Cool stuff,
however, why did you chose to work with this include while needless to say you can manage to have an even greater result by having a TIMESTAMP/DATETIME( if that's supported by SQLite ) column in your table?

[Logic_]

^^ I think MySQL only features that.

[Bolex_]

Decent work, might use it in future

[HoussemGaming]

Looks dope, BTW the easy dialog include link is not working, can you update it, Please ?, Repped

[cuber]

Quote:

Originally Posted by HoussemGaming Looks dope, BTW the easy dialog include link is not working, can you update it, Please ?, Repped

https://sampforum.blast.hk/showthread.php?tid=475838

Btw, dope work.

[Gammix]

Quote:

Originally Posted by Dayrion Ban_GetLongIP -> What is this for? Same question for BAN_MASK. Thanks for answering me

Thats CIDR Ip detection introduced by R@f, i just modified/optimized it. Basically its a way to detect IP range.

Quote:

Originally Posted by Eoussama Cool stuff, however, why did you chose to work with this include while needless to say you can manage to have an even greater result by having a TIMESTAMP/DATETIME( if that's supported by SQLite ) column in your table?

SQLite of SA-MP is horribly outdated.

Quote:

Originally Posted by HoussemGaming Looks dope, BTW the easy dialog include link is not working, can you update it, Please ?, Repped

Updated

[Pottus]

You should be saving the clientid there is so many different profiling queries you can make to figure out patterns that otherwise wouldn't be evident under normal circumstances. You should also save country codes as well and also every connection saving the ip / clientid / time / country code / nickname.

[Gammix]

Quote:

Originally Posted by Pottus You should be saving the clientid there is so many different profiling queries you can make to figure out patterns that otherwise wouldn't be evident under normal circumstances. You should also save country codes as well and also every connection saving the ip / clientid / time / country code / nickname.

I don't want to code too much on it. I think this much should be enough for my little server.
People feel free to update it!

[PT]

Quote:

Originally Posted by Pottus You should be saving the clientid there is so many different profiling queries you can make to figure out patterns that otherwise wouldn't be evident under normal circumstances. You should also save country codes as well and also every connection saving the ip / clientid / time / country code / nickname.

I like the idea..


Gammix you should think better about it.

[Gammix]

Quote:

Originally Posted by PT I like the idea.. Gammix you should think better about it.

As i said, feel free to update it. I ain't spending more time on this.

[HydraHumza]

Quote:

Originally Posted by Pottus You should be saving the clientid there is so many different profiling queries you can make to figure out patterns that otherwise wouldn't be evident under normal circumstances. You should also save country codes as well and also every connection saving the ip / clientid / time / country code / nickname.

Great Idea. I would try to do it.

[TheRealMan]

Gammix, New script again from your usefull scripts, Keep it up sir.

[feheristi97]

I just don't get why people use SQLite instead of MySQL...