local connectionHandle;
local pldata = { }
addEventHandler ( "onPlayerJoin", root,
function ( )
spawnPlayer ( source, 1959.55, -1714.46, 10 )
fadeCamera ( source, true )
setCameraTarget ( source, source )
end
)
addEventHandler ( "onResourceStart", root,
function ( )
connectionHandle = dbConnect ( "mysql", "dbname=testgm;host=localhost", "root", "" )
local query = dbQuery ( connectionHandle, "SELECT * FROM `user`" )
if ( query ) then
for key, value in ipairs ( dbPoll ( query, -1 ) ) do
table.insert ( pldata, { id = value[ "id" ], name = value[ "name" ], age = value[ "age" ], profession = value[ "profession" ], language = value[ "language" ] } )
end
end
end
)