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>';
}
