function spawnCharacter(id, source, pass)
	dbQuery(
		function (queryHandler)
			local result, numAffectedRows, errorMsg = dbPoll(queryHandler, 0)
			if numAffectedRows > 0 then
				for k,data in pairs(result) do
					local charname = string.gsub(tostring(data["charactername"]), " ", "_")
					setPlayerName(source, charname)

					local id = tonumber(data["id"])
					local currentid = getElementData(source, "dbid")
					local x = tonumber(data["x"])
					local y = tonumber(data["y"])
					local z = tonumber(data["z"])
					setElementPosition(source, x, y, z)
					local rot = tonumber(data["rotation"])
					setElementData(source, "char:rot", rot)
					local radio = tonumber(data["radiochannel"])
					setElementData(source, "char:radioChannel", radio)
					local ehseg = tonumber(data["ehseg"])
					setElementData(source, "char:Hunger", ehseg)
					local Thirsty = tonumber(data["thirsty"])
					setElementData(source, "char:Thirsty", Thirsty)
					local interior = tonumber(data["interior_id"])
					setElementData(source, "interior", interior)
					local dimension = tonumber(data["dimension_id"])
					setElementData(source, "char:dim", dimension)
					local pr = tonumber(data["pr"])
					local pg = tonumber(data["pg"])
					local pb = tonumber(data["pb"])
					setElementData(source, "char:pR", pr)
					setElementData(source, "char:pG", pg)
					setElementData(source, "char:pB", pb)
					local health = tonumber(data["health"])
					local dead = tonumber(data["dead"])
					setElementData(source, "char:health", health)
					local armor = tonumber(data["armor"])
					setElementData(source, "char:armor", armor)
					local skin = tonumber(data["skin"])
					setElementModel(source, skin)
					setElementData(source, "char:skin", skin)
					local adminnick = tostring(data["adminnick"])
					setElementData(source, "user:adminnick", adminnick)
					local money = tonumber(data["money"])
					setElementData(source, "char:Money", money)
					setElementData(source, "char:timeSpent", tonumber(data["timeSpentOn"]))
					local radiochannel = tonumber(data["radiochannel"])
					local carlicense = tonumber(data["car_license"])
					local gunlicense = tonumber(data["gun_license"])
					local bankmoney = tonumber(data["bankmoney"])
					setElementData(source, "char:Bankmoney", bankmoney)
					local gender = tonumber(data["gender"])
					setElementData(source, "char:gender", gender)
					local dutyskin = tonumber(data["dutyskin"])
					setElementData(source, "char:DutySkin", dutyskin)
					local faction = tonumber(data["faction"])
					setElementData(source, "char:Faction", faction)
					local factionleader = tonumber(data["factionleader"])
					setElementData(source, "char:FactionLeader", factionleader)
					local factionrank = tonumber(data["factionrank"])
					setElementData(source, "char:FactionRank", factionrank)

					setElementData(source, "char:HLP", tonumber(data["hlp"]))

					-- local nextpay = tonumber(data["nextpay"])
					-- setElementData(source, "char:nextpay", nextpay)
					-- triggerClientEvent(source, "onClientTaxTimerStart", source, nextpay)

					local id_code = tostring(data["id_code"])
					setElementData(source, "char:id_code", id_code)
					local age = data["age"]
					setElementData(source, "char:age", age)
					local race = tonumber(data["skincolor"])
					local weight = data["weight"]
					local height = data["height"]
					local desc = data["description"]
					setElementData(source, "char:job", tonumber(data["job"]))
					setElementData(source, "dbid", tonumber(id))
					setElementData(source, "char:MaxInt", tonumber(data["max_int"]))
					setElementData(source, "char:MaxVeh", tonumber(data["max_veh"]))
					setElementData(source, "user:loggedin", 1)
					setElementData(source, "char:phoneNumber", getElementData(source, "dbid"))
					if data["car_license"] == 1 then
						setElementData(source, "char:drivingLicense", true)
					else
						setElementData(source, "char:drivingLicense", false)
					end
					local playerWithNick = getPlayerFromName(tostring(charname))
					setElementData(source, "char:Name", tostring(charname))
					local pid = getElementData(source, "playerid")
					local fixedName = string.gsub(tostring(charname), "_", " ")
					setPlayerNametagText(source, tostring(fixedName))
					setPlayerNametagShowing(source, false)
					triggerClientEvent(source, "showInfoBox", source, "Sikeresen bejelentkeztél, jó szórakozást kivánunk a HL-en!")
					triggerEvent("loadPlayerItems", source, source)
					triggerClientEvent(source, "changeHudState", source)
					triggerClientEvent(source, "destroyLoginBox", source, pass)

					setPedGravity (source, 0.008 )
					setPedAnimation(source, false)
					setElementVelocity(source, 0, 0, 0)
					setElementFrozen(source, false)
					setCameraTarget(source)
					spawnPlayer(source, x, y, z, rot, skin)

					if dead == 1 then
						setElementHealth(source, 0)
					else
						setElementHealth(source, health)
					end

					setPedArmor(source, armor)
					setElementDimension(source, dimension)
					setElementInterior(source, interior, x, y, z)
					setCameraInterior(source, interior)
					toggleAllControls(source, true, true, true)
					setElementFrozen(source, false)

					if tonumber(data["jailTime"]) > 0 then
						setElementDimension(source, 65400 + getElementData(source, "playerid"))
						setElementInterior(source, 6)
						setElementPosition(source, 263.821807, 77.848365, 1001.0390625)
						setPedRotation(source, 267.438446)
						triggerClientEvent(source, "jailText", source, tonumber(data["jailTime"]))
						setElementData(source, "char:jailTime", data["jailTime"])
						local jailReason = tostring(data["jailreason"]) or "Ismeretlen"
						setElementData(source, "char:jailReason", jailReason)
						setElementData(source, "char:adminJailed", true)
						outputChatBox("#00baff[HL]#ffffff Börtönbe kerültél! Indok: ".. jailReason ..".", source, 0, 255, 0, true)
					else
						setElementData(source, "char:jailTime", 0)
						setElementData(source, "char:jailReason", nil)
						setElementData(source, "char:adminJailed", false)
					end

					--- adócucc
					local adolevonas = tonumber(data["adolevonas"])
					if adolevonas == 0 then
						triggerClientEvent(source, "initTax", source)
						mysql:query_free("UPDATE karakterek SET lastlogin = NOW(), lastado = NOW() WHERE id = '".. id .."'")
					end
				end
			else
				triggerClientEvent(source, "showInfoBox", source, "Hiba! Nem található karakter,\nkérlek készítsd el a HL-RPG.EU/REG oldalon!")
			end
		end,
		newsql,
		-- "SELECT * FROM karakterek WHERE account = ?", id
		"SELECT *, (CASE WHEN lastado < CURDATE() THEN 0 ELSE 1 END) AS adolevonas FROM karakterek WHERE account = ?", id
	)
end