Sizin muhtemelen server kısmında veritabanı kaydı yapılamıyor. Server kısmında veritabanı kaydı kısmını bulup atarsanız belki yardımcı olabilirim.
ESX = nil
TriggerEvent('esx:getSharedObject', function(obj) ESX = obj end)
RegisterServerEvent("kashactersS:SetupCharacters")
AddEventHandler('kashactersS:SetupCharacters', function()
local src = source
local LastCharId = GetLastCharacter(src)
SetIdentifierToChar(GetPlayerIdentifiers(src)[1], LastCharId)
local Characters = GetPlayerCharacters(src)
TriggerClientEvent('kashactersC:SetupUI', src, Characters)
end)
RegisterServerEvent("kashactersS:CharacterChosen")
AddEventHandler('kashactersS:CharacterChosen', function(charid, ischar, spawnid)
local spid = spawnid
local src = source
local spawn = {}
SetLastCharacter(src, tonumber(charid))
SetCharToIdentifier(GetPlayerIdentifiers(src)[1], tonumber(charid))
if ischar == "true" then
if spid=="sonkonum" then
spawn = GetSpawnPos(src)
elseif spid=="otel" then
spawn = { x = 198.79, y = -934.32, z = 30.68 }
elseif spid=="havaalani" then
spawn = { x = 1556.18, y = 3609.20, z = 35.43 }
elseif spid=="karakol" then
spawn = { x = -687.73, y = 5768.60, z = 17.33 }
else
spawn = GetSpawnPos(src)
end
if spawn.x == nil then
spawn = { x = -1045.42, y = -2750.85, z = 22.31 }
end
TriggerClientEvent("kashactersC:SpawnCharacter", src, spawn)
else
spawn = { x = -1045.42, y = -2750.85, z = 22.31 }
TriggerClientEvent("kashactersC:SpawnCharacter", src, spawn,true)
end
end)
ESX.RegisterServerCallback('kashactersS:getPlayerSkin', function(source, cb, charidp)
MySQL.Async.fetchAll('SELECT skin FROM users WHERE identifier = @identifier', {
['@identifier'] = 'Char'..charidp..GetIdentifierWithoutSteam(GetPlayerIdentifiers(source)[1])
}, function(users)
if users[1] ~= nil then
local user, skin = users[1]
if user.skin then
skin = json.decode(user.skin)
end
cb(skin)
else
cb(nil)
end
end)
end)
RegisterServerEvent("kashactersS
eleteCharacter")
AddEventHandler('kashactersS
eleteCharacter', function(charid)
local src = source
DeleteCharacter(GetPlayerIdentifiers(src)[1], charid)
TriggerClientEvent("kashactersC:ReloadCharacters", src)
end)
function GetPlayerCharacters(source)
local identifier = GetIdentifierWithoutSteam(GetPlayerIdentifiers(source)[1])
local Chars = MySQLAsyncExecute("SELECT * FROM `users` WHERE identifier LIKE '%"..identifier.."%'")
return Chars
end
function GetLastCharacter(source)
local LastChar = MySQLAsyncExecute("SELECT `charid` FROM `user_lastcharacter` WHERE `steamid` = '"..GetPlayerIdentifiers(source)[1].."'")
if LastChar[1] ~= nil and LastChar[1].charid ~= nil then
return tonumber(LastChar[1].charid)
else
MySQLAsyncExecute("INSERT INTO `user_lastcharacter` (`steamid`, `charid`) VALUES('"..GetPlayerIdentifiers(source)[1].."', 1)")
return 1
end
end
function SetLastCharacter(source, charid)
MySQLAsyncExecute("UPDATE `user_lastcharacter` SET `charid` = '"..charid.."' WHERE `steamid` = '"..GetPlayerIdentifiers(source)[1].."'")
end
function SetIdentifierToChar(identifier, charid)
for _, itable in pairs(IdentifierTables) do
MySQLAsyncExecute("UPDATE `"..itable.table.."` SET `"..itable.column.."` = 'Char"..charid..GetIdentifierWithoutSteam(identifier).."' WHERE `"..itable.column.."` = '"..identifier.."'")
end
end
function SetCharToIdentifier(identifier, charid)
for _, itable in pairs(IdentifierTables) do
MySQLAsyncExecute("UPDATE `"..itable.table.."` SET `"..itable.column.."` = '"..identifier.."' WHERE `"..itable.column.."` = 'Char"..charid..GetIdentifierWithoutSteam(identifier).."'")
end
end
function DeleteCharacter(identifier, charid)
for _, itable in pairs(IdentifierTables) do
MySQLAsyncExecute("DELETE FROM `"..itable.table.."` WHERE `"..itable.column.."` = 'Char"..charid..GetIdentifierWithoutSteam(identifier).."'")
end
end
function GetSpawnPos(source)
local SpawnPos = MySQLAsyncExecute("SELECT `position` FROM `users` WHERE `identifier` = '"..GetPlayerIdentifiers(source)[1].."'")
if SpawnPos[1].position ~= nil then
return json.decode(SpawnPos[1].position)
else
local spawn = { x = -1045.42, y = -2750.85, z = 22.31 }
return spawn
end
end
function GetIdentifierWithoutSteam(Identifier)
return string.gsub(Identifier, "steam", "")
end
function MySQLAsyncExecute(query)
local IsBusy = true
local result = nil
MySQL.Async.fetchAll(query, {}, function(data)
result = data
IsBusy = false
end)
while IsBusy do
Citizen.Wait(0)
end
return result
end
