Witajcie, dzia?am na gamemodzie FairPlay: Github .
W tabeli characters doda?em kolumn? points , ostatnio mecze si? w jaki spos?b doda? aby informacje z tej kolumny wy?wietla?y sie na tablicy pod klawiszem TAB.
Stworzy?em 4 proste serwerowe funkcje i wyeksportowa?em je.
[code2]function getPlayerPoints (thePlayer)
local name = getPlayerName(thePlayer)
local query = dbQuery(exports['roleplay-accounts']:getSQLConnection(), "SELECT `??` FROM `??` WHERE `??` = '??' LIMIT 1", "points", "characters", "characterName", name)
local result = dbPoll(query, -1)
if (query) then
local points = result
return tonumber(points[1]["points"])
else
outputDebugString("pointsystem_classes - getPlayerPoints (Database unknow problem! Can't get points!)")
end
end
function setPlayerPoints (thePlayer, pointsAmount)
local name = getPlayerName(thePlayer)
local query = dbExec(exports['roleplay-accounts']:getSQLConnection(), "UPDATE `??` SET `??` = '??' WHERE `??` = '??'", "characters", "points", pointsAmount, "characterName", name)
if (query) then
outputDebugString("Set Player point " .. name .. " to ".. pointsAmount )
end
end
function givePlayerPoints (thePlayer, pointsAmount)
local name = getPlayerName(thePlayer)
local query = dbQuery(exports['roleplay-accounts']:getSQLConnection(), "SELE... |