src/cmd_neonserv_uset.c

   1 /* cmd_neonserv_uset.c - NeonServ v5.2
   2  * Copyright (C) 2011  Philipp Kreil (pk910)
   3  *
   4  * This program is free software: you can redistribute it and/or modify
   5  * it under the terms of the GNU General Public License as published by
   6  * the Free Software Foundation, either version 3 of the License, or
   7  * (at your option) any later version.
   8  *
   9  * This program is distributed in the hope that it will be useful,
  10  * but WITHOUT ANY WARRANTY; without even the implied warranty of
  11  * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
  12  * GNU General Public License for more details.
  13  *
  14  * You should have received a copy of the GNU General Public License
  15  * along with this program. If not, see <http://www.gnu.org/licenses/>.
  16  */
  17
  18 #include "cmd_neonserv.h"
  19
  20 CMD_BIND(neonserv_cmd_uset) {
  21     MYSQL_RES *res;
  22     MYSQL_ROW row;
  23     loadUserSettings(user);
  24     if(argc > 0) {
  25         if(!stricmp(argv[0], "language")) {
  26             struct language* lang;
  27             if(argc > 1) {
  28                 if((lang = get_language_by_tag(argv[1])) == NULL && (lang = get_language_by_name(argv[1])) == NULL) {
  29                     lang = user->language;
  30                 } else {
  31                     printf_mysql_query("SELECT `user_id` FROM `users` WHERE `user_user` = '%s'", escape_string(user->auth));
  32                     res = mysql_use();
  33                     if ((row = mysql_fetch_row(res)) != NULL) {
  34                         printf_mysql_query("UPDATE `users` SET `user_lang` = '%s' WHERE `user_id` = '%s'", escape_string(lang->langtag), row[0]);
  35                     } else {
  36                         printf_mysql_query("INSERT INTO `users` (`user_user`, `user_lang`) VALUES ('%s', '%s')", escape_string(user->auth), escape_string(lang->langtag));
  37                     }
  38                     struct UserNode *cuser;
  39                     for(cuser = getAllUsers(NULL); cuser; cuser = getAllUsers(cuser)) {
  40                         if((cuser->flags & USERFLAG_ISAUTHED) && !stricmp(user->auth, cuser->auth))
  41                             cuser->language = lang;
  42                     }
  43                 }
  44             } else
  45                 lang = user->language;
  46             reply(getTextBot(), user, "\002Language   \002%s", lang->langname);
  47             char tmp[MAXLEN];
  48             int tmppos = 0;
  49             lang = get_default_language();
  50             tmppos = sprintf(tmp, "%s (%s)", lang->langname, lang->langtag);
  51             printf_mysql_query("SELECT `lang`,`text` FROM `language` WHERE `ident` = 'name'");
  52             res = mysql_use();
  53             while((row = mysql_fetch_row(res)) != NULL) {
  54                 tmppos += sprintf(tmp + tmppos, ", %s (%s)", row[1], row[0]);
  55             }
  56             reply(getTextBot(), user, "  %s", tmp);
  57         } else if(!stricmp(argv[0], "noinvite") && chan) {
  58             loadChannelSettings(chan);
  59             if(!(chan->flags & CHANFLAG_CHAN_REGISTERED)) {
  60                 reply(getTextBot(), user, "MODCMD_CHAN_REQUIRED");
  61                 return;
  62             }
  63             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));
  64             res = mysql_use();
  65             row = mysql_fetch_row(res);
  66             int noinvite = (row ? 1 : 0);
  67             if(argc > 1) {
  68                 if(!strcmp(argv[1], "0") || !stricmp(argv[1], "off") || !stricmp(argv[1], get_language_string(user, "NS_SET_OFF"))) {
  69                     if(noinvite) {
  70                         printf_mysql_query("DELETE FROM `noinvite` WHERE `id` = '%s'", row[0]);
  71                         noinvite = 0;
  72                     }
  73                 } else if(!strcmp(argv[1], "1") || !stricmp(argv[1], "on") || !stricmp(argv[1], get_language_string(user, "NS_SET_ON"))) {
  74                     if(!noinvite) {
  75                         int userid;
  76                         printf_mysql_query("SELECT `user_id` FROM `users` WHERE `user_user` = '%s'", escape_string(user->auth));
  77                         res = mysql_use();
  78                         if ((row = mysql_fetch_row(res)) != NULL) {
  79                             userid = atoi(row[0]);
  80                         } else {
  81                             printf_mysql_query("INSERT INTO `users` (`user_user`) VALUES ('%s')", escape_string(user->auth));
  82                             userid = (int) mysql_insert_id(mysql_conn);
  83                         }
  84                         printf_mysql_query("INSERT INTO `noinvite` (`uid`, `cid`) VALUES ('%d', '%d')", userid, chan->channel_id);
  85                         noinvite = 1;
  86                     }
  87                 }
  88             }
  89             reply(getTextBot(), user, "\002NoInvite   \002%s", (noinvite ? get_language_string(user, "NS_SET_ON") : get_language_string(user, "NS_SET_OFF")));
  90         } else if((!stricmp(argv[0], "autoinvite") || !stricmp(argv[0], "noautoop") || !stricmp(argv[0], "info")) && chan) {
  91             loadChannelSettings(chan);
  92             if(!(chan->flags & CHANFLAG_CHAN_REGISTERED)) {
  93                 reply(getTextBot(), user, "MODCMD_CHAN_REQUIRED");
  94                 return;
  95             }
  96             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));
  97             res = mysql_use();
  98             row = mysql_fetch_row(res);
  99             if(row) {
 100                 int flags = atoi(row[0]);
 101                 if(!stricmp(argv[0], "autoinvite")) {
 102                     int getInvite = 0;
 103                     if(!row[3] && atoi(row[2]) >= atoi(getChanDefault("channel_getinvite")))
 104                         getInvite = 1;
 105                     else if(row[3] && atoi(row[2]) >= atoi(row[3]))
 106                         getInvite = 1;
 107                     if(getInvite && 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_AUTOINVITE) {
 110                                 flags &= ~DB_CHANUSER_AUTOINVITE;
 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_AUTOINVITE)) {
 115                                 flags |= DB_CHANUSER_AUTOINVITE;
 116                                 printf_mysql_query("UPDATE `chanusers` SET `chanuser_flags` = '%d' WHERE `chanuser_id` = '%s'", flags, row[4]);
 117                             }
 118                         }
 119                     }
 120                     if(getInvite)
 121                         reply(getTextBot(), user, "\002AutoInvite \002%s", ((flags & DB_CHANUSER_AUTOINVITE) ? get_language_string(user, "NS_SET_ON") : get_language_string(user, "NS_SET_OFF")));
 122                     else
 123                         reply(getTextBot(), user, "\002AutoInvite \002%s", get_language_string(user, "NS_USET_NO_ACCESS"));
 124                 } else if(!stricmp(argv[0], "noautoop")) {
 125                     if(argc > 1) {
 126                         if(!strcmp(argv[1], "0") || !stricmp(argv[1], "off") || !stricmp(argv[1], get_language_string(user, "NS_SET_OFF"))) {
 127                             if(flags & DB_CHANUSER_NOAUTOOP) {
 128                                 flags &= ~DB_CHANUSER_NOAUTOOP;
 129                                 printf_mysql_query("UPDATE `chanusers` SET `chanuser_flags` = '%d' WHERE `chanuser_id` = '%s'", flags, row[4]);
 130                             }
 131                         } else if(!strcmp(argv[1], "1") || !stricmp(argv[1], "on") || !stricmp(argv[1], get_language_string(user, "NS_SET_ON"))) {
 132                             if(!(flags & DB_CHANUSER_NOAUTOOP)) {
 133                                 flags |= DB_CHANUSER_NOAUTOOP;
 134                                 printf_mysql_query("UPDATE `chanusers` SET `chanuser_flags` = '%d' WHERE `chanuser_id` = '%s'", flags, row[4]);
 135                             }
 136                         }
 137                     }
 138                     reply(getTextBot(), user, "\002NoAutoOp   \002%s", ((flags & DB_CHANUSER_NOAUTOOP) ? get_language_string(user, "NS_SET_ON") : get_language_string(user, "NS_SET_OFF")));
 139                 } else if(!stricmp(argv[0], "info")) {
 140                     char *infoline;
 141                     if(argc > 1) {
 142                         infoline = merge_argv(argv, 1, argc);
 143                         if(!strcmp(infoline, "*"))
 144                             infoline = "";
 145                         printf_mysql_query("UPDATE `chanusers` SET `chanuser_infoline` = '%s' WHERE `chanuser_id` = '%s'", escape_string(infoline), row[4]);
 146                     } else
 147                         infoline = row[1];
 148                     reply(getTextBot(), user, "\002Info       \002%s", infoline);
 149                 }
 150             } else
 151                 reply(getTextBot(), user, "NS_NOT_ON_USERLIST_YOU", chan);
 152         } else
 153             reply(getTextBot(), user, "NS_USET_UNKNOWN_SETTING", argv[0]);
 154     } else {
 155         //view all options
 156         reply(getTextBot(), user, "NS_USET_GLOBAL");
 157         reply(getTextBot(), user, "\002Language   \002%s", user->language->langname);
 158         if(!chan) return;
 159         loadChannelSettings(chan);
 160         if(!(chan->flags & CHANFLAG_CHAN_REGISTERED)) return;
 161         reply(getTextBot(), user, "NS_USET_CHANNEL");
 162         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));
 163         res = mysql_use();
 164         row = mysql_fetch_row(res);
 165         reply(getTextBot(), user, "\002NoInvite   \002%s", (row ? get_language_string(user, "NS_SET_ON") : get_language_string(user, "NS_SET_OFF")));
 166         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));
 167         res = mysql_use();
 168         row = mysql_fetch_row(res);
 169         if(row) {
 170             int flags = atoi(row[0]);
 171             int getInvite = 0;
 172             if(!row[3] && atoi(row[2]) >= atoi(getChanDefault("channel_getinvite")))
 173                 getInvite = 1;
 174             else if(row[3] && atoi(row[2]) >= atoi(row[3]))
 175                 getInvite = 1;
 176             if(getInvite)
 177                 reply(getTextBot(), user, "\002AutoInvite \002%s", ((flags & DB_CHANUSER_AUTOINVITE) ? get_language_string(user, "NS_SET_ON") : get_language_string(user, "NS_SET_OFF")));
 178             else
 179                 reply(getTextBot(), user, "\002AutoInvite \002%s", get_language_string(user, "NS_USET_NO_ACCESS"));
 180             reply(getTextBot(), user, "\002NoAutoOp   \002%s", ((flags & DB_CHANUSER_NOAUTOOP) ? get_language_string(user, "NS_SET_ON") : get_language_string(user, "NS_SET_OFF")));
 181             reply(getTextBot(), user, "\002Info       \002%s", row[1]);
 182         }
 183     }
 184 }