diff options
Diffstat (limited to 'frontend/pages/welcome.php')
-rw-r--r-- | frontend/pages/welcome.php | 33 |
1 files changed, 33 insertions, 0 deletions
diff --git a/frontend/pages/welcome.php b/frontend/pages/welcome.php index d326f08..4b727e3 100644 --- a/frontend/pages/welcome.php +++ b/frontend/pages/welcome.php @@ -6,5 +6,38 @@ function init_welcome() { function body_welcome() { global $S; echo '<h2>Welcome</h2>'; + echo '<div class="box"><h3>Most Popular Downloads</h3>'; + $r=$S['pdo']->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=$S['pdo']->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=$S['pdo']->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>'; } ?> |