[Elenna]

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

// SELECT SQL for RSVPs for this event

IN LINE

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

, userfield.field14, userfield.field10

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

FIND

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

ADD AFTER

  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

    // 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:

$orderby = "userfield.field14";

Be sure to REMOVE the ending };

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