vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   Modification Requests/Questions (Unpaid) (https://vborg.vbsupport.ru/forumdisplay.php?f=112)
-   -   phpinclude_start trouble - Forum Stats in Header (https://vborg.vbsupport.ru/showthread.php?t=95421)

Neutral Singh 09-01-2005 04:10 AM
phpinclude_start trouble - Forum Stats in Header
 
Hi

There used to be smart little Forum stats hack which enabled me to show some important forum stats like no. of members, posts, threads etc in the header template to be shown on each forum page. In vB3.0.7, i could do it simply by putting the following code in the phpinclude_start template and then call the variables in header template.

Now with the advent of vB3.5, phpinclude_start has been removed and global_start hook has taken its place. I tried to create a plugin by using global_start hook and putting exactly the same code (below) in that plugin but as expected it resulted in an error.

How can use the plugin system to show the information in the header template? I believe some minor changes in the following code would do the trick but my expertise in PHP are pretty novice. Please guide me.

Thanks.


Code:
// forum stats start
        $numbersmembers=$DB_site->query_first('SELECT COUNT(*) AS users,MAX(userid) AS max FROM user');
        $numbermembers=number_format($numbersmembers['users']);
        $countposts=$DB_site->query_first('SELECT COUNT(*) AS posts FROM post');
        $totalposts=number_format($countposts['posts']);
        $countthreads=$DB_site->query_first('SELECT COUNT(*) AS threads FROM thread');
        $totalthreads=number_format($countthreads['threads']);
// forum stats end

// total online start
        $datecut = TIMENOW - $vboptions['cookietimeout'];
        $headerguests=$DB_site->query_first("SELECT COUNT(*) AS count FROM session WHERE userid=0 AND lastactivity>$datecut");
        $headerusers=$DB_site->query_first("SELECT COUNT(DISTINCT(userid)) AS count FROM session WHERE session.userid>0 AND session.lastactivity>$datecut");
        $headerguests=$headerguests[count];
        $headerusers=$headerusers[count];
        $totalonline=$headerguests+$headerusers;
// total online end

// get newest member name and userid start
        $getnewestmember=$DB_site->query_first("SELECT userid, username FROM user WHERE userid=$numbersmembers[max]");
        $newusername = $getnewestmember['username'];
        $newuserid = $getnewestmember['userid'];
// get newest member name and userid end

Boofo 09-02-2005 12:13 AM
First of all, this has changed:

$DB_site

Fix those and that will definately help. ;)

Andreas 09-02-2005 12:31 AM
Try

PHP Code:
// forum stats start 
$numbersmembers = $db->query_first("SELECT COUNT(*) AS users,MAX(userid) AS max FROM 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']); 
$totalthreads=number_format($counter['threads']); 
// forum stats end 

// total online start 
$datecut = TIMENOW - $vbulletin->options['cookietimeout']; 
$headerguests=$db->query_first("SELECT COUNT(*) AS count FROM " . TABLE_PREFIX . "session WHERE userid=0 AND lastactivity>$datecut"); 
$headerusers=$db->query_first("SELECT COUNT(DISTINCT(userid)) AS count FROM " . TABLE_PREFIX . "session WHERE session.userid>0 AND session.lastactivity>$datecut"); 
$headerguests=$headerguests[count]; 
$headerusers=$headerusers[count]; 
$totalonline=$headerguests+$headerusers; 
// total online end

// get newest member name and userid start 
$getnewestmember=$db->query_first("SELECT userid, username FROM " . TABLE_PREFIX . "user WHERE userid=$numbersmembers[max]"); 
$newusername = $getnewestmember['username']; 
$newuserid = $getnewestmember['userid']; 
// get newest member name and userid end 
But this should still be optimized
- You can get rid of 2 Queries by using Datastore Item userstats (but this requires a File Edit)
- It might be possible to do the online stuff in 1 query

Neutral Singh 09-02-2005 05:25 AM
woohooo!! it works flawlessly !! Thanks.


All times are GMT. The time now is 09:01 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.00981 seconds
  • Memory Usage 1,736KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_code_printable
  • (1)bbcode_php_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (4)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 
Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 
Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete