$x = floatval($row[$v1]) * 9 / 5 + 32;
} else {
$x = intval($row[$v1]);
}
$d1[] = array($row['time'], $x);
$spark1[] = $x;
// data column #2
if (substri_count($jsarr[$v2], "Speed") > 0) {
$x = intval($row[$v2]) * 0.621371;
} elseif (substri_count($jsarr[$v2], "Temp") > 0) {
$x = floatval($row[$v2]) * 9 / 5 + 32;
} else {
$x = intval($row[$v2]);
}
$d2[] = array($row['time'], $x);
$spark2[] = $x;
}
$sparkdata1 = implode(",", array_reverse($spark1));
$sparkdata2 = implode(",", array_reverse($spark2));
$max1 = round(max($spark1), 1);
$max2 = round(max($spark2), 1);
$min1 = round(min($spark1), 1);
$min2 = round(min($spark2), 1);
$avg1 = round(average($spark1), 1);
$avg2 = round(average($spark2), 1);
$pcnt25data1 = round(calc_percentile($spark1, 25), 1);
$pcnt25data2 = round(calc_percentile($spark2, 25), 1);
$pcnt75data1 = round(calc_percentile($spark1, 75), 1);
$pcnt75data2 = round(calc_percentile($spark2, 75), 1);
} else {
}
$sessionqry = mysql_query("SELECT {$selectstring} FROM {$db_table} WHERE session={$session_id} ORDER BY time DESC;") or die(mysql_error());
while ($row = mysql_fetch_assoc($sessionqry)) {
$i = 1;
while (isset(${'v' . $i})) {
if (substri_count($keyarr[${'v' . $i}][0], "Speed") > 0) {
$x = intval($row[${'v' . $i}]) * $speed_factor;
${'v' . $i . '_measurand'} = $speed_measurand;
} elseif (substri_count($keyarr[${'v' . $i}][0], "Temp") > 0) {
$x = $temp_func(floatval($row[${'v' . $i}]));
${'v' . $i . '_measurand'} = $temp_measurand;
} else {
$x = intval($row[${'v' . $i}]);
${'v' . $i . '_measurand'} = ' (' . $keyarr[${'v' . $i}][1] . ')';
}
${'d' . $i}[] = array($row['time'], $x);
${'spark' . $i}[] = $x;
$i = $i + 1;
}
}
$i = 1;
while (isset(${'v' . $i})) {
${'v' . $i . '_label'} = '"' . $keyarr[${'v' . $i}][0] . ${'v' . $i . '_measurand'} . '"';
${'sparkdata' . $i} = implode(",", array_reverse(${'spark' . $i}));
${'max' . $i} = round(max(${'spark' . $i}), 1);
${'min' . $i} = round(min(${'spark' . $i}), 1);
${'avg' . $i} = round(average(${'spark' . $i}), 1);
${'pcnt25data' . $i} = round(calc_percentile(${'spark' . $i}, 25), 1);
${'pcnt75data' . $i} = round(calc_percentile(${'spark' . $i}, 75), 1);
$i = $i + 1;
}
}
