local connection = exports.mta_connection:getConnection()

function loadAllGate()
	gates = {}

	local queryHandler = dbQuery(connection, "SELECT * FROM gates")
	local result, numAffectedRows, errorMsg = dbPoll(queryHandler, -1)
	if numAffectedRows > 0 then
		for key, row in ipairs(result) do
			local gateId = tonumber(row["id"])
			gates[key] = {}

			gates[key]["sqlId"] = gateId
			gates[key]["modelId"] = tonumber(row["modelId"])

			gates[key]["lockState"] = true

			gates[key]["defaultState"] = fromJSON(row["defaultState"])
			gates[key]["changeState"] = fromJSON(row["changeState"])
			gates[key]["createRotation"] = fromJSON(row["createRotation"])
			gates[key]["IndDim"] = fromJSON(row["IndDim"])

			gates[key]["gate"] = createObject(gates[key]["modelId"], gates[key]["defaultState"][1], gates[key]["defaultState"][2], gates[key]["defaultState"][3], gates[key]["defaultState"][4], gates[key]["defaultState"][5], gates[key]["defaultState"][6])
			setElementRotation(gates[key]["gate"], gates[key]["createRotation"][1], gates[key]["createRotation"][2], gates[key]["createRotation"][3])
			setElementInterior(gates[key]["gate"], gates[key]["IndDim"][1])
			setElementDimension(gates[key]["gate"], gates[key]["IndDim"][2])
		end
	end

	outputDebugString(#gates .. " gate(s) loaded")
end
addEventHandler("onResourceStart", resourceRoot, loadAllGate)

addCommandHandler("creategate", function (player, cmd, modellID, changex, changey, changez)
	if player then
		if modellID and changex and changey and changez then
			if getElementData(player, "acc:admin") >= 8 then
				local x, y, z = getElementPosition(player)
				local rotx, roty, rotz = getElementRotation(player)
				local int = getElementInterior(player)
				local dim = getElementDimension(player)
				dbExec(connection, "INSERT INTO gates SET defaultState = ?, createRotation = ?, changeState = ?, modelId = ?, IndDim = ? ", toJSON({x, y, z}), toJSON({rotx, roty, rotz}), toJSON({tonumber(changex), tonumber(changey), tonumber(changez)}), modellID, toJSON({int, dim}))
				outputChatBox("#7cc576'Sikeres' #ffffff Létrehozás", player, 255, 255, 255, true)
			end
		else
			outputChatBox("#7cc576[Használat] #ffffff/".. cmd .." #00ced1[Modell ID] [Mozgás_X] [Mozgás_Y] [Mozgás_Z]", player, 255, 255, 255, true)
		end
	end
end)

addCommandHandler("gate", function(player)
	local gate = getClosestGate(player)
	if gate then
		if (not exports["mta_item"]:hasItemS(player, 36, tonumber(gate)) or false) and getElementData(player, "acc:admin") <= 5 then
			outputChatBox("#dc143c[Hiba]:#ffffff Nincs kulcsod a kapuhoz.", player, 255, 255, 255, true)
			return
		end

		if getElementData(gates[gate]["gate"], "inUse") then
			return
		end

		setElementData(gates[gate]["gate"], "inUse", true)

		if gates[gate]["lockState"] then
			moveObject(gates[gate]["gate"], 1500, gates[gate]["changeState"][1], gates[gate]["changeState"][2], gates[gate]["changeState"][3], gates[gate]["changeState"][4], gates[gate]["changeState"][5], gates[gate]["changeState"][6], "OutQuad")
			setElementInterior(gates[gate]["gate"], gates[gate]["IndDim"][1])
			setElementDimension(gates[gate]["gate"], gates[gate]["IndDim"][2])
		else
			moveObject(gates[gate]["gate"], 1500, gates[gate]["defaultState"][1], gates[gate]["defaultState"][2], gates[gate]["defaultState"][3], gates[gate]["defaultState"][4], gates[gate]["defaultState"][5], gates[gate]["defaultState"][6], "OutQuad")
			setElementInterior(gates[gate]["gate"], gates[gate]["IndDim"][1])
			setElementDimension(gates[gate]["gate"], gates[gate]["IndDim"][2])
		end

		gates[gate]["lockState"] = not gates[gate]["lockState"]
		setTimer(function()
			setElementData(gates[gate]["gate"], "inUse", false)
		end, 1500, 1)
	end
end)

addCommandHandler("nearbygate", function(player)
	local gate = getClosestGate(player)
	if gate then
		outputChatBox("#7cc576[ExternalGaming] #ffffffLegközelebbi kapu: #7cc576"..gate, player, 0, 0, 0, true)
	else
		outputChatBox("#7cc576[ExternalGaming] #ffffffNincs a közeledben kapu.", player, 0, 0, 0, true)
	end
end)

function getClosestGate(p1)
	local x, y, z = getElementPosition(p1)
	local dis = 99999
	local dis2 = 0
	local gate = false

	for key, value in ipairs(gates) do
		local x2, y2, z2 = getElementPosition(gates[key]["gate"])
		dis2 = getDistanceBetweenPoints3D(x, y, z, x2, y2, z2)

		if tonumber(dis2) < tonumber(dis) and tonumber(dis2) <= 9 then
			dis = dis2
			gate = key
		end
	end
	return gate
end