summaryrefslogtreecommitdiff
path: root/lib/VNDB
diff options
context:
space:
mode:
authorYorhel <git@yorhel.nl>2009-08-08 19:45:05 +0200
committerYorhel <git@yorhel.nl>2009-08-08 19:45:05 +0200
commit763cffca97e49d9908ff4d499cdca150bcad5670 (patch)
tree777b8343a6832a539607f0f9f07737cee26c6a88 /lib/VNDB
parentf95031507420e14ab95512b3bfbbbfab8fe5ce9f (diff)
Converted tags.added to timestamptz
Diffstat (limited to 'lib/VNDB')
-rw-r--r--lib/VNDB/DB/Tags.pm5
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);