Welcome to Geeklog Sunday, December 17 2017 @ 05:07 am EST


Status: offline

matthewcox

Forum User
Junior
Registered: 11/12/2003
Posts: 31
Location:Asheville, North Carolina
I've been trying to remove stories that have been archived from the site feed by tinkering with lib-syndication.php

Am I correct that it should be done somewhere in the function SYND_feedUpdateCheckAll?

This is my latest attempt but it doesn't work:
PHP Formatted Code
    // get list of topics that anonymous users have access to
    $tresult = DB_query( "SELECT tid FROM {$_TABLES['topics']}"
                         . COM_getPermSQL( 'WHERE', 1 ));
    $tnumrows = DB_numRows( $tresult );
    $topiclist = array();
    for( $i = 0; $i < $tnumrows; $i++ )
    {
        $T = DB_fetchArray( $tresult );
//Modified to exclude archive from site feed
        $archiveexclude = "archive";
        $compareresult = strncmp($T['tid'],$archiveexclude);
        if($compareresult != 0) {
        $topiclist[] = $T['tid'];
        }
//End modification
    }
 

Is it my novice coding or am I looking in the wrong place?

Any help would be appreciated. Thanks, Matthew

Status: offline

Dirk

Site Admin
Admin
Registered: 12/01/2002
Posts: 13073
Location:Stuttgart, Germany
I would try and roll that into the SQL query - let MySQL do the work for you. Something like
PHP Formatted Code
$tresult = DB_query( "SELECT tid FROM {$_TABLES['topics']} WHERE archive_flag = 0" . COM_getPermSQL( 'AND', 1 ));

Completely untested, but that should only return the topics where the archive_flag is not set.

bye, Dirk

Status: offline

matthewcox

Forum User
Junior
Registered: 11/12/2003
Posts: 31
Location:Asheville, North Carolina
Thanks Dirk!

I forgot to mention that's where I started but I couldn't get my sql statement to work thinking that I didn't understand the interaction between that line of code and the function COM_getPermSQL.

As it turns out, I was testing in the wrong place. I was working with the function SYND_feedUpdateCheckAll when I should have been working with SYND_getFeedContentAll. Your snippet worked perfectly once I figured out where to put it Big Grin

Arrow I'm assuming I should apply the same code to both functions as well right?

This works great as a feed that I bring rite back into the site to make a clean "Recent Articles" block.

See it in action along with the facelift I finally gave my site http://matthewcox.org and let me know what you think.

Thanks again, Matthew

All times are EST. The time is now 05:07 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