blob: 2de99a1d1cd6ee893c6cb1c017842ff51e5866da (
plain)
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
|
<?php
function init_welcome(&$S) {
$S['title']='Welcome';
}
function body_welcome(&$S) {
echo '<h2>Welcome</h2>';
echo '<div class="box"><h3>Most Popular Downloads</h3>';
$r=query('SELECT `build` FROM `downloads` GROUP BY `build` ORDER BY COUNT(*) DESC LIMIT 3');
if ($r->rowCount()) {
while ($build=$r->fetch(PDO::FETCH_COLUMN)) {
$build=new sql_build($build);
echo $build->display();
}
} else {
echo print_warning('No downloads');
}
echo '</div>';
echo '<div class="box"><h3>Recently Downloaded</h3>';
$r=query('SELECT * FROM `downloads` ORDER BY `time` DESC LIMIT 3');
if ($r->rowCount()) {
while ($download=$r->fetch(PDO::FETCH_ASSOC)) {
$download=new sql_download($download);
echo $download->get_build()->display();
}
} else {
echo print_warning('No downloads');
}
echo '</div>';
echo '<div class="box"><h3>Recently Built</h3>';
$r=query('SELECT * FROM `builds` WHERE `status`="finished/success" ORDER BY `finish` DESC LIMIT 3');
if ($r->rowCount()) {
while ($build=$r->fetch(PDO::FETCH_ASSOC)) {
$build=new sql_build($build);
echo $build->display();
}
} else {
echo print_warning('No finished builds');
}
echo '</div>';
}
?>
|