inter forum

	// 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);