summaryrefslogtreecommitdiffstats
path: root/web/template/stats/updates_table.php
diff options
context:
space:
mode:
authorLoui Chang <louipc.ist@gmail.com>2008-06-24 08:53:16 +0200
committerLoui Chang <louipc.ist@gmail.com>2008-07-07 17:41:39 +0200
commit36ee5561035af335bc3c900ded7aa89066421226 (patch)
treebb50f608f5049ee9e1dda2b544174ad63290f0a4 /web/template/stats/updates_table.php
parent4372ddb91476523535441b257c286ef413aec66e (diff)
downloadaur-36ee5561035af335bc3c900ded7aa89066421226.tar.gz
aur-36ee5561035af335bc3c900ded7aa89066421226.tar.xz
Move code out of index.php
Move database queries to functions and html to templates. Signed-off-by: Loui Chang <louipc.ist@gmail.com>
Diffstat (limited to 'web/template/stats/updates_table.php')
-rw-r--r--web/template/stats/updates_table.php40
1 files changed, 40 insertions, 0 deletions
diff --git a/web/template/stats/updates_table.php b/web/template/stats/updates_table.php
new file mode 100644
index 00000000..e1eb888e
--- /dev/null
+++ b/web/template/stats/updates_table.php
@@ -0,0 +1,40 @@
+<table class="boxSoft">
+<tr>
+<th colspan="2" class="boxSoftTitle" style="text-align: right">
+<a href="rss2.php"><img src="images/rss.gif"></a>
+<span class="f3"><?php print __("Recent Updates") ?><span class="f5"></span></span>
+</th>
+</tr>
+
+<?php while ($row = mysql_fetch_assoc($newest_packages)): ?>
+
+<tr>
+<td class="boxSoft">
+<span class="f4"><span class="blue">
+<a href="packages.php?ID=<?php print intval($row["ID"]); ?>">
+<?php print $row["Name"] . ' ' . $row["Version"]; ?>
+</a></span>
+</td>
+<td class="boxSoft">
+
+<?php
+$mod_int = intval($row["ModifiedTS"]);
+$sub_int = intval($row["SubmittedTS"]);
+
+if ($mod_int != 0):
+ $modstring = gmdate("r", $mod_int);
+elseif ($sub_int != 0):
+ $modstring = '<img src="images/new.gif" /> ' . gmdate("r", $sub_int);
+else:
+ $modstring = '(unknown)';
+endif;
+?>
+
+<span class="f4"><?php print $modstring; ?></span>
+</td>
+</tr>
+
+<?php endwhile; ?>
+
+</table>
+