Query field Kunena new messages

I was able to use a CB query field to get the count of unread uddeIM messages:

SELECT COUNT(*) FROM `#__uddeim` WHERE `toid`='[user_id]' AND `toread`='0';

Can you give me the CB query to get the count of new messages in a category in Kunena for a given user?

Can you give me the CB query to get the count of new messages in a category in Kunena for a given user?

Please understand I am not here to write custom code or queries for you on request. I can provide you with simple examples at best, which you already have above. You'll need to review the Kunena database table to write a query based off that.

Your post also would make better sense in the Kunena forums as we are not the developers of Kunena and did not create its database structure. Once you've the query you would replace the user id usage in it with '[user_id]' to substitute in the user id for CB Query Field usage.

With that said the below would probably work. Consult with Kunena for further help on writing Kunena queries. Note this may also be outside their scope of support as writing custom code for you is not support, sorry.

I poured through the kunena files and found the variable that holds the new messages count value I want. Is there a way to display php variables in the query field?

No, for that you need to use a CB Code Field which can display the results of PHP as a field value.

I can't get the code field to work.
If I put this in the code box to test:

return 'Age';

should I not see the text "Age"?

Yes, you should see the word Age displayed. Ensure you are not including the php open and close tags as your code is parsed as an anonymous PHP function. Enable debug mode and maximum error reporting during testing to ensure no errors are occurring. Please ensure you're correctly using the Code fieldtype and not code validation or a code select type.