get('showscroller') == 1) {
$height =$params->get('height');
$bgcolor =$params->get('bgcolor');
$border =$params->get('border');
$delay =$params->get('delay');
$speed =$params->get('speed');
$pause =$params->get('pause');
$width =$params->get('width');
$divs = "1"; ?>
get('oldDeletemod', '0') == 1) {
$delevents = 'DELETE FROM #__eventlist_dates WHERE DATE_SUB(NOW(), INTERVAL '.(int)$params->get( 'minus','2' ).' DAY) > dates';
$database->setQuery($delevents);
$database->query();
}
//archive events older than x days
if ($params->get('oldDeletemod', '0') == 2) {
$archevents = 'UPDATE #__eventlist_dates SET published= -1 WHERE DATE_SUB(NOW(), INTERVAL '.(int)$params->get( 'minus','2' ).' DAY) > dates';
$database->setQuery($archevents);
$database->query();
}
//getItemid
$itemidquery = 'SELECT id FROM #__menu WHERE link = "index.php?option=com_eventlist" AND published > 0';
$database->setQuery($itemidquery);
$Itemid = $database->loadResult();
if ($params->get( 'type', '0' ) == 0) {
$where = ' WHERE a.published = 1';
$order = ' ORDER BY a.dates, a.times';
} else {
$where = ' WHERE a.published = -1';
$order = ' ORDER BY a.dates DESC, a.times DESC';
}
//get $params->get( 'count', '2' ) nr of datasets
$query = 'SELECT a.*, l.club, l.city, l.url'
.' FROM #__eventlist_dates AS a'
.' LEFT JOIN #__eventlist_locate AS l ON l.id = a.locid'
.' LEFT JOIN #__eventlist_categories AS c ON c.id = a.catsid'
. $where
.' AND c.access <= '.(int)$my->gid
. $order
.' LIMIT '.(int)$params->get( 'count', '2' )
;
$database->setQuery($query);
$rows = $database->loadObjectList();
//Two lines
function elmod_two_lines($rows, $Itemid, &$params)
{
?>
get('formatdate', '%d.%m.%Y'), strtotime( $row->dates ));
$zeit = strftime( $params->get('formattime', '%H:%M'), strtotime( $row->times ));
?>
|
get('linkdet', '1') == 1) {
echo "$datum | ".$zeit."";
} else {
echo $datum." | ".$zeit ;
}
?>
|
|
get('showtitloc', '0') == 0) {
if ($row->url && $params->get('linkloc', '1') == 1) {
?>
club; ?>
club;
}
} else {
//cut titel
$beschnitten = strlen($row->titel);
if ($beschnitten > $params->get('cuttitle', '18')) {
$row->titel = substr($row->titel, 0, $params->get('cuttitle', '18'));
$row->titel = $row->titel.'...';
}
if ($params->get('linkdet', '1') == 2) {
echo "id)."'>$row->titel";
} else {
echo $row->titel;
}
}
?>
|
get('formatdate', '%d.%m.%Y'), strtotime( $row->dates ));
?>
|
get('linkdet', '1') == 1) {
echo "id)."'>$datum";
} else {
echo $datum;
}
?>
/
url && $params->get('linkloc', '1') == 1){
?>
club; ?>
club;
}
?>
|
url;
}
return $url;
}
//any events to display?
if (empty($rows)) {
?>
| get('noevents', 'Sorry, no events to display'); ?> |
";
echo ""; }
if ($params->get('view', '1') == 1) {
elmod_two_lines($rows, $Itemid, $params);
} else {
elmod_one_line($rows, $Itemid, $params);
}
if ($divs==1){
echo"
";
}
?>