Site hacked, Need EOT help

Our site was hacked and I am uncertain about the working condition of the s2 Member plugin.

I thought all was well until I saw two instances of member subscribers still being active after the EOT time had expired. I had never run into this before the hacking.

I pulled the wp_usermeta table but (and I apologize for the very simple question) I don’t understand how the EOT is written out.

For example, in the table it the EOT appears as:

1387602000
But the EOT in the system is Sun Nov 10, 2013 9:33 pm UTC

Weirder still is the second one I found. It has an EOT of:

1384119180
And in the system has the SAME EXACT EOT as the above example: Sun Nov 10, 2013 9:33 pm UTC

What I need to do is start by finding all of the people that have expired (and also look at those that have the above repeated date), but since I couldn’t figure out how to read the EOT time, I didn’t know who was expired and who was active.

I tried:
http://yoursite.com/?s2member_auto_eot_system_via_cron=1
(Replacing the site with “yoursite.com”) and it did not force the members with past EOTs to be demoted.

Any help would be graciously appreciated!! Thanks.

• This topic was modified 3 years, 1 month ago by  Jen Ortiz.

I thought I was asking a simple question…

How do you reverse-engineer the wp_s2member_auto_eot_time that looks like:

1386708207

Into something that looks like this:

Tue Dec 10, 2013 8:43 pm UTC

Am I asking the wrong question? Or does one have nothing to do with the other?

Any response is greatly appreciated!

A friend was able to give me the answer. I am posting it here in case anyone else needs it!
=============

That’s a UNIX epoch time, the number of milliseconds since the official “birth” of UNIX (1/1/1970).

If you are working in an Excel spreadsheet, there are two ways to approach this. You can either use a simple formula

=A1/(60*60*24)+”1/1/1970″

==========

And if you need the formula for an open office spreadsheet, use:

let’s say cell A2 contains a UNIX timestamp 1341104400, then this formula

=A2/86400+25569

will return a number. And if you format that cell as a date, DD/MM/YYYY HH:MM:SS, then you’ll read a pretty “01/07/2012 01:00:00” there.

Credit goes to:
https://forum.openoffice.org/en/forum/viewtopic.php?f=13&t=606