Where can I find user's subscription expiration date in database?

We're shifting our Forum based support to a more dedicated support system!

We'll be closing our Forum support from 10th June, 2020 and move to Email Support assistance.

  • If you are a WCFM premium add-ons user, contact us- here
  • Want to know more before buying our add-ons? Send Pre sale queries- here
  • If you are a WCFM free user, please open a support ticket at WordPress.org
  • For WCFM App related queries, reach us- here
From now the forum will be read-only!

Multi Vendor Marketplace Plugin | WCFM Marketplace › Forums › WCFM › Where can I find user's subscription expiration date in database?

Viewing 3 reply threads
  • Author
    Posts
    • June 3, 2020 at 8:15 pm #138099
      tuomas.viikeri-9133
      Participant

      Like the title says, in what table can I find the user’s subscription expiration date data in the database?

    • June 4, 2020 at 1:15 pm #138268
      Sarmistha Chakraborty
      Keymaster

      Hello,

      You will find the expiry date in “wp_usermeta” table.
      get_user_meta( $user_id, 'wcfm_membership_next_schedule', true );

      Thanks.

    • June 4, 2020 at 9:29 pm #138448
      tuomas.viikeri-9133
      Participant

      I found the “key” columns which are named “wcfm_membership_next_schedule” in the usermeta table. If the “value” next to this column is supposed tell the expiration date it is then somehow crypted. For example a single value of it was 1593475200. This doesn’t look like a expiration date. How can I find the expiration dates in a readable form?

    • June 5, 2020 at 10:25 pm #138889
      Sarmistha Chakraborty
      Keymaster

      Hello,

      This is Timestamp.
      print echo date("Y-m-d",1593475200);

      Thanks.

  • Author
    Posts
Viewing 3 reply threads
  • You must be logged in to reply to this topic.