| Author |
 Topic  |
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
 Posted - 10 May 2001 : 21:11:23
|
| If it works for the 30 days, then it should work for all of the other days as well. Thanks for testing it out.. |
 |
|
|
DarlingBri
Junior Member
United Kingdom
378 Posts |
Posted - 10 May 2001 : 21:55:50
|
Alan, that is a beautiful, beautiful thing :o) Thank you! 
--Happy Bri
*****
"Bother," said Pooh, as Piglet was assimilated by the Borg. |
|
|
|
e3stone
Average Member
USA
885 Posts |
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 10 May 2001 : 22:44:03
|
| There were a few changes made, mainly cosmetic. The code in question was added so that there was a default cookie setting for the inbox/outbox setting. |
|
|
|
e3stone
Average Member
USA
885 Posts |
|
|
Aznknight
Senior Member
USA
1373 Posts |
Posted - 10 May 2001 : 23:20:31
|
e3stone, add it below the include for inc_top.asp is fine. don't forget to inclose my code inside <% %> asp delimiters though 
- Alan
www.iamviet.com
www.calvsa.net
Snitz Resource |
|
|
|
e3stone
Average Member
USA
885 Posts |
|
|
e3stone
Average Member
USA
885 Posts |
Posted - 10 May 2001 : 23:39:28
|
hmmm, doesn't this code only delete the message if the user views their private messages? what if I have a user that has 20 messages in their box and they never go and check them, thus never accessing pm_view.asp? The messages don't get deleted, right?
Another question: if I delete a member, are all their stored pm's deleted as well?
<-- Eric -->
http://insidewaco.com/forum/home.asp |
|
|
|
Aznknight
Senior Member
USA
1373 Posts |
Posted - 10 May 2001 : 23:45:55
|
Yep you're right this will only delete it when the go to check their pm's, To make it do the pruning when anyone checks their pm's at pm_view.asp, just remove M_TO = " & strUserMemberID & " AND from the sql statement and delete the second statement, so that it'll look like below:
'Delete messages past 30 days old
strMessageDays = datetostr(dateAdd("d",-30,strForumTimeAdjust))
SQL = "DELETE FROM " & strTablePrefix & "PM WHERE M_SENT < '" & strMessageDays & "'"
my_Conn.Execute SQL
- Alan
www.iamviet.com
www.calvsa.net
Snitz Resource |
|
|
|
Aznknight
Senior Member
USA
1373 Posts |
Posted - 10 May 2001 : 23:47:32
|
quote:
Another question: if I delete a member, are all their stored pm's deleted as well?
<-- Eric -->
http://insidewaco.com/forum/home.asp
No it does not. Their PM's will remain there because the default pop_delete.asp has no idea what PM's are since PM is a mod.
- Alan
www.iamviet.com
www.calvsa.net
Snitz Resource |
|
|
|
e3stone
Average Member
USA
885 Posts |
Posted - 10 May 2001 : 23:52:34
|
Alan, I think you and Huw need to have a contest on who responds the quickest to questions with the right answer
Alan: 4 minutes 32.67582 seconds
Huw: 4 minutes 33.56453 seconds
Anytime I post a question, I go check another page and come back and there's an answer 
Opps, forgot Richard
Richard: 4 minutes 33.23454 seconds
<-- Eric -->
http://insidewaco.com/forum/home.asp
Edited by - e3stone on 10 May 2001 23:53:45 |
|
|
|
Ribkick
Junior Member
USA
296 Posts |
Posted - 11 May 2001 : 15:46:29
|
Richard, I downloaded your PM manager as well. I put it up and it worked fine. Thank you, this gives me a custom way to manage the PM as well if the automatic one by Alan isn't enough.
With the people we'll be inviting to our forum, I can see them getting very chatty LOL. Thanks again all for your hard work in these help forums.
|
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 11 May 2001 : 19:44:32
|
| Cool Glad it works for you. |
|
|
|
dayve
Forum Moderator
USA
5820 Posts |
Posted - 22 May 2001 : 13:04:59
|
quote:
http://www1.domaindlx.com/dssdbs/files/admin_pmmaint.zip
You'll just need to add a link to it in your admin_home.asp page.
beautiful, just beautiful... I don't particularly care for automation of this process so this works out perfect for me... thanks guys once again.
Dayve |
|
|
|
Gandalf il Bianco
Starting Member
Italy
18 Posts |
Posted - 22 May 2001 : 20:30:29
|
It works perfectly! Great mod Richard!
|
|
|
|
Topic |
|
Topic Locked
