Showing posts/member count on non-forum HTML page

[Marco van Herwaarden]

Try changing to:

PHP Code:

<?php
chdir('../forum');
include_once('./global.php');
global $vbulletin; // Should not be needed
 
// get total members 
$numbersmembers=$vbulletin->db->query_first('SELECT COUNT(*) AS users FROM " . TABLE_PREFIX . "user'); 
 
...etc, replacing $db by $vbulletin->db

[wii]

Still the same result using this code:

PHP Code:


<?php
chdir('../forum');
include_once('http://www.myforum.com/forum/global.php');

// get total members 
$numbersmembers=$vbulletin->db->query_first('SELECT COUNT(*) AS users FROM " . TABLE_PREFIX . "user'); 
$numbermembers = number_format($numbersmembers['users']); 
// get total posts 
$countposts=$vbulletin->db->query_first('SELECT COUNT(*) AS " . TABLE_PREFIX . "posts FROM post'); 
$totalposts = number_format($countposts['posts']); 
//$countthreads=$vbulletin->db->query_first('SELECT COUNT(*) AS " . TABLE_PREFIX . "threads FROM thread'); 
//$totalthreads = number_format($countthreads['threads']); 

echo $numbermembers . " forum members - " . $totalposts  . " posts";

?>

I would still even pay for a working code, so I can include these stats in my website (not forum).

Thanks

Originally Posted by wii

Anyone? I would even pay a little (using paypal) to get this done !

Thanks

[Marco van Herwaarden]

replace:

PHP Code:

include_once('http://www.myforum.com/forum/global.php'); 


With:

PHP Code:

require_once('./global.php'); 


And with the above code, error message is the same? Even the linenumber?

[wii]

Now I get an SQL error:

Invalid SQL:
SELECT COUNT(*) AS users FROM " . TABLE_PREFIX . "user;

[Marco van Herwaarden]

Please post your current script and the full error message.

[wii]

Ok, the script:

PHP Code:


<?php 
chdir('../forum'); 
 require_once('./global.php');  

// get total members  
$numbersmembers=$vbulletin->db->query_first('SELECT COUNT(*) AS users FROM " . TABLE_PREFIX . "user');  
$numbermembers = number_format($numbersmembers['users']);  
// get total posts  
$countposts=$vbulletin->db->query_first('SELECT COUNT(*) AS " . TABLE_PREFIX . "posts FROM post');  
$totalposts = number_format($countposts['posts']);  
//$countthreads=$vbulletin->db->query_first('SELECT COUNT(*) AS " . TABLE_PREFIX . "threads FROM thread');  
//$totalthreads = number_format($countthreads['threads']);  

echo $numbermembers . " forum members - " . $totalposts  . " posts"; 

?>

The error - removed link (private forum)

PHP Code:


Database error in vBulletin 3.5.1:

Invalid SQL:
SELECT COUNT(*) AS users FROM " . TABLE_PREFIX . "user;

MySQL Error  : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '" . TABLE_PREFIX . "user' at line 1
Error Number : 1064
Date         : Monday, December 5th 2005 @ 10:19:57 AM
Script       : http://www.myforum.com/beta/stats.php
Referrer     : 
IP Address   : XX.XX.XX.XX
Username     : wii
Classname    : vB_Database 


[Marco van Herwaarden]

PHP Code:

$numbersmembers=$vbulletin->db->query_first('SELECT COUNT(*) AS users FROM " . TABLE_PREFIX . "user'); 


replace by:

PHP Code:

$numbersmembers=$vbulletin->db->query_first("SELECT COUNT(*) AS users FROM " . TABLE_PREFIX . "user"); 


Do the same for the other query (SDon't use single quotes there).

[wii]

Ok, I got the include to work on the page, but which include is best to use for this?

include()
require()
include_once()
require_once()

I?m using require currently.

But the post count is between 10-13 more than on the forum (seems to change once in a while), anyway to fix this?

Is it possible to modify the script, so it uses the same as index.php to count the posts?

PHP Code:


 // get total threads & posts from the forumcache 
$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); 

// get total members and newest member from template 
$numbermembers = vb_number_format($vbulletin->userstats['numbermembers']); 


[Marco van Herwaarden]

require_once is mostly the correct way.

[wii]

Thanks