dcDTr81f

1con = dbConnect( "sqlite", "organizacje.db" )
2tabela={}
3addEventHandler("onResourceStart",getResourceRootElement(getThisResource()),function()
4	dbExec(con, "CREATE TABLE IF NOT EXISTS 'organizacje' (id INTEGER PRIMARY KEY AUTOINCREMENT, team TEXT,r INT,g INT,b INT, gracze TEXT)")
5	que = dbQuery(con,"SELECT * FROM organizacje")
6	local result = dbPoll(que, -1)
7	if result then
8		for k,v in pairs(result) do
9			team = createTeam(v.team,v.r,v.g,v.b)
10			for k,t in pairs(fromJSON(v.gracze)) do
11				if getPlayerFromName(t[1]) then
12					setPlayerTeam(getPlayerFromName(t[1]),getTeamFromName(v.team))
13				end
14			end
15		end
16	end
17end)
18
19addEventHandler("onPlayerLogin",root,function()
20	que = dbQuery(con,"SELECT * FROM organizacje")
21	local result = dbPoll(que, -1)
22	if result then
23		for k,v in pairs(result) do
24			for k,t in pairs(fromJSON(v.gracze)) do
25				if getPlayerFromName(t[1]) then
26					setPlayerTeam(getPlayerFromName(t[1]),getTeamFromName(v.team))
27				end
28			end
29		end
30	end
31end)
32
33addCommandHandler("org",function(plr,cmd,nazwa,r,g,b)
34	if tostring(nazwa) then
35		local organizacja = createTeam(nazwa,r,g,b)
36		tabela[organizacja] = {}
37		local insert = table.insert(tabela[organizacja],{getPlayerName(plr), "owner"})
38		dbQuery(con, "INSERT INTO 'organizacje' ( team, r, g, b, gracze ) VALUES ( ?,?,?,?,? )", getTeamName(organizacja), r, g ,b, toJSON(tabela[organizacja]))
39	end 
40end)
41
42addCommandHandler("add",function(plr,cmd,player)
43	que = dbQuery(con,"SELECT * FROM organizacje")
44	local result = dbPoll(que, -1)
45	if result then
46		for k,v in pairs(result) do
47			if tabela[v.team] then
48				for k,t in pairs(fromJSON(v.gracze)) do
49					jakastabela={}
50					if t[1] == getPlayerName(plr) then
51						table.insert(jakastabela,v.gracze)
52						table.insert(jakastabela,{getPlayerName(getPlayerFromName(player)), "member"})
53						setPlayerTeam(getPlayerFromName(player), getPlayerTeam(plr))
54						dbQuery (con, "UPDATE 'organizacje' SET gracze = ?", toJSON(jakastabela))
55					end
56				end
57			end
58		end
59	end
60end)