pyR6ENga

1staffData = { }
2
3addEventHandler ( "onResourceStart", resourceRoot,
4	function ( )
5		connection = dbConnect ( "sqlite", "database.db" )
6		if ( connection ) then 
7			dbExec ( connection, "CREATE TABLE IF NOT EXISTS staffs (id INTEGER PRIMARY KEY AUTOINCREMENT, account TEXT, nick TEXT, rankName TEXT, lastAction TEXT, addedBy TEXT, joinedOn TEXT, lastLogin TEXT, warningPoints INT )" )
8			dbExec ( connection, "CREATE TABLE IF NOT EXISTS staff_ranks (id INTEGER PRIMARY KEY AUTOINCREMENT, account TEXT, rankName TEXT, permissions TEXT )" )
9			dbQuery ( ranksCallback, { staff.account }, connection, "SELECT rankName, permissions FROM staff_ranks" )
10			outputDebugString ( "Staff System: Successfully connected to database." )
11		else 
12			outputDebugString ( "Staff System: Failed to connecte to database" )
13		end 
14	end 
15)
16 
17function ranksCallback ( query ) 
18	local result = dbPoll ( query, 0 )
19	if ( result and type ( result ) == "table" ) then 
20		for _, rank in ipairs ( result ) do 
21			table.insert (
22				staffData [ rank.account ] [ "ranks" ],
23				{
24					[ "rankName" ] = tostring ( rank.rankName ),
25					[ "permissions" ] = fromJSON ( tostring ( rank.permissions ) )
26				}
27			)
28		end  
29	end  
30end