function connect()
DBConnection = dbConnect( "mysql", "dbname=;host=;charset=utf8", "", "" )
if (not DBConnection) then
outputDebugString("Nie uda?o si? nawi?za? po??czenia z baz? MySQL")
else
outputDebugString("Po??czenie z MySQL zosta?o nawi?zane")
end
end
addEventHandler("onResourceStart",resourceRoot, connect)
function query(...)
local queryHandle = dbQuery(DBConnection , ...)
if (not queryHandle) then
return nil
end
local rows = dbPoll(queryHandle, -1)
return rows
end
function zapiszBron ()
local serial = getPlayerSerial ( source )
local bron = getPedWeapon ( source )
local amunijca = getPedTotalAmmo ( source )
local bazaRezultat = query("SELECT * FROM zapisbroni WHERE serial=?", serial)
query("INSERT INTO zapisbroni (serial, bron, amunicja) VALUES (?,?,?)", serial, bron, amunijca)
end
function zaladujBron ()
local serial = getPlayerSerial ( source )
local bazaRezultat = query("SELECT * FROM zapisbroni WHERE serial=?", serial)
if bazaRezultat then
local weapon = giveWeapon ( source, bazaRezultat[1].bron)
setWeaponAmmo ( source, bazaRezultat[1].bron, bazaRezultat[1].amunicja )
end
end
addEventHandler ( "onPlayerJoin", getRootElement(), zaladujBron )
addEventHandler ( "onPlayerQuit", getRootElement(), zapiszBron )