Stop MemberPress from setting transaction expires dates to 23:59:59 UTC+0

mepr-stop-23-59-59-utc-expires-at.php

<?php
// This will set the expires at hour, minute, second to the same hour, minute, second when the user joined.
function update_txn_expires_at($txn, $old_txn = false) {
  global $wpdb;
  
  if(!isset($txn->id) || (int)$txn->id <=0 || $txn->expires_at == '0000-00-00 00:00:00') { return; }
  
  $expires_at_ts = strtotime($txn->expires_at);
  $created_at_ts = strtotime($txn->created_at);
  
  $new_expires_at_ts = mktime(
    gmdate("H", $created_at_ts), //hour
    gmdate("i", $created_at_ts), //minute
    gmdate("s", $created_at_ts), //second
    gmdate("n", $expires_at_ts), //month
    gmdate("j", $expires_at_ts), //day
    gmdate("Y", $expires_at_ts)  //year
  );
  
  $expires_at = gmdate('Y-m-d H:i:s', $new_expires_at_ts);
  
  $wpdb->query("UPDATE {$wpdb->prefix}mepr_transactions SET expires_at = '{$expires_at}' WHERE id = {$txn->id}");
}
add_action('mepr-txn-store', 'update_txn_expires_at', 999999, 2);