public function publishComment(int $commentId) : bool
{
$this->db->beginTransaction();
$this->db->update('hull_blog_comments', ['approved' => true], ['commentid' => $commentId]);
$latestVersion = $this->db->cell('SELECT MAX(versionid) FROM hull_blog_comment_versions WHERE comment = ?', $commentId);
$this->db->update('hull_blog_comment_versions', ['approved' => true], ['versionid' => $latestVersion]);
return $this->db->commit();
}