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>";
}
