Kluge Kluge Kluge...

This message was sent from: Development
http://forums.oscommerce.com/viewtopic.php?p=179985#179985
----------------------------------------------------------------

[quote="orchard"]I think it's almost alway part of a query string, so it's difficult to know how else to change it.  One way would be to create a string[code]$now = 'now() - interval 3 hour'[/code] and then replace all occurrences of[code]'blah blah blah now() blah blah blah'[/code]with[code]'blah blah blah ' . $now . ' blah blah blah'[/code]It would still be a lot of substitutions, but you would only have to do it once.  After that you could edit the definition of $now.  Maybe it would be nice if osCommerce made this change as part of the standard code.[/quote]

Mr. Baker is correct. That is what I posted this to the development thread. If I'm in California and my server is in Russia or Hong Kong, then there is a problem in that I have to change about 50 files which use now() or another database time call as a function rather than making the change in one location (ie: setting the TZ variable on the server and letting the server serve me *my* time in *my* timezone). By relying on the database to provide the time we have created a piece of code that has to be modified may times by hand for a business process that is done often (colo or shared server services in another timezone).

With everything being done so modular, it seems a shame to force a developer to hand-edit this "feature".