1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
|
<?php
require_once("../inc/db.inc");
require_once("../inc/util.inc");
require_once("../inc/translation.inc");
function nresults($app, $state) {
$r = mysql_query("select count(*) as nresults from result where appid=$app->id and server_state=$state");
$foobar = mysql_fetch_object($r);
mysql_free_result($r);
return $foobar->nresults;
}
init_session();
db_init();
$platforms = array();
$r2 = mysql_query("select * from platform");
while ($platform = mysql_fetch_object($r2)) {
if ($platform->deprecated) continue;
array_push($platforms, $platform);
}
mysql_free_result($r2);
page_head(tr(APPS_TITLE));
echo tr(APPS_DESCRIPTION)."<br><br>
";
$result = mysql_query("select * from app");
start_table();
while ($app = mysql_fetch_object($result)) {
echo "<tr><th colspan=3>$app->user_friendly_name</th></tr>\n";
if (0) { // this is too inefficient
$nunsent = nresults($app, 2);
$ninprogress = nresults($app, 4);
$ndone = nresults($app, 5);
echo "<tr><td colspan=3>
$nunsent results unsent
<br> $ninprogress results in progress
<br> $ndone results done
</td></tr>
";
}
echo "<tr><th>".tr(APPS_PLATFORM)."</th><th>".tr(APPS_VERSION)."</th><th>".tr(APPS_INSTALLTIME)."</th></tr>\n";
for ($i=0; $i<sizeof($platforms); $i++) {
$platform = $platforms[$i];
$newest = null;
$r2 = mysql_query("select * from app_version where appid=$app->id and platformid = $platform->id");
while ($av = mysql_fetch_object($r2)) {
if ($av->deprecated) continue;
if (!$newest || $av->version_num>$newest->version_num) {
$newest = $av;
}
}
if ($newest) {
$x = sprintf("%0.2f", $newest->version_num/100);
$y = pretty_time_str($newest->create_time);
echo "<tr>
<td>$platform->user_friendly_name</td>
<td>$x</td>
<td>$y</td>
</tr>
";
}
}
}
end_table();
mysql_free_result($result);
page_tail();
?>
|
