Feature for the next new version?
Printed From: LogSat Software
Category: Spam Filter ISP
Forum Name: Spam Filter ISP Support
Forum Description: General support for Spam Filter ISP
URL: https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=1912
Printed Date: 23 February 2025 at 12:16am
Topic: Feature for the next new version?
Posted By: Guests
Subject: Feature for the next new version?
Date Posted: 08 September 2003 at 2:30pm
|
Hi Roberto,
In an upcoming version of SFISP can you add a filter for the reply-to field so that
emails can be blacklisted by the this field. I have notice that a lot of emails have
common key words in the reply-to field.
Thanks
- Steve.
PS, I am running version 1.2.0.201 on 2k sp 4, Mdac 2.7sp1, mysql odbc driver 3.5 and the memory usage seams to be stable.
|
Replies:
Posted By: LogSat
Date Posted: 09 September 2003 at 5:50pm
|
Steve,
Thanks for the request. We can add it to the list of fields currently being checked by the existing keywords filter. That should be simple enough that we can probably include it in the next build to be released within a few days.
Roberto F.
LogSat Software
|
Posted By: Guests
Date Posted: 09 September 2003 at 5:56pm
|
Thanks Roberto.
Instead of the keyword filter could you add it to the from-email filter?
Thanks again.
|
Posted By: LogSat
Date Posted: 09 September 2003 at 6:38pm
|
Unfortunately that is not as simple as it seems. The "mail from" is checked as soon as the remote server sends the MAIL FROM command, before any data is sent. The "Reply-To" header is sent with the data, so the "mail from" filter does not know about the "Reply-to" header yet.
Changing the inner workings of this behavior is not something we want to undertake at the moment, so for now the most we can do is to have the regular keyword filter scan for that header.
Roberto
|
Posted By: Guests
Date Posted: 10 September 2003 at 9:50am
|
Okay, I did not know it was that complicated of a change.
I will be watching for the next build.
Thanks
|
Posted By: Guests
Date Posted: 11 September 2003 at 9:49am
|
How about an option to sort quarantined email by domain (after the @)
|
Posted By: Guests
Date Posted: 11 September 2003 at 11:07pm
|
This is stuff that can be done through the web using a little asp code to make the queries. If SpamFilter keeps getting bigger due to all of the wish list items it is going to get more system intensive and the price for it is going to have go up due to the cost of addtional programming and development.
If I were to make a wish list add on it would be that all of the admin GUI be through the web. This would get around the issue of either having to use terminal services or some other third party remote access program. Since a good part of the program is using web/database already it wouldn't be too far off to go all the way and just make the service with out the gui or make it work both ways. Many of the current server applications for ISP's have web interfaces. Going with a web GUI will be a step in the right direction towards a multi-platform SpamFilter.
Just my two and a half cents worth.
g
|
Posted By: Desperado
Date Posted: 12 September 2003 at 12:55am
|
Daniel,
I tend to agree with George below. As to sorting, all that can be done in the ASP code. In you "ListSpam.asp" file, You can expand the sort options to any extent you want ...
Example:
Select Case order_By
Case "EmailTo"
order_By = "EmailTo, MsgDate, Subject, EmailFrom, RejectDetails"
Case "Subject"
order_By = "Subject, MsgDate, EmailFrom, EmailTo, RejectDetails"
Case "EmailFrom"
order_By = "EmailFrom, MsgDate, EmailTo, Subject, RejectDetails"
Case "Domain"
order_By = "Domain, MsgDate, EmailTo, Subject, RejectDetails"
Case "MsgDate"
order_By = "MsgDate, EmailFrom, Subject, EmailTo, RejectDetails"
Case "RejectDetails"
order_By = "RejectDetails, MsgDate, EmailFrom, Subject, EmailTo"
Case "DESC-MsgDate"
order_By = "MsgDate DESC, EmailFrom, Subject, EmailTo, RejectDetails"
End Select
Then, one query may look like the following ... NOTE the first line ... it sorts like you asked about:
If (Field = "tofield") Then
SQL = "SELECT SUBSTRING(EmailFrom, CHARINDEX( mailto:'@'" CLASS="ASPForums" TITLE="WARNING: URL created by poster. - '@' , EmailFrom) + 1, 100) AS Domain, QuarID, EmailFrom, Subject, MsgDate, MsgID, RejectDesc, RejectDetails, EmailTo "
SQL = SQL & "FROM tblQuarantine, tblRejectCodes "
SQL = SQL & "WHERE EmailTo LIKE '%" + Replace(SearchQuery, "'", "''") + "%' "
SQL = SQL & "AND (Deliver <> 1) "
SQL = SQL & "AND (Expire <> 1) "
SQL = SQL & "AND (tblQuarantine.RejectID = tblRejectCodes.RejectID) "
If SearchSpan = 1 Then
SQL = SQL & "AND (MsgDate >= DATEADD(hour,-1,getdate())) "
End If
If SearchSpan = 4 Then
SQL = SQL & "AND (MsgDate >= DATEADD(hour,-4,getdate())) "
End If
If SearchSpan = 8 Then
SQL = SQL & "AND (MsgDate >= DATEADD(hour,-8,getdate())) "
End If
If SearchSpan = 24 Then
SQL = SQL & "AND (MsgDate >= DATEADD(hour,-24,getdate())) "
End If
SQL = SQL & "ORDER BY " & order_By
Set rs = con.Execute(SQL)
RecordCount = rs.RecordCount
End If
I have a lot more going on so this will not work directly in you code but you can get the idea.
Dan S.
|
Posted By: Guests
Date Posted: 02 October 2003 at 9:26pm
|
Hi Robert,
Did you and your team get a chance to include my request.
Thanks
|
Posted By: LogSat
Date Posted: 03 October 2003 at 12:30am
|
Steve,
That feature has been added to the new 2.0 version that will hopefully be released in a month or two. It's not yet available in the 1.2.x builds.
Roberto F.
LogSat Software
|
Posted By: Guests
Date Posted: 03 October 2003 at 10:01am
|