execute mysql_check only if a query fails.
[NeonServV5.git] / cmd_neonserv_set.c
1
2 typedef char* neonserv_cmd_set_function(struct ClientSocket *client, struct UserNode *user, struct ChanNode *chan, const char *setting, char *argument);
3 static void neonserv_cmd_set_setting(struct ClientSocket *client, struct UserNode *user, struct ChanNode *chan, int setting, char *argument);
4 static char* neonserv_cmd_set_trigger(struct ClientSocket *client, struct UserNode *user, struct ChanNode *chan, const char *setting, char *argument);
5 static char* neonserv_cmd_set_modes(struct ClientSocket *client, struct UserNode *user, struct ChanNode *chan, const char *setting, char *argument);
6 static char* neonserv_cmd_set_dynlimit(struct ClientSocket *client, struct UserNode *user, struct ChanNode *chan, const char *setting, char *argument);
7 static char* neonserv_cmd_set_nodelete(struct ClientSocket *client, struct UserNode *user, struct ChanNode *chan, const char *setting, char *argument);
8
9 #define NS_VALID_FUNCTION 0x01
10 #define NS_VALID_STRING   0x02
11 #define NS_VALID_ACCESS   0x04
12 #define NS_VALID_NO501    0x08
13 #define NS_VALID_OPTIONS  0x10
14 #define NS_VALID_NUMERIC  0x20
15 #define NS_VALID_BOOLEAN  0x40
16
17 #define NS_HAS_OPT  0x100 /* options (SET_OPTION_{NAME}_{VALUE}) */
18 #define NS_HAS_HELP 0x200 /* help    (SET_HELP_{NAME}) - only shown if help is requested */
19
20 static const struct {
21     const char *setting;
22     const char *chanfield;
23     unsigned int valid;
24     void *parameter;
25 } channel_settings[] = {
26     {"TRIGGER",         NULL,                   NS_VALID_FUNCTION,                  neonserv_cmd_set_trigger},
27     {"DEFAULTTOPIC",    "channel_defaulttopic", NS_VALID_STRING,                    NULL},
28     {"TOPICMASK",       "channel_topicmask",    NS_VALID_STRING,                    NULL},
29     {"ADVANCEDTOPIC",   "channel_exttopic",     NS_VALID_BOOLEAN | NS_HAS_OPT,      NULL},
30     {"GREETING",        "channel_greeting",     NS_VALID_STRING,                    NULL},
31     {"USERGREETING",    "channel_usergreeting", NS_VALID_STRING,                    NULL},
32     {"USERINFO",        "channel_userinfo",     NS_VALID_ACCESS,                    NULL},
33     {"WIPEINFO",        "channel_wipeinfo",     NS_VALID_ACCESS,                    NULL},
34     {"MODES",           "channel_modes",        NS_VALID_FUNCTION,                  neonserv_cmd_set_modes},
35     {"INVITEME",        "channel_getinvite",    NS_VALID_ACCESS,                    NULL},
36     {"GIVEOPS",         "channel_getop",        NS_VALID_ACCESS,                    NULL},
37     {"GIVEVOICE",       "channel_getvoice",     NS_VALID_ACCESS,                    NULL},
38     {"ENFOPS",          "channel_canop",        NS_VALID_ACCESS,                    NULL},
39     {"ENFVOICE",        "channel_canvoice",     NS_VALID_ACCESS,                    NULL},
40     {"KICK",            "channel_cankick",      NS_VALID_ACCESS,                    NULL},
41     {"BAN",             "channel_canban",       NS_VALID_ACCESS,                    NULL},
42     {"STATICBAN",       "channel_staticban",    NS_VALID_ACCESS,                    NULL},
43     {"PUBCMD",          "channel_pubcmd",       NS_VALID_ACCESS,                    NULL},
44     {"ENFMODES",        "channel_enfmodes",     NS_VALID_ACCESS,                    NULL},
45     {"ENFTOPIC",        "channel_enftopic",     NS_VALID_ACCESS,                    NULL},
46     {"TOPICSNARF",      "channel_topicsnarf",   NS_VALID_ACCESS,                    NULL},
47     {"CHANGETOPIC",     "channel_changetopic",  NS_VALID_ACCESS,                    NULL},
48     {"SETTERS",         "channel_setters",      NS_VALID_ACCESS | NS_VALID_NO501,   NULL},
49     {"ADDUSER",         "channel_canadd",       NS_VALID_ACCESS,                    NULL},
50     {"DELUSER",         "channel_candel",       NS_VALID_ACCESS,                    NULL},
51     {"CLVL",            "channel_canclvl",      NS_VALID_ACCESS,                    NULL},
52     {"RESYNC",          "channel_canresync",    NS_VALID_ACCESS,                    NULL},
53     {"SUSPEND",         "channel_cansuspend",   NS_VALID_ACCESS,                    NULL},
54     {"NOTICEUSERS",     "channel_notice",       NS_VALID_ACCESS,                    NULL},
55     {"NOTICEREACTION",  "channel_noticereaction", NS_VALID_OPTIONS | NS_HAS_OPT,    "4"},
56     {"CTCPUSERS",       "channel_ctcp",         NS_VALID_ACCESS,                    NULL},
57     {"CTCPREACTION",    "channel_ctcpreaction", NS_VALID_OPTIONS | NS_HAS_OPT,      "4"},
58     {"PROTECT",         "channel_protect",      NS_VALID_OPTIONS | NS_HAS_OPT,      "4"},
59     {"TOYS",            "channel_toys",         NS_VALID_OPTIONS | NS_HAS_OPT,      "3"},
60     {"DYNLIMIT",        "channel_dynlimit",     NS_VALID_NUMERIC | NS_VALID_FUNCTION | NS_HAS_OPT, neonserv_cmd_set_dynlimit},
61     {"NODELETE",        "channel_nodelete",     NS_VALID_BOOLEAN | NS_VALID_FUNCTION, neonserv_cmd_set_nodelete},
62     {NULL, NULL, 0, NULL}
63 };
64
65 #define MAX_QUERY_LEN 1024
66 static CMD_BIND(neonserv_cmd_set) {
67     int i, j;
68     if(argc && !strcmp(argv[0], "defaults")) {
69         //reset channel settings
70         int uaccess = getChannelAccess(user, chan, 1);
71         if(uaccess < 500) {
72             reply(getTextBot(), user, "NS_SET_DEFAULTS_OWNER", chan->name);
73             return;
74         }
75         int seed = 0;
76         char *tmp;
77         static char defaultskey[16];
78         for(tmp = user->auth; *tmp; tmp++)
79             seed = (seed * 0xEECE66DL ^ ((*tmp << 24) | (*tmp << 16) | (*tmp << 8) | *tmp));
80         for(tmp = chan->name; *tmp; tmp++)
81             seed = (seed * 0xEECE66DL ^ ((*tmp << 24) | (*tmp << 16) | (*tmp << 8) | *tmp));
82         sprintf(defaultskey, "%08x", seed);
83         if(argc > 1 && !strcmp(argv[1], defaultskey)) {
84             char query[MAX_QUERY_LEN];
85             int querypos = 0;
86             i = 0;
87             while(channel_settings[i].setting) {
88                 if(channel_settings[i].chanfield)
89                     querypos += sprintf(query + querypos, "`%s` = NULL, ", channel_settings[i].chanfield);
90                 i++;
91             }
92             if(querypos) {
93                 query[querypos-2] = '\0';
94             }
95             printf_mysql_query("UPDATE `channels` SET %s WHERE `channel_id` = '%d'", query, chan->channel_id);
96             reply(getTextBot(), user, "NS_SET_DEFAULTS_DONE", chan->name);
97         } else {
98             reply(getTextBot(), user, "NS_SET_DEFAULTS_CODE", chan->name, defaultskey);
99         }
100     } else if(argc && strcmp(argv[0], "help")) {
101         //find the correct command
102         i = 0;
103         j = 0;
104         char *args = (argc > 1 ? merge_argv(argv, 1, argc) : NULL);
105         while(channel_settings[i].setting) {
106             if(!stricmp(channel_settings[i].setting, argv[0])) {
107                 //setting found
108                 if(channel_settings[i].valid & NS_VALID_FUNCTION) {
109                     neonserv_cmd_set_function *func = channel_settings[i].parameter;
110                     func(client, user, chan, channel_settings[i].setting, args);
111                 } else {
112                     neonserv_cmd_set_setting(client, user, chan, i, args);
113                 }
114                 j = 1;
115                 break;
116             }
117             i++;
118         }
119         if(j == 0) {
120             //unknown setting
121             reply(getTextBot(), user, "NS_SET_UNKNOWN_SETTING", argv[0]);
122         }
123     } else {
124         char query[MAX_QUERY_LEN], *value, *org_value, *tmp, nameBuf[64];
125         int querypos = 0;
126         MYSQL_RES *res, *defaults_res;
127         MYSQL_ROW row, defaults;
128         struct Table *table;
129         char *content[2];
130         i = 0;
131         while(channel_settings[i].setting) {
132             if(channel_settings[i].chanfield)
133                 querypos += sprintf(query + querypos, ", `%s`", channel_settings[i].chanfield);
134             i++;
135         }
136         table = table_init(2, i, 0);
137         table_set_bold(table, 0, 1);
138         printf_mysql_query("SELECT `channel_id` %s FROM `channels` WHERE `channel_name` = 'defaults'", query);
139         defaults_res = mysql_use();
140         defaults = mysql_fetch_row(defaults_res);
141         printf_mysql_query("SELECT `channel_name` %s FROM `channels` WHERE `channel_id` = '%d'", query, chan->channel_id);
142         res = mysql_use();
143         row = mysql_fetch_row(res);
144         i = 0;
145         j = 0;
146         reply(getTextBot(), user, "NS_SET_HEADER", chan->name);
147         while(channel_settings[i].setting) {
148             if(channel_settings[i].chanfield) {
149                 j++;
150                 org_value = (row[j] ? row[j] : defaults[j]);
151             } else if(channel_settings[i].valid & NS_VALID_FUNCTION) {
152                 neonserv_cmd_set_function *func = channel_settings[i].parameter;
153                 org_value = func(client, user, chan, NULL, NULL);
154             } else
155                 org_value = "0";
156             value = org_value;
157             if(channel_settings[i].valid & NS_VALID_BOOLEAN) {
158                 if(!strcmp(value, "0"))
159                     value = get_language_string(user, "NS_SET_OFF");
160                 else
161                     value = get_language_string(user, "NS_SET_ON");
162             }
163             strcpy(query, value);
164             querypos = strlen(query);
165             if(channel_settings[i].valid & NS_HAS_OPT) {
166                 sprintf(nameBuf, "NS_SET_OPTION_%s_%s", channel_settings[i].setting, org_value);
167                 tmp = get_language_string(user, nameBuf);
168                 if(tmp) {
169                     querypos += sprintf(query+querypos, " - %s", tmp);
170                 }
171             }
172             if(argc && channel_settings[i].valid & NS_HAS_HELP) {
173                 sprintf(nameBuf, "NS_SET_HELP_%s", channel_settings[i].setting);
174                 tmp = get_language_string(user, nameBuf);
175                 if(tmp) {
176                     querypos += sprintf(query+querypos, " - %s", tmp);
177                 }
178             }
179             content[0] = (char*)channel_settings[i].setting;
180             content[1] = query;
181             table_add(table, content);
182             i++;
183         }
184         char **table_lines = table_end(table);
185         for(i = 0; i < table->entrys; i++) {
186             reply(getTextBot(), user, table_lines[i]);
187         }
188         table_free(table);
189     }
190 }
191
192 static void neonserv_cmd_set_setting(struct ClientSocket *client, struct UserNode *user, struct ChanNode *chan, int setting, char *args) {
193     char *value;
194     char nameBuf[64];
195     //get current value
196     MYSQL_RES *res;
197     MYSQL_ROW row;
198     printf_mysql_query("SELECT `%s` FROM `channels` WHERE `channel_id` = '%d'", channel_settings[setting].chanfield, chan->channel_id);
199     res = mysql_use();
200     row = mysql_fetch_row(res);
201     if(row[0] == NULL) {
202         printf_mysql_query("SELECT `%s` FROM `channels` WHERE `channel_name` = 'defaults'", channel_settings[setting].chanfield);
203         res = mysql_use();
204         row = mysql_fetch_row(res);
205     }
206     value = row[0];
207     if(args) {
208         //change the channel setting
209         //check the new argument
210         int valid = channel_settings[setting].valid;
211         if(valid & NS_VALID_STRING) {
212             if(!strcmp(args, "*")) {
213                 args = "";
214             }
215         }
216         if(valid & NS_VALID_ACCESS) {
217             int caccess = atoi(args);
218             int max = ((valid & NS_VALID_NO501) ? 500 : 501);
219             if(caccess < 0 || caccess > max) {
220                 reply(getTextBot(), user, "NS_INVALID_ACCESS", caccess);
221                 return;
222             }
223             int uaccess = getChannelAccess(user, chan, 1);
224             if(uaccess == 500) uaccess++;
225             if(atoi(value) > uaccess) {
226                 reply(getTextBot(), user, "NS_SET_CANNOT_SET");
227                 return;
228             }
229             if(caccess > uaccess) {
230                 reply(getTextBot(), user, "NS_SET_BADLEVEL");
231                 return;
232             }
233             sprintf(nameBuf, "%d", caccess);
234             args = nameBuf;
235         }
236         if(valid & NS_VALID_OPTIONS) {
237             int options = atoi((char *) channel_settings[setting].parameter);
238             int coption = atoi(args);
239             if(coption < 0 || coption >= options) {
240                 reply(getTextBot(), user, "NS_SET_INVALID_OPTION", args);
241                 int i;
242                 int nameBufPos = 0;
243                 if(valid & NS_HAS_OPT) {
244                     for(i = 0; i < options; i++) {
245                         sprintf(nameBuf, "NS_SET_OPTION_%s_%d", channel_settings[setting].setting, i);
246                         reply(getTextBot(), user, "\002%d\002 - %s", i, get_language_string(user, nameBuf));
247                     }
248                 } else {
249                     for(i = 0; i < options; i++) {
250                         nameBufPos += sprintf(nameBuf + nameBufPos, "\002%d\002, ", i);
251                     }
252                     if(nameBufPos) {
253                         nameBuf[nameBufPos-2] = '\0';
254                         reply(getTextBot(), user, nameBuf);
255                     }
256                 }
257                 return;
258             }
259         }
260         if(valid & NS_VALID_NUMERIC) {
261             sprintf(nameBuf, "%d", atoi(args));
262             args = nameBuf;
263         }
264         if(valid & NS_VALID_BOOLEAN) {
265             if(!strcmp(args, "0") || !stricmp(args, "off") || !stricmp(args, get_language_string(user, "NS_SET_OFF"))) {
266                 args = "0";
267             } else if(!strcmp(args, "1") || !stricmp(args, "on") || !stricmp(args, get_language_string(user, "NS_SET_ON"))) {
268                 args = "1";
269             } else {
270                 reply(getTextBot(), user, "NS_SET_INVALID_BOOLEAN", args);
271                 return;
272             }
273         }
274         //valid - set it
275         value = args;
276         printf_mysql_query("UPDATE `channels` SET `%s` = '%s' WHERE `channel_id` = '%d'", channel_settings[setting].chanfield, escape_string(value), chan->channel_id);
277     }
278     reply(getTextBot(), user, "\002%s\002 %s", channel_settings[setting].setting, value);
279     if(channel_settings[setting].valid & NS_HAS_HELP) {
280          sprintf(nameBuf, "NS_SET_HELP_%s", channel_settings[setting].setting);
281          reply(getTextBot(), user, "  %s", get_language_string(user, nameBuf));
282     }
283 }
284
285 static char* neonserv_cmd_set_trigger(struct ClientSocket *client, struct UserNode *user, struct ChanNode *chan, const char *setting, char *argument) {
286     char *trigger;
287     //get current trigger
288     MYSQL_RES *res;
289     MYSQL_ROW row;
290     printf_mysql_query("SELECT `trigger` FROM `bot_channels` WHERE `chanid` = '%d' AND `botid` = '%d'", chan->channel_id, client->clientid);
291     res = mysql_use();
292     row = mysql_fetch_row(res);
293     trigger = row[0];
294     if(argument) {
295         int uaccess = getChannelAccess(user, chan, 1);
296         if(uaccess < 500) {
297             reply(getTextBot(), user, "NS_SET_TRIGGER_OWNER", chan->name);
298             return NULL;
299         }
300         if(strlen(argument) > 15)
301             argument[15] = '\0';
302         printf_mysql_query("UPDATE `bot_channels` SET `trigger` = '%s' WHERE `chanid` = '%d' AND `botid` = '%d'", escape_string(argument), chan->channel_id, client->clientid);
303         trigger = argument;
304         changeChannelTrigger(client->botid, chan, trigger);
305     }
306     if(setting) {
307         reply(getTextBot(), user, "\002%s\002 %s", setting, trigger);
308     }
309     return trigger;
310 }
311
312 static char* neonserv_cmd_set_modes(struct ClientSocket *client, struct UserNode *user, struct ChanNode *chan, const char *setting, char *argument) {
313     char *value;
314     //get current value
315     MYSQL_RES *res;
316     MYSQL_ROW row;
317     printf_mysql_query("SELECT `channel_modes` FROM `channels` WHERE `channel_id` = '%d'", chan->channel_id);
318     res = mysql_use();
319     row = mysql_fetch_row(res);
320     if(row[0] == NULL) {
321         printf_mysql_query("SELECT `channel_modes` FROM `channels` WHERE `channel_name` = 'defaults'");
322         res = mysql_use();
323         row = mysql_fetch_row(res);
324     }
325     value = row[0];
326     if(argument) {
327         //change the channel setting
328         //TODO: parse, check and set modelock
329     }
330     if(setting) {
331         reply(getTextBot(), user, "\002%s\002 %s", setting, value);
332     }
333     return value;
334 }
335
336 static char* neonserv_cmd_set_dynlimit(struct ClientSocket *client, struct UserNode *user, struct ChanNode *chan, const char *setting, char *argument) {
337     char *value;
338     char tmp[64];
339     //get current value
340     MYSQL_RES *res;
341     MYSQL_ROW row;
342     printf_mysql_query("SELECT `channel_dynlimit` FROM `channels` WHERE `channel_id` = '%d'", chan->channel_id);
343     res = mysql_use();
344     row = mysql_fetch_row(res);
345     if(row[0] == NULL) {
346         printf_mysql_query("SELECT `channel_dynlimit` FROM `channels` WHERE `channel_name` = 'defaults'");
347         res = mysql_use();
348         row = mysql_fetch_row(res);
349     }
350     value = row[0];
351     if(argument) {
352         //change the channel setting
353         sprintf(tmp, "%d", atoi(argument));
354         argument = tmp;
355         printf_mysql_query("UPDATE `channels` SET `channel_dynlimit` = '%s' WHERE `channel_id` = '%d'", escape_string(argument), chan->channel_id);
356         if(strcmp(argument, "0"))
357             putsock(client, "MODE %s +l %d", chan->name, (chan->usercount + atoi(argument)));
358         else if(isModeSet(chan, 'l'))
359             putsock(client, "MODE %s -l", chan->name);
360     }
361     if(setting) {
362         reply(getTextBot(), user, "\002%s\002 %s", setting, value);
363     }
364     return value;
365 }
366
367 static char* neonserv_cmd_set_nodelete(struct ClientSocket *client, struct UserNode *user, struct ChanNode *chan, const char *setting, char *argument) {
368     char *value;
369     //get current value
370     MYSQL_RES *res;
371     MYSQL_ROW row;
372     printf_mysql_query("SELECT `channel_nodelete` FROM `channels` WHERE `channel_id` = '%d'", chan->channel_id);
373     res = mysql_use();
374     row = mysql_fetch_row(res);
375     if(row[0] == NULL) {
376         printf_mysql_query("SELECT `channel_nodelete` FROM `channels` WHERE `channel_name` = 'defaults'");
377         res = mysql_use();
378         row = mysql_fetch_row(res);
379     }
380     value = row[0];
381     if(argument && isGodMode(user)) {
382         //change the channel setting
383         if(!strcmp(argument, "0") || !strcmp(argument, "off") || !strcmp(argument, get_language_string(user, "NS_SET_OFF"))) {
384             argument = "0";
385         } else if(!strcmp(argument, "0") || !strcmp(argument, "off") || !strcmp(argument, get_language_string(user, "NS_SET_OFF"))) {
386             argument = "1";
387         } else {
388             reply(getTextBot(), user, "NS_SET_INVALID_BOOLEAN", argument);
389             return NULL;
390         }
391         printf_mysql_query("UPDATE `channels` SET `channel_nodelete` = '%s' WHERE `channel_id` = '%d'", escape_string(argument), chan->channel_id);
392     }
393     if(setting) {
394         reply(getTextBot(), user, "\002%s\002 %s", setting, value);
395     }
396     return value;
397 }
398
399 #undef MAX_QUERY_LEN