protected function getSeriesLink(int $series, int $listOrder, string $which = 'curr') : string
{
$query = "\n SELECT\n *\n FROM\n hull_blog_series_items\n WHERE\n parent = ?\n AND listorder";
// Dynamic query:
switch ($which) {
case 'prev':
$query .= ' < ? ORDER BY listorder DESC';
break;
case 'curr':
$query .= ' = ?';
break;
case 'next':
$query .= ' > ? ORDER BY listorder ASC';
break;
default:
$query .= ' != ? ORDER BY listorder ASC';
}
$data = $this->db->row($query, $series, $listOrder);
if (empty($data)) {
return '';
}
if (!empty($data['series'])) {
return '/blog/series/' . $this->db->cell('SELECT slug FROM hull_blog_series WHERE seriesid = ?', $data['series']);
}
if (!empty($data['post'])) {
$b = $this->db->row('SELECT blogyear, blogmonth, slug FROM view_hull_blog_list WHERE postid = ?', $data['post']);
return '/blog/' . $b['blogyear'] . '/' . \str_pad($b['blogmonth'], 2, '0', STR_PAD_LEFT) . '/' . $b['slug'];
}
return '';
}