updates to the custom PHP codebase

Site Changelog

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!