save system

mysqlhost1 = "localhost"
mysqluser1 = "root"
mysqlpassword1 = ""
mysqlhandler1 = "wojtek"


addEventHandler("onResourceStart", getResourceRootElement(), function()
	handler = dbConnect("mysql", "dbname="..mysqlhandler1..";host="..mysqlhost1, mysqluser1, mysqlpassword1, "autoreconnect=1")
if handler then
	outputDebugString ('Datenbank-Connect')
else
	outputDebugString ("Datenbank-ERROR")
end
end)




      
function saveAccounts ()
	local serial = getPlayerSerial ( source )
	local Spielername = getPlayerName ( source )
	local x,y,z = getElementPosition( source )
	local i = getElementInterior( source )
	local d = getElementDimension( source )
	local skin = getPedSkin ( source )
	local money = getPlayerMoney ( source )
	local health = getElementHealth ( source )
	local armor = getPedArmor ( source )
	local wanted = getPlayerWantedLevel ( source )
	local q =   dbQuery(handler,"SELECT * FROM `accounts` WHERE `serial` = '".. serial .."'")
	local result, rows = dbPoll(q, -1)
	if rows == 0 then
		 		  dbExec( handler, "INSERT INTO accounts ( name ,`serial` ,  x, y, z, intterior, demension, skin, money, health, armor, wanted ) VALUES ( ".. Spielername ..",'" .. serial .. "', " .. x .. ", " .. y .. ", " .. z .. "," .. i .. ", " .. d .. "," .. skin .. "," .. money .. ", ".. health ..", ".. armor ..", " .. wanted .. " )" )
	else
		res =  dbExec( handler, "UPDATE `accounts` SET  name = ".. Spielername ..",x = ".. x ..", y =  ".. y ..", z = ".. z ..", intterior = ".. i ..", demension = ".. d ..", skin = ".. skin ..", money = ".. money ..", health = ".. health ..", armor = ".. armor ..", wanted = ".. wanted .." WHERE `serial` = '"..serial.."'")
	end
end


function loadAccounts ()
	local serial = getPlayerSerial ( source )
	local result = dbQuery( handler ,"SELECT * FROM `accounts` WHERE `serial` = ?", serial)
if result then
    local row = dbPoll(result, -1)[1]
			setElementPosition ( source, row.x, row.y, row.z)
			setElementInterior ( source, row.intterior )
			setElementDimension ( source, row.demension )
			setPedSkin ( source, row.skin )
			setPlayerMoney ( source, row.money )
			setElementHealth ( source, row.health)
			setPedArmor ( source, row.armor )
			setPlayerWantedLevel ( source, row.wanted )
                        setPlayerName ( source, row.name )

end
end
addEventHandler ( "onPlayerJoin", getRootElement(), loadAccounts )
addEventHandler ( "onPlayerQuit", getRootElement(), saveAccounts )