Hi,
Some plugins uses SQL queries to get the article's data from database tables, so my question is that in this case how to render introtext field to hide seblod tags.
For Example:
$query = '
SELECT DISTINCT
categories.title AS cat,
'.($config['use_title_alias'] ? 'content.alias' : 'content.title').' AS title,
content.introtext AS text,
content.id AS IID,
CASE WHEN CHAR_LENGTH(content.alias)
THEN CONCAT_WS(":", content.id, content.alias)
ELSE content.id END as ID,
CASE WHEN CHAR_LENGTH(categories.alias)
THEN CONCAT_WS(":", categories.id, categories.alias)
ELSE categories.id END as CID
FROM
#__content AS content
LEFT JOIN
#__categories AS categories
ON categories.id = content.catid
LEFT JOIN
#__users AS users
ON users.id = content.created_by
LEFT JOIN
#__content_frontpage AS frontpage
ON content.id = frontpage.content_id
WHERE
content.state = 1
'. $access_con .'
AND categories.published = 1
AND ( content.publish_up = '.$db->Quote($nullDate).' OR content.publish_up <= '.$db->Quote($now).' )
AND ( content.publish_down = '.$db->Quote($nullDate).' OR content.publish_down >= '.$db->Quote($now).' )
AND ( '.$sql_where.' )
'.$lang_filter.'
'.$frontpage_con.'
ORDER BY
'.$order_options.'
LIMIT
'.($config['startposition']).','.($amount + (int)$config['startposition']).';
';
As the result of above example, introtext will be included with seblod tags and all the field those have Custom->article->introtext storage.
Can you tell me how to change "content.introtext AS text," to make it compatible with Seblod.
Regards,
Umair