/**
* @access protected
*/
function OOMediaCategory($id)
{
$query = 'SELECT * FROM ' . OOMediaCategory::getTableName() . ' WHERE id = ' . $id;
$sql = new sql();
// $sql->debugsql = true;
$result = $sql->get_array($query);
$result = $result[0];
if (count($result) == 0) {
trigger_error('No OOMediaCategory found with id "' . $id . '"', E_USER_ERROR);
}
// var_dump( $result);
$this->_id = $result['id'];
$this->_re_id = $result['re_id'];
$this->_name = $result['name'];
$this->_path = $result['path'];
}
/**
* @access protected
*/
function getTableJoin()
{
$mediatable = OOMedia::getTableName();
$cattable = OOMediaCategory::getTableName();
return $mediatable . ' LEFT JOIN ' . $cattable . ' ON ' . $mediatable . '.category_id = ' . $cattable . '.id';
}
