RqUnigqT

1require("mysqloo")
2include("eazy_jobsaver_mysqloolib.lua")
3if not mysqloo then
4	print("not loaded!")
5end	
6eazyJobSave = {}
7
8eazyJobSave.eazy_host = "crypticrp.us"
9eazyJobSave.eazy_username = "crypticr_user"
10eazyJobSave.eazy_password = "Tillyb12"
11eazyJobSave.eazy_databasename = "crypticr_eazyjob"
12eazyJobSave.eazy_databaseport = "3306"
13
14eazyJobSave.eazy_openDatabase = mysqloo.CreateDatabase(eazyJobSave.eazy_host, eazyJobSave.eazy_username, eazyJobSave.eazy_password , eazyJobSave.eazy_databasename, eazyJobSave.eazy_databaseport)
15
16eazyJobSave.eazy_openDatabase:RunQuery([[
17CREATE TABLE IF NOT EXISTS `eazy_playersJobs` (
18    `steamID` BIGINT UNSIGNED NOT NULL,
19    `job` INT NOT NULL,
20    KEY(`steamID`))
21]])
22
23
24
25
26
27
28hook.Add("PlayerDisconnected","eazy_update_Job_Row",function(ply)
29	if ply:Team() == 0 then return end
30	eazyJobSave.eazy_openDatabase:PrepareQuery([[
31		DELETE FROM eazy_playersJobs
32		WHERE steamID = ]]..ply:SteamID64()..[[
33	]])
34
35	eazyJobSave.eazy_openDatabase:PrepareQuery([[
36		INSERT INTO eazy_playersJobs (steamID, job) 
37		VALUES (]]..ply:SteamID64()..[[,]]..ply:Team()..[[)
38	]])
39end)
40
41
42hook.Add("PlayerInitialSpawn","eazy_change_Job",function(ply)
43
44	local plyJob = eazyJobSave.eazy_openDatabase:query([[ SELECT * FROM eazy_playersJobs WHERE steamID = ]]..ply:SteamID64()..[[;]])
45	function plyJob:onSuccess()
46	 
47		if _G.RPExtraTeams[plyJob:getData()[1].job].max == 0 then
48			ply:changeTeam(plyJob:getData()[1].job, true, true)
49		elseif _G.RPExtraTeams[plyJob:getData()[1].job].max > team.NumPlayers(plyJob:getData()[1].job) then
50			ply:changeTeam(plyJob:getData()[1].job, true, true)
51		else
52			ply:changeTeam(1, true, true)
53		end
54	end
55	plyJob:start()
56end)