Один материал в нескольких категориях (мультикатегории) - Joomla 1.5: [FAQ] Часто задаваемые вопросы и ответы

ALTER TABLE `#_content` ADD `catid2` INT ( 11 ) NOT NULL DEFAULT '-1' AFTER `catid` ;
ALTER TABLE `#_content` ADD `catid3` INT ( 11 ) NOT NULL DEFAULT '-1' AFTER `catid2` ;
ALTER TABLE `#_content` ADD INDEX ( `catid2` );
ALTER TABLE `#_content` ADD INDEX ( `catid3` );

	var $catid				= null;

	var $catid2				= null;
	var $catid3				= null;

				<?php echo $lists['catid']; ?>

                </br><?php echo $lists['catid2']; ?>
                </br><?php echo $lists['catid3']; ?>

		$javascript = "onchange=\"changeDynaList ( 'catid', sectioncategories, document.adminForm.sectionid.options[document.adminForm.sectionid.selectedIndex].value, 0, 0);\"";

		$javascript = "onchange=\"changeDynaList ( 'catid', sectioncategories, document.adminForm.sectionid.options[document.adminForm.sectionid.selectedIndex].value, 0, 0);changeDynaList ( 'catid2', sectioncategories, document.adminForm.sectionid.options[document.adminForm.sectionid.selectedIndex].value, 0, 0);changeDynaList ( 'catid3', sectioncategories, document.adminForm.sectionid.options[document.adminForm.sectionid.selectedIndex].value, 0, 0);\"";

			foreach ($cat_list as $cat)
			{
				if ($cat->section == $section->id) {
					$rows2[] = $cat;
				}
			}

			$sectioncategories[$section->id][] = JHTML::_('select.option', '-1', JText::_( 'Select Category' ), 'id', 'title');

		$lists['catid'] = JHTML::_('select.genericlist',  $categories, 'catid', 'class="inputbox" size="1"', 'id', 'title', intval ($row->catid));

		$lists['catid2'] = JHTML::_('select.genericlist',  $categories, 'catid2', 'class="inputbox" size="1"', 'id', 'title', intval ($row->catid2));
		$lists['catid3'] = JHTML::_('select.genericlist',  $categories, 'catid3', 'class="inputbox" size="1"', 'id', 'title', intval ($row->catid3));

			$where .= ' AND a.catid = '.(int) $this->_id;

			$where .= ' AND (a.catid = '.(int) $this->_id.' OR a.catid2 = '.(int) $this->_id.' OR a.catid3 = '.(int) $this->_id.')';

			$this->_article = $this->_db->loadObject ();

			if ($this->_article->catid2 != -1) {
			$query = 'SELECT title'.
					' FROM #__categories' .
					' WHERE id = '.$this->_article->catid2;
			$this->_db->setQuery ($query);
			$this->_cat2 = $this->_db->loadObject ();
			$this->_article->category2	= $this->_cat2->title;
			}
			
			if ($this->_article->catid3 != -1) {
			$query = 'SELECT title'.
					' FROM #__categories' .
					' WHERE id = '.$this->_article->catid3;
			$this->_db->setQuery ($query);
			$this->_cat3 = $this->_db->loadObject ();
			$this->_article->category3	= $this->_cat3->title;
			}

			<?php if ($this->params->get ('link_category')) : ?>
				<?php echo '<a href="'.JRoute::_(ContentHelperRoute::getCategoryRoute ($this->article->catslug, $this->article->sectionid)).'">'; ?>
			<?php endif; ?>
			<?php echo $this->escape ($this->article->category); ?>
			<?php if ($this->params->get ('link_category')) : ?>
				<?php echo '</a>'; ?>
			<?php endif; ?>

             <?php if ($this->params->get ('link_category') && $this->article->category2) : ?>
				<?php echo ', 
				<a href="'.JRoute::_(ContentHelperRoute::getCategoryRoute ($this->article->catid2, $this->article->sectionid)).'">'; ?>
			<?php endif; ?>
			<?php echo $this->escape ($this->article->category2); ?>
			<?php if ($this->params->get ('link_category') && $this->article->category2) : ?>
				<?php echo '</a>'; ?>
			<?php endif; ?>
            <?php if ($this->params->get ('link_category') && $this->article->category3) : ?>
				<?php echo ', 
				<a href="'.JRoute::_(ContentHelperRoute::getCategoryRoute ($this->article->catid3, $this->article->sectionid)).'">'; ?>
			<?php endif; ?>
			<?php echo $this->escape ($this->article->category3); ?>
			<?php if ($this->params->get ('link_category') && $this->article->category3) : ?>
				<?php echo '</a>'; ?>
			<?php endif; ?>

		if (($item->params->get ('show_readmore') && @ $item->readmore) || $item->params->get ('link_titles'))
		{

			$itemid = JRequest::getInt ('id',0);

				$item->readmore_link = JRoute::_(ContentHelperRoute::getArticleRoute ($item->slug, $item->catslug, $item->sectionid));

				$item->readmore_link = JRoute::_(ContentHelperRoute::getArticleRoute ($item->slug, $itemid, $item->sectionid));

				$returnURL = JRoute::_(ContentHelperRoute::getArticleRoute ($item->slug, $item->catslug, $item->sectionid),false);

				$returnURL = JRoute::_(ContentHelperRoute::getArticleRoute ($item->slug, $itemid, $item->sectionid),false);

$where[] = 'c.catid = ' . (int) $catid;

$where[] = '(c.catid = ' . (int) $catid .' OR c.catid2 = ' . (int) $catid .' OR c.catid3 = '. (int) $catid .')';

// Get the articles
		$query = 'SELECT c.*, g.name AS groupname, cc.title AS name, u.name AS editor, f.content_id AS frontpage, s.title AS section_name, v.name AS author' .
				' FROM #__content AS c' .
				' LEFT JOIN #__categories AS cc ON cc.id = c.catid' .
				' LEFT JOIN #__sections AS s ON s.id = c.sectionid' .
				' LEFT JOIN #__groups AS g ON g.id = c.access' .
				' LEFT JOIN #__users AS u ON u.id = c.checked_out' .
				' LEFT JOIN #__users AS v ON v.id = c.created_by' .
				' LEFT JOIN #__content_frontpage AS f ON f.content_id = c.id' .
				$where .
				$order;

// Get the articles
		$query = 'SELECT c.*, g.name AS groupname, cc.title AS name, cc2.title AS name2, cc3.title AS name3, u.name AS editor, f.content_id AS frontpage, s.title AS section_name, v.name AS author' .
				' FROM #__content AS c' .
				' LEFT JOIN #__categories AS cc ON cc.id = c.catid' .
				' LEFT JOIN #__categories AS cc2 ON cc2.id = c.catid2' .
				' LEFT JOIN #__categories AS cc3 ON cc3.id = c.catid3' .
				' LEFT JOIN #__sections AS s ON s.id = c.sectionid' .
				' LEFT JOIN #__groups AS g ON g.id = c.access' .
				' LEFT JOIN #__users AS u ON u.id = c.checked_out' .
				' LEFT JOIN #__users AS v ON v.id = c.created_by' .
				' LEFT JOIN #__content_frontpage AS f ON f.content_id = c.id' .
				$where .
				$order;

				$row->cat_link 	= JRoute::_( 'index.php?option=com_categories&task=edit&cid[]='. $row->catid );

	$row->cat_link2 	= JRoute::_( 'index.php?option=com_categories&task=edit&cid[]='. $row->catid2 );
				$row->cat_link3 	= JRoute::_( 'index.php?option=com_categories&task=edit&cid[]='. $row->catid3 );

<a href="<?php echo $row->cat_link; ?>" title="<?php echo JText::_( 'Edit Category' ); ?>">
							<?php echo $row->name; ?></a>

                        <?php if ($row->catid2 && $row->catid2!=-1) : ?>
							<hr><a href="<?php echo $row->cat_link2; ?>" title="<?php echo JText::_( 'Edit Category' ); ?>">
							<?php echo $row->name2; ?></a>
						<?php endif; ?>
                        <?php if ($row->catid3 && $row->catid3!=-1) : ?>
							<hr><a href="<?php echo $row->cat_link3; ?>" title="<?php echo JText::_( 'Edit Category' ); ?>">
							<?php echo $row->name3; ?></a>
						<?php endif; ?>

$lists['catid'] = JHTML::_('select.genericlist',  $categories, 'catid', 'class="inputbox" size="1"', 'id', 'title', intval($article->catid));

		$lists['catid2'] = JHTML::_('select.genericlist',  $categories, 'catid2', 'class="inputbox" size="1"', 'id', 'title', intval($article->catid2));
		$lists['catid3'] = JHTML::_('select.genericlist',  $categories, 'catid3', 'class="inputbox" size="1"', 'id', 'title', intval($article->catid3));

$javascript = "onchange=\"changeDynaList( 'catid', sectioncategories, document.adminForm.sectionid.options[document.adminForm.sectionid.selectedIndex].value, 0, 0);\"";

$javascript = "onchange=\"changeDynaList ( 'catid', sectioncategories, document.adminForm.sectionid.options[document.adminForm.sectionid.selectedIndex].value, 0, 0);changeDynaList ( 'catid2', sectioncategories, document.adminForm.sectionid.options[document.adminForm.sectionid.selectedIndex].value, 0, 0);changeDynaList ( 'catid3', sectioncategories, document.adminForm.sectionid.options[document.adminForm.sectionid.selectedIndex].value, 0, 0);\"";

			foreach ($cat_list as $cat)
			{
				if ($cat->section == $section->id) {
					$rows2[] = $cat;
				}
			}

			$sectioncategories[$section->id][] = JHTML::_('select.option', '-1', JText::_( 'Select Category' ), 'id', 'title');

		<?php echo $this->lists['catid']; ?>

        </br><?php echo $this->lists['catid2']; ?>
        </br><?php echo $this->lists['catid3']; ?>

			$limit		= JRequest::getVar('limit', 0, '', 'int');
			$limitstart	= JRequest::getVar('limitstart', 0, '', 'int');

			$query = 'SELECT id, title'.
					' FROM #__categories'.
					' WHERE section = '.(int) $this->_id;
			$this->_db->setQuery($query);
			$this->_cat = $this->_db->loadObjectList();
			foreach ($this->_cat as $data)
			{
				$cati[$data->id] = $data->title;
			}

				// check to determine if section or category has proper access rights
				$rows[$i] = $row;

				if ($rows[$i]->catid2 != -1) $rows[$i]->category2	= $cati[$rows[$i]->catid2];
				if ($rows[$i]->catid3 != -1) $rows[$i]->category3	= $cati[$rows[$i]->catid3];

		$query = 'SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.fulltext, a.sectionid, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by,' .
				' a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.attribs, a.hits, a.images, a.urls, a.ordering, a.metakey, a.metadesc, a.access,' .

		$query = 'SELECT a.*,' .

			$limit		= JRequest::getVar('limit', 0, '', 'int');
			$limitstart	= JRequest::getVar('limitstart', 0, '', 'int');

			$query = 'SELECT id, title'.
					' FROM #__categories'.
					' WHERE section = '.(int) $this->_category->section;
			$this->_db->setQuery($query);
			$this->_cat = $this->_db->loadObjectList();
			foreach ($this->_cat as $data)
			{
				$cati[$data->id] = $data->title;
			}

				// check to determine if section or category has proper access rights
				$rows[$i] = $row;

				$rows[$i]->category1	= $cati[$rows[$i]->catid];
				if ($rows[$i]->catid2 != -1) $rows[$i]->category2	= $cati[$rows[$i]->catid2];
				if ($rows[$i]->catid3 != -1) $rows[$i]->category3	= $cati[$rows[$i]->catid3];

		$query = 'SELECT cc.title AS category, a.id, a.title, a.alias, a.title_alias, a.introtext, a.fulltext, a.sectionid, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by,' .
			' a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.attribs, a.hits, a.images, a.urls, a.ordering, a.metakey, a.metadesc, a.access,' .

		$query = 'SELECT cc.title AS category, a.*,' .

			<?php if ($this->item->params->get('link_category')) : ?>
				<?php echo '</a>'; ?>
			<?php endif; ?>

            <?php if ($this->item->params->get ('link_category') && $this->item->category2) : ?>
				<?php echo ', 
				<a href="'.JRoute::_(ContentHelperRoute::getCategoryRoute ($this->item->catid2, $this->item->sectionid)).'">'; ?>
			<?php endif; ?>
			<?php echo $this->escape ($this->item->category2); ?>
			<?php if ($this->item->params->get ('link_category') && $this->item->category2) : ?>
				<?php echo '</a>'; ?>
			<?php endif; ?>
            <?php if ($this->item->params->get ('link_category') && $this->item->category3) : ?>
				<?php echo ', 
				<a href="'.JRoute::_(ContentHelperRoute::getCategoryRoute ($this->item->catid3, $this->item->sectionid)).'">'; ?>
			<?php endif; ?>
			<?php echo $this->escape ($this->item->category3); ?>
			<?php if ($this->item->params->get ('link_category') && $this->item->category3) : ?>
				<?php echo '</a>'; ?>
			<?php endif; ?>

		<?php echo $this->escape($this->item->category); ?>
			<?php if ($this->item->params->get('link_category')) : ?>
				<?php echo '</a>'; ?>
			<?php endif; ?>

		<?php echo $this->escape($this->item->category1); ?>
		<?php if ($this->item->params->get('link_category')) : ?>
			<?php echo '</a>'; ?>
		<?php endif; ?>
            <?php if ($this->item->params->get ('link_category') && $this->item->category2) : ?>
				<?php echo ', 
				<a href="'.JRoute::_(ContentHelperRoute::getCategoryRoute ($this->item->catid2, $this->item->sectionid)).'">'; ?>
			<?php endif; ?>
			<?php echo $this->escape ($this->item->category2); ?>
			<?php if ($this->item->params->get ('link_category') && $this->item->category2) : ?>
				<?php echo '</a>'; ?>
			<?php endif; ?>
            <?php if ($this->item->params->get ('link_category') && $this->item->category3) : ?>
				<?php echo ', 
				<a href="'.JRoute::_(ContentHelperRoute::getCategoryRoute ($this->item->catid3, $this->item->sectionid)).'">'; ?>
			<?php endif; ?>
			<?php echo $this->escape ($this->item->category3); ?>
			<?php if ($this->item->params->get ('link_category') && $this->item->category3) : ?>
				<?php echo '</a>'; ?>
			<?php endif; ?>

ALTER TABLE `#_content` CHANGE `catid2` `catid2` INT( 11 ) NOT NULL DEFAULT '-1';
ALTER TABLE `#_content` CHANGE `catid3` `catid3` INT( 11 ) NOT NULL DEFAULT '-1';
UPDATE `frip_content` SET catid2 = '-1' WHERE catid2 =0;
UPDATE `frip_content` SET catid3 = '-1' WHERE catid3 =0;

if ($this->_article->catid2 != 0 || $this->_article->catid2 != -1)

if ($this->_article->catid2 != -1)

if ($this->_article->catid3 != 0 || $this->_article->catid3 != -1)

if ($this->_article->catid3 != -1)

<?php if ($this->params->get ('link_category') && $this->article->catid2) : ?>

<?php if ($this->params->get ('link_category') && $this->article->category2) : ?>

<?php if ($this->params->get ('link_category') && $this->article->catid3) : ?>

<?php if ($this->params->get ('link_category') && $this->article->category3) : ?>

<?php if ($row->catid2) : ?>

<?php if ($row->catid2 && $row->catid2!=-1) : ?>

<?php if ($row->catid3) : ?>

<?php if ($row->catid3 && $row->catid3!=-1) : ?>

$javascript = "onchange=\"changeDynaList( 'catid', sectioncategories, document.adminForm.sectionid.options[document.adminForm.sectionid.selectedIndex].value, 0, 0);\"";

$javascript = "onchange=\"changeDynaList ( 'catid', sectioncategories, document.adminForm.sectionid.options[document.adminForm.sectionid.selectedIndex].value, 0, 0);changeDynaList ( 'catid2', sectioncategories, document.adminForm.sectionid.options[document.adminForm.sectionid.selectedIndex].value, 0, 0);changeDynaList ( 'catid3', sectioncategories, document.adminForm.sectionid.options[document.adminForm.sectionid.selectedIndex].value, 0, 0);\"";

			foreach ($cat_list as $cat)
			{
				if ($cat->section == $section->id) {
					$rows2[] = $cat;
				}
			}

			$sectioncategories[$section->id][] = JHTML::_('select.option', '-1', JText::_( 'Select Category' ), 'id', 'title');

				// check to determine if section or category has proper access rights
				$rows[$i] = $row;

				$rows[$i]->category1	= $cati[$rows[$i]->catid];

		<?php echo $this->escape($this->item->category); ?>

		<?php echo $this->escape($this->item->category1); ?>

<a href="<?php echo $row->cat_link; ?>" title="<?php echo JText::_( 'Edit Category' ); ?>">
							<?php echo $row->name; ?></a>

<?php if (($row->catid2 && $row->catid2!=-1) || ($row->catid3 && $row->catid3!=-1)) : ?>
                    	<div class="jpane-toggler"><span><?php echo JText::_( 'SELECT FROM LIST' ); ?></span></div>
                    	<div class="jpane-slider">
						<a href="<?php echo $row->cat_link; ?>" title="<?php echo JText::_( 'Edit Category' ); ?>">
							<?php echo $row->name; ?></a>
                        <?php if ($row->catid2 && $row->catid2!=-1) : ?>
							<hr><a href="<?php echo $row->cat_link2; ?>" title="<?php echo JText::_( 'Edit Category' ); ?>">
							<?php echo $row->name2; ?></a>
						<?php endif; ?>
                        <?php if ($row->catid3 && $row->catid3!=-1) : ?>
							<hr><a href="<?php echo $row->cat_link3; ?>" title="<?php echo JText::_( 'Edit Category' ); ?>">
							<?php echo $row->name3; ?></a>
						<?php endif; ?>
                        </div>
                        <?php else : ?>
                        <a href="<?php echo $row->cat_link; ?>" title="<?php echo JText::_( 'Edit Category' ); ?>">
							<?php echo $row->name; ?></a>
                    <?php endif; ?>

<form action="index.php?option=com_content" method="post" name="adminForm">

		  <script type="text/javascript">
			window.addEvent('domready', function(){ new Accordion($$('div.jpane-toggler'), $$('div.jpane-slider'), {onActive: function(toggler, i) { toggler.addClass('jpane-toggler-down'); toggler.removeClass('jpane-toggler'); },onBackground: function(toggler, i) { toggler.addClass('jpane-toggler'); toggler.removeClass('jpane-toggler-down'); },duration: 300,opacity: false,alwaysHide: true}); });
  		</script>