It's been awhile since I've looked at this hack, so I'm not sure how to dodge that problem. I'm currently enrolled in an SQL course at ITT Tech, and once I finish it I should be better equipped to deal with this functional but still somewhat glitchy hack. This is what I have in mind for the next version.
- The hack overall will become a display mode for news.php and exist in the same code. I intend to retain most if not all of Brian's original functionality for the news module. Basically you'll see one new line on your vbacmps config: Display as Digest? *Yes *No; with the default being no.
- I'm now aware some of the ugliness in the code is due to the fact you can't nest while loops - so I'm gonna have to put a stop to that.
- The number of days will still default at 7, but modifying it will be possible from the admincp
- Users will be able to submit a scan range to the page in two ways determined by the admin. Method one is to allow them to choose weeks (i.e. Week starting Monday, January 3rd). The week starting will refer back to the user setting for start of the week in the case. Or the admin may simply set a day range, but be careful with that in case some yahoo decides to, say, search all news items between a couple of days that are months apart (which would set up a highly intensive query on the server). Obviously, a max time differential would be needed, now that I think about it (14 days sounds good to me).
Any other suggested features would be welcome.