[Release] [FX] WhiteList DB (Async) 2.0

FiveM Resource Development & Modding Releases
1

Whitelist DB

I have created a small script for create WhiteList connected to your database, with this script you no longer need to restart your server for add someone in your WhiteList, when player try to connect, the script check if player is WhiteListed.

How-To

You can add someone in WhiteList with RCON Command or ChatCommand if you are in-game.
Example (In-Game) : /wladd steam:1100001049619D1.
Example (RCON) : wladd steam:1100001049619D1.

You can also remove someone from WhiteList with RCON Command or ChatCommand if you are in-game.
Example (In-Game) : /wlremove steam:1100001049619D1.
Example (RCON) : wlremove steam:1100001049619D1.

For use in-game commands you need to be in the “admin” group.

Requirements

  • Essentialmode 2.X or more.
  • MySQL Async

Installation

  • Download hav_whitelistdb-master.zip here
  • Import whitelistdb.sql in your database
  • Put /hav_whitelistdb-master/ in your /resources/ folder
  • Rename /hav_whitelistdb-master/ to /hav_whitelistdb/
  • Edit server.lua and configure the necessary information
  • Add “start hav_whitelistdb” in your server config file (server.cfg)
12 Likes
2

Thank’s dude :slight_smile: Awesome !

3 Likes
3

Hello, thanks for this release, I would like to try this but the download is private, I send you a request for access.

2 Likes
4

@Xantid Oops! Sorry, I unlocked it!

2 Likes
5

Do I just type in the players steam id? or what?

2 Likes
6

Use chat or rcon command to add someone in whitelist (SteamID like steam:1100001049619D1)

1 Like
7

That doesnt look like a normal steam id?

8

It’s SteamID (Hex) used in FiveM, you can get it here : http://vacbanned.com/

9

100 Downloads ! Thank’s all !

1 Like
10

can do this script for work with async?

11

how work for MYSQL ASYNC ???

12

You cant get this work with Async until FXServer.

13

Any one can help port this script to MySQL Async Library?
Thanks…

14

@mazix @Excelsiors_Gaming @ccking
Update 1.1 - Changelog :

  • Add compatibility with Async
15

We are having problems with “async”.

We get this errormessage when we start the server:
https://gyazo.com/3a52f9c369b75e46aec88d19c921576b

This is what line 9 looks like:
https://gyazo.com/8cd593cd38372e5446e8d25420a4a4e7

Could someone please help?

16

Just delete line 9 and add in __resource.lua :

server_script '@mysql-async/lib/MySQL.lua'

I need to update my scripts for FxServer but i don’t have the time actually

1 Like
17

Thanks!
This helped alot! We got 1 more problem tho…

We are using CouchDB and now it says that it will whitelist as planned but it dosent input it into the database…

We needed to convert the whitelist.sql to JSON.
As converted the doc was like this:

{
“user_whitelist”: []
}

18

I don’t use and i don’t know how work CouchDB sorry :confused:

19

What other database system would you recommend?

(Instead of CouchDB)

20

I use only Async :slight_smile: