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

FiveM Resource Development Discussion
21

oh ok let me work on this then :smiley:

1 Like
22

I couldnt freaking get it to work i gave up on that project thanks for the help :smiley:

1 Like
23

what do i have to put for this one i really hate this my sql stuff i cant figure it out

MySQL.Async.execute(
‘INSERT INTO owned_vehicles (owner, vehicle) VALUES (@owner, @vehicle)’,
{
[‘@owner’] = xPlayer.identifier,
[‘@vehicle’] = json.encode(vehicleProps)
}, function(rowsChanged)
TriggerClientEvent(‘esx:showNotification’, _source, _U(‘vehicle’)… _(‘belongs’))
end
)

thats the creation code what would i need to fetch it this is the error i am getting with this code

code:

MySQL.Async.fetchAll(‘SELECT * FROM owned_vehicles WHERE owner, vehicle VALUES @owner, @vehicle’,
{
[‘@owner’] = xPlayer.identifier,
[‘@vehicle’] = json.encode(vehicleProps)
}, function(results)

error:
Capture

24

You cant use commas and you dont have a space between whereowner

25

oops didnt notice that no space but i didnt know no commas so do i just remove the commas then?
https://pastebin.com/fwKgZj17

oh so that no space is just the format of the forum i do have one there

26 
MySQL.Async.fetchAll("SELECT * FROM owned_vehicles WHERE owner = @owner and vehicle = @vehicle", {['@owner']=value, ['@vehicle']=value}, function(response) end)
1 Like
27

Im on my phone so that isnt completed but you arent setting ut up right…

28

alright ill try and work with that thanks again :smiley: and should it say response or result cause im trying to get the data thats in there?

29

Its just a variable name.

30

oh ok:D
(20 characters)

31

ok sweet got it to work :smiley: minus it wont get the vehicle value but that might just be my code

32

I use MySQL alot.

but here is how I get all my player characters and how to get a single player character.

    -- Gets ALL player characters
    CharacterDB.GetPlayerCharacters = function(id)
        local results = MySQL.Sync.fetchAll("SELECT * FROM characters WHERE license = @license", {['@license'] = ServerHelpers.FindPlayerIdentifier("license", id)})
        return results
    end

    -- Gets Players Targeted Character
    CharacterDB.GetPlayerCharacter = function(id, name, dob)
        local results = MySQL.Sync.fetchAll("SELECT * FROM characters WHERE license = @license AND name = @name AND dob = @dob", {
            ['@license'] = ServerHelpers.FindPlayerIdentifier("license", id),
            ['@name'] = name,
            ['@dob'] = dob
        })
        if results[1] then
            return results[1]
        else
            return false
        end
    end
33

Sweet that will help alot in the futrue but i think what the problem is vehicleprops is encoded on entry so do i have to like decode it xD?

34

yeah because when you encode it its a stringified JSON array.

you have to do json.encode(string) to actually use the array values.

35

oh ok so how could i check if that == the current vehicle props? idk why but i dont understand that encode stuff

36

well you aren’t thinking this through at all. You are trying to match like 50+ values… what if the car changes then guess what you can’t find that car anymore.

37

well my overall goal is to delete a duplicate entry in the database so if the vehicle == vehicle thats what i was thinking. and how can it just change cause the ls customs i have updates it per change i think

38

ye but how are you gonna save it over another vehicle if you change the vehicle then try to save the vehicle you just changed??

39

well isnt it only the properties not the vehicle its self the rims etc

40

I mean are you only gonna allow one car of the same type per player?