By Philippe on Friday, 06 April 2018
Posted in Technical Issues
Likes 0
Views 516
Votes 0
Hello,

In the User Blog App listing, i succeeded to display all items, including articles from Groups and Pages.

For that I modified the file and I deleted the following line :

$query[] = 'AND ' . $db->qn('source_type') . '=' . $db->Quote('easyblog.sitewide');

It worked !
But since the recent update of the application (2.1.3), this technique no longer works...

Could you help me please ?
In my opinion it is decided in the following lines :

$contributeSQL = ' AND ((a.`source_type` = ' . $db->Quote(EASYBLOG_POST_SOURCE_SITEWIDE) . ') ';

if ($includeTeam) {
$contributeSQL .= $contributor::genAccessSQL(EASYBLOG_POST_SOURCE_TEAM, 'a');
}

$contributeSQL .= ')';

Thank you,
Philippe
Hello Philippe,

You can try use this instead:

$contributeSQL = ' AND ((a.`source_type` IS NOT NULL) ';

if ($includeTeam) {
$contributeSQL .= $contributor::genAccessSQL(EASYBLOG_POST_SOURCE_TEAM, 'a');
}

$contributeSQL .= ')';


Please try and see how it goes.
·
Friday, 06 April 2018 12:55
·
0 Likes
·
0 Votes
·
0 Comments
·
It's perfect !

Thank you for your help Nick.
Philippe
·
Friday, 06 April 2018 20:14
·
0 Likes
·
0 Votes
·
0 Comments
·
You are most welcome Philippe, glad that your issue is resolved now.
·
Saturday, 07 April 2018 01:38
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post