Modifications are welcome |
Post Reply 
|
Page 12> |
| Author | |
LogSat 
Admin Group 
Joined: 25 January 2005 Location: United States Status: Offline Points: 4104 |
 Post Options
 Thanks(0)
 Quote Reply
 Topic: Modifications are welcomePosted: 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. |
|
 |
|
|
johndpatriot
Guest Group 
|
Post Options
Thanks(0)
Quote Reply
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 Let me know if there are issues with this in this forum |
|
|
|
|
Jacksun
Guest Group
|
Post Options
Thanks(0)
Quote Reply
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 Cheers, |
|
|
|
|
Roy
Guest Group
|
Post Options
Thanks(0)
Quote Reply
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 |
|
|
|
|
jacksun
Newbie 
Joined: 24 February 2005 Status: Offline Points: 31 |
Post Options
Thanks(0)
Quote Reply
Posted: 23 November 2005 at 9:46pm |
|
Sorry, moving the site.
Here is the new link:
Cheers,
Wayne Edited by jacksun |
|
|
|
|
rbarrow
Guest Group
|
Post Options
Thanks(0)
Quote Reply
Posted: 29 November 2005 at 10:58am |
|
Thanks!!
Roy |
|
|
|
|
lyndonje
Senior Member 
Joined: 31 January 2006 Location: United Kingdom Status: Offline Points: 192 |
Post Options
Thanks(0)
Quote Reply
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. |
|
|
|
|
jdevv
Newbie
Joined: 13 July 2005 Location: Netherlands Status: Offline Points: 5 |
Post Options
Thanks(0)
Quote Reply
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 |
|
|
|
|
Benny
Guest Group
|
Post Options
Thanks(0)
Quote Reply
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?
|
|
|
|
|
lyndonje
Senior Member
Joined: 31 January 2006 Location: United Kingdom Status: Offline Points: 192 |
Post Options
Thanks(0)
Quote Reply
Posted: 14 February 2006 at 3:49am |
|
Isn't an automatic clean up already part of Spam Filter settings? Under the Quarantine tab?
|
|
|
|
|
ktrunkett
Newbie
Joined: 07 February 2005 Status: Offline Points: 30 |
Post Options
Thanks(0)
Quote Reply
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
|
|
|
|
|
ktrunkett
Newbie
Joined: 07 February 2005 Status: Offline Points: 30 |
Post Options
Thanks(0)
Quote Reply
Posted: 14 February 2006 at 4:06pm |
|
also, is there a way to log in and see all users spam.
|
|
|
|
|
Benny
Newbie
Joined: 17 January 2006 Status: Offline Points: 24 |
Post Options
Thanks(0)
Quote Reply
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 = specialuser@xyz.com, select all. the other way is to use SFI to see them. :-) Edited by Benny |
|
|
|
|
ktrunkett
Newbie
Joined: 07 February 2005 Status: Offline Points: 30 |
Post Options
Thanks(0)
Quote Reply
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. |
|
|
|
|
Benny
Newbie
Joined: 17 January 2006 Status: Offline Points: 24 |
Post Options
Thanks(0)
Quote Reply
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.
|
|
|
|
|
Benny
Newbie
Joined: 17 January 2006 Status: Offline Points: 24 |
Post Options
Thanks(0)
Quote Reply
Posted: 16 February 2006 at 9:48pm |
|
I took a look at the code. here's what you can do. Register an account like 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) |
|
|
|
|
ktrunkett
Newbie
Joined: 07 February 2005 Status: Offline Points: 30 |
Post Options
Thanks(0)
Quote Reply
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 admin@mycompany.com and only see "mycompany.com" emails. i dont' want to see "yourcompany.com" emails. Thanks Kriss Edited by ktrunkett |
|
|
|
|
Benny
Newbie
Joined: 17 January 2006 Status: Offline Points: 24 |
Post Options
Thanks(0)
Quote Reply
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) Edited by Benny |
|
|
|
|
ktrunkett
Newbie
Joined: 07 February 2005 Status: Offline Points: 30 |
Post Options
Thanks(0)
Quote Reply
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 admin@anycompany.com get all of the quarantine for their specfic domain.
|
|
|
|
|
jacksun
Newbie
Joined: 24 February 2005 Status: Offline Points: 31 |
Post Options
Thanks(0)
Quote Reply
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.
Wayne Edited by jacksun |
|
|
|
|
Rifleman
Groupie 
Joined: 08 August 2005 Location: United States Status: Offline Points: 53 |
Post Options
Thanks(0)
Quote Reply
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%";" Edited by Rifleman |
|
|
|
|
Rifleman
Groupie
Joined: 08 August 2005 Location: United States Status: Offline Points: 53 |
Post Options
Thanks(0)
Quote Reply
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
|
|
|
|
|
Rifleman
Groupie
Joined: 08 August 2005 Location: United States Status: Offline Points: 53 |
Post Options
Thanks(0)
Quote Reply
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 |
|
|
|
|
Rifleman
Groupie
Joined: 08 August 2005 Location: United States Status: Offline Points: 53 |
Post Options
Thanks(0)
Quote Reply
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? |
|
|
|
|
Benny
Newbie
Joined: 17 January 2006 Status: Offline Points: 24 |
Post Options
Thanks(0)
Quote Reply
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. Edited by Benny |
|
|
|
|
chris_bell
Newbie
Joined: 16 February 2006 Status: Offline Points: 6 |
Post Options
Thanks(0)
Quote Reply
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 |
|
|
|
|
Stupid
Senior Member
Joined: 28 November 2005 Status: Offline Points: 127 |
Post Options
Thanks(0)
Quote Reply
Posted: 07 April 2006 at 5:32pm |
|
I can do this for you.
|
|
|
|
|
Stupid
Senior Member
Joined: 28 November 2005 Status: Offline Points: 127 |
Post Options
Thanks(0)
Quote Reply
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 |
|
|
|
|
lyndonje
Senior Member
Joined: 31 January 2006 Location: United Kingdom Status: Offline Points: 192 |
Post Options
Thanks(0)
Quote Reply
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? |
|
|
|
|
lyndonje
Senior Member
Joined: 31 January 2006 Location: United Kingdom Status: Offline Points: 192 |
Post Options
Thanks(0)
Quote Reply
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") |
|
|
|
Topic Options
chris_bell wrote:|
Post Reply
|
Page 12> |
Tweet
|
| Forum Jump | Forum Permissions You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum |
This page was generated in 0.293 seconds.