X-Git-Url: http://git.pk910.de/?a=blobdiff_plain;f=src%2Fevent_neonspam_chanmsg.c;h=163315db30fd03e13c096403d1b3fab85faa9b29;hb=f90d21daf31f8d69e24406678be696afa8cae962;hp=117d5ad85c96130175b1774731f71bcc20439501;hpb=bb5692b9cbff069abbf9573c81e86c3cd2061ceb;p=NeonServV5.git

diff --git a/src/event_neonspam_chanmsg.c b/src/event_neonspam_chanmsg.c
index 117d5ad..163315d 100644
--- a/src/event_neonspam_chanmsg.c
+++ b/src/event_neonspam_chanmsg.c
@@ -162,7 +162,7 @@ static USERAUTH_CALLBACK(neonspam_event_chanmsg_nick_lookup) {
 
 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)
@@ -175,53 +175,53 @@ static void neonspam_event_chanmsg_punish(struct ClientSocket *client, struct Ch
         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);
@@ -243,7 +243,7 @@ static void neonspam_event_chanmsg_punish(struct ClientSocket *client, struct Ch
                 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);