From 763cffca97e49d9908ff4d499cdca150bcad5670 Mon Sep 17 00:00:00 2001
From: Yorhel <git@yorhel.nl>
Date: Sat, 8 Aug 2009 19:45:05 +0200
Subject: Converted tags.added to timestamptz

---
 lib/Multi/IRC.pm    | 2 +-
 lib/VNDB/DB/Tags.pm | 5 +++--
 2 files changed, 4 insertions(+), 3 deletions(-)

(limited to 'lib')

diff --git a/lib/Multi/IRC.pm b/lib/Multi/IRC.pm
index 84f307d9..8c5d4143 100644
--- a/lib/Multi/IRC.pm
+++ b/lib/Multi/IRC.pm
@@ -274,7 +274,7 @@ sub notify { # name, pid, payload
       'g' AS type, t.id, t.name AS title, u.username
     FROM tags t
     JOIN users u ON u.id = t.addedby
-    WHERE t.added > ?
+    WHERE t.added > to_timestamp(?)
     ORDER BY t.added|;
 
   $_[KERNEL]->post(pg => query => $q, [ $t ], 'formatid', [ keys %{$_[HEAP]{notify}} ]);
diff --git a/lib/VNDB/DB/Tags.pm b/lib/VNDB/DB/Tags.pm
index 3e095d3c..755758c7 100644
--- a/lib/VNDB/DB/Tags.pm
+++ b/lib/VNDB/DB/Tags.pm
@@ -39,7 +39,8 @@ sub dbTagGet {
       't.meta = ?' => $o{meta}?1:0 ) : (),
   );
   my @select = (
-    qw|t.id t.meta t.name t.description t.added t.state t.c_vns|,
+    qw|t.id t.meta t.name t.description t.state t.c_vns|,
+    q|extract('epoch' from t.added) as added|,
     $o{what} =~ /addedby/ ? ('t.addedby', 'u.username') : (),
   );
   my @join = $o{what} =~ /addedby/ ? 'JOIN users u ON u.id = t.addedby' : ();
@@ -88,7 +89,7 @@ sub dbTagEdit {
   my($self, $id, %o) = @_;
 
   $self->dbExec('UPDATE tags !H WHERE id = ?', {
-    $o{upddate} ? ('added = ?' => time) : (),
+    $o{upddate} ? ('added = NOW()' => 1) : (),
     map { +"$_ = ?" => $o{$_} } qw|name meta description state|
   }, $id);
   $self->dbExec('DELETE FROM tags_aliases WHERE tag = ?', $id);
-- 
cgit v1.2.3