How to make a check on database

[president vankk]

Hi my friends,

I'm currently developing a script and I got stucked to how I can make a check on a table on database.. If table X on player account are seted to 1 then will return true.

Can someone explain me about to how make checks on database like I said above?

Thans.

 

[Ramirow]

Which table you are trying to check? It it's a table that didn't come with the original database I think you need to add a function to retrieve it's data.

 

[Codex NG]

Hi my friends,

I'm currently developing a script and I got stucked to how I can make a check on a table on database.. If table X on player account are seted to 1 then will return true.

Can someone explain me about to how make checks on database like I said above?

Thans.

Provide the script so someone can help you

 

[president vankk]

@Ninja already helped me by giving me the example below

local resultId = db.storeQuery('SELECT `premium_points` FROM `accounts` WHERE `id` = ' .. player:getAccountId())
if resultId then
    local points = result.getNumber(resultId, 'premium_points')
    print(points)
    result.free(resultId)
end

 

[Codex NG]

Oh now solutions are being provided via pm's

 

[StreamSide]

Oh now solutions are being provided via pm's

private information