function display() { global $mainframe, $option; $db =& JFactory::getDBO(); $user =& JFactory::getUser(); $task = JRequest::getVar('task'); $cid = JRequest::getVar('cid', array(0), '', 'array'); $option = JRequest::getCmd('option'); $section = JRequest::getVar('section'); JArrayHelper::toInteger($cid, array(0)); $row =& JTable::getInstance('ligen', 'TableCLM'); // load the row from the db table $row->load($cid[0]); // Prüfen ob User Berechtigung zum editieren hat if ($row->sl !== CLM_ID and CLM_usertype !== 'admin') { JError::raiseWarning(500, JText::_('PAARUNG_LIGEN')); if ($row->liga_mt == 1) { //mtmt $link = 'index.php?option=' . $option . '§ion=mturniere'; } else { $link = 'index.php?option=' . $option . '§ion=ligen'; } $mainframe->redirect($link); } // Prüfen ob Runden erstellt sind if ($row->rnd < 1) { JError::raiseWarning(500, JText::_('PAARUNG_RUND')); if ($row->liga_mt == 1) { //mtmt $link = 'index.php?option=' . $option . '§ion=mturniere'; } else { $link = 'index.php?option=' . $option . '§ion=ligen'; } $mainframe->redirect($link); } $row->checkout($user->get('id')); // Teilnehmer zusammenstellen $sql = "SELECT a.*, m.name as hname, m.tln_nr as htln, n.name as gname, n.tln_nr as gtln, rt.name as rname " . " FROM #__clm_rnd_man as a" . " LEFT JOIN #__clm_mannschaften as m ON m.tln_nr = a.tln_nr AND m.liga = a.lid AND m.sid = a.sid" . " LEFT JOIN #__clm_mannschaften as n ON n.tln_nr = a.gegner AND n.liga = a.lid AND n.sid = a.sid" . " LEFT JOIN #__clm_liga as l ON a.lid = l.id " . " LEFT JOIN #__clm_runden_termine as rt ON rt.liga = a.lid AND rt.nr = (a.runde + (a.dg-1) * l.runden) " . " WHERE a.sid = " . $row->sid . " AND a.lid = " . $row->id . " AND a.heim = 1" . " ORDER BY a.dg ASC, a.runde ASC, a.paar ASC"; $db->setQuery($sql); $paarung = $db->loadObjectList(); // Mannschaftsliste $sql = "SELECT tln_nr, name, rankingpos FROM #__clm_mannschaften " . " WHERE sid = " . $row->sid . " AND liga = " . $row->id . " ORDER BY tln_nr ASC "; $db->setQuery($sql); $man = $db->loadObjectList(); // Mannschaftsliste $sql = "SELECT COUNT(tln_nr) as tln_nr FROM #__clm_mannschaften " . " WHERE sid = " . $row->sid . " AND liga = " . $row->id . " "; $db->setQuery($sql); $count_man = $db->loadObjectList(); // "spielfrei(e)" Mannschaft suchen //mtmt $query = " SELECT COUNT(id) as anzahl FROM #__clm_mannschaften as a " . " WHERE sid = " . $row->sid . " AND liga = " . $row->id . " " . " AND a.name = 'spielfrei'" . " ORDER BY a.tln_nr "; $db->setQuery($query); $spielfreiNumber = $db->loadObjectList(); if ($spielfreiNumber[0]->anzahl > 1) { foreach ($man as $key => $value) { if ($value->name == 'spielfrei') { $value->name .= " " . $value->tln_nr; } } } require_once JPATH_COMPONENT . DS . 'views' . DS . 'paarung.php'; CLMViewPaarung::paarung($row, $paarung, $man, $count_man, $option, $cid, $lists); }