The update of the database with the calculated expiration date doesn't work.
The value which appears in the database is 0000-00-00.
I edited the store order details behavior on the pp_confirm.php page and pasted the code above in the "Value" field of the expiration date column as type: text.
Also I added the where clause on the Wadaorderdetails recordset on the download_center.php page - like you suggested.
Strange was also one try I did changing your code to:
<?php echo(date("Y/m/d", mktime(0, 0, 0, date("Y"), date("m"), date("d")+ 31))); ?>
(Just wanted the sequence of numbers like it is in the order history!)
Then I got as calculated expiration date: 1970-01-01
Changed the code to how it was before, then I got again: 0000-00-00
Did I something wrong or is something wrong with the code?
Thank you for any help!