1. LAC DB connected successfully!<br><br>=================Entry Start From Here ============<br><br>SELECT * FROM gpay_webhooks WHERE id = '239'<br><br><br><br>======================= I am in subscription Renew ==================<br><br>Webhook tbl Record Id is => 239 and order_id is => 5159 and GPA ID is => GPA.3395-9780-7664-43773..7<br><br>SELECT id,status FROM tbl_customer_subscriptions WHERE order_id='5159' AND subscriber_id='37272' AND trans_id='GPA.3395-9780-7664-43773' AND status='3' LIMIT 1<br><br>UPDATE tbl_customer_subscriptions SET status='3',is_cancelled='1',platform='webhook', end_date=NOW(),cancelled_at=NOW() WHERE trans_id='GPA.3395-9780-7664-43773' AND subscriber_id='37272' AND order_id='5159' AND status IN('2','3') limit 1<br><br>Subscription cancelled successfully as it was refunded, order id is = 5159<br><br>Closing this record as this could be refunded.<br><br>239