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);
29 table_add(table, content);
32 char **table_lines = table_end(table);
34 for(i = 0; i < table->entrys; i++) {
35 reply(getTextBot(), user, table_lines[i]);
38 reply(getTextBot(), user, "NS_TABLE_NONE");
40 printf_mysql_query("SELECT COUNT(*) FROM `users` WHERE `user_rank` = '0' AND `user_access` > 0");
42 row = mysql_fetch_row(res2);
43 reply(getTextBot(), user, "NS_LISTRANK_UNRANKED", atoi(row[0]));