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!

[SirSteve]

Thanks! Hopefully the next version of vb will include this!

[clearchannel]

Has anyone gotten this hack to work on their vb? I've copied and pasted the hack a few dozen times, and can not for the life of me get it to work.

Would someone be willing to look at the three files I hacked and maybe tell me where I went wrong?

I certently would appericate some help with this.

Thanks

[clearchannel]

Let me see if I can save sometime.

When I first hack the three files, I received the following error message:

Parse error: parse error in /home/virtual/*******/home/httpd/html/forums1/calendar.php on line 461

Here is what that line (461), and the lines before (460) and after (462) the look like in my editor:

460: // Moderation Queue for Calendar Events (v1.0)
461: FROM calendar_events, user
462: WHERE eventid = $eventid AND calendar_events.userid = user.userid"))

[Admin]

E-Mail me your hacked files Clearchannel.

[clearchannel]

I have this hack installed, and it works great.

A much needed feature, or at least for my forums.

Thanks Firefly

[gabs]

I got it working under v2.0.3 with just a two minor adjustments:

Instead of doing what the instructions tell u to in mod/index.php (you won't find the code to replace). Do this:

find:

PHP Code:

<a href="moderate.php?s=<?php echo $session[sessionhash]; ?>&action=posts"> Moderate New Posts </a><br>

bellow it add:

PHP Code:

<!-- // Moderation Queue for Calendar Events (v1.0) -->
<a href="moderate.php?s=<?php echo $session[sessionhash]; ?>&action=calendar"> Moderate New Calendar Events </a><br>
<!-- // Moderation Queue for Calendar Events (v1.0) -->

And finaly to prevent unmoderated events from showing up on the calendar, in admin/calendar.php :

find:

PHP Code:

LIKE '$year-$doublemonth-%' AND ((userid = '$bbuserinfo[userid]' AND public = 0) OR (public = 1))"); 


replace it with:

PHP Code:

LIKE '$year-$doublemonth-%' AND ((userid = '$bbuserinfo[userid]' AND public = 0) OR (public = 1)) AND visible=1"); 


That is, works like a charm - thanx firefly

[Shenlong]

GREAT HACK FIREFLY! u rock!

[Ghostsuit]

Great hack works like a charm however did notice that when copy pasting text some of the statements were appearing in the //commented out area. so had to manually correct that.

Might be the cause of others problems.

[jamesdasher]

I am having some trouble getting this to install on vb 2.2 is there an update...or is it just me...

2 things primarily...

1. the code:

PHP Code:

if($info = $DB_site->query_first("SELECT eventdate,allowsmilies,username,event,subject,calendar_events.userid,public 


doesn't appear in the order given in the install file...it is way at the top of the document (I could only find one instance of this)

2. the code:

PHP Code:

$subject = htmlspecialchars($info[subject]); 


appears in the file 2 times...

that is as far as I have currently gotten, hope you can help

James

[Ghostsuit]

Just installed this on 2.2.4 however I used beyond compare to merge the code to the new files but it seems to work fine.