diff options
author | Yorhel <git@yorhel.nl> | 2009-08-08 19:45:05 +0200 |
---|---|---|
committer | Yorhel <git@yorhel.nl> | 2009-08-08 19:45:05 +0200 |
commit | 763cffca97e49d9908ff4d499cdca150bcad5670 (patch) | |
tree | 777b8343a6832a539607f0f9f07737cee26c6a88 /lib/VNDB | |
parent | f95031507420e14ab95512b3bfbbbfab8fe5ce9f (diff) |
Converted tags.added to timestamptz
Diffstat (limited to 'lib/VNDB')
-rw-r--r-- | lib/VNDB/DB/Tags.pm | 5 |
1 files changed, 3 insertions, 2 deletions
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); |