FireFly, people are having that comment in the middle of the query because that's what your instructions say to do. Step 6 of the calendar.php instructions say to find this:
PHP Code:
if($info = $DB_site->query_first("SELECT eventdate,allowsmilies,username,event,subject,calendar_events.userid,public
And replace it with this:
PHP Code:
// Moderation Queue for Calendar Events (v1.0) if($info = $DB_site->query_first("SELECT eventdate,allowsmilies,username,event,subject,calendar_events.userid,public,visible
// Moderation Queue for Calendar Events (v1.0)
Also, I noticed that in I think all the instructions for calendar.php (that's as far as I've gotten so far, I'm in the middle of installing it), every bit of code to add has had comments in it, like "// Moderation Queue for Calendar Events (v1.0)", but most of them, if you just select and copy it out of the box into the file, will have the first bit of code on the same line as the opening comment. Like this, from Step 1:
PHP Code:
// Moderation Queue for Calendar Events (v1.0) $eventinfo = $DB_site->query_first("SELECT allowsmilies,public,userid,eventdate,event,subject,visible FROM calendar_events WHERE eventid = $eventid");
// Moderation Queue for Calendar Events (v1.0)
It's of course not a problem for me to put adjust the code so the real code appears on a new line between the comments, but this might be something you could fix in an updated release.
Finally, in Step #7 of the instructions for calendar.php (this is the reason I'm here in the middle of installing this hack in the first place), that bit of code to find appears twice. Do we add the new code before both of them, or just the first or second? Someone else did the first; I'm doing both, and I'll try to test it, but an official word would be nice.