local meta = FindMetaTable("Player")
if !meta then return end

// By Killzone.
// No pulic release.
// Made for selthion-network.com for Killzone.

DB = {}

// OH NO!
DB.ERROR = {
    [1] = "ERROR: Module not found or couldn't initialize!",
    [2] = "ERROR: Module didn't load.",
    [3] = "ERROR: Connection wasn't made.",
    [4] = "SUCCESS: Module was found and loaded!",
    [5] = "SUCCESS: Connection was made!"
}

DB.Module = require( "tmysql" )
if DB.Module then
        print( DB.ERROR[4] )
    else
        print( DB.ERROR[2])
end

function DB.Connect()

    local HOST = "mysql.xenonservers.com"
    local PORT = 3306
    local NAME = "kunden_53984"
    local USERNAME = "kunden_53984"
    local PASSWORD = "selthion"

    print(DB.ERROR[5])
    tmysql.initialize( HOST, NAME , PASSWORD, USERNAME, PORT, 2, 2)

end

DB.Connect()

// Create a new account.
function DB.NewAccount( pl )
    local ID = pl:SteamID()
    local name = pl:Name()

    tmysql.query("INSERT INTO db_users (steamid, name, donator, money, title) VALUES( '"..pl:SteamID().."', '"..name.."', '0', '0', 'Guest') ")
    local query = tmysql.query("SELECT * FROM db_users WHERE steamid = '"..pl:SteamID().."'")

    DB.LoadAccount( pl )
    pl:ChatPrint("Your account has loaded.")

end

// Load an account.
function DB.LoadAccount( pl )
    pl.PlayerData = {}
    local query = tmysql.query("SELECT * FROM db_users WHERE steamid = '"..pl:SteamID().."'")
    if !query then pl:ChatPrint("Could not load your account...") return end
    pl.PlayerData["money"] = tmysql.query("SELECT money FROM db_users WHERE steamid = '"..pl:SteamID().."'")
    pl.PlayerData["title"] = tmysql.query("SELECT title FROM db_users WHERE steamid = '"..pl:SteamID().."'")
    pl.PlayerData["donator"] = tmysql.query("SELECT donator FROM db_users WHERE steamid = '"..pl:SteamID().."'")

    pl:ChatPrint("Your account has loaded.")
end

// Save an account.
function DB.SaveAccount( pl )
    name = pl:Name()
    ID = pl:SteamID()
    money = pl.PlayerData["money"] or 0
    VIP = pl.PlayerData["donator"] or 0
    title = pl.PlayerData["title"] or "Guest"

    tmysql.query("UPDATE db_users SET name = "..name.." WHERE steamid = '"..tostring(ID).."'")
    tmysql.query("UPDATE db_users SET money = "..money.." WHERE steamid = '"..tostring(ID).."'")
    tmysql.query("UPDATE db_users SET donator = "..VIP.." WHERE steamid = '"..tostring(ID).."'")
    tmysql.query("UPDATE db_users SET title = "..title.." WHERE steamid = '"..tostring(ID).."'")
end

// Check if we have the player in our database or not..
function Player( pl )
    ID = pl:SteamID()
    local query = tmysql.query("SELECT * FROM db_users WHERE steamid = '"..pl:SteamID().."'")

    if query then
        DB.LoadAccount( pl )
        pl:ChatPrint("[Mysql] Account found for "..pl:Name().." with steamid "..pl:SteamID()..".")
    else
        DB.NewAccount( pl )
        pl:ChatPrint("[Mysql] No account found for "..pl:Name().." , creating one...")
    end
end

function SQL( pl )
    ID = pl:SteamID()
    Player( pl )
end
concommand.Add("MYSQL", SQL)