| <?php | <?php |
| /*// most interesting | /*// most interesting |
| SELECT sum(heuristic_value) as sum, CNID | SELECT sum(heuristic_value) as sum, CNID |
| FROM `heuristic_results` group by CNID order by sum DESC limit 30 | FROM heuristic_results group by CNID order by sum DESC limit 30 |
| // spread of values | // spread of values |
| select floor(sum) as val,count(*) from (SELECT sum(heuristic_value) | select floor(sum) as val,count(*) from (SELECT sum(heuristic_value) |
| as sum FROM heuristic_results group by CNID) as a group by val*/ | as sum FROM heuristic_results group by CNID) as a group by val*/ |
| $series = Array(); | $series = Array(); |
| include_once("../lib/common.inc.php"); | include_once("../lib/common.inc.php"); |
| $query = "select heuristic_name, floor(heuristic_value) as val,count(*) from heuristic_results group by heuristic_name, val"; | $query = "select heuristic_name, floor(heuristic_value) as val,count(*) from heuristic_results group by heuristic_name, val"; |
| $result = $conn->query($query); | $result = $conn->query($query); |
| foreach ($result->fetchAll() as $r) { | foreach ($result->fetchAll() as $r) { |
| $series[$r["heuristic_name"]][$r["val"]] = $r[2]; | $series[$r["heuristic_name"]][$r["val"]] = $r[2]; |
| } | } |
| ?> | ?> |