<?
/*
https://500px.com/antoniodiaz/galleries/wedding-10
https://www.flickr.com/photos/bryaniceman/albums/72157620860152988
https://1x.com/member/photoma/albums/515
*/
require_once('/home/www/artlimited/include/i_declare.php');
require_once(AL_PATH.'include/i_session.php');
require(AL_PATH.'include/i_database.php');
require_once(AL_PATH.'include/i_library.php');
require_once(AL_PATH.'include/i_country.php');
require_once(AL_PATH.'/include/i_member.php');
require_once(AL_PATH.'/user/i_function.php');
require_once(AL_PATH.'/image/i_declare.php');

$DesignParam['FOOTER_IMAGE_FEATURED']=0;

$User=detect_user_from_id_or_nickname($db_pf,$_GET['user']);
$MemberId=intval($User['Id']);

if ($MemberId==0) require(AL_PATH.'/include/i_error_404.php');

// ---- Is member blocked

if (member_blocked($db_pf,$User['Id'],$_SESSION['UserId'])) {
	header('location: /');
	exit(0);
}

// ---- Get collection info

$SQL='SELECT picbase.Id,
			COL.Id AS ThisId,COL.Name,COL.UrlSlug,COL.Comment,COL.CountPublic,COL.CountPrivate,
			User.Folder,
			PO'.IMAGE_ADULT_CONTENT.'.Value AS Adult,
	  	PO'.IMAGE_URL_SLUG_STRING.'.Value AS Slug,
	  	0 AS Scale,
	  	0 AS LinkInternal
			FROM picbase
			INNER JOIN members ON members.Id='.$User['Id'].' AND members.Active=1
			INNER JOIN members User ON User.Id=picbase.Uid AND members.Active=1
			INNER JOIN '.COLLECTION_FAVOURITES_TABLE_NAME.' FAV ON FAV.CollectionId='.intval($_GET['cid']).' AND FAV.ArtworkId=picbase.Id
			LEFT JOIN '.COLLECTION_TABLE_NAME.' COL ON COL.Id='.intval($_GET['cid']).'
			LEFT JOIN picbase_options PO'.IMAGE_ADULT_CONTENT.' ON PO'.IMAGE_ADULT_CONTENT.'.Id=picbase.Id AND PO'.IMAGE_ADULT_CONTENT.'.Type='.IMAGE_ADULT_CONTENT.'
			LEFT JOIN picbase_options_char PO'.IMAGE_URL_SLUG_STRING.' ON PO'.IMAGE_URL_SLUG_STRING.'.Id=picbase.Id AND PO'.IMAGE_URL_SLUG_STRING.'.Type='.IMAGE_URL_SLUG_STRING.'
			WHERE
			1
			ORDER BY FAV.DateIn DESC
			LIMIT 1';

// if ($_SESSION['UserId']==2) mail(SITE_EMAIL,'SQL Collection FAV #'.intval($_GET['cid']),$SQL);

db_no_lock_set($db_pf);
$CollectionQuery=db_query(__FILE__,__LINE__,$SQL,$db_pf);
db_no_lock_reset($db_pf);
$CollectionInfo=db_fetch_assoc($CollectionQuery);

/*
debug($SQL);
debug(var_export($CollectionInfo,1));
exit();
*/

if (!$CollectionInfo) require(AL_PATH.'/include/i_error_404.php');

$CollectionInfo['CountArtworks']=($_SESSION['UserId']==$User['Id'] ? $CollectionInfo['CountPrivate']:$CollectionInfo['CountPublic']);

// ---- here we go

require_once(AL_PATH.'/include/i_language.php'); // needed to get status
require_once(AL_PATH.'/include/i_culture_dictionnary_'.$_SESSION['UserLang'].'.php');
require_once(AL_PATH.'/user/public/i_user.php');

// ---- verify if good url

parse_str(parse_url($_SERVER['REQUEST_URI'],PHP_URL_QUERY),$QSArray);
$_GET=array_merge($_GET,$QSArray);
$MetaLink=display_full_url($User['Id'],$User['NickName']).sprintf(URL_USER_FAVOURITE_COLLECTION,$CollectionInfo['UrlSlug'],$_SESSION['UserLang'],$CollectionInfo['ThisId']).($_GET['offset']>0 ? '?offset='.$_GET['offset']:'');

/*
debug(var_export($_SERVER,1));
debug($MetaLink);
exit();
*/

$Found=strpos(HTTP_WWW.SITE_DOMAIN.$_SERVER['REQUEST_URI'],$MetaLink);
if ($Found!=0 || $Found===FALSE) {
	header('HTTP/1.1 301 Moved Permanently',TRUE,301);
	header('location: '.$MetaLink);
	exit();
}

// ---- Mark in last members_seen

if (!empty($_SESSION['UserId']) && $_SESSION['UserId']!=$User['Id'] && $User['Id']!=0) {
	$SQL='DELETE LOW_PRIORITY FROM members_seen WHERE UserId='.$_SESSION['UserId'].' AND OwnerId='.$User['Id'].' AND TypeId='.OBJ_PROFILE;
	db_query(__FILE__,__LINE__,$SQL,$db_pf);
	$SQL='INSERT LOW_PRIORITY INTO members_seen (UserId,OwnerId,TypeId,RecDate) VALUES ('.$_SESSION['UserId'].','.$User['Id'].','.OBJ_PROFILE.',NOW())';
	db_query(__FILE__,__LINE__,$SQL,$db_pf);
}

// ---- display header

$MetaTitle=sprintf($RsDic['PROFILE_FAVOURITE_META_LINK_TITLE'],$CollectionInfo['Name'],$User['FullName'],$CollectionInfo['CountArtworks'],plural($CollectionInfo['CountArtworks']));
$MetaDescription=($CollectionInfo['Comment'] ? nl2br(htmlentities($CollectionInfo['Comment'])).' - ':'').sprintf($RsDic['PROFILE_FAVOURITE_META_DESCRIPTION'],$CollectionInfo['Name'],$User['FullName'],$CollectionInfo['CountArtworks'],plural($CollectionInfo['CountArtworks']));
$MetaImage[0]=get_image_file_name($CollectionInfo);

if ($_SESSION['UserLang']=='fr') {
	// $MetaCanonical=$FullUrl.(intval($_REQUEST['tabid'])>0 ? '&tabid='.intval($_REQUEST['tabid']):'');
	$MetaAlternate['URL']=display_full_url($User['Id'],$User['NickName']).sprintf(URL_USER_FAVOURITE_COLLECTION,$CollectionInfo['UrlSlug'],'en',$CollectionInfo['ThisId']);
	$MetaAlternate['LANG']='en';
} else {
	$MetaAlternate['URL']=display_full_url($User['Id'],$User['NickName']).sprintf(URL_USER_FAVOURITE_COLLECTION,$CollectionInfo['UrlSlug'],'fr',$CollectionInfo['ThisId']);
	$MetaAlternate['LANG']='fr';
}

require(AL_PATH.'/include/i_page_header.php');
if (!empty($User['GoogleAnalyticsCode'])) echo $User['GoogleAnalyticsCode'];

// ------- Start display

/*
display_user_header($User);

echo '<div style="text-align:center;">';
tab_display($TabArray);
echo '</div>';
*/

// ---- last created pictures

$ThumbSize=202;
$PerRow=$Thumb['RowCount']=($_SESSION['UserId']>0 ? 8:6);
$Offset=intval($_GET["offset"]);
if ($Offset<0) $Offset=0;
$Delta=$PerRow*($_SESSION['UserBrowseImgCount']>0 ? $_SESSION['UserBrowseImgCount']:4);
$Param='';
$NoNavigation=0;
$SQLFields=SQL_IMAGE_FIELDS;
$SQL='FROM picbase
			INNER JOIN '.COLLECTION_FAVOURITES_TABLE_NAME.' FAV ON FAV.CollectionId='.$CollectionInfo['ThisId'].' AND FAV.ArtworkId=picbase.Id
			INNER JOIN members ON members.Id=picbase.uid AND members.PicCount>0 AND members.Active=1
			'.($_SESSION['UserId']!=$User['Id'] ? '
  			INNER JOIN picbase_options PO16 ON PO16.Id=picbase.Id AND PO16.Type='.IMAGE_HIDDEN.' AND PO16.Value=0
				INNER JOIN picbase_options PO18 ON PO18.Id=picbase.Id AND PO18.Type='.IMAGE_BLIND_TEST.' AND PO18.Value=0
				INNER JOIN picbase_options PO19 ON PO19.Id=picbase.Id AND PO19.Type='.IMAGE_CHARTER_OUT.' AND PO19.Value=0
				':'').'
			LEFT JOIN picbase_options PO'.IMAGE_ORDER_RANK.' ON PO'.IMAGE_ORDER_RANK.'.Id=picbase.Id AND PO'.IMAGE_ORDER_RANK.'.Type='.IMAGE_ORDER_RANK.'
			LEFT JOIN picbase_selection ON picbase_selection.Id=picbase.Id
			'.SQL_IMAGE_JOIN.'
			WHERE
			1';
$SQLSort='ORDER BY FAV.DateIn DESC';
$SQLLimit='LIMIT '.$Offset.','.$Delta;

$SQLQuery=$SQLFields.CRLF.$SQL.CRLF.$SQLSort.CRLF.$SQLLimit;
// debug($SQLQuery);
db_no_lock_set($db_pf);
$ResultThumb=db_query(__FILE__,__LINE__,$SQLQuery,$db_pf);
db_no_lock_reset($db_pf);

$BaseLine=array(
	'DB_CONN' => '',
	'TEXT_ID' => 0,
	'STRING' => $CollectionInfo['Name'],
	'CULTURE_ID' => $_SESSION['UserCulture'],
	'CLASS' => '',
	'STYLE' => 'padding:0;margin:0;',
	'RETURN' => 0,
);
echo '<div class="Ma20px AlignHC">';
display_base_line($BaseLine);
echo '<div class="Ma10px" style="font-weight:bold;font-size:15px;color:#AAA;">'.sprintf($RsDic['PROFILE_FAVOURITE_LINK_TITLE'],'<span style="color:#222"><a href="'.$User['ProfileUrl'].'" title="'.sprintf($RsDic['PROFILE_PORTRAIT_ALT_LABEL'],$User['FullName']).'" class="dot_link">'.$User['FullName']).'</a></span></div>';
echo '<div><p style="margin:auto;max-width:512px;color:gray;">'.nl2br($CollectionInfo['Comment']).'</p></div>';
echo $CollectionInfo['CountArtworks'].' image'.plural($CollectionInfo['CountArtworks']);
echo '<div class="Ma10px"><a href="'.$User['ProfileUrl'].'" title="'.sprintf($RsDic['PROFILE_PORTRAIT_ALT_LABEL'],$User['FullName']).'"><img src="/user/'.$User['Folder'].'/avatar.gif" style="border-radius:50%;width:50px;height:50px;" alt="'.$User['FullName'].'" /></a></div>';
echo '</div>';

if (db_num_rows($ResultThumb)>0) {
	require(PATH_BROWSE_CORE);
} else {
	$BaseLine=array(
		'DB_CONN' => '',
		'TEXT_ID' => 0,
		'STRING' => sprintf($RsDic['USER_NO_IMAGE_TXT'],$User['FirstName']),
		'CULTURE_ID' => $_SESSION['UserCulture'],
		'CLASS' => 'UserMsgInfo',
		'STYLE' => '',
		'RETURN' => 0,
	);
	display_base_line($BaseLine);
}

// ----- End of page

require_once(AL_PATH.'include/i_page_footer.php');
?>