theConnecting = mysql_connect(theHostname, theUsername, thePassword, theDatabase)

-- Functions
function connectMySQL()

	if theConnecting then

		outputConsole("* [DEBUG] The connection was established.")
		outputConsole("* [DEBUG] Connected to MySQL Database: "..theDatabase..".")

	else

		outputConsole("* [DEBUG] Failed to connect to MySQL Database: "..theDatabase..".")
		outputConsole("* [DEBUG] The connection was closed.")

	end

end

-- Events
addEventHandler("onResourceStart", getResourceRootElement(getThisResource()), connectMySQL)

-----------------------------------------------------------------------------------------------

-- Functions
function registerHandler(thePlayer, playerUsername, playerPassword)

	playerUsername = mysql_escape_string(theConnecting, playerUsername)

	local theQuery = mysql_query(theConnecting, "SELECT Username FROM Accounts WHERE Username='"..playerUsername.."'")
	outputConsole(mysql_error(theConnecting))

	if(mysql_num_rows(theQuery) == 0) then

		local playerIP = getPlayerIP(thePlayer)
		local playerSerial = getPlayerSerial(thePlayer)
		outputChatBox("#0066CC* [SERVER] #FFFFFFYou have succesfully registed.", thePlayer, 255, 255, 255, true)
		mysql_query(theConnecting, "INSERT INTO Accounts (Username, Password, IP, Serial) VALUES ('"..playerUsername.."', '"..playerPassword.."', '"..playerIP.."', '"..playerSerial.."'")

	else

		outputChatBox("#0066CC* [SERVER] #FFFFFFAccount already existed.", thePlayer, 255, 255, 255, true)

	end

end

-- Eventswow
addEvent("triggeringRegisterClick", true)
addEventHandler("triggeringRegisterClick", getRootElement(), registerHandler)