Moderation Queue for Calendar Events!

This was requested by clearchanel yesterday:
http://www.vbulletin.com/forum/showt...threadid=33118

The idea is, letting normal members post public events for all to see, but still avoiding the abusive members abuse this feature.
Basically, if the option is turned on, all new public events will be added to a moderation queue, similar to the way new attachments and posts are moderated.
Each moderator will then be able to approve public events in a special place in his Mod CP.
A link is added there, see the screen shot in the zip file for more info.

That's all I think there is to this.
To install this hack, download the attached zip, extract it, and upload install_modqueuecal.php to your admin folder. Then go to it in your browser, and follow all the instructions that will be presented to you.
The install script will run two queries. One will add a field to your calendar_events table, and the other will add the new admin option.
Uninstall procedure is also avaiable.

A demo of the validating screen can be found in the zip file.
By the way, moderation is bypassed for mods and admins, so they can post without having to validate the events.

Not sure if this will work on versions prior to 2.2.0, but I don't expect any problems with it.

That's it I think.
Feedback is welcomed as always!

[clearchannel]

Is your code correction in your last post correct. I'm having a hard time getting this to work in 2.26.

thanks

[FleaBag]

It's correct as far as I know. Everything works perfectly for me.

[JJR512]

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.

[JJR512]

One question: When someone submits an even, the title shows up on the calendar, but clicking it gives an "invalid event id" message until the event is moderated (approved). Is this intended behavior? Shouldn't nothing show up until it's approved?

[JJR512]

OK, for the record, in Step 7 of the instructions for calendar.php, you do it for the FIRST instance of the found code, and not for the second! If you do it for the second, then if you click on the link that is the number of the date in that date's box, you will get an invalid id error message. I guess that sounds confusing...don't worry about it, just do it to the first instance only and you'll be fine.

[JJR512]

You know what...I could be wrong. I've just discovered that if you don't do it for the second bit of code, then anyone can click on the date link to see the event for that day, even before it's been moderated. If you click the event itself, you still get the invalid id message, though. Now I'm confused.

[JJR512]

Here's how to get an email message whenever someone posts a public event that gets queued. These instructions assume you have completely installed the hack as instructed.

In calendar.php, find:

PHP Code:

// Moderation Queue for Calendar Events (v1.0)
               if ($moderateevents and ($bbuserinfo[usergroupid]!=5 and $bbuserinfo[usergroupid]!=6 and $bbuserinfo[usergroupid]!=7)) {
                 $visible=0; 


After that, add:

PHP Code:

                 $emailsubject="New Calendar event awaiting moderation";
                 $emailmessage="A new public event has been posted to the $bbtitle Calendar and requires your approval before becoming publically available. Please login to the $bbtitle Moderator Control Panel ($bburl/mod) to review it.";
                 mail($webmasteremail,$emailsubject,$emailmessage,"From: \"$bbtitle Calendar Event Queue\" <$webmasteremail>"); 


That's it.

[FleaBag]

Dude there's a fix earlier in the post for un-moderated events appearing on the Calendar. And thanks for this e-mail feature! It's very useful as at times I haven't authorised events until they've passed!

[fabz]

Hi,
i have vb2.2.5
I launched the installation script wthout any error, great !
In the cp, the calendar is activated and moderated.

I connect as a moderator and go to calendar...
nothing changed, I only have the "private event" button...

May someone help me ?

[Richard]

I just installed this hack on vBulletin 2.2.9. It works great except for this problem:

When a user posts an event, all is fine and dandy, until he's redirected back to his own event. It shows up as event invalid. Is it supposed to be this way or is there something I'm doing wrong?