Jon, I'll get that to you this evening/tomorrow morning.
It's probably no big surprise, but I've been working on the internals of the code with an eye to fresher platforms.
Current ramifications include much of the site rewritten on paper (okay, text files untested) in PHP 5 and PostgreSQL. By much, okay, I don't mean most. But if in a miracle it didn't need debugging, one could read and post and many of the internals are awaiting presentation for things like editing and deleting and admin stuff.
What's the advantages of PostgreSQL vs. mySQL?
I can't speak for later versions of MySQL, since I haven't developed for it past the version we're running now. I think it's catching up, but PostgreSQL has long had stuff like stored procedures and triggers and the like. It's supposed to be more stable, but like most stuff, it depends who you ask.
You might want to experiment with SQLite, also.
From looking at their web page I don't think they support everything we currently use in terms of SQL commands. Do many hosts offer it?
Hosts are generally MySQL, then PostgreSQL. PostgreSQL's been more advanced for many years. That said, I use MySQL myself nowadays and later versions are much improved, both in features and -- rather critically -- stability. I still wish I didn't have to manually rebuild and optimize tables, though, and the lack of active-active replication bugs me.
SQLite is a library that's built into PHP 5.
From the docs, SQLite looks like an extension to PHP. The install we're running doesn't seem to have it.
New Suggestion:
Y'know how there are people who don't like white-fonted discussions? What if we changed the "s" quickedit to substitute a class, let's call it "spoiler", that was defined as {color: #FFF} in the default stylesheet? Then, once we implement the css update, users who don't like whitefont could use the custom stylesheet utility to redefine the spoiler class to any color they like!
t on edit
I see that there's already a spoiler class with that exact definition, but it's not being used for the quickedit.
I see that there's already a spoiler class with that exact definition, but it's not being used for the quickedit.
I'm not sure why it's not being used for the quickedit. That's an oversight on my part. Let me fix that right now.
And then I'll look over the files you sent, and toss you the password in question.
Part of what I am trying to achieve with the rewrite exercise is to put all the HTML generation on one level, so it's easier to maintain. Right now all sorts of code, classes and pages, can generate HTML. Messy, messy, messy. Want to separate form from function as much as possible.