What is the "stats" table for?

[the_sisko]

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]

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]

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

[the_sisko]

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]

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

$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]

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

$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:
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]

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

[Xenon]

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