This week I’ve made several major and minor changes to the website code. I’ll start keeping track of what I do here. It’s high time I know what I do when with this site.

• Database:
  • Added hit counter tables
  • Added an order column for topics
  • Added link table
  • changed date fields in links and quotes to datetime fields
• Libraries:
  • Added Date_Calc class library for better handling of dates and formatting of dates. (File: Calc.php)
  • Used in new code, haven’t yet retrofitted old code to use.
  • Added Counter function for tracking visits to each page and direct visits to articles. (File: hit_counter.php)
  • Added my_escape_SQL_single_quote function for cleaner data in database.
    (File: my_utils.php)

  • Added functions for clean date formatting. (File: my_utils.php)
• Admin Tools:
  • Improved robustness and error checking on news posting code.
  • Eliminated code that was putting slashes into my database by instead passing database bound strings through my_escape_SQL_single_quote.
  • Added quote management tools
  • Added link management tools
  • Added topic management tools
• Main Pages:
  • Modified CSS. Now is a bit cleaner and is more consistent in handling of hovers for A HREF’s, plus added that nice red glow on hover.
  • Cleaned up some HTML errors in templates and did some minor reformating.
  • Changed header from silly fade thing to big bold thing that can be changed with out massive formatting headache.
  • Unified code template for news topics (index.php) and others (quotes.php, links.php, photos.php)
  • Added permalink ability. Figured it’s about time that people can link to a specific entry on my site.
  • Removed my “hidden” link to “All Quotes” page and replaced with a clearly labled “more quotes” link.
  • Added a “links” side section with full links page and “more links” link.
• Added This Changelog!