Contributions
Specials Expiration Fix
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.
Expand All / Collapse All
Updates the expiration fix to accomodate changes made in MySQL version 4.
This is the same fix as above but coded using standard php.
The previous code was not working on my version of php/mysql and would insert a null date
Discovered that my original fix created problems when updating specials that weren't supposed to expire. This version corrects the problem so that specials that weren't supposed to automatically expire won't.
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.
Note: Contributions are used at own risk.
Specials Expiration Fix
Proper Code for Special Expiry Fix