added support ranking system

[NeonServV5.git] / src / cmd_neonserv_delrank.c

diff --git a/src/cmd_neonserv_delrank.c b/src/cmd_neonserv_delrank.c
new file mode 100644 (file)
index 0000000..bd92f00
--- /dev/null
+++ b/src/cmd_neonserv_delrank.c
@@ -0,0 +1,21 @@
+
+#include "cmd_neonserv.h"
+
+/*
+* argv[0-*]   rank name
+*/
+
+CMD_BIND(neonserv_cmd_delrank) {
+    char *name = merge_argv(argv, 0, argc);
+    MYSQL_RES *res;
+    MYSQL_ROW row;
+    printf_mysql_query("SELECT `rank_id`, `rank_name` FROM `support_ranks` WHERE `rank_name` = '%s'", escape_string(name));
+    res = mysql_use();
+    if ((row = mysql_fetch_row(res)) == NULL) {
+        reply(getTextBot(), user, "NS_DELRANK_NOT_FOUND", name);
+        return;
+    }
+    printf_mysql_query("UPDATE `users` SET `user_rank` = '0', `user_access` = '0' WHERE `user_rank` = '%s'", row[0]);
+    printf_mysql_query("REMOVE FROM `support_ranks` WHERE `rank_id` = '%s'", row[0]);
+    reply(getTextBot(), user, "NS_DELRANK_DELETED", row[1]);
+}