Community Add-Ons
| Maintainers: | wdepot |
 Add file to this package |
|
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
Download Report
Updates the expiration fix to accomodate changes made in MySQL version 4.