Social Group and Album Enhancements - Social Group Calendars

In short, this modification will allow social groups on your forum have their own calendar area and have upcoming events shown on their group page. Here is a list of features:

1. Upcoming events for a group are shown on the group's page, grouped by day.
2. The group's next event is shown in more detail and can be configured to show the entire event description or be trimmed to a certain number of characters.
3. Members can see events for all the social groups they belong to consolidated into one calendar.
4. The forum home index page can be setup to show upcoming events for social groups.
5. Non-members can see upcoming events for a public group by viewing the group's page if the group doesn't require joining to view content. They will not see events for these groups in the calendar view or on the forum homepage, which will help keep the clutter down.
6. Group's that are moderated, invite only, or must join to view content, will not display their upcoming events to non-members. Their events are also secured, so following a link to an event by a non-member will result in a no permissions error.
7. Group owners can optionally allow members to be able to post events, or they can set their group up so that only they can post events.
8. When clicking on the New Event link from the group's page, the event will automatically be assigned to the referring group.
9. When creating a new event from the calendar view, the creator can assign the event to any group he has permissions to post events. These events will appear in a drop down box on the event.
10. Admins and moderators can be set to be excluded from all filtering and permissions. This allows the administrator an unfiltered view of the social group calendar, and the ability to move or edit group's events as needed.
11. Plays nice with Farcaster's Event Attendance v3.0 (RSVP mod).

Installation Instructions (Remember to Mark Installed)
Follow the installation instructions available here: https://vborg.vbsupport.ru/showthread.php?p=1999324

Revision Log

• 0.1.0 BETA - 01/28/09 - Initial Version
• 1.0.0 - 04/05/09 - Bug Fixes and Release
• 2.0 - 03/07/10 - Updated to work with vb4.

Known Issues
None at this time.

[mrt12345]

i have tis error would anybody have any ideas ?

Database error in vBulletin 4.1.5:

Invalid SQL:

SELECT event. sg.name as socialgroupname, *,
user.username, IF(user.displaygroupid = 0, user.usergroupid, user.displaygroupid) AS displaygroupid,
user.adminoptions, user.usergroupid, user.usertitle, user.membergroupids, user.infractiongroupids, IF(options & 8192, 1, 0) AS hasaccessmask,
IF(dateline_to = 0, 1, 0) AS singleday
, subscribeevent.eventid AS subscribed
,avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline,
customavatar.width AS avwidth,customavatar.height AS avheight, customavatar.width_thumb AS avwidth_thumb, user.avatarrevision,
customavatar.height_thumb AS avheight_thumb, customavatar.filedata_thumb, NOT ISNULL(customavatar.userid) AS hascustom
FROM vb_event AS event
LEFT JOIN vb_user AS user ON (user.userid = event.userid)
LEFT JOIN vb_socialgroupmember sgm ON sgm.userid = 01 AND sgm.groupid = event.socialgroupcalendar
LEFT JOIN (SELECT groupid, name FROM vb_socialgroup) sg ON sg.groupid = event.socialgroupcalendar
LEFT JOIN vb_subscribeevent AS subscribeevent ON (subscribeevent.eventid = event.eventid AND subscribeevent.userid = 1)
LEFT JOIN vb_avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN vb_customavatar AS customavatar ON(customavatar.userid = user.userid)
WHERE calendarid = 1 AND
((dateline_to >= 1312113600 AND dateline_from < 1320148800) OR (dateline_to = 0 AND dateline_from >= 1312113600 AND dateline_from <= 1320148800 )) AND
event.visible = 1
AND (event.socialgroupcalendar = 0 OR sgm.groupid IS NOT NULL OR 1=1 )
ORDER BY dateline_from;

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 '*,
user.username, IF(user.displaygroupid = 0, user.usergroupid, user.displaygr' at line 1
Error Number : 1064

[mmoore5553]

I have this on 4.1.7 and it says no calendar specified. I am unsure where to go to fix this. I have added a calendar but not sure how to associate it to the group

[mmoore5553]

I have found one issue that I am administrator I can not click add event from inside the group it says i do not have permission. But if i go to calendar I can edit and add events.

[mmoore5553]

Developer...I have emailed you and wrote to see if you can help. I have problem with it and need help. I installed and gives error. Please let me know . I am willing to pay.

[steve k.]

Installed on 4.1.10. Works great. I think. I am still in process of building my alpha forum, but all looks good with one group. I found in the xml where to change the color of teh calendar icon on the groups page. Is there a way ti set that to use a stylevar?

Also, is the a way to make the events section on the group page to have the same look and feel as the "Group Photos" section?

my current example http://alpha.bmw2002faq.com/group.php?groupid=1

thanks,
steve k

[Morrus]

Dunno what I'm doing wrong, but I'm trying to add this to a clean vB4 install and it's not working. Calendar.php won't load at all.

Maybe my code editing skills are weak (I've tried a half dozen times now). Anyone got copies of the correctly edited files and templates I could just use as-is, since it's a clean vB4 install?

(Edit - ah, I see the developer hasn't posted to this thread in nearly 2 years.)

[ywwz]

tooooo many editing...

[ywwz]

Calendar
Set this to the calendar ID that social group events should be saved in.
Social Group Members will still need to be in a user group that has access to the calendar to be able to view event details or add events, so be sure to setup the desired security
(It is planned in the future to allow more than one calendar to be configured for Social Group Events)

what number should i give this ID?

[ywwz]

installed anyway, very good!!! cool mod!

[popmyzit]

tried on VB 4.2 can't get to work. Getting php error:

Warning: fetch_template() calls should be replaced by the vB_Template class. Template name: socialgroups_events in [path]/includes/functions.php on line 4734