if (!$enabledMetrics[$provider_name] || !array_key_exists('score_column', $provider)) { not_found(); } # building a query to select all beacon data in one swoop $query = "SELECT urls.id AS url_id, urls.url as url, UNIX_TIMESTAMP(last_update) AS t,"; $query .= "\n\t" . $provider['table'] . '_last_id, UNIX_TIMESTAMP(' . $provider['table'] . '.timestamp) AS ' . $provider_name . '_timestamp'; foreach ($provider['metrics'] as $section_name => $section) { foreach ($section as $metric) { $query .= ",\n\t\t" . $provider['table'] . '.' . $metric[1] . ' AS ' . $provider_name . '_' . $metric[1]; } } $query .= "\nFROM urls"; $query .= "\n\tLEFT JOIN " . $provider['table'] . ' ON urls.' . $provider['table'] . '_last_id = ' . $provider['table'] . '.id'; $query .= "\nWHERE urls.id = " . mysql_real_escape_string($urlid); #echo $query; exit; $result = mysql_query($query); if (!$result) { error_log(mysql_error()); } $row = mysql_fetch_assoc($result); mysql_free_result($result); $score = $row[$provider_name . '_' . $provider['score_column']]; if (!is_null($score)) { $pretty_score = prettyScore($score); if (array_key_exists('output', $_GET) && $_GET['output'] == 'color') { $colors = array(1 => '#EE0000', 2 => '#EE2800', 3 => '#EE4F00', 4 => '#EE7700', 5 => '#EE9F00', 6 => '#EEC600', 7 => '#EEEE00', 8 => '#C6EE00', 9 => '#9FEE00', 10 => '#77EE00', 11 => '#4FEE00', 12 => '#28EE00', 13 => '#00EE00'); echo $colors[scoreColorStep($score)]; } else { echo $score; } }
?> <td class="score" title="Current dynaTrace score: <?php echo prettyScore($row['dt_o']); ?> (<?php echo $row['dt_o']; ?> )"><?php echo prettyScore($row['dt_o']); ?> (<?php echo $row['dt_o']; ?> )</td> <td title="Current dynaTrace score: <?php echo prettyScore($row['dt_o']); ?> (<?php echo $row['dt_o']; ?> )"><div class="gbox"><div style="width: <?php echo $row['dt_o'] + 1; ?> px" class="bar c<?php echo scoreColorStep($row['dt_o']); ?> "/></div></td> <?php } } ?>
} ?> </td><?php $value = $row[$provider_name . '_' . $metric[1]]; if (is_null($value)) { ?> <td class="na">n/a</td> <td><span id="details_<?php echo $provider_name . '_' . $metric[1]; ?> " class="details"></span></td> <td></td> <?php } else { if ($metric[2] == PERCENT_GRADE) { $pretty_score = prettyScore($value); ?> <td class="value"><?php echo $pretty_score; ?> (<i><?php echo htmlentities($value); ?> </i>%)</td> <td><span id="details_<?php echo $provider_name . '_' . $metric[1]; ?> " class="details"></span></td> <td><div class="gbox" title="Current <?php echo $provider['score_name']; ?>