Welcome to Geeklog, Anonymous Saturday, October 05 2024 @ 12:14 am EDT
Geeklog Forums
COM_featuredCheck delete all featured flags except one
OMAL
Anonymous
Text Formatted Code
function COM_featuredCheck(){
global $_TABLES;
// Look for multiple featured frontpage articles. If more than one pick the newest.
$sql = "SELECT sid FROM {$_TABLES['stories']} WHERE featured = 1 AND draft_flag = 0 AND frontpage = 1 AND date <= NOW() ORDER BY date DESC LIMIT 2";
$resultB = DB_query($sql);
$numB = DB_numRows($resultB);
if ($numB > 1) {
$B = DB_fetchArray($resultB);
// un-feature all other featured frontpage story
$sql = "UPDATE {$_TABLES['stories']} SET featured = 0 WHERE featured = 1 AND draft_flag = 0 AND frontpage = 1 AND date <= NOW() AND sid <> '{$B['sid']}'";
DB_query($sql);
}
21
19
Quote
Status: offline
Laugh
Site Admin
Admin
Registered: 09/27/05
Posts: 1470
Location:Canada
Yes that is how it works.
We did have a feature request for what you are describing at one point:
https://github.com/Geeklog-Core/geeklog/issues/793
but it was closed.
I would think it should be easy to implement (by just changing that SQL) but from what I remember their was some sort of problem which would crop up. Unfortunately I cannot remember what it was and I didn't leave a comment about it.
If it is something you want add a feature request and if you do customize your site with it be sure to include your code in the feature request so we can add it in.
One of the Geeklog Core Developers.
We did have a feature request for what you are describing at one point:
https://github.com/Geeklog-Core/geeklog/issues/793
but it was closed.
I would think it should be easy to implement (by just changing that SQL) but from what I remember their was some sort of problem which would crop up. Unfortunately I cannot remember what it was and I didn't leave a comment about it.
If it is something you want add a feature request and if you do customize your site with it be sure to include your code in the feature request so we can add it in.
One of the Geeklog Core Developers.
19
25
Quote
All times are EDT. The time is now 12:14 am.
- Normal Topic
- Sticky Topic
- Locked Topic
- New Post
- Sticky Topic W/ New Post
- Locked Topic W/ New Post
- View Anonymous Posts
- Able to post
- Filtered HTML Allowed
- Censored Content