<?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 = '{"stores":"[anghami, napster, 7digital, youtubemusic, qobuz, tiktok]","upc":"5054316629412","uid":"38"}';
	$json_store = json_decode($json);
	
	$userid = $json_store->uid;
	$upc = $json_store->upc;
	
	//$upc = $json_store['upc'];
	
	$manage_store = $json_store->stores;
	$manage_store=str_replace("[","",$manage_store);
	$manage_store=str_replace("]","",$manage_store);
	$manage_store=str_replace(" ","",$manage_store);
	$store_dist = explode(",",$manage_store);
	$store_did = count($store_dist);
		
	if($upc!='' && $userid!='' && $manage_store!=''){
		
		$distributor='';
		$territory ='';		
		$pricing ='';
		$store_id='';
		for($i=0;$i<$store_did;$i++)
		{
			$store_terri = $store_dist[$i];
			if($store_terri=='rndirect'){
				$store_id = 18;
			}elseif($store_terri=='itunes'){
				$store_id = 15;
			}elseif($store_terri=='amazon'){
				$store_id = 12;
			}elseif($store_terri=='emusic'){
				$store_id = 5;
			}elseif($store_terri=='spotify'){
				$store_id = 13;
			}elseif($store_terri=='youtubemusic'){
				$store_id = 21;
			}elseif($store_terri=='anghami'){
				$store_id = 30;
			}elseif($store_terri=='deezer'){
				$store_id = 16;
			}elseif($store_terri=='tidal'){
				$store_id = 24;
			}elseif($store_terri=='claromusica'){
				$store_id = 31;
			}elseif($store_terri=='nuuday'){
				$store_id = 27;
			}elseif($store_terri=='gracenote'){
				$store_id = 29;
			}elseif($store_terri=='kanjian'){
				$store_id = 32;
			}elseif($store_terri=='pandora'){
				$store_id = 33;
			}elseif($store_terri=='napster'){
				$store_id = 17;
			}elseif($store_terri=='melon'){
				$store_id = 34;
			}elseif($store_terri=='iheartradio'){
				$store_id = 35;
			}elseif($store_terri=='7digital'){
				$store_id = 36;
			}elseif($store_terri=='saavn'){
				$store_id = 37;
			}elseif($store_terri=='bugs!'){
				$store_id = 38;
			}elseif($store_terri=='awa'){
				$store_id = 39;
			}elseif($store_terri=='navervibe'){
				$store_id = 40;
			}elseif($store_terri=='facebook'){
				$store_id = 41;
			}elseif($store_terri=='qobuz'){
				$store_id = 42;
			}elseif($store_terri=='netease'){
				$store_id = 43;
			}elseif($store_terri=='tencent'){
				$store_id = 44;
			}elseif($store_terri=='tiktok'){
				$store_id = 45;
			}elseif($store_terri=='kuackmedia'){
				$store_id = 46;
			}elseif($store_terri=='huaweimusic'){
				$store_id = 47;
			}elseif($store_terri=='twitchradio'){
				$store_id = 48;
			}elseif($store_terri=='soundcloud'){
				$store_id = 28;
			}elseif($store_terri=='youtube'){
				$store_id = 22;
			}
				$distributor .= $store_id.",";
			
			
		}
		
		$asset='';
		$ter_tool='';
		$store_tool='';
		$che = '';
		
		$territory='';
		$pricing='';
		
		$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'){
				mysql_query("update approving_user_updates set present_id=0 where upc='".$upc."'");
				$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 status,nid 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,25)");
							$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('Store data',$pager)){
					 if($numr==0){
						 mysql_query("insert into approving_user_updates(upc,uid,page) values('".$upc."','".$userid."','Store data')");
					 }else{
					 $page=$sq_qry1['page'];
					 $pager=explode(",",$page);
					 if(!in_array('Store data',$pager)){
						mysql_query("update approving_user_updates set uid='".$userid."', page= '".$page.",Store data',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)");
						}
					 //}
					 
				  }
				  
				}
		}
		
		$distributor  = substr($distributor,0,-1);
				$testdids= explode(',',$distributor);
				if(in_array(48,$testdids)){
					$twitchstatus = 1;
				$distributor  = str_replace("48","",$distributor);
				$distributor  = str_replace(",,","",$distributor);
				$distributor  = substr($distributor,0,-1);
				}else{
					$twitchstatus = 0;
				}
				
		/* if($distributor == '')
		{
			form_set_error('', t('Please select any one Store'));
			drupal_goto('addstore/form/'.$upc);
		} */
		$store_res= mysql_query("select upc from release_territory WHERE upc=".$upc);
		$store_rec= mysql_fetch_array($store_res);
		$store = $store_rec['upc'];
		if($store==''){
		$qury="insert into release_territory (upc,distributor,territory,asset,admin_store) value ('".$upc."','".$distributor ."','".$ter_tool."','".$asset."','".$store_tool."')";
		mysql_query($qury);
		mysql_query("update release_table set storestatus=1 WHERE upc='$upc'");
		}
		else{
		$qury="update release_territory set  distributor='".$distributor ."' , territory='".$ter_tool."', asset='".$asset."',admin_store='".$store_tool."' WHERE upc='".$upc."'";
		mysql_query($qury);
		mysql_query("update release_table set storestatus=1 WHERE upc='$upc'");
		}
		//added on 22Jul2014 at 2-53pm
		$storeres= mysql_query("select upc from release_pricing WHERE upc=".$upc);
		$storerec= mysql_fetch_array($storeres);
		$storeval= $storerec['upc'];
		if($storeval==''){
		$qury="insert into release_pricing (upc,distributor,pricing) value ('".$upc."','".$distributor ."','".$pricing."')";
		mysql_query($qury);
		mysql_query("update release_table set storestatus=1 WHERE upc='$upc'");

		}
		else{
		$qury="update release_pricing set  distributor='".$distributor ."' , pricing='".$pricing."' WHERE upc='".$upc."'";
		mysql_query($qury);
		mysql_query("update release_table set storestatus=1 WHERE upc='$upc'");

		}
		
		$store_res= mysql_query("select upc,distributors from album_distribution WHERE upc=".$upc);
		$store_rec= mysql_fetch_array($store_res);
		$store_val= $store_rec['upc'];
		$store_dist= $distributor;
		$store_dist= explode(',',$store_dist);
		if($store_val==''){
		$dt = time();
		$SQL_QRY = "INSERT INTO album_distribution (upc, distributors, date, twitchstatus) VALUES ";
		$SQL_QRY .= '("'.$upc.'","'.$distributor .'","'.$dt.'","'.$twitchstatus.'")';
		mysql_query($SQL_QRY);
		}else{
		mysql_query("UPDATE album_distribution SET distributors='".$distributor."',twitchstatus='".$twitchstatus."' WHERE upc='".$upc."'");
		
		$nodevalues = mysql_query("select nid from audio where upc = '".$upc."'");
		while($nodevalue = mysql_fetch_array($nodevalues)){
				$nodeidval .= $nodevalue['nid'].",";
			}
		$nodeidval  = substr($nodeidval,0,-1);
		$dist=$distributor;
		$temp= explode(',',$dist);
	if(in_array('5',$temp)){
		$livewid=mysql_fetch_array(mysql_query("SELECT wid,tkid,tk_status FROM route_audio_distribution WHERE nid IN (".$nodeidval.") and did=5"));
		$wid=$livewid['wid'];
		$tkid=$livewid['tkid'];
		$tk_status=$livewid['tk_status'];
		if($wid=='0')
		{
			mysql_query("update route_audio_distribution set wid=1 WHERE did=5 and nid IN(".$nodeidval.")");
		}
		if(!in_array('5',$store_dist)){
			if(($tkid=='1' || $tk_status=='1') &&  ($wid=='1')){
				mysql_query("update route_audio_distribution set tkid='0' , tk_status='0' WHERE did=5 and nid IN(".$nodeidval.")");
			}
		}
	}else
	{
		mysql_query("update route_audio_distribution set wid=0 WHERE did=5 and nid IN(".$nodeidval.")");
	}
	if(in_array('12',$temp)){
		$livewid=mysql_fetch_array(mysql_query("SELECT wid,tkid,tk_status FROM route_audio_distribution WHERE nid IN (".$nodeidval.") and did=12"));
		$wid=$livewid['wid'];
		$tkid=$livewid['tkid'];
		$tk_status=$livewid['tk_status'];
		if($wid=='0')
		{
			mysql_query("update route_audio_distribution set wid=1 WHERE did=12 and nid IN(".$nodeidval.")");
		}
		if(!in_array('12',$store_dist)){		
			if(($tkid=='1' || $tk_status=='1') &&  ($wid=='1')){
				mysql_query("update route_audio_distribution set tkid='0',tk_status='0' WHERE did=12 and nid IN(".$nodeidval.")");
			}
		}	
		
	}else
	{
		mysql_query("update route_audio_distribution set wid=0 WHERE did=12 and nid IN(".$nodeidval.")");
	}

	if(in_array('13',$temp)){
		$livewid=mysql_fetch_array(mysql_query("SELECT wid,tkid,tk_status FROM route_audio_distribution WHERE nid IN (".$nodeidval.") and did=13"));
		$wid=$livewid['wid'];
		$tkid=$livewid['tkid'];
		$tk_status=$livewid['tk_status'];
		if($wid=='0')
		{
			mysql_query("update route_audio_distribution set wid=1 WHERE did=13 and nid IN(".$nodeidval.")");
		}
		if(!in_array('13',$store_dist)){		
			if(($tkid=='1' || $tk_status=='1') &&  ($wid=='1')){
				mysql_query("update route_audio_distribution set tkid='0' , tk_status='0' WHERE did=13 and nid IN(".$nodeidval.")");
			}
		}
	}else
	{
		mysql_query("update route_audio_distribution set wid=0 WHERE did=13 and nid IN(".$nodeidval.")");
	}
	if(in_array('15',$temp)){
		$livewid=mysql_fetch_array(mysql_query("SELECT wid,tkid,tk_status FROM route_audio_distribution WHERE nid IN (".$nodeidval.") and did=15"));
		$wid=$livewid['wid'];
		$tkid=$livewid['tkid'];
		$tk_status=$livewid['tk_status'];
		if($wid=='0')
		{
			mysql_query("update route_audio_distribution set wid=1 WHERE did=15 and nid IN(".$nodeidval.")");
		}
		if(!in_array('15',$store_dist)){		
			if(($tkid=='1' || $tk_status=='1') &&  ($wid=='1')){
				mysql_query("update route_audio_distribution set tkid='0' , tk_status='0' WHERE did=15 and nid IN(".$nodeidval.")");
			}
		}	
	}else
	{
		mysql_query("update route_audio_distribution set wid=0 WHERE did=15 and nid IN(".$nodeidval.")");
	}
	if(in_array('16',$temp)){
		$livewid=mysql_fetch_array(mysql_query("SELECT wid,tkid,tk_status FROM route_audio_distribution WHERE nid IN (".$nodeidval.") and did=16"));
		$wid=$livewid['wid'];
		$tkid=$livewid['tkid'];
		$tk_status=$livewid['tk_status'];
		if($wid=='0')
		{
			mysql_query("update route_audio_distribution set wid=1 WHERE did=16 and nid IN(".$nodeidval.")");
		}
		if(!in_array('16',$store_dist)){		
			if(($tkid=='1' || $tk_status=='1') &&  ($wid=='1')){
				mysql_query("update route_audio_distribution set tkid='0' , tk_status='0' WHERE did=16 and nid IN(".$nodeidval.")");
			}
		}	
	}else
	{
		mysql_query("update route_audio_distribution set wid=0 WHERE did=16 and nid IN(".$nodeidval.")");
	}
	if(in_array('18',$temp)){
		$livewid=mysql_fetch_array(mysql_query("SELECT wid,tkid,tk_status FROM route_audio_distribution WHERE nid IN (".$nodeidval.") and did=18"));
		$wid=$livewid['wid'];
		$tkid=$livewid['tkid'];
		$tk_status=$livewid['tk_status'];
		if($wid=='0')
		{
			mysql_query("update route_audio_distribution set wid=1 WHERE did=18 and nid IN(".$nodeidval.")");
		}
	if(!in_array('18',$store_dist)){			
		if(($tkid=='1' || $tk_status=='1') &&  ($wid=='1')){
			mysql_query("update route_audio_distribution set tkid='0' , tk_status='0' WHERE did=18 and nid IN(".$nodeidval.")");
		}
	}	
	}else
	{
		mysql_query("update route_audio_distribution set wid=0 WHERE did=18 and nid IN(".$nodeidval.")");
	}
	if(in_array('19',$temp)){
		$livewid=mysql_fetch_array(mysql_query("SELECT wid,tkid,tk_status FROM route_audio_distribution WHERE nid IN (".$nodeidval.") and did=19"));
		$wid=$livewid['wid'];
		$tkid=$livewid['tkid'];
		$tk_status=$livewid['tk_status'];
		if($wid=='0')
		{
			mysql_query("update route_audio_distribution set wid=1 WHERE did=19 and nid IN(".$nodeidval.")");
		}
	if(!in_array('19',$store_dist)){			
		if(($tkid=='1' || $tk_status=='1') &&  ($wid=='1')){
			mysql_query("update route_audio_distribution set tkid='0' , tk_status='0' WHERE did=19 and nid IN(".$nodeidval.")");
		}
	}	
		}else
	{
		mysql_query("update route_audio_distribution set wid=0 WHERE did=19 and nid IN(".$nodeidval.")");
	}
	/* if(in_array('20',$temp)){
		$livewid=mysql_fetch_array(mysql_query("SELECT wid,tkid,tk_status FROM route_audio_distribution WHERE nid IN (".$nodeidval.") and did=20"));
		$wid=$livewid['wid'];
		$tkid=$livewid['tkid'];
		$tk_status=$livewid['tk_status'];
		if($wid=='0')
		{
			mysql_query("update route_audio_distribution set wid=1 WHERE did=20 and nid IN(".$nodeidval.")");
		}
	if(!in_array('20',$store_dist)){			
		if(($tkid=='1' || $tk_status=='1') &&  ($wid=='1')){
			mysql_query("update route_audio_distribution set tkid='0' , tk_status='0' WHERE did=20 and nid IN(".$nodeidval.")");
		}
	}	
	}else
	{
		mysql_query("update route_audio_distribution set wid=0 WHERE did=20 and nid IN(".$nodeidval.")");
	} */
	if(in_array('21',$temp)){
		$livewid=mysql_fetch_array(mysql_query("SELECT wid,tkid,tk_status FROM route_audio_distribution WHERE nid IN (".$nodeidval.") and did=21"));
		$wid=$livewid['wid'];
		$tkid=$livewid['tkid'];
		$tk_status=$livewid['tk_status'];
		if($wid=='0')
		{
			mysql_query("update route_audio_distribution set wid=1 WHERE did=21 and nid IN(".$nodeidval.")");
		}
	if(!in_array('21',$store_dist)){			
		if(($tkid=='1' || $tk_status=='1') &&  ($wid=='1')){
			mysql_query("update route_audio_distribution set tkid='0' , tk_status='0' WHERE did=21 and nid IN(".$nodeidval.")");
		}	
	}
	}else
	{
		mysql_query("update route_audio_distribution set wid=0 WHERE did=21 and nid IN(".$nodeidval.")");
	}
	if(in_array('22',$temp)){
	$livewid=mysql_fetch_array(mysql_query("SELECT wid,tkid,tk_status FROM route_audio_distribution WHERE nid IN (".$nodeidval.") and did=22"));
	$wid=$livewid['wid'];
	$tkid=$livewid['tkid'];
	$tk_status=$livewid['tk_status'];
		if($wid=='0')
		{
			//mysql_query("update route_audio_distribution_youtube set wid=1 WHERE did=22 and nid IN(".$nodeidval.")");
		}
	if(!in_array('22',$store_dist)){		
		if(($tkid=='1' || $tk_status=='1') &&  ($wid=='1')){
			mysql_query("update route_audio_distribution set tkid='0' , tk_status='0' WHERE did=22 and nid IN(".$nodeidval.")");
		}
	 }
	}else
	{
		mysql_query("update route_audio_distribution set wid=0 WHERE did=22 and nid IN(".$nodeidval.")");
	}	
/* 	if(in_array('23',$temp)){
	$livewid=mysql_fetch_array(mysql_query("SELECT wid,tkid,tk_status FROM route_audio_distribution WHERE nid IN (".$nodeidval.") and did=23"));
	$wid=$livewid['wid'];
	$tkid=$livewid['tkid'];
	$tk_status=$livewid['tk_status'];
		if($wid=='0')
		{
			mysql_query("update route_audio_distribution set wid=1 WHERE did=23 and nid IN(".$nodeidval.")");
		}
	if(!in_array('23',$store_dist)){		
		if(($tkid=='1' || $tk_status=='1') &&  ($wid=='1')){
			mysql_query("update route_audio_distribution set tkid='0' , tk_status='0' WHERE did=23 and nid IN(".$nodeidval.")");
		}
	 }
	}else
	{
		mysql_query("update route_audio_distribution set wid=0 WHERE did=23 and nid IN(".$nodeidval.")");
	} */	
	if(in_array('24',$temp)){
	$livewid=mysql_fetch_array(mysql_query("SELECT wid,tkid,tk_status FROM route_audio_distribution WHERE nid IN (".$nodeidval.") and did=24"));
	$wid=$livewid['wid'];
	$tkid=$livewid['tkid'];
	$tk_status=$livewid['tk_status'];
		if($wid=='0')
		{
			mysql_query("update route_audio_distribution set wid=1 WHERE did=24 and nid IN(".$nodeidval.")");
		}
	if(!in_array('24',$store_dist)){		
		if(($tkid=='1' || $tk_status=='1') &&  ($wid=='1')){
			mysql_query("update route_audio_distribution set tkid='0' , tk_status='0' WHERE did=24 and nid IN(".$nodeidval.")");
		}
	 }
	}else
	{
		mysql_query("update route_audio_distribution set wid=0 WHERE did=24 and nid IN(".$nodeidval.")");
	}	
	
	/*if(in_array('25',$temp)){
	$livewid=mysql_fetch_array(mysql_query("SELECT wid,tkid,tk_status FROM route_audio_distribution WHERE nid IN (".$nodeidval.") and did=25"));
	$wid=$livewid['wid'];
	$tkid=$livewid['tkid'];
	$tk_status=$livewid['tk_status'];
		if($wid=='0')
		{
			mysql_query("update route_audio_distribution set wid=1 WHERE did=25 and nid IN(".$nodeidval.")");
		}
	 if(!in_array('25',$store_dist)){		
		if(($tkid=='1' || $tk_status=='1') &&  ($wid=='1')){
			mysql_query("update route_audio_distribution set tkid='0' , tk_status='0' WHERE did=25 and nid IN(".$nodeidval.")");
		}
	 }
	}else
	{
		mysql_query("update route_audio_distribution set wid=0 WHERE did=25 and nid IN(".$nodeidval.")");
	}
	 */
	if(in_array('26',$temp)){
	$livewid=mysql_fetch_array(mysql_query("SELECT wid,tkid,tk_status FROM route_audio_distribution WHERE nid IN (".$nodeidval.") and did=26"));
	$wid=$livewid['wid'];
	$tkid=$livewid['tkid'];
	$tk_status=$livewid['tk_status'];
		if($wid=='0')
		{
			mysql_query("update route_audio_distribution set wid=1 WHERE did=26 and nid IN(".$nodeidval.")");
		}
	if(!in_array('26',$store_dist)){		
		if(($tkid=='1' || $tk_status=='1') &&  ($wid=='1')){
			mysql_query("update route_audio_distribution set tkid='0' , tk_status='0' WHERE did=26 and nid IN(".$nodeidval.")");
		}
	 }
	}else
	{
		mysql_query("update route_audio_distribution set wid=0 WHERE did=26 and nid IN(".$nodeidval.")");
	}
	
	if(in_array('27',$temp)){
	$livewid=mysql_fetch_array(mysql_query("SELECT wid,tkid,tk_status FROM route_audio_distribution WHERE nid IN (".$nodeidval.") and did=27"));
	$wid=$livewid['wid'];
	$tkid=$livewid['tkid'];
	$tk_status=$livewid['tk_status'];
		if($wid=='0')
		{
			mysql_query("update route_audio_distribution set wid=1 WHERE did=27 and nid IN(".$nodeidval.")");
		}
	if(!in_array('27',$store_dist)){		
		if(($tkid=='1' || $tk_status=='1') &&  ($wid=='1')){
			mysql_query("update route_audio_distribution set tkid='0' , tk_status='0' WHERE did=27 and nid IN(".$nodeidval.")");
		}
	 }
	}else
	{
		mysql_query("update route_audio_distribution set wid=0 WHERE did=27 and nid IN(".$nodeidval.")");
	}
	
	
	if(in_array('28',$temp)){
	$livewid=mysql_fetch_array(mysql_query("SELECT wid,tkid,tk_status FROM route_audio_distribution WHERE nid IN (".$nodeidval.") and did=28"));
	$wid=$livewid['wid'];
	$tkid=$livewid['tkid'];
	$tk_status=$livewid['tk_status'];
		if($wid=='0')
		{
			mysql_query("update route_audio_distribution set wid=1 WHERE did=28 and nid IN(".$nodeidval.")");
		}
	if(!in_array('28',$store_dist)){		
		if(($tkid=='1' || $tk_status=='1') &&  ($wid=='1')){
			mysql_query("update route_audio_distribution set tkid='0' , tk_status='0' WHERE did=28 and nid IN(".$nodeidval.")");
		}
	 }

		$sc_user_access = mysql_query("select sc_status from sc_user_access where uid=".$userid);
		$sc_user_access_one = mysql_fetch_array($sc_user_access);
		$sc_user_access_fin = $sc_user_access_one['sc_status'];
		if($sc_user_access_fin==1)
		{
	 
	 //cleared track
				$datas = mysql_query("select a.upc,a.isrc,n.uid from audio a join node n on n.nid=a.nid where n.del_flag=0 and n.disapproved=0 and a.upc='".$upc."'");
				$datas_fet_cnt = mysql_num_rows($datas);
				
				if($datas_fet_cnt!=0)
				{	
					while( $datas_fet = mysql_fetch_array($datas))
					{
						$upc = $datas_fet['upc'];
						$uid = $datas_fet['uid'];
						$isrc= $datas_fet['isrc'];
						$dt = time();
						
						if($che != "0")
						{
							
							$Query_profile_status=mysql_fetch_array(mysql_query("select profile_status from soundcloud_profile where profile_url = '".$che."' and uid=".$uid." and profile_status!=4"));
							if($Query_profile_status['profile_status'] == 1)
							{
								$qury_cnt=mysql_query("select stcid from soundcloud_track_channel where isrc='".$isrc."'");
								$row_cnt_sc = mysql_num_rows($qury_cnt);
								if($row_cnt_sc==0)
								{
									$val ="INSERT INTO soundcloud_track_channel (upc,uid,isrc,channel,created_date, url_status) VALUES(".$upc.",".$uid.",'".$isrc."','".$che." : Feed Controlled','".$dt."',0)";
									mysql_query($val);
								}
								else
								{
									$val ="Update soundcloud_track_channel set url_status=1, upc=".$upc.",uid=".$uid.",channel='".$che." : Feed Controlled',created_date='".$dt."' where isrc='".$isrc."'";
									mysql_query($val);
								}
							}
							else
							{
								$sc_che_value .= '('.$che.')'.',';
								$err = 1;
							}
							$final_che_val  = substr($sc_che_value,0,-1);
							/* if($err == 1)
							{
								drupal_goto('addstore/form/'.$upc.'');
								drupal_set_message(''.$final_che_val.' belongs to a profile which has not yet been activated. Only Track URLs from Active Whitelisted Profiles can be saved. If you have submitted your Profile URLs for Whitelisting below, will be notified when they are activated.');
							} */
						}
						else
						{
							
							
							//form_set_error('selsound', t('Soundcloud selection requires an associated white-listed profile. Please either select a profile or remove the Soundcloud selection. You may edit this selection at a later date or as soon as you have white-listed a profile.'));
							//drupal_goto('addstore/form/'.$upc.'');
						}
					}
				}
				else
				{
					if($che != "0")
					{
						$release_datas = mysql_query("select uid from release_table where upc='".$upc."'");
						$release_datas_fet = mysql_fetch_array($release_datas);
						$release_uid = $release_datas_fet['uid'];
						
						$relupdate=mysql_query("select stcid from soundcloud_track_channel where upc='".$upc."'");
						$row_relup = mysql_num_rows($relupdate);
						if($row_relup==0)
						{
						$scinsert ="INSERT INTO soundcloud_track_channel (upc,isrc,uid,channel,url_status) VALUES(".$upc.",".$upc.",".$release_uid.",'".$che." : Feed Controlled',0)";
						mysql_query($scinsert);
						}
						else
						{
						$scupdate="Update soundcloud_track_channel set url_status=0,channel='".$che." : Feed Controlled',uid='".$release_uid."' where upc='".$upc."'";
						mysql_query($scupdate);
						}
					}
					else
					{
						/* form_set_error('selsound',t('Soundcloud selection requires an associated white-listed profile. Please either select a profile or remove the Soundcloud selection. You may edit this selection at a later date or as soon as you have white-listed a profile.'));
						drupal_goto('addstore/form/'.$upc.''); */
					}
				}
       }
	}else
		
	{
		mysql_query("update route_audio_distribution set wid=0 WHERE did=28 and nid IN(".$nodeidval.")");
	}
	
	
		if(in_array('29',$temp)){
	$livewid=mysql_fetch_array(mysql_query("SELECT wid,tkid,tk_status FROM route_audio_distribution WHERE nid IN (".$nodeidval.") and did=29"));
	$wid=$livewid['wid'];
	$tkid=$livewid['tkid'];
	$tk_status=$livewid['tk_status'];
		if($wid=='0')
		{
			mysql_query("update route_audio_distribution set wid=1 WHERE did=29 and nid IN(".$nodeidval.")");
		}
	if(!in_array('29',$store_dist)){		
		if(($tkid=='1' || $tk_status=='1') &&  ($wid=='1')){
			mysql_query("update route_audio_distribution set tkid='0' , tk_status='0' WHERE did=29 and nid IN(".$nodeidval.")");
		}
	 }
	}else
	{
		mysql_query("update route_audio_distribution set wid=0 WHERE did=29 and nid IN(".$nodeidval.")");
	}
	if(in_array('33',$temp)){
	$livewid=mysql_fetch_array(mysql_query("SELECT wid,tkid,tk_status FROM route_audio_distribution WHERE nid IN (".$nodeidval.") and did=33"));
	$wid=$livewid['wid'];
	$tkid=$livewid['tkid'];
	$tk_status=$livewid['tk_status'];
		if($wid=='0')
		{
			mysql_query("update route_audio_distribution set wid=1 WHERE did=33 and nid IN(".$nodeidval.")");
		}
	if(!in_array('33',$store_dist)){		
		if(($tkid=='1' || $tk_status=='1') &&  ($wid=='1')){
			mysql_query("update route_audio_distribution set tkid='0' , tk_status='0' WHERE did=33 and nid IN(".$nodeidval.")");
		}
	 }
	}else
	{
		mysql_query("update route_audio_distribution set wid=0 WHERE did=33 and nid IN(".$nodeidval.")");
	}
	if(in_array('34',$temp)){
	$livewid=mysql_fetch_array(mysql_query("SELECT wid,tkid,tk_status FROM route_audio_distribution WHERE nid IN (".$nodeidval.") and did=34"));
	$wid=$livewid['wid'];
	$tkid=$livewid['tkid'];
	$tk_status=$livewid['tk_status'];
		if($wid=='0')
		{
			mysql_query("update route_audio_distribution set wid=1 WHERE did=34 and nid IN(".$nodeidval.")");
		}
	if(!in_array('34',$store_dist)){		
		if(($tkid=='1' || $tk_status=='1') &&  ($wid=='1')){
			mysql_query("update route_audio_distribution set tkid='0' , tk_status='0' WHERE did=34 and nid IN(".$nodeidval.")");
		}
	 }
	}else
	{
		mysql_query("update route_audio_distribution set wid=0 WHERE did=34 and nid IN(".$nodeidval.")");
	}
	if(in_array('35',$temp)){
	$livewid=mysql_fetch_array(mysql_query("SELECT wid,tkid,tk_status FROM route_audio_distribution WHERE nid IN (".$nodeidval.") and did=35"));
	$wid=$livewid['wid'];
	$tkid=$livewid['tkid'];
	$tk_status=$livewid['tk_status'];
		if($wid=='0')
		{
			mysql_query("update route_audio_distribution set wid=1 WHERE did=35 and nid IN(".$nodeidval.")");
		}
	if(!in_array('35',$store_dist)){		
		if(($tkid=='1' || $tk_status=='1') &&  ($wid=='1')){
			mysql_query("update route_audio_distribution set tkid='0' , tk_status='0' WHERE did=35 and nid IN(".$nodeidval.")");
		}
	 }
	}else
	{
		mysql_query("update route_audio_distribution set wid=0 WHERE did=35 and nid IN(".$nodeidval.")");
	} 
	if(in_array('36',$temp)){
	$livewid=mysql_fetch_array(mysql_query("SELECT wid,tkid,tk_status FROM route_audio_distribution WHERE nid IN (".$nodeidval.") and did=36"));
	$wid=$livewid['wid'];
	$tkid=$livewid['tkid'];
	$tk_status=$livewid['tk_status'];
		if($wid=='0')
		{
			mysql_query("update route_audio_distribution set wid=1 WHERE did=36 and nid IN(".$nodeidval.")");
		}
	if(!in_array('36',$store_dist)){		
		if(($tkid=='1' || $tk_status=='1') &&  ($wid=='1')){
			mysql_query("update route_audio_distribution set tkid='0' , tk_status='0' WHERE did=36 and nid IN(".$nodeidval.")");
		}
	 }
	}else
	{
		mysql_query("update route_audio_distribution set wid=0 WHERE did=36 and nid IN(".$nodeidval.")");
	}
	
	if(in_array('37',$temp)){
	$livewid=mysql_fetch_array(mysql_query("SELECT wid,tkid,tk_status FROM route_audio_distribution WHERE nid IN (".$nodeidval.") and did=37"));
	$wid=$livewid['wid'];
	$tkid=$livewid['tkid'];
	$tk_status=$livewid['tk_status'];
		if($wid=='0')
		{
			mysql_query("update route_audio_distribution set wid=1 WHERE did=37 and nid IN(".$nodeidval.")");
		}
		
	if(!in_array('37',$store_dist)){		
		if(($tkid=='1' || $tk_status=='1') &&  ($wid=='1')){
			mysql_query("update route_audio_distribution set tkid='0' , tk_status='0' WHERE did=37 and nid IN(".$nodeidval.")");
		}
	 }
	}else
	{
		mysql_query("update route_audio_distribution set wid=0 WHERE did=37 and nid IN(".$nodeidval.")");
	}
	if(in_array('38',$temp)){
	$livewid=mysql_fetch_array(mysql_query("SELECT wid,tkid,tk_status FROM route_audio_distribution WHERE nid IN (".$nodeidval.") and did=38"));
	$wid=$livewid['wid'];
	$tkid=$livewid['tkid'];
	$tk_status=$livewid['tk_status'];
		if($wid=='0')
		{
			mysql_query("update route_audio_distribution set wid=1 WHERE did=38 and nid IN(".$nodeidval.")");
		}
		
	if(!in_array('38',$store_dist)){		
		if(($tkid=='1' || $tk_status=='1') &&  ($wid=='1')){
			mysql_query("update route_audio_distribution set tkid='0' , tk_status='0' WHERE did=38 and nid IN(".$nodeidval.")");
		}
	 }
	}else
	{
		mysql_query("update route_audio_distribution set wid=0 WHERE did=38 and nid IN(".$nodeidval.")");
	}
	
	if(in_array('39',$temp)){
	$livewid=mysql_fetch_array(mysql_query("SELECT wid,tkid,tk_status FROM route_audio_distribution WHERE nid IN (".$nodeidval.") and did=39"));
	$wid=$livewid['wid'];
	$tkid=$livewid['tkid'];
	$tk_status=$livewid['tk_status'];
		if($wid=='0')
		{
			mysql_query("update route_audio_distribution set wid=1 WHERE did=39 and nid IN(".$nodeidval.")");
		}
		
	if(!in_array('39',$store_dist)){		
		if(($tkid=='1' || $tk_status=='1') &&  ($wid=='1')){
			mysql_query("update route_audio_distribution set tkid='0' , tk_status='0' WHERE did=39 and nid IN(".$nodeidval.")");
		}
	 }
	}else
	{
		mysql_query("update route_audio_distribution set wid=0 WHERE did=39 and nid IN(".$nodeidval.")");
	}

	if(in_array('41',$temp)){
	$livewid=mysql_fetch_array(mysql_query("SELECT wid,tkid,tk_status FROM route_audio_distribution WHERE nid IN (".$nodeidval.") and did=41"));
	$wid=$livewid['wid'];
	$tkid=$livewid['tkid'];
	$tk_status=$livewid['tk_status'];
		if($wid=='0')
		{
			mysql_query("update route_audio_distribution set wid=1 WHERE did=41 and nid IN(".$nodeidval.")");
		}
		
	if(!in_array('41',$store_dist)){		
		if(($tkid=='1' || $tk_status=='1') &&  ($wid=='1')){
			mysql_query("update route_audio_distribution set tkid='0' , tk_status='0' WHERE did=41 and nid IN(".$nodeidval.")");
		}
	 }
	}else
	{
		mysql_query("update route_audio_distribution set wid=0 WHERE did=41 and nid IN(".$nodeidval.")");
	}
	
	if(in_array('42',$temp)){
	$livewid=mysql_fetch_array(mysql_query("SELECT wid,tkid,tk_status FROM route_audio_distribution WHERE nid IN (".$nodeidval.") and did=42"));
	$wid=$livewid['wid'];
	$tkid=$livewid['tkid'];
	$tk_status=$livewid['tk_status'];
		if($wid=='0')
		{
			mysql_query("update route_audio_distribution set wid=1 WHERE did=42 and nid IN(".$nodeidval.")");
		}
		
	if(!in_array('42',$store_dist)){		
		if(($tkid=='1' || $tk_status=='1') &&  ($wid=='1')){
			mysql_query("update route_audio_distribution set tkid='0' , tk_status='0' WHERE did=42 and nid IN(".$nodeidval.")");
		}
	 }
	}else
	{
		mysql_query("update route_audio_distribution set wid=0 WHERE did=42 and nid IN(".$nodeidval.")");
	}
	
	if(in_array('43',$temp)){
	$livewid=mysql_fetch_array(mysql_query("SELECT wid,tkid,tk_status FROM route_audio_distribution WHERE nid IN (".$nodeidval.") and did=43"));
	$wid=$livewid['wid'];
	$tkid=$livewid['tkid'];
	$tk_status=$livewid['tk_status'];
		if($wid=='0')
		{
			mysql_query("update route_audio_distribution set wid=1 WHERE did=43 and nid IN(".$nodeidval.")");
		}
		
	if(!in_array('43',$store_dist)){		
		if(($tkid=='1' || $tk_status=='1') &&  ($wid=='1')){
			mysql_query("update route_audio_distribution set tkid='0' , tk_status='0' WHERE did=43 and nid IN(".$nodeidval.")");
		}
	 }
	}else
	{
		mysql_query("update route_audio_distribution set wid=0 WHERE did=43 and nid IN(".$nodeidval.")");
	}
	
	if(in_array('44',$temp)){
	$livewid=mysql_fetch_array(mysql_query("SELECT wid,tkid,tk_status FROM route_audio_distribution WHERE nid IN (".$nodeidval.") and did=44"));
	$wid=$livewid['wid'];
	$tkid=$livewid['tkid'];
	$tk_status=$livewid['tk_status'];
		if($wid=='0')
		{
			mysql_query("update route_audio_distribution set wid=1 WHERE did=44 and nid IN(".$nodeidval.")");
		}
		
	if(!in_array('44',$store_dist)){		
		if(($tkid=='1' || $tk_status=='1') &&  ($wid=='1')){
			mysql_query("update route_audio_distribution set tkid='0' , tk_status='0' WHERE did=44 and nid IN(".$nodeidval.")");
		}
	 }
	}else
	{
		mysql_query("update route_audio_distribution set wid=0 WHERE did=44 and nid IN(".$nodeidval.")");
	}
	if(in_array('45',$temp)){
	$livewid=mysql_fetch_array(mysql_query("SELECT wid,tkid,tk_status FROM route_audio_distribution WHERE nid IN (".$nodeidval.") and did=45"));
	$wid=$livewid['wid'];
	$tkid=$livewid['tkid'];
	$tk_status=$livewid['tk_status'];
		if($wid=='0')
		{
			mysql_query("update route_audio_distribution set wid=1 WHERE did=45 and nid IN(".$nodeidval.")");
		}
		
	if(!in_array('45',$store_dist)){		
		if(($tkid=='1' || $tk_status=='1') &&  ($wid=='1')){
			mysql_query("update route_audio_distribution set tkid='0' , tk_status='0' WHERE did=45 and nid IN(".$nodeidval.")");
		}
	 }
	}else
	{
		mysql_query("update route_audio_distribution set wid=0 WHERE did=45 and nid IN(".$nodeidval.")");
	}
	
	if(in_array('46',$temp)){
	$livewid=mysql_fetch_array(mysql_query("SELECT wid,tkid,tk_status FROM route_audio_distribution WHERE nid IN (".$nodeidval.") and did=46"));
	$wid=$livewid['wid'];
	$tkid=$livewid['tkid'];
	$tk_status=$livewid['tk_status'];
		if($wid=='0')
		{
			mysql_query("update route_audio_distribution set wid=1 WHERE did=46 and nid IN(".$nodeidval.")");
		}
		
	if(!in_array('46',$store_dist)){		
		if(($tkid=='1' || $tk_status=='1') &&  ($wid=='1')){
			mysql_query("update route_audio_distribution set tkid='0' , tk_status='0' WHERE did=46 and nid IN(".$nodeidval.")");
		}
	 }
	}else
	{
		mysql_query("update route_audio_distribution set wid=0 WHERE did=46 and nid IN(".$nodeidval.")");
	}
	
	if(in_array('47',$temp)){
	$livewid=mysql_fetch_array(mysql_query("SELECT wid,tkid,tk_status FROM route_audio_distribution WHERE nid IN (".$nodeidval.") and did=47"));
	$wid=$livewid['wid'];
	$tkid=$livewid['tkid'];
	$tk_status=$livewid['tk_status'];
		if($wid=='0')
		{
			mysql_query("update route_audio_distribution set wid=1 WHERE did=47 and nid IN(".$nodeidval.")");
		}
		
	if(!in_array('47',$store_dist)){		
		if(($tkid=='1' || $tk_status=='1') &&  ($wid=='1')){
			mysql_query("update route_audio_distribution set tkid='0' , tk_status='0' WHERE did=47 and nid IN(".$nodeidval.")");
		}
	 }
	}else
	{
		mysql_query("update route_audio_distribution set wid=0 WHERE did=47 and nid IN(".$nodeidval.")");
	}
	if(in_array('48',$temp)){
	$livewid=mysql_fetch_array(mysql_query("SELECT wid,tkid,tk_status FROM route_audio_distribution WHERE nid IN (".$nodeidval.") and did=48"));
	$wid=$livewid['wid'];
	$tkid=$livewid['tkid'];
	$tk_status=$livewid['tk_status'];
		if($wid=='0')
		{
			mysql_query("update route_audio_distribution set wid=1 WHERE did=48 and nid IN(".$nodeidval.")");
		}
		
	if(!in_array('48',$store_dist)){		
		if(($tkid=='1' || $tk_status=='1') &&  ($wid=='1')){
			mysql_query("update route_audio_distribution set tkid='0' , tk_status='0' WHERE did=48 and nid IN(".$nodeidval.")");
		}
	 }
	}else
	{
		mysql_query("update route_audio_distribution set wid=0 WHERE did=48 and nid IN(".$nodeidval.")");
	}
	 
}

$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 status,nid 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,25)");
					$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('Store data',$pager)){
			 if($numr==0){
				 mysql_query("insert into approving_user_updates(upc,uid,page) values('".$upc."','".$userid."','Store data')");
			 }else{
			 $page=$sq_qry1['page'];
			 $pager=explode(",",$page);
			 if(!in_array('Store data',$pager)){
				mysql_query("update approving_user_updates set uid='".$userid."', page= '".$page.",Store data',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 upc 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 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)");
				}
			 }
			 
		  }
		  
		}
	}
	$albumrel= mysql_query("select upc 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 upc 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(2);
			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(2);
			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(2);
			$_SESSION['upc']="";
			drupal_goto('release_details/'.$upc.'');
		} */	
	}
	
	$manage_api = mysql_fetch_array(mysql_query("select * from release_territory where upc='".$upc."'"));
		$dist_api = explode(",",$manage_api['distributor']);
	$dist_did = count($dist_api);
		$distributor_api='';
		for($i=0;$i<$dist_did;$i++)
		{
			$store_api = $dist_api[$i];
			if($store_api==18){
				$terri_store ='rndirect';
			}elseif($store_api==15){
				$terri_store ='itunes';
			}elseif($store_api==12){
				$terri_store ='amazon';
			}elseif($store_api==5){
				$terri_store ='emusic';
			}elseif($store_api==13){
				$terri_store ='spotify';
			}elseif($store_api==21){
				$terri_store ='youtubemusic';
			}elseif($store_api==30){
				$terri_store ='anghami';
			}elseif($store_api==16){
				$terri_store ='deezer';
			}elseif($store_api==24){
				$terri_store ='tidal';
			}elseif($store_api==31){
				$terri_store ='claromusica';
			}elseif($store_api==27){
				$terri_store ='nuuday';
			}elseif($store_api==29){
				$terri_store ='gracenote';
			}elseif($store_api==32){
				$terri_store ='kanjian';
			}elseif($store_api==33){
				$terri_store ='pandora';
			}elseif($store_api==17){
				$terri_store ='napster';
			}elseif($store_api==34){
				$terri_store ='melon';
			}elseif($store_api==35){
				$terri_store ='iheartradio';
			}elseif($store_api==36){
				$terri_store ='7digital';
			}elseif($store_api==37){
				$terri_store ='saavn';
			}elseif($store_api==38){
				$terri_store ='bugs!';
			}elseif($store_api==39){
				$terri_store ='awa';
			}elseif($store_api==40){
				$terri_store ='navervibe';
			}elseif($store_api==41){
				$terri_store ='facebook';
			}elseif($store_api==42){
				$terri_store ='qobuz';
			}elseif($store_api==43){
				$terri_store ='netease';
			}elseif($store_api==44){
				$terri_store ='tencent';
			}elseif($store_api==45){
				$terri_store ='tiktok';
			}elseif($store_api==46){
				$terri_store ='kuackmedia';
			}elseif($store_api==47){
				$terri_store ='huaweimusic';
			}elseif($store_api==48){
				$terri_store ='twitchradio';
			}elseif($store_api==28){
				$terri_store ='soundcloud';
			}elseif($store_api==22){
				$terri_store ='youtube';
			}
				$distributor_api .= $terri_store.",";
			
			
		}	
				
	$data = array("store"=>$distributor_api,"upc"=>$manage_api['upc'],"uid"=>$json_store->uid);
	
	//$data = array("message"=>"stores 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' );
	}
	
?>