// Get some variables ready (just as in aeva_viewAlbum)
$urlmore = (isset($_REQUEST['sort']) ? ';sort=' . (int) $_REQUEST['sort'] : '') . (isset($_REQUEST['asc']) ? ';asc' : '') . (isset($_REQUEST['desc']) ? ';desc' : '');
$persort = !empty($peralbum['sort']) ? $peralbum['sort'] : 'm.id_media DESC';
$sort = preg_match('~^m\.([a-z_]+) (A|DE)SC$~', $persort, $dt) ? $persort : 'm.id_media DESC';
$context['aeva_sort'] = !empty($dt[1]) ? $dt[1] : 'id_media';
$context['aeva_asc'] = !empty($dt[2]) && $dt[2] == 'A';
if (!empty($urlmore))
{
$sort_list = array('id_media', 'time_added', 'title', 'views', 'weighted');
$sort = isset($_REQUEST['sort']) ? $sort_list[max(0, min(4, (int) $_REQUEST['sort']))] : $dt[1];
$m_asc = isset($_REQUEST['asc']) && !isset($_REQUEST['desc']) ? true : (in_array($sort, array('m.time_added', 'm.title')) && !isset($_REQUEST['desc']) ? true : false);
$sort .= $m_asc ? ' ASC' : ' DESC';
}
// Get the next and previous item link
$item_data['next'] = $item_data['prev'] = 0;
$item_data['next2'] = $item_data['prev2'] = 0;
$myurl = $amSettings['data_dir_url'];
// Get the complete list of pictures in this album...
$request = $amFunc['db_query']('
SELECT m.id_media, m.title, t.id_file, t.directory, t.filename, t.width, t.height
FROM {db_prefix}aeva_media AS m
LEFT JOIN {db_prefix}aeva_files AS t ON (t.id_file = m.id_thumb)
WHERE m.album_id = {int:current_album} {raw:approvals}
ORDER BY ' . $sort,
array(
'current_album' => $item_data['album_id'],
'approvals' => !aeva_allowedTo('moderate') ? 'AND (approved = 1 OR id_member = '.$user_info['id'].')' : ''
),__FILE__,__LINE__);
// And fetch the ones just before and just after the current one.
$cur = -1;
$prevnext = [];
while ($row = $amFunc['db_fetch_row']($request))
{
if ($row[0] == $item_data['id_media'])
$cur = count($prevnext);
$prevnext[] = $row;
}
$amFunc['db_free_result']($request);