Stat block in MySql

Get help with installation and running phpBB 3.1.x here. Please do not post bug reports, feature requests, or extension related questions here.
Anti-Spam Guide
Forum rules
READ: phpBB.com Board-Wide Rules and Regulations

NOTE: phpBB 3.1.x is at its End of Life stage and support will NOT be provided after July 1st, 2018.
Locked
Cereus
Registered User
Posts: 2
Joined: Sat Jun 16, 2018 3:14 pm

Stat block in MySql

Post by Cereus » Sat Jun 16, 2018 3:20 pm

Hello.

Some time ago my forum was flooded with bots, which have messed with the original stats of stat-block online-list. I want to revert these stats about when there was the highest number of online users to previous one, from before this incident. However, I cannot find where to edit these stats in MySql. I would appreciate the assistance on that matter.

Thank you.

User avatar
KevC
Support Team Member
Support Team Member
Posts: 68466
Joined: Fri Jun 04, 2004 10:44 am
Location: Oxford, UK
Contact:

Re: Stat block in MySql

Post by KevC » Sat Jun 16, 2018 3:32 pm

It's in the _config table of your database.
record_online_users

It's about page 8 or 9 of that table.
-:|:- Support Request Template -:|:-
Image
Cheap UK Hosting
"In the land of the blind the little green bloke with no pupils is king - init!"

Cereus
Registered User
Posts: 2
Joined: Sat Jun 16, 2018 3:14 pm

Re: Stat block in MySql

Post by Cereus » Sat Jun 16, 2018 3:36 pm

Thanks a lot! In a million years I wouldn't find it there.

How can I convert the date when it's displayed as 1516069471?
Is there some converter or just some logic way to figure out the numbers? I want to set the date back as well.

@Edit: I managed to do it. Just kept trying with every next number until I got the correct date. Thanks!

User avatar
KevC
Support Team Member
Support Team Member
Posts: 68466
Joined: Fri Jun 04, 2004 10:44 am
Location: Oxford, UK
Contact:

Re: Stat block in MySql

Post by KevC » Sat Jun 16, 2018 3:52 pm

It's a unix time stamp. If you want it closer to the time you want there are websites out there that will convert unix timestamps to normal time and vice versa. You put the date/time in and it'll give you the long number to put in.
-:|:- Support Request Template -:|:-
Image
Cheap UK Hosting
"In the land of the blind the little green bloke with no pupils is king - init!"

User avatar
stevemaury
Support Team Member
Support Team Member
Posts: 49732
Joined: Thu Nov 02, 2006 12:21 am
Location: The U.P.
Name: Steve
Contact:

Re: Stat block in MySql

Post by stevemaury » Mon Jun 18, 2018 6:20 pm

http://unixtimestamp.com

That number is the number of seconds that have passed since midnight on 1/1/1970.
For REALLY good and VERY inexpensive hosting CLICK HERE

I can stop all your spam. PM or email me.

All unsolicited PMs will be ignored.

Locked

Return to “[3.1.x] Support Forum”

Who is online

Users browsing this forum: No registered users and 23 guests