function _vereinteammatchlist($vid, $show = 'home') { global $dbi; // step 1 collect the teams for this verein // step 2 for each team we collect the schedule and create click-rows to the matchsheet echo '<h3>Alle Vereins Teams und ihre Heim Spiele</h3>'; $RS = DB_listTeams($dbi, 0, 0, "", 1, "", $vid); foreach ($RS as $row) { if ($show == 'home') { $MATCHLIST = DB_listMatches($dbi, 1, 0, $row[4], "", "", 1); } elseif ($show = 'away') { $MATCHLIST = DB_listMatches($dbi, 1, 0, $row[4], "", "", 0); } elseif ($show = 'all') { // this doesn't work ... $MATCHLIST = DB_listMatches($dbi, 1, 0, $row[4], "", "", "", "", "logic"); } $aTH = array("Runde", "Datum", "Spielort", "Status", "", "Sets", "Legs", "Team", "Teamname"); echo "<div class=\"sectionhead\">Team {$row['5']} in {$row['2']} (" . sizeof($MATCHLIST) . " Matches)</div><br/>"; echo '<div class="child">'; OpenTable(); echo ArrayToTableHead($aTH); echo RecordsetToClickTable($MATCHLIST, 4, "ls_system.php?func=showmatch&vmkey=%P1%&eventid=%P2%", 3, 0); CloseTable(); echo '</div><br/>'; } }
/** * purpose: list specific players according to searchstring * params: findstring, findpassnr * returns: renders Page with Browsebar+PlayerTable */ function listall($findstr = '', $findpass = '', $firstLetter = '') { # zeigt einen Table mit einer SpielerListe an global $dbi, $realm_id, $playercode, $usertoken; if (sizeof($usertoken['registermap']) < 1) { die_red('Err58:RegisterMap'); } if (strlen($findstr) < 1 && strlen($findpass) < 1 && strlen($firstLetter) < 1) { $findstr = 'A'; } $aTH = array('Aktiv', 'Vorname', 'Nachname', 'Key-1', 'Key-2', 'PLZ', 'Wohnsitz'); $RS = DB_listPlayers($dbi, 0, $findstr, '', $findpass, '', '', $firstLetter); $target = $playercode . '?func=edit&vpid=%P1%'; $ROWS = RecordsetToClickTable($RS, 0, $target, 0); // OUTPUT // echo setPageTitle('<h3>Liste::Spielereinträge ' . $findstr . '</h3>'); echo LastNameBrowseBar($firstLetter); OpenTable('browse'); echo ArrayToTableHead($aTH); echo $ROWS; CloseTable(); debug('Anzahl der gefundenen Spieler = ' . sizeof($RS)); }
/** * purpose generate a detailed statcodelist breakdown per Player for a specific event * params eventid,playerid * returns HTML Table page */ function _showStatCodeListForEventDetail($player_id) { global $event, $dbi; $aTH = array('Vorname', 'Nachname', 'Runde', 'Datum', 'Legs+', 'Sets+', 'Matches+', 'Punkte'); $target = 'ls_system.php?func=showmatch&vmkey=%P1%&eventid=' . $event['id']; /* * supported for different type of statcodelists (9,13,16,17) * the default is to return a detailed game list without any points or calculations * if special calcs are needed use the switch clause on stat_code */ switch ($event['evstatcode_id']) { case 16: // BDSO Punkte 7,6,3,0 // retrieve all games -> for each game get game data $RS = lsdb_stat_ReturnGamePointsForPlayer($dbi, $event, $player_id, 1); break; default: $RS = DB_retStatQueryArrayDetail($dbi, $player_id, $event); } // OUTPUT $OUT = _MakeStatPageHeader($event['id'], 0); $OUT = $OUT . '<h3>Detailed List</h3>'; $OUT = $OUT . OpenTable('statlistdetail', 1); $OUT = $OUT . ArrayToTableHead($aTH); // skip fields: pid,gid $OUT = $OUT . RecordsetToClickTable($RS, 2, $target, 4); $OUT = $OUT . CloseTable(1); echo $OUT; }
$uid = 0; $uid = $usertoken['id']; switch ($usertoken['usertype_id']) { case 4: case 5: case 6: // seems we have a liga admin here ... // pass USERID as adm and set uid to zero .... $uid = 0; $adm = $usertoken['id']; default: } // ACTION $RS = DB_listWFRequest($dbi, 0, $uid, $wf_status, 0, '', $adm); if (sizeof($RS) > 0) { $ROWS = RecordsetToClickTable($RS, 1, 'wf.php?op=edit&reqid=%P1%', 0); } else { $ROWS = 'No requests (' . $wf_status . ') found ...'; } // OUTPUT $OUT = '<h3>Anträge Status: ' . $wf_status . '</h3>'; $OUT = $OUT . '<div class=\'child\'>'; $OUT = $OUT . OpenTable('wflist', 1); $OUT = $OUT . $ROWS; $OUT = $OUT . CloseTable(1); $OUT = $OUT . '</div>'; /* $aTH=array('ID','Request','Date','User','Status','Message'); $OUT='<table>'.ArrayToTableHead($aTH); $OUT=$OUT.RecordsetToDataTable($RS,array(0,1,2,3,4,5)); */
function _showallgroup($eventid) { // this function returns the standings for the entire group a selected event is member of global $dbi, $event, $tdbg; $evgrp = $event['evtypecode_id']; $ES = DB_listEvents($dbi, 1, 0, '', $evgrp); $aTH = array('Team', 'Set+', 'Set-', 'Diff', 'Leg+', 'Leg-', 'Diff', 'Matches', 'Points'); echo setPageTitle('Alle Tabellen der Liga Gruppe ' . $event['typdesc']); echo _tabellenav($eventid); OpenTable(); foreach ($ES as $ev) { echo '<tr><td colspan="9" bgcolor="' . $tdbg . '">' . $ev[1] . '</td></tr>'; echo ArrayToTableHead($aTH); // this is for point-standings if ($event['evtabpoints'] == 1) { $RS = DB_getTabelle($dbi, $ev[0], 0, 'point', 'small'); } // this is for the set-standings if ($event['evtabsets'] == 1) { $RS = DB_getTabelle($dbi, $ev[0], 0, 'set', 'small'); } //$fields=array(4,5,6,7,8,9,10,11,12); //$ROWS=RecordsetToDataTable($RS,$fields); $target = ''; $ROWS = RecordsetToClickTable($RS, 4, $target, 1, 3); echo $ROWS; } CloseTable(); echo '</div>'; }
function _listTeams($eventgroup) { # # // List all active teams for the actual eventgroup # // get eventgroup - list teams with hyperlinks into the schedule page for this league # global $dbi, $tdbg; /* * we have no global event struct here ... retieve based on passed param * show selector for change of eventgroup .... */ echo form_EventGroupSelect('ls_debug.php?func=allteams', '', $eventgroup); if (!$eventgroup > 0) { return; } $aTH = array('Bewerb', 'Saison', 'Team-id', 'Teamname', 'Verein-id', 'Vereinsname', 'Spielort-id', 'Heimspielort'); $target = 'ls_system.php?func=schedule&eventid=%P1%'; $RS = DB_listTeams($dbi, 0, $eventgroup, '', 1); $ROWS = RecordsetToClickTable($RS, 2, $target, 0); // OUTPUT echo '<h3>Alle Teams der Liga-Gruppe ' . $eventgroup . '</h3>'; echo '<p>Hier werden alle Teams die in <b>allen</b> aktiven Ligen dieser Liga Gruppe spielen alphabetisch gelistet. Ein Klick auf einen Teameintrag führt direkt in die Seite mit allen Spielberichten (Spielplan) der betreffenden Liga oder Klasse.</p>'; OpenTable(); echo ArrayToTableHead($aTH); echo "<tr height=5px></tr>"; echo $ROWS; CloseTable(); echo "<p>Anzahl der Teams: " . count($RS) . "</p>"; }