Jump to content

MySQL - dbQuerry bugged?


xLargo

Recommended Posts

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 by xLargo
Link to comment

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...