on 1:text:*:?: { var %botdb = $sqlite_open($scriptdir\Databases\xfed.db) if ($1 == !register) { var %sql = SELECT Nickname, Hostname FROM Users 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) set %user.nick $hget(row, 2) echo -a %user.nick : %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 ) halt