[geeklog-devel] [geeklog-cvs] geeklog: One featured story per topic is now allowed, with only ...
joe at ThrowingDice.com
Sun Sep 27 15:19:47 EDT 2009
At 12:21 PM 9/27/2009, geeklog-cvs at lists.geeklog.net wrote:
>One featured story per topic is now allowed, with only one being
>able to be displayed as featured on the frontpage.
Just a thought: I always thought the best way to handle this would be
to remove "featured" from the story table and move it to the topics
table (and vars table for the global "feature"). Then you don't have
to deal with duplicates. The code hits the topic table to find out
how many stories to put on the page so that select would also get the
featured sid. This would allow the system to have "featured on front
page (only)", "featured in topic" and "featured in topic and on front
The same concept could be used to remove "archive_flag" and
"is_default" from the topics table along with the code to make sure
there are no dupes.
Not imperative by any means. The database designer in me just doesn't
like fields on a table where all but one record have the same value
and that one record has the only other value.
Throwing Dice Games
More information about the geeklog-devel