LUA using function variable outside of it

Question

I am trying to edit a script in LUA but I couldn't get access of a local defined in a function

LUA Code

function getSafeMoney()
    local SafeMoney = nil
    
    QBCore.Functions.ExecuteSql(false, 'SELECT * FROM `moneysafes` WHERE `safe` = "mechanic"', function(result)
        SafeMoney = json.decode(json.encode(result[1])).money;
    end)
    return SafeMoney
end

print(getSafeMoney())

Result : nil

here's the sql function as sysdevs asked

QBCore.Functions.ExecuteSql = function(wait, query, cb)
    local rtndata = {}
    local waiting = true
    exports['ghmattimysql']:execute(query, {}, function(data)
        if cb ~= nil and wait == false then
            cb(data)
        end
        rtndata = data
        waiting = false
    end)
    if wait then
        while waiting do
            Citizen.Wait(5)
        end
        if cb ~= nil and wait == true then
            cb(rtndata)
        end
    end
    return rtndata
end

could you provide QBCore.Functions.ExecuteSql ?

sysdevs
– sysdevs

2020-12-23 00:09:27 +00:00
Commented Dec 23, 2020 at 0:09 — sysdevs
– sysdevs, Commented Dec 23, 2020 at 0:09
@sysdevs updated

TiT0
– TiT0

2020-12-23 00:11:24 +00:00
Commented Dec 23, 2020 at 0:11 — TiT0
– TiT0, Commented Dec 23, 2020 at 0:11

sysdevs · Accepted Answer · 2020-12-23 00:13:32Z

1

Your second function is not holding the main function I assume, I am bad at lua aswell, but I think that changing

QBCore.Functions.ExecuteSql(false, ............

to

QBCore.Functions.ExecuteSql(true, ............

This will probably fix your problem, still your code is ambiguous and needs concentration if you could provide more information I might be able to help more

answered Dec 23, 2020 at 0:13

sysdevs

3631 silver badge9 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

TiT0 Over a year ago

it is a game script code, taking some time to execute, will provide you with news. Thanks for your help

Collectives™ on Stack Overflow

LUA using function variable outside of it

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related