src/cmd_neonserv_uset.c

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