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

[tuomas.viikeri-9133]

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

[Sarmistha Chakraborty]

Hello,

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

Thanks.

[tuomas.viikeri-9133]

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?

[Sarmistha Chakraborty]

Hello,

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

Thanks.

[Author]

Posts