FREE Get a FREE template when you purchase Social bundle 🚀 ⚡️

Helpdesk

Your Time
Our Time
Response Time
24 — 48 hours
We strive to provide the fastest ever response possible. However, we are not super beings.

Allow at least 24 — 48 hours
  Support is offline
It is currently off working hours and most of us aren't around

Rest assured that we will get back to you as soon as the day starts tomorrow!
  Support is offline

Showing comments from the last 6 days only

lph220 · ·
3:56 AM Sunday, 17 October 2021
Normal
Hi,

I found in /models/blog.php that the getBlogComment function has a query to retrieve comment and tried to add the following but it does not have effect.

Can you help me with the syntax please?


if ($lite) {
$query = 'SELECT a.* FROM `#__easyblog_comment` a';
$query .= ' LEFT JOIN #__users AS c ON a.`created_by` = c.`id`';
$query .= ' WHERE a.`post_id` = '.$db->Quote($id);
$query .= ' AND a.`published` = 1';
$query .= ' AND a.' . $db->quoteName('created') . ' >= DATE_SUB(' . $db->Quote($now) . ', INTERVAL 6 DAY)';


Kind regards,

Matt
The replies under this section are restricted to logged in users or users with an active subscription with us