vb.org Archive - Stats member... Prob !

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vB3 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=15)

- - Stats member... Prob ! (https://vborg.vbsupport.ru/showthread.php?t=177258)

Stats member... Prob !

Hello

recently i token this script to view the stat of member to intagrate to my page web !

PHP Code:


		
			
<?php 

error_reporting(7); 

//################################################### 
// A MODIFIER LE REPERTOIRE YOUR/PAT 
//################################################### 

chdir('your/pat/'); 

//################################################### 
// Fichier a inclure 
//################################################### 

require_once('global.php'); 

//################################################### 
// Recuperation des donnees dans la base 
//################################################### 

$countposts=$DB_site->query_first('SELECT COUNT(*) AS posts FROM post'); 
$totalposts=number_format($countposts['posts']); 
$numbersmembers=$DB_site->query_first('SELECT COUNT(*) AS users,MAX(userid) AS max FROM user'); 
$numbermembers=number_format($numbersmembers['users']); 

//################################################### 
// Affichage du nombre de membres et de messages 
//################################################### 

echo "$numbermembers membres et $totalposts messages"; 

?>

But he doesn't turn ?

why ? some modification in the script ?

Sorry of my bad english and tnx ;)

Is that your actual script cuz it doesn't look like the path to your forums was input here:

PHP Code:


		
			
chdir('your/pat/');

And, you might want to use this instead of the one your are using for global.php assuming you are changing directories to the forum directory:

PHP Code:


		
			
require_once('./global.php');

Wow. I haven't seen 3.0 code in forever, but as Lynne stated you must set your/pat to your forums directory for this to work.

Okay , i have configured my path...

But when i test this script , i have this error

Fatal error: Call to a member function on a non-object in /home/mysite/public_html/stat.php on line 21

It appears that the $DB_site class isn't created. I haven't messed with 3.0 code at all (meaning I can't tell you what class name it is), but it is looking like Global.php doesn't initiate it like it should.

I don(t understand this line

$countposts=$DB_site->query_first('SELECT COUNT(*) AS posts FROM post');

$DB_site -> is the probleme !!!!!

it's my database name ?

What version of vbulletin are you running on your site?

Well, the code you are trying to use is for 3.0. The method to make a database query is different now. It used to be:

Code:

$DB_site->query_first

and is now:

Code:

$vbulletin->db->query_first  Or

$db->query_first OR

several other lesser used methods depending on where the query is being used

I'm not sure where you got your code, but you may want to go search to find some code already written for 3.6 instead of 3.0

Quote:

Originally Posted by Lynne (Post 1501535)

Well, the code you are trying to use is for 3.0. The method to make a database query is different now. It used to be:

Code:

$DB_site->query_first

and is now:

Code:

$vbulletin->db->query_first  Or

$db->query_first OR

several other lesser used methods depending on where the query is being used

I'm not sure where you got your code, but you may want to go search to find some code already written for 3.6 instead of 3.0

Thanks for your ansewer !

But , were i fond this code ?

can you send me one pliz ?

TNX

X vBulletin 3.8.12 by vBS Debug Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (4)bbcode_code_printable (3)bbcode_php_printable (1)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (1)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (10)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 pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages:

Phrase Groups Available:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01129 seconds Memory Usage 1,747KB 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 (4)bbcode_code_printable (3)bbcode_php_printable (1)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (1)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (10)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 pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: