/[BackupPC]/trunk/lib/BackupPC/SearchLib.pm
This is repository of my old source code which isn't updated any more. Go to git.rot13.org for current projects!
ViewVC logotype

Diff of /trunk/lib/BackupPC/SearchLib.pm

Parent Directory Parent Directory | Revision Log Revision Log | View Patch Patch

revision 63 by dpavlin, Sun Aug 21 15:59:55 2005 UTC revision 64 by dpavlin, Sun Aug 21 17:08:55 2005 UTC
# Line 32  sub getUnits() { Line 32  sub getUnits() {
32    
33  sub epoch_to_iso {  sub epoch_to_iso {
34          my $t = shift || return;          my $t = shift || return;
35            $t += 60 * 60 * +2;     # FIXME add TZ
36          my $dt = DateTime->from_epoch( epoch => $t ) || return;          my $dt = DateTime->from_epoch( epoch => $t ) || return;
37          print STDERR "BUG: $t != " . $dt->epoch . "\n" unless ($t == $dt->epoch);          print STDERR "BUG: $t != " . $dt->epoch . "\n" unless ($t == $dt->epoch);
38          return $dt->ymd . ' ' . $dt->hms;          return $dt->ymd . ' ' . $dt->hms;
# Line 115  sub getFiles($$) { Line 116  sub getFiles($$) {
116          $sql_where = " WHERE ". $where if ($where);          $sql_where = " WHERE ". $where if ($where);
117    
118          my $sql_order = qq{          my $sql_order = qq{
119                  ORDER BY files.id                  ORDER BY files.date
120                  LIMIT $on_page                  LIMIT $on_page
121                  OFFSET ?                  OFFSET ?
122          };          };
Legend:
Removed from v.63  
changed lines
  Added in v.64
  ViewVC Help
Powered by ViewVC 1.1.26