Добавляем вкладку с отображением количества личных сообщений - Kunena

DEFINE('_KUNENA_MY_DISCUSSIONS', 'Мои обсуждения');

DEFINE('_KUNENA_MY_PRIVATEMESSAGE', 'Личные сообщения');

function GetShowMyLatestLink($name, $rel='nofollow')
    {
        return CKunenaLink::GetSefHrefLink(KUNENA_LIVEURLREL.'&func=mylatest', $name, '', $rel);
    }

function GetShowMyPrivateMes($name, $rel='nofollow')
    {
        return CKunenaLink::GetSefHrefLink('index.php/component/uddeim/', $name, '', $rel);
    }

if ($fbConfig->enablehelppage)
    {
        $header .= ' <li ';
        if ($func == 'faq' ) $header .= ' class="Kunena_item_active" ';
        $header .= ' >'.CKunenaLink::GetHelpLink($fbConfig, '<span>'.(array_key_exists('help', $fbIcons)? '<img src="' . KUNENA_URLICONSPATH . $fbIcons['help'] . '" border="0" alt="' . _GEN_HELP . '" title="' . _GEN_HELP . '"/>' : _GEN_HELP).'</span>');
        $header .= '</li>';
	}

if ($my_id != 0)
    {
	    $header .= ' <li ';
	    if ($func == 'mylatest') $header .= ' class="Kunena_item_active" ';
		
		if (!(defined('_JEXEC') || defined('_VALID_MOS'))) { die( 'Direct Access to this location is not allowed.' ); }

//$udd_sql="SELECT a.*, b.username AS displayname FROM #__uddeim AS a LEFT JOIN #__users AS b ON a.fromid=b.id WHERE a.toread=0 AND a.totrash=0 AND a.toid=".(int)$udd_userid." ORDER BY a.datum";
$udd_sql="SELECT a.*, b.username AS displayname FROM jos_uddeim AS a LEFT JOIN jos_users AS b ON a.fromid=b.id WHERE a.toread=0 AND a.totrash=0 AND a.toid=".(int)$my_id." ORDER BY a.datum";
$res=mysql_query($udd_sql);
$mecount = 0;
while ($myrow=mysql_fetch_array($res)){
$mecount++;
//echo $my_id;
};
if ($mecount>0){
	    $header .=' >'.CKunenaLink::GetShowMyPrivateMes('<span>'.(array_key_exists('showmylatest', $fbIcons)? '<img src="' . _KUNENA_MY_PRIVATEMESSAGE . $fbIcons['showmylatest'] . '" border="0" alt="' . _KUNENA_MY_PRIVATEMESSAGE . '" title="' . _KUNENA_MY_PRIVATEMESSAGE . '"/>' : _KUNENA_MY_PRIVATEMESSAGE.'( '.$mecount).' )</span>');
	}
else{
		$header .=' >'.CKunenaLink::GetShowMyPrivateMes('<span>'.(array_key_exists('showmylatest', $fbIcons)? '<img src="' . _KUNENA_MY_PRIVATEMESSAGE . $fbIcons['showmylatest'] . '" border="0" alt="' . _KUNENA_MY_PRIVATEMESSAGE . '" title="' . _KUNENA_MY_PRIVATEMESSAGE . '"/>' : _KUNENA_MY_PRIVATEMESSAGE).'</span>');
};
	$header .= '</li>';
    }

$udd_sql="SELECT a.*, b.username AS displayname FROM jos_uddeim AS a LEFT JOIN jos_users AS b ON a.fromid=b.id WHERE a.toread=0 AND a.totrash=0 AND a.toid=".(int)$my_id." ORDER BY a.datum";
$res=mysql_query($udd_sql);

mysql_connect("localhost", "mysql_user", "mysql_password") or
        die("Could not connect: " . mysql_error());
    mysql_select_db("mydb");