cmd_neonserv_uset.c

   1
   2 static CMD_BIND(neonserv_cmd_uset) {
   3     MYSQL_RES *res;
   4     MYSQL_ROW row;
   5     loadUserSettings(user);
   6     if(argc > 0) {
   7         if(!stricmp(argv[0], "language")) {
   8             struct language* lang;
   9             if(argc > 1) {
  10                 if((lang = get_language_by_tag(argv[1])) == NULL && (lang = get_language_by_name(argv[1])) == NULL) {
  11                     lang = user->language;
  12                 } else {
  13                     printf_mysql_query("SELECT `user_id` FROM `users` WHERE `user_user` = '%s'", escape_string(user->auth));
  14                     res = mysql_use();
  15                     if ((row = mysql_fetch_row(res)) != NULL) {
  16                         printf_mysql_query("UPDATE `users` SET `user_lang` = '%s' WHERE `user_id` = '%s'", escape_string(lang->langtag), row[0]);
  17                     } else {
  18                         printf_mysql_query("INSERT INTO `users` (`user_user`, `user_lang`) VALUES ('%s', '%s')", escape_string(user->auth), escape_string(lang->langtag));
  19                     }
  20                     user->language = lang;
  21                 }
  22             } else
  23                 lang = user->language;
  24             reply(getTextBot(), user, "\002Language   \002%s", lang->langname);
  25             char tmp[MAXLEN];
  26             int tmppos = 0;
  27             lang = get_default_language();
  28             tmppos = sprintf(tmp, "%s (%s)", lang->langname, lang->langtag);
  29             printf_mysql_query("SELECT `lang`,`text` FROM `language` WHERE `ident` = 'name'");
  30             res = mysql_use();
  31             while((row = mysql_fetch_row(res)) != NULL) {
  32                 tmppos += sprintf(tmp + tmppos, ", %s (%s)", row[1], row[0]);
  33             }
  34             reply(getTextBot(), user, "  %s", tmp);
  35         } else if(!stricmp(argv[0], "noinvite") && chan) {
  36             loadChannelSettings(chan);
  37             if(!(chan->flags & CHANFLAG_CHAN_REGISTERED)) {
  38                 reply(getTextBot(), user, "MODCMD_CHAN_REQUIRED");
  39                 return;
  40             }
  41             printf_mysql_query("SELECT `id` FROM `noinvite` LEFT JOIN `users` ON `uid` = `user_id` WHERE `cid` = '%d' AND `user_user` = '%s'", chan->channel_id, escape_string(user->auth));
  42             res = mysql_use();
  43             row = mysql_fetch_row(res);
  44             int noinvite = (row ? 1 : 0);
  45             if(argc > 1) {
  46                 if(!strcmp(argv[1], "0") || !stricmp(argv[1], "off") || !stricmp(argv[1], get_language_string(user, "NS_SET_OFF"))) {
  47                     if(noinvite) {
  48                         printf_mysql_query("DELETE FROM `noinvite` WHERE `id` = '%s'", row[0]);
  49                         noinvite = 0;
  50                     }
  51                 } else if(!strcmp(argv[1], "1") || !stricmp(argv[1], "on") || !stricmp(argv[1], get_language_string(user, "NS_SET_ON"))) {
  52                     if(!noinvite) {
  53                         int userid;
  54                         printf_mysql_query("SELECT `user_id` FROM `users` WHERE `user_user` = '%s'", escape_string(user->auth));
  55                         res = mysql_use();
  56                         if ((row = mysql_fetch_row(res)) != NULL) {
  57                             userid = atoi(row[0]);
  58                         } else {
  59                             printf_mysql_query("INSERT INTO `users` (`user_user`) VALUES ('%s')", escape_string(user->auth));
  60                             userid = (int) mysql_insert_id(mysql_conn);
  61                         }
  62                         printf_mysql_query("INSERT INTO `noinvite` (`uid`, `cid`) VALUES ('%d', '%d')", userid, chan->channel_id);
  63                         noinvite = 1;
  64                     }
  65                 }
  66             }
  67             reply(getTextBot(), user, "\002NoInvite   \002%s", (noinvite ? get_language_string(user, "NS_SET_ON") : get_language_string(user, "NS_SET_OFF")));
  68         } else if((!stricmp(argv[0], "autoinvite") || !stricmp(argv[0], "noautoop") || !stricmp(argv[0], "info")) && chan) {
  69             loadChannelSettings(chan);
  70             if(!(chan->flags & CHANFLAG_CHAN_REGISTERED)) {
  71                 reply(getTextBot(), user, "MODCMD_CHAN_REQUIRED");
  72                 return;
  73             }
  74             printf_mysql_query("SELECT `chanuser_flags`, `chanuser_infoline`, `chanuser_access`, `channel_getinvite`, `chanuser_id` FROM `chanusers` LEFT JOIN `users` ON `chanuser_uid` = `user_id` LEFT JOIN `channels` ON `channel_id` = `chanuser_cid` WHERE `chanuser_cid` = '%d' AND `user_user` = '%s'", chan->channel_id, escape_string(user->auth));
  75             res = mysql_use();
  76             row = mysql_fetch_row(res);
  77             if(row) {
  78                 int flags = atoi(row[0]);
  79                 if(!stricmp(argv[0], "autoinvite")) {
  80                     int getInvite = 0;
  81                     if(!row[3] && atoi(row[2]) >= atoi(getChanDefault("channel_getinvite")))
  82                         getInvite = 1;
  83                     else if(row[3] && atoi(row[2]) >= atoi(row[3]))
  84                         getInvite = 1;
  85                     if(getInvite && argc > 1) {
  86                         if(!strcmp(argv[1], "0") || !stricmp(argv[1], "off") || !stricmp(argv[1], get_language_string(user, "NS_SET_OFF"))) {
  87                             if(flags & DB_CHANUSER_AUTOINVITE) {
  88                                 flags &= ~DB_CHANUSER_AUTOINVITE;
  89                                 printf_mysql_query("UPDATE `chanusers` SET `chanuser_flags` = '%d' WHERE `chanuser_id` = '%s'", flags, row[4]);
  90                             }
  91                         } else if(!strcmp(argv[1], "1") || !stricmp(argv[1], "on") || !stricmp(argv[1], get_language_string(user, "NS_SET_ON"))) {
  92                             if(!(flags & DB_CHANUSER_AUTOINVITE)) {
  93                                 flags |= DB_CHANUSER_AUTOINVITE;
  94                                 printf_mysql_query("UPDATE `chanusers` SET `chanuser_flags` = '%d' WHERE `chanuser_id` = '%s'", flags, row[4]);
  95                             }
  96                         }
  97                     }
  98                     if(getInvite)
  99                         reply(getTextBot(), user, "\002AutoInvite \002%s", ((flags & DB_CHANUSER_AUTOINVITE) ? get_language_string(user, "NS_SET_ON") : get_language_string(user, "NS_SET_OFF")));
 100                     else
 101                         reply(getTextBot(), user, "\002AutoInvite \002%s", get_language_string(user, "NS_USET_NO_ACCESS"));
 102                 } else if(!stricmp(argv[0], "noautoop")) {
 103                     if(argc > 1) {
 104                         if(!strcmp(argv[1], "0") || !stricmp(argv[1], "off") || !stricmp(argv[1], get_language_string(user, "NS_SET_OFF"))) {
 105                             if(flags & DB_CHANUSER_NOAUTOOP) {
 106                                 flags &= ~DB_CHANUSER_NOAUTOOP;
 107                                 printf_mysql_query("UPDATE `chanusers` SET `chanuser_flags` = '%d' WHERE `chanuser_id` = '%s'", flags, row[4]);
 108                             }
 109                         } else if(!strcmp(argv[1], "1") || !stricmp(argv[1], "on") || !stricmp(argv[1], get_language_string(user, "NS_SET_ON"))) {
 110                             if(!(flags & DB_CHANUSER_NOAUTOOP)) {
 111                                 flags |= DB_CHANUSER_NOAUTOOP;
 112                                 printf_mysql_query("UPDATE `chanusers` SET `chanuser_flags` = '%d' WHERE `chanuser_id` = '%s'", flags, row[4]);
 113                             }
 114                         }
 115                     }
 116                     reply(getTextBot(), user, "\002NoAutoOp   \002%s", ((flags & DB_CHANUSER_NOAUTOOP) ? get_language_string(user, "NS_SET_ON") : get_language_string(user, "NS_SET_OFF")));
 117                 } else if(!stricmp(argv[0], "info")) {
 118                     char *infoline;
 119                     if(argc > 1) {
 120                         infoline = merge_argv(argv, 1, argc);
 121                         if(!strcmp(infoline, "*"))
 122                             infoline = "";
 123                         printf_mysql_query("UPDATE `chanusers` SET `chanuser_infoline` = '%s' WHERE `chanuser_id` = '%s'", escape_string(infoline), row[4]);
 124                     } else
 125                         infoline = row[1];
 126                     reply(getTextBot(), user, "\002Info       \002%s", infoline);
 127                 }
 128             } else
 129                 reply(getTextBot(), user, "NS_NOT_ON_USERLIST_YOU", chan);
 130         } else
 131             reply(getTextBot(), user, "NS_USET_UNKNOWN_SETTING", argv[0]);
 132     } else {
 133         //view all options
 134         reply(getTextBot(), user, "NS_USET_GLOBAL");
 135         reply(getTextBot(), user, "\002Language   \002%s", user->language->langname);
 136         if(!chan) return;
 137         loadChannelSettings(chan);
 138         if(!(chan->flags & CHANFLAG_CHAN_REGISTERED)) return;
 139         reply(getTextBot(), user, "NS_USET_CHANNEL");
 140         printf_mysql_query("SELECT `id` FROM `noinvite` LEFT JOIN `users` ON `uid` = `user_id` WHERE `cid` = '%d' AND `user_user` = '%s'", chan->channel_id, escape_string(user->auth));
 141         res = mysql_use();
 142         row = mysql_fetch_row(res);
 143         reply(getTextBot(), user, "\002NoInvite   \002%s", (row ? get_language_string(user, "NS_SET_ON") : get_language_string(user, "NS_SET_OFF")));
 144         printf_mysql_query("SELECT `chanuser_flags`, `chanuser_infoline`, `chanuser_access`, `channel_getinvite` FROM `chanusers` LEFT JOIN `users` ON `chanuser_uid` = `user_id` LEFT JOIN `channels` ON `channel_id` = `chanuser_cid` WHERE `chanuser_cid` = '%d' AND `user_user` = '%s'", chan->channel_id, escape_string(user->auth));
 145         res = mysql_use();
 146         row = mysql_fetch_row(res);
 147         if(row) {
 148             int flags = atoi(row[0]);
 149             int getInvite = 0;
 150             if(!row[3] && atoi(row[2]) >= atoi(getChanDefault("channel_getinvite")))
 151                 getInvite = 1;
 152             else if(row[3] && atoi(row[2]) >= atoi(row[3]))
 153                 getInvite = 1;
 154             if(getInvite)
 155                 reply(getTextBot(), user, "\002AutoInvite \002%s", ((flags & DB_CHANUSER_AUTOINVITE) ? get_language_string(user, "NS_SET_ON") : get_language_string(user, "NS_SET_OFF")));
 156             else
 157                 reply(getTextBot(), user, "\002AutoInvite \002%s", get_language_string(user, "NS_USET_NO_ACCESS"));
 158             reply(getTextBot(), user, "\002NoAutoOp   \002%s", ((flags & DB_CHANUSER_NOAUTOOP) ? get_language_string(user, "NS_SET_ON") : get_language_string(user, "NS_SET_OFF")));
 159             reply(getTextBot(), user, "\002Info       \002%s", row[1]);
 160         }
 161     }
 162 }