Miscellany

bind pub - !db db_stats

	################################################################################
	## !db
	##   Shows some db stats
	################################################################################
	proc db_stats { nick host handle channel text } {
			global pretimedb
				if {$text == ""} {
				set sql "SELECT COUNT(*) AS count,SUM(`nuke`) AS nuke,SUM(`unnuke`) AS unnuke FROM `release`"
				set query [mysqlsel $pretimedb $sql]
				mysqlmap $pretimedb {count nuke unnuke} {
				putquick "PRIVMSG $channel :14\[12db-Stats14\]12 $count releases are in the db with $nuke 04nuked12 and $unnuke 09unnuked12 releases"
				}
			}
		}