<?
include "../db/db_conn.php";
include "../counter/count.php";

header("Vary: User-Agent, Accept");


$is_echo_preview_lib = 0;
$is_echo_coll_wish_lib = 0;
$is_echo_rclike_lib = 0;


$start = $_GET["start"];
$start = (int)$start;

$mode = $_GET["mode"];
$ix = $_GET["ix"];


$mTitle = "Album Photos";

if ($mode && $ix) {

	if ($mode=="user") {

		$tmet = mysqli_fetch_array(mysqli_query($connect, "select id,name,new_level from member where idx='".$ix."'"));

		if ($tmet[0]) {

			$mTitle = $tmet["name"]."'".((substr($tmet["name"], -1)=="s")?"":"s")." Album Photos";
		}
		else {
			header("HTTP/1.1 404 Not Found");
			header("Location: ".$url_404);
			exit;
		}

	}

	else if ($mode=="album") {

		$tmet = mysqli_fetch_array(mysqli_query($connect, "select idx,band,album,a_type,release_date,band_idx,ab_str,thumb1,band_idx_2,band_idx_3,band_idx_4,band_idx_5,band_idx_6 from Album where idx='".$ix."'"));

		$brow = mysqli_fetch_array(mysqli_query($connect, "select band,ab_str from Band where idx='".$tmet["band_idx"]."'"));

		if ($tmet[0]) {

			$mTitle = artist_name_text($tmet["band"],$tmet["band_idx"],$tmet["band_idx_2"],$tmet["band_idx_3"],$tmet["band_idx_4"],$tmet["band_idx_5"],$tmet["band_idx_6"])." - ".$tmet["album"]." Album Photos";
		}
		else {
			header("HTTP/1.1 404 Not Found");
			header("Location: ".$url_404);
			exit;
		}

	}

	else if ($mode=="artist") {

		$tmet = mysqli_fetch_array(mysqli_query($connect, "select * from Band where idx='".$ix."'"));
			
		if ($tmet[0]) {

			$artist_idx = $ix;

			$mTitle = $tmet["band"]." Album Photos";
		}
		else {
			header("HTTP/1.1 404 Not Found");
			header("Location: ".$url_404);
			exit;
		}

	}

	else if ($mode=="user-artist") {

		$tp = explode("-",$ix,2);

		$tmet_1 = mysqli_fetch_array(mysqli_query($connect, "select id,name,new_level from member where idx='".$tp[0]."'"));
		$tmet = mysqli_fetch_array(mysqli_query($connect, "select * from Band where idx='".$tp[1]."'"));
		
		if ($tmet_1[0] && $tmet[0]) {

			$artist_idx = $tp[1];

			$mTitle = $tmet_1["name"]." / ".$tmet["band"]." - Album Photos";
		}
		else {
			header("HTTP/1.1 404 Not Found");
			header("Location: ".$url_404);
			exit;
		}

		$no_robots = 1; //noindex

	}

	else {
		
		$mode = $ix = "";
		
	}

}


$mTitle .= echo_page_str($start);


if ($mode=="artist" || $mode=="user-artist") {


	$where_ai_sql = echo_where_ai_sql($artist_idx,$tmet["x_artist_1"],$tmet["x_artist_2"],$tmet["x_artist_3"]);

	$tmp_result = mysqli_query($connect, "select idx from Album_mini where ".$where_ai_sql." order by idx asc");

	$i = 0; $ai_album_photos = "";

	while ($tmp_row = mysqli_fetch_array($tmp_result)) {

		$ai_album_photos .= ($i==0) ? $tmp_row["idx"] : ",".$tmp_row["idx"];
		$i++;
	}

	if (!$ai_album_photos) $ai_album_photos = "0";

}


$where_str = "";


if ($mode=="user" && $ix) {
	
	$where_str = " where mem_idx='".$ix."'";

	$post_str = "mode=user&ix=".$ix;
	$album_photos_url = "/album-photo/user/".$ix."/";
}

else if ($mode=="album" && $ix) {

	$where_str = " where album_idx='".$ix."'";

	$post_str = "mode=album&ix=".$ix;
	$album_photos_url = $breadcrumb_4_url = "/album-photo/album/".$ix."/";
	$breadcrumb_3_url = "/album-photo/artist/".$tmet["band_idx"]."/";

	$breadcrumb_3_name = $brow["band"]." Album Photos";
	$breadcrumb_4_name = $tmet["album"]." Album Photos";
}

else if ($mode=="artist" && $ix) {

	$where_str = " where album_idx in (".$ai_album_photos.")";

	$post_str = "mode=artist&ix=".$ix;
	$album_photos_url = $breadcrumb_3_url = "/album-photo/artist/".$ix."/";

	$breadcrumb_3_name = $tmet["band"]." Album Photos";
}

else if ($mode=="user-artist" && $ix) {
	
	$tp = explode("-",$ix,2);

	$where_str = " where mem_idx='".$tp[0]."' and album_idx in (".$ai_album_photos.")";

	$post_str = "mode=user-artist&ix=".$ix;
	$album_photos_url = "/album-photo/user-artist/".$ix."/";
}


if (!$album_photos_url) {

	$album_photos_url = "/album-photo/all/";
}


$start_str = ($start && $start>1) ? $start."/" : "";

$canonical_url = $album_photos_url.$start_str;


if (preg_match("/thumbnail\.php/",$_SERVER['REQUEST_URI'])) {

	header("HTTP/1.1 301 Moved Permanently");
	header("Location: ".$protocol_site_domain.$canonical_url);
	exit;
}


$head_string = "
<link rel=\"canonical\" href=\"".$protocol_site_domain.$canonical_url."\" />
";


$row_2 = mysqli_fetch_array(mysqli_query($connect, "select count(*) from Album_photo".$where_str));

if (!$start || $start<0) $start = 1;
$total = $row_2[0];
$scale = 120;
$page_scale = $default_page_scale;
$total_page = @ceil($total/$scale);
if ($total_page>0 && $start>$total_page) $start = $total_page;
$m = ($start-1)*$scale;


if ($isMobile) {
	$result = mysqli_query($connect, "select idx,album_idx,thumb_name,format from Album_photo".$where_str." order by idx desc limit ".$m.",".$scale);
}
else {
	$result = mysqli_query($connect, "select idx,mem_idx,album_idx,thumb_name,likes,format from Album_photo".$where_str." order by idx desc limit ".$m.",".$scale);
}


if ($mode=="artist") {

	$breadcrumb_3_cnt = $total;
}

else if ($mode=="album") {
	
	$tmp = mysqli_fetch_array(mysqli_query($connect, "select count(*) from Album_photo where artist_idx='".$tmet["band_idx"]."'"));

	$breadcrumb_3_cnt = $tmp[0];
	$breadcrumb_4_cnt = $total;
}


$chk_num = mysqli_num_rows($result);


if ($isMobile) {

	$no_top_ad = 1;

	if ($chk_num>=22) $echo_matched_content = 1;

	$top_include_file = "../mobile_top.php";

	$main_include_file = "include/mobile_photos_thumbnail.php";

	include "../mobile_site_layout.php";

}
else {

	$top_include_file = "../top_new.php";

	$main_include_file = "include/photos_thumbnail.php";

	$side_include_file_1 = "../side/side_group_2.php";

	if ($chk_num>=22) $side_include_file_2 = "../side/matched_content.php";

	include "../site_layout_new.php";

}

include "../hidden2.php";

?>