Database "query" and "result"

[Nothxbye]

To set status = 1 in database from lua script it looks like:

db.query('UPDATE `players` SET `status` = 1 WHERE `id` = '..getPlayerGUIDByName(getCreatureName(cid))..'')

But how to check status whether it is 0 or 1 from database?
I've got something like this but it doesnt work:

local Info = result.getDataInt("SELECT `status` FROM `players` WHERE `id` = "..getPlayerGUIDByName("Name").." AND `status` = 1")
        if(Info:getID() ~= -1) then

        end

Using Otserv

 

[Summ]

local res = db.getResult("SELECT `status` FROM `players` WHERE `id` = "..getPlayerGUIDByName("Name").." AND `status` = 1")
if res:getID() ~= -1 then
    local status = res:getDataInt("status")


    res:free()
end

 

[Polat Alemdar]

lol

 

[Nothxbye]

local res = db.getResult("SELECT `status` FROM `players` WHERE `id` = "..getPlayerGUIDByName("Name").." AND `status` = 1")
if res:getID() ~= -1 then
    local status = res:getDataInt("status")


    res:free()
end

Works