Select Page

New version of related Articles 1.5.1

New version of related Articles 1.5.1

relatedarticlesforJoomla

As requested

“I like your plugin so much and I have a request if it’s possible. I need the items to have the correct SEF links as it displayed in the site”

BUG: SEF URL’s were not properly translated, now corrected thanks to a bit bigger SQL

 

SELECT

a.id, a.title, a.created,  CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(“:”, a.id, a.alias) ELSE a.id END as slug, CASE WHEN CHAR_LENGTH(b.alias)

THEN CONCAT_WS(“:”, b.id, b.alias) ELSE b.id END as catslug, u.id AS sectionid

FROM jos_content as a INNER JOIN jos_categories AS b ON b.id=a.catid INNER JOIN jos_sections AS u ON u.id = a.sectionid

WHERE ( state = ‘1’ AND a.checked_out = 0 ) AND a.state = 1 AND u.published = 1 AND b.published = 1 AND ( publish_up = ‘0000-00-00 00:00:00’ OR

publish_up = ‘2008-12-15 19:38:19’ ) AND catid = 1 AND a.id < 6 ORDER BY id DESC LIMIT 10

😉

NEW: plugin renamed to Content – Related Articles for more clarity in backend panel

NEW: back link to my site for helping me keeping program GPL and covering cost of hosting (this help me keeping a high page rank). Can be switch off in plugin settings

This version is now running on my site….

Download HERE

About The Author

I worked with various Insurances companies across Switzerland on online applications handling billion premium volumes. I love to continuously spark my creativity in many different and challenging open-source projects fueled by my great passion for innovation and blockchain technology.In my technical role as a senior software engineer and Blockchain consultant, I help to define and implement innovative solutions in the scope of both blockchain and traditional products, solutions, and services. I can support the full spectrum of software development activities, starting from analyzing ideas and business cases and up to the production deployment of the solutions.I'm the Founder and CEO of Disruptr GmbH.

Categories