I'm VERY stuck for time, so am posting this in the hope that someone can assist.
I am maintaining a website for a club, most of who's communications go via a mailing list. I'm wanting to create an online, browse-able archive of the message posts within the Siulverstripe site I've set up.
I've created a PHP script which connects to the mail server, checks for new mail, and inserts it into the database...
CREATE TABLE `Digest` (
`idDigest` int(11) NOT NULL AUTO_INCREMENT,
`date` timestamp NULL DEFAULT NULL,
`To` varchar(255) DEFAULT NULL,
`From` varchar(255) DEFAULT NULL,
`Subject` varchar(255) DEFAULT NULL,
`Bodytext` text,
PRIMARY KEY (`idDigest`)
) ENGINE=InnoDB
and deletes each message from the mail queue after it's been inserted into the database (I've got a dedicated mail account for the archival process)
All I want is a simple module to take the database content and display the messages in chronological order. Today's messages on one page, and then "older" for each preceding day.
Nice-to-have would be to make it searchable.
"archives" by month
Eventually, I'd also like to include the thread-id to make the relevant threads link up, but I'm not fussed about that right now.
My PHP is rusty at best, and my time is at a premium right now
If it comes to it, I'm willing to pay for this, if anyone's interested.