[FilterScript] GBan System - SQLite
#1

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
Reply
#2

Leap Year support?
Reply
#3

Quote:
Originally Posted by Logic_
View Post
Leap Year support?
I am pretty sure this does have leap year support: https://sampforum.blast.hk/showthread.php?tid=347605
Reply
#4

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

Looks nice.
Reply
#6

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?
Reply
#7

^^ I think MySQL only features that.
Reply
#8

Decent work, might use it in future
Reply
#9

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

Quote:
Originally Posted by HoussemGaming
View Post
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.
Reply
#11

Quote:
Originally Posted by Dayrion
View Post
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
View Post
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
View Post
Looks dope, BTW the easy dialog include link is not working, can you update it, Please ?, Repped
Updated
Reply
#12

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.
Reply
#13

Quote:
Originally Posted by Pottus
View Post
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!
Reply
#14

Quote:
Originally Posted by Pottus
View Post
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.
Reply
#15

Quote:
Originally Posted by PT
View Post
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.
Reply
#16

Quote:
Originally Posted by Pottus
View Post
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.
Reply
#17

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

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


Forum Jump:


Users browsing this thread: 3 Guest(s)