I really dont get it.. sql insert.. can you spot what i did wrong?

docburn · 2019-08-10T18:31:33.571Z

I want to learn how to read and write in my db… I can usually fix my own problem but there is no message, no error in console or anywhere… and nothing happen in the db, off course

I would like to find my sanity back… if you can help me spot the mistake. Thank you very much!

the table is called “users_cars”

In visual studio code

image1708×978 99 KB

In raw lua

--<===============================================================================================================================>
	ESX = nil
	TriggerEvent('esx:getSharedObject', function(obj) ESX = obj end)
--<===============================================================================================================================>
	RegisterCommand("writedb", function(source args)
		TriggerEvent('esx_burn:writedb')
	end)
--<===============================================================================================================================>
	RegisterServerEvent('esx_burn:writedb')
	AddEventHandler('esx_burn:writedb', function(source) -- , Xplate, Xnitro, Xfuel)
		------------------------------------------------------------------>
		local _source = source
				
		local xId = GetPlayerIdentifiers(_source)[1]
		local xPlayer = ESX.GetPlayerFromId(_source)
		local xPlate = "666 EVIL"
		local xNitro = 69
		local xFuel = 96

		MySQL.Async.execute("INSERT INTO users_cars (id, owner, plate, nitro, fuel) VALUES (@id @owner, @plate, @nitro, @fuel)",   
		{
			['@id'] = xId,
			['@owner'] = xPlayer.identifier,
			["@plate"] = xPlate,
			["@nitro"] = xNitro,
			["@fuel"] = xFuel
		}, function (result)
			TriggerClientEvent("output", _source, "^2 FAILED EVERYTIME ^0") -- debug
		end)
		------------------------------------------------------------------>
	end)
--<===============================================================================================================================>

Twittchter · 2019-08-10T18:37:36.832Z

	```MySQL.Async.execute("INSERT INTO users_cars (id, owner, plate, nitro, fuel) VALUES (@id @owner, @plate, @nitro, @fuel)",   
	{
		['@id'] = xId,```

You have missed a coma where VALUES is, but I also want to ask, why are you using the ID as something you are writing to the DB?

Do you want it to have the same ID every time for that player?

Note, I haven’t checked the screenshots.

docburn · 2019-08-10T18:40:03.054Z

as of right now the value that i try to input are dummy data… i did not pay much attention to what i was trying to write but … why the hell it would not work

I also see…

}, function (result)

there is no space between function and “(result)” … and the coma you spoted

docburn · 2019-08-10T18:41:29.017Z

i though the id would auto add itself by the database… but that mean i should only try to input 4 values ?

VALUES (@id @owner, @plate, @nitro, @fuel)
to
VALUES (@owner, @plate, @nitro, @fuel) and the id will auto increment ?

EDIT: i can add that the id value is not important in my eyes… i want to save my nitro and fuel level inside the db… idealy in the owned_vehicles when im done experimenting

image736×51 6.19 KB

Twittchter · 2019-08-10T18:45:08.789Z

Yes, but also the owner column needs to have the identifier information. Not the ID column.

Basically, the owner information is just the server ID at the moment, not the SteamID.

docburn · 2019-08-10T18:46:18.592Z

i was trying to use it like this
[’@owner’] = xPlayer.identifier,
i’ll go dance around all that… see if something showup in the db

RegisterCommand can be run serverside ? i am triggering this debug codes with it

Twittchter · 2019-08-10T18:48:06.253Z

Read your locals.

It’s four am for me, and you’re way to quick to reply.

I’ll leave you with that my dude.

docburn · 2019-08-10T18:48:38.155Z

10-4 thank you very much… i appreciate the second opinion.

docburn · 2019-08-10T18:56:27.176Z

I am here now… and still nothing in the db… grr… if someone else can shed some light on my darkness

--<===============================================================================================================================>
	ESX = nil
	TriggerEvent('esx:getSharedObject', function(obj) ESX = obj end)
--<===============================================================================================================================>
	RegisterServerEvent('esx_burn:writedb')
	AddEventHandler('esx_burn:writedb', function(source) -- , Xplate, Xnitro, Xfuel)
		------------------------------------------------------------------>
		local _source = source
				
		local xOwner = GetPlayerIdentifiers(_source)[1]
		local xPlate = "666 EVIL"
		local xNitro = 69
		local xFuel = 96

		MySQL.Async.execute("INSERT INTO users_cars (owner, plate, nitro, fuel) VALUES (@owner, @plate, @nitro, @fuel)",   
		{
			['@owner'] = xOwner,
			["@plate"] = xPlate,
			["@nitro"] = xNitro,
			["@fuel"] = xFuel
		}, function(result)
			TriggerClientEvent("esx_burn:output", _source, "^2 TRYING TO OUTPUT ^0")
		end)
		------------------------------------------------------------------>
	end)
--<===============================================================================================================================>

Twittchter · 2019-08-10T18:58:43.808Z

) " is outside the bracket.

docburn · 2019-08-10T19:04:46.953Z

dude, you brought me to the water and i still cant drink… now im looking at “)” everywhere and feel dumb and blind… i code a lot, and never tried any sql before… its lightly new to me

I think i need more sleep than you … i’ll find it!

Twittchter · 2019-08-10T19:10:04.981Z

At the end of the mysql execute string my dude. Try it within the bracket to enclose the sql statement. Xo

Twittchter · 2019-08-10T19:11:52.277Z

What do you get when you have two tired asf coders trying to solve a problem.

No hair, no sleep and even more problems.

docburn · 2019-08-10T19:12:55.358Z

lol

/SelfFacePalm

i’ll go try what you said… that would MAKE A LOOOOOOT OF SENSE… haha… jeez

docburn · 2019-08-10T20:01:12.048Z

Working… finally thank you dude!