fixed ban timeout check

[NeonServV5.git] / cmd_neonserv_users.c

diff --git a/cmd_neonserv_users.c b/cmd_neonserv_users.c
index 5b6e0657802bf55f0887aaeeee7e7b960ba040f6..f9a7173d4ef7d8605187582e56edc606016e49e7 100644 (file)
--- a/cmd_neonserv_users.c
+++ b/cmd_neonserv_users.c
@@ -53,7 +53,7 @@ static void neonserv_cmd_users_async1(struct ClientSocket *client, struct Client
     char seenstr[MAXLEN];
     struct Table *table;
     struct ChanUser *chanuser;
-    printf_mysql_query("SELECT `chanuser_access`, `user_user`, `chanuser_seen`, `chanuser_flags` FROM `chanusers` LEFT JOIN `users` ON `chanuser_uid` = `user_id` WHERE `chanuser_cid` = '%d'", chan->channel_id);
+    printf_mysql_query("SELECT `chanuser_access`, `user_user`, `chanuser_seen`, `chanuser_flags` FROM `chanusers` LEFT JOIN `users` ON `chanuser_uid` = `user_id` WHERE `chanuser_cid` = '%d' ORDER BY `chanuser_access` DESC, `user_user` ASC", chan->channel_id);
     res = mysql_use();
     table = table_init(4, mysql_num_rows(res) + 1, 0);
     if(usermask)