The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#11
|
||||
|
||||
Quote:
|
#12
|
||||
|
||||
Nah, that wasn't a typo - just bad (brain) memory.
I don't deal with the subscriptionlog table that often you know. |
#13
|
||||
|
||||
True, but it was still classic.
|
#14
|
|||
|
|||
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:
But when I went back to my board to check it, it displalyed ARRAY What'd I screw up this time :dead: |
#15
|
|||
|
|||
Use $subscribers[totalactive] in the template.
|
#16
|
|||
|
|||
Quote:
I'd like to throw out one last thank you to all. |
#17
|
|||
|
|||
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? Code:
$subscribers = $db->query_first("SELECT COUNT(*) AS totalactive FROM " . TABLE_PREFIX . "subscriptionlog WHERE status=1"); $subscribers['totalactive'] = vb_number_format($subscribers['totalactive']); |
#18
|
|||
|
|||
Quote:
PHP Code:
|
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|