vb.org Archive - Calendar Enhancements - Farcaster's Event Attendance

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vBulletin 3.6 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=194)

- - Calendar Enhancements - Farcaster's Event Attendance (https://vborg.vbsupport.ru/showthread.php?t=129088)

Hmmm....

As I posted in the integration thread (integration to Evercrafts Event Forum Hack) I can't get this to work... I'm posting here now because I uninstalled everything in an attempt to trouble shoot this thing.... So here's where I am.

1) Uninstalled Evercrafts Event Forum Hack....

2) Uninstalled the Bridge Hack....

3) Uninstalled the Attendance hack....

4) Reinstalled the Attendance hack (Overwrite for safe measure)...

5) Create an event in the calendar with RSVP checked (I can see the RSVP options when I create the event)

6) Click on the event I created and note there is no RSVP option for users to interact with.

7) It should be noted that I have all forums with RSVP enabled within the ADMIN options....

I assume why it is not working here might be why it is not working when I have all of the previously uninstalled hacks applied. *shrugs*

I am using vB 3.6.8

How can it be done, to display the amount of people who want to attend ("yes") to an event, on the weekly and monthly calendar view?

like done here:
http://www.future-music.net/forum/calendar.php
http://www.future-music.net/forum/ca...o=displaymonth

that would be a great feature

I'm using this with the forum events mod and when any recurring event is RSVP'd to it rsvp's to the entire sequence instead of individual events. Do I have a setting wrong someplace?

I am having some issues with people using IE and signing up for an event. When they do it takes them back to the login. I have uninstalled and reinstalled the addon and nothing seems to work.

Any ideas?
(you can check at: eternaldestinyguild.com)

Quote:

Originally Posted by kai3k (Post 1345793)

I agree, that would be a very nice add-on. I tried adding the "total number of yeses" variable (that is used in the event description) into the Weekly template, but it didn't display. It pulled in the "Yes" phrase, but that's it.

Hi. I just installed this mod to my test site. Thank you very much for hard work.

I have the following problem.

After the install and adding RSVP to an event I can no longer edit or delit an event.

I get a message displayed that I do not have enough permissions for editing. And for deleting I just get the page reloading. Once the RSVP mod gets disabled everything starts to work normal again.

Please help.

Thank You

I have an issue with this interferring with custom holidays.

If a user event and a custom holiday appear on the same day, it tries to treat the holiday as a regular calendar event, and returns a SQL error.

Anyone know how to turn this off for custom holidays? Other holidays, on days that don't have a user event, are just fine.

Here are some examples:
Regular holiday with no user event: http://www.graceofthevalar.com/calen...=2007-10-3&c=1
Event and holiday on same day: http://www.graceofthevalar.com/calen...2007-10-20&c=1
(since I get all the emails about the SQL error, please only click if you are trying to help me :) Thank you!)

Quote:

Originally Posted by Elenna (Post 1360683)

http://www.graceofthevalar.com/calen...2007-10-20&c=1
(since I get all the emails about the SQL error, please only click if you are trying to help me :) Thank you!)

Elenna,

I cannot see the underlying SQL error when I open the link you gave. Can you PM or post the error?

BTW, I'm a LotRO player as well, but I'm on the Brandywine server. ;)

Quote:

Originally Posted by Farcaster (Post 1361154)

Elenna,

I cannot see the underlying SQL error when I open the link you gave. Can you PM or post the error?

BTW, I'm a LotRO player as well, but I'm on the Brandywine server. ;)

Bah, you chose the wrong server! ;) Too bad, would have been fun to adventure with a vB coding god. LOL

Here's the error message. Note that I did modify the plugin to pull some profile fields so that might account for it? Boy I'll feel dumb if I messed it up myself!

For the edits I did, scroll up a few pages (2-3), I posed the edits I did.

On the standard "Database Error" page (meaning no vB "wrap"):

Code:

Database error in vBulletin 3.6.8:

Invalid SQL:

        SELECT    u.username, ea.userid, ea.response , ea.comment, ea.guests, ea.rsvp_date, u.avatarid, , userfield.field8, userfield.field9, u.avatarrevision, avatarpath, NOT ISNULL(customavatar.userid) AS hascustom, customavatar.dateline,

            customavatar.width, customavatar.height

        FROM    eventattendance ea

            INNER JOIN user u ON u.userid = ea.userid

            LEFT JOIN avatar AS avatar ON avatar.avatarid = u.avatarid

            LEFT JOIN customavatar AS customavatar ON customavatar.userid = u.userid        

  LEFT JOIN userfield AS userfield ON userfield.userid = u.userid

        WHERE    eventid = 04

            AND ocdate = '1192838400'

        ORDER BY

            ea.response , u.username;

MySQL Error  : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' userfield.field8, userfield.field9, u.avatarrevision, avatarpath, NOT ISNULL(cu' at line 1

Error Number : 1064

Date         : Monday, October 15th 2007 @ 07:34:07 PM

Script       : http://www.graceofthevalar.com/calen...2007-10-20&c=1

Referrer     : http://www.graceofthevalar.com/calendar.php

Classname    : vb_database

Elenna, the error in the SQL is right here:

[SQL]u.avatarid, , userfield.field8[/SQL]

There is no column specified between u.avatarid and userfield.field8. I think this has something to do with your custom modification, because I cannot reproduce this problem using the unmodified version on my forums.

Quote:

Originally Posted by Elenna (Post 1361206)

Bah, you chose the wrong server! ;) Too bad, would have been fun to adventure with a vB coding god. LOL

Far from a god. I am but a pattawan learner, as it were ;)

X vBulletin 3.8.12 by vBS Debug 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 (4)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (2)pagenav_pagelinkrel (1)post_thanks_navbar_search (1)printthread (10)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
Messages:

Phrase Groups Available:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01412 seconds Memory Usage 1,751KB 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 (4)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (2)pagenav_pagelinkrel (1)post_thanks_navbar_search (1)printthread (10)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
Messages: