function shAppendCat($cat_id, $option, $shLangName)
{
$sefConfig =& Sh404sefFactory::getConfig();
$sef = array();
$pathWay = new mtPathWay($cat_id);
$pathway_ids = $pathWay->getPathWay($cat_id);
switch ($sefConfig->shMTreeInsertCategories) {
case '1':
// only last cat
if ($cat_id > 0) {
//this is not root we must use this cat
$sef[] = ($sefConfig->shMTreeInsertCategoryId ? $cat_id . $sefConfig->replacement : '') . $pathWay->getCatName($cat_id);
}
//else // this is root, don't add cat name
shRemoveFromGETVarsList('cat_id');
break;
case '0':
// if no cat, we still put them all. This param only applies to listing links
// if no cat, we still put them all. This param only applies to listing links
case '2':
// we want all cats
foreach ($pathway_ids as $id) {
$sef[] = ($sefConfig->shMTreeInsertCategoryId ? $id . $sefConfig->replacement : '') . $pathWay->getCatName($id);
}
// If curreny category is not root, append to sefstring
if ($cat_id > 0) {
$sef[] = ($sefConfig->shMTreeInsertCategoryId ? $cat_id . $sefConfig->replacement : '') . $pathWay->getCatName($cat_id);
}
shRemoveFromGETVarsList('cat_id');
break;
}
return $sef;
}
function smartCountUpdate_catMove($old_cat_parent, $new_cat_parent, $cat_links, $cat_cats)
{
$database =& JFactory::getDBO();
// Add $old_cat_parent to $old_ancestors array first
$old_ancestors = mtPathWay::getPathWay($old_cat_parent);
$old_ancestors[] = $old_cat_parent;
$new_ancestors = mtPathWay::getPathWay($new_cat_parent);
$new_ancestors[] = $new_cat_parent;
if (count($old_ancestors) > 0) {
foreach ($old_ancestors as $old_ancestor) {
if ($old_ancestor > 0) {
$database->setQuery("UPDATE #__mt_cats SET cat_cats = cat_cats - " . intval($cat_cats) . ", cat_links = cat_links - " . intval($cat_links) . " WHERE cat_id = {$old_ancestor}");
$database->query();
}
}
}
if (count($new_ancestors) > 0) {
foreach ($new_ancestors as $new_ancestor) {
if ($new_ancestor > 0) {
$database->setQuery("UPDATE #__mt_cats SET cat_cats = cat_cats + " . intval($cat_cats) . ", cat_links = cat_links + " . intval($cat_links) . " WHERE cat_id = {$new_ancestor}");
$database->query();
}
}
}
return true;
}
function plugin($cat_id, $attr = null)
{
require_once JPATH_ROOT . DS . 'administrator' . DS . 'components' . DS . 'com_mtree' . DS . 'admin.mtree.class.php';
$mtPathWay = new mtPathWay($cat_id);
$cat_ids = $mtPathWay->getPathWay();
$cat_ids[] = $cat_id;
$cat_names = array();
if (empty($cat_ids[0])) {
$cat_names[] = JText::_('Root');
}
foreach ($cat_ids as $cid) {
// Do not add 'Root' name since its done above already
if ($cid > 0) {
$cat_names[] = $mtPathWay->getCatName($cid);
}
}
$html = '<a href="';
$html .= JRoute::_('index.php?option=com_mtree&task=listcats&cat_id=' . $cat_id);
$html .= '"';
# Insert attributes
if (is_array($attr)) {
// from array
foreach ($attr as $key => $val) {
$key = htmlspecialchars($key);
$val = htmlspecialchars($val);
$html .= " {$key}=\"{$val}\"";
}
} elseif (!is_null($attr)) {
// from scalar
$html .= " {$attr}";
}
# set the listing text, close the tag
$html .= '>' . htmlspecialchars(implode(JText::_('Arrow'), $cat_names)) . '</a> ';
return $html;
}
function updateCatCount($inc = 1)
{
if ($this->cat_id <= 0) {
return false;
} else {
$cat_parent_ids = mtPathWay::getPathWay($this->cat_id);
if (!empty($cat_parent_ids)) {
$cat_parent_ids2 = implode(',', $cat_parent_ids);
//echo $cat_parent_ids2;
if ($inc < 0) {
$this->_db->setQuery('UPDATE #__mt_cats SET cat_cats = (cat_cats - ABS(' . intval($inc) . ')) WHERE cat_id IN (' . $cat_parent_ids2 . ')');
} else {
$this->_db->setQuery('UPDATE #__mt_cats SET cat_cats = (cat_cats + ABS(' . intval($inc) . ')) WHERE cat_id IN (' . $cat_parent_ids2 . ')');
}
if (!$this->_db->query()) {
echo "<script> alert('" . $this->_db->getErrorMsg() . "'); window.history.go(-1); </script>\n";
return false;
}
}
return true;
}
}
function findCatID($cat_names)
{
global $mtconf;
$db =& JFactory::getDBO();
if (count($cat_names) == 0) {
return 0;
}
for ($i = 0; $i < count($cat_names); $i++) {
$cat_names[$i] = preg_replace('/:/', '-', $cat_names[$i], 1);
}
// (1)
// First Attempt will try to search by category's alias.
// If it returns one result, then this is most probably the correct category
$db->setQuery("SELECT cat_id, cat_parent, alias FROM #__mt_cats WHERE cat_published='1' AND cat_approved='1' && alias = " . $db->quote($cat_names[count($cat_names) - 1]));
$cat_ids = $db->loadObjectList();
if (count($cat_ids) == 1 && $cat_ids[0]->cat_id > 0) {
return $cat_ids[0]->cat_id;
} else {
// (2)
// Second attempt will load each matches above for their pathway cat_ids
if (!class_exists('mtPathWay')) {
require_once $mtconf->getjconf('absolute_path') . '/administrator/components/com_mtree/admin.mtree.class.php';
}
$pathway_matches = array();
$i = 0;
foreach ($cat_ids as $cat_id) {
$pathWay = new mtPathWay($cat_id->cat_id);
$pathway_ids = $pathWay->getPathWay($cat_id->cat_id);
// Only matches the category that has the same number of level
if (count($cat_names) - 1 == count($pathway_ids)) {
$pathway_matches[$i]->pathway_ids = $pathway_ids;
$pathway_matches[$i]->cat = $cat_id;
$i++;
}
}
// There is only one match, return the result
if (count($pathway_matches) == 1) {
return $pathway_matches[0]->cat->cat_id;
} else {
// There is more than one result, we have to do another round of check based on their aliases
// There are at least 2 matches and all of them have the same number of levels
// First, get all the alias of all matching pathways.
$select_cat_ids = array();
foreach ($pathway_matches as $pathway_match) {
$select_cat_ids = array_merge($select_cat_ids, $pathway_match->pathway_ids);
}
if (!empty($select_cat_ids)) {
$db->setQuery('SELECT cat_id, alias FROM #__mt_cats WHERE cat_id IN (' . implode(', ', $select_cat_ids) . ') LIMIT ' . count($select_cat_ids));
$cat_aliases = $db->loadObjectList('cat_id');
// Now for each pathway matches, look through their aliases and look for matches against the SEF URLs
foreach ($pathway_matches as $pathway_match) {
$matched = true;
for ($i = count($pathway_match->pathway_ids) - 1; $i >= 0; $i--) {
$cat_id = $pathway_match->pathway_ids[$i];
if ($cat_aliases[$cat_id]->alias == $cat_names[$i]) {
$matched = true;
} else {
$matched = false;
continue 2;
}
}
if ($matched) {
return $pathway_match->cat->cat_id;
}
}
}
}
}
}
function mtAppendPathWay($option, $task, $cat_id = 0, $link_id = 0, $img_id = 0)
{
global $mainframe, $Itemid;
$database =& JFactory::getDBO();
$mtPathWay = new mtPathWay();
$pathway =& $mainframe->getPathway();
switch ($task) {
case "listcats":
case "addcategory":
// Show "Add Category Path?"
$cids = $mtPathWay->getPathWay($cat_id);
break;
case "viewlink":
case "writereview":
case "rate":
case "recommend":
case "viewgallery":
$mtLink = new mtLinks($database);
$mtLink->load($link_id);
$cat_id = $mtLink->getCatID();
$cids = $mtPathWay->getPathWay($cat_id);
break;
case "viewimage":
if ($img_id > 0) {
$database->setQuery('SELECT link_id FROM #__mt_images WHERE img_id = \'' . $img_id . '\' LIMIT 1');
$link_id = $database->loadResult();
if (!is_null($link_id)) {
$mtLink = new mtLinks($database);
$mtLink->load($link_id);
$cat_id = $mtLink->getCatID();
$cids = $mtPathWay->getPathWay($cat_id);
}
}
break;
// Adding listing from a category
// Adding listing from a category
case "addlisting":
if ($cat_id > 0) {
$cids = $mtPathWay->getPathWay($cat_id);
} elseif ($link_id > 0) {
$mtLink = new mtLinks($database);
$mtLink->load($link_id);
$cat_id = $mtLink->getCatID();
$cids = $mtPathWay->getPathWay($cat_id);
}
// Show "Add Listing" Path?
break;
case "listnew":
$pathway->addItem(JText::_('New listing'));
break;
case "listfeatured":
$pathway->addItem(JText::_('Featured listing'));
break;
case "listpopular":
$pathway->addItem(JText::_('Popular listing'));
break;
case "listmostrated":
$pathway->addItem(JText::_('Most rated listing'));
break;
case "listtoprated":
$pathway->addItem(JText::_('Top rated listing'));
break;
case "listmostreview":
$pathway->addItem(JText::_('Most reviewed listing'));
break;
case "advsearch":
$pathway->addItem(JText::_('Advanced search'));
break;
case "advsearch2":
$pathway->addItem(JText::_('Advanced search results'));
break;
case "search":
$pathway->addItem(JText::_('Search results'));
break;
}
if (isset($cids) && is_array($cids) && count($cids) > 0) {
foreach ($cids as $cid) {
$pathway->addItem($mtPathWay->getCatName($cid), "index.php?option={$option}&task=listcats&cat_id={$cid}");
}
// Append the curreny category name
$pathway->addItem($mtPathWay->getCatName($cat_id), "index.php?option={$option}&task=listcats&cat_id={$cat_id}");
} elseif ($cat_id > 0) {
$pathway->addItem($mtPathWay->getCatName($cat_id), "index.php?option={$option}&task=listcats&cat_id={$cat_id}");
}
if (in_array($task, array("viewlink", "writereview", "rate", "recommend", "viewgallery"))) {
$pathway->addItem($mtLink->link_name, "index.php?option={$option}&task=viewlink&link_id={$link_id}");
}
}
