Calendar Enhancements - Show Events & Birthdays on Additional Forum Pages

This hack will allow you to display upcomming events and birthdays at the top of the forum display, show thread and/or search pages. It uses the forums normal calendar permission rules, so only authorized users will be able to see your forum's events. The hack will correctly install for both 3.5.x and 3.6.0 version forums.

Installation:
1. Use the Product Manager to import the product file product-rah_events_on_forum_pages_1_1_0
2. Configure the product options as desired under the vBulletin options, "Events on Forum Pages".
3. Use the Style Manager to add the code below to the bottom of the navbar template.

<table class="tborder" cellpadding="$stylevar[cellpadding]" cellspacing="$stylevar[cellspacing]" border="0" width="100%" align="center">
<!-- today's birthdays -->
<if condition="$show['birthdays']">
<tbody>
<tr>
<td class="thead" colspan="2">
<a style="float:$stylevar[right]" href="#top" onclick="return toggle_collapse('forumhome_birthdays')"><img id="collapseimg_forumhome_birthdays" src="$stylevar[imgdir_button]/collapse_thead$vbcollapse[collapseimg_forumhome_birthdays].gif" alt="" border="0" /></a>
$vbphrase[todays_birthdays]
</td>
</tr>
</tbody>
<tbody id="collapseobj_forumhome_birthdays" style="$vbcollapse[collapseobj_forumhome_birthdays]">
<tr>
<td class="alt2"><a href="calendar.php?$session[sessionurl]do=getday&day=$today&sb=1"><img src="$stylevar[imgdir_misc]/birthday.gif" alt="$vbphrase[view_birthdays]" border="0" /></a></td>
<td class="alt1" width="100%"><div class="smallfont">$birthdays</div></td>
</tr>
</tbody>
</if>
<!-- end today's birthdays -->
<if condition="$show['upcomingevents']">
<tbody>
<tr>
<td class="thead" colspan="2">
<a style="float:$stylevar[right]" href="#top" onclick="return toggle_collapse('forumhome_events')"><img id="collapseimg_forumhome_events" src="$stylevar[imgdir_button]/collapse_thead$vbcollapse[collapseimg_forumhome_events].gif" alt="" border="0" /></a>
<if condition="$show['todaysevents']">$vbphrase[todays_events]<else /><phrase 1="$vboptions[showevents]">$vbphrase[upcoming_events_for_the_next_x_days]</phrase></if>
</td>
</tr>
</tbody>
<tbody id="collapseobj_forumhome_events" style="$vbcollapse[collapseobj_forumhome_events]">
<tr>
<td class="alt2"><a href="calendar.php$session[sessionurl_q]"><img src="$stylevar[imgdir_misc]/calendar.gif" alt="$vbphrase[calendar]" border="0" /></a></td>
<td class="alt1" width="100%"><div class="smallfont">$upcomingevents</div></td>
</tr>
</tbody>
</if>
</table>
<br />

Note that if you do not want the events to be shown both at the top of the forum home page and at the bottom, you will need to remove the original tables from the forumhome template.

That's it. You're done. Enjoy!

Please find sample screenshots of the options menu and the forum display page attached. If you have any questions, please feel free to PM me.

[abroad]

I am using 3.6.5 but after installation nothing changed on my site...no upcoming events...nothing... all options are "YES"?

Can somebody help me?

[memorex]

I love this hack, Thanks Farcaster.

I also would love to use this on vbadvanced portal.

[ThorstenA]

I'd like to only see special calendars on special forums.

[Benj]

sweet how many additional queries does this add?

[nebu]

this hack didnt work with 3.6.4.
i installed, edited the template and ... nothing happaned.

all to yes!

there is only 1 change. i have 1 more line between the navbar and
the forum, but it is a clear line.
nothing in it

can someone help me?


ADD:
after reboot .... they appear.
but!
only the today events!
why doesnt appear upcoming events?

tell me, how i can set the days for the events to display.

[santimariani]

Help! I am getting the following error:

Database error in vBulletin 3.6.5:

Invalid SQL:

SELECT
c.calendarid,
max(CASE WHEN cp.calendarpermissions IS NULL THEN
ug.calendarpermissions
ELSE cp.calendarpermissions
END) maxPerm
FROM
usergroup ug
CROSS JOIN calendar c
LEFT JOIN calendarpermission cp ON
c.calendarid = cp.calendarid
AND cp.usergroupid = ug.usergroupid
WHERE
ug.usergroupid IN (6, 09)
GROUP BY
c.calendarid;;

MySQL Error : Unknown column 'ug.usergroupid' in 'on clause'
Error Number : 1054
Date : Monday, May 21st 2007 @ 08:36:59 PM
Script : XXXX
Referrer : XXXX
IP Address : XXX
Username : XXX
Classname : vB_Database

Thanks for what is promising to be a very useful mod.

[santimariani]

I was able to install it and it is a very good mod, but... it did add about 5 queries, so, sadly, I had to uninstall it. Is there any way of decreasing the quearies this mod requires? That would be great.

[Ignicoccus]

Hi,

I have the problem that your mod shows the birthdays on forumhome, even though I did switch this feature off (I only want to show events). Any ideas on this ?

[joker2040]

Works on 3.6.5

[Farcaster]

Originally Posted by Ignicoccus

Hi,

I have the problem that your mod shows the birthdays on forumhome, even though I did switch this feature off (I only want to show events). Any ideas on this ?

Have you also disabled the vBulletin option to show birthdays on the forumhome?