Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 General Discussions
  #1  
Old 03-19-2001, 12:52 AM
slip slip is offline
 
Join Date: Mar 2003
Posts: 7
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Okay.. I want to be able to show on an external page (outside of vbulletin) the number of total regged users, and the number of online users..

This code was workign PERFECTLY with vB114 but it produces an error with vb2..

heres the code..
Code:
<?
require("forum/admin/config.php");
$db=mysql_connect($servername,$dbusername,$dbpassword);
mysql_select_db($dbname);

$loggedins=mysql_query("SELECT COUNT(sessionid) AS sessions FROM session",$db);
$tempa=mysql_fetch_array($loggedins);
$totalonline=$tempa[sessions];

$registered=mysql_query("SELECT COUNT(userid) AS registered FROM user",$db);
$tempb=mysql_fetch_array($registered);
$regged=$tempb[registered];

echo "<font face=arial size=2>
We have a total of $regged registered users.  There are currently $totalonline users online at the moment.</font>
";
?>
and now heres what it shows with vb 20 installed..

"Warning: 0 is not a MySQL result index in /home/redg/htdocs/online2.php on line 7
We have a total of 3130 registered users. There are currently users online at the moment. "



any ideas are greatly appreciated..
slip
Reply With Quote
  #2  
Old 03-19-2001, 01:33 AM
Guest
 
Posts: n/a
Default

Code:
<?
require("forum/admin/config.php");
$db=mysql_connect($servername,$dbusername,$dbpassword);
mysql_select_db($dbname);

$loggedins=mysql_query("SELECT COUNT(userid) AS users FROM session",$db) or die ("oops");
while($loggedin = mysql_fetch_array($loggedins))
	$totalonline=number_format($loggedin[users]);

$users=mysql_query("SELECT COUNT(userid) AS registeredusers FROM user",$db) or die ("double oops");
while($user = mysql_fetch_array($users))
	$totalusers=number_format($user[registeredusers]);

echo "<font face=arial size=2>
We have a total of $totalusers registered users.  There are currently $totalonline users online at the moment.</font>
";
?>
should do it...

[edited to correct invalid query]
Reply With Quote
  #3  
Old 03-19-2001, 01:49 AM
Guest
 
Posts: n/a
Default

i did that, and i only get "oops" now when i go to that file.. any ideas?
Reply With Quote
  #4  
Old 03-19-2001, 02:00 AM
Guest
 
Posts: n/a
Default

Yeah... I just checked the session table and there is no such field as 'sessionid'.

Replace your first query with this:
Code:
"SELECT COUNT(userid) AS users FROM session"
Reply With Quote
  #5  
Old 03-19-2001, 02:10 AM
Guest
 
Posts: n/a
Default

woo hoo!
you seriously rule!!!

thanks!
Reply With Quote
  #6  
Old 03-19-2001, 10:55 PM
Guest
 
Posts: n/a
Default

is there a way to put this into a html page?
Reply With Quote
  #7  
Old 03-20-2001, 12:43 AM
Guest
 
Posts: n/a
Default

Quote:
Originally posted by Blue2000
is there a way to put this into a html page?
Do you mean an HTML page as in a page with a .html extension? If so, then no, unless your server has been configured to parse HTML files as PHP.
Reply With Quote
  #8  
Old 03-20-2001, 01:17 AM
Guest
 
Posts: n/a
Default

ahh, but there is

SSI from the .php file
Reply With Quote
  #9  
Old 03-20-2001, 01:26 AM
Guest
 
Posts: n/a
Default

Quote:
Originally posted by Flare945
ahh, but there is
Oh, okay then
Reply With Quote
  #10  
Old 03-20-2001, 12:19 PM
Guest
 
Posts: n/a
Default

The results in VBulletin 2.0 are different to the results in your script. It counts correctly the sessions, but why shows the vbulletin other results? Any suggestions?
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 10:06 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.04667 seconds
  • Memory Usage 2,238KB
  • Queries Executed 14 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)ad_showthread_firstpost
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (3)bbcode_code
  • (2)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (2)pagenav_pagelink
  • (10)post_thanks_box
  • (10)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (10)post_thanks_postbit_info
  • (10)postbit
  • (1)postbit_onlinestatus
  • (10)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.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/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • pagenav_page
  • pagenav_complete
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete