[Release] FiveM-BanSql

mysql
async
ban
sql

#21

@J.Manlet More ban info it’s done. you can look in source code.
I will make a new release after make preload SQL as an config option.


#22

Do this works fine?

Seems to be some problems with the script from what i can read


#23

Install it and see. You can find out in minutes rather than waiting for author to get back to you(if it happens at all).


#24

New release V1.0.3

Making commands more simple.
Add more ban info, SteamID/FiveMLicense/IP
Fix if you have more then 1 player banned player can reconnect.
Optimize ban and banperm fonction.


#25

Uploading…

Error running call reference function for resource essentialmode: citizen:/scripting/lua/scheduler.lua:351: server/main.lua:234: attempt to index a nil value (field '?')
stack traceback:
        servcfx> er/main.lua:234: in upvalue 'ref'
        citizen:/scripting/lua/scheduler.lua:337: in function <citizen:/scripting/lua/scheduler.lua:336>
        [C]: in function 'xpcall'
        citizen:/scripting/lua/scheduler.lua:336: in function <citizen:/scripting/lua/scheduler.lua:335>
stack traceback:
        [C]: in function 'error'
        citizen:/scripting/lua/scheduler.lua:351: in function <citizen:/scripting/lua/scheduler.lua:322>

Dude everytime I do a ban this is what I get nothing happens…
Command

banoffline 0 "Name Here"

Idk what it is man even with this updated version bro.


#26

@KrizFrost
What version of essentielmode you use?
Have you this error with /ban too?


#27

I just recently updated it, but how do I check the version ?


#28

When you start your server, ES does a version check. You can see what you’re running during the startup process in the terminal.


#29

It wasn’t updated to the correct version
odd but now when I banned someone and I go to login now after I banned them we have a problem…
I get banned and it states my IP is their IP. also grabs my License as well


#30

@KrizFrost
Fix here


#31

Can not ban offline for some odd reason


#32

@KrizFrost Have you update FiveM server build. I have listen the last version have a trouble with mysql async.


#33

Updating it causes mad issues with the server completely breaks ESX with the new branch of FiveM so I doubt thats going to be a fix


#34

anyone having issues with this not banning people? i added someone to db than they where able to join


#35

can we have a ban reload consol command


#36

New release for some fix

@Skrubzilla1 You edit your sql and want to reload the banlist?
For now you can just restart the ressource but i can look for that.


#37

Would it be possible to make this send the logs to a discord channel? one channel for unbans, one for bans? maybe by using esx_discord_bot? If that would be possible, this would be AWESOME! :smiley:


#38

So do i use those commands in-game or how?


#39

@Ruippinen Yes all command are in-game


#40

@Dustyduelist Yes i can do it, i finish to work on my new ressource and i will make this after.