| Re: Photo of the Month?
Like I said, I haven't really thought about how it should work, but here is one example how this could work:
It could be a vBcron that is set to run monthly and only be a couple to a few queries.
One query (I think) to pull the images that have been posted in the last 30 days and sort it by (selectable) views, replies, or ratings and limit it to 1
And one query (again, I think) to copy or move that image to another category, such as Photos of the Month.
I'm not a programmer, but I really don't see this being a problem with performance.
|