Hello: I currently have dbmail up and running just fine as a engine to get certain e.mails for a subdomain into mysql. We basically want to create a message tracking system and automate certain messages. I am only using the smtp engine from dbmail and have a web based front end in php that grabs the messags, parses the subjects, dates and attachments, then displays them for the intended use.
I was browsing the list to find out a solution to having the subject stored in a separate field. I eventually found a thread that discussed this, but looking at the CVS source and diff'ing the sql tables, I found no new colums for subject, from, etc. As of now I have to parse the subject out of the messageblks table, and since I only want to display one heading for each particular e.mail subject (they are globally unique subject identifiers - but I have to account for someone replying to a message with the same subject). My code could be much more expandible and efficient if I could somehow have the subject in its own column. Has anyone figured out how to accomplish this? The thread I was discussing: http://mailman.fastxs.nl/pipermail/dbmail/2002-March/000150.html Thanks -Mark
