function startskryptu()
db = dbConnect("mysql", "dbname=truck;host=127.0.0.1", "root","","share=1")
truckerzaladunki = { }
truckerrozladunki = { }
zz = dbQuery(zaladujzaladunki, db, "SELECT * FROM towary_zaladunki")
zr = dbQuery(zaladujrozladunki, db, "SELECT * FROM towary_rozladunki")
end
addEventHandler("onResourceStart", getResourceRootElement(), startskryptu)
function zaladujzaladunki(qh)
local results = dbPoll(qh, -1)
for i, zal in pairs(results) do
truckerzaladunki[i] = {}
truckerzaladunki[i]["x"] = zal.x
truckerzaladunki[i]["y"] = zal.y
truckerzaladunki[i]["z"] = zal.z
truckerzaladunki[i]["descr"] = zal.descr
end
outputConsole("zaladowano zaladunki")
dbFree(zz)
end
function zaladujrozladunki(qh)
local results = dbPoll(qh, -1)
for i, roz in pairs(results) do
truckerrozladunki[i] = {}
truckerrozladunki[i]["x"] = roz.x
truckerrozladunki[i]["y"] = roz.y
truckerrozladunki[i]["z"] = roz.z
truckerrozladunki[i]["descr"] = roz.descr
end
outputConsole("zaladowano rozladunki")
dbFree(zr)
end
Hello guys, I've got a problem with MYSQL - dbQuerry.
zr = dbQuery(zaladujrozladunki, db, "SELECT * FROM towary_rozladunki")
and function (zaladujrozladunki) works great, but the problem is with
zz = dbQuery(zaladujzaladunki, db, "SELECT * FROM towary_zaladunki")
which looks like doesn't even trigger function (zaladujzaladunki).
When I added outputChatBox("Test") before results, it doesn't show anything.
I have no idea what's goin' on.
I can only recive the errors "WARNING: satruck-towary / towary.Lua:58 database results uncollected after 5minutes. [QUERY] SELECT * FROM towary_zaladunki"