local DB_HOST = "89.34.96.142"
local DB_USERNAME = "daquirer_mybb982"
local DB_PASSWORD = "soulicious123"
local DB_FORUM_DATABASE = "daquirer_mybb982"
local DB_PORT = 3306

local Sync_Method = "SteamID"

local Forum_Table = "mybbbg_"

GroupID = {

	["bwhitelistThingHere"]=2,

}

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

function log (msg)
	ServerLog("Forum Sync >> "..msg.."\n")
end

require ("mysqloo")

local db = mysqloo.connect(DB_HOST, DB_USERNAME, DB_PASSWORD, DB_FORUM_DATABASE, DB_PORT)

function QueryDB(query, callback)

    q = db:query(query)

    function q:onSuccess(result)
        if callback then
            callback(result)
        end
    end

    function q:onError(err, sql)
        log("Query errored.")
        log("Query: ", sql)
        log("Error: ", err)

        if db:status() == 2 then
			db:connect()

			function db:onConnected()
				q:start()
			end

		end
    end
    q:start()

end

function db:onConnectionFailed(err)

    log("Database connection failed.")
    log("Error: ", err)

end

function db:onConnected()

    log("Connection to Forum MySQL (v"..db:serverVersion()..") database successful.")

end

hook.Add("PlayerSay", "onSyncSay", function(ply, text, team)

	if (string.lower(text) == "!sync") then

	local steamID = ply:SteamID64()
	local low_method = string.lower(Sync_Method)
	local forumtable = string.lower(Forum_Table)
	bWhitelist:GetPlayerWhitelists(ply)
	PrintTable(getIDTable)
	local getID = GroupID[getIDTable[1]]

	--querycheck = "SELECT * FROM "..forumtable.."users WHERE loginname='"..steamID.."';"
	--queryB = "UPDATE "..forumtable.."users SET usergroup="..getID.." WHERE loginname='"..steamID.."';"
	log("Synced MyBB User: "..steamID.." to Forum with GroupID: "..getID)

	ply:ChatPrint("You're Forum rank has now been synced with your Ingame Rank, this means whatever regiment you are apart of ingame, you will be apart of that on the forums, make sure to refresh the forums.")

	end

end)

db:connect()