local host = "blizzard-servers.com"             -- Your MySQL Host
local user = "blizzard_warn"                        -- The MySQL user
local pass = "*****************"                    -- Your MySQL password
local db   = "blizzard_warn"            -- Database name
local port = 3306                       -- MySQL port (if you are unsure don't change this)

-- DO NOT EDIT PAST THIS POINT!
require("mysqloo")

function EPSILON:InitDB()
    self.DB = mysqloo.connect(host, user, pass, db --[[, "76561198060076722"]])
    self.DB:connect()

    self.DB.onConnected = function()
        self.DB:query([[CREATE TABLE IF NOT EXISTS epsilon(
            `id`    INT(11) NOT NULL    AUTO_INCREMENT,
            `Victim`    TEXT    NOT NULL,
            `Issuer`    TEXT    NOT NULL,
            `Reason`    TEXT    NOT NULL,
            `issuerSteamId` VARCHAR(20) NOT NULL,
            `victimSteamId` VARCHAR(20) NOT NULL,
            `time` INT,
            PRIMARY KEY (id)
        ) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1;]])
        self.DB:query([[ALTER TABLE epsilon ADD time INT AFTER victimSteamId;]])
    end
end

function EPSILON:QueryDB(query, callback, error)
    local query = self.DB:query(query)
    query.onSuccess = (callback or function() end)

    query.onError = (error or function(_, err, sql)
        MsgC(Color(255, 0, 0), "EPSILON: SQL error: " .. err .. " in statement \"" .. sql .. "\"\n")
    end)

    query:start()
end

hook.Add("Initialize", "LoadInventoryDatabase", function()
    EPSILON:InitDB()
end)