forum.coppermine-gallery.net

Support => cpg1.5.x Support => cpg1.5 miscellaneous => Topic started by: E. William on November 06, 2013, 10:23:22 am

Title: Show/count only keywords for accessible categories
Post by: E. William on November 06, 2013, 10:23:22 am

Hi everyone,

First post, so please be gentle :).

I was wondering if it's possible to count only keywords from albums which you have a right to view.

So for instance, a guest will only see keywords from albums available to guests, but not those reserved for registered users, and registered users will see the keywords for all albums except private ones (but including his own private albums).

I'm pretty sure the following section from keyword.inc.php would need some modification, but I'm unsure how to do it:

Code: [Select]

    while (list($keywords) = mysql_fetch_row($result)) {
        $array = explode($CONFIG['keyword_separator'], html_entity_decode($keywords));

        foreach($array as $word) {
            if (!in_array($word = utf_strtolower($word), $keywords_array)) {
                $keywords_array[] = $word;
                $keyword_count[$word] = 1;
            } else {
                $keyword_count[$word]++;
            }
        }
    }


Title: Re: Show/count only keywords for accessible categories
Post by: Αndré on November 06, 2013, 11:57:41 am

Open include/keyword.inc.php, find

Code: [Select]

$result = cpg_db_query("SELECT keywords FROM {$CONFIG['TABLE_PICTURES']} WHERE keywords <> '' $ALBUM_SET");and replace with

Code: [Select]

get_meta_album_set(0);
$result = cpg_db_query("SELECT keywords FROM {$CONFIG['TABLE_PICTURES']} AS r $RESTRICTEDWHERE AND keywords <> ''");

It seems that $ALBUM_SET is always empty. It's probably a leftover of cpg1.4.x and not used anymore in cpg1.5.x. I've found two other references to it in sidebar.php which should be replaced accordingly and

Code: [Select]

$ALBUM_SET          = ''; in include/init.inc.php, which should be removed.

Title: Re: Show/count only keywords for accessible categories
Post by: Αndré on November 06, 2013, 12:07:46 pm

Fixed clickable keyword list content in SVN revision 8620.

Title: Re: Show/count only keywords for accessible categories
Post by: E. William on November 06, 2013, 11:07:27 pm

Works like a charm :).

Thanks a lot for the help.