#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() */
