问在创建事务后更新Memberpress到期日期

EN

 $transaction = $event->get_data();
 $user = $transaction->user();

 if(($subscription = $transaction->subscription_id)) {
   $subscription_number = $subscription->subscr_id;
   //This transaction belongs to a recurring subscription
 }
 else {
   $transaction_number = $transaction->trans_num;
   //This is a non-recurring transaction
 }

global $wpdb;

$newdate = mysql_result(mysql_query("SELECT yearFromNow FROM usermeta WHERE userid = ".$user. "and meta_key = 'mepr_mepr_yearfromnow' " ), 0);

$insertdate = mysql_result(mysql_query("INSERT into wp_mepr_transactions max(expires_at) value ".$newdate." into WHERE userid = ".$user ), 0);


}
add_action('mepr-event-transaction-completed', 'mepr_capture_completed_transaction'); ```