News:

SMF 2.1.4 has been released! Take it for a spin! Read more.

Main Menu

Resetting Online Time Statistics

Started by hatah, March 25, 2013, 08:00:16 AM

Previous topic - Next topic

hatah

So I'd like to reset the Online Time Statistics of my forum. Is this possible?

Shambles


Mr. Pedram

Quote from: hatah on March 25, 2013, 08:00:16 AM
So I'd like to reset the Online Time Statistics of my forum. Is this possible?

Quote from: Shambles on March 25, 2013, 10:20:17 AM
Sure is.

Surely he/she will ask about how..

I didn't test it, but i think this will do:
Maintenance / Recount all forum totals and statistics / Run task now
My Modifications:
» Loading For SMF
» Buddies Block
» Redirect Links
» Birthdate On Registration
» PM Warning
» Instagram
» Add Table,Td,Tr Button
» Search Topic & Board Button
Browse All...

Arantor

QuoteSurely he/she will ask about how..

Then he/she should have asked that, as well as which statistics they actually want to change since there are several.

QuoteI didn't test it, but i think this will do:
Maintenance / Recount all forum totals and statistics / Run task now

No it won't.

Mr. Pedram

Quote from: Arantor on March 25, 2013, 11:04:10 AM
QuoteSurely he/she will ask about how..

Then he/she should have asked that, as well as which statistics they actually want to change since there are several.

QuoteI didn't test it, but i think this will do:
Maintenance / Recount all forum totals and statistics / Run task now

No it won't.

Are you "Shambles"? :)
Always in right place & right time
My Modifications:
» Loading For SMF
» Buddies Block
» Redirect Links
» Birthdate On Registration
» PM Warning
» Instagram
» Add Table,Td,Tr Button
» Search Topic & Board Button
Browse All...

Arantor

No, but I understand the mentality just fine.

Mr. Pedram

NP, thought all statistics will be reset via:

QuoteMaintenance / Recount all forum totals and statistics / Run task now
My Modifications:
» Loading For SMF
» Buddies Block
» Redirect Links
» Birthdate On Registration
» PM Warning
» Instagram
» Add Table,Td,Tr Button
» Search Topic & Board Button
Browse All...

Chalky

No, the word is "recount", not "reset"  ;)  When you check your till receipt it doesn't change the bill to $0 and give you your money back  :P

I don't know how to reset though, admit I'm intrigued...

Shambles

A very simple database query will do it. I've done it myself (and I'm no database query person) but the OP did not ask that. He/she may already [now] know how to do it but originally asked if it was possible.

The answer, again, is yes.

Arantor

And depending on what statistics, exactly, are being altered, it could be different queries ;)

Shambles

Yeah, I made an assumption he wants to make everyone a forum n00b, timewise ;)

Quote from: hatah
So I'd like to reset the Online Time Statistics of my forum...

Arantor

This is why I'd like him to clarify what he wants to do because until he does, anything we suggest is going to be straight up speculation and likely wrong.

hatah

Yes, I would like to know how...

I'd just like to reset the total time that I've been online.

Arantor

Just for you?

Got access to phpMyAdmin? Happy doing direct database changes?

hatah


kat

I guess (This IS just a guess)you could go to phpmyadmin>smf_members and edit your "totalTimeLoggedIn", if your time logged in is so critical, for you.

I'd backup the database, first, though, in case something critical gets screwed.

(OOPS! Sorry, Arantor. Cross-posted)

Arantor

Eh, don't apologise, that's exactly what needs to be done. I just don't give out the information off the bat ;)

kat

Why's that, out of curiosity?

Possibility of abuse? (Hadn't thought of that)

Arantor

Nah, it's more a barrier-to-entry thing. I don't suggest people go into the database unless they have at least *some* idea of what they're doing, and people that need step by step instructions probably shouldn't be going to the database directly because the odds are that something will go wrong.

hatah


kat

http://wiki.simplemachines.org/smf/Backup

Ah. I did consider that, Arantor. Hence the "Back up, first" thing.

That, of course, shouldn't need to be said.

However, we've both been here long enough to know that "Common sense" is an oxymoron. ;)


Advertisement: