Once you've chosen the correct database, I believe it is the SQL tab.

would it be possible to have a section on the users profile page saying what events they will be attending ??

Anything is possible. ;) I'm just not sure how it would really be done since all this hack essentially does is insert another bit of information with the information for an event and then read it back when displaying an event.

To display this information with a user's profile, you'd have to scan through every event and look at that additional bit of information to see if it matches the chosen user profile. I think the code to do this will be even more than the original hack, lol.

Essentially, you'd be scanning the entire events table (or just the newer events) every time a user looks at another's profile. I suspecting it would be kinda heavy on the server if this was implemented on a forum with a lot of users and events.

thanks for the reply but doesnt the attendance table hold the users ID (when they click to say there attending) in which case calling the record from the database would be easier on the server (WHERE userID = "?")

I looked at the structure of the events table and the "roll" field and it seems quite easy on the server. All it has to do is go through the events table just like you said. Now, who wants to code this cool idea? :D

Suggestion:

In the Public Calendar when you click on the link at the bottom of the page to add or remove yourself as an attendee, it would be very helpful (for planning purposes) to have a drop down menu or text box available to fill in a number for how many will be in that "party".

For instance, we are planning a BBQ on Oct. 30. This is going to be open to both members and non-members (i.e. families). If a person is going to bring a spouse, 2 kids and a friend who may be interested in diving in the future, it would be very helpful to be able to look at the list and see that this will be a "Party of 5", it would also be an added bonus if the total number of attendees could be shown.

Adding this feature would make the Calendar more "useful" and relevant. If you still have to comb through a thread to find the number of attendees for each name, the Calendar function becomes less valuable.

This doesn't seem too hard to do, but for my site I would have no need for it. But I see how your suggestion can take the calendar to the beginning stages of becoming a planner--which I fully believe it will be in the future once people realize what you can do with it.

Right now a lot of our users are planning group events which means a lot more than just 1 person attending per username... this makes the "attending" feature almost useless as it misrepresents actual attendance. I would love to see (and am willing to pay for) a feature to simply include the # of attendees... it doesn't seem hard to add but time is not something I have lots of.

If someone writes out the pseudocode, I'd be willing to hack at it in my spare time.

that would be so sweet if you could !! dunno about the code tho