#include <config.h>
#include <db.h>
inherit "/cmds/base";
int db;
void finish_request(int type, mixed* data, object person) {
string ret;
mapping row;
if (type == DB_SUCCESS) {
ret = "";
foreach (row in data) {
ret += sprintf("%-15s %s\n", row["Reporter"], "" + row["bing"]);
}
} else {
ret = "Some sort of horrible error!\n";
}
person->more_string(ret, "details");
} /* finish_request() */
int cmd(string who){
string request;
if(who == "all") {
request = "select Reporter, count(*) as bing from errors "
//"where Status = 'OPEN' "
"group by Reporter order by bing desc";
} else {
request = "select Reporter, count(*) as bing from errors "
"where Reporter = '" + who + "'" // and Status = 'OPEN' "
"group by Reporter order by bing desc";
}
DB_HANDLER->make_sql_request("errors", CONFIG_DB_USER, "", request,
(: finish_request($1, $2, $(this_player())) :));
add_succeeded_mess("");
return 1;
}
mixed *query_patterns() {
return ({ "<string'person|all'>", (: cmd($4[0]) :) });
} /* query_pattern() */
