server.lua

root = getRootElement()

-- MySQL Handlers.
db = dbConnect( "mysql", "dbname=admin_mta;host=127.0.0.1", "admin_mta", "FUCK MY PASSWORD SHIT", "share=1" )

if db then
	outputDebugString( "Connection with database was successfully established." )
else
	outputDebugString( "Connection with database couldn't be established." )
end


function loginPlayer(username, password)
qh = dbQuery(db, "SELECT * FROM accounts WHERE BINARY username=? and password=?", username, md5(password))
result , numrows, errmsg = dbPoll (qh, -1)
local row = result[1]
if row then
  outputChatBox("You have successfully logged in.", client)
  triggerClientEvent(source, "login.success", source)
  setElementData(client, "isPlayedLoggedIn", true)
  setElementData(client, "getPlayerUsername", username)
else
  outputChatBox("Oops! Something went wrong, have a check on your username and password.", client)
end
end
addEvent("loginPlayer", true)
addEventHandler("loginPlayer", resourceRoot, loginPlayer)

-- Register Player

function registerPlayer(username, password, email)
qh = dbQuery(db, "SELECT * FROM accounts WHERE BINARY username=?", username)
result , numrows, errmsg = dbPoll (qh, -1)
local row = result[1]
if row then
  outputChatBox("Sorry! Username already in use.", client)
else
  cr = dbQuery(db, "INSERT INTO accounts (username, password, email) VALUES (?,?,?)", username, md5(password), email)
  triggerClientEvent(source, "register.success", source)
end
end
addEvent("registerPlayer", true)
addEventHandler("registerPlayer", resourceRoot, registerPlayer)