z2

Indeed, I tried making one and it didn't show up at all.

The comment box is still linked to the underdogs

We can probably change the affiliation links

yeah, zeph's review appears and I'm like "It's fixed" then I cry when my review is kilt.

Haha, if you look at the date of that review, it was made in August of last year. I have no idea why it suddenly showed up. The review I was speaking of previously wasn't that.

Reviews seem to be working fine now. But the question is, do they work for Commodore?

They still don't work for me... =(

I'm a bit baffled. Some info on exactly what you did and what happened would be appreciated.

I typed a review for a game, clicked submit and was taken to the page that says, "Your review has been submitted and can be seen here." When I clicked the link, it wasn't there.

i have an odd feeling that the code for the review and comments scripts are still sending their updates to zzt.org, which no longer exists. i may be wrong though! i don't really know about these things

I am able to make test comments without a problem. As for reviews, I figured out the problem: single quotes/apostrophes were not being escaped in the review text, which screwed up the SQL queries if your review contained this character. This was why the review script worked for me but nobody else; I was testing it using random letters (but no punctuation), while everybody else was posting real reviews (including characters such as apostrophes).

Anyway, reviews should be fixed now.

Yay!

So uh, how did that script ever work on the old site?

Sorcery-assisted time travel.

http://yahoo.com/ wrote:So uh, how did that script ever work on the old site?

It's because of a little feature called Magic Quotes. Magic Quotes basically runs addslashes() automatically on all input received by the script; the idea is to escape certain characters (such as quotes) so that they don't mess up stuff like SQL queries. As far as I can tell, it was meant as a convenience; escaping important characters is one less thing you have to worry about.

However, I don't like it that much because it's a feature that can be turned on or off, depending on how PHP is configured. If your PHP script relies on Magic Quotes, moving it to a server on which that option is turned off will break it; the same goes for moving a script that expects raw input. This convenient feature actually makes PHP scripts less portable; to be portable, you must check to see if Magic Quotes is on before calling addslashes(), and this just seems like more hassle than it's worth.

I preferred Zandor's explanation.

The download of "ZZT Crime" is broken (case-sensitivity issues. You link to "crimes.zip" when the file is "Crimes.zip".)