Site Changelog

• Database:
  • wrote a script to strip the slashes out of my database. slashes were icky.
    • cleaned all code of unneccesary slash stripping.
    • Admin Tools:
      • made main admin page reflect topics for news entries
        • news edit and adding uses topics for ease of navigation
        • Main Pages:
          • added “next/prev” navigation for individual viewing of entries.
            • changed layout of “next/prev” on multi-view(default view)
              • display time zone

I originally wrote this website software to run on a crappy HP-UX box that only had PHP ver. 3.0.8 or something. It was horribly outdated for its time even. That was September 25, 2001. Nearly 2 years ago. Anyway… I started first by trying to implement the database with DBM. DBM sucks. I didn’t try that for long at all. After that I decided to just use flat text files with custom delimiters and a small API for accessing and updating the data in those files. That’s probably why I didn’t spend a lot of time writing admin pages at the time; the parsing of all that text got ugly fast.

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.