src/cmd_neonserv_delrank.c

   1
   2 #include "cmd_neonserv.h"
   3
   4 /*
   5 * argv[0-*]   rank name
   6 */
   7
   8 CMD_BIND(neonserv_cmd_delrank) {
   9     char *name = merge_argv(argv, 0, argc);
  10     MYSQL_RES *res;
  11     MYSQL_ROW row;
  12     printf_mysql_query("SELECT `rank_id`, `rank_name` FROM `support_ranks` WHERE `rank_name` = '%s'", escape_string(name));
  13     res = mysql_use();
  14     if ((row = mysql_fetch_row(res)) == NULL) {
  15         reply(getTextBot(), user, "NS_DELRANK_NOT_FOUND", name);
  16         return;
  17     }
  18     printf_mysql_query("UPDATE `users` SET `user_rank` = '0', `user_access` = '0' WHERE `user_rank` = '%s'", row[0]);
  19     printf_mysql_query("REMOVE FROM `support_ranks` WHERE `rank_id` = '%s'", row[0]);
  20     reply(getTextBot(), user, "NS_DELRANK_DELETED", row[1]);
  21 }