updates to the custom PHP codebase

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!