$db->setQuery($query);
$summe = $db->loadObjectList();
//echo "<br>error: ".mysql_errno() . ": " . mysql_error(). "\n";
//Rundendaten
$rnd1 = $rnd + ($dg - 1) * $mail[0]->runden;
$query = " SELECT name, datum " . " FROM #__clm_runden_termine as a " . " WHERE a.liga = " . $lid . " AND a.nr = " . $rnd1 . " AND a.sid = " . $sid;
$db->setQuery($query);
$rundeterm = $db->loadObjectList();
//echo "<br>error: ".mysql_errno() . ": " . mysql_error(). "\n";
//DWZ gespielt
$query = " SELECT a.sid,a.lid,a.runde,a.paar,a.dg, AVG(d.DWZ) as dwz,AVG(g.DWZ) as gdwz " . " FROM #__clm_rnd_man as a " . " LEFT JOIN #__clm_rnd_spl AS r ON (r.sid=a.sid AND r.lid= a.lid AND r.runde=a.runde AND r.paar = a.paar AND r.dg = a.dg) " . " LEFT JOIN #__clm_dwz_spieler AS d ON (d.ZPS = r.zps AND d.Mgl_Nr = r.spieler AND d.sid = r.sid) " . " LEFT JOIN #__clm_dwz_spieler AS g ON (g.ZPS = r.gzps AND g.Mgl_Nr = r.gegner AND g.sid = r.sid) " . " WHERE a.lid = {$lid} AND a.sid = {$sid} AND a.heim = 1 AND r.heim = 1 " . " AND a.runde = " . $rnd . " AND a.dg = " . $dg . " AND a.sid = " . $sid . " AND a.paar = " . $paarung . " GROUP BY a.paar ASC";
$db->setQuery($query);
$dwzgespielt = $db->loadObjectList();
//echo "<br>error: ".mysql_errno() . ": " . mysql_error(). "\n";
// Ergebnistext für flexibele Punktevergabe holen
$erg_text = CLMModelMeldung::punkte_text($lid);
// Pfad für Mail
$uri =& JFactory::getURI();
$url =& JURI::getInstance($uri->toString());
$pfad = $url->getHost();
// SUBJECT
$subject_neu = JTEXT::_('RESULT_DATA_SUBJECT_1') . $fromname . ' ' . $mail[0]->name . ': ' . $begegnung[0]->name . " - " . $begegnung[1]->name . " " . $summe[0]->sum . ' : ' . $summe[1]->sum;
// Mailbody TXT
$body_msg = JText::_('RESULT_DATA_BODY1') . " " . $begegnung[0]->name . " - " . $begegnung[1]->name . JText::_('RESULT_DATA_BODY2_1') . $fromname . JText::_('RESULT_DATA_BODY2_2') . "\r\n\r\n http://{$pfad}/index.php?option=com_clm&view=runde&saison={$sid}&liga={$lid}&runde={$rnd}&dg={$dg}" . JText::_('RESULT_DATA_BODY3') . JText::_('RESULT_DATA_BODY4') . "\r\n\r\n http://{$pfad}/index.php?option=com_clm&view=rangliste&saison={$sid}&liga={$lid}" . JText::_('RESULT_DATA_BODY5');
// Mailbody - TXT Ergänzung
$body_msg .= "\r\n\r\n ";
$zeile .= $mail[0]->name . ', ' . $rundeterm[0]->name;
if (isset($rundeterm[0]->datum)) {
$zeile .= ' ' . JText::_('ON_DAY') . ' ' . JHTML::_('date', $rundeterm[0]->datum, JText::_('%d. %B %Y'));
}
$body_msg .= $zeile;
if ($finish[$runde + ($dg - 1) * $liga[0]->runden - 1]->meldung == 0) {
//klkl
$msg = JText::_('RESULT_DATA_ROUND_UNPUBLISHED');
$link = "index.php?option=com_clm&view=paarungsliste&saison={$sid}&liga={$lid}";
$mainframe->redirect($link, $msg);
}
// Prüfen ob Datensatz schon vorhanden ist
$access = $this->access;
if ($access[0]->gemeldet > 0) {
$msg = JText::_('RESULT_DATA_ALREADY_EXISTS');
$link = "index.php?option=com_clm&view=runde&saison={$sid}&liga={$lid}&runde={$runde}&dg={$dg}";
$mainframe->redirect($link, $msg);
} else {
$datum =& JFactory::getDate($liga[0]->datum);
// Ergebnistext f�r flexibele Punktevergabe holen
$erg_text = CLMModelMeldung::punkte_text($liga[0]->id);
// Browsertitelzeile setzen
$doc =& JFactory::getDocument();
$daten['title'] = JText::_('RESULT_DATA_RESULT') . ' ' . $liga[0]->name;
$doc->setHeadData($daten);
?>
<div id="clm">
<div id="meldung">
<div class="componentheading"><?php
echo JText::_('RESULT_DATA_RESULT');
?>
</div>
<h4><?php
echo $liga[0]->name . ', ';
echo JText::_('RESULT_DATA_ROUND');
