/** * @access public */ function getFiles() { if ($this->_files === null) { $this->_files = array(); $qry = 'SELECT file_id FROM ' . OOMedia::_getTableName() . ' WHERE category_id = ' . $this->getId(); $sql = new rex_sql(); $sql->setQuery($qry); $result = $sql->getArray(); if (is_array($result)) { foreach ($result as $line) { $this->_files[] =& OOMedia::getMediaById($line['file_id']); } } } return $this->_files; }
<input class="rex-form-submit" type="submit" value="' . $I18N->msg('pool_search') . '" /> </p> </div> </noscript>'; } $cat_out .= ' </div> </fieldset> </form> </div> '; // ----- EXTENSION POINT $cat_out = rex_register_extension_point('MEDIA_LIST_TOOLBAR', $cat_out, array('subpage' => $subpage, 'category_id' => $rex_file_category)); // *************************************** Subpage: Detail if ($subpage == 'detail' && rex_post('btn_delete', 'string')) { // TODO: getMediaById() deprecated, daher getMediaByFileName() nutzen $media = OOMedia::getMediaById($file_id); if ($media) { $file_name = $media->getFileName(); if ($PERMALL || $REX['USER']->hasPerm('media[' . $media->getCategoryId() . ']')) { $uses = $media->isInUse(); if ($uses === false) { if ($media->delete() !== FALSE) { $info = $I18N->msg('pool_file_deleted'); } else { $warning = $I18N->msg('pool_file_delete_error_1', $file_name); } $subpage = ""; } else { $warning = array(); $warning[] = '<strong>' . $I18N->msg('pool_file_delete_error_1', $file_name) . ' ' . $I18N->msg('pool_file_delete_error_2') . '</strong><br />'; foreach ($uses as $use) {
/** * @access public */ function getMediaByFileName($name) { $query = 'SELECT file_id FROM ' . OOMedia::_getTableName() . ' WHERE filename = "' . $name . '"'; $sql = new rex_sql(); $result = $sql->getArray($query); if (is_array($result)) { foreach ($result as $line) { return OOMedia::getMediaById($line['file_id']); } } return null; }
/** * @access public */ function searchMediaByFileName($name) { $query = 'SELECT file_id FROM ' . OOMedia::_getTableName() . ' WHERE filename = "' . addslashes($name) . '"'; $sql = new sql(); $result = $sql->get_array($query); $media = array(); foreach ($result as $line) { $media[] = OOMedia::getMediaById($line['file_id']); } return $media; }