| Author |
 Topic  |
|
Ribkick
Junior Member
USA
296 Posts |
 Posted - 08 May 2001 : 18:53:26
|
Hi Richard and Slemieux, your work on the PM MOD is terrific! Just installed it with no hitches, well done.
I do have one concern however. Is there a way to set it to prune any messages over a certain amount of days? I can see this being a huge problem with members that don't do any housekeeping. In time our server would be filled with very old, defunct messages.
Perhaps there's a way to for an Admin to delete/edit a members in/out box if nothing else. Not having Access 2000 on my computer, I can't get to the database to edit it.
Thanks again, terrific feature and very well written and executed.
Edited by - ribkick on 08 May 2001 19:17:03 |
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 08 May 2001 : 19:09:21
|
I am not the one who did that MOD. slemieux is the author of that MOD. I have just been making a few changes to it here and there to keep it compatible with the forum as the forum changes.
It probably wouldn't be very hard to either write a new admin interface for deleting PMs that are say 30 days old or something like that. Or it could probably be added to admin_count.asp. Either way, it's something that would have to be manually run by the Admin. |
 |
|
|
Ribkick
Junior Member
USA
296 Posts |
Posted - 08 May 2001 : 19:14:58
|
I wouldn't mind running it once a week or month but it's way beyond my expertice to write the code. Should I direct my questions to Slemieux for this sort of thing?
This does seem like it would be a hidden monster filling the database though.
|
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 08 May 2001 : 19:27:31
|
| I will look into doing it. |
|
|
|
swatijain
Starting Member
48 Posts |
Posted - 08 May 2001 : 19:35:45
|
Hi
Just a suggestion...if you want you can access your access database from the web.
Download this ASP Application: http://www.tableeditor.com/
I have used it for SQL Server and I am impressed with it. It supports Access 2000, so you should be fine.
-Swati
|
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 08 May 2001 : 20:07:54
|
| Excellent suggestion. I use the same thing for accessing my databases that are online also. |
|
|
|
Ribkick
Junior Member
USA
296 Posts |
Posted - 08 May 2001 : 20:48:03
|
Swat, I tried that link 3 times and got the same "can't find website" error but will try again later during a less busy time.
Richard, if you could look into an addional mod/add-on for the PM mod to prune messages, that would be, in my opinion, a very valuable asset to this otherwise excellent addition to our forum. Thanks to both of you for your help.
|
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
|
|
Aznknight
Senior Member
USA
1373 Posts |
Posted - 08 May 2001 : 21:32:20
|
the private message mod is one of my favorite mods too  !
I wrote some simple codes that does the pruning you're talking about like awhile back and thought i've released it here already. It might be buried somewhere here or i might have forgot to post it up. What it does is it deletes messages that have been read and are older than 30 days. unread messages will be left alone.
here is the code again for ya:
add this to pm_view.asp around line 62:
'Delete messages past 30 days old
strMessageDays = datetostr(dateAdd("d",-30,strForumTimeAdjust))
SQL = "DELETE FROM " & strTablePrefix & "PM WHERE M_TO = " & strUserMemberID & " AND M_SENT < '" & strMessageDays & "' AND M_READ = 1"
my_Conn.Execute SQL
SQL = "DELETE FROM " & strTablePrefix & "PM WHERE M_FROM = " & strUserMemberID & " AND M_SENT < '" & strMessageDays & "' AND M_READ = 1"
my_Conn.Execute SQL
right after this part:
'#######################################################################
'####### Right now if a user doesn't have an OUTBOX preference #######
'####### set in their cookie it will default to double #######
'####### #######
'####### If you want to change it, just change "double" below #######
'####### to either "single" or "none" #######
'#######################################################################
Response.Cookies(strCookieURL & "paging")("outbox") = "double"
Response.Cookies(strCookieURL & "paging").Expires = dateAdd("d", 360, strForumTimeAdjust)
end if
- Alan
www.iamviet.com
www.calvsa.net
Snitz Resource |
|
|
|
dayve
Forum Moderator
USA
5820 Posts |
Posted - 08 May 2001 : 22:36:51
|
Aznknight: I get an error with that code
Richard Kinser: Have you gotten the compact feature to work with table editor?
Dayve
Edited by - dayve on 08 May 2001 22:37:14 |
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 08 May 2001 : 22:53:24
|
dayve,
I've never tried using it. |
|
|
|
Aznknight
Senior Member
USA
1373 Posts |
Posted - 09 May 2001 : 01:39:04
|
quote:
Aznknight: I get an error with that code
Richard Kinser: Have you gotten the compact feature to work with table editor?
Dayve
Edited by - dayve on 08 May 2001 22:37:14
um, what was the error? it's more constructive if that is displayed as well as just saying you got an error. 
- Alan
www.iamviet.com
www.calvsa.net
Snitz Resource |
|
|
|
work mule
Senior Member
USA
1358 Posts |
Posted - 09 May 2001 : 01:57:25
|
A question to pose to you guys about "pruning".
Are your members aware of the fact that you are/will be deleting private messages over 30 days old? Have you stated this policy anywhere (like on the PM pages themselves)? I'd hate for anyone to have any angry members.
|
|
|
|
Aznknight
Senior Member
USA
1373 Posts |
Posted - 09 May 2001 : 02:14:38
|
yeah i stated this in bold red letters to the left of the pm icons on the pm_view.asp page.
- Alan
www.iamviet.com
www.calvsa.net
Snitz Resource
Edited by - aznknight on 09 May 2001 02:20:27 |
|
|
|
wii
Free ASP Hosts Moderator
Denmark
2632 Posts |
Posted - 09 May 2001 : 04:16:17
|
any chance of releasing the PM popup code when new PM´s are received?
|
|
|
|
DarlingBri
Junior Member
United Kingdom
378 Posts |
Posted - 09 May 2001 : 09:05:05
|
Ooooh! What a good idea! Someone post the error code so Alan can fix it and the less adventurous among us can use it! 
*****
"Bother," said Pooh, as Piglet was assimilated by the Borg. |
|
|
|
Topic |
|
Topic Locked
