[HELP] How can i load data from MySQL to a player variable?

[alexxnder]

Hello how can i load data from MySQL to a player variable ? i searched on google and i didn't found anything to help me

[Tekken]

 

local data = dbPoll("your data to be returned using normal MySQL");

for i,v in ipairs(data) do

v["var_name_in_db"]

end

Please note that this is a simple example for better understanding please read dbPoll wiki page.

[alexxnder]

  

9 minutes ago, Tekken said:

 

local data = dbPoll("your data to be returned using normal MySQL");

for i,v in ipairs(data) do

v["var_name_in_db"]

end

Please note that this is a simple example for better understanding please read dbPoll wiki page.

Ok, but how can i assign the data from mysql to a player variable ?

[Tekken]

What do you mean by player variable ?

[alexxnder]

6 minutes ago, Tekken said:

What do you mean by player variable ?

like this:

local data = dbPoll("your data to be returned using normal MySQL");

for i,v in ipairs(data) do

    player_variable = v["var_name_in_db"]

end

or

for i,v in ipairs(data) do   

      skin = v["var_name_in_db"]

end

I don't know if you understand what i want to say, i don't have a good english.

Edited September 7, 2020 by alexxnder

[Tekken]

Well you should use a tabel to store player element like this 

playersTable = {}
 

and after to store it you do this 

playersTable[thePlayer] = v[1]
 

you got it?

[alexxnder]

Just now, Tekken said:

Well you should use a tabel to store player element like this 

playersTable = {}
 

and after to store it you do this 

playersTable[thePlayer] = v[1]
 

you got it?

Yes, i got it, thank you bro btw the peoples from this forum are really great and friendly and i'm glad to see that!  

[Tekken]

You’re welcome.  

You can also do

tablePlayers[player]["skin"] = skinid

 

for a better way of storing data than get/setElementData

[alexxnder]

6 minutes ago, Tekken said:

You’re welcome.  

You can also do

tablePlayers[player]["skin"] = skinid

 

for a better way of storing data than get/setElementData

Got it   (Mersi)  

In caz de o sa mai am nevoie de ajutor o sa te mai contactez daca nu te deranjeaza  chiar sunt surprins de cate chestii poti face pe acest client

Edited September 7, 2020 by alexxnder

[Tekken]