added support ranking system

[NeonServV5.git] / src / cmd_neonserv_addrank.c

diff --git a/src/cmd_neonserv_addrank.c b/src/cmd_neonserv_addrank.c
new file mode 100644 (file)
index 0000000..8df429a
--- /dev/null
+++ b/src/cmd_neonserv_addrank.c
@@ -0,0 +1,20 @@
+
+#include "cmd_neonserv.h"
+
+/*
+* argv[0-*]   rank name
+*/
+
+CMD_BIND(neonserv_cmd_addrank) {
+    char *name = merge_argv(argv, 0, argc);
+    MYSQL_RES *res;
+    MYSQL_ROW row;
+    printf_mysql_query("SELECT `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_ADDRANK_EXISTS", row[0]);
+        return;
+    }
+    printf_mysql_query("INSERT INTO `support_ranks` (`rank_name`) VALUES ('%s')", escape_string(name));
+    reply(getTextBot(), user, "NS_ADDRANK_EXISTS", name);
+}