<?php 
	ini_set("display_errors","off");
	session_start();
	//$dbcon=mysql_connect('localhost','root','');
	$dbcon=mysql_connect('35.187.110.251','root','5qA8kDtFkaNtd5vD');
	if (!$dbcon) {
		die('Could not connect: ' . mysql_error());
		}
		$upc="";
	//mysql_select_db('routenote6_upgrade',$dbcon);
	mysql_select_db('rn22_upgrade',$dbcon);
	
	$json = '{"language":"Afrikaans","newtitle":"testcomposition","albumversion":"01","artist":"[Primary, Featuring, Producer]","artistsname":"[tst, test, britneyspears]","primarygenre":"Alternative","compositiondefaut":"2021","composition":"test","recordingdefault":"2021","recording":"test","labelname":"test label","relesedate":"2021/03/16","explicit":"Not Explicit","albumID":"988667676","upc":"5054316196198","uid":"38"}';
	$json_store = json_decode($json);
	
	$userid = $json_store->uid;
	$upc = $json_store->upc;
	
	$lang_info = $json_store->language;
	$releasetitle = $json_store->newtitle;
	$albumversion = $json_store->albumversion;
	$genre = $json_store->primarygenre;
	$cpy_name = $json_store->composition;
	$pcpy_name = $json_store->recording;
	$label =  $json_store->labelname;
	$odate = $json_store->relesedate;
	$expl = $json_store->explicit;
	$custom_album_id = $json_store->albumID;
	$sec_genre = '';
	$cpy_year=$json_store->compositiondefaut;
	$pcpy_year=$json_store->recordingdefault;
	$backtoover = '';
	$sdate = '';
	$pdate = '';
	$modal_expval = 'NO';
	
	$edit_role = $json_store->artist;
	$edit_role=str_replace("[","",$edit_role);
	$edit_role=str_replace("]","",$edit_role);
	$edit_role=str_replace(" ","",$edit_role);
	$primary_role = explode(",",$edit_role);
	$store_did = count($primary_role);
	
	$edit_artist = $json_store->artistsname;
	$edit_artist=str_replace("[","",$edit_artist);
	$edit_artist=str_replace("]","",$edit_artist);
	$edit_artist=str_replace(" ","",$edit_artist);
	$primary_artist = explode(",",$edit_artist);
	
	for($i=0;$i<$store_did;$i++)
	{
	if($i==0){
	$_REQUEST['role']=$primary_role[$i];
	$art = $primary_artist[$i];
	}else{
	$sec_art['artist'] .= $primary_artist[$i].",";
	$sec_art['srole'] .= $primary_role[$i].",";
	}
	}
	
	$time=time();
	
	if($upc!='' && $userid!='' && $lang_info!='' && $releasetitle!='' && $albumversion!=''&& $genre!='' && $cpy_name!=''  && $pcpy_name!='' && $label!='' && $odate!='' && $expl!='' && $custom_album_id!='' && $cpy_year!='' && $pcpy_year!='' && $edit_role!='' && $edit_artist!=''){
	$role_name_res= mysql_query("select r.name from role r, users_roles ur where  ur.rid=r.rid and uid=".$userid);
	$role_name_rec= mysql_fetch_array($role_name_res);
	$rolename_val = $role_name_rec['name'];
	if($rolename_val!='admin'){
		$qry_val= mysql_query("select nid from audio where upc=$upc");
		while($qry_val1 = mysql_fetch_array($qry_val))
		{
	    $nid_val=$qry_val1['nid'];
	    $sql_qry= mysql_query("select nid,status from node  where nid=$nid_val");
		$sql_qry1 = mysql_fetch_array($sql_qry);
		$status_val=$sql_qry1['status'];
					$alldis_count_res = mysql_fetch_array(mysql_query("SELECT count(nid) cnt FROM `route_audio_distribution` WHERE nid =$nid_val AND (wid =1 OR wid =2 OR wid =3)"));
					$alldis_count = $alldis_count_res['cnt'];
					$dis_tkdwncount_res = mysql_fetch_array(mysql_query("SELECT count(nid) cnt FROM `route_audio_distribution` WHERE nid =$nid_val AND tkid=1 AND (wid =1 OR wid =2 OR wid =3)"));
					$dis_tkdwncount = $dis_tkdwncount_res['cnt'];
					
					if($alldis_count!=0 || $dis_tkdwncount!=0)
					{
						if($alldis_count == $dis_tkdwncount)
							$takedown_status = 1;
						else
							$takedown_status = 0;
					} 
			if($status_val==1 && $takedown_status==0){
			$distributors= mysql_query("select distributors from album_distribution where upc=$upc");
		    $distributors_arr = mysql_fetch_array($distributors);
			$array_folder=explode(",",$distributors_arr['distributors']);
			$array_folder=array_unique($array_folder);
			for($tech_count=0;$tech_count<count($array_folder);$tech_count++)
			{
				$wwid='';
				$re = mysql_query("select wid from route_audio_distribution where nid='".$sql_qry1['nid']."' and did in(".$array_folder[$tech_count].") and did not in (0,1,2,3,4,6,7,8,9,10,11,14,17)");
				$re_rec = mysql_fetch_array($re);
				$wwid=$re_rec['wid'];
				if($wwid!='' && $wwid!='4'){
					mysql_query("update route_audio_distribution set wid=4,prepage=".$wwid." where nid='".$sql_qry1['nid']."' and did in(".$array_folder[$tech_count].")");
				}
			}
		    $sq_qqry= mysql_query("select upc,page from approving_user_updates where upc=$upc");
		    $sq_qry1 = mysql_fetch_array($sq_qqry);
			$numr= mysql_num_rows($sq_qqry);
			$page=$sq_qry1['page'];
			$pager=explode(",",$page);
			if(!in_array('Editalbum',$pager)){
		    if($numr==0){
			  mysql_query("insert into approving_user_updates(upc,uid,page) values('".$upc."','".$userid."','Editalbum')");
			 }else{
			$page=$sq_qry1['page'];
			$pager=explode(",",$page);
			if(!in_array('Editalbum',$pager)){
				mysql_query("update approving_user_updates set uid='".$userid."',page= '".$page.",Editalbum',present_id=0 where upc=$upc");
			 }else{
				mysql_query("update approving_user_updates set uid='".$userid."',present_id=0  where upc=$upc");
			 }
			 }
			}
			 $recordcount_query=mysql_query("select * from approved_releases_logs where upc='$upc'");
			$recordcount=mysql_num_rows($recordcount_query);
			if($recordcount!=0)
			{
				//echo "update approved_releases_logs set update_approved_date=now() where upc=$upc";
				//exit;
				mysql_query("update approved_releases_logs set update_approved_date=now(),disapp_highlight=0 where upc=$upc");
			}
			else
			{
				$nid_query=mysql_query("select nid from audio where upc=$upc");
				$nid_query_arr = mysql_fetch_array($nid_query);
				$uid_query=mysql_query("select uid from node where nid=".$nid_query_arr['nid']);
				$uid_query_arr = mysql_fetch_array($uid_query);
				$uid_query_val=$uid_query_arr['uid'];
				//echo "insert into approved_releases_logs (uid,upc,admin_id,update_approved_date) values ($uid_query_val,$upc,$user_id,now())";
				//exit;
				mysql_query("insert into approved_releases_logs (uid,upc,update_approved_date,apdated_approve,disapp_highlight) values ($userid,$upc,now(),'yes',0)");
			}
			//} 
	      }
		}
	}
	$spotify_arturi = '';
	
	/* if($c[$i]!=''){
	$c[$i] = str_replace(",","|",$c[$i]);	
	$sec_art['artist'] .=$c[$i].",";
	}
	if($d[$i]!=''){
	$sec_art['srole'] .=$d[$i].",";
	} */
	/* if($c[$i]!=''){
		if($e[$i]=='')
		{
			$e[$i] = NULL;
		}
		$sec_art['sec_spotifyuri'] .=$e[$i].",";
	} */
	
	$sec_art['artist'] = substr($sec_art['artist'],0,-1);
	$sec_art['srole']   = substr($sec_art['srole'],0,-1);
	//$sec_art['sec_spotifyuri']   = substr($sec_art['sec_spotifyuri'],0,-1);
	$sec_art['sec_spotifyuri']   = '';
	
	$artist_chek = '';
	 $artist_chek_t = '';
	 $artist_chek = $art.','.$sec_art['artist'];
	 $artist_chek_t= explode(',',$artist_chek);
	 $countt=count($artist_chek_t);
	 
	 $_REQUEST['primary_spotifyuri']='';
	 
	 //$artist_chek_uri = $_REQUEST['primary_spotifyuri'].','.$sec_art['sec_spotifyuri'];
	 //$artist_chek_turi = explode(',',$artist_chek_uri);
	 
	 $proprietary_id = '';
	 //$urivalueses = $spotify_arturi.','.$sec_art['sec_spotifyuri'];
	 //$urivalueses = explode(',',$urivalueses);
	 
	 $uidsty = mysql_fetch_array(mysql_query("select uid from release_table where upc='".$upc."'"));
	$userid = $uidsty['uid'];
	 
	 for($i=0;$i<$countt;$i++){
				$urivalues = '';
				/* $urivalues = $urivalueses[$i];
				
				if($artist_chek_turi[$i]!="")
				{
				$urivalues = $urivalueses[$i];
				$strlen = explode("/",$urivalues);
				$arrlen =  count($strlen);
				$urivalues = "spotify:artist:".$strlen[$arrlen-1];
				}
				else
				{
				$urivalues = NULL;	
				} */
		if(trim($artist_chek_t[$i])!='' && trim($artist_chek_t[$i])!='Various Artists'){
		$artist_names = mysql_query("select count(*) as cnt,artist_name,spotify_uri_id from all_artists_id where spotify_uri_id='".$urivalues."' and binary artist_name='".trim($artist_chek_t[$i])."' and login_uid='".$userid."'");
			$artist_che = mysql_fetch_array($artist_names);
			$artist_count = $artist_che['cnt'];
			$artist_nme = $artist_che['artist_name'];
			$spotify_uri_id = $artist_che['spotify_uri_id'];
		$artist_names_dup = mysql_query("select count(*) as cnt,artist_name from all_artists_id where spotify_uri_id='' and binary artist_name='".trim($artist_chek_t[$i])."' and login_uid='".$userid."'");
			$artist_che_dup = mysql_fetch_array($artist_names_dup);
			$artist_count_dup = $artist_che_dup['cnt'];
			//if($artist_count == 0){
				$maxqry = mysql_fetch_array(mysql_query("select max(proprietary_id) as proprietary_id from all_artists_id"));
				$proprietary_id = $maxqry['proprietary_id'];
				$proprietary_id = $proprietary_id + 1;
				$artistname = $artist_chek_t[$i];
				$artistname = preg_replace('/\s+/','%20',$artistname);
				$artistname = str_replace("&","&amp;",$artistname);
				$artistname = str_replace("!","&#33;",$artistname);
				$artistname = str_replace("$","&#36;",$artistname);
				$artistname = str_replace("'","&#39;",$artistname);
				$artistname = str_replace('"',"&#34;",$artistname);
				$artistname = str_replace("<","&#60;",$artistname);
				$artistname = str_replace(">","&#62;",$artistname);
				/* require '/var/www/html/rn22/spotify-web-api-php-master/vendor/autoload.php';
				$typemethod = "artist";
				
				$client_id = '44d9f71573a1464eb2443d8374809071'; 
				$client_secret = '2d4c324462c243c18f8a5d3d86cf3a7f'; 
				$session = new SpotifyWebAPI\Session(
				'44d9f71573a1464eb2443d8374809071',
				'2d4c324462c243c18f8a5d3d86cf3a7f',
				''.$base_url.'/spotify-web-api-php-master-new/demo1.php'
				);
				$session->requestCredentialsToken();
				$accessToken = $session->getAccessToken();
				$totkentval = get_spotify_uri($client_id,$client_secret,$accessToken,$typemethod,$artistname);
				$urlarrry = $totkentval['artists']['items'][0];
				$urivalues = $urlarrry['uri']; */
				
				
				$uri_chk = mysql_query("select * from all_artists_id where spotify_uri_id='".$urivalues."' and login_uid='".$userid."'");
				$uri_chkkk = mysql_fetch_array($uri_chk);
				$spuri_chk = mysql_num_rows($uri_chk);
				
				$duplicate_artist = mysql_fetch_array(mysql_query("select count(*) as cnt,proprietary_id,spotify_uri_id from all_artists_id where spotify_uri_id='".$urivalues."' and binary artist_name='".trim($artist_chek_t[$i])."'"));
				$artist_cnt = $duplicate_artist['cnt'];
				$dup_artist = $duplicate_artist['proprietary_id'];
				$sptfy_uri = $duplicate_artist['spotify_uri_id'];
				if(($dup_artist!=0 && $sptfy_uri!='') || ($artist_cnt!=0 && $sptfy_uri!=$urivalues)){
					$proprietary_id = $dup_artist;
				}
				
				if(($artist_count==0 && $spuri_chk==0) || ($artist_count_dup ==0 && $spotify_uri_id!=$urivalues)){
					
					mysql_query("insert into all_artists_id(proprietary_id,spotify_uri_id,artist_name,upc,login_uid,updated_at) values ('".$proprietary_id."','".$urivalues."','".trim($artist_chek_t[$i])."','".$upc."','".$userid."','".$time."')");
					
				}
				else{
					if($artist_count!=0){
					$ari_chk = mysql_fetch_array(mysql_query("select * from all_artists_id where artist_name='".$artist_nme."'"));
					$artisi_chk = mysql_num_rows($ari_chk);
					$sp_art_uri = $ari_chk['spotify_uri_id'];
					if($sp_art_uri!=$urivalues){
						//mysql_query("update all_artists_id set spotify_uri_id='".$urivalues."',upc='".$upc."',login_uid='".$userid."',updated_at='".$time."' where artist_name='".$artist_nme."'");
					}
				  }
					else if($spuri_chk!=0){
						
						//mysql_query("update all_artists_id set spotify_uri_id='' where spotify_uri_id='".$urivalues."'");
						mysql_query("insert into all_artists_id(proprietary_id,spotify_uri_id,artist_name,upc,login_uid,updated_at) values ('".$proprietary_id."','".$urivalues."','".trim($artist_chek_t[$i])."','".$upc."','".$userid."','".$time."')");
				  }
				   else{}
				
				}
			//}
	 }
		 
	 }
	 $_REQUEST['compilevalue']='No';
	 if($_REQUEST['compilevalue']=='Yes'){ 
	$test="Various Artists";
	mysql_query('update release_table set releasetitle="'.mysql_real_escape_string($releasetitle).'",albumversion="'.mysql_real_escape_string($albumversion).'",artist="'.$test.'",genre="'.mysql_real_escape_string($genre).'",sec_genre="'.mysql_real_escape_string($sec_genre).'",ccopyyear="'.mysql_real_escape_string($cpy_year).'",ccopyname="'.mysql_real_escape_string($cpy_name).'",pcopyyear="'.mysql_real_escape_string($pcpy_year).'",pcopyname="'.mysql_real_escape_string($pcpy_name).'",label="'.mysql_real_escape_string($label).'",explicit="'.mysql_real_escape_string($expl).'",language_info="'.mysql_real_escape_string($lang_info).'",backtooverview="'.mysql_real_escape_string($backtoover).'",salesstartdate="'.mysql_real_escape_string($sdate).'",preorderdate="'.mysql_real_escape_string($pdate).'",originalreleasedate="'.mysql_real_escape_string($odate).'",role="Primary",sec_art="'.mysql_real_escape_string($sec_art['artist']).'",sec_art_role="'.mysql_real_escape_string($sec_art['srole']).'",albumstatus="1", compilevalue="Yes", completion_date=now(), custom_album_id="'.$custom_album_id.'" WHERE upc="'.$upc.'"');
	
	}else{
	mysql_query('update release_table set releasetitle="'.mysql_real_escape_string($releasetitle).'",albumversion="'.mysql_real_escape_string($albumversion).'",artist="'.mysql_real_escape_string($art).'",artist_uri="'.mysql_real_escape_string($spotify_arturi).'",genre="'.mysql_real_escape_string($genre).'",sec_genre="'.mysql_real_escape_string($sec_genre).'",ccopyyear="'.mysql_real_escape_string($cpy_year).'",ccopyname="'.mysql_real_escape_string($cpy_name).'",pcopyyear="'.mysql_real_escape_string($pcpy_year).'",pcopyname="'.mysql_real_escape_string($pcpy_name).'",label="'.mysql_real_escape_string($label).'",explicit="'.mysql_real_escape_string($expl).'",language_info="'.mysql_real_escape_string($lang_info).'",backtooverview="'.mysql_real_escape_string($backtoover).'",salesstartdate="'.mysql_real_escape_string($sdate).'",preorderdate="'.mysql_real_escape_string($pdate).'",originalreleasedate="'.mysql_real_escape_string($odate).'",role="Primary",sec_art="'.mysql_real_escape_string($sec_art['artist']).'",sec_art_uri="'.mysql_real_escape_string($sec_art['sec_spotifyuri']).'",sec_art_role="'.mysql_real_escape_string($sec_art['srole']).'",albumstatus=1 , compilevalue="No", completion_date=now(), custom_album_id="'.$custom_album_id.'" WHERE upc="'.$upc.'"');

	
	}
	
	##################### Regard unfinished release##################
	$albumrel_unfinished= mysql_query("select * from myuploaded_audio_report WHERE upc='".$upc."'");
	$numb_un= mysql_num_rows($albumrel_unfinished);
	if($numb_un!=0){
	$myy_uplload_auo = 'update myuploaded_audio_report set artist_name="'.mysql_real_escape_string($art).'" where upc="'.$upc.'" and release_status="Unfinished"';
	mysql_query($myy_uplload_auo);
	}
	##################add dis_api_report#########################################
	$albumrel_unfinished_api= mysql_query("select * from discography_api_report WHERE upc='".$upc."'");
	$numb_un_api= mysql_num_rows($albumrel_unfinished_api);
	if($numb_un_api!=0){
	$salesstartdatee=mysql_real_escape_string($sdate);
	$salesstartdate=str_replace('/','-',$salesstartdatee);
	$myy_uplload_auo_api = 'update discography_api_report set artist_name="'.mysql_real_escape_string($art).'",artist_role="'.mysql_real_escape_string($_REQUEST['role']).'",sec_artist_name="'.mysql_real_escape_string($sec_art['artist']).'",sec_artist_role="'.mysql_real_escape_string($sec_art['srole']).'",ssd="'.mysql_real_escape_string($salesstartdate).'" where upc="'.$upc.'" and release_status="Unfinished"';
	mysql_query($myy_uplload_auo_api);
	}
	######################################################
	
	$albumrel= mysql_query("select * from album_metadata WHERE upc_id='".$upc."'");
	$numb= mysql_num_rows($albumrel);
		if($numb==0){
		if($_REQUEST['compilevalue']=='Yes'){ 
		$art="Various Artists";
		$_REQUEST['role'] ="Primary";
		$SQL_QRY = "INSERT INTO album_metadata (upc_id, tag, value) VALUES ";
		$SQL_QRY .= '(\''.$upc.'\',"artist","'.mysql_real_escape_string($art).'")';
		mysql_query($SQL_QRY);
		$SQL_QRY = "INSERT INTO album_metadata (upc_id, tag, value) VALUES ";
		$SQL_QRY .= '(\''.$upc.'\',"artistrole","'.mysql_real_escape_string($_REQUEST['role']).'")';
		mysql_query($SQL_QRY);
		$SQL_QRY = "INSERT INTO album_metadata (upc_id, tag, value) VALUES ";
		$SQL_QRY .= '(\''.$upc.'\',"artist_uri","'.mysql_real_escape_string($_REQUEST['primary_spotifyuri']).'")';
		mysql_query($SQL_QRY);
		}else{
		$SQL_QRY = "INSERT INTO album_metadata (upc_id, tag, value) VALUES ";
		$SQL_QRY .= '(\''.$upc.'\',"artist","'.mysql_real_escape_string($art).'")';
		mysql_query($SQL_QRY);
		$SQL_QRY = "INSERT INTO album_metadata (upc_id, tag, value) VALUES ";
		$SQL_QRY .= '(\''.$upc.'\',"artistrole","'.mysql_real_escape_string($_REQUEST['role']).'")';
		mysql_query($SQL_QRY);
		$SQL_QRY = "INSERT INTO album_metadata (upc_id, tag, value) VALUES ";
		$SQL_QRY .= '(\''.$upc.'\',"artist_uri","'.mysql_real_escape_string($_REQUEST['primary_spotifyuri']).'")';
		mysql_query($SQL_QRY);
		}
		$SQL_QRY = "INSERT INTO album_metadata (upc_id, tag, value) VALUES ";
		$SQL_QRY .= '(\''.$upc.'\',"album","'.addslashes(mysql_real_escape_string($releasetitle)).'")';
		mysql_query($SQL_QRY);
		$SQL_QRY = "INSERT INTO album_metadata (upc_id, tag, value) VALUES ";
		$SQL_QRY .= '(\''.$upc.'\',"albumversion","'.addslashes(mysql_real_escape_string($albumversion)).'")';
		mysql_query($SQL_QRY);
		$SQL_QRY = "INSERT INTO album_metadata (upc_id, tag, value) VALUES ";
		$SQL_QRY .= '(\''.$upc.'\',"label","'.mysql_real_escape_string($label).'")';
		mysql_query($SQL_QRY);
		$SQL_QRY = "INSERT INTO album_metadata (upc_id, tag, value) VALUES ";
		$SQL_QRY .= '(\''.$upc.'\',"genre","'.mysql_real_escape_string($genre).'")';
		mysql_query($SQL_QRY);
		$SQL_QRY = "INSERT INTO album_metadata (upc_id, tag, value) VALUES ";
		$SQL_QRY .= '(\''.$upc.'\',"sec_gen","'.mysql_real_escape_string($sec_genre).'")';
		mysql_query($SQL_QRY);
		$SQL_QRY = "INSERT INTO album_metadata (upc_id, tag, value) VALUES ";
		$SQL_QRY .= '(\''.$upc.'\',"cpy_year","'.mysql_real_escape_string($cpy_year).'")';
		mysql_query($SQL_QRY);
		$SQL_QRY = "INSERT INTO album_metadata (upc_id, tag, value) VALUES ";
		$SQL_QRY .= '(\''.$upc.'\',"cpy_name","'.mysql_real_escape_string($cpy_name).'")';
		mysql_query($SQL_QRY);
		$SQL_QRY = "INSERT INTO album_metadata (upc_id, tag, value) VALUES ";
		$SQL_QRY .= '(\''.$upc.'\',"pcpy_year","'.mysql_real_escape_string($pcpy_year).'")';
		mysql_query($SQL_QRY);
		$SQL_QRY = "INSERT INTO album_metadata (upc_id, tag, value) VALUES ";
		$SQL_QRY .= '(\''.$upc.'\',"pcpy_name","'.mysql_real_escape_string($pcpy_name).'")';
		mysql_query($SQL_QRY);
		/* $SQL_QRY = "INSERT INTO album_metadata (upc_id, tag, value) VALUES ";
		$SQL_QRY .= '(\''.$upc.'\',"year","'.mysql_real_escape_string($relyear).'")';
		mysql_query($SQL_QRY); */
		$SQL_QRY = "INSERT INTO album_metadata (upc_id, tag, value) VALUES ";
		$SQL_QRY .= '(\''.$upc.'\',"ssdate","'.mysql_real_escape_string($sdate).'")';
		mysql_query($SQL_QRY);
		$SQL_QRY = "INSERT INTO album_metadata (upc_id, tag, value) VALUES ";
		$SQL_QRY .= '(\''.$upc.'\',"predate","'.mysql_real_escape_string($pdate).'")';
		mysql_query($SQL_QRY);
		$SQL_QRY = "INSERT INTO album_metadata (upc_id, tag, value) VALUES ";
		$SQL_QRY .= '(\''.$upc.'\',"ordate","'.mysql_real_escape_string($odate).'")';
		mysql_query($SQL_QRY);
		$SQL_QRY = "INSERT INTO album_metadata (upc_id, tag, value) VALUES ";
		$SQL_QRY .= '(\''.$upc.'\',"explicit","'.mysql_real_escape_string($expl).'")';
		mysql_query($SQL_QRY);
		$SQL_QRY = "INSERT INTO album_metadata (upc_id, tag, value) VALUES ";
		$SQL_QRY .= '(\''.$upc.'\',"language_info","'.mysql_real_escape_string($lang_info).'")';
		mysql_query($SQL_QRY);
		
		if($_REQUEST['compilevalue']=='No'){
		$SQL_QRY = "INSERT INTO album_metadata (upc_id, tag, value) VALUES ";
		$SQL_QRY .= '(\''.$upc.'\',"sec_art","'.mysql_real_escape_string($sec_art['artist']).'")';
		mysql_query($SQL_QRY);}
		else{
		$SQL_QRY = "DELETE from album_metadata WHERE tag='sec_art'  AND  upc_id='".$upc."'";
		mysql_query($SQL_QRY);
		}
		
		if($_REQUEST['compilevalue']=='No'){
		$SQL_QRY = "INSERT INTO album_metadata (upc_id, tag, value) VALUES ";
		$SQL_QRY .= '(\''.$upc.'\',"sec_art_role","'.mysql_real_escape_string($sec_art['srole']).'")';
		mysql_query($SQL_QRY);}
		else{
		$SQL_QRY = "DELETE from album_metadata WHERE tag='sec_art_role'  AND  upc_id='".$upc."'";
		mysql_query($SQL_QRY);
		}
		
		if($_REQUEST['compilevalue']=='No'){
		$SQL_QRY = "INSERT INTO album_metadata (upc_id, tag, value) VALUES ";
		$SQL_QRY .= '(\''.$upc.'\',"sec_art_uri","'.mysql_real_escape_string($sec_art['sec_spotifyuri']).'")';
		mysql_query($SQL_QRY);}
		else{
		$SQL_QRY = "DELETE from album_metadata WHERE tag='sec_art_uri'  AND  upc_id='".$upc."'";
		mysql_query($SQL_QRY);
		}
		
		}else{
		//album
		$query=mysql_query("select * from album_metadata WHERE tag='album' AND value!='' AND upc_id='".$upc."'");
		$numb= mysql_num_rows($query);
		if($numb==0)
		{
		$SQL_QRY = "INSERT INTO album_metadata (upc_id, tag, value) VALUES ";
		$SQL_QRY .= '(\''.$upc.'\',"album","'.mysql_real_escape_string($releasetitle).'")';
		mysql_query($SQL_QRY);
		}else{
		mysql_query('update album_metadata set value="'.mysql_real_escape_string($releasetitle).'" WHERE tag="album" AND upc_id="'.$upc.'"');
		}
		//album_Version
		$query=mysql_query("select * from album_metadata WHERE tag='albumversion' AND value!='' AND upc_id='".$upc."'");
		$numb= mysql_num_rows($query);
		if($numb==0)
		{
		$SQL_QRY = "INSERT INTO album_metadata (upc_id, tag, value) VALUES ";
		$SQL_QRY .= '(\''.$upc.'\',"albumversion","'.mysql_real_escape_string($albumversion).'")';
		mysql_query($SQL_QRY);
		}else{
		mysql_query('update album_metadata set value="'.mysql_real_escape_string($albumversion).'" WHERE tag="albumversion" AND upc_id="'.$upc.'"');
		}
		//artist
		if($_REQUEST['compilevalue']=='Yes'){ 
		$art="Various Artists";
		$_REQUEST['role'] ="Primary";
		}
		$query=mysql_query("select * from album_metadata WHERE tag='artist' AND value!='' AND upc_id='".$upc."'");
		$numb= mysql_num_rows($query);
		if($numb==0)
		{
		$SQL_QRY = "INSERT INTO album_metadata (upc_id, tag, value) VALUES ";
		$SQL_QRY .= '(\''.$upc.'\',"artist","'.mysql_real_escape_string($art).'")';
		mysql_query($SQL_QRY);
		}else{
		mysql_query('update album_metadata set value="'.mysql_real_escape_string($art).'" WHERE tag="artist" AND upc_id="'.$upc.'"');
		}
		
		//atist_uri
		$query=mysql_query("select * from album_metadata WHERE tag='artist_uri' AND value!='' AND upc_id='".$upc."'");
		$numb= mysql_num_rows($query);
		if($numb==0)
		{
		$SQL_QRY = "INSERT INTO album_metadata (upc_id, tag, value) VALUES ";
		$SQL_QRY .= '(\''.$upc.'\',"artist_uri","'.mysql_real_escape_string($_REQUEST['primary_spotifyuri']).'")';
		mysql_query($SQL_QRY);
		}else{
		mysql_query('update album_metadata set value="'.mysql_real_escape_string($_REQUEST['primary_spotifyuri']).'" WHERE tag="artist_uri" AND upc_id="'.$upc.'"');
		}
		
		//genre
		$query=mysql_query("select * from album_metadata WHERE tag='genre' AND value!='' AND upc_id='".$upc."'");
		$numb= mysql_num_rows($query);
		if($numb==0)
		{
		$SQL_QRY = "INSERT INTO album_metadata (upc_id, tag, value) VALUES ";
		$SQL_QRY .= '(\''.$upc.'\',"genre","'.mysql_real_escape_string($genre).'")';
		mysql_query($SQL_QRY);
		}else{
			mysql_query('update album_metadata set value="'.mysql_real_escape_string($genre).'" WHERE tag="genre" AND upc_id="'.$upc.'"');
		}
		//sec_gen
		$query=mysql_query("select * from album_metadata WHERE tag='sec_gen' AND value!='' AND upc_id='".$upc."'");
		$numb= mysql_num_rows($query);
		if($numb==0)
		{
		$SQL_QRY = "INSERT INTO album_metadata (upc_id, tag, value) VALUES ";
		$SQL_QRY .= '(\''.$upc.'\',"sec_gen","'.mysql_real_escape_string($sec_genre).'")';
		mysql_query($SQL_QRY);
		}else{
			mysql_query('update album_metadata set value="'.mysql_real_escape_string($sec_genre).'" WHERE tag="sec_gen"  AND  upc_id="'.$upc.'"');
		}
		//label
		$query=mysql_query("select * from album_metadata WHERE tag='label' AND value!='' AND upc_id='".$upc."'");
		$numb= mysql_num_rows($query);
		if($numb==0)
		{
		$SQL_QRY = "INSERT INTO album_metadata (upc_id, tag, value) VALUES ";
		$SQL_QRY .= '(\''.$upc.'\',"label","'.mysql_real_escape_string($label).'")';
		mysql_query($SQL_QRY);
		}else{
		mysql_query('update album_metadata set value="'.mysql_real_escape_string($label).'" WHERE tag="label"  AND  upc_id="'.$upc.'"');
		}
		//explicit
		$query=mysql_query("select * from album_metadata WHERE tag='explicit' AND value!='' AND upc_id='".$upc."'");
		$numb= mysql_num_rows($query);
		if($numb==0)
		{
		$SQL_QRY = "INSERT INTO album_metadata (upc_id, tag, value) VALUES ";
		$SQL_QRY .= '(\''.$upc.'\',"explicit","'.mysql_real_escape_string($expl).'")';
		mysql_query($SQL_QRY);
		}else{		
		mysql_query("update album_metadata set value='".mysql_real_escape_string($expl)."' WHERE tag='explicit' AND  upc_id='".$upc."'");
		}
		//language information
		$query=mysql_query("select * from album_metadata WHERE tag='language_info' AND value!='' AND upc_id='".$upc."'");
		$numb= mysql_num_rows($query);
		if($numb==0)
		{
		$SQL_QRY = "INSERT INTO album_metadata (upc_id, tag, value) VALUES ";
		$SQL_QRY .= '(\''.$upc.'\',"language_info","'.mysql_real_escape_string($lang_info).'")';
		mysql_query($SQL_QRY);
		}else{	
		mysql_query('update album_metadata set value="'.mysql_real_escape_string($lang_info).'" WHERE tag="language_info"  AND  upc_id="'.$upc.'"');
		}
		//ssdate
		$query=mysql_query("select * from album_metadata WHERE tag='ssdate' AND value!='' AND upc_id='".$upc."'");
		$numb= mysql_num_rows($query);
		if($numb==0)
		{
		$SQL_QRY = "INSERT INTO album_metadata (upc_id, tag, value) VALUES ";
		$SQL_QRY .= '(\''.$upc.'\',"ssdate","'.mysql_real_escape_string($sdate).'")';
		mysql_query($SQL_QRY);
		}else{		
		mysql_query("update album_metadata set value='".mysql_real_escape_string($sdate)."' WHERE tag='ssdate'  AND  upc_id='".$upc."'");
		}
		//predate
		$query=mysql_query("select * from album_metadata WHERE tag='predate' AND value!='' AND upc_id='".$upc."'");
		$numb= mysql_num_rows($query);
		if($numb==0)
		{
		$SQL_QRY = "INSERT INTO album_metadata (upc_id, tag, value) VALUES ";
		$SQL_QRY .= '(\''.$upc.'\',"predate","'.mysql_real_escape_string($pdate).'")';
		mysql_query($SQL_QRY);
		}else{		
		mysql_query("update album_metadata set value='".mysql_real_escape_string($pdate)."' WHERE tag='predate'  AND  upc_id='".$upc."'");
		}
		//ordate
		$query=mysql_query("select * from album_metadata WHERE tag='ordate' AND value!='' AND upc_id='".$upc."'");
		$numb= mysql_num_rows($query);
		if($numb==0)
		{
		$SQL_QRY = "INSERT INTO album_metadata (upc_id, tag, value) VALUES ";
		$SQL_QRY .= '(\''.$upc.'\',"ordate","'.mysql_real_escape_string($odate).'")';
		mysql_query($SQL_QRY);
		}else{		
		mysql_query("update album_metadata set value='".mysql_real_escape_string($odate)."' WHERE tag='ordate'  AND  upc_id='".$upc."'");
		}
		//cpy_name
		$query=mysql_query("select * from album_metadata WHERE tag='cpy_name' AND value!='' AND upc_id='".$upc."'");
		$numb= mysql_num_rows($query);
		if($numb==0)
		{
		$SQL_QRY = "INSERT INTO album_metadata (upc_id, tag, value) VALUES ";
		$SQL_QRY .= '(\''.$upc.'\',"cpy_name","'.mysql_real_escape_string($cpy_name).'")';
		mysql_query($SQL_QRY);
		}else{		
		mysql_query('update album_metadata set value="'.mysql_real_escape_string($cpy_name).'" WHERE tag="cpy_name"  AND  upc_id="'.$upc.'"');	
		}
		//cpy_year
		$query=mysql_query("select * from album_metadata WHERE tag='cpy_year' AND value!='' AND upc_id='".$upc."'");
		$numb= mysql_num_rows($query);
		if($numb==0)
		{
		$SQL_QRY = "INSERT INTO album_metadata (upc_id, tag, value) VALUES ";
		$SQL_QRY .= '(\''.$upc.'\',"cpy_year","'.mysql_real_escape_string($cpy_year).'")';
		mysql_query($SQL_QRY);
		}else{			
		mysql_query("update album_metadata set value='".mysql_real_escape_string($cpy_year)."' WHERE tag='cpy_year'  AND  upc_id='".$upc."'");
		}
		//pcpy_name
		$query=mysql_query("select * from album_metadata WHERE tag='pcpy_name' AND value!='' AND upc_id='".$upc."'");
		$numb= mysql_num_rows($query);
		if($numb==0)
		{
		$SQL_QRY = "INSERT INTO album_metadata (upc_id, tag, value) VALUES ";
		$SQL_QRY .= '(\''.$upc.'\',"pcpy_name","'.mysql_real_escape_string($pcpy_name).'")';
		mysql_query($SQL_QRY);
		}else{		
		mysql_query('update album_metadata set value="'.mysql_real_escape_string($pcpy_name).'" WHERE tag="pcpy_name"  AND  upc_id="'.$upc.'"');	
		}
		//pcpy_year
		$query=mysql_query("select * from album_metadata WHERE tag='pcpy_year' AND value!='' AND upc_id='".$upc."'");
		$numb= mysql_num_rows($query);
		if($numb==0)
		{
		$SQL_QRY = "INSERT INTO album_metadata (upc_id, tag, value) VALUES ";
		$SQL_QRY .= '(\''.$upc.'\',"pcpy_year","'.mysql_real_escape_string($pcpy_year).'")';
		mysql_query($SQL_QRY);
		}else{			
		mysql_query("update album_metadata set value='".mysql_real_escape_string($pcpy_year)."' WHERE tag='pcpy_year'  AND  upc_id='".$upc."'");	
		}
		/* //year
		$query=mysql_query("select * from album_metadata WHERE tag='year' AND value!='' AND upc_id='".$upc."'");
		$numb= @mysql_num_rows($query);
		if($numb==0)
		{
		$SQL_QRY = "INSERT INTO album_metadata (upc_id, tag, value) VALUES ";
		$SQL_QRY .= '(\''.$upc.'\',"year","'.mysql_real_escape_string($relyear).'")';
		mysql_query($SQL_QRY);
		}else{			
		mysql_query("update album_metadata set value='".mysql_real_escape_string($relyear)."' WHERE tag='year'  AND  upc_id='".$upc."'");
		} */
		
		//artistrole
		$query=mysql_query("select * from album_metadata WHERE tag='artistrole' AND value!='' AND upc_id='".$upc."'");
		$numb= mysql_num_rows($query);
		if($numb==0)
		{
		$SQL_QRY = "INSERT INTO album_metadata (upc_id, tag, value) VALUES ";
		$SQL_QRY .= '(\''.$upc.'\',"artistrole","'.mysql_real_escape_string($_REQUEST['role']).'")';
		mysql_query($SQL_QRY);
		}else{				
		mysql_query("update album_metadata set value='".mysql_real_escape_string($_REQUEST['role'])."' WHERE tag='artistrole'  AND upc_id='".$upc."'");	
		}
		//sec_art
		$query=mysql_query("select * from album_metadata WHERE tag='sec_art' AND value!='' AND upc_id='".$upc."'");
		$numb= mysql_num_rows($query);
		if($numb==0)
		{
		$SQL_QRY = "INSERT INTO album_metadata (upc_id, tag, value) VALUES ";
		$SQL_QRY .= '(\''.$upc.'\',"sec_art","'.mysql_real_escape_string($sec_art['artist']).'")';
		mysql_query($SQL_QRY);
		}else if($_REQUEST['compilevalue']=='No'){			
		mysql_query('update album_metadata set value="'.mysql_real_escape_string($sec_art['artist']).'" WHERE tag="sec_art"  AND  upc_id="'.$upc.'"');	
		}else{
		 mysql_query("DELETE from album_metadata WHERE tag='sec_art'  AND  upc_id='".$upc."'");
		}
		
		//sec_art_role
		$query=mysql_query("select * from album_metadata WHERE tag='sec_art_role' AND value!='' AND upc_id='".$upc."'");
		$numb= mysql_num_rows($query);
		if($numb==0)
		{
		$SQL_QRY = "INSERT INTO album_metadata (upc_id, tag, value) VALUES ";
		$SQL_QRY .= '(\''.$upc.'\',"sec_art_role","'.mysql_real_escape_string($sec_art['role']).'")';
		mysql_query($SQL_QRY);
		}else if($_REQUEST['compilevalue']=='No'){		
		mysql_query("update album_metadata set value='".mysql_real_escape_string($sec_art['role'])."' WHERE tag='sec_art_role'  AND  upc_id='".$upc."'");		
		}else
		{
		mysql_query("DELETE from album_metadata WHERE tag='sec_art_role'  AND  upc_id='".$upc."'");
		}
		
		//sec_art_uri
		$query=mysql_query("select * from album_metadata WHERE tag='sec_art_uri' AND value!='' AND upc_id='".$upc."'");
		$numb= mysql_num_rows($query);
		if($numb==0)
		{
		$SQL_QRY = "INSERT INTO album_metadata (upc_id, tag, value) VALUES ";
		$SQL_QRY .= '(\''.$upc.'\',"sec_art_uri","'.mysql_real_escape_string($sec_art['sec_spotifyuri']).'")';
		mysql_query($SQL_QRY);
		}else if($_REQUEST['compilevalue']=='No'){		
		mysql_query("update album_metadata set value='".mysql_real_escape_string($sec_art['sec_spotifyuri'])."' WHERE tag='sec_art_uri'  AND  upc_id='".$upc."'");
		}else
		{
		mysql_query("DELETE from album_metadata WHERE tag='sec_art_uri'  AND  upc_id='".$upc."'");
		}
			
		}
		
		$vids = mysql_query("SELECT * FROM audio where upc='".$upc."'");
		$numb= mysql_num_rows($vids);
		if($numb!=0){
		while($vidsrec = mysql_fetch_array($vids))
		{
		$vid = $vidsrec['vid'];
		mysql_query('update audio_metadata set value="'.mysql_real_escape_string($releasetitle).'",clean="'.mysql_real_escape_string($releasetitle).'" WHERE tag="album" AND vid="'.$vid.'"');
		mysql_query('update audio_metadata set value="'.mysql_real_escape_string($album_version).'",clean="'.mysql_real_escape_string($album_version).'" WHERE tag="albumversion" AND vid="'.$vid.'"');
		mysql_query('update audio_metadata set value="'.mysql_real_escape_string($genre).'",clean="'.mysql_real_escape_string($genre).'" WHERE tag="genre" AND vid="'.$vid.'"');
		mysql_query('update audio_metadata set value="'.mysql_real_escape_string($sec_genre).'",clean="'.mysql_real_escape_string($sec_genre).'" WHERE tag="sec_gen"  AND  vid="'.$vid.'"');
		mysql_query('update audio_metadata set value="'.mysql_real_escape_string($label).'",clean="'.mysql_real_escape_string($label).'" WHERE tag="label"  AND  vid="'.$vid.'"');
		/* mysql_query('update audio_metadata set value="'.mysql_real_escape_string($expl).'",clean="'.mysql_real_escape_string($expl).'" WHERE tag="explicit" AND  vid="'.$vid.'"'); */
		mysql_query('update audio_metadata set value="'.mysql_real_escape_string($sdate).'",clean="'.mysql_real_escape_string($sdate).'" WHERE tag="ssdate"  AND  vid="'.$vid.'"');
		mysql_query('update audio_metadata set value="'.mysql_real_escape_string($odate).'",clean="'.mysql_real_escape_string($odate).'" WHERE tag="ordate"  AND  vid="'.$vid.'"');
		mysql_query('update audio_metadata set value="'.mysql_real_escape_string($cpy_name).'" , clean="'.mysql_real_escape_string($cpy_name).'" WHERE tag="cpy_name"  AND  vid="'.$vid.'"');	
		mysql_query('update audio_metadata set value="'.mysql_real_escape_string($cpy_year).'",clean="'.mysql_real_escape_string($cpy_year).'" WHERE tag="cpy_year"  AND  vid="'.$vid.'"');
		
		if($genre=='Instrumental' || $sec_genre=='Instrumental'){
			mysql_query("update audio_metadata set value='None',clean='None' WHERE tag='language_info'  AND  vid='".$vid."'");
		}else{
			$lang_check = mysql_query("select * from audio_metadata where tag='language_info' and value='None' and vid='".$vid."'");
			$lang_checks = mysql_num_rows($lang_check);
			if($lang_checks!=0){
				mysql_query('update audio_metadata set value="'.mysql_real_escape_string($lang_info).'",clean="'.mysql_real_escape_string($lang_info).'" WHERE tag="language_info" AND  vid="'.$vid.'"');
			}
		}
		
		$query=mysql_query("select * from audio_metadata  WHERE tag='pcpy_name'  AND  vid='".$vid."'");	
		$numb= mysql_num_rows($query);
		if($numb==0)
		{
		$SQL_QRY = "INSERT INTO audio_metadata (vid, tag, value,clean) VALUES ";
		$SQL_QRY .= '(\''.$vid.'\',"pcpy_name","'.mysql_real_escape_string($pcpy_name).'","'.mysql_real_escape_string($pcpy_name).'")';
		mysql_query($SQL_QRY);
		}else{	
		mysql_query('update audio_metadata set value="'.mysql_real_escape_string($pcpy_name).'",clean="'.mysql_real_escape_string($pcpy_name).'" WHERE tag="pcpy_name"  AND  vid="'.$vid.'"');	
		}
		$query=mysql_query("select * from audio_metadata WHERE tag='pcpy_year'  AND  vid='".$vid."'");
		$numb= mysql_num_rows($query);
		if($numb==0)
		{
		$SQL_QRY = "INSERT INTO audio_metadata (vid, tag, value,clean) VALUES ";
		$SQL_QRY .= '(\''.$vid.'\',"pcpy_year","'.mysql_real_escape_string($pcpy_year).'","'.mysql_real_escape_string($pcpy_year).'")';
		mysql_query($SQL_QRY);
		}else{			
		mysql_query("update audio_metadata set value='".mysql_real_escape_string($pcpy_year)."',clean='".mysql_real_escape_string($pcpy_year)."' WHERE tag='pcpy_year'  AND  vid='".$vid."'");	
		}
		/* mysql_query("update audio_metadata set value='".mysql_real_escape_string($relyear)."',clean='".mysql_real_escape_string($relyear)."' WHERE tag='year'  AND  vid='".$vid."'"); */
		}
		
}
		if($modal_expval=='YES'){		
		mysql_query("update release_table set model_explicit_clean='".$modal_expval."' WHERE upc='".$upc."'");		
		}
		$_SESSION['artist']="";
		$_SESSION['artist_uri'] = ""; /* primary spotify uri */
		$_SESSION['title']="";
		$_SESSION['label']="";
		$_SESSION['genre']="";
		$_SESSION['edit_album_info_title']="";
		$_SESSION['album_version']="";
		$_SESSION['sec_genre']="";
		$_SESSION['ccopyname']="";
		$_SESSION['ccopyyear']="";
		$_SESSION['pcopyname']="";
		$_SESSION['pcopyyear']="";
		$_SESSION['explicit']="";
		//$_SESSION['sale_date']="";
		$_SESSION['id-textbox-1']="";
		$_SESSION['pre_date']="";
		$_SESSION['org_date']="";	
		/* $_SESSION['releaseyear']=""; */
		$_SESSION['explicit']="";
		$_SESSION['compilevalue']="";
	$albumrel= mysql_query("select * from release_table WHERE upc='".$upc."'");
	$role_rec= mysql_fetch_array($albumrel);	
	$upc_id=$role_rec['upc'];
			if($upc_id!=''){
				$album_res= mysql_query("select * from release_table WHERE status=1 and upc='".$upc."'");
				$rolerec= mysql_fetch_array($album_res);	
				/* $album_res1 = mysql_query("select * from album_metadata WHERE upc_id='".$upc."' AND tag='artist_uri'");
				$rolerecwer= mysql_fetch_array($album_res1);
				print_r($rolerecwer);
				echo "<br /><br />";
				$album_res2 = mysql_query("select * from album_metadata WHERE upc_id='".$upc."' AND tag='sec_art_uri'");
				$rolerecwer2= mysql_fetch_array($album_res2);
				print_r($rolerecwer2);
				exit; */ 	
		
	$album_res= mysql_query("select * from release_table WHERE status=1 and upc='".$upc."'");
		$rolerec= mysql_fetch_array($album_res);	
		$upcid=$rolerec['upc'];
		if($upcid==''){
		$_SESSION['upc']="";
			//$users=arg(0);
			/* if($users=='user'){
			$upc=arg(3);
			drupal_goto('users/seller/edit_album/'.$upc.'');
			}else{
			$upc=arg(1);
			drupal_goto('edit_album/'.$upc.'');
			} */
			}else{
			$_SESSION['upc']="";
			/* $users=arg(0);
			if($users=='user'){
			$upc=arg(3);
			drupal_goto('users/seller/release_details/'.$upc.'');
			}else{
			$upc=arg(1);
			drupal_goto('release_details/'.$upc.'');
			} */
			}
		}else{
			/* $users=arg(0);
			if($users=='user'){
			$upc=arg(3);
			drupal_goto('users/seller/release_details/'.$upc.'');
			}else{
			$upc=arg(1);
			$_SESSION['upc']="";
			drupal_goto('release_details/'.$upc.'');
		} */	
	}
	$edit_api = mysql_fetch_array(mysql_query("select * from release_table where upc='".$upc."'"));
				
				
	$data = array("language"=>$edit_api['language_info'],"release_title"=>$edit_api['releasetitle'],"album_version"=>$edit_api['albumversion'],"artist"=>$edit_api['artist'],"role"=>$edit_api['role'],"sec_art"=>$edit_api['sec_art'],"sec_art_role"=>$edit_api['sec_art_role'],"genre"=>$edit_api['genre'],"label"=>$edit_api['label'],"composition_year"=>$edit_api['ccopyyear'],"composition_name"=>$edit_api['ccopyname'],"recording_year"=>$edit_api['pcopyyear'],"recording_name"=>$edit_api['pcopyname'],"original_date"=>$edit_api['originalreleasedate'],"explicit"=>$edit_api['explicit'],"album_id"=>$edit_api['custom_album_id'],"album_id"=>$edit_api['custom_album_id'],"upc"=>$edit_api['upc'],"uid"=>$json_store->uid);	
	
	//$data = array("message"=>"editalbum updated successfully");
		echo json_encode($data);
	}else{
		$data = array("message"=>"Required parameter is missing");
		echo json_encode($data);
		header( 'HTTP/1.1 400 Bad Request' );
	}
	
?>