function get_message($messageID) #2

    function get_message($messageID)
    {
        // default where
        $this->db->where('t1.siteID', $this->siteID, FALSE);
        $this->db->where('t1.messageID', $this->db->escape($messageID), FALSE);
        $this->db->where('deleted', 0, FALSE);
        $this->db->where('(t2.toUserID = '.$this->session->userdata['userID'].' OR t2.userID = '.$this->session->userdata['userID'].')', NULL, FALSE);

        // get user join
        $this->db->select('t1.*, t2.toUserID, max(unread) as unread, parentID, deleted, users.userID, email, firstName, lastName, displayName, avatar', FALSE);
        $this->db->from('community_messages t1');
        $this->db->limit(1);

        // joins
        $this->db->join('community_messagemap t2', 't2.messageID = t1.messageID ');
        $this->db->join('users', 'users.userID = t1.userID');

        // groups
        $this->db->group_by('messageID');

        // get
        $query = $this->db->get();

        if ($query->num_rows())
        {
            return $query->row_array();
        }
        else
        {
            return FALSE;
        }
    }