/** * @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'; }