Make post script to pass variables to multiple APIs and append file on server -- 2

1. Get a Value from Wordpress Woocommerce product backend post_meta, this value is made by a plugin. 2. Deconstruct that value into 4 variables to use and store them in a database. The 4 variables are separated by a : Example [login to view URL]:3738495:839423 [login to view URL] - This is the sub-domain 3127 - This is the location and can be 2 values only the key is below 3127 = NYC 3128 = United Kingdom 3738495 - This is the username 839423 - This is the password 3. Get 2 date & time values and store them with the post_meta from step 2, these are in the product description. Please see file attachments for how the data is showed. After this is done we have now completed one product. The script will need to check the next product for both values (post meta and times). The values we need to store for date and time are: Action Date Time Time Zone Activate 04/12/19 10:00 AM EST Deactivate 04/12/19 11:00 AM EST 4. Steps 1-3 will need to be done on all products in my woocommerce store, there are only about 7 of them that contain both post_meta and the date and time. So I would like this to run every 6 hours automatically checking if any data has changed. The values do update every so often so they will need to be updated if they do. 5. Now that we have values stored in our database we will need a second script to cross check the database with upcoming Activate times. 2 hours before an upcoming Activate time and date we will need to fire off some API calls. 6. 2 hours before our activate time from above, the following will now happen. 6A. Create a VPS from a snapshot (preconfigured already made backup) via api call, the location of where we will make the VPS depends on the location from post meta which can be seen in step 2. API docs: [login to view URL] 6B. Get the IP address from the new VPS we have made and point it to our subdomain [login to view URL] VIA api API option --data '{"type":"A","name":"a1","content":"$IPfromVPSmade","ttl":{},"priority":10,"proxied":false}' API call: [login to view URL] 6C. Add IP from VPS to whitelist * Add IPs: Curl Example GET curl -v [login to view URL]${EMAIL}/${PASS}?ips=ip1 !important;ip2 !important;ipn 7. We need to now run some commands on the remote VPS we made. Command 1. (this command will add the username and password from the database that we stored earlier to our password file) htpasswd -b /etc/squid/squid_passwd 3738495 839423 Command 2. (edit our config file with the activation time and deactivate time) File location is: /etc/squid/[login to view URL] On line 38 of this file here is the line we need to change acl Activationtime time 00:00-23:59 Change to acl Activationtime time 10:00-11:00 Note: The server time is in UST so we can either convert the time from EST our database to UST or change the server time to EST. Our site has different time zones listed for activation so we need a solution to update the times. I think the best way is to change the remote server time to match the correct time zone. Should be able to do this with one line of code. Command 3. /usr/sbin/squid -k reconfigure 8. When the time reaches the Deactivate Time, we will need to do the following Run the command on the VPS sarg -x -e atcproxys@[login to view URL] Delete our VPS via API call [login to view URL] Remove DNS entry we made [login to view URL] * Remove IP from whitelist: Curl Example GET curl -v [login to view URL]${EMAIL}/${PASS}?ips=ip1 !important;ip2 !important;ipn