Location of EOTs

[MacGyvr]

Where are the Automatic EOTs (and other fields of information) stored? I want to be able to look those up for each member. I can't imagine that would be stored at PayPal.

[MacGyvr]

My question seems to have been ignored in a long string that were answered. Can someone just point me to where EOTs are stored?

[Raam Dev]

Hi MacGyvr,

Apologies for the slow reply!

The Automatic EOT is stored in the wp_usermeta table with a meta_key wp_s2member_auto_eot_time. The meta_value for that row will be the date of the Automatic EOT in Unixtime format (e.g., 1324339200).

Keep in mind that a Automatic EOT time will only exist in the database if one has been set for the user. By default, the EOT will only be calculated when an Account Expiration / Termination occurs. If necessary, you can override this by manually setting the EOT on the users profile:

EOT = End Of Term. ( i.e. Account Expiration / Termination. ).

If you leave this empty, s2Member will configure an EOT Time automatically, based on the paid Subscription associated with this account. In other words, if a paid Subscription expires, is cancelled, terminated, refunded, reversed, or charged back to you; s2Member will deal with the EOT automatically.

That being said, if you would rather take control over this, you can. If you type in a date manually, s2Member will obey the Auto-EOT Time that you've given, no matter what. In other words, you can force certain Members to expire automatically, at a time that you specify. s2Member will obey.

Valid formats for Automatic EOT Time:

mm/dd/yyyy
yyyy-mm-dd
+1 year
+2 weeks
+2 months
+10 minutes
next thursday
tomorrow
today

* anything compatible with PHP's strtotime() function.

[MacGyvr]

Thank you! Exactly what I needed!

[Raam Dev]

You're welcome! Glad to hear that's the info you needed.