static void neonspam_event_chanmsg_punish(struct ClientSocket *client, struct ChanUser *chanuser, struct NeonSpamSettings *settings, unsigned int warn, unsigned int punish) {
MYSQL_RES *res;
- MYSQL_ROW row;
+ MYSQL_ROW row, defaults;
loadChannelSettings(chanuser->chan);
int uaccess = 0;
if(chanuser->user->flags & USERFLAG_ISAUTHED)
printf_mysql_query("SELECT `channel_spam_reaction`, `channel_spam_reaction_duration` FROM `channels` WHERE `channel_id` = '%d'", chanuser->chan->channel_id);
res = mysql_use();
row = mysql_fetch_row(res);
- if(!row[0]) {
+ if(!row[0] || !row[1]) {
printf_mysql_query("SELECT `channel_spam_reaction`, `channel_spam_reaction_duration` FROM `channels` WHERE `channel_name` = 'defaults'");
res = mysql_use();
- row = mysql_fetch_row(res);
+ defaults = mysql_fetch_row(res);
}
sprintf(reason, SPAMSERV_MSG_WARNING, SPAMSERV_MSG_SPAM);
- punishment = atoi(row[0]) + 1;
- punish_time = atoi(row[1]);
+ punishment = atoi((row[0] ? row[0] : defaults[0])) + 1;
+ punish_time = atoi((row[1] ? row[1] : defaults[1]));
}
if(!punishment && (punish & SPAMSETTINGS_FLOODSCAN) && settings->exceptlevel[SPAMSETTINGS_FLOODEXCINDEX] > uaccess) {
printf_mysql_query("SELECT `channel_flood_reaction`, `channel_flood_reaction_duration` FROM `channels` WHERE `channel_id` = '%d'", chanuser->chan->channel_id);
res = mysql_use();
row = mysql_fetch_row(res);
- if(!row[0]) {
+ if(!row[0] || !row[1]) {
printf_mysql_query("SELECT `channel_flood_reaction`, `channel_flood_reaction_duration` FROM `channels` WHERE `channel_name` = 'defaults'");
res = mysql_use();
- row = mysql_fetch_row(res);
+ defaults = mysql_fetch_row(res);
}
sprintf(reason, SPAMSERV_MSG_WARNING, SPAMSERV_MSG_FLOOD);
- punishment = atoi(row[0]) + 1;
- punish_time = atoi(row[1]);
+ punishment = atoi((row[0] ? row[0] : defaults[0])) + 1;
+ punish_time = atoi((row[1] ? row[1] : defaults[1]));
}
if(!punishment && (punish & SPAMSETTINGS_CAPSSCAN) && settings->exceptlevel[SPAMSETTINGS_CAPSEXCINDEX] > uaccess) {
printf_mysql_query("SELECT `channel_caps_reaction`, `channel_caps_reaction_duration` FROM `channels` WHERE `channel_id` = '%d'", chanuser->chan->channel_id);
res = mysql_use();
row = mysql_fetch_row(res);
- if(!row[0]) {
+ if(!row[0] || !row[1]) {
printf_mysql_query("SELECT `channel_caps_reaction`, `channel_caps_reaction_duration` FROM `channels` WHERE `channel_name` = 'defaults'");
res = mysql_use();
- row = mysql_fetch_row(res);
+ defaults = mysql_fetch_row(res);
}
sprintf(reason, SPAMSERV_MSG_WARNING, SPAMSERV_MSG_CAPS);
- punishment = atoi(row[0]) + 1;
- punish_time = atoi(row[1]);
+ punishment = atoi((row[0] ? row[0] : defaults[0])) + 1;
+ punish_time = atoi((row[1] ? row[1] : defaults[1]));
}
if(!punishment && (punish & SPAMSETTINGS_DIGITSCAN) && settings->exceptlevel[SPAMSETTINGS_DIGITEXCINDEX] > uaccess) {
printf_mysql_query("SELECT `channel_digit_reaction`, `channel_digit_reaction_duration` FROM `channels` WHERE `channel_id` = '%d'", chanuser->chan->channel_id);
res = mysql_use();
row = mysql_fetch_row(res);
- if(!row[0]) {
+ if(!row[0] || !row[1]) {
printf_mysql_query("SELECT `channel_digit_reaction`, `channel_digit_reaction_duration` FROM `channels` WHERE `channel_name` = 'defaults'");
res = mysql_use();
- row = mysql_fetch_row(res);
+ defaults = mysql_fetch_row(res);
}
sprintf(reason, SPAMSERV_MSG_WARNING, SPAMSERV_MSG_DIGIT);
- punishment = atoi(row[0]) + 1;
- punish_time = atoi(row[1]);
+ punishment = atoi((row[0] ? row[0] : defaults[0])) + 1;
+ punish_time = atoi((row[1] ? row[1] : defaults[1]));
}
if(!punishment && (warn & SPAMSETTINGS_SPAMSCAN) && settings->exceptlevel[SPAMSETTINGS_SPAMEXCINDEX] > uaccess) {
sprintf(reason, SPAMSERV_MSG_WARNING, SPAMSERV_MSG_SPAM);
banmask = generate_banmask(chanuser->user, banmaskBuf);
printf_mysql_query("INSERT INTO `bans` (`ban_channel`, `ban_mask`, `ban_triggered`, `ban_timeout`, `ban_owner`, `ban_reason`) VALUES ('%d', '%s', UNIX_TIMESTAMP(), '%lu', '%d', '%s')", chanuser->chan->channel_id, escape_string(banmask), (unsigned long) (punish_time ? (time(0) + punish_time) : 0), 0, escape_string(reason));
if(punish_time) {
- int banid = (int) mysql_insert_id(mysql_conn);
+ int banid = (int) mysql_insert_id(get_mysql_conn());
char nameBuf[MAXLEN];
char banidBuf[20];
sprintf(nameBuf, "ban_%d", banid);