Переписывание самописа компонента - Joomla 1.5: Общие вопросы

JHTML::stylesheet('branches.css', 'components/com_branches/assets/');

JHTML::script('tooltip.js', 'components/com_branches/assets/js/');

JHTML::_('script', 'tooltip.js', 'components/com_branches/assets/js/');

require_once ( JPATH_BASE .DS.'papka'.DS.'mini.js' );

$document = JFactory::getDocument();
$document->addScript(JURI::root().'components'.DS.'com_branches'.DS.'assets'.DS.'js'.DS.'tooltip.js');

CREATE TABLE IF NOT EXISTS `jos_branches_category` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `parent_id` int(11) NOT NULL DEFAULT '0',
  `title` varchar(200) NOT NULL,
  `alias` varchar(255) NOT NULL,
  `published` tinyint(1) NOT NULL,
  `ordering` mediumint(9) NOT NULL,
  `position_top` int(3) NOT NULL,
  `position_left` int(3) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=23 ;

CREATE TABLE IF NOT EXISTS `jos_branches_record` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL,
  `catid` int(11) NOT NULL,
  `published` tinyint(1) NOT NULL,
  `ordering` int(11) NOT NULL,
  `img` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=19 ;

SELECT t1.*, (SELECT COUNT(*) FROM `#__branches_record` WHERE catid=t1.id) as cnt FROM `#__branches_category` t1 WHERE parent_id = 0 AND published = 1