Community Add-Ons

Maintainers: wdepot
Add file to this package
Top » Features

Specials Expiration Fix
for osCommerce Online Merchant v2.2

I discovered that our special prices were being expired by the system a day earlier than planned. I discovered that the cause of the problem was the fact that the code that automatically turns off specials that expire checks the current date AND TIME against the date that the special was set to expire. The specials administration only sets the date for expiration which means the time is automatically set to midnight (00:00:00) of that day. The moment midnight passes as the day begins the special gets expired instead of being expired at the end of the day like it should be. The fix is very simple as detailed in the attached text file.

Legend:  Download   Report

Expand All / Collapse All

Specials Expiration Fix wdepot 3 Nov 2006  

Updates the expiration fix to accomodate changes made in MySQL version 4.

Proper Code for Special Expiry Fix Phocea 8 Jul 2006  
Specials Expiration Fix wdepot 6 Jul 2006  
Specials Expiration Fix wdepot 31 May 2006