X-Git-Url: http://www.chiark.greenend.org.uk/ucgi/~mdw/git/odin-cgi/blobdiff_plain/be24e9afafe0d740652d962fd5531de901a9cd09..cc346ee1adf852ba0f4322bc04a78ec64206d37a:/bin/shorturl.userv

diff --git a/bin/shorturl.userv b/bin/shorturl.userv
index 489168d..3bb1c8a 100755
--- a/bin/shorturl.userv
+++ b/bin/shorturl.userv
@@ -4,7 +4,6 @@ use lib "lib";
 
 use Odin;
 use DBI;
-use POSIX;
 
 Odin::cmdline_who;
 
@@ -23,12 +22,11 @@ EOF
   @ARGV == 0 or Odin::fail "usage: list";
   my $db = Odin::open_db;
   for my $r (@{$db->selectall_arrayref
-      ("SELECT " . Odin::sql_timestamp($db, "stamp") . ", tag, url
+      ("SELECT tag, stamp, url
 	FROM odin_shorturl WHERE owner = ?
 	ORDER BY stamp", undef, $Odin::WHO)}) {
-    my ($stamp, $tag, $url) = @$r;
-    my $t = strftime "%Y-%m-%d %H:%M:%S %z", localtime $stamp;
-    printf "%-25s  %-12s  %s\n", $t, $tag, $url;
+    my ($tag, $stamp, $url) = @$r;
+    Odin::print_columns Odin::fmt_time $stamp => 25, $tag => 12, $url =>0;
   }
 } elsif ($op eq "new") {
   @ARGV == 1 or Odin::fail "usage: new URL";