Bug #3300 ยป 3300.patch
| components/com_comprofiler/plugin/user/plug_cbmamboauthortab/cb.authortab.php | ||
|---|---|---|
|
. "\n AND a.state = 1 "
|
||
|
. "\n AND (publish_up = '0000-00-00 00:00:00' OR publish_up <= '$now')"
|
||
|
. "\n AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '$now')"
|
||
|
. "\n AND a.access IN (" . implode( ',', CBuser::getMyInstance()->getAuthorisedViewLevelsIds( true ) ) . ')'
|
||
|
. "\n AND a.access IN (" . implode( ',', CBuser::getMyInstance()->getAuthorisedViewLevelsIds( ( $jVer >= 2 ? false : true ) ) ) . ')'
|
||
|
. "\n ORDER BY a.created DESC"
|
||
|
;
|
||
|
$_CB_database->setQuery( $query );
|
||