/**
* @access public
*/
function getMediaById($id)
{
$id = (int) $id;
if ($id == 0) {
return null;
}
$query = 'SELECT ' . OOMedia::_getTableName() . '.*, ' . OOMediaCategory::_getTableName() . '.name catname FROM ' . OOMedia::_getTableJoin() . ' WHERE file_id = ' . $id;
$sql = new rex_sql();
// $sql->debugsql = true;
$result = $sql->getArray($query);
if (count($result) == 0) {
trigger_error('No OOMediaCategory found with id "' . $id . '"', E_USER_NOTICE);
return null;
}
$result = $result[0];
$aliasMap = array('file_id' => 'id', 're_file_id' => 'parent_id', 'category_id' => 'cat_id', 'catname' => 'cat_name', 'filename' => 'name', 'originalname' => 'orgname', 'filetype' => 'type', 'filesize' => 'size');
$media = new OOMedia();
foreach ($sql->getFieldNames() as $fieldName) {
if (in_array($fieldName, array_keys($aliasMap))) {
$var_name = '_' . $aliasMap[$fieldName];
} else {
$var_name = '_' . $fieldName;
}
$media->{$var_name} = $result[$fieldName];
}
return $media;
}
/**
* @access protected
*/
function OOMedia($id = null)
{
if ($id === null) {
return;
}
$query = 'SELECT ' . $this->_getTableName() . '.*,' . OOMediaCategory::_getTableName() . '.name catname FROM ' . OOMedia::_getTableJoin() . ' WHERE file_id = ' . $id;
$sql = new sql();
// $sql->debugsql = true;
$result = $sql->get_array($query);
if (count($result) == 0) {
trigger_error('No OOMediaCategory found with id "' . $id . '"', E_USER_ERROR);
}
$result = $result[0];
// var_dump( $result);
$this->_id = $result['file_id'];
$this->_parent_id = $result['re_file_id'];
$this->_cat_id = $result['category_id'];
$this->_cat_name = $result['catname'];
$this->_name = $result['filename'];
$this->_orgname = $result['originalname'];
$this->_type = $result['filetype'];
$this->_size = $result['filesize'];
$this->_width = $result['width'];
$this->_height = $result['height'];
$this->_title = $result['title'];
$this->_description = $result['description'];
$this->_copyright = $result['copyright'];
$this->_updatedate = $result['updatedate'];
$this->_updateuser = $result['updateuser'];
$this->_createdate = $result['createdate'];
$this->_createuser = $result['createuser'];
}
/**
* @access public
*/
function &getMediaById($id)
{
$id = (int) $id;
if (!is_numeric($id)) {
return null;
}
$query = 'SELECT ' . OOMedia::_getTableName() . '.*, ' . OOMediaCategory::_getTableName() . '.name catname FROM ' . OOMedia::_getTableJoin() . ' WHERE file_id = ' . $id;
$sql = new sql();
// $sql->debugsql = true;
$result = $sql->get_array($query);
if (count($result) == 0) {
//trigger_error('No OOMediaCategory found with id "'.$id.'"', E_USER_NOTICE);
return null;
}
$result = $result[0];
// var_dump( $result);
$media = new OOMedia();
$media->_id = $result['file_id'];
$media->_parent_id = $result['re_file_id'];
$media->_cat_id = $result['category_id'];
$media->_cat_name = $result['catname'];
$media->_name = $result['filename'];
$media->_orgname = $result['originalname'];
$media->_type = $result['filetype'];
$media->_size = $result['filesize'];
$media->_width = $result['width'];
$media->_height = $result['height'];
$media->_title = $result['title'];
$media->_description = $result['description'];
$media->_copyright = $result['copyright'];
$media->_updatedate = $result['updatedate'];
$media->_updateuser = $result['updateuser'];
$media->_createdate = $result['createdate'];
$media->_createuser = $result['createuser'];
return $media;
}
