vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)
-   -   What is the "stats" table for? (https://vborg.vbsupport.ru/showthread.php?t=69517)

the_sisko 09-16-2004 12:32 PM

What is the "stats" table for?
 
I'm working on a new hack which includes updating userids. So I looked over the db and searched for userids.
The job is done but I cannot figure out what the "stats" table doing for a job?

Does anybody know it?

miz 09-16-2004 02:29 PM

well i dunno what the stats table used for
but
for update userids via mysql see this thread

https://vborg.vbsupport.ru/showthread.php?t=69430

Dean C 09-16-2004 03:54 PM

Moved to General vBulletin questions. Please read the forum descriptions more closely in future :) Thanks

the_sisko 09-16-2004 07:01 PM

It's more like a user merge script and I need to know if the userid field in stats table needs to be altered.
No I will update it anyway, but would like to know what its doing anyway.

Xenon 09-20-2004 12:52 PM

actually i don't see a userid within the stats table...

PHP Code:

$schema['CREATE']['query']['stats'] = "
CREATE TABLE " 
TABLE_PREFIX "stats (
    dateline INT UNSIGNED NOT NULL DEFAULT '0',
    nuser mediumint UNSIGNED NOT NULL DEFAULT '0',
    nthread mediumint UNSIGNED NOT NULL DEFAULT '0',
    npost mediumint UNSIGNED NOT NULL DEFAULT '0',
    ausers mediumint UNSIGNED NOT NULL DEFAULT '0',
    PRIMARY KEY (dateline)
)
"


so if you have a userid there, it's because of a hack, and therefore it's better to ask the hack author about that :)

the_sisko 09-20-2004 12:58 PM

Quote:

Originally Posted by Xenon
actually i don't see a userid within the stats table...

PHP Code:

$schema['CREATE']['query']['stats'] = "
CREATE TABLE " 
TABLE_PREFIX "stats (
    dateline INT UNSIGNED NOT NULL DEFAULT '0',
    nuser mediumint UNSIGNED NOT NULL DEFAULT '0',
    nthread mediumint UNSIGNED NOT NULL DEFAULT '0',
    npost mediumint UNSIGNED NOT NULL DEFAULT '0',
    ausers mediumint UNSIGNED NOT NULL DEFAULT '0',
    PRIMARY KEY (dateline)
)
"


so if you have a userid there, it's because of a hack, and therefore it's better to ask the hack author about that :)

I don't have a hack on this table...
I just wanted to know what it does and what nuser and auser is?

I started a support ticket for this question and get this:
Quote:

To my understanding this is the table used to store the statistics it generates for Admin Control Panel > Statistics & Logs > Statistics.
But still no info about this nuser and auser fields...

Colin F 09-20-2004 12:58 PM

I would assume that it stores stats made by the cron, which can be viewed in the admincp statistics.

Xenon 09-20-2004 01:43 PM

nuser sounds like new users to me
auser then would be active users

regarding my local board that would fit in.
so no id's in there and therefore nothing to worry about for your hack


All times are GMT. The time now is 12:35 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.01265 seconds
  • Memory Usage 1,730KB
  • 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
  • (2)bbcode_php_printable
  • (2)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (8)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