[FilterScript] GBan System - SQLite - Printable Version
+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Filterscripts (https://sampforum.blast.hk/forumdisplay.php?fid=17)
+--- Thread: [FilterScript] GBan System - SQLite (/showthread.php?tid=637472)
+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Filterscripts (https://sampforum.blast.hk/forumdisplay.php?fid=17)
+--- Thread: [FilterScript] GBan System - SQLite (/showthread.php?tid=637472)
GBan System - SQLite - Gammix - 15.07.2017
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
Re: GBan System - SQLite - Logic_ - 15.07.2017
Leap Year support?
Re: GBan System - SQLite - Gammix - 15.07.2017
Quote:
|
Originally Posted by Logic_
 Leap Year support?
|
Re: GBan System - SQLite - Dayrion - 15.07.2017
Ban_GetLongIP -> What is this for? Same question for BAN_MASK.
Thanks for answering me
Re: GBan System - SQLite - coool - 15.07.2017
Looks nice.
Re: GBan System - SQLite - Eoussama - 15.07.2017
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?
Re: GBan System - SQLite - Logic_ - 15.07.2017
^^ I think MySQL only features that.
Re: GBan System - SQLite - Bolex_ - 15.07.2017
Decent work, might use it in future
Re: GBan System - SQLite - HoussemGaming - 15.07.2017
Looks dope, BTW the easy dialog include link is not working, can you update it, Please ?, Repped
Re: GBan System - SQLite - cuber - 15.07.2017
Quote:
|
Originally Posted by HoussemGaming
Looks dope, BTW the easy dialog include link is not working, can you update it, Please ?, Repped
|
Btw, dope work.
Re: GBan System - SQLite - Gammix - 15.07.2017
Quote:
|
Originally Posted by Dayrion
Ban_GetLongIP -> What is this for? Same question for BAN_MASK.
Thanks for answering me |
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? |
Quote:
|
Originally Posted by HoussemGaming
Looks dope, BTW the easy dialog include link is not working, can you update it, Please ?, Repped
|
Re: GBan System - SQLite - Pottus - 15.07.2017
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.
Re: GBan System - SQLite - Gammix - 15.07.2017
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.
|
People feel free to update it!
Re: GBan System - SQLite - PT - 16.07.2017
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.
|
Gammix you should think better about it.
Re: GBan System - SQLite - Gammix - 16.07.2017
Quote:
|
Originally Posted by PT
I like the idea..
Gammix you should think better about it. |
Re: GBan System - SQLite - HydraHumza - 16.07.2017
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.
|
Re: GBan System - SQLite - TheRealMan - 18.07.2017
Gammix, New script again from your usefull scripts, Keep it up sir.
Re: GBan System - SQLite - feheristi97 - 20.07.2017
I just don't get why people use SQLite instead of MySQL...