[Release] FiveM-BanSql

@ItzDusty it’s done.
[1.0.4] is out
BanSqlWebHook

How do i add admins if i use esx

You can

in game
1-You can use es_admin interface.

In server console
setgroup USER_ID superadmin

in sql data base
Change group of the player in table users

I recommand you to use this too to prevent ip change.

Hey, i put all the required files in and it lets me load into the server but wont let me ban

@Elite1 Have you the confirm message on the server load ? like that

The BanList and history has been loaded successfully.

If any other have this error you can find the async need here

New Release 1.0.4a

  • Minor config update
  • Fix Translation

Hey, do you got discord Elite#0666

it says
Could not find dependency async for resource FiveM-BanSql.
e[93mCouldn’t start resource FiveM-BanSql.e[0m

Got discord if so Elite#0666

it says
Could not find dependency async for resource FiveM-BanSql.
e[93mCouldn’t start resource FiveM-BanSql.e[0m

It’s telling you what the problem is in the error itself. You need to install resource async:

Make sure to start it before bansql.

[1.0.5] is out
Improve Data get from player when ban online.
Add MigrateTo1.0.5.sql
Add permission in config
Fix text not in english if steam is close
Fix Xbl, Live,Discord info go in playerip data sql

1.0.6 Improved offline ban

Optimise on player connecting ban check
Improve return text for perm ban

Add baninfo table sql
Add player info in baninfo table on playerloaded

remove no more need code in config

Fix Migrate table DEFAULT NULL
Fix console error if ban online and player not have all info
Fix console error if user not exist in sql for offline ban

1.0.6 Have a bad bug can ban more of 1 player.
Fix in 1.0.6a
Download : Last Release

1.0.6b

add commands bansql
Fix es_admin2 compatibility

Download : Last Release

Can you help me? the table baninfo is not being created … does it help me to correct this? http://prntscr.com/nblfc4

Possible you will add support for a discord webhook for the activities performed with this good resource : ) ? i’d like to have a log on discord. Thanks in advance.

Look in config file

Lol thanks i think i was very tired, good work thanks for the resource.

@tomcyk try last dev build.
https://github.com/RedAlex/FiveM-BanSql/archive/master.zip