PHP modCLM_TurMultipleHelper::getTree Examples

Example #1

File: mod_clm_turmultiple.php Project: ChessLeagueManager/deprecated

$param['linkplayerslist'] = $params->get('linkplayerslist', 1);
$param['linkroundseach'] = $params->get('linkroundseach', 0);
$param['showunpublishedrounds'] = $params->get('showunpublishedrounds', 0);
$param['linkmatchescomplete'] = $params->get('linkmatchescomplete', 0);
$param['linktable'] = $params->get('linktable', 0);
$param['linkrankingscore'] = $params->get('linkrankingscore', 0);
$param['textrankingscore'] = $params->get('textrankingscore', '');
$param['linkinvitation'] = $params->get('linkinvitation', 0);
$param['contentid'] = $params->get('contentid', '');
$param['textbottom'] = $params->get('textbottom', '');
// URL-Parameter
$runde = JRequest::getVar('runde');
$arrayTurniere = array();
// CategoryID vorgegeben?
if ($param['categoryid'] != '' and $param['categoryid'] > 0) {
    list($parentArray, $parentKeys, $parentChilds) = modCLM_TurMultipleHelper::getTree();
    // für jede Kategorie Unterkategorien ermitteln
    $arrayAllCatid = array();
    if (isset($parentChilds[$param['categoryid']])) {
        $arrayAllCatid = $parentChilds[$param['categoryid']];
        $arrayAllCatid[] = $param['categoryid'];
    } else {
        $arrayAllCatid[] = $param['categoryid'];
    }
    $addWhere = '( ( catidAlltime = ' . implode(' OR catidAlltime = ', $arrayAllCatid) . ' )
						OR 
						( catidEdition = ' . implode(' OR catidEdition = ', $arrayAllCatid) . ' ) )';
    // zugewiesene Turniere
    $query = 'SELECT id' . ' FROM #__clm_turniere' . ' WHERE ' . $addWhere . ' ORDER BY ordering';
    $db->setQuery($query);
    $arrayTurniere = $db->loadResultArray();