All pastes #439598 Raw Edit

Unnamed

public text v1 · immutable
·published 2007-04-14 11:44 UTC
rendered paste body
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"

				}
			}
		}