How could I display total # of subscribers? Help Please

[Boofo]

Originally Posted by KirbyDE

My fault - it's status not active

Typo man has struck again! LMAO

[Andreas]

Nah, that wasn't a typo - just bad (brain) memory.
I don't deal with the subscriptionlog table that often you know.

[Boofo]

True, but it was still classic.

[TrickyD]

Thanks again for all the help guys, hopefully this is the last I have to bug you about this particular hack.

So I ran the query with the prefix and updated code as

[sql]select count(*) from cmq_subscriptionlog where status=1[/sql]
And it returned the correct number, 95.

So then I entered the following in the plugin manager for the global_start

PHP Code:

$subscribers = $db->query_first("SELECT COUNT(*) AS totalactive FROM " . TABLE_PREFIX . "subscriptionlog WHERE status=1");
$subscribers['totalactive'] = vb_number_format($subscribers['totalactive']); 


I went into my header template and entered $subscribers at the top of the template and saved it.

But when I went back to my board to check it, it displalyed ARRAY

What'd I screw up this time :dead:

[calorie]

Use $subscribers[totalactive] in the template.

[TrickyD]

Originally Posted by calorie

Use $subscribers[totalactive] in the template.

Fantastic, works perfect now.

I'd like to throw out one last thank you to all.

[TrickyD]

I know this thread is from back in 2005, but this mod is still working and has been a huge asset to my forum.

But I've grown and have added other subscriptions.

Here is my question...

How can I modify this code to only count the total active subscribers in a specific subscription?

$subscribers = $db->query_first("SELECT COUNT(*) AS totalactive FROM " . TABLE_PREFIX . "subscriptionlog WHERE status=1");
$subscribers['totalactive'] = vb_number_format($subscribers['totalactive']);

I'm assuming a I need a "subscriptionid=1" in there somewhere?

[psylenced]

Originally Posted by TrickyD

How can I modify this code to only count the total active subscribers in a specific subscription?

$subscribers = $db->query_first("SELECT COUNT(*) AS totalactive FROM " . TABLE_PREFIX . "subscriptionlog WHERE status=1");
$subscribers['totalactive'] = vb_number_format($subscribers['totalactive']);

I'm assuming a I need a "subscriptionid=1" in there somewhere?

That is correct:

PHP Code:

$subscribers = $db->query_first("SELECT COUNT(*) AS totalactivesub1 FROM " . TABLE_PREFIX . "subscriptionlog WHERE status=1 AND subscriptionid = 1");
$subscribers['totalactivesub1'] = vb_number_format($subscribers['totalactivesub1']);