int db;
int cmd(string who){
mixed rows;
string ret;
db = db_connect("localhost", "errors");
if(who == "all")
rows = db_exec(db, "select Reporter, count(*) as bing from errors "
"where Status = 'DENIED' "
"group by Reporter order by bing desc");
else
rows = db_exec(db, sprintf("select Reporter, count(*) from errors "
"where Reporter = '%s' and Status = 'DENIED' "
"group by Reporter",
who));
if(intp(rows)){
ret = sprintf("%-15s %s\n", "player", "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);
this_player()->more_string(ret);
} else printf(rows);
return 1;
}
