CMD_BIND(neonserv_cmd_listrank) {
MYSQL_RES *res, *res2;
- MYSQL_ROW row;
+ MYSQL_ROW row, row2;
struct Table *table;
int ranks = 0;
printf_mysql_query("SELECT `rank_id`, `rank_name` FROM `support_ranks` ORDER BY `rank_order` ASC");
content[1] = get_language_string(user, "NS_LISTRANK_NAME");
content[2] = get_language_string(user, "NS_LISTRANK_ASSIGNED");
table_add(table, content);
+ char usersBuf[MAXLEN];
+ int usersPos, userCount;
+ char assignedBuf[MAXLEN];
while ((row = mysql_fetch_row(res)) != NULL) {
ranks++;
content[0] = row[0];
content[1] = row[1];
- printf_mysql_query("SELECT COUNT(*) FROM `users` WHERE `user_rank` = '%s'", row[0]);
+ printf_mysql_query("SELECT `user_user`, `user_god` FROM `users` WHERE `user_rank` = '%s'", row[0]);
res2 = mysql_use();
- row = mysql_fetch_row(res2);
- content[2] = row[0];
+ usersPos = 0;
+ userCount = 0;
+ while((row2 = mysql_fetch_row(res2)) != NULL) {
+ usersPos += sprintf(usersBuf+usersPos, (usersPos ? ", %s%s" : "%s%s"), (strcmp(row2[1], "0") ? "@" : ""), row2[0]);
+ userCount++;
+ }
+ sprintf(assignedBuf, (userCount ? "%d (%s)" : "%d"), userCount, usersBuf);
+ content[2] = assignedBuf;
table_add(table, content);
}
//send the table
if(!ranks)
reply(getTextBot(), user, "NS_TABLE_NONE");
table_free(table);
- printf_mysql_query("SELECT COUNT(*) FROM `users` WHERE `user_rank` = '0' AND `user_access` > 0");
+ printf_mysql_query("SELECT `user_user` FROM `users` WHERE `user_rank` = '0' AND `user_access` > 0");
res2 = mysql_use();
- row = mysql_fetch_row(res2);
- reply(getTextBot(), user, "NS_LISTRANK_UNRANKED", atoi(row[0]));
+ usersPos = 0;
+ userCount = 0;
+ while((row2 = mysql_fetch_row(res2)) != NULL) {
+ usersPos += sprintf(usersBuf+usersPos, (usersPos ? ", %s%s" : "%s%s"), (strcmp(row2[1], "0") ? "@" : ""), row2[0]);
+ userCount++;
+ }
+ reply(getTextBot(), user, "NS_LISTRANK_UNRANKED", userCount);
+ if(userCount) {
+ reply(getTextBot(), user, " %s", usersBuf);
+ }
}