[Release] nameOfPlayers v.1 / Get Name of players in database!


#1

nameOfPlayers

Description
This script is for you GTA V server on FiveM.
NEED ESSENTIALS’s SCRIPT TO WORK !

FIRST : You have to edit your database and set a new column in table USERS :

  • Name of the column : Nom
  • VARCHAR / 60 / NULL

THEN :

  • EDIT "server.lua’ to enter your personal informations to connect to your database !

THEN :

  • You can connect to your server and look in your database, it’s work ! You have in column ‘Nom’ your Steam Name.

Now restart your server. When a player enter in your server, his name is register
in your database. It’s more friendly when you have lot of players on your server
and when you want identify them more quickly !!

Contribute
if you are a developer and would like to contribute any help is welcome!

For the moment, I prefer share little script like this to help guys who didn’t know lua and want some help.
You’ll find all the informations of my script in the README.txt

Download
nameOfPlayers.rar (1.1 KB)


[Release] Get Player Name in your database ! (MySQL) Updated for Essential mode 5
#2

thxxx very useful :slight_smile:


#3

Thank you :slight_smile:
Nice job.


#4

Thank you dude. You’re my love <3

Great job ! :yum:

Ps :

Are you french baby ?


#5

Thanks for your report ! Yes I’m french :wink:


#6

Doesn’t work. I made a little modification, it’s better now :smiley:

On top of the server.lua

require "resources/essentialmode/lib/MySQL"
MySQL:open("localhost", "gta5_gamemode_essential", "root", "password")

#7

Oh yes I forget ! So sorry ! It’s because i have the script in an other file on my server ! I will update, thanks :wink:


#8

No problem ahah, baguette help another baguette ! :wink:


#9

You mean “users” database ? And to add a new column : Name / int / 60 / null ?


#10

getting this error


#11

Update: working now just had to get DB table right


#12

Yes, in table users add a new colum : Nom / VARCHAR / 60 / NULL


#13

Hi,

Works percfect thanks


#14

Nom varchar(50) DEFAULT NULL


#15

thanks for this, it’s perfect :slight_smile:


#16

For those of you who also need names in “bans” etc… just add the same column in the “bans” table or whatever the hell your table is.


#17

Is it me or this script doesnt work anymore ?


#18

It’s you, read the README and add column in your database, edit the informations to connect to your database. That’s it


#19

Well mate , I don’t know why then . As you can check here :

  • Database has the correct form :
    DBB

  • Server.lua has been modified so it connects to my ddb :
    server.lua

Thanks in advance for your help


#20

is their away to get this to work with couchdb?