require("mysqloo")
include("eazy_jobsaver_mysqloolib.lua")
if not mysqloo then
	print("not loaded!")
end
eazyJobSave = {}

eazyJobSave.eazy_host = "crypticrp.us"
eazyJobSave.eazy_username = "crypticr_user"
eazyJobSave.eazy_password = "Tillyb12"
eazyJobSave.eazy_databasename = "crypticr_eazyjob"
eazyJobSave.eazy_databaseport = "3306"

eazyJobSave.eazy_openDatabase = mysqloo.CreateDatabase(eazyJobSave.eazy_host, eazyJobSave.eazy_username, eazyJobSave.eazy_password , eazyJobSave.eazy_databasename, eazys_databaseport)

eazyJobSave.eazy_openDatabase:RunQuery([[
CREATE TABLE IF NOT EXISTS `eazy_playersJobs` (
    `steamID` BIGINT UNSIGNED NOT NULL,
    `job` INT NOT NULL,
    KEY(`steamID`))
]])






hook.Add("PlayerDisconnected","eazy_update_Job_Row",function(ply)
	if ply:Team() == 0 then return end
	eazyJobSave.eazy_openDatabase:PrepareQuery([[
		DELETE FROM eazy_playersJobs
		WHERE steamID = ]]..ply:SteamID64()..[[
	]])

	eazyJobSave.eazy_openDatabase:PrepareQuery([[
		INSERT INTO eazy_playersJobs (steamID, job)
		VALUES (]]..ply:SteamID64()..[[,]]..ply:Team()..[[)
	]])
end)


hook.Add("PlayerInitialSpawn","eazy_change_Job",function(ply)

	local plyJob = eazyJobSave.eazy_openDatabase:query([[ SELECT * FROM eazy_playersJobs WHERE steamID = ]]..ply:SteamID64()..[[;]])
	function plyJob:onSuccess()

		if _G.RPExtraTeams[plyJob:getData()[1].job].max == 0 then
			ply:changeTeam(plyJob:getData()[1].job, true, true)
		elseif _G.RPExtraTeams[plyJob:getData()[1].job].max > team.NumPlayers(plyJob:getData()[1].job) then
			ply:changeTeam(plyJob:getData()[1].job, true, true)
		else
			ply:changeTeam(1, true, true)
		end
	end
	plyJob:start()
end)