#include <config.h> inherit COMMAND_BASE; int db; int cmd( string who ) { mixed rows; string ret; db = db_connect("localhost", CONFIG_DB_ERRORS, CONFIG_DB_USER ); if( who == "all") rows = db_exec( db, "select Forwarder, count(*) as bing from " "forwards where Forwarder is not NULL group by Forwarder " "order by bing desc"); else rows = db_exec( db, sprintf("select Forwarder, count(*) from " "forwards where Forwarder = '%s' group by Forwarder", who ) ); if( intp(rows) ) { ret = sprintf("%-15s %s\n", "fixer", "reports"); ret += implode( allocate( rows, function( int i ) { mixed tmp = db_fetch( db, i+1 ); return sprintf("%-15s %s", tmp[0], ""+tmp[1] ); } ), "\n"); ret += "\n"; db_close(db); TP->more_string(ret); return 1; } printf(rows); return 1; } /* cmd() */