This automation allows you to fire MySQL queries to the same local database hosted on the site or an external database located on a different location. This allows you to run sql queries whenever a subscription status changes.
These are the following states on a subscription that would be triggered:
Being Activated
Being Refunded
Being Expired
Database Options
There are two database options that can be configured:
Local Database
This would be the same database as your Joomla site is using. You do not need to furnish login details for the database.
External Database
In the event that you need to runMySQLqueries on a different database or a database hosted on a different server, you should use this option. Remember to set the login credentials for the database connection.
Activated
When a subscription on the site is activated, PayPlans would trigger any automations that you have and execute the query that you have executed:
You may also use token as values in the query.
Refunded
Triggered when a subscription on the site is refunded to the customer.
You may also use token as values in the query.
Expired
When a subscription expires, PayPlans would trigger the REST API Requests created for this.
You may also use token as values in the query.