2 #include "cmd_neonserv.h"
8 CMD_BIND(neonserv_cmd_listrank) {
13 printf_mysql_query("SELECT `rank_id`, `rank_name` FROM `support_ranks`");
15 table = table_init(3, mysql_num_rows(res) + 1, 0);
17 content[0] = get_language_string(user, "NS_LISTRANK_ID");
18 content[1] = get_language_string(user, "NS_LISTRANK_NAME");
19 content[2] = get_language_string(user, "NS_LISTRANK_ASSIGNED");
20 table_add(table, content);
21 while ((row = mysql_fetch_row(res)) != NULL) {
25 printf_mysql_query("SELECT COUNT(*) FROM `users` WHERE `user_rank` = '%s'", row[0]);
27 row = mysql_fetch_row(res2);
31 char **table_lines = table_end(table);
33 for(i = 0; i < table->entrys; i++) {
34 reply(getTextBot(), user, table_lines[i]);
37 reply(getTextBot(), user, "NS_TABLE_NONE");
39 printf_mysql_query("SELECT COUNT(*) FROM `users` WHERE `user_rank` = '0' AND `user_access` > 0");
41 row = mysql_fetch_row(res2);
42 reply(getTextBot(), user, "NS_LISTRANK_UNRANKED", atoi(row[0]));