From de2c01c711867eb764b295ca33e0b764ca1b4011 Mon Sep 17 00:00:00 2001 From: Jules Laplace Date: Thu, 12 Sep 2013 13:25:13 -0500 Subject: bury a thread --- lib/db.pm | 26 ++++++++++++++++++++++++++ 1 file changed, 26 insertions(+) (limited to 'lib') diff --git a/lib/db.pm b/lib/db.pm index 1faa3f4..aefdbe3 100644 --- a/lib/db.pm +++ b/lib/db.pm @@ -944,6 +944,24 @@ sub get_recent_files return \@rows; } +sub get_thread_comment_modified + { + my ($id) = @_; + my $query; + + $id = $dbh->quote($id); + $query = "SELECT MAX(date) FROM comments WHERE id=$id"; + + $sth = $dbh->prepare($query); + $sth->execute(); + my ($date) = $sth->fetchrow_array(); + $sth->finish(); + + if ($date == 0) + { return -1; } + + return $date; + } @@ -1684,6 +1702,14 @@ sub update_thread_size $rows = $dbh->do($query); } +sub update_thread_lastmodified + { + my ($id, $disp) = @_; + $id = $dbh->quote($id); + $disp = $dbh->quote($disp); + $query = "UPDATE threads SET lastmodified=$disp WHERE id=$id"; + $dbh->do($query); + } sub update_thread_display { my ($id, $disp) = @_; -- cgit v1.2.3-70-g09d2