Quote:
Originally Posted by Rho'd Berth
Hi scarex,
Can you please explain a bit more how you fixed it?
What change should I make in the section.php file? Where should I make it?
Thanks in advance,
Robert
|
I've edited packages/vbcms/collection/content/section.php. In 4.0.8 release, in getLoadQuery function you can find the query in $sql variable.
Before $sql statement, I declared the following variable
PHP Code:
$restriction ="AND node.parentnode NOT IN (5,154)";
and I used it in $sql statement
PHP Code:
" INNER JOIN " . TABLE_PREFIX . "cms_node AS rootnode
ON rootnode.nodeid = " . intval($this->filter_node) .
" $restriction AND (node.nodeleft >= rootnode.nodeleft AND node.nodeleft <= rootnode.noderight) AND node.nodeleft != rootnode.nodeleft ".