local Table = {
	{ x, y, z },
	{ x, y, z },
	{ x, y, z },
	{ x, y, z },
	{ x, y, z },
	{ x, y, z },
}

addEventHandler( "onResourceStart", resourceRoot,
	function ( )
		executeSQLQuery ( "CREATE TABLE IF NOT EXISTS SaveAccount ( PlayerSerial, UserName, PassWord )" )
		executeSQLQuery ( "CREATE TABLE IF NOT EXISTS AutoLogin ( PlayerSerial, AutoLogin )" )
	end
)
addEvent( "onRegister", true )
addEventHandler ( "onRegister", root,
	function ( User, PassWord )
		local Account = addAccount ( tostring ( User ), tostring ( PassWord ) )
		if Account then
			exports ["guimessages"] : outputServer ( source, "UserName: ".. User , 0, 255, 0, true )
			exports ["guimessages"] : outputServer ( source, "PassWord: ".. PassWord , 0, 255, 0, true )
		else
			exports ["guimessages"] : outputServer ( source, "# - [ #ffffff * This account already exists#ff0000 ] - #" , 255, 0, 0, true )
		end
	end
)

addEvent( "onLogin", true )
addEventHandler ( "onLogin", root,
	function ( User, PassWord, Text )
		local Account = getAccount ( tostring ( User ), tostring ( PassWord ) )
		local SQL = executeSQLQuery ( "SELECT * FROM SaveAccount WHERE PlayerSerial = ? ", getPlayerSerial ( client ) )
		local SQL1 = executeSQLQuery ( "SELECT * FROM AutoLogin WHERE PlayerSerial = ? ", getPlayerSerial ( client ) )
		if Account then
			if Text == "True" then
				if #SQL == 0 then
					executeSQLQuery ( "INSERT INTO AutoLogin ( PlayerSerial, AutoLogin ) VALUES ( ?, ? ) ", getPlayerSerial ( client ), "1" )
					executeSQLQuery ( "INSERT INTO SaveAccount ( PlayerSerial, UserName, PassWord ) VALUES ( ?, ?, ? ) ", getPlayerSerial ( client ), tostring ( User ), tostring ( PassWord ) )
				else
					executeSQLQuery ( "UPDATE SaveAccount SET PlayerSerial = ?, UserName = ?, PassWord = ? ", getPlayerSerial ( client ), tostring ( User ), tostring ( PassWord ) )
					executeSQLQuery ( "UPDATE AutoLogin SET PlayerSerial = ?, AutoLogin = ?", getPlayerSerial ( client ), "1" )
				end
			else
				if #SQL1 == 0 then
					executeSQLQuery ( "INSERT INTO AutoLogin ( PlayerSerial, AutoLogin ) VALUES ( ?, ? ) ", getPlayerSerial ( client ), "1" )
				else
					executeSQLQuery ( "UPDATE AutoLogin SET PlayerSerial = ?, AutoLogin = ?", getPlayerSerial ( client ), "1" )
				end
			end
			logIn ( client, Account, PassWord )
			triggerClientEvent ( source, "Yes", source )
			exports ["guimessages"] : outputServer ( source, "# - [ #ffffff Welcome To Server#ff0000 ] - #" , 255, 0, 0, true )
			local x, y, z = unpack ( Table [ math.random ( #Table ) ] )
			setElementPosition ( source, x, y, z )
		else
			exports ["guimessages"] : outputServer ( source, "# - [ #ffffff * Worng Username Or Password#ff0000 ] - #" , 255, 0, 0, true )
		end
	end
)

addEvent( "On", true )
addEventHandler ( "On", root,
	function ( )
		local SQLListe = executeSQLQuery ( "SELECT * FROM SaveAccount WHERE PlayerSerial = ? ", getPlayerSerial ( client ) )
		local SQLListe1 = executeSQLQuery ( "SELECT * FROM AutoLogin WHERE PlayerSerial = ? ", getPlayerSerial ( client ) )
		if #SQLListe ~= 0 then
			if #SQLListe1 ~= 0 then
				triggerClientEvent ( client, "Yes", client )
				local Account = getAccount ( tostring ( SQLListe [ 1 ] [ "UserName"] ), tostring ( SQLListe [ 1 ] [ "PassWord"] ) )
				logIn ( client, Account, tostring ( SQLListe [ 1 ] [ "PassWord"] ) )
				exports ["guimessages"] : outputServer ( client, "# - [ #ffffff Welcome To Server#ff0000 ] - #" , 255, 0, 0, true )
				local x, y, z = unpack ( Table [ math.random ( #Table ) ] )
				setElementPosition ( source, x, y, z )
			else
				triggerClientEvent ( client, "setInfo", client, SQLListe [ 1 ] [ "UserName"], SQLListe [ 1 ] [ "PassWord"] )
			end
		end
	end
)

addCommandHandler ( "DELETE",
	function ( PlayerSource )
		local SQL = executeSQLQuery ( "SELECT * FROM AutoLogin WHERE PlayerSerial = ? ", getPlayerSerial ( PlayerSource ) )
		if #SQL == 0 then
			exports ["guimessages"] : outputServer ( PlayerSource, "# - [ #ffffff * لقد تم الحذف من قبل#ff0000 ] - #" , 255, 0, 0, true )
		else
			executeSQLQuery ( "DELETE FROM `AutoLogin` WHERE playerSerial = ?", getPlayerSerial ( PlayerSource ) )
			exports ["guimessages"] : outputServer ( PlayerSource, "# - [ #ffffff * تم الحذف بنجاح#ff0000 ] - #" , 255, 0, 0, true )
		end
	end
)