As an easy but extremely helpful feature, what about changing the deletedflag to be a unix timestamp (or similar). This would allow the maintenance script, etc to be modified in the future to delete messages that have been deleted after they've been flagged for deletion for over 72 hours, as an example.
This would be a good feature for ISP helpdesks, as so many times users screw up and delete mail accidentally, but with POP there's nothing we can do about it. Currently we can restore it if they call up within 12-24 hours, but making it a timestamp would allow ISPs to set it to their own preferred 'grace period', probably as a function of database size and performance. (I for example would like to keep deleted messages for a week and allow a user to 'undelete' messages by accessing a webpage if they need to within that time). As far as syntax, the format of 0 for active, 1, etc... Could be retained -- and when the value is over 1000 (for example) it could be then treated as a timestamp... /Mark On 6/8/02 6:17 PM, "Philip Warner" <[EMAIL PROTECTED]> wrote: > > We have about 600 users and for some reason, some of them (less than 10) > have certain messages that are continuously sent to them via POP (never > deleted). Looking at the database for one such offending message: > > message_idnr | 3634 > mailbox_idnr | 1157 > messagesize | 6010 > seen_flag | 0 > answered_flag | 0 > deleted_flag | 1 > flagged_flag | 0 > recent_flag | 1 > draft_flag | 0 > unique_id | 1158A1028439277 > internal_date | 2002-08-04 15:34:37 > status | 1 > rfcsize | 6189 > > I notice that deleted_flag is 1 and seen_flag is 0, but this seems normal, > at least when mail is left on the server. What is odd is that no matter how > many times the user retrieves their mail, this message is always retrieved. > > As far as I can tell from the logs, they are only using POP. > > I'd be interested to know if anyone else has these problems, or has any > insight into likely causes. > > > > ---------------------------------------------------------------- > Philip Warner | __---_____ > Albatross Consulting Pty. Ltd. |----/ - \ > (A.B.N. 75 008 659 498) | /(@) ______---_ > Tel: (+61) 0500 83 82 81 | _________ \ > Fax: (+61) 0500 83 82 82 | ___________ | > Http://www.rhyme.com.au | / \| > | --________-- > PGP key available upon request, | / > and from pgp5.ai.mit.edu:11371 |/ > > _______________________________________________ > Dbmail mailing list > Dbmail@dbmail.org > https://mailman.fastxs.nl/mailman/listinfo/dbmail
