function getTemplate() { if ($this->link_template != '') { return $this->link_template; } else { $cat = new mtCats($this->_db); $cat->load($this->cat_id); if ($cat->cat_template != '') { return $cat->cat_template; } else { return false; } } }
function loadCustomTemplate($cat_id = null, &$savantConf, $template = '') { global $mtconf; $database =& JFactory::getDBO(); if (!empty($template)) { $templateDir = $mtconf->getjconf('absolute_path') . '/components/com_mtree/templates/' . $template; if (is_dir($templateDir)) { $savantConf["template_path"] = $templateDir . '/'; $mtconf->set('template', $template); } } else { $mtCats = new mtCats($database); $mtCats->load($cat_id); if (!empty($mtCats->cat_template)) { $savantConf['template_path'] = $mtconf->getjconf('absolute_path') . "/components/com_mtree/templates/" . $mtCats->cat_template . "/"; $mtconf->set('template', $mtCats->cat_template); } } }
function search($option) { global $mainframe, $mtconf; $database =& JFactory::getDBO(); $search_text = JRequest::getVar('search_text', '', 'post'); $search_where = JRequest::getInt('search_where', 0, 'post'); // 1: Listing, 2: Category $limit = $mainframe->getUserStateFromRequest("viewlistlimit", 'limit', $mtconf->getjconf('list_limit')); $limitstart = $mainframe->getUserStateFromRequest("viewcli{$option}limitstart", 'limitstart', 0); # Detect search command # Quick Go $id_found = 0; if (substr($search_text, 0, 3) == "id:") { $temp = explode(":", $search_text); if (is_numeric($temp[1])) { $id_found = $temp[1]; } } # Search query if ($search_where == 1) { if ($id_found) { $link = new mtLinks($database); $link->load($id_found); if (!empty($link->link_name)) { $mainframe->redirect("index2.php?option=com_mtree&task=editlink&link_id=" . $id_found); } else { $mainframe->redirect("index2.php?option=com_mtree", JText::_('Your search does not return any result')); } } else { // Total Results $database->setQuery('SELECT COUNT(*) FROM #__mt_links ' . "\nWHERE link_name LIKE '%" . $database->getEscaped($search_text, true) . "%'"); $total = $database->loadResult(); // Page Navigation jimport('joomla.html.pagination'); $pageNav = new JPagination($total, $limitstart, $limit); // Links $database->setQuery("SELECT l.*, COUNT(r.rev_id) AS reviews FROM #__mt_links AS l" . "\nLEFT JOIN #__mt_reviews AS r ON r.link_id = l.link_id" . "\nWHERE l.link_name LIKE '%" . $database->getEscaped($search_text, true) . "%'" . "\nGROUP BY l.link_id" . "\nORDER BY l.link_name ASC" . "\nLIMIT " . $pageNav->limitstart . ', ' . $pageNav->limit); } } else { if ($id_found) { $cat = new mtCats($database); $cat->load($id_found); if (!empty($cat->cat_name)) { $mainframe->redirect("index2.php?option=com_mtree&task=editcat&cat_id=" . $id_found); } else { $mainframe->redirect("index2.php?option=com_mtree", JText::_('Your search does not return any result')); } } else { // Total Results $database->setQuery("SELECT COUNT(*) FROM #__mt_cats WHERE cat_name LIKE '%" . $database->getEscaped($search_text, true) . "%'"); $total = $database->loadResult(); // Page Navigation jimport('joomla.html.pagination'); $pageNav = new JPagination($total, $limitstart, $limit); // Categories $database->setQuery("SELECT * FROM #__mt_cats WHERE cat_name LIKE '%" . $database->getEscaped($search_text, true) . "%' ORDER BY cat_name ASC LIMIT {$pageNav->limitstart}, {$pageNav->limit}"); } } $results = $database->loadObjectList(); # Get Pathway $pathWay = new mtPathWay(); # Results Output if ($search_where == 1) { // Links HTML_mtree::searchresults_links($results, $pageNav, $pathWay, $search_where, $search_text, $option); } else { // Categories HTML_mtree::searchresults_categories($results, $pageNav, $pathWay, $search_where, $search_text, $option); } }
function print_startmenu($task, $cat_parent) { global $mtconf; $database =& JFactory::getDBO(); # Count the number of pending links/cats/reviews/reports/claims $database->setQuery("SELECT COUNT(*) FROM #__mt_cats WHERE cat_approved='0'"); $pending_cats = $database->loadResult(); $database->setQuery("SELECT COUNT(*) FROM #__mt_links WHERE link_approved <= 0"); $pending_links = $database->loadResult(); $database->setQuery("SELECT COUNT(*) FROM #__mt_reviews WHERE rev_approved='0'"); $pending_reviews = $database->loadResult(); $database->setQuery("SELECT COUNT(*) FROM #__mt_reports WHERE rev_id = 0 && link_id > 0"); $pending_reports = $database->loadResult(); $database->setQuery("SELECT COUNT(*) FROM #__mt_reviews WHERE ownersreply_text != '' AND ownersreply_approved = '0'"); $pending_reviewsreply = $database->loadResult(); $database->setQuery("SELECT COUNT(*) FROM #__mt_reports WHERE rev_id > 0 && link_id > 0"); $pending_reviewsreports = $database->loadResult(); $database->setQuery("SELECT COUNT(*) FROM #__mt_claims"); $pending_claims = $database->loadResult(); HTML_mtree::print_style(); ?> <table cellpadding="3" cellspacing="0" border="0" width="100%"> <tr> <td align="left" valign="top" width="160" height="0"> <style type="text/css"> </style> <table cellpadding="2" cellspacing="0" border="0" width="160" height="100%" align="left" style="border: 1px solid #cccccc;"> <tr><td colspan="2" style="background: #DDE1E6; border-bottom: 1px solid #cccccc;font-weight:bold;"><?php echo JText::_('Title'); ?> </td></tr> <?php if (!$mtconf->get('admin_use_explorer')) { ?> <tr> <td width="20" align="center" style="background-color:#DDE1E6"><img src="../includes/js/ThemeOffice/home.png" width="16" height="16" /></td> <td width="100%" style="background-color:#F1F3F5"> <a class="mt_menu<?php echo $task == "listcats" || $task == "editcat" || $task == "" ? "_selected" : ""; ?> " href="index2.php?option=com_mtree&task=listcats"><?php echo JText::_('Navigate tree'); ?> </a></td> </tr> <?php } ?> <tr> <td align="center" style="background-color:#DDE1E6"><img src="../components/com_mtree/img/page_white_add.png" width="16" height="16" /></td> <td style="background-color:#F1F3F5"> <a class="mt_menu<?php echo $task == "newlink" ? "_selected" : ""; ?> " href="index2.php?option=com_mtree&task=newlink&cat_parent=<?php echo $cat_parent; ?> "><?php echo JText::_('Add listing'); ?> </a></td> </tr> <tr> <td align="center" style="background-color:#DDE1E6"><img src="../components/com_mtree/img/folder_add.png" width="16" height="16" /></td> <td style="background-color:#F1F3F5"> <a class="mt_menu<?php echo $task == "newcat" ? "_selected" : ""; ?> " href="index2.php?option=com_mtree&task=newcat&cat_parent=<?php echo $cat_parent; ?> "><?php echo JText::_('Add cat'); ?> </a></td> </tr> <?php # Pending Approvals if ($pending_links > 0 or $pending_cats > 0 or $pending_reviews > 0 or $pending_reports > 0 or $pending_reviewsreply > 0 or $pending_reviewsreports > 0 or $pending_claims > 0) { ?> <tr><td colspan="2" style="background: #DDE1E6; border-bottom: 1px solid #cccccc;border-top: 1px solid #cccccc;font-weight:bold;"><?php echo JText::_('Pending approval'); ?> </td></tr> <?php if ($pending_cats > 0) { ?> <tr> <td style="background-color:#DDE1E6"><img src="../components/com_mtree/img/folder.png" width="18" height="18" /></td> <td style="background-color:#F1F3F5"> <a class="mt_menu<?php echo $task == "listpending_cats" ? "_selected" : ""; ?> " href="index2.php?option=com_mtree&task=listpending_cats"><?php echo JText::_('Categories'); ?> (<?php echo $pending_cats; ?> )</a></td> </tr> <?php } if ($pending_links > 0) { ?> <tr> <td style="background-color:#DDE1E6"><img src="../components/com_mtree/img/page_white.png" width="16" height="16" /></td> <td style="background-color:#F1F3F5"> <a class="mt_menu<?php echo $task == "listpending_links" ? "_selected" : ""; ?> " href="index2.php?option=com_mtree&task=listpending_links"><?php echo JText::_('Listings'); ?> (<?php echo $pending_links; ?> )</a></td> </tr> <?php } if ($pending_reviews > 0) { ?> <tr> <td style="background-color:#DDE1E6"><img src="../components/com_mtree/img/comment.png" width="16" height="16" /></td> <td style="background-color:#F1F3F5"> <a class="mt_menu<?php echo $task == "listpending_reviews" ? "_selected" : ""; ?> " href="index2.php?option=com_mtree&task=listpending_reviews"><?php echo JText::_('Reviews'); ?> (<?php echo $pending_reviews; ?> )</a></td> </tr> <?php } if ($pending_reports > 0) { ?> <tr> <td style="background-color:#DDE1E6"><img src="../components/com_mtree/img/error.png" width="16" height="16" /></td> <td style="background-color:#F1F3F5"> <a class="mt_menu<?php echo $task == "listpending_reports" ? "_selected" : ""; ?> " href="index2.php?option=com_mtree&task=listpending_reports"><?php echo JText::_('Reports'); ?> (<?php echo $pending_reports; ?> )</a></td> </tr> <?php } if ($pending_reviewsreply > 0) { ?> <tr> <td style="background-color:#DDE1E6"><img src="../components/com_mtree/img/user_comment.png" width="16" height="16" /></td> <td style="background-color:#F1F3F5"> <a class="mt_menu<?php echo $task == "listpending_reviewsreply" ? "_selected" : ""; ?> " href="index2.php?option=com_mtree&task=listpending_reviewsreply"><?php echo JText::_('Owners replies'); ?> (<?php echo $pending_reviewsreply; ?> )</a></td> </tr> <?php } if ($pending_reviewsreports > 0) { ?> <tr> <td style="background-color:#DDE1E6"><img src="../components/com_mtree/img/error.png" width="16" height="16" /></td> <td style="background-color:#F1F3F5"> <a class="mt_menu<?php echo $task == "listpending_reviewsreports" ? "_selected" : ""; ?> " href="index2.php?option=com_mtree&task=listpending_reviewsreports"><?php echo JText::_('Reviews reports'); ?> (<?php echo $pending_reviewsreports; ?> )</a></td> </tr> <?php } if ($pending_claims > 0) { ?> <tr> <td style="background-color:#DDE1E6"><img src="../components/com_mtree/img/user_green.png" width="16" height="16" /></td> <td style="background-color:#F1F3F5"> <a class="mt_menu<?php echo $task == "listpending_claims" ? "_selected" : ""; ?> " href="index2.php?option=com_mtree&task=listpending_claims"><?php echo JText::_('Claims'); ?> (<?php echo $pending_claims; ?> )</a></td> </tr> <?php } } # End of Pending Approvals # dTree if ($mtconf->get('admin_use_explorer')) { ?> <tr><td colspan="2" style="background: #DDE1E6; border-bottom: 1px solid #cccccc;border-top: 1px solid #cccccc;font-weight:bold;"><?php echo JText::_('Explorer'); ?> </td></tr> <tr><td colspan="2" style="background-color:#F1F3F5;"> <?php $cats = HTML_mtree::getChildren(0, $mtconf->get('explorer_tree_level')); ?> <link rel="StyleSheet" href="components/com_mtree/dtree.css" type="text/css" /> <script type="text/javascript" src="../components/com_mtree/js/dtree.js"></script> <script type="text/javascript"> <!-- fpath = '../components/com_mtree/img/dtree/folder.gif'; d = new dTree('d'); d.config.closeSameLevel = true; d.icon.root = '../includes/js/ThemeOffice/home.png', d.icon.folder = '../components/com_mtree/img/dtree/folder.gif', d.icon.folderOpen = '../components/com_mtree/img/dtree/folderopen.gif', d.icon.node = '../components/com_mtree/img/dtree/page.gif', d.icon.empty = '../components/com_mtree/img/dtree/empty.gif', d.icon.line = '../components/com_mtree/img/dtree/line.png', d.icon.join = '../components/com_mtree/img/dtree/join.png', d.icon.joinBottom = '../components/com_mtree/img/dtree/joinbottom.png', d.icon.plus = '../components/com_mtree/img/dtree/plus.png', d.icon.plusBottom = '../components/com_mtree/img/dtree/plusbottom.png', d.icon.minus = '../components/com_mtree/img/dtree/minus.gif', d.icon.minusBottom = '../components/com_mtree/img/dtree/minusbottom.gif', d.icon.nlPlus = '../components/com_mtree/img/dtree/nolines_plus.gif', d.icon.nlMinus = '../components/com_mtree/img/dtree/nolines_minus.gif' d.add(0,-1,'<?php echo JText::_('Root'); ?> ', 'index2.php?option=com_mtree'); <?php foreach ($cats as $cat) { echo "\nd.add("; echo $cat->cat_id . ","; echo $cat->cat_parent . ","; // Print Category Name echo "'" . addslashes(htmlspecialchars($cat->cat_name, ENT_QUOTES)); echo "',"; echo "pp(" . $cat->cat_id . "),"; echo "'','',"; echo "fpath"; echo ");"; } ?> document.write(d); function pp(cid) { return 'index2.php?option=com_mtree&task=listcats&cat_id='+cid; } //--> </script> </td></tr> <?php } # End of dTree # This Directory if ($task == 'listcats' || $task == 'editcat' || $task == 'editcat_browse_cat' || $task == 'editcat_add_relcat' || $task == 'editcat_remove_relcat') { if ($cat_parent > 0) { # Lookup all information about this directory $thiscat = new mtCats($database); $thiscat->load($cat_parent); ?> <tr><td colspan="2" align="left" style="color: black; padding-left: 20px;font-weight:bold;background: #DDE1E6 url(../components/com_mtree/img/dtree/folderopen.gif) no-repeat center left; border-bottom: 1px solid #cccccc;border-top: 1px solid #cccccc;"><?php echo JText::_('This category'); ?> </td></tr> <tr class="row0"><td colspan="2" style="background-color:#F1F3F5"> <?php $published_img = $thiscat->cat_published ? 'tick.png' : 'publish_x.png'; $featured_img = $thiscat->cat_featured ? 'tick.png' : 'publish_x.png'; $tcat = new mtDisplay(); $tcat->add(JText::_('Name'), '<a href="index2.php?option=com_mtree&task=editcat&cat_id=' . $thiscat->cat_id . '&cat_parent=' . $thiscat->cat_parent . '">' . $thiscat->cat_name . '</a>'); $tcat->add(JText::_('Cat id'), $thiscat->cat_id); $tcat->add(JText::_('Listings'), $thiscat->cat_links); $tcat->add(JText::_('Categories'), $thiscat->cat_cats); $tcat->add(JText::_('Related categories2'), $thiscat->getNumOfRelCats()); $tcat->add(JText::_('Published'), '<img src="images/' . $published_img . '" width="12" height="12" border="0" alt="" />'); $tcat->add(JText::_('Featured'), '<img src="images/' . $featured_img . '" width="12" height="12" border="0" alt="" />'); $tcat->display(); ?> </td></tr> <?php } # This Listing } elseif ($task == 'editlink' || $task == 'editlink_change_cat' || $task == 'reviews_list' || $task == 'newreview' || $task == 'editreview' || $task == 'editlink_browse_cat' || $task == 'editlink_add_cat' || $task == 'editlink_remove_cat') { global $link_id; if ($link_id[0] > 0) { $thislink = new mtLinks($database); $thislink->load($link_id[0]); $database->setQuery('SELECT COUNT(*) FROM #__mt_reviews WHERE link_id = ' . $database->quote($link_id[0]) . ' AND rev_approved = 1'); $reviews = $database->loadResult(); ?> <tr><td colspan="2" align="left" style="color: black; padding-left: 20px;font-weight:bold;background: #DDE1E6 url(../includes/js/ThemeOffice/document.png) no-repeat center left; border-bottom: 1px solid #cccccc;border-top: 1px solid #cccccc;"><?php echo JText::_('This listing'); ?> </td></tr> <tr class="row0"><td colspan="2" style="background-color:#F1F3F5"> <?php $tlisting = new mtDisplay(); $tlisting->add(JText::_('Name'), '<a href="index2.php?option=com_mtree&task=editlink&link_id=' . $thislink->link_id . '">' . $thislink->link_name . '</a>'); $tlisting->add(JText::_('Listing id'), $thislink->link_id); $tlisting->add(JText::_('Category'), '<a href="index2.php?option=com_mtree&task=listcats&cat_id=' . $thislink->cat_id . '">' . $thislink->getCatName() . '</a>'); $tlisting->add(JText::_('Reviews'), '<a href="index2.php?option=com_mtree&task=reviews_list&link_id=' . $thislink->link_id . '">' . $reviews . '</a>'); $tlisting->add(JText::_('Hits'), $thislink->link_hits); $tlisting->add(JText::_('Modified2'), tellDateTime($thislink->link_modified)); $tlisting->display(); ?> </td></tr> <?php } } // Search $search_text = JRequest::getVar('search_text', '', 'post'); $search_where = JRequest::getInt('search_where', 0, 'post'); // 1: Listing, 2: Category ?> <tr><td colspan="2" style="background: #DDE1E6; border-bottom: 1px solid #cccccc;border-top: 1px solid #cccccc;font-weight:bold;"><?php echo JText::_('Search'); ?> </td></tr> <tr><td colspan="2" align="left" style="background-color:#F1F3F5"> <form action="index2.php" method="post"> <input class="text_area" type="text" name="search_text" size="10" maxlength="250" value="<?php echo $search_text; ?> " /> <input type="submit" value="<?php echo JText::_('Search'); ?> " class="button" /> <select name="search_where" class="inputbox" size="1"> <option value="1"<?php echo $search_where == 1 ? ' selected' : ''; ?> ><?php echo JText::_('Listings'); ?> </option> <option value="2"<?php echo $search_where == 2 ? ' selected' : ''; ?> ><?php echo JText::_('Categories'); ?> </option> </select> <a href="index2.php?option=com_mtree&task=advsearch"><?php echo JText::_('Advanced search short'); ?> </a> <input type="hidden" name="option" value="com_mtree" /> <input type="hidden" name="task" value="search" /> <input type="hidden" name="limitstart" value="0" /> </form> </td></tr> <tr><td colspan="2" style="background: #DDE1E6; border-bottom: 1px solid #cccccc;border-top: 1px solid #cccccc;font-weight:bold;"><?php echo JText::_('More'); ?> </td></tr> <tr> <td style="background: #DDE1E6;"><img src="../components/com_mtree/img/zoom.png" width="16" height="16" /></td> <td style="background-color:#F1F3F5"> <a class="mt_menu" href="index2.php?option=com_mtree&task=spy"><?php echo JText::_('Spy directory'); ?> </a></td> </tr> <tr> <td style="background: #DDE1E6;"><img src="../includes/js/ThemeOffice/config.png" width="16" height="16" /></td> <td style="background-color:#F1F3F5"> <a class="mt_menu<?php echo $task == "config" ? "_selected" : ""; ?> " href="index2.php?option=com_mtree&task=config"><?php echo JText::_('Configuration'); ?> </a></td> </tr> <?php /* ?> <tr> <td style="background: #DDE1E6;"><img src="../components/com_mtree/img/table_link.png" width="16" height="16" /></td> <td style="background-color:#F1F3F5"> <a class="mt_menu<?php echo ($task=="linkchecker") ? "_selected": ""; ?>" href="index2.php?option=com_mtree&task=linkchecker"><?php echo JText::_( 'Link checker' ) ?></a></td> </tr> <?php */ ?> <tr> <td style="background: #DDE1E6;"><img src="../includes/js/ThemeOffice/template.png" width="16" height="16" /></td> <td style="background-color:#F1F3F5"> <a class="mt_menu<?php echo $task == "templates" ? "_selected" : ""; ?> " href="index2.php?option=com_mtree&task=templates"><?php echo JText::_('Templates'); ?> </a></td> </tr> <tr> <td style="background: #DDE1E6;"><img src="../includes/js/ThemeOffice/content.png" width="16" height="16" /></td> <td style="background-color:#F1F3F5"> <a class="mt_menu<?php echo $task == "customfields" ? "_selected" : ""; ?> " href="index2.php?option=com_mtree&task=customfields"><?php echo JText::_('Custom fields'); ?> </a></td> </tr> <tr> <td style="background: #DDE1E6;"><img src="../includes/js/ThemeOffice/query.png" width="16" height="16" /></td> <td style="background-color:#F1F3F5"> <a class="mt_menu<?php echo $task == "csv" ? "_selected" : ""; ?> " href="index2.php?option=com_mtree&task=csv"><?php echo JText::_('Export'); ?> </a></td> </tr> <tr> <td style="background: #DDE1E6;"><img src="../includes/js/ThemeOffice/globe3.png" width="16" height="16" /></td> <td style="background-color:#F1F3F5"> <a class="mt_menu" href="index.php?option=com_mtree&task=geocode"><?php echo JText::_('Locate Listings in Map'); ?> </a></td> </tr> <tr> <td style="background: #DDE1E6;"><img src="../includes/js/ThemeOffice/globe3.png" width="16" height="16" /></td> <td style="background-color:#F1F3F5"> <a class="mt_menu" href="index2.php?option=com_mtree&task=globalupdate"><?php echo JText::_('Recount categories listings'); ?> </a></td> </tr> <tr> <td style="background: #DDE1E6;"><img src="../includes/js/ThemeOffice/credits.png" width="16" height="16" /></td> <td style="background-color:#F1F3F5"> <a class="mt_menu<?php echo $task == "about" ? "_selected" : ""; ?> " href="index2.php?option=com_mtree&task=about"><?php echo JText::_('About mosets tree'); ?> </a></td> </tr> </table> </td> <td valign="top"> <?php }