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)
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. |
|
johndpatriot
Guest Group |
Post Options
Thanks(0)
|
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)
|
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)
|
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)
|
Sorry, moving the site.
Here is the new link:
Cheers,
Wayne Edited by jacksun |
|
rbarrow
Guest Group |
Post Options
Thanks(0)
|
Thanks!!
Roy |
|
lyndonje
Senior Member Joined: 31 January 2006 Location: United Kingdom Status: Offline Points: 192 |
Post Options
Thanks(0)
|
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)
|
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)
|
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)
|
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)
|
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)
|
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)
|
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)
|
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)
|
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)
|
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)
|
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)
|
'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)
|
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)
|
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)
|
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)
|
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)
|
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)
|
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)
|
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)
|
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)
|
I can do this for you.
|
|
Stupid
Senior Member Joined: 28 November 2005 Status: Offline Points: 127 |
Post Options
Thanks(0)
|
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)
|
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)
|
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") |
|
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.289 seconds.