/**
* purpose: generate performance graph for a team
* params: team_id
* returns: complete table with Google API graphics
*/
function getTeamAvgHist($vtid)
{
# changed to google API and using the api_rs layer
#TODO here we still are hardcoded to 501 playing ...
global $dbi;
$OUT = "";
$RS = DB_listTeamLineUp($dbi, $vtid);
# TP.lid,T.id,T.tname,P.pid,P.pfname,P.plname,P.pfkey1,P.pfkey2,TY.TEXT,TP.leventid #
foreach ($RS as $row) {
$PlayerDat = DB_listLegStatAverageBreakdown($dbi, 0, $row[9], '>0', 501, $row[3]);
# E.evname,P.pid,P.pfname,P.plname,M.mdate,L.ldarts,L.lfinish,(501-L.lscore),round((L.lscore/L.ldarts),2) AVG
if (sizeof($PlayerDat) > 0) {
$arAVG = array();
foreach ($PlayerDat as $rowleg) {
$arAVG[] = round($rowleg[8]) * 2;
}
$imgURL = '<img src="' . _googleAVGChart('l', $arAVG) . '"/><br/>';
# to tu kurwa
$OUT = $OUT . '<tr><td>' . mb_convert_encoding($rowleg[2], 'UTF-8') . ' ' . mb_convert_encoding($rowleg[3], 'UTF-8') . '</td><td>' . $imgURL . '</td></tr>';
}
}
$RET = OpenTable('teamdata', 1);
$RET = $RET . $OUT;
$RET = $RET . CloseTable(1);
return $RET;
}
$event_id = 0;
if (isset($_POST['eventid'])) {
$event_id = strip_tags($_POST['eventid']);
}
if (!is_numeric($event_id) || $event_id == 0) {
die('X');
}
$dbi = sql_connect($dbhost, $dbuname, $dbpass, $dbname);
$aEvent = reteventconfig($event_id);
$legDistance = $aEvent['evsgldist'];
$qry = "select mround,count(mround) CNT,avg({$legDistance}/ldarts) AVG from tblmatch,tblgame,tblleg,tplayer P\r\nwhere mkey=gmkey and gid=lgid and lpid=P.pid and gtype=1 and lscore={$legDistance} and mevid={$event_id} and P.pgender='H' group by mround asc";
$qryResultset = sql_query($qry, $dbi);
$arAVG = array();
while ($a = sql_fetch_row($qryResultset, $dbi)) {
// google charts are normalized between 0 - 100 , we scale from 0 - 50
$arAVG[] = number_format($a[2] * 2, 2, '.', '');
}
$imgURLH = "<img src=\"" . _googleAVGChart('l', $arAVG) . "\"/>";
$imgHEADH = "<h3>Average per Dart Performance Herren Runde 1 - " . sizeof($arAVG) . "</h3>";
$qry = "select mround,count(mround) CNT,avg({$legDistance}/ldarts) AVG from tblmatch,tblgame,tblleg,tplayer P\r\nwhere mkey=gmkey and gid=lgid and lpid=P.pid and gtype=1 and lscore={$legDistance} and mevid={$event_id} and P.pgender='D' group by mround asc";
$qryResultset = sql_query($qry, $dbi);
$arAVG = array();
while ($a = sql_fetch_row($qryResultset, $dbi)) {
// google charts are normalized between 0 - 100 , we scale from 0 - 50
$arAVG[] = number_format($a[2] * 2, 2, '.', '');
}
$imgURLD = "<img src=\"" . _googleAVGChart('l', $arAVG) . "\"/>";
$imgHEADD = "<h3>Average per Dart Performance Damen Runde 1 - " . sizeof($arAVG) . "</h3>";
# no header in this case ??
#header('Content-Type: application/html; charset=ISO-8859-1');
echo "<table width=100%><tr><td>" . $imgHEADH . "</td><td>" . $imgHEADD . "</td></tr><tr><td>" . $imgURLH . "</td><td>" . $imgURLD . "</td></tr></table";
