public static function showmenu() { $db = JFactory::getDBO(); $query = "SELECT * FROM `#__menu` WHERE `alias` = 'OSE Membership™'"; $db->setQuery($query); $results = $db->loadResult(); if (empty($results)) { $query = "UPDATE `#__menu` SET `alias` = 'OSE Membership™', `path` = 'OSE Membership™', `published`=1, `img` = '\"components/com_osemsc/favicon.ico\"' WHERE `component_id` = ( SELECT extension_id FROM `#__extensions` WHERE `element` ='com_osemsc') AND `client_id` = 1 "; $db->setQuery($query); $db->query(); } self::$extension = self::getExtensionName(); $view = JRequest::getVar('view'); echo '<div class="menu-search">'; echo '<ul>'; echo '<li '; echo $view == 'memberships' ? 'class="current"' : ''; echo '><a href="index.php?option=' . self::$extension . '&view=memberships">' . JText::_('MEMBERSHIP_MANAGEMENT') . '</a></li>'; echo '<li '; echo $view == 'members' ? 'class="current"' : ''; echo '><a href="index.php?option=' . self::$extension . '&view=members">' . JText::_('MEMBER_MANAGEMENT') . '</a></li>'; echo '<li '; echo $view == 'orders' ? 'class="current"' : ''; echo '><a href="index.php?option=' . self::$extension . '&view=orders">' . JText::_('ORDER_MANAGEMENT') . '</a></li>'; echo '<li '; echo $view == 'coupons' ? 'class="current"' : ''; echo '><a href="index.php?option=' . self::$extension . '&view=coupons">' . JText::_('COUPON_MANAGEMENT') . '</a></li>'; echo '<li '; echo $view == 'emails' ? 'class="current"' : ''; echo '><a href="index.php?option=' . self::$extension . '&view=emails">' . JText::_('TEMPLATES') . '</a></li>'; echo '<li '; echo $view == 'config' ? 'class="current"' : ''; echo '><a href="index.php?option=' . self::$extension . '&view=config">' . JText::_('CONFIGURATION') . '</a></li>'; echo '<li '; echo $view == 'profile' ? 'class="current"' : ''; echo '><a href="index.php?option=' . self::$extension . '&view=profile">' . JText::_('CUSTOM_PROFILE') . '</a></li>'; echo '<li '; echo $view == 'addons' ? 'class="current"' : ''; echo '><a href="index.php?option=' . self::$extension . '&view=addons">' . JText::_('ADDONS') . '</a></li>'; echo '<li '; echo $view == 'aboutose' ? 'class="current"' : ''; echo '><a href="index.php?option=' . self::$extension . '&view=aboutose">' . JText::_('ABOUTOSE') . '</a></li>'; echo '</ul></div>'; }