Modifications are welcome
Printed From: LogSat Software
Category: Spam Filter ISP
Forum Name: Web Interface Mods
Forum Description: Open to all users who wish to share their quarantine web interface modifications
URL: https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=5338
Printed Date: 04 November 2025 at 4:39am
Topic: Modifications are welcome
Posted By: LogSat
Subject: Modifications are welcome
Date Posted: 20 September 2005 at 6:14pm
|
Many users have greatly modified and improved SpamFilter's sample
quarantine web interface. We're providing an open forum where users can
share or make otherwise available their modifications. Please feel free to post any topics that are related to web interfaces here. ------------- Roberto Franceschetti http://www.logsat.com" rel="nofollow - LogSat Software http://www.logsat.com/sfi-spam-filter.asp" rel="nofollow - Spam Filter ISP |
Replies:
Posted By: Guests
Date Posted: 21 September 2005 at 10:08am
|
I have given the site a small face lift and added a back button to get things started. I have also fixed a small bug that affects the end user trying to change thier password on rare occasions. http://www.patriotforge.com/files/spamfilterweb.zip - http://www.patriotforge.com/files/spamfilterweb.zip Let me know if there are issues with this in this forum |
Posted By: Guests
Date Posted: 22 September 2005 at 11:15pm
|
This link is to the web pages I posted in the forum some time ago. I combined mods from several regular posters in the forum to create these. There is select all messages button, new spam notification scripts, some buttons instead of links etc. You can get them here: http://www.inetsecurity.info/downloads/spamfilterweb.zip - http://www.inetsecurity.info/downloads/spamfilterweb.zip Cheers, |
Posted By: Guests
Date Posted: 16 November 2005 at 11:15am
|
Wayne, The link appears broken...I am very interested in seeing what you have on the interface. Roy |
Posted By: jacksun
Date Posted: 23 November 2005 at 9:46pm
|
Sorry, moving the site.
Here is the new link:
https://inetsecurity.secure.powweb.com/downloads/spamfilterweb.zip - https://inetsecurity.secure.powweb.com/downloads/spamfilterw eb.zip
Cheers,
Wayne
|
Posted By: Guests
Date Posted: 29 November 2005 at 10:58am
|
Thanks!!
Roy |
Posted By: lyndonje
Date Posted: 09 February 2006 at 9:43am
|
Hi jacksun I've installed your web interface, but the notifications don't seem to work. Is there anything additional to the HTML pages that are required? Have anyone else developed any web interfaces? Thanks! Lyndon. |
Posted By: jdevv
Date Posted: 09 February 2006 at 11:10am
|
Hi Jacksun, I am trying to get your webinterface working with mysql. I get an strange error message on row 116 of listspam.asp Thanks, David |
Posted By: Guests
Date Posted: 13 February 2006 at 4:20pm
| I couldn't get the notification to work either. What about an automatic clean up after x days? |
Posted By: lyndonje
Date Posted: 14 February 2006 at 3:49am
| Isn't an automatic clean up already part of Spam Filter settings? Under the Quarantine tab? |
Posted By: ktrunkett
Date Posted: 14 February 2006 at 2:40pm
|
How would i setup the listspam.asp page to refresh automatically, based on the user plugging in a number to "refresh" every 30 seconds
|
Posted By: ktrunkett
Date Posted: 14 February 2006 at 4:06pm
| also, is there a way to log in and see all users spam. |
Posted By: Benny
Date Posted: 16 February 2006 at 10:33am
|
ktrunkett, yes you can, but you need a small mod to the website Wayne designed. You can do this in two ways. One create an exception in the code (listspam.asp), if the EmailTo = mailto:specialuser@xyz.com - specialuser@xyz.com , select all. the other way is to use SFI to see them. :-) |
Posted By: ktrunkett
Date Posted: 16 February 2006 at 11:49am
|
do you have an example of how (and where in the file) i should place that? I really don't Know asp and the sql part of it. Thanks. |
Posted By: Benny
Date Posted: 16 February 2006 at 12:27pm
| Sorry, I don't. I don't have this need. You really need to know the sql to do this though. |
Posted By: Benny
Date Posted: 16 February 2006 at 9:48pm
|
I took a look at the code. here's what you can do. Register an account like mailto:admin@mycompany.com - admin@mycompany.com In the file ListSpam.asp line 33, replace the line 33 to 43 with the following and please make sure there's no line wrap: 'Generate query. If EmailTo = "admin@mycompany.com" Then SQL = "SELECT QuarID, EmailFrom, Subject, MsgDate, MsgID, RejectDesc " SQL = SQL & "FROM tblQuarantine, tblRejectCodes " SQL = SQL & "WHERE (Deliver = 0) " SQL = SQL & "AND (Expire = 0) " SQL = SQL & "AND (tblQuarantine.RejectID = tblRejectCodes.RejectID) " SQL = SQL & "ORDER BY " & order_by Else SQL = "SELECT QuarID, EmailFrom, Subject, MsgDate, MsgID, RejectDesc " SQL = SQL & "FROM tblQuarantine, tblRejectCodes " SQL = SQL & "WHERE (EmailTo = '" & EmailTo & "') " SQL = SQL & "AND (Deliver = 0) " SQL = SQL & "AND (Expire = 0) " SQL = SQL & "AND (tblQuarantine.RejectID = tblRejectCodes.RejectID) " SQL = SQL & "ORDER BY " & order_by End if Set rs = con.Execute(SQL) |
Posted By: ktrunkett
Date Posted: 17 February 2006 at 10:37am
|
That helps alot.. thanks. One more (maybe Two) Questions. That SQL works. Is there a way (i'm sure there is) to log in with mailto:admin@mycompany.com - admin@mycompany.com and only see "mycompany.com" emails. i dont' want to see "yourcompany.com" emails. Thanks Kriss |
Posted By: Benny
Date Posted: 17 February 2006 at 12:35pm
|
'Generate query. If EmailTo = "admin@mycompany.com" Then SQL = "SELECT QuarID, EmailFrom, Subject, MsgDate, MsgID, RejectDesc " SQL = SQL & "FROM tblQuarantine, tblRejectCodes " SQL = SQL & "WHERE instr(1,tblQuarantine.EmailTo,"mycompany.com")&g t;1 " SQL = SQL & "AND (Deliver = 0) " SQL = SQL & "AND (Expire = 0) " SQL = SQL & "AND (tblQuarantine.RejectID = tblRejectCodes.RejectID) " SQL = SQL & "ORDER BY " & order_by Else SQL = "SELECT QuarID, EmailFrom, Subject, MsgDate, MsgID, RejectDesc " SQL = SQL & "FROM tblQuarantine, tblRejectCodes " SQL = SQL & "WHERE (EmailTo = '" & EmailTo & "') " SQL = SQL & "AND (Deliver = 0) " SQL = SQL & "AND (Expire = 0) " SQL = SQL & "AND (tblQuarantine.RejectID = tblRejectCodes.RejectID) " SQL = SQL & "ORDER BY " & order_by End if Set rs = con.Execute(SQL) |
Posted By: ktrunkett
Date Posted: 17 February 2006 at 4:06pm
|
SQL = SQL & "WHERE instr1,tblQuarantine.EmailTo,"mycompany.com")&am p;g t;1 " didnt' work but i think i'm learning SQL now and did this instead. SQL = SQL & "WHERE (EmailTo Like '%mycompany.com' )" THanks for your help.. i'm going to try and figure out how to make any mailto:admin@anycompany.com - admin@anycompany.com get all of the quarantine for their specfic domain.
|
Posted By: jacksun
Date Posted: 21 February 2006 at 1:19pm
|
I have added the VBS scripts needed to run the reminder.asp scripts to the download. This download now has all the previous download stuff plus these VBS scripts.
These scripts get the reminders to work.
You need to put these .vbs files into a directory on the web server that has execute permissions, set the paths in the files so it can find your reminder.asp scripts, and then schedule these .vbs scripts to run using a scheduled job.
https://inetsecurity.secure.powweb.com/downloads/spamfilterweb.zip - https://inetsecurity.secure.powweb.com/downloads/spamfilterw eb.zip
Wayne
|
Posted By: Rifleman
Date Posted: 27 February 2006 at 2:21pm
|
Could someone please give me the examples of the changes to the asp scripts when using MYSQL? I am getting an error on line 111. The line is con.open = "Provider=SQLOLEDB; Data Source=spamfilter; Initial Catalog=spamfilter; User ID=root; Password="%password%";" |
Posted By: Rifleman
Date Posted: 27 February 2006 at 6:10pm
|
I am getting this error. I have gone oiver the instructions as much as I can. I creted the tables in MySQL. Type mismatch: 'clng'
/ListSpam.asp, line 117
|
Posted By: Rifleman
Date Posted: 28 February 2006 at 5:09pm
|
OK, so I got past one issue since I figured out what I needed to do in MySQL. But so far, the password change gets this error: Microsoft OLE DB Provider for ODBC Drivers error '80040e14' You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '[Password] = 'password' WHERE EMail = 'email@domain /PasswordChange.asp, line 40 |
Posted By: Rifleman
Date Posted: 28 February 2006 at 6:12pm
|
Well, after much ado, I figured it out. Now, for the notifications. Could we get some details on he scripts please? Has anyone gotten it to work? If so, how did you do it? |
Posted By: Benny
Date Posted: 28 February 2006 at 6:15pm
|
I got it working. Actually pretty cool. Now it emails users a list of spam with subjects etc. everyday. Once users click the link in the email, it goes directly into the website and they can delete or send right there. No more login screen. Anybody is interested, leave me a PM with your email address. |
Posted By: chris_bell
Date Posted: 13 March 2006 at 5:08am
|
Does anyone have a mod that allows users to add there alternate email address's via the web client ? Best, Chris |
Posted By: Stupid
Date Posted: 07 April 2006 at 5:32pm
|
I can do this for you.
|
chris_bell wrote:Posted By: Stupid
Date Posted: 28 April 2006 at 3:41pm
|
For anybody who is interest, I can develop this for you, but I would need a list of features that you want to be on there. Stupid |
Posted By: lyndonje
Date Posted: 10 May 2006 at 2:19pm
|
Hi jacksun, I've set the http path in the VBS script, I've copied WinHttp.dll into system32 directory and registered it. But when I run the vbs script it errors. As CDONTS isnt installed on this server, I've added a WScript.Echo command if objWinHttp.Status <> 200 - which is appearing, so I krnow the WinHttp is returning an error of some sort. The path in the VBS is correct, because if I copy and paste into IE it works. Any ideas? |
Posted By: lyndonje
Date Posted: 10 May 2006 at 2:59pm
|
Don't worry, sorted it. Downloaded and installed MSXML4 SP2, and then changed the lines in your scripts from Set objWinHttp = CreateObject("WinHttp.WinHttpRequest.5") to Set objWinHttp = CreateObject("WinHttp.WinHttpRequest.5.1") |
Posted By: AndrewD
Date Posted: 29 October 2010 at 4:22am
|
For those still looking for more functionality please see my post on this topic.
A link is in my signature below.
Cheers
Andrew ------------- Spamfilter web interface. www.tyrexpg.com.au See http://www.logsat.com/SpamFilter/Forums/forum_posts.asp?TID=6883 |