Exports

function getPlayerData(plr, dataName)

    local user = getElementData(plr, "accName")
    local query = exports.SCmysql:query("SELECT * FROM accountsData WHERE username=?", user)
    local data = fromJSON(query[1].data)
    if (data[dataName]) then
        return data[dataName]
    else
        return false
    end
end

function setPlayerData(plr, dataName, value)

    local user = getElementData(plr, "accName")
    local query = exports.SCmysql:query("SELECT * FROM accountsData WHERE username=?", user)
    local data = fromJSON(query[1].data)
    if (type(value) == "table") then
        data[dataName] = toJSON(value)
    else
        data[dataName] = value
    end
    exports.SCmysql:exec("UPDATE accountsData SET data=? WHERE username=?", toJSON(data), user)
end


function getPlayerAccountName(plr)

    local accName = getElementData(plr, "accName")
    return accName or false
end


function getAccountData(user, dataName)

    local query = exports.SCmysql:query("SELECT * FROM accountsData WHERE username=?", user)
    local data = fromJSON(query[1].data)
    if (data[dataName]) then
        return data[dataName]
    else
        return false
    end
end


function setAccountData(user, dataName, value)

    local query = exports.SCmysql:query("SELECT * FROM accountsData WHERE username=?", user)
    local data = fromJSON(query[1].data)
    if (type(value) == "table") then
        data[dataName] = toJSON(value)
    else
        data[dataName] = value
    end
    exports.SCmysql:exec("UPDATE accountsData SET data=? WHERE username=?", toJSON(data), user)
end