• There is NO official Otland's Discord server and NO official Otland's server list. The Otland's Staff does not manage any Discord server or server list. Moderators or administrator of any Discord server or server lists have NO connection to the Otland's Staff. Do not get scammed!
  • 2026 staff recruitment is open! Check it out and consider applying!

TFS 1.1 how to call from database

Itutorial

Itutorial

Legendary OT User
Joined
Dec 23, 2014
Messages
2,461
Solutions
68
Reaction score
1,123
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?
 
Sort by date Sort by votes
Code: 
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
Code: 
databaseCall(cid, "level")

have fun hope you like :)
 
Last edited:
Upvote 0 Downvote
Back
Top