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

Page 8 of 12

« First

Last »

Show 40 post(s) from this thread on one page

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)

TheMilkCarton

07-25-2007 09:26 AM

I have 1.2.1 installed, and I have just noticed n's are still being truncated.

At what part in the code did you implement this code fix? I'd like to look in the plugins and make sure it's there correctly.

chris1979

07-28-2007 07:50 AM

Anyone going to respond to Elenna?

y2krazy

08-17-2007 10:56 PM

Is this compatible with 3.6.8?

Farcaster

08-20-2007 09:36 PM

Quote:

Originally Posted by y2krazy (Post 1319938)

Is this compatible with 3.6.8?

Yes.

Elenna

08-21-2007 08:26 PM

Quote:

Originally Posted by chris1979 (Post 1303717)

Anyone going to respond to Elenna?

:D I keep checking, but I'm not holding my breath :)

SVTCobraLTD

08-24-2007 03:43 PM

Found my answer. Will be installing this shortly.

SVT

USAMustangs.com

09-07-2007 06:49 AM

Installed and it seems to be working fine for all newly created calendar events.

However, how can you get to add the RSVP to calendar events created prior to installing this feature?

Thanks.

Elenna

09-07-2007 01:45 PM

Quote:

Originally Posted by USAMustangs.com (Post 1334077)

Installed and it seems to be working fine for all newly created calendar events.

However, how can you get to add the RSVP to calendar events created prior to installing this feature?

Thanks.

I haven't tested it, but you should be able to Edit the Event (where you would change description, etc) and check the Allow RSVP box.

Elenna

09-07-2007 02:39 PM

I believe I've figured out how to get custom userfields to display.

NOTE: This involved modifying the plugins used. This will pull the most current information in the database, as opposed to pulling that information at the time that the person RSVPd.

Step 1: In AdminCP, go to User Profile Fields and make note of the field names (i.e. field14) that you want to use.

Step 2: Go to Product Manager> Plugin Manager Scroll down until you see "Add RSVPs to Event Description"

FIND

Code:

// SELECT SQL for RSVPs for this event

IN LINE

Code:

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

            customavatar.width, customavatar.height

ADD

Code:

, userfield.field14, userfield.field10

(add or remove ,userfield.field for each profile field you need to pull)

FIND

Code:

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

ADD AFTER

Code:

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

Now you can modify your template (Style> Your Style> Edit Templates> Calendar> calendar_rsvp_bit)
You can use $rsvp[fieldXX] wherever you'd like that field to display, replacing XX with the field number, like you added to the select statement above.

Now, every time the event is viewed, it will pull the most current information from those profile fields and display them.

If you'd like to change the option to sort by one of the profile fields (for raids, etc) you can edit the following section:

In same Plugin above, FIND

Code:

    // Display RSVPs

    // Setup Sort Order

    switch($vbulletin->options['rah_rsvp_sort']) {

        case 0: $orderby = "u.username"; break;

        case 1: $orderby = "ea.rsvp_date";break;

    };

REPLACE with:

Code:

$orderby = "userfield.field14";

Be sure to REMOVE the ending };

Where field14 is the field that you wish to sort by.

DJFriar

09-08-2007 06:59 PM

Is there a way to disable the ability to select "No"??? I want people to just be able to say they are attending or they might be able to attend. We don't care who can't attend.

edfig

09-15-2007 03:54 AM

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

kai3k

09-24-2007 08:19 AM

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

IvyKeepMommy

10-04-2007 10:18 PM

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?

SnoozerD

10-05-2007 02:55 PM

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)

Elenna

10-10-2007 01:49 AM

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.

crkgb

10-12-2007 12:27 AM

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

Elenna

10-15-2007 12:38 PM

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!)

Farcaster

10-15-2007 10:57 PM

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. ;)

Elenna

10-16-2007 12:37 AM

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

Farcaster

10-16-2007 03:52 AM

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 ;)

Elenna

10-17-2007 02:11 AM

Oops!!

Thanks so much. I did get an additional , in there in my code.

Thank you for the second pair of eyes. I'm sorry to bug you!!

This now works :)

I'm not sure if this is your design, or something in vB... but now that I can see the event, is it supposed to show both events (the holiday and the RSVP event) on the same page? This only happens when I view the Holiday. When I click on the RSVP event, I only see the event, not the holiday.

See this link:
http://www.graceofthevalar.com/calen...day=2007-10-20

Farcaster

10-18-2007 01:54 AM

Quote:

Originally Posted by Elenna (Post 1362010)

'm not sure if this is your design, or something in vB... but now that I can see the event, is it supposed to show both events (the holiday and the RSVP event) on the same page? This only happens when I view the Holiday. When I click on the RSVP event, I only see the event, not the holiday.

If you click on an event from the month or week view, you should only see the event you clicked on. That is default vBulletin behavior. If you click on a day, or I suppose a holiday, you'll see everything that is scheduled for that day.

Elenna

10-18-2007 02:09 AM

Thanks for the reply! I was thinking that that is probably the default behavior. The bummer is that is shows the RSVP form for the event on that day, which is confusing to folks, but that certainly isn't your fault!

pgb	10-20-2007 09:17 PM

i just upgraded from vb 3.6.3 to the latest release and all of the rsvp's that people had previously posted are gone.

any ideas?

thanks in advance for your help.

sandbender

10-22-2007 03:17 AM

Great hack! Very useful in my forum.

Except I too need a custom user field instead of avatar.

Could we maybe use the guests field?

IGCEMA

10-23-2007 11:20 AM

Is there a possibility of adding a way to manually add an individual to the RSVP list by username?

IvyKeepMommy

11-05-2007 12:01 AM

I'm continuing to have a problem with RSVP's on ranged events (the response to the first day of the event carries through for all instances of the event). Any help on how to fix this? And if there isn't a fix is there a way to simply disable the ranged events so that they can't be used that way, and thus force my users to put in the events individually?

I run a mommy group with lots of playdates (many of them weekly events) and it's really messing up the planning to have the incorrect reponses posting.

Thanks for your help and a great mod!

Underlab

11-06-2007 09:57 PM

This is awesome.

chris1979

11-09-2007 05:20 PM

This is a brilliant mod and it works great for me, but I have one question. I'd really like the first entry in the thread (the calendar entry) to look the same as the other entries (the forum posts).

I have custom fields in my forum postbit so I need to find a way to get those custom fields to show up in the calendar entry.

Does anyone know how I can get custom fields to appear? (For example, in the postbit template I just type $post[field7] - how can I get that same data to show up in the calendar template?)

Thanks in advance.

Chris

TheMilkCarton

11-11-2007 03:37 PM

Chris,

You're posting in the wrong modification section. This mod is completely separate from vB Event Forums, which is what turns an "event" into a "thread". As for the custom fields, you'd probably have to add a query to grab them, although since the Event Forums turns the calendar into a normal forum, the $post field method should work? I guess not though.

Farcaster,

Can you share the old contents of the calendar_update_complete plugin, or whatever used to update the RSVPs when you change the event date? I'm currently trying to reverse it, and the easy part was stopping the deletion of the RSVPs, but now I'm trying to recreate the update query to set them to the right date (they still disappear when I change the date, but reappear when I change it back)

*snip*

Nevermind, I got it changed the way I want it. I even added an automated PM informing members of a date change. :)

Jaxel

11-23-2007 10:49 PM

This mod doesnt work for me at all... the rsvp form never shows up, even after I add it to the calendar_showeventsbit.

I also have vbEventsForum mod installed, if that matters. Is there anyway to get this to work with the vbEvents Forum?

Farcaster

11-23-2007 10:51 PM

Quote:

Originally Posted by Jaxel (Post 1388350)

I also have vbEventsForum mod installed, if that matters.

You need the integration hack. This hack will not work without it.

Jaxel

11-24-2007 03:43 AM

Where do I get this integration hack?

dismas

11-28-2007 05:20 PM

Quote:

Originally Posted by Jaxel (Post 1388436)

Where do I get this integration hack?

See the "Add ons" section of the release post at the top of this page. The first link is for the integration mod.

rpainter

11-29-2007 09:51 AM

For the events that I post, you have to go to both days. How can I set this up to RSVP all days of a ranged event?

rpainter

11-30-2007 04:18 PM

Is this MOD still supported? If so, I really need to know the answer to my first question and I have 1 more.

I only have 1 calendar on my forum. This calendar needs to be viewable by everyone...registered users, guests, etc. However, I have a custom usergroup (Judges). I only want that usergroup to be able to RSVP to the events. Is this possible?

Thanks.

rpainter

11-30-2007 05:15 PM

OK. I figured out the second one. In calendar_showeventsbit, I replaced $rsvp_form with

Code:

<if condition="is_member_of($vbulletin->userinfo, 6, 9, 10)">

$rsvp_form

</if>

If you need this, just replace the numbers (6,9,10) with your usergroup IDs.

I still would like to know how to make it RSVP for ALL days of a multi-day event.

powerful_rogue

12-01-2007 01:04 AM

Hi,

Ive just had a member of my forum ask this:

Quote:

I am getting very very bored with typing up a response to an interesting thread that relates to a past event and when I submit it I get an error message saying :

Invalid Event please contact administrator

Is it just me?

Apparently a few others get this message as well.

Any ideas what may be casuing this?

IvyKeepMommy

12-05-2007 02:41 AM

Quote:

Originally Posted by powerful_rogue (Post 1392705)

Hi,

Ive just had a member of my forum ask this:

Apparently a few others get this message as well.

Any ideas what may be casuing this?

I had this same problem as well -- apparantly once the event is in the past, only moderators may post to the event. I solved the problem by changing the option to close the rsvp (by leaving it open everyone can still participate in the discussion on the past event).

IvyKeepMommy

12-05-2007 02:49 AM

Quote:

For ranged and recurring events, members are able to RSVP for a single day of the event. So, if the recurring event occurs every Monday, your members can RSVP separately for each recurrence. For ranged events that span more than one day, members can sign up for individual days of the event. Thus, if the event had a duration of 5 days, a member could signup for only one or two of the days, if he chose.

I am not finding this to be the case -- is there a setting I need to check on?

On my forum, however your RSVP to the first in the series of events carries through for all of the events, and if you change it on a later event it changes the first event and the whole series.

All times are GMT. The time now is 08:09 AM.

Page 8 of 12

« First

Last »

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01652 seconds Memory Usage 1,852KB 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 (9)bbcode_code_printable (13)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (40)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: