function _getCLMPunkte(&$options) { $sid = JRequest::getInt('saison', '1'); $liga = JRequest::getInt('liga', '1'); $db = JFactory::getDBO(); $rnd_dg = CLMModelAktuell_Runde::Runden(); $runde = $rnd_dg[0]; $dg = $rnd_dg[1]; $id = @$options['id']; // ordering für Rangliste -> Ersatz für direkten Vergleich $query = "SELECT a.order, a.runden, a.durchgang, a.b_wertung FROM #__clm_liga as a" . " WHERE id = " . $liga . " AND sid = " . $sid; $db->setQuery($query); $order = $db->loadObjectList(); if ($order[0]->order == 1) { $ordering = " , m.ordering ASC"; } else { $ordering = ', a.tln_nr ASC '; } $query = " SELECT a.tln_nr as tln_nr,m.name as name, SUM(a.manpunkte) as mp, " . " SUM(a.brettpunkte) as bp, SUM(a.wertpunkte) as wp, m.published, m.man_nr, COUNT(DISTINCT a.runde) as spiele" . " FROM #__clm_rnd_man as a " . " LEFT JOIN #__clm_mannschaften as m ON m.liga = {$liga} AND m.tln_nr = a.tln_nr " . " WHERE a.lid = " . $liga . " AND a.sid = " . $sid . " AND m.man_nr <> 0 " . " AND gemeldet > 0 "; if ($runde != "" && $dg == 1) { $query = $query . " AND runde < " . ($runde + 1) . " AND dg = 1"; } if ($runde != "" && $dg > 1) { $query = $query . " AND ( runde < " . ($runde + 1) . " OR dg = 1)"; } $query = $query . " GROUP BY a.tln_nr "; if ($order[0]->b_wertung == 0) { $query = $query . " ORDER BY mp DESC, bp DESC" . $ordering; } if ($order[0]->b_wertung == 3) { $query = $query . " ORDER BY mp DESC, bp DESC, wp DESC" . $ordering; } if ($order[0]->b_wertung == 4) { $query = $query . " ORDER BY mp DESC, bp DESC, " . $ordering . ", wp DESC"; } return $query; }
} else { $array[3][1] = 1; } $array[3][2][] = array("option", "com_clm"); $array[3][2][] = array("view", "paarungsliste"); $array[3][2][] = array("saison", $sid); $array[3][2][] = array("liga", $lid); if ($itemid != '') { $array[3][2][] = array("Itemid", $itemid); } $array[3][3] = array(); // Aktuelle Runde if (count($sub_runden) > 0) { $array[3][3][0][0] = JText::_('ROUND_CURRENT'); require_once JPATH_COMPONENT . DS . 'models' . DS . 'aktuell_runde.php'; $rnd_dg = CLMModelAktuell_Runde::Runden(); if (JRequest::getVar('view', -1) != "runde" || JRequest::getVar('runde', -1) != $rnd_dg[0] || JRequest::getVar('dg', -1) != $rnd_dg[1]) { $array[3][3][0][1] = 0; } else { $array[3][3][0][1] = 1; } $array[3][3][0][2][] = array("option", "com_clm"); $array[3][3][0][2][] = array("view", "aktuell_runde"); $array[3][3][0][2][] = array("saison", $sid); $array[3][3][0][2][] = array("liga", $lid); if ($itemid != '') { $array[3][3][0][2][] = array("Itemid", $itemid); } // Alle Runden for ($i = 0; $i < count($sub_runden); $i++) { /* if ($sub_runden[$i]->nr > $sub_runden[$i]->runden) { //klkl