// Database shit

require ("mysqloo")

local DATABASE_HOST = ""
local DATABASE_PORT = ""
local DATABASE_NAME = ""
local DATABASE_USERNAME = ""
local DATABASE_PASSWORD = ""

function connectToDatabase()
    databaseObject = mysqloo.connect(DATABASE_HOST, DATABASE_USERNAME, DATABASE_PASSWORD, DATABASE_NAME, DATABASE_PORT)
    databaseObject.onConnected = function() print("Database connection successful.) end
    databaseObject.onConnectionFailed = function() print("Database connection failed.) end
    databaseObject:connect()
end

function checkQuery(query)
    local playerInfo = query:getData()
    if playerInfo[1] ~= nil then
        return true
    end
end

function FirstJoinMysql( ply )
    local query1 = databaseObject:query("SELECT * FROM Players WHERE ID = '" .. ply:SteamID() .. "'")
    query1.onSuccess = function(q)
        if not checkQuery(q) then
            local query2 = databaseObject:query(INSERT INTO Players(ID, money) VALUES ('" .. ply:SteamID() .. "', " ..1000 .. ")")
            query2.onSuccess = function(q) print("Account created for" v:Nick() v:SteamID ".")
            query2.onError = function(q,e) print("Something went wrong when trying to create an account for" v:Nick() v:SteamID ".")
            query2.start()
        else
            print( v:Nick() v:SteamID() "has logged on.")
        end
    end
    query1.onError = function(q,e) print("Authenticating issue has occurred.")
    query1.start()
end
hook.Add( "PlayerInitialSpawn", "PlayerInitialSpawn", FirstJoinMysql )