on 1:text:*:?: {
var %botdb = $sqlite_open($scriptdir\Databases\xfed.db)
if ($1 == !register) {
var %sql = SELECT Hostname FROM Users WHERE Hostname = $site
var %request = $sqlite_query(%botdb, %sql)
if (%request && $sqlite_fetch_row(%request, row)) {
; Grab 'Hostname' (1) Field from the table 'Users' and apply it to an global variable.
set %user.host $hget(row, 1)
echo -a %user.host
sqlite_free %request
if (%user.host == $site) {
msg $nick You already have registered. If you have forgotten your password please type !lostpass and we will generate a new one for you.
halt
}
else {
if ($2 == $null) || ($3 == $null) {
msg $nick You did not specify a password or e-mail address, please try again. (Syntax: !register <pass> <e-mail>)
halt
}