order ranks in cmd_listrank

diff --git a/src/bot_NeonServ.c b/src/bot_NeonServ.c
index e5c2ed1ae4b73e7f49321b0033e7479fe266d14c..5c0a68bbf0f3134adadc0f19fe00a1847758b01f 100644 (file)
--- a/src/bot_NeonServ.c
+++ b/src/bot_NeonServ.c
@@ -515,7 +515,7 @@ void init_NeonServ() {
     OPER_COMMAND("delrank",      neonserv_cmd_delrank,   1,     1000, CMDFLAG_REQUIRE_AUTH | CMDFLAG_CHECK_AUTH | CMDFLAG_OPLOG);
     OPER_COMMAND("setrank",      neonserv_cmd_setrank,   1,     1000, CMDFLAG_REQUIRE_AUTH | CMDFLAG_CHECK_AUTH | CMDFLAG_OPLOG);
     OPER_COMMAND("assignrank",   neonserv_cmd_assignrank,2,     1000, CMDFLAG_REQUIRE_AUTH | CMDFLAG_CHECK_AUTH | CMDFLAG_OPLOG);
-    OPER_COMMAND("listrank",     neonserv_cmd_listrank,  0,     1000, CMDFLAG_REQUIRE_AUTH | CMDFLAG_CHECK_AUTH | CMDFLAG_OPLOG);
+    OPER_COMMAND("listrank",     neonserv_cmd_listrank,  0,     1,    CMDFLAG_REQUIRE_AUTH | CMDFLAG_CHECK_AUTH | CMDFLAG_OPLOG);
     #undef OPER_COMMAND
     
     start_bots();

diff --git a/src/cmd_neonserv_listrank.c b/src/cmd_neonserv_listrank.c
index b87f19d7e53f0a2b50e1dd11f07f81ec76439a66..f28b4bfd7da21722284ae45937548c58752c1ade 100644 (file)
--- a/src/cmd_neonserv_listrank.c
+++ b/src/cmd_neonserv_listrank.c
@@ -26,7 +26,7 @@ CMD_BIND(neonserv_cmd_listrank) {
     MYSQL_ROW row;
     struct Table *table;
     int ranks = 0;
-    printf_mysql_query("SELECT `rank_id`, `rank_name` FROM `support_ranks`");
+    printf_mysql_query("SELECT `rank_id`, `rank_name` FROM `support_ranks` ORDER BY `rank_order` ASC");
     res = mysql_use();
     table = table_init(3, mysql_num_rows(res) + 1, 0);
     char *content[3];