vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   Member Archives (https://vborg.vbsupport.ru/forumdisplay.php?f=202)
-   -   Custom Stats Hack Help Needed! (https://vborg.vbsupport.ru/showthread.php?t=44938)

X-Fan 10-24-2002 02:11 PM

Custom Stats Hack Help Needed!
 
G'day all,

I'm making a custom statistics hack for my Web site because my front page was getting too bogged down with the various stats that I wanted to display. So what I've done is put all the stats-getting hacks I'm using into their own php file (with a few tweaks and mods here and there) which I'll put up a link to load it in a javascript popup window.

But, being a relative PHP newbie, I'm stuck on getting a few totals, such as total members online (just the number, not the list of actual members), total registered vs total guest, total visible vs total invisible, record total online, and total new user registrations for the current day.

Again, with the online stuff, I just want the totals, not the list of names.

Also, with that Top 5 Posters hack that's been around for a while, how can I edit this line:

PHP Code:

$posts5 $DB_site->query('SELECT userid,username,posts FROM user ORDER BY posts DESC LIMIT 5'); 

to not include admins or specific posters? I know it entails the usergroupid and userid variables, but can't work out exactly how to do it.

Can anyone help with this, please?

X-Fan 09-22-2003 01:30 AM

Okay, persistance has paid off and I've managed to sort out some of the problems I was having with this hack. Now I'm at the stage where I'd like to include some demographics type stats, but I'm stumped as to how to get birthdate information from the database and sort it into categories, such as Under 15, 16-25, etc.

Can anyone help with that, please?


All times are GMT. The time now is 05:33 PM.

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.00968 seconds
  • Memory Usage 1,716KB
  • 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_php_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (2)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