// 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 )