2 static CMD_BIND(neonserv_cmd_uset) {
5 loadUserSettings(user);
7 if(!stricmp(argv[0], "language")) {
10 if((lang = get_language_by_tag(argv[1])) == NULL && (lang = get_language_by_name(argv[1])) == NULL) {
11 lang = user->language;
13 printf_mysql_query("SELECT `user_id` FROM `users` WHERE `user_user` = '%s'", escape_string(user->auth));
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]);
18 printf_mysql_query("INSERT INTO `users` (`user_user`, `user_lang`) VALUES ('%s', '%s')", escape_string(user->auth), escape_string(lang->langtag));
20 user->language = lang;
23 lang = user->language;
24 reply(getTextBot(), user, "\002Language \002%s", lang->langname);
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'");
31 while((row = mysql_fetch_row(res)) != NULL) {
32 tmppos += sprintf(tmp + tmppos, ", %s (%s)", row[1], row[0]);
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");
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));
43 row = mysql_fetch_row(res);
44 int noinvite = (row ? 1 : 0);
46 if(!strcmp(argv[1], "0") || !stricmp(argv[1], "off") || !stricmp(argv[1], get_language_string(user, "NS_SET_OFF"))) {
48 printf_mysql_query("DELETE FROM `noinvite` WHERE `id` = '%s'", row[0]);
51 } else if(!strcmp(argv[1], "1") || !stricmp(argv[1], "on") || !stricmp(argv[1], get_language_string(user, "NS_SET_ON"))) {
54 printf_mysql_query("SELECT `user_id` FROM `users` WHERE `user_user` = '%s'", escape_string(user->auth));
56 if ((row = mysql_fetch_row(res)) != NULL) {
57 userid = atoi(row[0]);
59 printf_mysql_query("INSERT INTO `users` (`user_user`) VALUES ('%s')", escape_string(user->auth));
60 userid = (int) mysql_insert_id(mysql_conn);
62 printf_mysql_query("INSERT INTO `noinvite` (`uid`, `cid`) VALUES ('%d', '%d')", userid, chan->channel_id);
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");
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));
76 row = mysql_fetch_row(res);
78 int flags = atoi(row[0]);
79 if(!stricmp(argv[0], "autoinvite")) {
81 if(!row[3] && atoi(row[2]) >= atoi(getChanDefault("channel_getinvite")))
83 else if(row[3] && atoi(row[2]) >= atoi(row[3]))
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]);
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]);
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")));
101 reply(getTextBot(), user, "\002AutoInvite \002%s", get_language_string(user, "NS_USET_NO_ACCESS"));
102 } else if(!stricmp(argv[0], "noautoop")) {
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]);
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]);
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")) {
120 infoline = merge_argv(argv, 1, argc);
121 if(!strcmp(infoline, "*"))
123 printf_mysql_query("UPDATE `chanusers` SET `chanuser_infoline` = '%s' WHERE `chanuser_id` = '%s'", escape_string(infoline), row[4]);
126 reply(getTextBot(), user, "\002Info \002%s", infoline);
129 reply(getTextBot(), user, "NS_NOT_ON_USERLIST_YOU", chan);
131 reply(getTextBot(), user, "NS_USET_UNKNOWN_SETTING", argv[0]);
134 reply(getTextBot(), user, "NS_USET_GLOBAL");
135 reply(getTextBot(), user, "\002Language \002%s", user->language->langname);
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));
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));
146 row = mysql_fetch_row(res);
148 int flags = atoi(row[0]);
150 if(!row[3] && atoi(row[2]) >= atoi(getChanDefault("channel_getinvite")))
152 else if(row[3] && atoi(row[2]) >= atoi(row[3]))
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")));
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]);