- $thumb = q("SELECT `thumb` FROM `contact` WHERE `uid` = %d AND `name` = '%s' AND `nick` = '%s' AND (`network` = '%s' OR `self` = 1)",
- intval($a->user['uid']),
- dbesc($id['username']),
- dbesc($id['nickname']),
- dbesc(NETWORK_DFRN)
- );
- $identities[$key][thumb] = $thumb[0][thumb];
-
- $identities[$key]['selected'] = (($id['nickname'] === $a->user['nickname']) ? true : false);
+ $thumb = q("SELECT `thumb` FROM `contact` WHERE `uid` = '%s' AND `self` = 1",
+ dbesc($id['uid'])
+ );
+
+ $identities[$key]['thumb'] = $thumb[0]['thumb'];
+
+ $identities[$key]['selected'] = ($id['nickname'] === $a->user['nickname']);
+
+ $notifications = 0;
+
+ $r = q("SELECT DISTINCT(`parent`) FROM `notify` WHERE `uid` = %d AND NOT `seen` AND NOT (`type` IN (%d, %d))",
+ intval($id['uid']), intval(NOTIFY_INTRO), intval(NOTIFY_MAIL));
+
+ if (dbm::is_result($r)) {
+ $notifications = sizeof($r);
+ }
+
+ $r = q("SELECT DISTINCT(`convid`) FROM `mail` WHERE `uid` = %d AND NOT `seen`",
+ intval($id['uid']));
+
+ if (dbm::is_result($r)) {
+ $notifications = $notifications + sizeof($r);
+ }
+
+ $r = q("SELECT COUNT(*) AS `introductions` FROM `intro` WHERE NOT `blocked` AND NOT `ignore` AND `uid` = %d",
+ intval($id['uid']));
+
+ if (dbm::is_result($r)) {
+ $notifications = $notifications + $r[0]["introductions"];
+ }
+
+ $identities[$key]['notifications'] = $notifications;