Hi, Rolf.
Ok, I did it! :D
I already applied on your site and it works.
Now if user that is not a group member click on links in module - should see notice that group is private ;) So access rights and privacy are preserved.
Here is code:
<ul class="cThumbDetails cResetList">
<?php
$db = JFactory::getDbo();
$query = $db->getQuery(true);
$query->select('*');
$query->from($db->quoteName('mysuffix_community_events'));
$query->where($db->quoteName('contentid')." = 12");
$query->order($db->quoteName('startdate') . ' DESC');
$db->setQuery($query);
$eventrowglobal = $db->loadRowList();
//print_r($eventrow);
?>
<?php foreach ($eventrowglobal as $eventrow) { ?>
<?php
$todais = strtotime(date('d-m-Y H:i'));
$eventstarts = strtotime(JHtml::date($eventrow[10] , 'd-m-Y H:i'));
if($eventstarts > $todais) {
?>
<li>
<b class="cThumb-Calendar cFloat-L">
<b><?php echo JHtml::date($eventrow[10] , 'M'); ?></b>
<b><?php echo JHtml::date($eventrow[10] , 'd'); ?></b>
</b>
<div class="cThumb-Detail">
<a href="<?php echo CRoute::_('index.php?option=com_community&view=events&task=viewevent&eventid=' . $eventrow[0] . '&groupid=' . $eventrow[3] ); ?>" class="cThumb-Title"><?php echo $eventrow[5]; ?></a>
<div class="cThumb-Location">
<?php echo CStringHelper::escape($eventrow[6]); ?>
</div>
<div class="cThumb-Members small">
<a href="<?php echo CRoute::_('index.php?option=com_community&view=events&task=viewguest&eventid=' . $eventrow[0] . '&type=1'); ?>">
<?php echo JText::sprintf((!CStringHelper::isSingular($eventrow[17])) ? 'COM_COMMUNITY_EVENTS_ATTANDEE_COUNT_MANY' : 'COM_COMMUNITY_EVENTS_ATTANDEE_COUNT', $eventrow[17]); ?>
</a>
</div>
</div>
</li>
<?php } ?>
<?php } ?>
</ul>
I created request to DB for data and altered original loop.
$query->from($db->quoteName('mysuffix_community_events')); - change to your db table suffix
$query->where($db->quoteName('contentid')." = 12"); - change 12 to your group id
How to use the code?
Just copy above code and replace with it original code within initial <ul> (line 14) and closing </ul> (around line 47). Also note that it's great to implement my previous hack that will allow you to use as many layouts/templates for Event modules... so you could have as many modules with Events from different groups... even one module for each group :D
It works 100% :D
EDIT (9-07-2014):
Corrected with sorting by date, starting from most recent Events.
EDIT (9-07-2014):
Corrected with showing only future Events. Will NOT show ongoing Events!
