Invision Community 4: SEO, prepare for v5 and dormant account notifications Matt November 11, 2024Nov 11
Posted February 24, 20168 yr Hello together, my following question is related to the commerce topic. We want to switch to IPS. We are selling a product and want to use the commerce application to realize that. When we update our product it will result in a downtime. At the moment we use a different software and we need to add the downtime manually to the subscriptions. I am testing at the moment if it is possible to do it automatically with IPS4. My idea was to create a Block on the client site with an php code. With this code i want to execute a sql command which add the downtime to the subscription time. I found the table nexus_purchases where the ps_expire is located. If I change this value the subscription time will change. Problem for me is that I have no clue in which format this value is. Here is an example date/expire time value: "1456426517" This value shows in plain text the 25/02/2016 My question is: Will this way work for me? Do I need to explain my problem or ideo more detailed? Is there a better way to solve the downtime compensation? Regards Marius
February 25, 20168 yr It's a UNIX timestamp (seconds passed since Jan 01 1970). You can use an SQL query: UPDATE nexus_purchases SET ps_expire=( ps_expire + ( 60*60*24 ) ) WHERE ps_active=1 This would add a day to active subscriptions. 60*60*24 is a day in seconds, if you want two you can just append *2...
Archived
This topic is now archived and is closed to further replies.