No Module.. how to get subscription info?

You have to include API file

include_once JPATH_ROOT.'/components/com_emerald/api.php';
$subscr = EmeraldHelper::getUserActiveSubscriptions();

Where $subscr is an array or user active subscriptions. Just shift first array element and use it's ctime and extreme properties for dates and acceess_count to show now many times it was used. And also access_limit to calculate how many times left.

Following... Nice (and obvious) idea to show this info in Profile context. Would like to see this in a CB tab or even CB login module ;-)

Alternative / SQL queries !?

No Emerald API usage, no custom CB plugin, no custom module.
Integration via SQL queries through CB-AutoActions or CB-Query field. This would allow t ocollect the infos from DB tables for current user. Can you provide example queries or some hints?

pepperstreet Can you provide example queries or some hints?

Unfortunately I am not aware of CB yet. Have тмук worked with it. So I cannot make example of code as I do not know how it works.

Sergey

pepperstreet Can you provide example queries or some hints?

Unfortunately I am not aware of CB yet. Have тмук worked with it. So I cannot make example of code as I do not know how it works.

CB knowledge is just needed for special CB plugin/tab creation. The mentioned alternatives work with custom SQL queries. So, only Emerald table and field relations are of interest.

Then I simply cannot understand what you are talking about :)

Sergey Then I simply cannot understand what you are talking about :)

NP. I am talking of the same subscription infos mentioned in the initial post.

Guest I want to do is add the users "time left", "limit" & "limit left"

How to "translate" this into SQL queries. So, without using the Emerald API.

pepperstreet Following... Nice (and obvious) idea to show this info in Profile context. Would like to see this in a CB tab or even CB login module ;-)

Alternative / SQL queries !?

No Emerald API usage, no custom CB plugin, no custom module.

Integration via SQL queries through CB-AutoActions or CB-Query field. This would allow t ocollect the infos from DB tables for current user. Can you provide example queries or some hints?

Maybe obsolete, because of new features in Emerald and CB 2.0 ?!

• Emerald content plugin has new [PLACEHOLDERS] to show subscription related infos
• CB 2.0 fields have layouts/templates which can fire content plugins.

(Interesting possibilities. Not tested, yet)

However, an Emerald module for User/Plans Infos would be a nice addition.