I don't know if you are reffering to my post, but after your quick fix i still 
have the same problem:

(i read my mail with imp)

A new mail arrives, i read it, i MARK it as read, and after refreshing i get 
the same pop up that says: you have 1 new message!

-----Αρχικό Μήνυμα-----
Από: Mark Mackay <[EMAIL PROTECTED]>
Θέμα: [Dbmail] Quick fix for the imap vs pop read state
Ημερομηνία: Sat, 28 Sep 2002 18:59:42 +1200

As mentioned in a previous post, I found that if you POPed a mailbox and
kept messages on server, any subsequent imap sessions showed the message
state as unread. 

Here's a quick fix (sorry not a patchfile):

In dbmysql, function db_update_pop replace:

      snprintf (query,DEF_QUERYSIZE,
            "UPDATE messages set status=%llu WHERE message_idnr=%llu AND
status<002",
           ((struct message *)tmpelement->data)->virtual_messagestatus,
           ((struct message *)tmpelement->data)->realmessageid);
 
With

      snprintf (query,DEF_QUERYSIZE,
            "UPDATE messages set seen_flag=if(%llu=1, 1, seen_flag),
status=%llu WHERE message_idnr=%llu AND status<002",
           ((struct message *)tmpelement->data)->virtual_messagestatus,
           ((struct message *)tmpelement->data)->virtual_messagestatus,
           ((struct message *)tmpelement->data)->realmessageid);


Works for me and should keep the imap state intact if POP doesn't change it,
but I don't think that really should be an issue anyway. The 'better' way to
do it is probably to just use the state column to determine read/unread in
the Imap client, but I didn't want do go and hack away at that if the rfc
called for something else...

/Mark

_______________________________________________
Dbmail mailing list
Dbmail@dbmail.org
https://mailman.fastxs.nl/mailman/listinfo/dbmail


______________________________________________________________________________________
http://mobile.pathfinder.gr - Pathfinder Mobile logos & Ringtones! 
http://www.pathfinder.gr - Δωρεάν mail από τον Pathfinder!

Reply via email to