---------------------------------
--Project: Vitality Gaming
--Author: sekoX
--File: login_server.lua
--Side: Server
---------------------------------
mysqlHandler = nil
function mysqlConnect()
    mysqlHandler = dbConnect("mysql", "dbname=databasename;host=127.0.0.1", "username", "password")
    if mysqlHandler then
        outputDebugString("[MySQL]: Connection stable!")
    else
        outputDebugString("[MySQL]: Connection failed.")
    end
end
addEventHandler("onResourceStart", getRootElement(), mysqlConnect)

MemberTeam = createTeam("Member", 67, 139, 222)
ModeratorTeam = createTeam("Moderator", 222, 183, 67)
AdminTeam = createTeam("Administrator", 222, 67, 67)
DonatorTeam = createTeam("Donator", 222, 217, 67)

function loginUser(username, password)
    local query = dbQuery(mysqlHandler, "SELECT * FROM users WHERE `userName` = ?", username)
    local result, row = dbPoll(query, -1)
    if result and row > 0 then
        for id, data in ipairs(result) do
            if password == data["userPass"] then
                outputChatBox("#ff0000[LOGIN]#ffffff Succesfully logged in!", root, 255, 255, 255, true)
                setElementData(source, "isloggedin", 1)
                setElementData(source, "loginName", data["userName"])
                setElementData(source, "teamLevel", data["teamLevel"])
                setElementData(source, "Money", data["money"])
                setElementData(source, "Rank", data["rank"])
                setElementData(source, "Points", data["points"])
                setElementData(source, "Donator", data["donator"])
                setPlayerInTeam()
                triggerClientEvent("event_success", source, "player")
            else
                outputChatBox("#ff0000[LOGIN]#ffffff Incorrect password!", root, 255, 255, 255, true)
            end
        end
    else
        outputChatBox("#ff0000[LOGIN]#ffffff Wrong account!", root, 255, 255, 255, true)
    end
end
addEvent("event_login", true)
addEventHandler("event_login", getRootElement(), loginUser)

function setPlayerInTeam()
    if getElementData(source, "teamLevel") == 1 then
        setPlayerTeam(source, MemberTeam)
    elseif getElementData(source, "teamLevel") == 2 then
        setPlayerTeam(source, ModeratorTeam)
    elseif getElementData(source, "teamLevel") == 3 then
        setPlayerTeam(source, AdminTeam)
    elseif getElementData(source, "Donator") == 1 then
        setPlayerTeam(source, DonatorTeam)
    end
end

function guestUser()
    setElementData(source, "isloggedin", 1)
    setElementData(source, "Guest", 1)
    setElementData(source, "Money", "Guest")
    setElementData(source, "Rank", "Guest")
    setElementData(source, "Points", "Guest")
    outputChatBox("#ff0000[LOGIN]#ffffff Succesfully logged in as Guest!", root, 255, 255, 255, true)
    triggerClientEvent("event_success", source, "guest")
end
addEvent("event_guest", true)
addEventHandler("event_guest", getRootElement(), guestUser)

function savePlayer()
    local query = dbExec(mysqlHandler, "UPDATE users SET teamLevel=?, money=?, rank=?, points=?, donator=? WHERE userName=?;", getElementData(source, "teamLevel"), getElementData(source, "Money"), getElementData(source, "Rank"), getElementData(source, "Points"), getElementData(source, "Donator"), getElementData(source, "loginName"))
end
addEventHandler("onPlayerQuit", getRootElement(), savePlayer)