xLargo Posted December 6, 2019 Posted December 6, 2019 (edited) 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" Edited December 6, 2019 by xLargo
xLargo Posted December 6, 2019 Author Posted December 6, 2019 (edited) Solved, I've got function a hundred codes below with function with the same name "zaladujzaladunki" sorry Edited December 6, 2019 by xLargo
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now