[Help] Need help with getting the data from this table

FiveM Resource Development Discussion
1

So idk how to get if they are a owner in the database someone please help

Execute thread

Blockquote MySQL.Async.execute(
‘INSERT INTO zoneowners (owner, label) VALUES (@owner, @label)’,
{
[‘@owner’] = xPlayer.identifier,
}, function(rowsChanged)
end
)

2

Well that’s not getting anything. its inserting into zoneowners…

3

yeah i need to know how to get the same data

4

Like how do i create a check if they are in there as owner is what i need to do i tried but could get it

5 
MySQL.Async.fetchAll("SELECT * FROM zoneowners WHERE owner = @owner", {['@owner'] = xPlayer.identifier}, function(results)
    print(tostring(json.encode(results)))
end)
6

ill give that a shot thanks :smiley:

7

I just updated the above code so you can actually see the data printed. Make sure to try the new one.

8

alright updating now

Then if i wanted it so only if they are owner would i make it results == (player id) then like that?

9

Well what does the label row hold on the database?

10

i have it as a null right now cause i cant figure out how to get the config.Zones.label to get put there

11

well if you are trying to find out what zone they are ownership of you have to do this

MySQL.Async.fetchAll("SELECT * FROM zoneowners WHERE owner = @owner", {['@owner'] = xPlayer.identifier, ['@label'] = labelnameorwhatever}, function(results)
    print(tostring(json.encode(results)))
end)
12

The first method returns ALL zones they are ownership of.

13

ok let me try that
20 characters

14

Oh lol i forgot i removed the labels in the database. guees i dont need that
:smiley:

So would this work

if results == xPlayer then
captured = true
end

15

this is what i put

RegisterServerEvent(‘Check’)
AddEventHandler(‘Check’, function ()
local xPlayer = ESX.GetPlayerFromId(source)

MySQL.Async.fetchAll("SELECT * FROM zoneowners WHERE owner = @owner", {['@owner'] = xPlayer.identifier}, function(results)
   if results == xPlayer then
    captured = true
   end
end)

end)

doesnt work tho

16

Do you have multiple zones. Because that will not work if you have multiple zones.

17

yeah i use esx drugs so like all those zones bui i cant figure out how to get the currentzones label

18

You need to figure that out before continuing :smiley: otherwise the code wont do what its supposed to.

19

well so i cant just remove that from the equation? like it just sets owner?

20

No because it doesn’t know what zone hes ownership of…