create a frontend list of all active CBsubs users?

I'm about to upgrade to CB2 and CBsubs 4RC2. Does it have a better way of showing a list of active CBsubs users? I could never find a good way to do that in CB1.9.x - unless someone knows a good way?

I need ot run some SQL queries to force my cb_active field to correctly display whether or not someone is an active CBsubs user or not.

Would this work?

update `j17_comprofiler`as a
inner join `j17_cbsubs_subscriptions` as b
ON b.`user_id` = a.`id`
SET a.`cb_active` = 'Yes'
WHERE b.`status` = "A"

ThePiston wrote: I'm about to upgrade to CB2 and CBsubs 4RC2. Does it have a better way of showing a list of active CBsubs users? I could never find a good way to do that in CB1.9.x - unless someone knows a good way?

I typically use the CBSubs - CB Field integration to set/reset a CB checkbox field based on a CBSubs subscription.

I then use that to filter my CB User list.

been doing that but something is out of whack - I have people set to status=A in the cbsubs DB with an outdated expiry_date for some reason so that's not working. I need to write and execute some queries to reset them all. working on it now

If they're active, but past their expiration date then expirations aren't being triggered in CBSubs regularly enough. Ensure you're running the CRON daily or visiting backend regularly depending on your settings to trigger expirations.

I just checked the cron I made a few years back and the key is now different from the one I'm seeing the CBsubs. Is that ok? Could that be why it wasn't running? I changed the cron to the one I copied today.