[Lua + SQL] Return value from player (solved)

[StormRusher]

Well i need a function to return the value of one column of SQLite, for example "test"

I wanna make a script to check if player has the value 1 or 0, then do action

Thanks

 

[Cykotitan]

function getTest(cid)
	if isPlayer(cid) then
		local query = db.getResult("SELECT `test` FROM `players` WHERE `id` = " .. getPlayerGUID(cid) .. ";")
		if(query:getID() ~= -1) then
			local ret = query:getDataInt("test")
			query:free()
			return ret
		end
	end
	return false
end

 

[StormRusher]

perfect man, holy shit i cant rep+ you ;<

thanks a lot