<?php 
//$message_text = mysqli_real_escape_string($con,$message_text);
//include('db_b.php'); 
include('db.php');
session_start();
$status = $_GET['status'];
//////////////////////////////////////////////////////////
$curr_day = date("d");
$curr_month = date("m");
$curr_year = date("Y");
/////////////////////////////////////////////////////////////// 
?>
<div style="display:none;">
<?php
$user_ip = getenv('REMOTE_ADDR');
$geo = unserialize(file_get_contents("http://www.geoplugin.net/php.gp?ip=$user_ip"));
$city = $geo["geoplugin_city"];
$region = $geo["geoplugin_regionName"];
$country = $geo["geoplugin_countryName"];
/*echo"$user_ip";
echo "City: ".$city."<br>";
echo "Region: ".$region."<br>";
echo "Country: ".$country."<br>";
/*
geoplugin_request
geoplugin_status
geoplugin_credit
geoplugin_city
geoplugin_region
geoplugin_areaCode
geoplugin_dmaCode
geoplugin_countryCode
geoplugin_countryName
geoplugin_continentCode
geoplugin_latitude
geoplugin_longitude
geoplugin_regionCode
geoplugin_regionName
geoplugin_currencyCode
geoplugin_currencySymbol
geoplugin_currencySymbol_UTF8
geoplugin_currencyConverter
*/
?> 
</div>
<?php
////////////////////////////////////////////////////////////// 
if($status =='insert_movie')
{
	$my_id = $_GET['my_id'];
	$cvideo = $_FILES['video_input']['name'];
	$tmp_file = $_FILES['video_input']['tmp_name'];
	
	$file_type = explode('.',$cvideo);
    $file_type = end($file_type);
    $random_name = rand();
	$random_name = mysqli_real_escape_string($con,$random_name);
	
	$get_vid ="select * from movie_tmptb where my_id='$my_id' ";
    $run_get_vid = mysqli_query($con,$get_vid);
	$check_vid = mysqli_num_rows($run_get_vid);
	while($row_vid = mysqli_fetch_array($run_get_vid)){
		$old_vid = $row_vid['video_url'];
	
	if($check_vid >0){
	
   $update_vid = "update movie_tmptb set video_url='$random_name.$file_type', video_name='', cur_country='$country', cur_city='$city' ,cur_date=CURDATE(), cur_time=CURTIME() where my_id='$my_id' ";
   $run_update_vid = mysqli_query($con,$update_vid);
   
   	if($run_update_vid)
	{ 
        unlink("movie_tmp/$old_vid");
		move_uploaded_file($tmp_file,"movie_tmp/$random_name.$file_type");
	echo"<span style='color:green;'>Post uploaded, Thanks</span>";
	?>
	<input id="active_video" value="<?php echo $random_name.'.'.$file_type;?>" />
	<?php
	}else{echo"Image Not Uploaded, Something Went Wrong.";}
   
		
	}else{
	
	$insert_movie = "insert into movie_tmptb (my_id,video_url,cur_country,cur_city,cur_date,cur_time ) 
	values('$my_id','$random_name.$file_type','$country','$city',CURDATE(),CURTIME() ) ";
	$run_insert_movie = mysqli_query($con,$insert_movie);
		if($run_insert_movie)
	{
		move_uploaded_file($tmp_file,"movie_tmp/$random_name.$file_type");
	echo"<span style='color:green;'>Post uploaded, Thanks</span>";
	?>
	<input id="active_video" value="<?php echo $random_name.'.'.$file_type;?>" />
	<?php
	}else{echo"Image Not Uploaded, Something Went Wrong.";}
	}
}
}


/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
if($status =='disp_tmp_movie')
{
	$my_id = $_GET['my_id'];
	$get_vid ="select * from movie_tmptb where my_id='$my_id' ";
$run_get_vid = mysqli_query($con,$get_vid);
while($row_get_vid = mysqli_fetch_array($run_get_vid))
{	$eid_video_url = $row_get_vid['video_url'];
	?>
	<input id="active_video" value="<?php echo $eid_video_url;?>" />
	<?php
}
}
//////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
if($status =="save_movie_view")
{
   $my_id = $_GET['my_id'];
   $live_videoid = $_GET['live_videoid'];
   
   $get_vid_view ="select * from movie_viewtb where movie_id='$live_videoid' AND ipuser='$user_ip'  ";
   $run_vid_view  = mysqli_query($con,$get_vid_view);
   $check_vid_view = mysqli_num_rows($run_vid_view);
   if($check_vid_view >0){}else{
   
   $insert_mv = "insert into movie_viewtb (my_id,movie_id,ipuser,cur_country,cur_city,cur_date,cur_time)
   values('$my_id','$live_videoid','$user_ip','$country','$city',CURDATE(),CURTIME() )";
   $run_insert_mv = mysqli_query($con,$insert_mv);
   }
}

///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////

if($status =="disp_movie_view")
{
   $live_videoid = $_GET['live_videoid'];
   
   $get_vid_view ="select * from movie_viewtb where movie_id='$live_videoid'  ";
   $run_vid_view  = mysqli_query($con,$get_vid_view);
   $check_vid_view = mysqli_num_rows($run_vid_view);
   if($check_vid_view <1){}else{echo $check_vid_view; }
}


/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////

if($status =="save_comment")
{
   $my_id = $_GET['my_id'];
   $live_videoid = $_GET['live_videoid'];
   $nw_comment = $_GET['nw_comment'];
   
   $insert_mv_com = "insert into movie_comtb (my_id,movieid,mv_comment,cur_country,cur_city,cur_date,cur_time)
   values('$my_id','$live_videoid','$nw_comment','$country','$city',CURDATE(),CURTIME() )";
   $run_insert_mv = mysqli_query($con,$insert_mv_com);
}

////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
if($status =="disp_mv_comm")
{
   $live_videoid = $_GET['live_videoid'];
   
   $get_vid_com ="select * from movie_comtb where movieid='$live_videoid' order by id desc  ";
   $run_vid_com = mysqli_query($con,$get_vid_com);
   $check_vid_com = mysqli_num_rows($run_vid_com);
   //if($check_vid_view <1){}else{echo $check_vid_view; }
   while($row_vid_com = mysqli_fetch_array($run_vid_com))
   {
	$user_id = $row_vid_com['my_id'];
	$mv_comment = $row_vid_com['mv_comment'];
		?>
	<div class="single_com_div" >
	<?php
	
	 $con = mysqli_connect('localhost','root','2019khalaf','cranebule_userdb');
 if(! $con){echo"You have not connected to the database.";}
 else{
	  $get_user = "select * from cb_userstb where id='$user_id' ";
	
	$run_get_user = mysqli_query($con,$get_user);
		
    while($row_get_user = mysqli_fetch_array($run_get_user))
	{
		$user_name = $row_get_user['lname'];
		$user_profile = $row_get_user['profile_image'];

?>

    <img src="../userprofile/avatar2.jpg" class="user_img_com" />
	<span class="com_user_name" ><?php echo $user_name; ?></span>
	<?php
		//echo"<script>window.open('index','_self')</script>";		
	}
	}
	

	
	
	
	?>
	<!--div class="single_com_div" -k->
    <img src="main_icon/crane log.png" class="user_img_com" /-k->
    <span class="com_user_name" >Abby</span-->
    <span class="com_detail" ><?php echo $mv_comment; ?></span>
    </div>
	
	<?php
   }

}

/////////////////////////////////////////////////////////////////////////////////////////////////////////////
if($status =="disp_mv_comm_count")
{
   $live_videoid = $_GET['live_videoid'];
   
   $get_vid_com_count ="select * from movie_comtb where movieid='$live_videoid'  ";
   $run_vid_com_count = mysqli_query($con,$get_vid_com_count);
   $check_vid_com_count = mysqli_num_rows($run_vid_com_count);
   if($check_vid_com_count <1){}else{echo $check_vid_com_count; }

}
///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////

if($status =="add_vid_name")
{
   $my_id = $_GET['my_id'];
   $videoname = $_GET['videoname'];
   
   $update_vid_name = "update movie_tmptb set video_name='$videoname' where my_id='$my_id' ";
   $run_insert_mv = mysqli_query($con,$update_vid_name);
 
}

/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
if($status =="disp_movie_name")
{
   $my_id = $_GET['my_id'];
  // $active_vid = $_GET['active_vid'];
   
   $get_vid_name ="select * from movie_tmptb where my_id='$my_id' ";
   $run_get_vid_name = mysqli_query($con,$get_vid_name);
while($row_get_vid_name = mysqli_fetch_array($run_get_vid_name)){	
  $video_name = $row_get_vid_name['video_name'];
  if($video_name==""){ ?>
	  
	
  <button id="add_vidname_btn" onClick="show_video_input_span();" class="add_vid_name_btn" >Add Name</button>
 
  
 <?php }else{ ?>
 <span  id="vidname_dip_span"  >
  <span  class="vid_name" ><?php echo $video_name; ?></span>
  <button id="preview_play" onClick="show_vid_name_eidt();" class="add_vid_name_btn" >Edit</button>
  </span>
  
  <span  id="vid_name_eidtspan" style="display:none;" >
  
  	<input id="videoname_edit" class="add_namenow_input" value="<?php echo $video_name; ?>" />
	<button id="preview_play" onClick="edit_vid_name();" class="add_namenow_btn" >OK</button>
  
  </span>
 <?php }
 
}
}

////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
if($status =="edit_vid_name")
{
   $my_id = $_GET['my_id'];
   $videoname_edit = $_GET['videoname_edit'];
   
   $edit_vid_name = "update movie_tmptb set video_name='$videoname_edit' where my_id='$my_id' ";
   $run_edit_mv = mysqli_query($con,$edit_vid_name);
 
}



///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////

if($status =="save_live_movie")
{
   $my_id = $_GET['my_id'];
   $active_vid = $_GET['active_vid'];
   
   $get_vid ="select * from movie_tmptb where my_id='$my_id' AND video_url='$active_vid' ";
   $run_get_vid = mysqli_query($con,$get_vid);
   $check_get_vid = mysqli_num_rows($run_get_vid);
   while($row_get_vid_name = mysqli_fetch_array($run_get_vid)){	
   $video_name = $row_get_vid_name['video_name'];
   
   $get_livevid ="select * from livemovietb where my_id='$my_id' ";
   $run_get_livevid = mysqli_query($con,$get_livevid);
   $check_get_livevid = mysqli_num_rows($run_get_livevid);
  
   
   if($check_get_livevid >0){
	   
   $update_livevid = "update livemovietb set video_url='$active_vid', video_name='$video_name', cur_country='$country', cur_city='$city' ,cur_date=CURDATE(), cur_time=CURTIME() where my_id='$my_id' ";
   $run_update_livevid = mysqli_query($con,$update_livevid); 
   
   copy("movie_tmp/$active_vid", "movie/$active_vid");   
	   
   }else{
   
   $save_mv = "insert into livemovietb (my_id,video_url,video_name,cur_country,cur_city,cur_date,cur_time)
   values('$my_id','$active_vid','$video_name','$country','$city',CURDATE(),CURTIME())";
   $run_insert_mv = mysqli_query($con,$save_mv);
   }
}
}

//////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
if($status =='disp_livemovie')
{
	$my_id = $_GET['my_id'];
	$get_vid ="select * from livemovietb where my_id='$my_id' ";
    $run_get_vid = mysqli_query($con,$get_vid);
    while($row_get_vid = mysqli_fetch_array($run_get_vid)){
	$live_video_url = $row_get_vid['video_url'];
	$live_video_name = $row_get_vid['video_name'];
	echo $live_video_name;
	?>
	<input id="live_video" value="<?php echo $live_video_url;?>" style="display:none;"	/>
	<?php
}
}

//////////////////////////////////////////Below playing cinema mv//////////////////////////////////////////////////////////////////

if($status =='disp_cinema_mv')
{
	$my_id = $_GET['my_id'];
	$get_vid ="select * from livemovietb";// where my_id='$my_id' ";
    $run_get_vid = mysqli_query($con,$get_vid);
    while($row_get_vid = mysqli_fetch_array($run_get_vid)){
	$live_videoid = $row_get_vid['id'];
	$live_video_url = $row_get_vid['video_url'];
	$live_video_name = $row_get_vid['video_name'];
	
	?>
	
	<div id="main_player" class="main_player" >
    <video id="cur_vid" onClick="show_movie_name();" class="sub_play" >
    <source src="movie/<?php echo $live_video_url; ?>" type="video/mp4">
    <source src="movie/<?php echo $live_video_url; ?>" type="video/ogg">
   Your browser does not support the video tag.
    </video>
   <!--img src="movie_thumb/mima.jfif" class="sub_play" /-->
</div>


<div id="movie_title" class="movie_title" >
<span id="mov_name" class="mov_name" ><?php echo $live_video_name; ?></span>

<span id="dur_time" class="mov_dur" >0:00</span>
<span id="cur_time" class="mov_dur" >0:00 /</span>

</div>
	
	
	
	<input id="live_videoid" value="<?php echo $live_videoid;?>" style="display:none;"	/>
	<?php
}
}

////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////

if($status =="like_mv_now")
{
   $my_id = $_GET['my_id'];
   $live_videoid = $_GET['live_videoid'];
   
   $get_vid_like ="select * from movie_liketb where movieid='$live_videoid' AND ipuser='$user_ip'  ";
   $run_vid_like  = mysqli_query($con,$get_vid_like);
   $check_vid_like = mysqli_num_rows($run_vid_like);
   if($check_vid_like >0){}else{
   
   $insert_mv = "insert into movie_liketb (my_id,movieid,ipuser,cur_country,cur_city,cur_date,cur_time)
   values('$my_id','$live_videoid','$user_ip','$country','$city',CURDATE(),CURTIME() )";
   $run_insert_mv = mysqli_query($con,$insert_mv);
   }
}

////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
if($status =="disp_movie_like")
{
   $live_videoid = $_GET['live_videoid'];
   
   $get_vidlike ="select * from movie_liketb where movieid='$live_videoid'  ";
   $run_vidlike = mysqli_query($con,$get_vidlike);
   $check_vidlike = mysqli_num_rows($run_vidlike);
   if($check_vidlike <1){}else{echo $check_vidlike; }
}


////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
if($status =="take_sit_save")
{
   $my_id = $_GET['my_id'];
   $sit_no = $_GET['sit_no'];
   $cur_movieid = $_GET['live_videoid'];
 
   
   
   $get_sit ="select * from cinema_sittb where sit_no='$sit_no' ";
   $run_sit  = mysqli_query($con,$get_sit);
   $check_sit = mysqli_num_rows($run_sit);
   if($check_sit <1){

   $get_sit_spt2 ="select * from cinema_sittb where movieid='$cur_movieid' AND ipuser='$user_ip' ";
   $run_sit_spt2  = mysqli_query($con,$get_sit_spt2);
   $check_sit_spt2 = mysqli_num_rows($run_sit_spt2);
   if($check_sit_spt2 <1){

   $insert_sit_no = "insert into cinema_sittb (my_id,sit_no,movieid,ipuser,cur_country,cur_city,cur_date,cur_time)
   values('$my_id','$sit_no','$cur_movieid','$user_ip','$country','$city',CURDATE(),CURTIME() )";
   $run_insert_sit_no = mysqli_query($con,$insert_sit_no);
   
   }else{
	   $update_sit ="update cinema_sittb set sit_no='$sit_no' where movieid='$cur_movieid' AND ipuser='$user_ip' ";
	   $run_update_sit = mysqli_query($con,$update_sit);
   }



   $tip_me ="sitempty";
   
   }else{
   $tip_me ="sit_busy";
   }
   
   
   
   
     ?> 
   <input id="tip_me" value="<?php echo $tip_me; ?>" style="display:none;" />

<?php }

////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
if($status =="disp_siters")
{
   $my_id = $_GET['my_id'];
   $live_videoid = $_GET['live_videoid'];
   

  $get_siter ="select * from cinema_sittb where sit_no='1' AND movieid='$live_videoid' ";
   $run_get_siter  = mysqli_query($con,$get_siter);
   $check_get_siter = mysqli_num_rows($run_get_siter);
      if($check_get_siter >0 ){
   while($row_get_siter = mysqli_fetch_array($run_get_siter)){
      
	  $siter_name = $row_get_siter['my_id'];
	  $sitip = $row_get_siter['ipuser'];
	  $sit_no = $row_get_siter['sit_no'];

	?>
<div class="single_sponser" >
<?php
	  	 $con = mysqli_connect('localhost','root','2019khalaf','cranebule_userdb');
 if(! $con){echo"You have not connected to the database.";}
 else{
	  $get_user = "select * from cb_userstb where id='$siter_name' ";
	  $run_get_user = mysqli_query($con,$get_user);
	  $check_user = mysqli_num_rows($run_get_user);
	  
	  if($check_user >0){
		
    while($row_get_user = mysqli_fetch_array($run_get_user))
	{
		$user_name = $row_get_user['lname'];
		$user_profile = $row_get_user['profile_image'];

?>

<?php 
//if($siter_name =='Guest'){ 
 ?>

 <?php if($sitip == $user_ip){ ?> 
 <img onClick="take_sit(1);" src="../userprofile/<?php echo $user_profile; ?>" class="user_img" style="width:65px;height:65px;border:2px solid red;" />
 
 <?php }else{ ?> 
 <img onClick="take_sit(1);" src="../userprofile/<?php echo $user_profile; ?>" class="user_img" />
 
 <?php } ?>
 
<span class="user_name" ><?php echo"$user_name"; ?></span>
 
 
 <?php  }  }else{ ?>

 <?php if($sitip == $user_ip){ ?> 
<img onClick="take_sit(1);" src="../userprofile/avatar2.jpg" class="user_img" style="width:65px;height:65px;border:2px solid red;" />
 <?php }else{ ?> 
 <img onClick="take_sit(1);" src="../userprofile/avatar2.jpg" class="user_img" />
  <?php } ?>
  
<span class="user_name" ><?php echo"$siter_name $sit_no"; ?></span>

	  <?php }  } ?>

</div>
   <?php } }else{ ?>
  <div class="single_sponser" >
<!--img src="movie_thumb/mima.jfif" class="user_img" /-->
<span onClick="take_sit(1);" class="user_sit_span">Sit 1</span>
<span class="user_name" >Take sit</span>
</div>
   <?php   } ?>



<?php 
include('db.php'); 
  $get_siter ="select * from cinema_sittb where sit_no='2' AND movieid='$live_videoid' ";
   $run_get_siter  = mysqli_query($con,$get_siter);
   $check_get_siter = mysqli_num_rows($run_get_siter);
      if($check_get_siter >0 ){
   while($row_get_siter = mysqli_fetch_array($run_get_siter)){
      
	  $siter_name = $row_get_siter['my_id'];
	  $sitip = $row_get_siter['ipuser'];
	  $sit_no = $row_get_siter['sit_no'];

	?>
<div class="single_sponser" >
<?php
	$con = mysqli_connect('localhost','root','2019khalaf','cranebule_userdb');
 if(! $con){echo"You have not connected to the database.";}
 else{
	  $get_user = "select * from cb_userstb where id='$siter_name' ";
	  $run_get_user = mysqli_query($con,$get_user);
	  $check_user = mysqli_num_rows($run_get_user);
	  
	  if($check_user >0){
		
    while($row_get_user = mysqli_fetch_array($run_get_user))
	{
		$user_name = $row_get_user['lname'];
		$user_profile = $row_get_user['profile_image'];

?>

<?php 
//if($siter_name =='Guest'){
 ?>

 <?php if($sitip == $user_ip){ ?> 
 <img onClick="take_sit(2);" src="../userprofile/<?php echo $user_profile; ?>" class="user_img" style="width:65px;height:65px;border:2px solid red;" />
 
 <?php }else{ ?> 
 <img onClick="take_sit(2);" src="../userprofile/<?php echo $user_profile; ?>" class="user_img" />
 
 <?php } ?>
 
<span class="user_name" ><?php echo"$user_name"; ?></span>
 
 
 <?php  }  }else{ ?>

 <?php if($sitip == $user_ip){ ?> 
<img onClick="take_sit(2);" src="../userprofile/avatar2.jpg" class="user_img" style="width:65px;height:65px;border:2px solid red;" />
 <?php }else{ ?> 
 <img onClick="take_sit(2);" src="../userprofile/avatar2.jpg" class="user_img" />
  <?php } ?>
  
<span class="user_name" ><?php echo"$siter_name $sit_no"; ?></span>

	  <?php }  } ?>

</div>
   <?php } }else{ ?>
  <div class="single_sponser" >
<!--img src="movie_thumb/mima.jfif" class="user_img" /-->
<span onClick="take_sit(2);" class="user_sit_span">Sit 2</span>
<span class="user_name" >Take sit</span>
</div>
   <?php   } ?>

   
   

<?php 
include('db.php'); 
   $get_siter ="select * from cinema_sittb where sit_no='3' AND movieid='$live_videoid' ";
   $run_get_siter  = mysqli_query($con,$get_siter);
   $check_get_siter = mysqli_num_rows($run_get_siter);
      if($check_get_siter >0 ){
   while($row_get_siter = mysqli_fetch_array($run_get_siter)){
      
	  $siter_name = $row_get_siter['my_id'];
	  $sitip = $row_get_siter['ipuser'];
	  $sit_no = $row_get_siter['sit_no'];

	?>
<div class="single_sponser" >
<?php
	  	 $con = mysqli_connect('localhost','root','2019khalaf','cranebule_userdb');
 if(! $con){echo"You have not connected to the database.";}
 else{
	  $get_user = "select * from cb_userstb where id='$siter_name' ";
	  $run_get_user = mysqli_query($con,$get_user);
	  $check_user = mysqli_num_rows($run_get_user);
	  
	  if($check_user >0){
		
    while($row_get_user = mysqli_fetch_array($run_get_user))
	{
		$user_name = $row_get_user['lname'];
		$user_profile = $row_get_user['profile_image'];

?>

<?php 
//if($siter_name =='Guest'){
 ?>
 <?php if($sitip == $user_ip){ ?> 
 <img onClick="take_sit(3);" src="../userprofile/<?php echo $user_profile; ?>" class="user_img" style="width:65px;height:65px;border:2px solid red;" />
 
 <?php }else{ ?> 
 <img onClick="take_sit(3);" src="../userprofile/<?php echo $user_profile; ?>" class="user_img" />
 
 <?php } ?>
 
<span class="user_name" ><?php echo"$user_name"; ?></span>
 
 
 <?php  }  }else{ ?>

 <?php if($sitip == $user_ip){ ?> 
<img onClick="take_sit(3);" src="../userprofile/avatar2.jpg" class="user_img" style="width:65px;height:65px;border:2px solid red;" />
 <?php }else{ ?> 
 <img onClick="take_sit(3);" src="../userprofile/avatar2.jpg" class="user_img" />
  <?php } ?>
  
<span class="user_name" ><?php echo"$siter_name $sit_no"; ?></span>

	  <?php }  } ?>

</div>
   <?php } }else{ ?>
  <div class="single_sponser" >
<!--img src="movie_thumb/mima.jfif" class="user_img" /-->
<span onClick="take_sit(3);" class="user_sit_span">Sit 3</span>
<span class="user_name" >Take sit</span>
</div>
   <?php   } ?>

   
   <?php 
   include('db.php'); 
  $get_siter ="select * from cinema_sittb where sit_no='4' AND movieid='$live_videoid' ";
   $run_get_siter  = mysqli_query($con,$get_siter);
   $check_get_siter = mysqli_num_rows($run_get_siter);
      if($check_get_siter >0 ){
   while($row_get_siter = mysqli_fetch_array($run_get_siter)){
      
	  $siter_name = $row_get_siter['my_id'];
	  $sitip = $row_get_siter['ipuser'];
	  $sit_no = $row_get_siter['sit_no'];

	?>
<div class="single_sponser" >
<?php
	  	 $con = mysqli_connect('localhost','root','2019khalaf','cranebule_userdb');
 if(! $con){echo"You have not connected to the database.";}
 else{
	  $get_user = "select * from cb_userstb where id='$siter_name' ";
	  $run_get_user = mysqli_query($con,$get_user);
	  $check_user = mysqli_num_rows($run_get_user);
	  
	  if($check_user >0){
		
    while($row_get_user = mysqli_fetch_array($run_get_user))
	{
		$user_name = $row_get_user['lname'];
		$user_profile = $row_get_user['profile_image'];

?>

<?php 
//if($siter_name =='Guest'){
 ?>
 <?php if($sitip == $user_ip){ ?> 
 <img onClick="take_sit(4);" src="../userprofile/<?php echo $user_profile; ?>" class="user_img" style="width:65px;height:65px;border:2px solid red;" />
 
 <?php }else{ ?> 
 <img onClick="take_sit(4);" src="../userprofile/<?php echo $user_profile; ?>" class="user_img" />
 
 <?php } ?>
 
<span class="user_name" ><?php echo"$user_name"; ?></span>
 
 
 <?php  }  }else{ ?>

 <?php if($sitip == $user_ip){ ?> 
<img onClick="take_sit(4);" src="../userprofile/avatar2.jpg" class="user_img" style="width:65px;height:65px;border:2px solid red;" />
 <?php }else{ ?> 
 <img onClick="take_sit(4);" src="../userprofile/avatar2.jpg" class="user_img" />
  <?php } ?>
  
<span class="user_name" ><?php echo"$siter_name $sit_no"; ?></span>

	  <?php }  } ?>

</div>
   <?php } }else{ ?>
  <div class="single_sponser" >
<!--img src="movie_thumb/mima.jfif" class="user_img" /-->
<span onClick="take_sit(4);" class="user_sit_span">Sit 4</span>
<span class="user_name" >Take sit</span>
</div>
   <?php   } ?>

   
<?php 
include('db.php'); 
  $get_siter ="select * from cinema_sittb where sit_no='5' AND movieid='$live_videoid' ";
   $run_get_siter  = mysqli_query($con,$get_siter);
   $check_get_siter = mysqli_num_rows($run_get_siter);
      if($check_get_siter >0 ){
   while($row_get_siter = mysqli_fetch_array($run_get_siter)){
      
	  $siter_name = $row_get_siter['my_id'];
	  $sitip = $row_get_siter['ipuser'];
	  $sit_no = $row_get_siter['sit_no'];

	?>
<div class="single_sponser" >
<?php
	  	 $con = mysqli_connect('localhost','root','2019khalaf','cranebule_userdb');
 if(! $con){echo"You have not connected to the database.";}
 else{
	  $get_user = "select * from cb_userstb where id='$siter_name' ";
	  $run_get_user = mysqli_query($con,$get_user);
	  $check_user = mysqli_num_rows($run_get_user);
	  
	  if($check_user >0){
		
    while($row_get_user = mysqli_fetch_array($run_get_user))
	{
		$user_name = $row_get_user['lname'];
		$user_profile = $row_get_user['profile_image'];

?>

<?php 
//if($siter_name =='Guest'){
 ?>
 <?php if($sitip == $user_ip){ ?> 
 <img onClick="take_sit(5);" src="../userprofile/<?php echo $user_profile; ?>" class="user_img" style="width:65px;height:65px;border:2px solid red;" />
 
 <?php }else{ ?> 
 <img onClick="take_sit(5);" src="../userprofile/<?php echo $user_profile; ?>" class="user_img" />
 
 <?php } ?>
 
<span class="user_name" ><?php echo"$user_name"; ?></span>
 
 
 <?php  }  }else{ ?>

 <?php if($sitip == $user_ip){ ?> 
<img onClick="take_sit(5);" src="../userprofile/avatar2.jpg" class="user_img" style="width:65px;height:65px;border:2px solid red;" />
 <?php }else{ ?> 
 <img onClick="take_sit(5);" src="../userprofile/avatar2.jpg" class="user_img" />
  <?php } ?>
  
<span class="user_name" ><?php echo"$siter_name $sit_no"; ?></span>

	  <?php }  } ?>

</div>
   <?php } }else{ ?>
  <div class="single_sponser" >
<!--img src="movie_thumb/mima.jfif" class="user_img" /-->
<span onClick="take_sit(5);" class="user_sit_span">Sit 5</span>
<span class="user_name" >Take sit</span>
</div>
   <?php   } ?>
 
   
<?php 
include('db.php'); 
  $get_siter ="select * from cinema_sittb where sit_no='6' AND movieid='$live_videoid' ";
   $run_get_siter  = mysqli_query($con,$get_siter);
   $check_get_siter = mysqli_num_rows($run_get_siter);
      if($check_get_siter >0 ){
   while($row_get_siter = mysqli_fetch_array($run_get_siter)){
      
	  $siter_name = $row_get_siter['my_id'];
	  $sitip = $row_get_siter['ipuser'];
	  $sit_no = $row_get_siter['sit_no'];

	?>
<div class="single_sponser" >
<?php
	  	 $con = mysqli_connect('localhost','root','2019khalaf','cranebule_userdb');
 if(! $con){echo"You have not connected to the database.";}
 else{
	  $get_user = "select * from cb_userstb where id='$siter_name' ";
	  $run_get_user = mysqli_query($con,$get_user);
	  $check_user = mysqli_num_rows($run_get_user);
	  
	  if($check_user >0){
		
    while($row_get_user = mysqli_fetch_array($run_get_user))
	{
		$user_name = $row_get_user['lname'];
		$user_profile = $row_get_user['profile_image'];

?>

<?php 
//if($siter_name =='Guest'){
 ?>
 <?php if($sitip == $user_ip){ ?> 
 <img onClick="take_sit(6);" src="../ /<?php echo $user_profile; ?>" class="user_img" style="width:65px;height:65px;border:2px solid red;" />
 
 <?php }else{ ?> 
 <img onClick="take_sit(6);" src="../userprofile/<?php echo $user_profile; ?>" class="user_img" />
 
 <?php } ?>
 
<span class="user_name" ><?php echo"$user_name"; ?></span>
 
 
 <?php  }  }else{ ?>

 <?php if($sitip == $user_ip){ ?> 
<img onClick="take_sit(6 );" src="../userprofile/avatar2.jpg" class="user_img" style="width:65px;height:65px;border:2px solid red;" />
 <?php }else{ ?> 
 <img onClick="take_sit(6);" src="../userprofile/avatar2.jpg" class="user_img" />
  <?php } ?>
  
<span class="user_name" ><?php echo"$siter_name $sit_no"; ?></span>

	  <?php }  } ?>

</div>
   <?php } }else{ ?>
  <div class="single_sponser" >
<!--img src="movie_thumb/mima.jfif" class="user_img" /-->
<span onClick="take_sit(6);" class="user_sit_span">Sit 6</span>
<span class="user_name" >Take sit</span>
</div>
   <?php   } ?>
    


<?php 
include('db.php'); 
  $get_siter ="select * from cinema_sittb where sit_no='7' AND movieid='$live_videoid' ";
   $run_get_siter  = mysqli_query($con,$get_siter);
   $check_get_siter = mysqli_num_rows($run_get_siter);
      if($check_get_siter >0 ){
   while($row_get_siter = mysqli_fetch_array($run_get_siter)){
      
	  $siter_name = $row_get_siter['my_id'];
	  $sitip = $row_get_siter['ipuser'];
	  $sit_no = $row_get_siter['sit_no'];

	?>
<div class="single_sponser" >
<?php
	  	 $con = mysqli_connect('localhost','root','2019khalaf','cranebule_userdb');
 if(! $con){echo"You have not connected to the database.";}
 else{
	  $get_user = "select * from cb_userstb where id='$siter_name' ";
	  $run_get_user = mysqli_query($con,$get_user);
	  $check_user = mysqli_num_rows($run_get_user);
	  
	  if($check_user >0){
		
    while($row_get_user = mysqli_fetch_array($run_get_user))
	{
		$user_name = $row_get_user['lname'];
		$user_profile = $row_get_user['profile_image'];

?>

<?php 
//if($siter_name =='Guest'){
 ?>
 <?php if($sitip == $user_ip){ ?> 
 <img onClick="take_sit(7);" src="../userprofile/<?php echo $user_profile; ?>" class="user_img" style="width:65px;height:65px;border:2px solid red;" />
 
 <?php }else{ ?> 
 <img onClick="take_sit(7);" src="../userprofile/<?php echo $user_profile; ?>" class="user_img" />
 
 <?php } ?>
 
<span class="user_name" ><?php echo"$user_name"; ?></span>
 
 
 <?php  }  }else{ ?>

 <?php if($sitip == $user_ip){ ?> 
<img onClick="take_sit(7);" src="../userprofile/avatar2.jpg" class="user_img" style="width:65px;height:65px;border:2px solid red;" />
 <?php }else{ ?> 
 <img onClick="take_sit(7);" src="../userprofile/avatar2.jpg" class="user_img" />
  <?php } ?>
  
<span class="user_name" ><?php echo"$siter_name $sit_no"; ?></span>

	  <?php }  } ?>

</div>
   <?php } }else{ ?>
  <div class="single_sponser" >
<!--img src="movie_thumb/mima.jfif" class="user_img" /-->
<span onClick="take_sit(7);" class="user_sit_span">Sit 7</span>
<span class="user_name" >Take sit</span>
</div>
   <?php   } ?>



<?php 
include('db.php'); 
  $get_siter ="select * from cinema_sittb where sit_no='8' AND movieid='$live_videoid' ";
   $run_get_siter  = mysqli_query($con,$get_siter);
   $check_get_siter = mysqli_num_rows($run_get_siter);
      if($check_get_siter >0 ){
   while($row_get_siter = mysqli_fetch_array($run_get_siter)){
      
	  $siter_name = $row_get_siter['my_id'];
	  $sitip = $row_get_siter['ipuser'];
	  $sit_no = $row_get_siter['sit_no'];

	?>
<div class="single_sponser" >
<?php
	  	 $con = mysqli_connect('localhost','root','2019khalaf','cranebule_userdb');
 if(! $con){echo"You have not connected to the database.";}
 else{
	  $get_user = "select * from cb_userstb where id='$siter_name' ";
	  $run_get_user = mysqli_query($con,$get_user);
	  $check_user = mysqli_num_rows($run_get_user);
	  
	  if($check_user >0){
		
    while($row_get_user = mysqli_fetch_array($run_get_user))
	{
		$user_name = $row_get_user['lname'];
		$user_profile = $row_get_user['profile_image'];

?>

<?php 
//if($siter_name =='Guest'){
 ?>
 <?php if($sitip == $user_ip){ ?> 
 <img onClick="take_sit(8);" src="../userprofile/<?php echo $user_profile; ?>" class="user_img" style="width:65px;height:65px;border:2px solid red;" />
 
 <?php }else{ ?> 
 <img onClick="take_sit(8);" src="../userprofile/<?php echo $user_profile; ?>" class="user_img" />
 
 <?php } ?>
 
<span class="user_name" ><?php echo"$user_name"; ?></span>
 
 
 <?php  }  }else{ ?>

 <?php if($sitip == $user_ip){ ?> 
<img onClick="take_sit(8);" src="../userprofile/avatar2.jpg" class="user_img" style="width:65px;height:65px;border:2px solid red;" />
 <?php }else{ ?> 
 <img onClick="take_sit(8);" src="../userprofile/avatar2.jpg" class="user_img" />
  <?php } ?>
  
<span class="user_name" ><?php echo"$siter_name $sit_no"; ?></span>

	  <?php }  } ?>

</div>
   <?php } }else{ ?>
  <div class="single_sponser" >
<!--img src="movie_thumb/mima.jfif" class="user_img" /-->
<span onClick="take_sit(8);" class="user_sit_span">Sit 8</span>
<span class="user_name" >Take sit</span>
</div>
   <?php   } ?>



<?php 
include('db.php'); 
  $get_siter ="select * from cinema_sittb where sit_no='9' AND movieid='$live_videoid' ";
   $run_get_siter  = mysqli_query($con,$get_siter);
   $check_get_siter = mysqli_num_rows($run_get_siter);
      if($check_get_siter >0 ){
   while($row_get_siter = mysqli_fetch_array($run_get_siter)){
      
	  $siter_name = $row_get_siter['my_id'];
	  $sitip = $row_get_siter['ipuser'];
	  $sit_no = $row_get_siter['sit_no'];

	?>
<div class="single_sponser" >
<?php
	  	 $con = mysqli_connect('localhost','root','2019khalaf','cranebule_userdb');
 if(! $con){echo"You have not connected to the database.";}
 else{
	  $get_user = "select * from cb_userstb where id='$siter_name' ";
	  $run_get_user = mysqli_query($con,$get_user);
	  $check_user = mysqli_num_rows($run_get_user);
	  
	  if($check_user >0){
		
    while($row_get_user = mysqli_fetch_array($run_get_user))
	{
		$user_name = $row_get_user['lname'];
		$user_profile = $row_get_user['profile_image'];

?>

<?php 
//if($siter_name =='Guest'){
 ?>
 <?php if($sitip == $user_ip){ ?> 
 <img onClick="take_sit(9);" src="../userprofile/<?php echo $user_profile; ?>" class="user_img" style="width:65px;height:65px;border:2px solid red;" />
 
 <?php }else{ ?> 
 <img onClick="take_sit(9);" src="../userprofile/<?php echo $user_profile; ?>" class="user_img" />
 
 <?php } ?>
 
<span class="user_name" ><?php echo"$user_name"; ?></span>
 
 
 <?php  }  }else{ ?>

 <?php if($sitip == $user_ip){ ?> 
<img onClick="take_sit(9);" src="../userprofile/avatar2.jpg" class="user_img" style="width:65px;height:65px;border:2px solid red;" />
 <?php }else{ ?> 
 <img onClick="take_sit(9);" src="../userprofile/avatar2.jpg" class="user_img" />
  <?php } ?>
  
<span class="user_name" ><?php echo"$siter_name $sit_no"; ?></span>

	  <?php }  } ?>

</div>
   <?php } }else{ ?>
  <div class="single_sponser" >
<!--img src="movie_thumb/mima.jfif" class="user_img" /-->
<span onClick="take_sit(9);" class="user_sit_span">Sit 9</span>
<span class="user_name" >Take sit</span>
</div>
   <?php   } ?>



<?php
  include('db.php');  
  $get_siter ="select * from cinema_sittb where sit_no='10' AND movieid='$live_videoid'";
   $run_get_siter  = mysqli_query($con,$get_siter);
   $check_get_siter = mysqli_num_rows($run_get_siter);
      if($check_get_siter >0 ){
   while($row_get_siter = mysqli_fetch_array($run_get_siter)){
      
	  $siter_name = $row_get_siter['my_id'];
	  $sitip = $row_get_siter['ipuser'];
	  $sit_no = $row_get_siter['sit_no'];

	?>
<div class="single_sponser" >
<?php
	  	 $con = mysqli_connect('localhost','root','2019khalaf','cranebule_userdb');
 if(! $con){echo"You have not connected to the database.";}
 else{
	  $get_user = "select * from cb_userstb where id='$siter_name' ";
	  $run_get_user = mysqli_query($con,$get_user);
	  $check_user = mysqli_num_rows($run_get_user);
	  
	  if($check_user >0){
		
    while($row_get_user = mysqli_fetch_array($run_get_user))
	{
		$user_name = $row_get_user['lname'];
		$user_profile = $row_get_user['profile_image'];

?>

<?php 
//if($siter_name =='Guest'){
 ?>
 <?php if($sitip == $user_ip){ ?> 
 <img onClick="take_sit(10);" src="../userprofile/<?php echo $user_profile; ?>" class="user_img" style="width:65px;height:65px;border:2px solid red;" />
 
 <?php }else{ ?> 
 <img onClick="take_sit(10);" src="../userprofile/<?php echo $user_profile; ?>" class="user_img" />
 
 <?php } ?>
 
<span class="user_name" ><?php echo"$user_name"; ?></span>
 
 
 <?php  }  }else{ ?>

 <?php if($sitip == $user_ip){ ?> 
<img onClick="take_sit(10);" src="../userprofile/avatar2.jpg" class="user_img" style="width:65px;height:65px;border:2px solid red;" />
 <?php }else{ ?> 
 <img onClick="take_sit(10);" src="../userprofile/avatar2.jpg" class="user_img" />
  <?php } ?>
  
<span class="user_name" ><?php echo"$siter_name $sit_no"; ?></span>

	  <?php }  } ?>

</div>
   <?php } }else{ ?>
  <div class="single_sponser" >
<!--img src="movie_thumb/mima.jfif" class="user_img" /-->
<span onClick="take_sit(10);" class="user_sit_span">Sit 10</span>
<span class="user_name" >Take sit</span>
</div>
   <?php   } ?>


<?php 
include('db.php'); 
  $get_siter ="select * from cinema_sittb where sit_no='11' AND movieid='$live_videoid' ";
   $run_get_siter  = mysqli_query($con,$get_siter);
   $check_get_siter = mysqli_num_rows($run_get_siter);
      if($check_get_siter >0 ){
   while($row_get_siter = mysqli_fetch_array($run_get_siter)){
      
	  $siter_name = $row_get_siter['my_id'];
	  $sitip = $row_get_siter['ipuser'];
	  $sit_no = $row_get_siter['sit_no'];

	?>
<div class="single_sponser" >
<?php
	  	 $con = mysqli_connect('localhost','root','2019khalaf','cranebule_userdb');
 if(! $con){echo"You have not connected to the database.";}
 else{
	  $get_user = "select * from cb_userstb where id='$siter_name' ";
	  $run_get_user = mysqli_query($con,$get_user);
	  $check_user = mysqli_num_rows($run_get_user);
	  
	  if($check_user >0){
		
    while($row_get_user = mysqli_fetch_array($run_get_user))
	{
		$user_name = $row_get_user['lname'];
		$user_profile = $row_get_user['profile_image'];

?>

<?php 
//if($siter_name =='Guest'){
 ?>
 <?php if($sitip == $user_ip){ ?> 
 <img onClick="take_sit(11);" src="../userprofile/<?php echo $user_profile; ?>" class="user_img" style="width:65px;height:65px;border:2px solid red;" />
 
 <?php }else{ ?> 
 <img onClick="take_sit(11);" src="../userprofile/<?php echo $user_profile; ?>" class="user_img" />
 
 <?php } ?>
 
<span class="user_name" ><?php echo"$user_name"; ?></span>
 
 
 <?php  }  }else{ ?>

 <?php if($sitip == $user_ip){ ?> 
<img onClick="take_sit(11);" src="../userprofile/avatar2.jpg" class="user_img" style="width:65px;height:65px;border:2px solid red;" />
 <?php }else{ ?> 
 <img onClick="take_sit(11);" src="../userprofile/avatar2.jpg" class="user_img" />
  <?php } ?>
  
<span class="user_name" ><?php echo"$siter_name $sit_no"; ?></span>

	  <?php }  } ?>

</div>
   <?php } }else{ ?>
  <div class="single_sponser" >
<!--img src="movie_thumb/mima.jfif" class="user_img" /-->
<span onClick="take_sit(11);" class="user_sit_span">Sit 11</span>
<span class="user_name" >Take sit</span>
</div>
   <?php   } ?>


<?php 
include('db.php'); 
  $get_siter ="select * from cinema_sittb where sit_no='12' AND movieid='$live_videoid' ";
   $run_get_siter  = mysqli_query($con,$get_siter);
   $check_get_siter = mysqli_num_rows($run_get_siter);
      if($check_get_siter >0 ){
   while($row_get_siter = mysqli_fetch_array($run_get_siter)){
      
	  $siter_name = $row_get_siter['my_id'];
	  $sitip = $row_get_siter['ipuser'];
	  $sit_no = $row_get_siter['sit_no'];

	?>
<div class="single_sponser" >
<?php
	  	 $con = mysqli_connect('localhost','root','2019khalaf','cranebule_userdb');
 if(! $con){echo"You have not connected to the database.";}
 else{
	  $get_user = "select * from cb_userstb where id='$siter_name' ";
	  $run_get_user = mysqli_query($con,$get_user);
	  $check_user = mysqli_num_rows($run_get_user);
	  
	  if($check_user >0){
		
    while($row_get_user = mysqli_fetch_array($run_get_user))
	{
		$user_name = $row_get_user['lname'];
		$user_profile = $row_get_user['profile_image'];

?>

<?php 
//if($siter_name =='Guest'){
 ?>
 <?php if($sitip == $user_ip){ ?> 
 <img onClick="take_sit(12);" src="../userprofile/<?php echo $user_profile; ?>" class="user_img" style="width:65px;height:65px;border:2px solid red;" />
 
 <?php }else{ ?> 
 <img onClick="take_sit(12);" src="../userprofile/<?php echo $user_profile; ?>" class="user_img" />
 
 <?php } ?>
 
<span class="user_name" ><?php echo"$user_name"; ?></span>
 
 
 <?php  }  }else{ ?>

 <?php if($sitip == $user_ip){ ?> 
<img onClick="take_sit(12);" src="../userprofile/avatar2.jpg" class="user_img" style="width:65px;height:65px;border:2px solid red;" />
 <?php }else{ ?> 
 <img onClick="take_sit(12);" src="../userprofile/avatar2.jpg" class="user_img" />
  <?php } ?>
  
<span class="user_name" ><?php echo"$siter_name $sit_no"; ?></span>

	  <?php }  } ?>

</div>
   <?php } }else{ ?>
  <div class="single_sponser" >
<!--img src="movie_thumb/mima.jfif" class="user_img" /-->
<span onClick="take_sit(12);" class="user_sit_span">Sit 12</span>
<span class="user_name" >Take sit</span>
</div>
   <?php   } ?>
  
	  
	  <?php
   

   
}

//////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////






?>