vb.org Archive - What is the "stats" table for?

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 01:40 AM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01264 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
Messages: