[Release] FiveM-BanSql

ItzikNossette · October 14, 2019, 10:20pm

@AlexGarcio
I have a mistake on my side.

Matzbear · October 15, 2019, 5:41pm

I’m having the same error as @ItzikNossette

AlexGarcio · October 17, 2019, 11:52pm

@ItzikNossette & @Matzbear Fixed

ItzikNossette · October 18, 2019, 6:10am

@AlexGarcio
Same problem after update

Turnox · October 18, 2019, 9:57pm

hey, after looking for a fix @ItzikNossette , @Matzbear
you would send us this :

-- checking for the issue number to string 
	print (target)
	print (servertarget)

let us know the answer from your cmd !!

ItzikNossette · October 19, 2019, 2:38am

@Turnox

mastersammie · October 27, 2019, 4:16pm

i keep getting this error when i try to ban someone

SCRIPT ERROR: @fivem-bansql/server.lua:578: attempt to concatenate a nil value (global ‘xblid1’)
handler (@essentialmode/server/main.lua:190)
handler (@chat/sv_chat.lua:27)

AlexGarcio · October 27, 2019, 5:18pm

@mastersammie it’s fix.

mastersammie · October 27, 2019, 9:42pm

thx fixed it

AlexGarcio · January 25, 2020, 2:56pm

1.0.9 Steam no more require & Anti-Cheat Compatible

To update from older version you have to drop the 3 sql table

Add Event to be self ban for anti-cheat use
Add Anti-Cheat event call from server side can choose player to ban
Add Event demo for anti-cheat use
Edit Rework discord message
Edit Steam is no more require but stay compatible
Edit License is not used as primary info
Edit Improve french translation by @EagleOnee
Edit Improve english translation by @Zeemahh
Edit Code cleaning&optimisation
Fix Sql can’t be load
Fix Fix nil value (global ‘xblid1’) at line 578

Matzbear · February 5, 2020, 9:04am

Is it posible to make the commands usable from the server console? Would make it easy to ban someone from my phone when i get an discord anticheat warning.

QUWASH · February 5, 2020, 9:08pm

Guys when I trigger this event from my server :TriggerEvent(“BanSql:ICheat”, “Auto-Cheat Custom Reason”,TargetId) events I wil get this error:
SCRIPT ERROR: @FiveM-BanSql/server.lua:232: attempt to compare number with string

Does anyone know how to fix this?

AlexGarcio · February 5, 2020, 9:18pm

@QUWASH it’s fix in 1.0.9a

@Matzbear console command are add you can try it here

brad_lesh · March 2, 2020, 8:10am

This is working great for me and my server but I can’t figure out one thing.

When I try the command /sqlsearch to get someone’s permid and try to search someone’s name it keeps giving me “Banlist: The Specified Name Is Not Valid”

I’ve tried 3 things.

Running someone’s name who is online and has never been SQLBanned
Running someone’s name who is offline and has never been banned
Running someone’s name who is offline and was perm banned using /sqlban

and I keep getting that same error message.

Can the dev or any users of this script give me some insight on why this may not be working?

Brad

AlexGarcio · March 6, 2020, 1:14pm

sqlsearch are case sensible.
If you search alex but my name is Alex you don’t find me.
But if you search Ale or lex you find Alex

ziame · April 21, 2020, 8:50am

If i ban someone only i see this ban message how i can do at all players see that message ?

Bando29 · May 11, 2020, 6:37pm

Does anyone know how to make it appear in the text box? What i mean is the SQL function works but it says that it is not a valid command and it doest appear in the text box explaining what to do.

In the two photos you can see how sqlban doesnt have predictive text where as the emotes do for example. How would i change this? Any help will be appreciated

outsider310 · May 20, 2020, 6:01am

Does it work with esx?

Vlanex04 · May 29, 2020, 5:33pm

Hi, how can I ban a person permanently?, if I set for example 1000 days, It doesn’t work, beacuse the days are too many.

AlexGarcio · June 19, 2020, 6:07am

0 day = perm ban