+++ /dev/null
-/* cmd_neonserv_uset.c - NeonServ v5.3
- * Copyright (C) 2011-2012 Philipp Kreil (pk910)
- *
- * This program is free software: you can redistribute it and/or modify
- * it under the terms of the GNU General Public License as published by
- * the Free Software Foundation, either version 3 of the License, or
- * (at your option) any later version.
- *
- * This program is distributed in the hope that it will be useful,
- * but WITHOUT ANY WARRANTY; without even the implied warranty of
- * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
- * GNU General Public License for more details.
- *
- * You should have received a copy of the GNU General Public License
- * along with this program. If not, see <http://www.gnu.org/licenses/>.
- */
-
-#include "cmd_neonserv.h"
-
-CMD_BIND(neonserv_cmd_uset) {
- MYSQL_RES *res;
- MYSQL_ROW row;
- loadUserSettings(user);
- if(argc > 0) {
- if(!stricmp(argv[0], "language")) {
- struct language* lang;
- if(argc > 1) {
- if((lang = get_language_by_tag(argv[1])) == NULL && (lang = get_language_by_name(argv[1])) == NULL) {
- lang = user->language;
- } else {
- printf_mysql_query("SELECT `user_id` FROM `users` WHERE `user_user` = '%s'", escape_string(user->auth));
- res = mysql_use();
- if ((row = mysql_fetch_row(res)) != NULL) {
- printf_mysql_query("UPDATE `users` SET `user_lang` = '%s' WHERE `user_id` = '%s'", escape_string(lang->langtag), row[0]);
- } else {
- printf_mysql_query("INSERT INTO `users` (`user_user`, `user_lang`) VALUES ('%s', '%s')", escape_string(user->auth), escape_string(lang->langtag));
- }
- struct UserNode *cuser;
- for(cuser = getAllUsers(NULL); cuser; cuser = getAllUsers(cuser)) {
- if((cuser->flags & USERFLAG_ISAUTHED) && !stricmp(user->auth, cuser->auth))
- cuser->language = lang;
- }
- }
- } else
- lang = user->language;
- reply(getTextBot(), user, "\002Language \002%s", lang->langname);
- char tmp[MAXLEN];
- int tmppos = 0;
- lang = get_default_language();
- tmppos = sprintf(tmp, "%s (%s)", lang->langname, lang->langtag);
- printf_mysql_query("SELECT `lang`,`text` FROM `language` WHERE `ident` = 'name'");
- res = mysql_use();
- while((row = mysql_fetch_row(res)) != NULL) {
- tmppos += sprintf(tmp + tmppos, ", %s (%s)", row[1], row[0]);
- }
- reply(getTextBot(), user, " %s", tmp);
- } else if(!stricmp(argv[0], "noinvite") && chan) {
- loadChannelSettings(chan);
- if(!(chan->flags & CHANFLAG_CHAN_REGISTERED)) {
- reply(getTextBot(), user, "MODCMD_CHAN_REQUIRED");
- return;
- }
- 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));
- res = mysql_use();
- row = mysql_fetch_row(res);
- int noinvite = (row ? 1 : 0);
- if(argc > 1) {
- if(!strcmp(argv[1], "0") || !stricmp(argv[1], "off") || !stricmp(argv[1], get_language_string(user, "NS_SET_OFF"))) {
- if(noinvite) {
- printf_mysql_query("DELETE FROM `noinvite` WHERE `id` = '%s'", row[0]);
- noinvite = 0;
- }
- } else if(!strcmp(argv[1], "1") || !stricmp(argv[1], "on") || !stricmp(argv[1], get_language_string(user, "NS_SET_ON"))) {
- if(!noinvite) {
- int userid;
- printf_mysql_query("SELECT `user_id` FROM `users` WHERE `user_user` = '%s'", escape_string(user->auth));
- res = mysql_use();
- if ((row = mysql_fetch_row(res)) != NULL) {
- userid = atoi(row[0]);
- } else {
- printf_mysql_query("INSERT INTO `users` (`user_user`) VALUES ('%s')", escape_string(user->auth));
- userid = (int) mysql_insert_id(get_mysql_conn());
- }
- printf_mysql_query("INSERT INTO `noinvite` (`uid`, `cid`) VALUES ('%d', '%d')", userid, chan->channel_id);
- noinvite = 1;
- }
- }
- }
- reply(getTextBot(), user, "\002NoInvite \002%s", (noinvite ? get_language_string(user, "NS_SET_ON") : get_language_string(user, "NS_SET_OFF")));
- } else if((!stricmp(argv[0], "autoinvite") || !stricmp(argv[0], "noautoop") || !stricmp(argv[0], "info")) && chan) {
- loadChannelSettings(chan);
- if(!(chan->flags & CHANFLAG_CHAN_REGISTERED)) {
- reply(getTextBot(), user, "MODCMD_CHAN_REQUIRED");
- return;
- }
- 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));
- res = mysql_use();
- row = mysql_fetch_row(res);
- if(row) {
- int flags = atoi(row[0]);
- if(!stricmp(argv[0], "autoinvite")) {
- int getInvite = 0;
- if(!row[3] && atoi(row[2]) >= atoi(getChanDefault("channel_getinvite")))
- getInvite = 1;
- else if(row[3] && atoi(row[2]) >= atoi(row[3]))
- getInvite = 1;
- if(getInvite && argc > 1) {
- if(!strcmp(argv[1], "0") || !stricmp(argv[1], "off") || !stricmp(argv[1], get_language_string(user, "NS_SET_OFF"))) {
- if(flags & DB_CHANUSER_AUTOINVITE) {
- flags &= ~DB_CHANUSER_AUTOINVITE;
- printf_mysql_query("UPDATE `chanusers` SET `chanuser_flags` = '%d' WHERE `chanuser_id` = '%s'", flags, row[4]);
- }
- } else if(!strcmp(argv[1], "1") || !stricmp(argv[1], "on") || !stricmp(argv[1], get_language_string(user, "NS_SET_ON"))) {
- if(!(flags & DB_CHANUSER_AUTOINVITE)) {
- flags |= DB_CHANUSER_AUTOINVITE;
- printf_mysql_query("UPDATE `chanusers` SET `chanuser_flags` = '%d' WHERE `chanuser_id` = '%s'", flags, row[4]);
- }
- }
- }
- if(getInvite)
- reply(getTextBot(), user, "\002AutoInvite \002%s", ((flags & DB_CHANUSER_AUTOINVITE) ? get_language_string(user, "NS_SET_ON") : get_language_string(user, "NS_SET_OFF")));
- else
- reply(getTextBot(), user, "\002AutoInvite \002%s", get_language_string(user, "NS_USET_NO_ACCESS"));
- } else if(!stricmp(argv[0], "noautoop")) {
- if(argc > 1) {
- if(!strcmp(argv[1], "0") || !stricmp(argv[1], "off") || !stricmp(argv[1], get_language_string(user, "NS_SET_OFF"))) {
- if(flags & DB_CHANUSER_NOAUTOOP) {
- flags &= ~DB_CHANUSER_NOAUTOOP;
- printf_mysql_query("UPDATE `chanusers` SET `chanuser_flags` = '%d' WHERE `chanuser_id` = '%s'", flags, row[4]);
- }
- } else if(!strcmp(argv[1], "1") || !stricmp(argv[1], "on") || !stricmp(argv[1], get_language_string(user, "NS_SET_ON"))) {
- if(!(flags & DB_CHANUSER_NOAUTOOP)) {
- flags |= DB_CHANUSER_NOAUTOOP;
- printf_mysql_query("UPDATE `chanusers` SET `chanuser_flags` = '%d' WHERE `chanuser_id` = '%s'", flags, row[4]);
- }
- }
- }
- reply(getTextBot(), user, "\002NoAutoOp \002%s", ((flags & DB_CHANUSER_NOAUTOOP) ? get_language_string(user, "NS_SET_ON") : get_language_string(user, "NS_SET_OFF")));
- } else if(!stricmp(argv[0], "info")) {
- char *infoline;
- if(argc > 1) {
- infoline = merge_argv(argv, 1, argc);
- if(!strcmp(infoline, "*"))
- infoline = "";
- printf_mysql_query("UPDATE `chanusers` SET `chanuser_infoline` = '%s' WHERE `chanuser_id` = '%s'", escape_string(infoline), row[4]);
- } else
- infoline = row[1];
- reply(getTextBot(), user, "\002Info \002%s", infoline);
- }
- } else
- reply(getTextBot(), user, "NS_NOT_ON_USERLIST_YOU", chan);
- } else
- reply(getTextBot(), user, "NS_USET_UNKNOWN_SETTING", argv[0]);
- } else {
- //view all options
- reply(getTextBot(), user, "NS_USET_GLOBAL");
- reply(getTextBot(), user, "\002Language \002%s", user->language->langname);
- if(!chan) return;
- loadChannelSettings(chan);
- if(!(chan->flags & CHANFLAG_CHAN_REGISTERED)) return;
- reply(getTextBot(), user, "NS_USET_CHANNEL");
- 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));
- res = mysql_use();
- row = mysql_fetch_row(res);
- reply(getTextBot(), user, "\002NoInvite \002%s", (row ? get_language_string(user, "NS_SET_ON") : get_language_string(user, "NS_SET_OFF")));
- 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));
- res = mysql_use();
- row = mysql_fetch_row(res);
- if(row) {
- int flags = atoi(row[0]);
- int getInvite = 0;
- if(!row[3] && atoi(row[2]) >= atoi(getChanDefault("channel_getinvite")))
- getInvite = 1;
- else if(row[3] && atoi(row[2]) >= atoi(row[3]))
- getInvite = 1;
- if(getInvite)
- reply(getTextBot(), user, "\002AutoInvite \002%s", ((flags & DB_CHANUSER_AUTOINVITE) ? get_language_string(user, "NS_SET_ON") : get_language_string(user, "NS_SET_OFF")));
- else
- reply(getTextBot(), user, "\002AutoInvite \002%s", get_language_string(user, "NS_USET_NO_ACCESS"));
- reply(getTextBot(), user, "\002NoAutoOp \002%s", ((flags & DB_CHANUSER_NOAUTOOP) ? get_language_string(user, "NS_SET_ON") : get_language_string(user, "NS_SET_OFF")));
- reply(getTextBot(), user, "\002Info \002%s", row[1]);
- }
- }
-}
\ No newline at end of file