Find the file: [path to install]/administrator/components/com_docman/classes/DOCMAN_utils.class.php
and goto line number 894.
Change following code:
| Code: |
$query .= $catid ? "\n AND d.catid IN ($catid) " : "";
}
else
{
if ($user->isSpecial) {
$query .= $catid ? "\n WHERE d.catid=$catid " : "";
} elseif ($user->canApprove()) {
$query .= $catid ? "\n WHERE d.catid=$catid " : "";
} elseif ($user->canPublish()) {
$query .= "WHERE d.approved=1";
$query .= $catid ? "\n AND d.catid=$catid " : "";
} elseif ($user->userid) {
$query .= "WHERE d.published=1 AND d.approved=1"
. "\n AND (d.dmowner=" . $user->userid
. "\n OR d.dmmantainedby=" . $user->userid
. "\n OR d.dmowner=" . _DM_PERMIT_EVERYONE
. "\n OR d.dmowner=" . _DM_PERMIT_REGISTERED;
if ($user->groupsIn != '0,0') {
$query .= "\n OR d.dmowner IN (" . $user->groupsIn . ")";
$query .= "\n OR d.dmmantainedby IN (" . $user->groupsIn . ")";
}
if ($_DOCMAN->getCfg('author_can') != _DM_AUTHOR_NONE) {
$query .= "\n OR d.dmsubmitedby = " . $user->userid;
}
$query .= ")";
$query .= $catid ? "\n AND d.catid=$catid " : "";
}
}
|
with this code
| Code: |
$query .= $catid ? "\n AND d.catid IN ($catid) " : "";
}
else
{
if ($user->isSpecial) {
$query .= $catid ? "\n WHERE d.catid IN ($catid) " : "";
} elseif ($user->canApprove()) {
$query .= $catid ? "\n WHERE d.catid IN ($catid) " : "";
} elseif ($user->canPublish()) {
$query .= "WHERE d.approved=1";
$query .= $catid ? "\n AND d.catid IN ($catid) " : "";
} elseif ($user->userid) {
$query .= "WHERE d.published=1 AND d.approved=1"
. "\n AND (d.dmowner=" . $user->userid
. "\n OR d.dmmantainedby=" . $user->userid
. "\n OR d.dmowner=" . _DM_PERMIT_EVERYONE
. "\n OR d.dmowner=" . _DM_PERMIT_REGISTERED;
if ($user->groupsIn != '0,0') {
$query .= "\n OR d.dmowner IN (" . $user->groupsIn . ")";
$query .= "\n OR d.dmmantainedby IN (" . $user->groupsIn . ")";
}
if ($_DOCMAN->getCfg('author_can') != _DM_AUTHOR_NONE) {
$query .= "\n OR d.dmsubmitedby = " . $user->userid;
}
$query .= ")";
$query .= $catid ? "\n AND d.catid IN ($catid) " : "";
}
}
|
