+
+ $myurl = $a->get_baseurl() . '/profile/' . $a->user['nickname'] ;
+ $r = q("SELECT COUNT(*) AS `total` FROM `mail`
+ WHERE `uid` = %d AND `seen` = 0 AND `from-url` != '%s' ",
+ intval(local_user()),
+ dbesc($myurl)
+ );
+
+ $mail = $r[0]['total'];
+