Resetting the EOT time for all members

#1

Hi

My client would like ALL EOT to be set to expire on 31/12/2019 at 23.59PM.
Is there a way to do this in the Admin Dashboard or do I need to run a MySQL query on database table?

Thanks

#2

I’ve worked out I can reset all members EOT dates through phpMyAdmin.

  • TAKE A BACKUP OF THIS TABLE: WPTABLEPREFIX_usermeta
  • PRACTICE ON A DUMMY_RUN_BACKUP of the usermeta table
  • Calculating the interger for the last day/hr/min of the current year? Try https://www.epochconverter.com/ (Epoch & Unix Timestamp Conversion Tools).

The S2 Member Pro field is: WPTABLEPREFIX_s2member_auto_eot_time

Update WPTABLEPREFIX_usermeta set meta_value = ‘[my_eot_date_time_expressed_as_integer]’ where meta_key = WPTABLEPREFIX__s2member_auto_eot_time’

I also found that going forward this tutorial describes how to create a subscription that ends on a fixed date for everybody.

I wonder whether I should use my phpMy Admin method each year or follow the tutorial?

Thanks