[bademantel]

@DDD
exactly what I need - almost!
Well it does work on the entry-page in my forum, but it does not show the events in the actual calendar. Have you got any idea why?
The functions_calendar.php I have does vary slightly from the one you posted:

if($calendarinfo[calendarid]==1){
$events = $DB_site->query("
SELECT event.*,
user.username, IF(user.displaygroupid = 0, user.usergroupid, user.displaygroupid) AS displaygroupid,
IF(dateline_to = 0, 1, 0) AS singleday
" . iif($bbuserinfo['userid'], ", subscribeevent.eventid AS subscribed") . "
FROM " . TABLE_PREFIX . "event AS event
LEFT JOIN " . TABLE_PREFIX . "user AS user ON (user.userid = event.userid)
" . iif($bbuserinfo['userid'], "LEFT JOIN " . TABLE_PREFIX . "subscribeevent AS subscribeevent ON (subscribeevent.eventid = event.eventid AND subscribeevent.userid = $bbuserinfo[userid])") . "
WHERE ((dateline_to >= $beginday AND dateline_from < $endday) OR (dateline_to = 0 AND dateline_from >= $beginday AND dateline_from <= $endday )) AND
visible = 1
");
}
else {
$events = $DB_site->query("
SELECT event.*,
user.username, IF(user.displaygroupid = 0, user.usergroupid, user.displaygroupid) AS displaygroupid,
IF(dateline_to = 0, 1, 0) AS singleday
" . iif($bbuserinfo['userid'], ", subscribeevent.eventid AS subscribed") . "
FROM " . TABLE_PREFIX . "event AS event
LEFT JOIN " . TABLE_PREFIX . "user AS user ON (user.userid = event.userid)
" . iif($bbuserinfo['userid'], "LEFT JOIN " . TABLE_PREFIX . "subscribeevent AS subscribeevent ON (subscribeevent.eventid = event.eventid AND subscribeevent.userid = $bbuserinfo[userid])") . "
WHERE calendarid = $calendarinfo[calendarid] AND
((dateline_to >= $beginday AND dateline_from < $endday) OR (dateline_to = 0 AND dateline_from >= $beginday AND dateline_from <= $endday )) AND
visible = 1
");
}

And also funny is the fact that it does not make any differences if I leave out the WHERE clause or not. It still does show the events on the entry-page but not in the calendar itself???

Have you got any clue what I can do?

THX Andreas