All pastes #769016 Raw Edit

Unbenannt

public text v1 · immutable
·published 2007-11-11 01:31 UTC
rendered paste body
proc nfo:get {nick uhost hand chan text} {
	global sql
      sql connect $sql(dbhost) $sql(dbuser) $sql(dbpass)
      sql selectdb $sql(dbname)
	set searchstring [string map [list "\*" "\%"] [lindex $text 0]]
      putlog "sql connected"
	set nfo      [lindex [lindex [sql "SELECT nfo FROM $sql(nfo) WHERE nfo_name LIKE '$searchstring%' order by id DESC LIMIT 1"] 0] 0]
	set nfo_name [lindex [sql "SELECT nfo_name FROM $sql(nfo) WHERE nfo_name LIKE '$searchstring%' order by id DESC LIMIT 1"] 0]
	sql disconnect
	putlog "sql disconnected"
	if { $nfo_name == "" } { 
	putquick "PRIVMSG $chan : \00303No NFO Found"
	} else {
	putlog "$nfo"
	set nfo_name [string trim $nfo_name].nfo

      foreach nfostring [split $nfo] {
        exec echo "$nfostring" >> $nfo_name
      }
         switch -exact -- [dccsend $nfo_name $nick] {
	 0 { puthelp "NOTICE $nick :Sending [file tail $nfo_name]." }
	 1 { puthelp "NOTICE $nick :Error: Too many pending file requests. Try again later, thank you." }
	 2 { puthelp "NOTICE $nick :Error: Could not open socket. Please notify my admin, thank you." }
	 3 { puthelp "NOTICE $nick :Error: File does not exist. Please notify my admin, thank you." }
	 4 { puthelp "NOTICE $nick :Error: Too many file sends already in progress. Your request has been added to the queue, please wait." }
	 5 { puthelp "NOTICE $nick :Error: Could not move file to temporary directory. Please notify my admin, thank you." }
	}
	file delete $nfo_name
	}
}