xLargo Posted December 6, 2019 Share 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 Link to comment
xLargo Posted December 6, 2019 Author Share 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 Link to comment
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