vb.org Archive
Page 2 of 2 1 2
Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 2.x Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=4)
-   -   Moderation Queue for Calendar Events! (https://vborg.vbsupport.ru/showthread.php?t=32380)

JulianD 03-21-2002 08:22 PM
I got a problem with this hack... it works good, but today a user submitted an Event with HTML code in it, and the HTML didn't work.... Can you guys check it out? Submit an event with HTML, and see if after the approval, the HTML is working?

HellRazor 03-23-2002 08:45 PM
Firefly, did you ever get a chance to add email notification? What would be cool is, when someone submits an event, the admin gets an email with a link, and just by clicking on the link, the event is approved.

FleaBag 05-19-2002 11:36 PM
Installed this and it all appears to be working fine on 2.2.5. jamesdasher is right, the code appears in the file twice. I added the code before the first reference. I warn everyone to make sure when they copy and paste the code to be added to manually remove PHP code from the commented lines, for some reason it is written in them?! Anyway, thanks for this hack - just what I needed! :D

FleaBag 05-20-2002 01:05 PM
Argh just got a database error...

Quote:
Database error in vBulletin 2.2.5:

Invalid SQL: SELECT
eventdate,allowsmilies,username,event,subject,cale ndar_events.userid,public,visible
// Moderation Queue for Calendar Events (v1.0)
FROM calendar_events, user
WHERE eventid = 7 AND
calendar_events.userid = user.userid
mysql error: You have an error in your SQL syntax near '/ Moderation
Queue for Calendar Events (v1.0)
' at line 2

mysql error number: 1064
...Anyone have any ideas what's up? Thanks in advance. :squareeyed:

FleaBag 05-21-2002 10:25 PM
*Bump*

Admin 05-22-2002 05:29 AM
For some reason you have this:
Code:
// Moderation Queue for Calendar Events (v1.0)
In the middle of a query... remove it. :)

FleaBag 05-22-2002 12:41 PM
D'oH! Thanks FireFly, and thanks gabs for the fix! :D

FleaBag 06-20-2002 12:41 PM
Works on 2.2.6! :) Also, for mod/index.php, do this [not what's in the instructions].

Replace...
PHP Code:
makenavoption("New Posts","moderate.php?action=posts","<br>"); 
...with...

PHP Code:
makenavoption("New Calendar Events","moderate.php?action=calendar","<br>");
makenavoption("New Posts","moderate.php?action=posts","<br>"); 

FleaBag 06-20-2002 05:00 PM
Having problems with this hack again after my upgrade...

Quote:
Invalid SQL: SELECT
eventdate,allowsmilies,username,event,subject,cale ndar_events.userid,public,visible
// Moderation Queue for Calendar Events (v1.0)
FROM calendar_events, user
WHERE eventid = 30 AND
calendar_events.userid = user.userid
mysql error: You have an error in your SQL syntax near '/ Moderation
Queue for Calendar Events (v1.0)
FROM calendar_events, user
' at line 2

mysql error number: 1064
...Getting that when viewing an event on the Calendar. Anyone able to help? Thanks in advance. :)

FleaBag 06-20-2002 05:07 PM
OK nevermind, I looked at that quote 10 times and it wasn't until I posted it here I realised I had a comment in the middle of a query. Seems to be working 100% now! :)

clearchannel 06-23-2002 02:39 PM
Is your code correction in your last post correct. I'm having a hard time getting this to work in 2.26.

thanks

FleaBag 06-23-2002 06:51 PM
It's correct as far as I know. Everything works perfectly for me.

JJR512 07-27-2002 05:36 PM
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 07-27-2002 06:14 PM
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 07-28-2002 02:34 AM
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 07-28-2002 02:51 AM
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 07-28-2002 02:53 AM
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 07-29-2002 11:15 PM
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 09-05-2002 08:27 PM
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 12-18-2002 07:20 PM
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?

Richard 12-18-2002 07:39 PM
Quote:
Originally posted by 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?
Oh nevermind. I found out the problem.

I got around it by creating a custom template for the error message.

snyx 01-10-2003 08:08 PM
mmmmm, this hack took some tweaking on 2.2.9 but I got it
thx for the email responder too JJR

one downside, I wish the event wouldnt show on the calendar untill allowed, oh well.

FleaBag 04-01-2003 12:02 AM
There is a fix for that earlier in this thread.

Boofo 04-01-2003 12:20 AM
Can someone post a text file with all of the fixes in it for this hack?

FleaBag 04-01-2003 12:50 AM
Give me 10 minutes...

Boofo 04-01-2003 12:56 AM
Thank you, sir. ;)

FleaBag 04-01-2003 01:30 AM
Grrr... I just posted a finished version of instructions, only to find it isn't working. :(

I'll keep working on it...

MACHOBY 04-01-2003 04:15 AM
I have tried to do this like 5 times and every time I finish, the entire calendar goes blank. I must be doing something wrong in the calendar.php changes. Could someone attach their calendar.php file here for me?

Thanks!

Boofo 04-01-2003 05:29 AM
Quote:
Yesterday at 09:30 PM GamerForums said this in Post #67
Grrr... I just posted a finished version of instructions, only to find it isn't working. :(

I'll keep working on it...
Great! Thanks and please let us know when you have something. ;)

FleaBag 04-01-2003 01:29 PM
Quote:
Today at 06:15 AM MACHOBY said this in Post #68
I have tried to do this like 5 times and every time I finish, the entire calendar goes blank. I must be doing something wrong in the calendar.php changes. Could someone attach their calendar.php file here for me?

Thanks!

I don't get a blank page, rather none of the features that are supposed to be added work. And attaching calendar.php here would be illegal.

portalguy 05-02-2003 04:49 PM
makenavoption("New Calendar Events","moderate.php?action=calendar","<br>");
makenavoption("New Posts","moderate.php?action=posts","<br>");

But it is still not showing on hte admin page :banana:
vb 2.3.0

FleaBag 07-05-2003 05:14 PM
So you've got the rest of it to work?


All times are GMT. The time now is 09:14 PM.
Page 2 of 2 1 2
Show 40 post(s) from this thread on one page

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01184 seconds
  • Memory Usage 1,818KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_code_printable
  • (7)bbcode_php_printable
  • (5)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (1)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (32)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 
Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 
Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete