X-Git-Url: https://www.chiark.greenend.org.uk/ucgi/~mdw/git/odin-cgi/blobdiff_plain/f0bcb39a65ff55a0cbe3fced66903c730679150a..cc346ee1adf852ba0f4322bc04a78ec64206d37a:/bin/pastebin.userv diff --git a/bin/pastebin.userv b/bin/pastebin.userv index 3c87cb5..fb3b740 100755 --- a/bin/pastebin.userv +++ b/bin/pastebin.userv @@ -6,7 +6,6 @@ use Odin; use DBI; use Encode; use Encode::Locale; -use POSIX; my $BAD = 0; @@ -42,14 +41,12 @@ 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, lang, title + ("SELECT tag, stamp, lang, title FROM odin_pastebin WHERE owner = ? ORDER BY stamp", undef, $Odin::WHO)}) { - my ($stamp, $tag, $lang, $title) = @$r; - my $t = strftime "%Y-%m-%d %H:%M:%S %z", localtime $stamp; - printf "%-25s %-12s %-16s %s\n", - $t, $tag, $lang, encode locale => $title; + my ($tag, $stamp, $lang, $title) = @$r; + Odin::print_columns Odin::fmt_time $stamp => 25, + $tag => 12, $lang => 16, (encode locale => $title) => 0; } } elsif ($op eq "new") { my $op = Odin::OptParse->new(@ARGV);