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

// By AC²
// No pulic release.
// Made for dP

local DATABASE = {}


// OH NO!
DATABASE.ERROR = {
    [1] = "ERROR: Module not found or couldn't initialize!",
    [2] = "SUCCESS: Module was found, connecting now.",
    [3] = "ERROR: Could not connect to database.",
    [4] = "SUCCESS: Connection was made!",
    [5] = "ERROR: Error in code, go debug! :D"
}

DATABASE.Module = require("tmysql")

if DATABASE.Module then
        print( DATABASE.ERROR[2] )
    else
        print( DATABASE.ERROR[1] )
end

print("DATABASE: OK!")

local HOST = "host here"
local PORT = 3306
local NAME = "name of database here"
local USERNAME = "user name here"
local PASSWORD = "pass"
local DATABASE = "this is the table you're using"
local DEFAULT_CHECKTIME = 1
local DEFAULT_COINS = 100
local DEFAULT_TITLE = "Guest"
local DEFAULT_STATUS = 1

tmysql.initialize(HOST, USERNAME, PASSWORD, NAME, PORT, 2, 2);

function SaveAccount( pl )
    local Name = tmysql.escape( pl:Name() )
    local Coins = pl.PlayerData["coins"]
    local Title = pl.PlayerData["title"]
    local Status = pl.PlayerData["status"]
    tmysql.query("UPDATE `" ..DATABASE.. "` SET `name`='" ..Name.. "', `coins`='" ..Coins.. "', `title`='" ..Title.. "', `status`='" ..Status.. "'  WHERE `steamid`='" .. pl:SteamID() .. "'");
    timer.Simple( 1, function( pl ) LoadAccount( pl ) end, pl )
end

function LoadAccount( pl )
    if !pl or !IsValid( pl ) then return end
    pl.PlayerData = {}
    tmysql.query("SELECT `steamid`, `name`, `coins`, `title`, `status`, `admin`  FROM `" ..DATABASE.. "` WHERE `steamid`='" ..pl:SteamID().. "'", function (result)
    if !pl or !IsValid(pl) then return end
        if !result or !result[1] then
            NewAccount( pl )
            return
        end

        pl.PlayerData["coins"] = result[1][3]
        pl.PlayerData["title"] = result[1][4]
        pl.PlayerData["status"] = result[1][5]

        if pl.PlayerData["status"] == "0" then
            pl:Kick("Your SteamID is banned!")
        end

    end)
    MsgN("Account found for player "..pl:Name().." ("..pl:SteamID()..")("..pl:IPAddress()..")")
    timer.Simple( 1, function ( pl ) SendData( pl ) end, pl)
end

function NewAccount( pl )
    local Name = tmysql.escape( pl:Name() )
    tmysql.query("INSERT INTO `" ..DATABASE.. "` (`steamid`, `name`, `password`, `coins`, `title`, `status`,`admin`, `reason` ) VALUES ('" ..pl:SteamID().. "', '" ..Name.. "', '0', '" ..DEFAULT_COINS.. "', '" ..DEFAULT_TITLE.. "', '" ..DEFAULT_STATUS.. "', '0', '0')", function()
        if !pl or !IsValid(pl) then return end
        LoadAccount( pl )
    end)
end


function LoadAC( pl )
    if !pl or !IsValid( pl ) then return end
    LoadAccount( pl )
end
hook.Add("PlayerInitialSpawn", "Load", LoadAC)

function SaveAC( pl )
    if !pl or !IsValid( pl ) then return end
    SaveAccount( pl )
end
hook.Add("PlayerDisconnected", "Save", SaveAC)