public function getPhotoData(int $authorID, string $context) : array
{
$file = $this->db->row("SELECT\n f.fileid,\n f.filename,\n a.slug\n FROM\n hull_blog_author_photos p\n JOIN\n hull_blog_authors a\n ON p.author = a.authorid\n JOIN\n hull_blog_photo_contexts c\n ON p.context = c.contextid\n JOIN\n airship_files f\n ON p.file = f.fileid\n WHERE\n c.label = ? AND a.authorid = ?\n ", $context, $authorID);
if (empty($file)) {
return [];
}
return $file;
}