[geeklog-devel] [geeklog-cvs] geeklog: One featured story per topic is now allowed, with only ...

Joe Mucchiello 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 
page" options.

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.

Joe Mucchiello
Throwing Dice Games

More information about the geeklog-devel mailing list