All pastes #426443 Raw Edit

Unnamed

public text v1 · immutable
·published 2007-04-06 04:00 UTC
rendered paste body
on $*:TEXT:/^!readd\b/g:#: {
  if (!$2) || ($banned($fulladdress)) return
  else {
    var %rlsname = $2
    if ( $readd(%rlsname) ) respondWith Entry re-Added
    else respondWith Fail. Entry not readded
  }
}

alias -l readd {
  if (!$1) { echo 4 -s ERROR: Invalid arguments | return }
  elseif (!%pre_db) { echo 4 -s ERROR: Not connected to database | return }
  else {
    var %rlsname = $sqlite_qt($sqlite_escape_string($1))
    var %sql = SELECT * FROM delpre WHERE releaseName = %rlsname ORDER BY pretime DESC LIMIT 1
    var %request = $sqlite_query(%pre_db, %sql)
    if (!%request) { echo 4 -a ERROR: %sqlite_errstr | return }
    else {
      noop $sqlite_fetch_row(%request,row)
      var %releasename = $hget(row,1), %category = $hget(row,2)
      var %pretime = $hget(row,3), %releaseGroup = $hget(row,4), %userID = $hget(row,5)

      if ($addpre(%releasename, %category, %pretime, %releaseGroup, %userID)) return 1
      elseif (%sqlite_errno == 19) return
      else { echo 4 -s ERROR: %sqlite_errstr | return }
    }
  }
}