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