bad argument dbquery

[Mec.Love]

opa, boa noite. então, estou com um backup de um servidor todo em mysql. configurei a conexão do mysql, startei e foi tudo ok. liguei o servidor no local porém dá um erro.
Warning: un_auth\server.lua:105 "Bad argument @ 'dbQuery' [Expected db-connection at argument 3, got boolean]

 

function playerRegister(username,password,confirmPassword, email)
	local mtaSerial = getPlayerSerial(client)
	local encryptionRule = tostring(math.random(0,9))..tostring(math.random(0,9))..tostring(math.random(0,9))..tostring(math.random(0,9))..tostring(math.random(0,9))..tostring(math.random(0,9))..tostring(math.random(0,9))..tostring(math.random(0,9))..tostring(math.random(0,9))..tostring(math.random(0,9))
	local encryptedPW = string.lower(md5(password))
	local ipAddress = getPlayerIP(client)
	
	dbQuery(playerRegisterCallback, {client, username, password, mtaSerial, ipAddress, encryptedPW, encryptionRule, email}, mysql:getConnection(), "SELECT username,mtaserial FROM accounts WHERE (username = ? or mtaserial = ?)", username, mtaSerial) --linha 105
end
addEvent("accounts:register:attempt",true)
addEventHandler("accounts:register:attempt",getRootElement(),playerRegister)

function playerRegisterCallback(queryHandler, client, username, password, serial, ip, encryptedPW, encryptionRule, email)
	local result, rows, err = dbPoll(queryHandler, 0)
	if rows > 0 then
		exports.un_notification:create(client,"Kullanıcı adı/email kullanılıyor veya yeni bir hesap oluşturmaya çalışıyorsun! ("..result[1]["username"]..")", "error")
	else
		dbExec(mysql:getConnection(), "INSERT INTO `accounts` SET `username`='"..username.."', `password`='"..encryptedPW.."', `email`='"..email.."', `registerdate`=NOW(), `ip`='"..ip.."', `salt`='"..encryptionRule.."', `mtaserial`='"..serial.."', `activated`='1' ")
		exports.un_notification:create(client,"Hesabınız başarıyla oluşturuldu, giriş yapabilirsiniz.", "success")
	end
end

Comentei na frente daLinha que está o erro > 105 <
ajuda eu

esse seria todo o codigo do serv side
 

local mysql = exports.un_mysql
local getElementData = getElementData
local setElementData = setElementData
local exports = exports

function setElementDataEx(theElement, theParameter, theValue, syncToClient, noSyncAtall)
	setElementData(theElement, theParameter, theValue)
	return true
end

function resourceStart(resource)
	setWaveHeight ( 0 )
	setGameType("Roleplay")
	setMapName("Istanbul")
	setRuleValue("Sürüm", "rc0.9")
	setRuleValue("Geliştiriciler", "UNT Development Team")
	for key, value in ipairs(exports.un_pool:getPoolElementsByType("player")) do
		triggerEvent("playerJoinResourceStart", value, resource)
	end
end
addEventHandler("onResourceStart", getResourceRootElement(getThisResource()), resourceStart)

function onJoin()
	local skipreset = false
	local loggedIn = getElementData(source, "loggedin")
	if loggedIn == 1 then
		skipreset = true
		setElementData(source, "account:seamless:validated", true, false, true)
	end
	if not skipreset then 
		setElementData(source, "loggedin", 0, false)
		setElementData(source, "account:loggedin", false, false)
		setElementData(source, "account:username", "", false)
		setElementData(source, "account:id", "", false)
		setElementData(source, "dbid", false)
		setElementData(source, "admin_level", 0, false)
		setElementData(source, "hiddenadmin", 0, false)
		setElementData(source, "globalooc", 1, false)
		setElementData(source, "muted", 0, false)
		setElementData(source, "loginattempts", 0, false)
		setElementData(source, "timeinserver", 0, false)
		setElementData(source, "chatbubbles", 0, false)
		setElementDimension(source, 9999)
		setElementInterior(source, 0)
	end
	exports.un_global:updateNametagColor(source)
end
addEventHandler("onPlayerJoin", getRootElement(), onJoin)
addEvent("playerJoinResourceStart", false)
addEventHandler("playerJoinResourceStart", getRootElement(), onJoin)

function resetNick(oldNick, newNick)
	setElementData(client, "legitnamechange", 1)
	setPlayerName(client, oldNick)
	setElementData(client, "legitnamechange", 0)
	exports.un_global:sendMessageToAdmins("Admin Warn: " .. tostring(oldNick) .. " kendi adını değiştirmek için çalıştı " .. tostring(newNick) .. ".")
end
addEvent("resetName", true )
addEventHandler("resetName", getRootElement(), resetNick)

function clientReady()
	local thePlayer = source
	local resources = getResources()
	local missingResources = false
	for key, value in ipairs(resources) do
		local resourceName = getResourceName(value)
		if resourceName == "un_global" or resourceName == "un_mysql" or resourceNmae == "un_pool" then
			if getResourceState(value) == "loaded" or getResourceState(value) == "stopping" or getResourceState(value) == "failed to load" then
				missingResources = true
				outputChatBox("Sunucu bağımlı kaynak eksik '"..getResourceName(value).."'.", thePlayer, 255, 0, 0)
				outputChatBox("Kısa bir süre sonra tekrar deneyiniz", thePlayer, 255, 0, 0)
				break
			end
		end
	end
	if missingResources then return end
	if not willPlayerBeBanned then
		triggerClientEvent(thePlayer, "beginLogin", thePlayer)
	else
		triggerClientEvent(thePlayer, "beginLogin", thePlayer, "Banned.")
	end
end
addEvent("onJoin", true)
addEventHandler("onJoin", getRootElement(), clientReady)

addEventHandler("accounts:login:request", getRootElement(), 
	function ()
		local seamless = getElementData(client, "account:seamless:validated")
		if seamless == true then
			setElementData(client, "account:seamless:validated", false, false, true)
			triggerClientEvent(client, "accounts:options", client)
			triggerClientEvent(client, "item:updateclient", client)
			return
		end
		triggerClientEvent(client, "accounts:login:request", client)
	end
);

function playerRegister(username,password,confirmPassword, email)
	local mtaSerial = getPlayerSerial(client)
	local encryptionRule = tostring(math.random(0,9))..tostring(math.random(0,9))..tostring(math.random(0,9))..tostring(math.random(0,9))..tostring(math.random(0,9))..tostring(math.random(0,9))..tostring(math.random(0,9))..tostring(math.random(0,9))..tostring(math.random(0,9))..tostring(math.random(0,9))
	local encryptedPW = string.lower(md5(password))
	local ipAddress = getPlayerIP(client)
	
	dbQuery(playerRegisterCallback, {client, username, password, mtaSerial, ipAddress, encryptedPW, encryptionRule, email}, mysql:getConnection(), "SELECT username,mtaserial FROM accounts WHERE (username = ? or mtaserial = ?)", username, mtaSerial)
end
addEvent("accounts:register:attempt",true)
addEventHandler("accounts:register:attempt",getRootElement(),playerRegister)

function playerRegisterCallback(queryHandler, client, username, password, serial, ip, encryptedPW, encryptionRule, email)
	local result, rows, err = dbPoll(queryHandler, 0)
	if rows > 0 then
		exports.un_notification:create(client,"Kullanıcı adı/email kullanılıyor veya yeni bir hesap oluşturmaya çalışıyorsun! ("..result[1]["username"]..")", "error")
	else
		dbExec(mysql:getConnection(), "INSERT INTO `accounts` SET `username`='"..username.."', `password`='"..encryptedPW.."', `email`='"..email.."', `registerdate`=NOW(), `ip`='"..ip.."', `salt`='"..encryptionRule.."', `mtaserial`='"..serial.."', `activated`='1' ")
		exports.un_notification:create(client,"Hesabınız başarıyla oluşturuldu, giriş yapabilirsiniz.", "success")
	end
end

local accountCharacters = {}
local onlineForPlayer = {}

function validateCredentials(username,password,checksave)
	if not (username == "") then
		if not (password == "") then	
			return true
		else
			exports.un_notification:create(client,"Lütfen şifrenizi girin.", "error")
		end
	else
		exports.un_notification:create(client,"Lütfen kullanıcı adınızı girin.", "error")
	end
	return false
end
addEvent("onRequestLogin",true)
addEventHandler("onRequestLogin",getRootElement(),validateCredentials)

function playerLogin(username,password,checksave)
	if not validateCredentials(username,password,checksave) then
		return false
	end
	dbQuery(loginCallback, {client,username,password}, mysql:getConnection(), "SELECT * FROM `accounts` WHERE `username`='".. username .."'")
end
addEvent("accounts:login:attempt",true)
addEventHandler("accounts:login:attempt",getRootElement(),playerLogin)

function loginCallback(queryHandler,source,username,password)
	local result, rows, err = dbPoll(queryHandler, 0)
	if rows > 0 then
		row = result[1]

		local encryptionRule = row["salt"]
		local encryptedPW = string.lower(md5(password))
		if row["password"] ~= encryptedPW then
			exports.un_notification:create(source,"Kullanıcı adı için şifreler eşleşmiyor!", "error")
			return
		end

		if (onlineForPlayer[row["id"]]) then
			thePlayer = onlineForPlayer[tonumber(row["id"])]
			if (thePlayer ~= source) then
				kickPlayer(thePlayer, thePlayer, "Bir kullanıcı hesabınıza giriş yaptı!")
			end
		end
		onlineForPlayer[tonumber(row["id"])] = source
		dbExec(mysql:getConnection(), "UPDATE accounts SET online='1' WHERE id = ?", tonumber(row["id"]))
		
		
		triggerClientEvent(source, "items:inventory:hideinv", source)
		
		setElementData(source, "account:loggedin", true, true)
		setElementData(source, "account:id", tonumber(row["id"]), true)
		local acID = tonumber(row['id'])
		setElementData(source, "account:username", row["username"], true)
		setElementData(source, "account:charLimit", tonumber(row["characterlimit"]), true)
		setElementData(source, "electionsvoted", row["electionsvoted"], true)
		setElementData(source, "account:email", row["email"])
		setElementData(source, "account:creationdate", row["registerdate"])
		setElementData(source, "account:email", row["email"])
		setElementData(source, "credits", tonumber(row["credits"]))
		setElementData(source, "admin_level", tonumber(row['admin']), true)
		setElementData(source, "supporter_level", tonumber(row['supporter']), true)
		setElementData(source, "vct_level", tonumber(row['vct']), true)
		setElementData(source, "mapper_level", tonumber(row['mapper']), true)
		setElementData(source, "scripter_level", tonumber(row['scripter']), true)
		setElementData(source, "bakiye", tonumber(row["bakiye"]) or 0, true)
		setElementData(source, "uyk", tonumber(row["uyk"]) or 0, true)
		local tablolar = row["custom_animations"]
        if type(fromJSON(tablolar)) ~= "table" then tablolar = toJSON ( { } ) end
        local animler = fromJSON(tablolar or toJSON ( { } ))
        table.insert(animler, block)
        setElementData(source, "custom_animations", animler)
		exports['un_reports']:reportLazyFix(source)
		setElementData(source, "adminreports", tonumber(row["adminreports"]), true)
		setElementData(source, "adminreports_saved", tonumber(row["adminreports_saved"]))
		if tonumber(row['referrer']) and tonumber(row['referrer']) > 0 then
			setElementData(source, "referrer", tonumber(row['referrer']), false, true)
		end
		
		if exports.un_integration:isPlayerLeadAdmin(source) then
			setElementData(source, "hiddenadmin", row["hiddenadmin"], true)
		else
			setElementData(source, "hiddenadmin", 0, true)
		end

		local vehicleConsultationTeam = exports.un_integration:isPlayerVehicleConsultant(source)
		setElementData(source, "vehicleConsultationTeam", vehicleConsultationTeam, false)

		if tonumber(row["adminjail"]) == 1 then
			setElementData(source, "adminjailed", true, true)
		else
			setElementData(source, "adminjailed", false, true)
		end
		setElementData(source, "jailtime", tonumber(row["adminjail_time"]), true)
		setElementData(source, "jailadmin", row["adminjail_by"], true)
		setElementData(source, "jailreason", row["adminjail_reason"], true)

		if row["monitored"] ~= "" then
			setElementData(source, "admin:monitor", row["monitored"], true)
		end

		dbExec(mysql:getConnection(), "UPDATE `accounts` SET `ip`='" .. getPlayerIP(source) .. "', `mtaserial`='" .. getPlayerSerial(source) .. "' WHERE `id`='".. tostring(row["id"]) .."'")
		setElementData(source, "jailreason", row["adminjail_reason"], true)

		setElementData(source, "forum_name", row["forum_name"])

		-- Militan
		for i=1, 6 do
			setElementData(source, "job_level:"..i, row["jlevel_"..i])
		end

		loadAccountSettings(source, row["id"])

	
		triggerClientEvent (source,"hideLoginWindow",source)
		triggerClientEvent(source, "vehicle_rims", source)
		local characters = {}
		dbQuery(
			function(qh, source)
				local res, rows, err = dbPoll(qh, 0)
				if rows > 0 then
					for index, value in ipairs(res) do
						if value.cked == 0 then
							local i = #characters + 1
							if not characters[i] then
								characters[i] = {}
							end
							characters[i][1] = value.id
							characters[i][2] = value.charactername
							characters[i][3] = tonumber(value.cked)
							characters[i][4] = ""
							characters[i][5] = value.age
							characters[i][6] = value.gender
							characters[i][9] = value.skin
							characters[i][11] = value.height
							characters[i][12] = value.weight
						end
					end
				end
				setElementData(source, "account:characters", characters)
				triggerClientEvent(source, "accounts:login:attempt", source, 0 )
				triggerEvent( "social:un_account", source, tonumber( row["id"] ) )
			end,
		{source}, mysql:getConnection(), "SELECT * FROM characters WHERE account = ?", tonumber(row["id"]))
	else
		triggerClientEvent(source,"set_warning_text",source,"Login","Kullanıcı adı veritabanında bulunamadı! ('".. username .."')")
	end
end

addEventHandler("onPlayerQuit", root,
	function()
		onlineForPlayer[getElementData(source, "account:id")] = false
		dbExec(mysql:getConnection(), "UPDATE accounts SET online='0' WHERE id = ?", tonumber(getElementData(source, "account:id")))
	end
)

function myCallback( responseData, errno, id )
    if errno == 0 then
        exports.un_cache:addImage(id, responseData)
	end
end

addEventHandler("onResourceStart", resourceRoot,
	function()
		imported_accounts = {}
		imported_characters = {}
		dbQuery(
			function(qh)
				local res, rows, err = dbPoll(qh, 0)
				if rows > 0 then
					for index, value in ipairs(res) do
						row_info = {}
						for count, data in pairs(value) do
							row_info[count] = data
						end
						imported_accounts[#imported_accounts + 1] = row_info
					end
				end
			end,
		mysql:getConnection(), "SELECT * FROM `accounts`")
		dbQuery(
			function(qh)
				local res, rows, err = dbPoll(qh, 0)
				if rows > 0 then
					for index, value in ipairs(res) do
						row_info = {}
						for count, data in pairs(value) do
							row_info[count] = data
						end
						imported_characters[#imported_characters + 1] = row_info
					end
				end
			end,
		mysql:getConnection(), "SELECT * FROM `characters`")
	end
)

function updateTables()
	imported_accounts, imported_characters = {}, {}
	dbQuery(
		function(qh)
			local res, rows, err = dbPoll(qh, 0)
			if rows > 0 then
				for index, value in ipairs(res) do
					row_info = {}
					for count, data in pairs(value) do
						row_info[count] = data
					end
					imported_accounts[#imported_accounts + 1] = row_info
				end
			end
		end,
	mysql:getConnection(), "SELECT * FROM `accounts`")
	dbQuery(
		function(qh)
			local res, rows, err = dbPoll(qh, 0)
			if rows > 0 then
				for index, value in ipairs(res) do
					row_info = {}
					for count, data in pairs(value) do
						row_info[count] = data
					end
					imported_characters[#imported_characters + 1] = row_info
				end
			end
		end,
	mysql:getConnection(), "SELECT * FROM `characters`")
end

function getTableInformations()
	return imported_accounts, imported_characters
end

function characterList(theClient)
	if theClient then 
	local dbid = getElementData(theClient, "account:id")
	local accounts, character = getTableInformations() -- // Hypnos

	local characters = {}
	for index, value in ipairs(character) do
		if value.account == dbid and value.cked == 0 then
			local i = #characters + 1
			if not characters[i] then
				characters[i] = {}
			end
			characters[i][1] = value.id
			characters[i][2] = value.charactername
			characters[i][3] = tonumber(value.cked)
			characters[i][4] = ""
			characters[i][5] = value.age
			characters[i][6] = value.gender
			characters[i][9] = value.skin
			characters[i][11] = value.height
			characters[i][12] = value.weight
		end
	end
	return characters
	end
end


function reloadCharacters()
if source then 
	local chars = characterList(source)
	setElementData(source, "account:characters", chars)
end
end
addEvent("updateCharacters", true)
addEventHandler("updateCharacters", getRootElement(), reloadCharacters)

function reconnectMe()
    redirectPlayer(client, "", 0 )
end
addEvent("accounts:reconnectMe", true)
addEventHandler("accounts:reconnectMe", getRootElement(), reconnectMe)
 

function adminLoginToPlayerCharacter(thePlayer, commandName, ...)
    if exports.un_integration:isPlayerSeniorAdmin(thePlayer) then
        if not (...) then
            outputChatBox("KULLANIM: /" .. commandName .. " [Tam karakter adı]", thePlayer, 255, 194, 14, false)
            outputChatBox("Oyuncunun karakterine ait loglar görüntüleniyor.", thePlayer, 255, 194, 0, false)
        else
            targetChar = table.concat({...}, "_")
            dbQuery(loginCharacterAdminCallback, {thePlayer, targetChar}, mysql:getConnection(), "SELECT `characters`.`id` AS `targetCharID` , `characters`.`account` AS `targetUserID` , `accounts`.`admin` AS `targetAdminLevel`, `accounts`.`username` AS `targetUsername` FROM `characters` LEFT JOIN `accounts` ON `characters`.`account`=`accounts`.`id` WHERE `charactername`='"..targetChar.."' LIMIT 1")
        end
    end
end
addCommandHandler("loginto", adminLoginToPlayerCharacter, false, false)
 
function loginCharacterAdminCallback(qh, thePlayer, name)
	local res, rows, err = dbPoll(qh, 0)
	if rows > 0 then
		local fetchData = res[1]
		local targetCharID = tonumber(fetchData["targetCharID"]) or false
        local targetUserID = tonumber(fetchData["targetUserID"]) or false
        local targetAdminLevel = tonumber(fetchData["targetAdminLevel"]) or 0
        local targetUsername = fetchData["targetUsername"] or false
        local theAdminPower = exports.un_global:getPlayerAdminLevel(thePlayer)
        if targetCharID and  targetUserID then
            local adminTitle = exports.un_global:getPlayerFullIdentity(thePlayer)
            if targetAdminLevel > theAdminPower then
                local adminUsername = getElementData(thePlayer, "account:username")
                outputChatBox("Sizden daha yüksek yetkiye sahip kişinin karakterine giriş yapamazsın.", thePlayer, 255,0,0)
                exports.un_global:sendMessageToAdmins("[GİRİŞ]: " .. tostring(adminTitle) .. " yüksek yetkiye sahip bir yöneticinin karakterine girmeye çalıştı ("..targetUsername..").")
                return false
            end
           
            spawnCharacter(targetCharID, targetUserID, thePlayer, targetUsername)  
            exports.un_global:sendMessageToAdmins("[GİRİŞ]: " .. tostring(adminTitle) .. " hesabına giriş yaptı, '"..targetUsername.."'.")
        end
	else
		outputChatBox("Karakter adı bulunamadı.", thePlayer, 255,0,0)
	end
end

addEvent("account:charactersQuotaCheck", true)
addEventHandler("account:charactersQuotaCheck", root,
    function(player)
        triggerClientEvent(player, "account:charactersQuotaCheck", player, true, "Onaylandı")
    end
)

function spawnCharacter(characterID, remoteAccountID, theAdmin, targetAccountName, location)
	if theAdmin then
		client = theAdmin
	end
	
	if not client then
		return false
	end
	
	if not characterID then
		return false
	end
	
	if not tonumber(characterID) then
		return false
	end
	characterID = tonumber(characterID)
	
	triggerEvent('setDrunkness', client, 0)
	setElementData(client, "alcohollevel", 0, true)

	removeMasksAndBadges(client)
	
	setElementDataEx(client, "pd.jailserved")
	setElementDataEx(client, "pd.jailtime")
	setElementDataEx(client, "pd.jailtimer")
	setElementDataEx(client, "pd.jailstation")
	setElementData(client, "loggedin", 0, true)
	
	local timer = getElementData(client, "pd.jailtimer")
	if isTimer(timer) then
		killTimer(timer)
	end
	
	if (getPedOccupiedVehicle(client)) then
		removePedFromVehicle(client)
	end
	-- End cleaning up
	
	local accountID = tonumber(getElementData(client, "account:id"))
	
	local characterData = false
	
	if theAdmin then
		accountID = remoteAccountID
		sqlQuery = "SELECT * FROM `characters` LEFT JOIN `jobs` ON `characters`.`id` = `jobs`.`jobCharID` AND `characters`.`job` = `jobs`.`jobID` WHERE `id`='" .. tostring(characterID) .. "' AND `account`='" .. tostring(accountID) .. "'"
	else
		sqlQuery = "SELECT * FROM `characters` LEFT JOIN `jobs` ON `characters`.`id` = `jobs`.`jobCharID` AND `characters`.`job` = `jobs`.`jobID` WHERE `id`='" .. tostring(characterID) .. "' AND `account`='" .. tostring(accountID) .. "' AND `cked`=0"
	end
	
	dbQuery(
		function(qh, client, characterID, remoteAccountID, theAdmin, targetAccountName, location)
			local res, rows, err = dbPoll(qh, 0)
			if rows > 0 then
				characterData = res[1]
				if characterData then
					if characterData["description"] then
						setElementData(client, "look", fromJSON(characterData["description"]) or {"", "", "", "", characterData["description"], ""})
					end
					setElementData(client, "weight", characterData["weight"])
					setElementData(client, "height", characterData["height"])
					setElementData(client, "race", tonumber(characterData["skincolor"]))
					setElementData(client, "maxvehicles", tonumber(characterData["maxvehicles"]))
					setElementData(client, "maxinteriors", tonumber(characterData["maxinteriors"]))
					--DATE OF BIRTH
					setElementData(client, "age", tonumber(characterData["age"]))
					setElementData(client, "month", tonumber(characterData["month"]))
					setElementData(client, "day", tonumber(characterData["day"]))
					
					-- LANGUAGES
					local lang1 = tonumber(characterData["lang1"])
					local lang1skill = tonumber(characterData["lang1skill"])
					local lang2 = tonumber(characterData["lang2"])
					local lang2skill = tonumber(characterData["lang2skill"])
					local lang3 = tonumber(characterData["lang3"])
					local lang3skill = tonumber(characterData["lang3skill"])
					local currentLanguage = tonumber(characterData["currlang"]) or 1
					setElementData(client, "languages.current", currentLanguage, false)
									
					if lang1 == 0 then
							lang1skill = 0
					end
					
					if lang2 == 0 then
							lang2skill = 0
					end
					
					if lang3 == 0 then
							lang3skill = 0
					end
					
					setElementData(client, "languages.lang1", lang1, false)
					setElementData(client, "languages.lang1skill", lang1skill, false)
					
					setElementData(client, "languages.lang2", lang2, false)
					setElementData(client, "languages.lang2skill", lang2skill, false)
					
					setElementData(client, "languages.lang3", lang3, false)
					setElementData(client, "languages.lang3skill", lang3skill, false)
					-- END OF LANGUAGES
					
					setElementData(client, "timeinserver", tonumber(characterData["timeinserver"]), false)
					setElementData(client, "account:character:id", characterID, false)
					setElementData(client, "dbid", characterID, true) -- workaround
					exports['un_items']:loadItems( client, true )
					setElementData(client, "loggedin", 1, true)
					
					-- Check his name isn't in use by a squatter
					local playerWithNick = getPlayerFromName(tostring(characterData["charactername"]))
					if isElement(playerWithNick) and (playerWithNick~=client) then
						if theAdmin then
							local adminTitle = exports.un_global:getPlayerAdminTitle(theAdmin)
							local adminUsername = getElementData(theAdmin, "account:username")
							kickPlayer(playerWithNick, getRootElement(), adminTitle.." "..adminUsername.." has logged into your account.")
							outputChatBox(""..targetAccountName.." ("..tostring(characterData["charactername"]):gsub("_"," ")..") adlı hesap oyundan atıldı.", theAdmin, 0, 255, 0 )
						else
							kickPlayer(playerWithNick, getRootElement(), "Başkası senin karakterinde oturum açmış olabilir.")
						end
					end
					
					setElementData(client, "bleeding", 0, false)
					
					-- Set their name to the characters
					setElementData(client, "legitnamechange", 1)
					setPlayerName(client, tostring(characterData["charactername"]))
					local pid = getElementData(client, "playerid")
					local fixedName = string.gsub(tostring(characterData["charactername"]), "_", " ")

					setElementData(client, "legitnamechange", 0)
					
					setPlayerNametagShowing(client, false)
					setElementFrozen(client, true)
					setPedGravity(client, 0)
					
					local locationToSpawn = {}
					if location then
						locationToSpawn.x = location[1]
						locationToSpawn.y = location[2]
						locationToSpawn.z = location[3]
						locationToSpawn.rot = location[4]
						locationToSpawn.int = location[5]
						locationToSpawn.dim = location[6]
					else
						locationToSpawn.x = tonumber(characterData["x"])
						locationToSpawn.y = tonumber(characterData["y"])
						locationToSpawn.z = tonumber(characterData["z"])
						locationToSpawn.rot = tonumber(characterData["rotation"])
						locationToSpawn.int = tonumber(characterData["interior_id"])
						locationToSpawn.dim = tonumber(characterData["dimension_id"])
					end
					spawnPlayer(client, locationToSpawn.x ,locationToSpawn.y ,locationToSpawn.z , locationToSpawn.rot, tonumber(characterData["skin"]))
					setElementDimension(client, locationToSpawn.dim)
					setElementInterior(client, locationToSpawn.int , locationToSpawn.x, locationToSpawn.y, locationToSpawn.z)
					setCameraInterior(client, locationToSpawn.int)
					

					exports["un_items"]:loadItems(client)

					setCameraTarget(client, client)
					setElementHealth(client, tonumber(characterData["health"]))
					setPedArmor(client, tonumber(characterData["armor"]))
					
					local teamElement = nil
					if (tonumber(characterData["faction_id"])~=-1) then
						teamElement = exports.un_pool:getElement('team', tonumber(characterData["faction_id"]))
						if not (teamElement) then       -- Facshun does not exist?
							characterData["faction_id"] = -1
							dbExec(mysql:getConnection(), "UPDATE characters SET faction_id='-1', faction_rank='1' WHERE id='" .. tostring(characterID) .. "' LIMIT 1")
						end
					end
					
					if teamElement then
						setPlayerTeam(client, teamElement)
					else
						setPlayerTeam(client, getTeamFromName("Citizen"))
					end

					
					local adminLevel = getElementData(client, "admin_level")
					local gmLevel = getElementData(client, "account:gmlevel")
					exports.un_global:updateNametagColor(client)
					-- ADMIN JAIL
					local jailed = getElementData(client, "adminjailed")
					local jailed_time = getElementData(client, "jailtime")
					local jailed_by = getElementData(client, "jailadmin")
					local jailed_reason = getElementData(client, "jailreason")

					if location then
							setElementPosition(client, location[1], location[2], location[3])
							setElementPosition(client, location[4], 0, 0)
					end
					
					if jailed then
						local incVal = getElementData(client, "playerid")
								
						setElementDimension(client, 55000+incVal)
						setElementInterior(client, 6)
						setCameraInterior(client, 6)
						setElementPosition(client, 263.821807, 77.848365, 1001.0390625)
						setPedRotation(client, 267.438446)
												
						setElementData(client, "jailserved", 0, false)
						setElementData(client, "adminjailed", true)
						setElementData(client, "jailreason", jailed_reason, false)
						setElementData(client, "jailadmin", jailed_by, false)
						
						if jailed_time ~= 999 then
							if not getElementData(client, "jailtimer") then
								setElementData(client, "jailtime", jailed_time+1, false)
								--exports['un_admins']:timerUnjailPlayer(client)
								triggerEvent("admin:timerUnjailPlayer", client, client)
							end
						else
							setElementData(client, "jailtime", "Unlimited", false)
							setElementData(client, "jailtimer", true, false)
						end

						
						setElementInterior(client, 6)
						setCameraInterior(client, 6)
					end
					
					setElementData(client, "faction", tonumber(characterData["faction_id"]), true)
					setElementData(client, "factionMenu", 0)
					local factionPerks = type(characterData["faction_perks"]) == "string" and fromJSON(characterData["faction_perks"]) or { }
					setElementData(client, "factionPackages", factionPerks, true)
					setElementData(client, "factionrank", tonumber(characterData["faction_rank"]), true)
					setElementData(client, "factionphone", tonumber(characterData["faction_phone"]), true)
					setElementData(client, "factionleader", tonumber(characterData["faction_leader"]), true)
					local factionPerks = type(characterData["faction_perms"]) == "string" and fromJSON(characterData["faction_perms"]) or {}
					setElementData(client, "factionperms", factionPerms, true)
					
					setElementData(client, "businessprofit", 0, false)
					setElementData(client, "legitnamechange", 0)
					setElementData(client, "muted", tonumber(muted))
					setElementData(client, "minutesPlayed",  tonumber(characterData["minutesPlayed"]), true)
					setElementData(client, "hoursplayed",  tonumber(characterData["hoursplayed"]), true)
					setPlayerAnnounceValue ( client, "score", characterData["hoursplayed"] )
					setElementData(client, "alcohollevel", tonumber(characterData["alcohollevel"]) or 0, true)
					exports.un_global:setMoney(client, tonumber(characterData["money"]), true)
					exports.un_global:checkMoneyHacks(client)
					
					setElementData(client, "restrain", tonumber(characterData["cuffed"]), true)
					setElementData(client, "tazed", false, false)
					setElementData(client, "realinvehicle", 0, false)
					
					local duty = tonumber(characterData["duty"]) or 0
					setElementData(client, "duty", duty, true)
					
					-- Job system - MAXIME
					setElementData(client, "job", tonumber(characterData["jobID"]) or 0, true)
					setElementData(client, "jobLevel", tonumber(characterData["jobLevel"]) or 0, true)
					setElementData(client, "jobProgress", tonumber(characterData["jobProgress"]) or 0, true)
					
					-- MAXIME JOB SYSTEM
					if tonumber(characterData["job"]) == 1 then
						if characterData["jobTruckingRuns"] then
							setElementData(client, "job-system-trucker:truckruns", tonumber(characterData["jobTruckingRuns"]), true)
							dbExec(mysql:getConnection(), "UPDATE `jobs` SET `jobTruckingRuns`='0' WHERE `jobCharID`='"..tostring(characterID).."' AND `jobID`='1' " )
						end
						triggerClientEvent(client,"restoreTruckerJob",client)
					end
					triggerEvent("restoreJob", client)
					--triggerClientEvent(client, "updateCollectionValue", client, tonumber(characterData["photos"]))
					--------------------------------------------------------------------------
					setElementData(client, "license.car", tonumber(characterData["car_license"]), true)
					setElementData(client, "license.bike", tonumber(characterData["bike_license"]), true)
					setElementData(client, "license.boat", tonumber(characterData["boat_license"]), true)
					setElementData(client, "license.pilot", tonumber(characterData["pilot_license"]), true)
					setElementData(client, "license.fish", tonumber(characterData["fish_license"]), true)
					setElementData(client, "license.gun", tonumber(characterData["gun_license"]), true)
					setElementData(client, "license.gun2", tonumber(characterData["gun2_license"]), true)
					
					setElementData(client, "bankmoney", tonumber(characterData["bankmoney"]), true)
					setElementData(client, "fingerprint", tostring(characterData["fingerprint"]), false)
					setElementData(client, "tag", tonumber(characterData["tag"]))
					setElementData(client, "blindfold", tonumber(characterData["blindfold"]), false)
					setElementData(client, "gender", tonumber(characterData["gender"]))
					setElementData(client, "deaglemode", 1, true) -- Default to lethal
					setElementData(client, "shotgunmode", 1, true) -- Default to lethal
					setElementData(client, "youtuber", tonumber(characterData["youtuber"]), true)
					setElementData(client, "rplus", tonumber(characterData["rplus"]), true)
					setElementData(client, "etiket", tonumber(characterData["etiket"]), true)
					setElementData(client, "donator", tonumber(characterData["donator"]), true)
					setElementData(client, "country", tonumber(characterData["ulke"]), true)
					setElementData(client, "hunger", tonumber(characterData["hunger"]), true)
					setElementData(client, "thirst", tonumber(characterData["thirst"]), true)
					setElementData(client, "level", tonumber(characterData["level"]), true)
					setElementData(client, "hoursaim", tonumber(characterData["hoursaim"]), true)
					setElementData(client, "box", tonumber(characterData["box"]), true)
					setElementData(client, "boxexp", tonumber(characterData["boxexp"]), true)
					setElementData(client, "vipver", 0)
					local resource = getResourceFromName("un_vip")
					if resource then
					local state = getResourceState(resource)
                        if state == "running" then
                                setElementData(client, "vipver", 0)
                                exports['un_vip']:loadVIP(characterID)
                        end
					end
					exports.un_anticheat:changeProtectedElementDataEx(client, "fakename", false, true)
					setElementData(client, "hapis_sure", tonumber(characterData["hapis_sure"]))
                    setElementData(client, "hapis_sebep", characterData["hapis_sebep"], true)
					setElementData(client, "clothing:id", tonumber(characterData["clothingid"]) or nil, true)
					if (tonumber(characterData["restrainedobj"])>0) then
						setElementData(client, "restrainedObj", tonumber(characterData["restrainedobj"]), false)
					end
					
					if ( tonumber(characterData["restrainedby"])>0) then
						setElementData(client, "restrainedBy",  tonumber(characterData["restrainedby"]), false)
					end

					takeAllWeapons(client)
					
					if (getElementType(client) == 'player') then
						triggerEvent("updateLocalGuns", client)
					end
					
					setPedStat(client, 70, 999)
					setPedStat(client, 71, 999)
					setPedStat(client, 72, 999)
					setPedStat(client, 74, 999)
					setPedStat(client, 76, 999)
					setPedStat(client, 77, 999)
					setPedStat(client, 78, 999)
					setPedStat(client, 77, 999)
					setPedStat(client, 78, 999)
					setPedStat(client, 79, 999) -- Strafeing fix
					
					toggleAllControls(client, true, true, true)
					triggerClientEvent(client, "onClientPlayerWeaponCheck", client)
					setElementFrozen(client, false)
					
					
					-- Player is cuffed
					if (tonumber(characterData["cuffed"])==1) then
						toggleControl(client, "sprint", false)
						toggleControl(client, "fire", false)
						toggleControl(client, "jump", false)
						toggleControl(client, "next_weapon", false)
						toggleControl(client, "previous_weapon", false)
						toggleControl(client, "accelerate", false)
						toggleControl(client, "brake_reverse", false)
						toggleControl(client, "aim_weapon", false)
					end            
					
					
					setPedFightingStyle(client, tonumber(characterData["fightstyle"]))     
					triggerEvent("onCharacterLogin", client, charname, tonumber(characterData["faction_id"]))
					triggerClientEvent(client, "accounts:characters:spawn", client, fixedName, adminLevel, gmLevel, tonumber(characterData["faction_id"]), tonumber(characterData["faction_rank"]))
					triggerClientEvent(client, "item:updateclient", client)
					
					
					if not theAdmin then
					--	dbExec(mysql:getConnection(), "UPDATE characters SET online='1', lastlogin=NOW() WHERE id='" .. characterID .. "'")
						local monitored = getElementData(client, "admin:monitor")
						if monitored then
							if monitored ~= "New Player" then
								exports.un_global:sendMessageToAdmins("[MONITOR] ".. getPlayerName(client):gsub("_", " ") .." ("..pid.."): "..monitored)
								exports.un_global:sendMessageToSupporters("[MONITOR] ".. getPlayerName(client):gsub("_", " ") .." ("..pid.."): "..monitored)
							end
						end
					end
					
					setTimer(setPedGravity, 2000, 1, client, 0.008)
					setElementAlpha(client, 255)
					
					-- WALKING STYLE
					triggerEvent("realism:applyWalkingStyle", client, characterData["walkingstyle"] or 128, true)

					if duty > 0 then
						local foundPackage = false
						for key, value in ipairs(factionPerks) do
							if tonumber(value) == tonumber(duty) then
								foundPackage = true
									break
							end
						end
						
						if not foundPackage then
							triggerEvent("duty:offduty", client)
							outputChatBox("Artık kullandığınız göreve erişiminiz yok - bu nedenle, kaldırıldı.", client, 255, 0, 0)
						end
					end
					triggerEvent("social:character", client)
					
					if theAdmin then
						local adminTitle = exports.un_global:getPlayerAdminTitle(theAdmin)
						local adminUsername = getElementData(theAdmin, "account:username")
						outputChatBox("You've logged into player's character successfully!", theAdmin, 0, 255, 0 )
						local hiddenAdmin = getElementData(theAdmin, "hiddenadmin")
						if hiddenAdmin == 0 then
							exports.un_global:sendMessageToAdmins("AdmKmt: " .. tostring(adminTitle) .. " "..adminUsername.." başka bir hesaba girdi, ("..targetAccountName..") "..tostring(characterData["charactername"]):gsub("_"," ")..".")
						end
					end
					

					if (tonumber(characterData["blindfold"])==1) then
						setElementData(client, "blindfold", 1)
						outputChatBox("Karakterinin gözü kapalı. eğer bu OCC bir eylem ise, F2 tuşunu kullanarak yönetici ile iletişime geç.", client, 255, 194, 15)
						fadeCamera(client, false)
					else
						fadeCamera(client, true, 4)
					end

					if (tonumber(characterData["cuffed"])==1) then
						outputChatBox("Karakterin sınırlandırılmış.", client, 255, 0, 0)
					end

					loadCharacterSettings(client,characterID)
					
					triggerClientEvent(client, "drawAllMyInteriorBlips", client)

					triggerEvent("playerGetMotds", client)
					triggerEvent( "accounts:character:select", client )
				end
			end
		end,
	{client, characterID, remoteAccountID, theAdmin, targetAccountName, location}, mysql:getConnection(), sqlQuery)
end
addEventHandler("accounts:characters:spawn", getRootElement(), spawnCharacter)
 
function Characters_onCharacterChange()
	triggerClientEvent(client, "items:inventory:hideinv", client)
	triggerEvent("savePlayer", client, "Change Character")
	triggerEvent('setDrunkness', client, 0)
	setElementData(client, "alcohollevel", 0, true)
	setElementData(client, "clothing:id", nil, true)
	removeMasksAndBadges(client)
	setElementData(client, "pd.jailserved")
	setElementData(client, "pd.jailtime")
	setElementData(client, "pd.jailtimer")
	setElementData(client, "pd.jailstation")
	setElementData(client, "loggedin", 0, true)
	setElementData(client, "bankmoney", 0)
	setElementData(client, "account:character:id", false)
	setElementAlpha(client, 0)
	removeElementData(client, "jailed")
	removeElementData(client, "jail_time")
	removeElementData(client, "jail:id")
	removeElementData(client, "jail:cell") 
	removeElementData(client, "enableGunAttach")
	triggerEvent("destroyWepObjects", client)
	
	if (getPedOccupiedVehicle(client)) then
			removePedFromVehicle(client)
	end
	exports.un_global:updateNametagColor(client)
	local clientAccountID = getElementData(client, "account:id") or -1
	setElementInterior(client, 0)
	setElementDimension(client, 1)
	setElementData(client, "legitnamechange", 1)
	setElementData(client, "legitnamechange", 0)
	triggerEvent("shop:removeMeFromCurrentShopUser",client, client)
	triggerClientEvent(client, "hideGeneralshopUI", client)
	local padId = getElementData(client, "padUsing")
	if padId then
		removeElementData(client, "padUsing")
		for key, thePad in pairs(getElementsByType("object", getResourceRootElement(getResourceFromName("un_item-world")))) do
			if getElementData(thePad, "id") == padId then
				removeElementData(thePad, "playerUsing")
				break
			end
		end
	end
	triggerEvent("accounts:character:select", client)
end
addEventHandler("accounts:characters:change", getRootElement(), Characters_onCharacterChange)
 
function removeMasksAndBadges(client)
    for k, v in ipairs({exports['un_items']:getMasks(), exports['un_items']:getBadges()}) do
        for kx, vx in pairs(v) do
            if getElementData(client, vx[1]) then
               setElementData(client, vx[1], false, true)
            end
        end
    end
end

local playersToBeSaved = { }

function beginSave()
	outputDebugString("Yerdeki tum esyalar kaydedildi.")
	for key, value in ipairs(getElementsByType("player")) do
		--triggerEvent("savePlayer", value, "Save All")
		table.insert(playersToBeSaved, value)
	end
	local timerDelay = 0
	for key, thePlayer in ipairs(playersToBeSaved) do
		timerDelay = timerDelay + 1000
		setTimer(savePlayer, timerDelay, 1, "Save All", thePlayer)
	end
end

function syncTIS()
	for key, value in ipairs(getElementsByType("player")) do
		local tis = getElementData(value, "timeinserver")
		if (tis) and (getPlayerIdleTime(value) < 600000)  then
			setElementData(value, "timeinserver", tonumber(tis)+1, false)
		end
	end
end
setTimer(syncTIS, 60000, 0)

function savePlayer(reason, player)
	if source ~= nil then
		player = source
	end
	if isElement(player) then
		local logged = getElementData(player, "loggedin")
		if (logged==1 or reason=="Change Character") then
			local vehicle = getPedOccupiedVehicle(player)
		
			if (vehicle) then
				local seat = getPedOccupiedVehicleSeat(player)
				triggerEvent("onVehicleExit", vehicle, player, seat)
			end
		
			local x, y, z, rot, health, armour, interior, dimension, cuffed, skin, duty, timeinserver, businessprofit, alcohollevel
		
			local x, y, z = getElementPosition(player)
			local rot = getPedRotation(player)
			local health = getElementHealth(player)
			local armor = getPedArmor(player)
			local interior = getElementInterior(player)
			local dimension = getElementDimension(player)
			local alcohollevel = getElementData(player, "alcohollevel")
			local d_addiction = ( getElementData(player, "drug.1") or 0 ) .. ";" .. ( getElementData(player, "drug.2") or 0 ) .. ";" .. ( getElementData(player, "drug.3") or 0 ) .. ";" .. ( getElementData(player, "drug.4") or 0 ) .. ";" .. ( getElementData(player, "drug.5") or 0 ) .. ";" .. ( getElementData(player, "drug.6") or 0 ) .. ";" .. ( getElementData(player, "drug.7") or 0 ) .. ";" .. ( getElementData(player, "drug.8") or 0 ) .. ";" .. ( getElementData(player, "drug.9") or 0 ) .. ";" .. ( getElementData(player, "drug.10") or 0 )
			money = getElementData(player, "stevie.money")
			if money and money > 0 then
			money = 'money = money + ' .. money .. ', '
			else
				money = ''
			end
			skin = getElementModel(player)
		
			if getElementData(player, "help") then
				dimension, interior, x, y, z = unpack( getElementData(player, "help") )
			end
		
			-- Fix for #0000984
			if getElementData(player, "businessprofit") and ( reason == "Quit" or reason == "Timed Out" or reason == "Unknown" or reason == "Bad Connection" or reason == "Kicked" or reason == "Banned" ) then
				businessprofit = 'bankmoney = bankmoney + ' .. getElementData(player, "businessprofit") .. ', '
			else
				businessprofit = ''
			end
		
			-- Fix for freecam-tv
			if exports['un_freecam']:isPlayerFreecamEnabled(player) then 
				x = getElementData(player, "tv:x")
				y = getElementData(player, "tv:y")
				z =  getElementData(player, "tv:z")
				interior = getElementData(player, "tv:int")
				dimension = getElementData(player, "tv:dim") 
			end
		
			local  timeinserver = getElementData(player, "timeinserver")
			-- LAST AREA
			local zone = exports.un_global:getElementZoneName(player)
			if not zone or #zone == 0 then
				zone = "Unknown"
			end
			local hunger = getElementData(player, "hunger") or 100
			local thirst = getElementData(player, "thirst") or 100
			
			local _, characters_temp = getTableInformations()
			for index, value in ipairs(characters_temp) do
				if value.id == getElementData(player, "dbid") then
					table.remove(characters_temp, index)
				end
			end
			dbQuery(
				function(qh)
					local res, rows, err = dbPoll(qh, 0)
					if rows > 0 then
						for index, value in ipairs(res) do
							row_info = {}
							for count, data in pairs(value) do
								row_info[count] = data
							end
							imported_characters[#imported_characters + 1] = row_info
						end
					end
				end,
			mysql:getConnection(), "SELECT * FROM `characters` WHERE `id` = ?", getElementData(player, "dbid"))
		end
	end
end
addEventHandler("onPlayerQuit", getRootElement(), savePlayer)
addEvent("savePlayer", false)
addEventHandler("savePlayer", getRootElement(), savePlayer)
setTimer(beginSave, 3600000, 0)
addCommandHandler("saveall", function(p) if exports.un_integration:isPlayerSeniorAdmin(p) then beginSave() outputChatBox("Başarıyla kayıt alındı.", p) end end)
addCommandHandler("saveme", function(p) triggerEvent("savePlayer", p, "Save Me", p) end)

addEvent("checkAlreadyUsingName", true)
addEventHandler("checkAlreadyUsingName", root,
	function(player, name)
		dbQuery(
			function(qh)
				local res, rows, err = dbPoll(qh, 0)
				if rows > 0 then
				    a = false
					triggerClientEvent(player, "receiveNameRegisterable", player, a, name)
				else
					a = true
					triggerClientEvent(player, "receiveNameRegisterable", player, a, name)
				end
			end,
		mysql:getConnection(), "SELECT charactername FROM characters WHERE charactername='"..name:gsub(" ", "_").. "'")
	end
)

local mysql = exports.un_mysql

function newCharacter_create(characterName_, characterDescription_, race_, gender_, skin_, height_, weight_, age_, languageselectun_, month_, day_, location_)
	characterName, characterDescription, race, gender, skin, height, weight, age, languageselected, month, day, location = characterName_, characterDescription_, race_, gender_, skin_, height_, weight_, age_, languageselectun_, month_, day_, location_

	if not (race > -1 and race < 3) then
		triggerClientEvent(client, "accounts:characters:new", client, 1, 2) -- State 1:2: error validating data
		return
	end
	
	if not (gender == 0 or gender == 1) then
		triggerClientEvent(client, "accounts:characters:new", client, 1, 3) -- State 1:3: error validating data
		return
	end
	
	characterName = string.gsub(tostring(characterName), " ", "_")
	
	dbQuery(
		function(qh, client, characterName, race, gender, skin, height, weight, age, languageselected, month, day)
			local res, rows, err = dbPoll(qh, 0)
			if rows > 0 then
				triggerClientEvent(client, "accounts:characters:new", client, 2, 1)
			else
				local accountID = getElementData(client, "account:id")
				local accountUsername = getElementData(client, "account:username")
				local fingerprint = md5((characterName) .. accountID .. race .. gender .. age)
				
				if month == "Ocak" then
					month = 1
				end
				
				local walkingstyle = 128
				if gender == 1 then
					walkingstyle = 129
				end
				location = { 396.83984375, -1531.484375, 32.2734375, 0, 0, 0, "IGS Yaninda bir otobüs durağı"}
				
				dbExec(mysql:getConnection(), "INSERT INTO `characters` SET `charactername`='" .. (characterName).. "', `x`='"..location[1].."', `y`='"..location[2].."', `z`='"..location[3].."', `rotation`='"..location[4].."', `interior_id`='"..location[5].."', `dimension_id`='"..location[6].."', `lastarea`='"..(location[7]).."', `gender`='" .. (gender) .. "', `skincolor`='" .. (race) .. "', `weight`='" .. (weight) .. "', `height`='" .. (height) .. "', `description`='', `account`='" .. (accountID) .. "', `skin`='" .. (skin) .. "', `age`='" .. (age) .. "', `fingerprint`='" .. (fingerprint) .. "', `lang1`='" .. (languageselected) .. "', `lang1skill`='100', `currLang`='1' , `month`='" .. (month or "1") .. "', `day`='" .. (day or "1").."', `walkingstyle`='" .. (walkingstyle).."'")
	
				dbQuery(
					function(qh, client, characterName, race, gender, skin, height, weight, age, languageselected, month, day)
						local res, rows, err = dbPoll(qh, 0)
						if rows > 0 then
							local id = res[1]['id']
							exports.un_anticheat:changeProtectedElementDataEx(client, "dbid", id, false)
							exports.un_global:giveItem( client, 16, skin )
							-- ID CARD
							exports.un_global:giveItem( client, 152, characterName..";"..(gender==0 and "Bay" or "Bayan")..";"..exports.un_global:formatDate(day or 1).." "..exports.un_global:numberToMonth(month or 1).." "..exports.un_global:getBirthYearFromAge(age)..";"..fingerprint)		-- Briefcase
							-- Briefcase
							if exports.un_global:giveItem( client, 160, 1 ) then
								triggerEvent("artifacts:toggle", client, client, "briefcase")
							end
					
							exports.un_anticheat:changeProtectedElementDataEx(client, "dbid")
							triggerClientEvent(client, "accounts:characters:new", client, 3, tonumber(id))
							
						end
					end,
				{client, characterName, race, gender, skin, height, weight, age, languageselected, month, day}, exports.un_mysql:getConnection(), "SELECT id FROM characters WHERE id = LAST_INSERT_ID()")
			end
		end,
	{client, characterName, race, gender, skin, height, weight, age, languageselected, month, day}, exports.un_mysql:getConnection(), "SELECT charactername FROM characters WHERE charactername='" .. (characterName) .. "'")
end
addEventHandler("accounts:characters:new", getRootElement(), newCharacter_create)


function emailDegistir(eposta)
	local username = getElementData(source, "account:username")
	if (string.len(eposta)<6) then
			triggerClientEvent(source, "email:GUIClose", source)
			triggerClientEvent(source, "accounts:error:window", source, "Geçersiz e-posta adresi.")
	elseif (string.len(eposta)>=50) then
			triggerClientEvent(source, "email:GUIClose", source)
			triggerClientEvent(source, "accounts:error:window", source, "Geçersiz e-posta adresi.")
	elseif (string.find(eposta, ";", 0)) or (string.find(eposta, ":", 0)) or (string.find(eposta, "'", 0)) or (string.find(eposta, ",", 0)) then
			triggerClientEvent(source, "email:GUIClose", source)
			triggerClientEvent(source, "accounts:error:window", source, "Geçersiz e-posta adresi.")
	else
		local query = dbExec(mysql:getConnection(), "UPDATE accounts SET email = '" .. eposta .. "', forceUpdate = 0 WHERE username = '" .. username .. "'")
		if query then
			outputChatBox("#575757UNT:#f9f9f9 E-posta adresiniz başarıyla değiştirildi.", source, 0, 255, 0, true)
			triggerClientEvent(source, "email:GUIClose", source)
		else
			triggerClientEvent(source, "accounts:error:window", source, "MySQL bağlantı hatası. F2 yetkili raporu açın.")
		end
	end
end
addEvent("email:degistir", true)
addEventHandler("email:degistir", getRootElement(), emailDegistir)