downloads controller finding wrong date

[Guest]

Downloads Controller is pulling the expiration date for downloads as always being Dec. 7, 1999 (it did this once before, & always used the same date).

 

The date of purchase is correctly entered in the database. DC is using this piece of code to get the expiry date:

 

while ($downloads = tep_db_fetch_array($downloads_query)) {
// MySQL 3.22 does not have INTERVAL
     list($dt_year, $dt_month, $dt_day) = explode('-', $downloads['date_purchased_day']);
     $download_timestamp = mktime(23, 59, 59, $dt_month, $dt_day + $downloads['download_maxdays'], $dt_year);
     $download_expiry = date('Y-m-d H:i:s', $download_timestamp);

 

Where is this code telling it to find the date, exactly? The problem is either in my database or in the code, one. I could really use some help here. That customers can never download properly is quickly affecting the credibility of our store, just as we're getting going.

 

Thanks,

 

Wendy