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);