Joomla!

global $jdb;
// Private mesages
if ($user->data['user_id'] != ANONYMOUS)
{
    $this->_tpldata['.'][0]['S_DISPLAY_PM'] = true;
    $this->_tpldata['.'][0]['U_PRIVATEMSGS'] = '/index.php?option=com_uddeim';
    $result = $jdb->sql_query('SELECT COUNT(*) AS `count` FROM `'.JOS_.'uddeim` `pm`, `'.JOS_.'users` `u` WHERE pm.toread = 0 AND u.username = "'.$jdb->sql_escape($user->data['username']).'" AND pm.toid = u.id');
    $row = $jdb->sql_fetchrow($result);
    $jdb->sql_freeresult($result);
    $this->_tpldata['.'][0]['PRIVATE_MESSAGE_INFO'] = str_replace('<strong>0</strong>', '<strong>'.$row['count'].'</strong>', $this->_tpldata['.'][0]['PRIVATE_MESSAGE_INFO']);
}

// Posts
if ($this->_tpldata['postrow']) {
    foreach ($this->_tpldata['postrow'] as &$row) {
        $user_data = get_joomla_user_data($row['POST_AUTHOR']);
        // avatars in posts
        $row['POSTER_AVATAR'] = $user_data['avatar'];
        // PM links
        if ((int)$user_data['id']) {
            $row['U_PM'] = '/index.php?option=com_uddeim&task=new&recip='.(int)$user_data['id'];
        }
    }
}