query($query) or die('Query failed');
$row = $result->fetchArray();
$title = $row["title"];
$ai_config1 = $row["ai_config1"];
$ai_config2 = $row["ai_config2"];
$ai_ident1 = $row["ai_ident1"];
$ai_ident2 = $row["ai_ident2"];
$map = $row["map"];
$version = $row["version"];
$faction1 = $row["faction1"];
$faction2 = $row["faction2"];
$time = $row["time"];
$query = 'SELECT faction1, faction2,
count(test_id) as total_games,
sum(case when winner = 1 then 1 else 0 end) as side1_won,
sum(case when winner = 2 then 1 else 0 end) as side2_won,
sum(case when winner = 0 then 1 else 0 end) as draw,
sum(case when winner = 1 then 1 else 0 end) * 100. / count(test_id) as side1_won_p,
sum(case when winner = 2 then 1 else 0 end) * 100. / count(test_id) as side2_won_p,
sum(case when winner = 0 then 1 else 0 end) * 100. / count(test_id) as draw_p,
avg(end_turn) as avg_end_turn
FROM "games"
WHERE test_id = ' . $id . '
GROUP BY faction1, faction2';
$result = $db->query($query) or die('Query failed');
?>
Wesnoth AI Testing Statistics
query($query) or die('Query failed');
$row = $result->fetchArray()
?>
| ai_ident1 |
|
| ai_ident2 |
|
| ai_config1 |
|
| ai_config2 |
|
| map |
|
| time |
|
| version |
|
| total games |
|
| side1 won |
|
| side2 won |
|
| draws |
|
| average end turn |
|