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)


local function reg( pl, cmd, args )
pl:Register( args[1], args[2], args[3] )
end
concommand.Add( "SomeNameOfTheCommand", req )