Skip to content
  1. Aug 19, 2011
  2. Jul 05, 2011
  3. Jul 04, 2011
  4. Mar 20, 2011
  5. Feb 25, 2011
  6. Jan 16, 2011
  7. Nov 13, 2010
  8. Aug 04, 2010
  9. Feb 28, 2010
  10. Dec 02, 2008
  11. Aug 13, 2008
  12. Jun 20, 2008
  13. May 23, 2008
  14. May 15, 2008
  15. Mar 11, 2008
  16. Feb 22, 2008
  17. Feb 15, 2008
  18. Feb 09, 2008
  19. Feb 03, 2008
    • Karen Stevenson's avatar
      Getting rid of offsets!! Alter query code to cast ISO and UNIX dates to native... · 45c07632
      Karen Stevenson authored
      Getting rid of offsets!! Alter query code to cast ISO and UNIX dates to native datetimes and do timezone conversion in the database. Much faster and more accurate.
      
      This will mean this version of the code will not work for databases that are not able to do native timezone conversion, but even inexpensive shared hosts will probably have the MYSQL database timezone tables installed, and PostgreSQL has good timezone handling enabled by default.
      
      The MYSQL timezone conversion code should be accurate, the PostgreSQL code looks right from the documentation but needs to be verified.
      
      The offset fields can now be dropped from the Date fields since we only need the timezone name to do the conversion.
      
      I probably missed some places that need to be adjusted for this change, but this should get most of the necessary fixes in place.
      45c07632
  20. Jan 31, 2008
  21. Jan 26, 2008
    • Karen Stevenson's avatar
      Add in the jQuery popup selector as a method to jump to different dates. · ebdb4fec
      Karen Stevenson authored
      Rework the calendar to pull values from a template table so we can browse and navigate by calendar week. This simplifies the code and hopefully will speed up processing the calendar since the database is doing the work of constructing the calendar template instead of using PHP computations. This method is also a more accurate way of computing calendar weeks. Requires an update to populate a template table. This works because there are only 14 possible calendar templates no matter how many years you go back or forward.
      
      More work needed, this is just the initial pass.
      ebdb4fec
  22. Jan 15, 2008
  23. Dec 20, 2007