bind pub - !db 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" } } }