print("VB4 registeration loaded!")

require("tmysql") // Were using tmysql 3 instead of 2.
require("cryptopp") // For md5 encryption.

Host = "localhost"
User = "tokiz"
Pass = "1234"
DB = "vbu"
Port = 3306

tmysql.initialize( Host, User, Pass, DB, Port )

local PLAYER = _R.Player

function SQLHandle( result, _, error )
    if error and error != 0 then
        print( "SQL ERROR: " .. error )
    end
end

function PLAYER:Register( user, pass, email )
    local validemail1 = string.find(email, "@")
    local validemail2 = string.find(email, ".")
    if self.Registered then return false end
    if !user or !pass or !email then return false end

    tmysql.query("INSERT INTO `user` ( `username`, `password`, `passworddate`, `email`, `joindate`, `ipaddress`, `steamid` ) VALUES ( '" .. tmysql.escape(user) .. "', '" .. tmysql.escape(pass) .. "', '" .. os.date() .. "', '" .. tmysql.escape(email) .. "', '" .. os.date() .. "', '" .. self:IPAddress() .. "', '" .. self:SteamID() .. "' )" , SQLHandle )
    self:ChatPrint( "[VB] You have successfully registered." )
    self.Registered = true
end

function PLAYER:IsRegistered( )
    tmysql.query( "SELECT `steamid` FROM `user` WHERE `steamid`= '" .. self:SteamID() .. "'", function ( Args )
        if Args[1] then
            self.Registered = true
            self:ChatPrint( "[VB] Welcome back " .. self:Nick() .. " remember to visit our forums." )
        else
            self.Registered = false
            self:ChatPrint( "[VB] You have register to play on our servers." )
            RunConsoleCommand( "vb4_register" )
        end
    end)
end

hook.Add("PlayerInitialSpawn", "CheckRegisteredStatus", function( p )
    if p:IsPlayer() then
        p:IsRegistered()
    end
end)