function csv($option) { global $mtconf; $database =& JFactory::getDBO(); # Load all custom fields $sql = "SELECT cf.*, ft.ft_class FROM #__mt_customfields AS cf " . "\nLEFT JOIN #__mt_fieldtypes AS ft ON ft.field_type=cf.field_type" . "\nWHERE cf.iscore = 0 ORDER BY ordering ASC"; $database->setQuery($sql); $fields = new mFields(); // $fields->setCoresValue( $row->link_name, $row->link_desc, $row->address, $row->city, $row->state, $row->country, $row->postcode, $row->telephone, $row->fax, $row->email, $row->website, $row->price, $row->link_hits, $row->link_votes, $row->link_rating, $row->link_featured, $row->link_created, $row->link_modified, $row->link_visited, $row->publish_up, $row->publish_down, $row->user_id, $row->username ); $fields->loadFields($database->loadObjectList()); # Publishing $publishing[] = JHTML::_('select.option', 1, JText::_('All')); $publishing[] = JHTML::_('select.option', 2, JText::_('Published')); $publishing[] = JHTML::_('select.option', 3, JText::_('Unpublished')); $publishing[] = JHTML::_('select.option', 4, JText::_('Pending')); $publishing[] = JHTML::_('select.option', 5, JText::_('Expired')); $publishing[] = JHTML::_('select.option', 6, JText::_('Pending approval')); $lists['publishing'] = JHTML::_('select.genericlist', $publishing, 'publishing', 'class="inputbox" size="1"', 'value', 'text', ''); HTML_mtree::csv($fields, $lists, $option); }