TFS 1.1 how to call from database

[Itutorial]

How do you call from the database?

local function databaseCall(cid, value)
value = ("SELECT `value` FROM `players` WHERE `id` = "..getAccountById(cid).." LIMIT 1)
ret = getDataInt('value')
return ret



something like this?

 

[Sir Islam]

function databaseCall(cid, value)
       local resultr, ret = db.storeQuery("SELECT `"..value.."` FROM `players` WHERE `id` = "..getPlayerGUID(cid)..";")
        ret = result.getDataInt(resultr,value)
        result.free(resultr)
        return ret
end

how to use

databaseCall(cid, "level")

have fun hope you like

 

[Itutorial]

Did you test it?