$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');