cn = dbConnect("mysql", "dbname=mta;host=localhost", "root", "1234")
--if cn then
--	outputDebugString(getResourceName(getThisResource())..": Jest połączenie MySQL!")
--	return true
--else
--	outputDebugString(getResourceName(getThisResource())..": Nie ma połączenia MySQL!")
--	return false
--end
addEvent("LoginRequest", true)
addEventHandler("LoginRequest", resourceRoot, function (login, pass)
	local q = dbQuery(cn, "SELECT * FROM dbusers WHERE username=? AND password=?", login, pass)
	local w = dbPoll(q, -1)
	if w and #w > 0 then
		triggerClientEvent(client, "ClosePanelLogownaia", resourceRoot)
		acount = getPlayerAccount(client)
		logIn(client, acount, tostring(pass))
		ac = getAccountName(getPlayerAccount(client))
		if isObjectInACLGroup("user."..ac, aclGetGroup("PD")) then
			spawnPlayer(client, 2880.1000976563, 945.5, 10.800000190735)
			setCameraTarget(client, client)
		else
			spawnPlayer(client, 2880.1000976563, 945.5, 10.800000190735)
			setCameraTarget(client, client)
		end
		queryhandle = dbQuery( cn, 'SELECT * FROM dbusers WHERE username=?', login)
		result = dbPoll(queryhandle, -1)
		for rid, row in ipairs (result) do
			setElementData(client, "id", tonumber(row["id"]))
		end
	else
		triggerClientEvent(root, "setguiText",root, "Błędny nick i/lub hasło!")
	end
end)

addEvent("RegisterRequest", true)
addEventHandler("RegisterRequest", resourceRoot, function(login, pass)
	local q = dbQuery(cn, "SELECT username FROM dbusers WHERE username=?", login)
	local w = dbPoll(q, -1)
	if w and #w > 0 then
		triggerClientEvent(root, "setguiText", root, "Istnieje już konto o podanym nicku!")

	else
		triggerClientEvent(root, "setguiText", root, "Rejestrujesz się pomyślnie!")
		dbExec(cn, "INSERT INTO dbusers SET username=?, password=?, ip=?, serial=?", login, pass, getPlayerIP(getPlayerFromName(login)), getPlayerSerial(getPlayerFromName(login)))
		queryhandle = dbQuery( connection, 'SELECT * FROM dbusers WHERE username=?', login)
		result = dbPoll(cn, -1)
		for rid, row in ipairs (result) do
			setElementData(client, "id", tonumber(row["id"]))
		end
		--dbExec(cn, "INSERT INTO `garcz`(`Gracz`, `pkt`, `money`) VALUES (?,?,?)",getPlayerName(login), 0, 5000)
		setElementData(getPlayerFromName(login), "pkt", 0)
		addAccount(login, pass)
	end
end)