Back in the early days of the Tie Fighter Alliance, things were easy. We had a few pages that Shawn and I could keep up without a
problem. We were a small and growing club, then Shawn got us into a War with a fairly new but very large club called the New Republic Navy (NRN).
Between being in an open war with one of the largest clubs
on the zone and allowing just about anybody to join the out club, we ended up getting about 10 - 15 people joining our club every week. Between adding new names to the rosters and squads, making changes to rank and
squadron assignments and just general maintenance I ended up with not much free time.
The Database
I knew there must be a better way. Our web hosting service offered a free database with the account we had so I ordered one. I had a
little dbase experience at work, but had no clue about how that translated out to the Internet. My first project was to automate the rosters and squadron listings so that they could be maintained from a secure web
page. This proved to be a daunting task that I spent well over 2 months actually figuring it all out.
The database itself was mSQL and I used PHP/FI (aka PHP2.0) to access it. PHP3.0 came out and I made
the changes, then mSQL had problems with a new version of Apache (the stuff that actually serves up web pages) and I had to do an emergency switch to a different database called MySQL, which was reported faster, more
stable and had more functions. This proved to be true.
Note: These pages are for historical purposes and content has not been updated since 2003