Auto Action that will fire ONLY on the following recurring payments but not on the first one

/** * Called at each change of user subscription state due to a plan activation or deactivation * * @param UserTable $user The user owning the $subscription with that $planId * @param string $status New status: 'A'=Active, 'X'=Expired, 'C'=Cancelled * @param int $planId Plan Id which is changing status * @param int $replacedPlanId Replaced Plan Id in case of an upgrade * @param ParamsInterface $integrationParams Integration parameters for that plan $planId * @param string $cause 'PaidSubscription' (first activation only), 'SubscriptionActivated' (renewals, cancellation reversals), 'SubscriptionDeactivated', 'Denied' * @param string $reason 'N' new subscription, 'R' renewal, 'U'=update ) * @param int $now Unix time * @param cbpaidSomething $subscription Subscription/Donation/Merchandise record * @param int $autorenewed 0: not auto-renewing (manually renewed), 1: automatically renewed (if $reason == 'R') * @return void */ public function onCPayUserStateChange( $user, $status, $planId, $replacedPlanId, $integrationParams, $cause, $reason, $now, $subscription, $autorenewed )

if ( ( $status == 'A' ) && ( $cause == 'PaidSubscription' ) && ( $reason != 'R' ) ) { $event = 'activation'; } elseif ( ( $status == 'A' ) && ( $cause == 'PaidSubscription' ) && ( $reason == 'R' ) && ( $autorenewed == 0 ) ) { $event = 'renewal'; } elseif ( ( $status == 'A' ) && ( $cause == 'PaidSubscription' ) && ( $reason == 'R' ) && ( $autorenewed == 1 ) ) { $event = 'autorenewal'; } elseif ( ( $status == 'X' ) && ( $cause != 'Pending' ) ) { $event = 'expired'; } elseif ( ( $status == 'C' ) && ( $cause != 'Pending' ) ) { $event = 'deactivation'; } elseif ( ( $cause == 'Pending' ) && ( $reason != 'R' ) && ( $autorenewed == 0 ) ) { $event = 'pendingfirst'; } elseif ( ( $cause == 'Pending' ) && ( $reason == 'R' ) && ( $autorenewed == 0 ) ) { $event = 'pendingrenewal'; }

SELECT `invoice` FROM `#__cbsubs_payment_baskets` WHERE `user_id` = '[cb:userdata field="user_id" /]' ORDER BY `time_updated` DESC LIMIT 1; SELECT `payment_status` FROM `#__cbsubs_payment_baskets` WHERE `user_id` = '[cb:userdata field="user_id" /]' ORDER BY `time_updated` DESC LIMIT 1; SELECT `payment_method` FROM `#__cbsubs_payment_baskets` WHERE `user_id` = '[cb:userdata field="user_id" /]' ORDER BY `time_updated` DESC LIMIT 1; SELECT `txn_id` FROM `#__cbsubs_payment_baskets` WHERE `user_id` = '[cb:userdata field="user_id" /]' ORDER BY `time_updated` DESC LIMIT 1; SELECT `item_number` FROM `#__cbsubs_payment_baskets` WHERE `user_id` = '[cb:userdata field="user_id" /]' ORDER BY `time_updated` DESC LIMIT 1; SELECT `payer_email` FROM `#__cbsubs_payment_baskets` WHERE `user_id` = '[cb:userdata field="user_id" /]' ORDER BY `time_updated` DESC LIMIT 1; SELECT `item_name` FROM `#__cbsubs_payment_baskets` WHERE `user_id` = '[cb:userdata field="user_id" /]' ORDER BY `time_updated` DESC LIMIT 1; SELECT CONCAT('<strong>Sub-Total:</strong> £', TRUNCATE( `mc_gross` - `tax`, 2 ), '<br /><br />') AS SubTotal FROM `#__cbsubs_payment_baskets` WHERE `user_id` = '[cb:userdata field="user_id" /]' ORDER BY `time_updated` DESC LIMIT 1; SELECT CONCAT('<strong>Tax:</strong> £', TRUNCATE( `tax`, 2 ), '<br /><br />') AS tTax FROM `#__cbsubs_payment_baskets` WHERE `user_id` = '[cb:userdata field="user_id" /]' ORDER BY `time_updated` DESC LIMIT 1; SELECT TRUNCATE( `mc_gross`, 2 ) FROM `#__cbsubs_payment_baskets` WHERE `user_id` = '[cb:userdata field="user_id" /]' ORDER BY `time_updated` DESC LIMIT 1; SELECT `ip_addresses` FROM `#__cbsubs_payment_baskets` WHERE `user_id` = '[cb:userdata field="user_id" /]' ORDER BY `time_updated` DESC LIMIT 1; SELECT DATE_FORMAT( `time_updated`, '%T - %d %b %Y' ) AS ttime_updated FROM `#__cbsubs_payment_baskets` WHERE `user_id` = '[cb:userdata field="user_id" /]' ORDER BY `time_updated` DESC LIMIT 1; SELECT DATE_FORMAT( `expiry_date`, '%T - %d %b %Y' ) AS texpiry_date FROM `#__cbsubs_subscriptions` WHERE `user_id` = '[cb:userdata field="user_id" /]' ORDER BY `expiry_date` DESC LIMIT 1;

UPDATE `#__cbsubs_payment_baskets` SET `invoice` = ( SELECT `invoice` FROM ( SELECT MAX( `invoice` + 1 ) AS `invoice` FROM `#__cbsubs_payment_baskets` ) AS t ) WHERE `user_id` = '[cb:userdata field="user_id" /]'; UPDATE `#__cbsubs_payment_baskets` SET `proformainvoice` = ( SELECT `proformainvoice` FROM ( SELECT MAX( `proformainvoice` + 1 ) AS `proformainvoice` FROM `#__cbsubs_payment_baskets` ) AS t ) WHERE `user_id` = '[cb:userdata field="user_id" /]'; UPDATE `#__cbsubs_payments` SET `invoice` = ( SELECT `invoice` FROM ( SELECT MAX( `invoice` + 1 ) AS `invoice` FROM `#__cbsubs_payments` ) AS t ) WHERE `user_id` = '[cb:userdata field="user_id" /]';