All pastes #915011 Raw Edit

Something

public text v1 · immutable
#915011 ·published 2008-02-23 12:51 UTC
rendered paste body
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 <pass> <e-mail>)
          halt