- Aktuelle Seite:
-
Startseite
-
Hockey
-
Kinder-Teams
- Mädchen A
Termine
| Frühjahrsputz 25 Apr 2020 10:00 Clubgelände |
Abfluss-As Michael Dressel
ASETEC GmbH Sven Kusch
Jochen Müller- Atzerodt
getMenu();
$menuItem = $menu->getActive();
$alias = $menuItem->alias;
$month = date("n");
if ($month10) {
$season = 'HALLE';
} else {
$season = 'FELD';
}
$db = JFactory::getDbo();
// Retrieve ids
$query = $db->getQuery(true)
->select($db->quoteName('id'))
->from($db->quoteName('#__contact_details'))
->where('alias = ' . $db->Quote($alias))
->order($db->quoteName('con_position').' ASC');
$db->setQuery($query);
$ids= $db->loadColumn();
if (empty($ids)) {
// Retrieve id of Jugendwart Hockey
$alias = 'jugendwart-hockey';
$query = $db->getQuery(true)
->select($db->quoteName('id'))
->from($db->quoteName('#__contact_details'))
->where('alias = ' . $db->Quote($alias));
$db->setQuery($query);
$ids= $db->loadColumn();
}
foreach ($ids as $id) {
// Retrieve catid
$query = $db->getQuery(true)
->select($db->quoteName('catid'))
->from($db->quoteName('#__contact_details'))
->where('id = ' . $db->Quote($id));
$db->setQuery($query);
$catid = $db->loadResult();
// Retrieve position
$query = $db->getQuery(true)
->select($db->quoteName('con_position'))
->from($db->quoteName('#__contact_details'))
->where('id = ' . $db->Quote($id));
$db->setQuery($query);
$position = $db->loadResult().PHP_EOL;
// Retrieve name
$query = $db->getQuery(true)
->select($db->quoteName('name'))
->from($db->quoteName('#__contact_details'))
->where('id = ' . $db->Quote($id));
$db->setQuery($query);
$name = $db->loadResult().PHP_EOL;
// Retrieve email
$query = $db->getQuery(true)
->select($db->quoteName('email_to'))
->from($db->quoteName('#__contact_details'))
->where('id = ' . $db->Quote($id));
$db->setQuery($query);
$email = $db->loadResult().PHP_EOL;
// Retrieve mobile
$query = $db->getQuery(true)
->select($db->quoteName('mobile'))
->from($db->quoteName('#__contact_details'))
->where('id = ' . $db->Quote($id));
$db->setQuery($query);
$mobile = $db->loadResult().PHP_EOL;
// Retrieve telephone
$query = $db->getQuery(true)
->select($db->quoteName('telephone'))
->from($db->quoteName('#__contact_details'))
->where('id = ' . $db->Quote($id));
$db->setQuery($query);
$telephone = $db->loadResult().PHP_EOL;
//Retrieve Trainingszeiten
$query = $db->getQuery(true)
->select($db->quoteName('misc'))
->from($db->quoteName('#__contact_details'))
->where('id = ' . $db->Quote($id));
$db->setQuery($query);
$temp = $db->loadResult().PHP_EOL;
if (strlen($temp)>1) {
$matches = preg_split('/\#/',$temp,-1,PREG_SPLIT_NO_EMPTY);
if (count($matches)>0) {
$misc = $temp;
}
if ($catid == 31) {
$tz = $misc;
}
else {
$misc = $temp;
}
}
// display data
if (strncmp($name,'###',3) !== 0) {
echo '
'; echo 'Trainingszeiten'; echo '
';echo '
'; $matches = preg_split('/\#/',$tz,-1,PREG_SPLIT_NO_EMPTY); $size = count($matches); for($x=0;$x
'.$position.'
'; $url = 'index.php?option=com_contact&view=contact&id='.$id.'&catid='.$catid; echo ''. $name.''; echo '- ';
}
if (strlen($email)>1) {
echo '
';
echo '- '." ". $email.' '; } if (strlen($mobile)>1) { echo '
';
echo '- '." ".$mobile.' '; } if (strlen($telephone)>1) { echo '
';
echo '- '." ". $telephone.' '; } echo '
'; echo 'Trainingszeiten'; echo '
';echo '
'; $matches = preg_split('/\#/',$tz,-1,PREG_SPLIT_NO_EMPTY); $size = count($matches); for($x=0;$x
