News:

Want to get involved in developing SMF, then why not lend a hand on our github!

Main Menu

Need to edit my Users Most Online, because the current number is insane.

Started by Yazar8, February 14, 2015, 11:07:42 AM

Previous topic - Next topic

Yazar8

I had an attack a couple of months back, in result of that, this happened:

http://imgur.com/sp4l7Lk

I have a very high users most online record at the bottom of the forum, I don't like it, because people keep asking "Wow we're popular." etc. So I want to set it back to 85, which is supposed to be our real record.

How to do that?

Edit: Okay done, but how do I edit the date? It's like 20 november 2013 or something like that

Chas Large

You need to manually edit the smf_settings table in your database. Use phpMyAdmin if you have this.

FIRST BACKUP THE DATABASE!

Once you've done that, open the database and then the smf_settings table.

Scroll down for the row mostOnline and edit the number there to to number on line you require

Scroll down two lines to mostDate and edit the UNIX time code there for the date you want it to show.

Use this site: http://www.epochconverter.com/ to get the date in UNIX format you need.

You should (with phpMyAdmin) be able to edit individual cells in the table just by double clicking on them and overtyping the numbers, then just click to the right and the timer should show for a few seconds whilst the cell is updated.

Reload your browser page of the site to reflect the changes made.
My Modifications :)  My Forum

Please DO NOT PM me with support requests. Post the problem in the appropriate Support Board so everyone can benefit from the advice given.

Yazar8

Quote from: Chas Large on February 14, 2015, 01:46:15 PM
You need to manually edit the smf_settings table in your database. Use phpMyAdmin if you have this.

FIRST BACKUP THE DATABASE!

Once you've done that, open the database and then the smf_settings table.

Scroll down for the row mostOnline and edit the number there to to number on line you require

Scroll down two lines to mostDate and edit the UNIX time code there for the date you want it to show.

Use this site: http://www.epochconverter.com/ to get the date in UNIX format you need.

You should (with phpMyAdmin) be able to edit individual cells in the table just by double clicking on them and overtyping the numbers, then just click to the right and the timer should show for a few seconds whilst the cell is updated.

Reload your browser page of the site to reflect the changes made.

Hello,

Thanks for the simple explenation!

I had a guess it's somewhere at the database, so I searched for 2114 and edited the numbers (before you posted) everything was set except the date, hopefully your post covered that part aswell.

Because I was not able to find the date, It didn't come to my mind that it could have been in UNIX format since all other dates were basical VARCHARS.

Thanks again!

Advertisement: