/** * Creates a new DeletedFileList object. */ public function __construct() { parent::__construct(); // categories $accessibleCategoryIDs = FilebaseCategory::getAccessibleCategoryIDs(); if (!empty($accessibleCategoryIDs)) { $this->getConditionBuilder()->add('entry.entryID IN (SELECT entryID FROM filebase' . WCF_N . '_entry_to_category WHERE categoryID IN (?))', array($accessibleCategoryIDs)); } else { $this->getConditionBuilder()->add('1=0'); } $this->getConditionBuilder()->add('entry.isDeleted = ?', array(1)); }
/** * Creates a new WatchedEntryList object. */ public function __construct() { parent::__construct(); $categoryIDs = FilebaseCategory::getAccessibleCategoryIDs(); if (empty($categoryIDs)) { $this->getConditionBuilder()->add('1=0'); } else { $objectTypeID = UserObjectWatchHandler::getInstance()->getObjectTypeID('de.incendium.filebase.entry'); // add conditions $this->sqlConditionJoins = "LEFT JOIN filebase" . WCF_N . "_entry entry ON (entry.entryID = user_object_watch.objectID)"; $this->getConditionBuilder()->add('user_object_watch.objectTypeID = ?', array($objectTypeID)); $this->getConditionBuilder()->add('user_object_watch.userID = ?', array(WCF::getUser()->userID)); $this->getConditionBuilder()->add('entry.entryID IN (SELECT entryID FROM filebase' . WCF_N . '_entry_to_category WHERE categoryID IN (?))', array($categoryIDs)); $this->getConditionBuilder()->add('entry.isDeleted = 0 AND entry.isDisabled = 0'); } }
/** * Creates a new AccessibleFileList object. */ public function __construct() { parent::__construct(); if ($this->applyCategoryFilter) { $accessibleCategoryIDs = FilebaseCategory::getAccessibleCategoryIDs(); if (!empty($accessibleCategoryIDs)) { $this->getConditionBuilder()->add('entry.entryID IN (SELECT entryID FROM filebase' . WCF_N . '_entry_to_category WHERE categoryID IN (?))', array($accessibleCategoryIDs)); } else { $this->getConditionBuilder()->add('1=0'); } } if (!WCF::getSession()->getPermission('mod.filebase.canModerateEntry')) { $this->getConditionBuilder()->add('entry.isDisabled = 0'); } if (!WCF::getSession()->getPermission('mod.filebase.canViewDeletedEntry')) { $this->getConditionBuilder()->add('entry.isDeleted = 0'); } // apply language filter if (LanguageFactory::getInstance()->multilingualismEnabled() && count(WCF::getUser()->getLanguageIDs())) { $this->getConditionBuilder()->add('(entry.languageID IN (?) OR entry.languageID IS NULL)', array(WCF::getUser()->getLanguageIDs())); } }