Latest News: (loading..)

Moxamint

♥Ambassador
  • Content count

    122
  • Joined

  • Last visited

  • Days Won

    4

Moxamint last won the day on July 24

Moxamint had the most liked content!

7 Followers

About Moxamint

Profile Information

  • Real Name
    Ai-Teh Eddy Lin
  • Gender
    Male
  • Location
    TAIWAN => a country, NOT part of China

Recent Profile Visitors

15,917 profile views
  1. So I guess it has fallen into the "great idea, doesn't work" category? Taiwan started using daylight saving in 1945 under the decision of Japanese government. It was then ended in 1980 by the Taiwanese government. It took the politicians so long to figure out daylight saving was merely an annoying thing.
  2. I am wondering if there is a statistics on the actually energy saving by doing this daylight saving thing.
  3. https://www.timeanddate.com/time/change/usa @ArtcoInc Thanks. Just wish there is no such thing...
  4. Hi Jack, Thanks for the comment. 1) My host in the USA could change the hosting location; 2) There is one thing called "daylight saving" and we do not have that in Taiwan. Result: the time offset could change without my awareness. My site generates custom order IDs based on the time orders are placed to match our ERP system, and these order IDs reset everyday. They highly reply on server time being sync to local time of Taiwan to operate. So if there is a way to avoid changing core code everywhere, I sure will vote for that. Cheers, Eddy
  5. Actually I just started my attempt to fix this time issue side-wise by using the old-fashioned way (core changes). I have defined the following: $dateServer = new DateTime("now", new DateTimeZone(date_default_timezone_get())); $dateStore = new DateTime("now", new DateTimeZone('Asia/Taipei')); $TimeOffset = $dateServer->format('H') - $dateStore->format('H') ...and am on my way to change all occurrences of 'now()'... An admin dashboard module would be extremely welcome... :) Cheers, Eddy
  6. @burt Yes about code did it :) ...and moon cake, fire crackers, and the whole nine yards. Cheers, Eddy
  7. @burt Hi Gary, Unfortunately it does not work by just changing 'now()' to 'now() - interval 10 hour' in checkout_process, because the function tep_db_perform() that will deal with the database later only recognizes 'now()' as one of the switches. if I move 'now() - interval 10 hour' directly into function tep_db_perform(), then it works correctly. Thanks and Happy Moon Festival, Eddy
  8. @Jack_mcs The add-on basically does what @burt suggested by moving the code to function tep_db_perform() so that the database time is altered each time the function is called. So I guess I have my questions answered. Thanks again, Eddy
  9. Thanks for confirmation. I'll look into it as well. Cheers, Eddy
  10. @burt Many thanks! Will try that. Although I could order their MySQL VPS but that would cost extra money every month... @Jack_mcs The add-on you pointed me to only instructed me to add define('CFG_TIME_ZONE', 'America/Los_Angeles'); in configure.php. That would only change the timezone php script uses, but the server / database timezone won't be affected. Maybe you meant to point me to this one Time Zone Offset - Adjust to match your instead?
  11. Hi, My company is located in Asia but my website is hosted in the States. I managed to change the timezone of the Apache server to match my location by adding date.timezone = "Asia/Taipei" in php.ini and I have also changed the related value in configure.php for both shop and admin. However, when an order was placed, the logged order time still used the US timezone. The database timezone was not changed. Is there a piece of code I should use to change the database timezone? Thanks in advance for your time and help. Eddy
  12. @OscPresto Hi, I had similar issue with Twitter Typeahead Autocomplete when and only when my site switched to using multi-byte languages such as Chinese and Japanese. @auzStar Dominic kindly offered me a solution and it solved the problem when searching in non-English languages. In file "catalog\ext\modules\header_tags\twitter_typeahead\autocomplete.php", find and replace all occurrences of the below - replace preg_with mb_ereg_replace replace strlen with mb_strlen replace stripos with mb_stripos replace substr with mb_substr Please also make sure your files are UTF-8 encoded. Best regards, Eddy
  13. That's what I was thinking about doing as well. Thanks, Eddy
  14. @Tsimi Hi Lambros - now is it possible to make this sort filter work on the search result page <<advanced_search_result.php>>? This file is quite different from specials and products_new. Made a few attempts with no joy... Thanks, Eddy
  15. Sure will do that - will talk with you later today. Thanks again, Eddy