Related Items Extended - A way to exclude specific categories please

Hello,
I really like Related Items Extended.

However I would like a way to exclude specific categories.

I do not want every article to appear in Related Items Extended. But I do want them to have meta-keywords.

Can someone please help?
11 years 2 months ago #1 by BubbaSmith
The topic has been marked as resolved.
Hello Bubba

We'll look into the possibility to exclude a specific category from the query.
But indeed this Related Items already based on their meta keywords, not every articles appear. If articles has different metakeyword(s) with the current one then it won't be displayed.
11 years 2 months ago #2 by erwinschro
The topic has been marked as resolved.
That would be great if you could exclude a specific category from the query.

In a news website, with articles being posted daily by many authors, it's too hard to go back and modify the meta-keywords for old articles. Much easier to move them into an excluded category!

Any chance I could receive a modified file? I purchased recently.
11 years 2 months ago #3 by BubbaSmith
The topic has been marked as resolved.
Yes you can re-download it later when there's a new update...but i can't promise the ETA...
11 years 2 months ago #4 by erwinschro
The topic has been marked as resolved.
Hi

Can you try to update the relateditems_xtd module using this attached file by uploading it through Extension Manager?

There's a new field in Module Parameters where you can specify Category IDs to be excluded from being queried. Fill in with comma separated values if there's more than one category id.

Let us know if this updated version works or not.
11 years 2 months ago #5 by erwinschro
The topic has been marked as resolved.
Thanks so much for trying. Unfortunately it causes the site to give an error.

I attempted a variety of categories (single parent; single child; parent, child, child) but they all gave an error.

If I re-set the new field "Exclude Category ID" to blank, the site and Related Items Extended function as normal.

On the error page, the title says "0 - Error:0" and the page returns:
0 - SQL=SELECT a.id,a.title,a.introtext,a.images,a.metakey,DATE_FORMAT(a.created, "%Y-%m-%d") as created,a.catid,cc.title as category_title,cc.access AS cat_access,cc.published AS cat_state, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(':', cc.id, cc.alias) ELSE cc.id END as catslug,u.name AS author,contact.id as contactid FROM joom3_content AS a LEFT JOIN joom3_content_frontpage AS f ON f.content_id = a.id LEFT JOIN joom3_categories AS cc ON cc.id = a.catid LEFT JOIN joom3_users AS u on u.id = a.created_by LEFT JOIN ( SELECT contact.user_id, MAX(contact.id) AS id, contact.language FROM joom3_contact_details AS contact WHERE contact.published = 1 GROUP BY contact.user_id, contact.language) AS contact ON contact.user_id = a.created_by WHERE a.id != 75 AND a.state = 1 AND a.access IN (1,1,5) AND (CONCAT(",", REPLACE(a.metakey, ", ", ","), ",") LIKE "%palmer%" OR CONCAT(",", REPLACE(a.metakey, ", ", ","), ",") LIKE "%feet%" OR CONCAT(",", REPLACE(a.metakey, ", ", ","), ",") LIKE "%timberline%" OR CONCAT(",", REPLACE(a.metakey, ", ", ","), ",") LIKE "%season%" OR CONCAT(",", REPLACE(a.metakey, ", ", ","), ",") LIKE "%snow%" OR CONCAT(",", REPLACE(a.metakey, ", ", ","), ",") LIKE "%open%" OR CONCAT(",", REPLACE(a.metakey, ", ", ","), ",") LIKE "%early%" OR CONCAT(",", REPLACE(a.metakey, ", ", ","), ",") LIKE "%2013%" OR CONCAT(",", REPLACE(a.metakey, ", ", ","), ",") LIKE "%level%" OR CONCAT(",", REPLACE(a.metakey, ", ", ","), ",") LIKE "%friday%" OR CONCAT(",", REPLACE(a.metakey, ", ", ","), ",") LIKE "%sunday%" OR CONCAT(",", REPLACE(a.metakey, ", ", ","), ",") LIKE "%weekend%" OR CONCAT(",", REPLACE(a.metakey, ", ", ","), ",") LIKE "%freezing%" OR CONCAT(",", REPLACE(a.metakey, ", ", ","), ",") LIKE "%top%" OR CONCAT(",", REPLACE(a.metakey, ", ", ","), ",") LIKE "%saturday%" OR CONCAT(",", REPLACE(a.metakey, ", ", ","), ",") LIKE "%tullis%" OR CONCAT(",", REPLACE(a.metakey, ", ", ","), ",") LIKE "%lifts%" OR CONCAT(",", REPLACE(a.metakey, ", ", ","), ",") LIKE "%passes%" OR CONCAT(",", REPLACE(a.metakey, ", ", ","), ",") LIKE "%plans%" OR CONCAT(",", REPLACE(a.metakey, ", ", ","), ",") LIKE "%lift%") AND cc.id not in () AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2013-10-09 05:04:18') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2013-10-09 05:04:18') AND ( (TO_DAYS('2013-10-08') - TO_DAYS(a.created) ) <= '90') ORDER BY a.created DESC LIMIT 0, 3
11 years 2 months ago #6 by BubbaSmith
The topic has been marked as resolved.
Powered by Kunena Forum