The CB Workflows module can also display it. You could also query for pending connection requests using a CB Query Field then display it anywhere that supports substitutions. The below query should work to give you the count.
Code:
SELECT COUNT(*)
FROM `#__comprofiler_members` AS m
LEFT JOIN `#__comprofiler` AS c
ON m.`referenceid` = c.`id`
LEFT JOIN `#__users` AS u
ON m.`referenceid` = u.`id`
WHERE m.`memberid` = '[user_id]'
AND c.`approved` = 1
AND c.`confirmed` = 1
AND c.`banned` = 0
AND u.`block` = 0
AND m.`pending` = 1
For inbox count the below should work.
Code:
SELECT COUNT(*)
FROM `#__uddeim`
WHERE `toid` = '[user_id]'
AND `totrash` = 0
AND `archived` = 0
AND `delayed` = 0
AND `toread` = 0
krileon
