#LASTNUKE
proc ms:lastnuke {nick uhost hand chan arg} {
      global mysql_ db_ searchchan
        set handle [mysqlconnect -host $mysql_(host) -user $mysql_(user) -pass $mysql_(password) -db $mysql_(db)];
    set chan [string tolower $chan]
    if {[channel get $chan search]} {
              set splitz [split $arg " "]
          set group [lrange $splitz 0 0]
          set group [string trimleft $group "\\\{"]
          set numrel [mysqlsel $handle "SELECT $db_(id) FROM $mysql_(table) WHERE $db_(group)= '$group'"]
            if {$numrel == 0} {
            putnow "PRIVMSG $chan :\[ \0037SEARCHING\003 \]"
            putnow "PRIVMSG $chan :\[ \0034No results found\003 \]"
            } else {
            set query1 [mysqlsel $handle "SELECT $db_(rlsname),$db_(section),$db_(files),$db_(size),$db_(status),$db_(reason),$db_(network),$db_(time),$db_(genre) FROM $mysql_(table) WHERE $db_(status)= '1' ORDER BY time DESC LIMIT 1" -flatlist];
            foreach { name type files mb nuke reason nukenetwork time genre} $query1 {
            if { $genre == "" } { set genre "" } else { set genre " / $genre" }
            if { ![string match $mb "0.00"] } { set mb "" } else { set mb " $mb $m / " }
             if { ![string match $files "0"] } { set files "" } else { set files " $files $f " }
if {$nuke == "1"} {
              set f "Files"
              set m "MB"
              putnow "PRIVMSG $chan :\[ \0037SEARCHING\003 \]"
              putnow "PRIVMSG $chan :\[ \0034Nuked\003 \] $name \[ \00314PRED\003: [duration [expr [unixtime] - $time]] \] \[\00314DATE\003: [clock format $time -format "%d-%m-%Y"] \] \[\00314TIME\003: [clock format $time -format "%H:%M:%S"] \] \00314in\003 \[ [tr:text2color $type] $genre \] \[ \00314INFO\003: $mb $files \] \[ \00314Nuke reason:\003 \0034$reason\003 \00314by\003: \0034$nukenetwork\003 \]"
              } else {
        putlog "ERROR in (PRESEARCH)"
    }
  }
}
        mysqlclose $handle
      }
    }
#END