vB Custom Pages

[GCSkye]

I noticed in vbcustom pages the following is needed to put placed in to include forum stats on the page:

PHP Code:

// get special data templates from the datastore
$specialtemplates = array(
    'userstats'
); 


Where exactly is it pulling this from? I am hoping it will help me with the following matter:
https://vborg.vbsupport.ru/showthrea...74#post1757574

[Lynne]

If you are using a template to spit something out, then yes, it does need to be included in one of the arrays at the top of the page. I'm not sure, but your problem may be that you are trying to get the forumcount for a forum you have asked not to have post counts. So, I'm not sure if the postcounts are available for that forum in the forumcache. You'd have to check that. I know there are several threads here about getting the post counts in specific forums, you might want to try a search.

[GCSkye]

I'm trying to get forum threads and posts to all count on the forum stats at the bottom of the page regardless of forum rules.

http://evercube.net/forum/

You will notice the header thread count is different than the footer thread count. The header stats are counting all the threads on the site while the footer is only counting forums that have permission to count posts.

This is what the header is calling:

PHP Code:

$numbersmembers = $db->query_first("SELECT COUNT(*) AS users,MAX(userid) AS max FROM " . TABLE_PREFIX . "user");   
$numbermembers = number_format($numbersmembers['users']);   
$counter = $db->query_first("SELECT COUNT(postid) AS posts, COUNT(threadid) AS threads FROM " . TABLE_PREFIX . "post");  
$totalposts=number_format($counter['posts']);   
$countthreads = $db->query_first("SELECT COUNT(*) AS threads FROM " . TABLE_PREFIX . "thread");  
$totalthreads=number_format($countthreads['threads']); 


[Mr-Moo]

I cannot help but feel this should have been included in your other thread:
https://vborg.vbsupport.ru/showthread.php?t=207005.

I will review this and see what I can come up for you.

// Edit //

Have you attempted the following:

Find:

PHP Code:

$totalthreads = 0;
$totalposts = 0;
if (is_array($vbulletin->forumcache))
{
    foreach ($vbulletin->forumcache AS $forum)
    {
        $totalthreads += $forum['threadcount'];
        $totalposts += $forum['replycount'];
    }
}
$totalthreads = vb_number_format($totalthreads);
$totalposts = vb_number_format($totalposts); 


Replace with:

PHP Code:

$counter = $db->query_first("SELECT COUNT(postid) AS posts, COUNT(threadid) AS threads FROM " . TABLE_PREFIX . "post");  
$totalposts=number_format($counter['posts']);   
$countthreads = $db->query_first("SELECT COUNT(*) AS threads FROM " . TABLE_PREFIX . "thread");  
$totalthreads=number_format($countthreads['threads']); 


[GCSkye]

Alright, basically all I am asking is where is the footer stats on vbulletin calling from?

If you can tell me that, just need to have them be changed to call like the header stats.

--- Edit

I'll try it

--- Edit

Thanks a bunch worked prefect.

[Mr-Moo]

Glad I could help You may want to post in your other thread that this issue was resolved.

Thank you!

[Dismounted]

You know that doing that will run 6 queries on forumhome, and that's not even doing much?

To answer your question, the $specialtemplates array is anything the page needs fetched from the datastore.