<?php

include('db.php');
session_start();
$status = $_GET['status']; 





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

if($status =='insert_video_playing_next')
{
	
	$my_id = $_GET['my_id'];
	$playing_next_video = $_GET['playing_next_video'];
	
	$online_video ="select * from online_playing_videotb where my_id='$my_id' ";
    $run_online_video = mysqli_query($con,$online_video);
	$check_online_video = mysqli_num_rows($run_online_video);
	if($check_online_video <1){
	
	$insert_playing_video_url ="insert into online_playing_videotb(my_id,playing_video_url) values ('$my_id','$playing_next_video')";
	$run_playing_video_url = mysqli_query($con,$insert_playing_video_url);
}else{

	$update_playing_video_url = "update online_playing_videotb set playing_video_url='$playing_next_video' where my_id='$my_id' ";
	$run_update_playing_video_url = mysqli_query($con,$update_playing_video_url);
	

}
}

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


if($status =='insert_video_duration')
{
	$my_id = $_GET['my_id'];
	$current_duration = $_GET['current_duration'];
	
	$video_curr_duration ="select * from video_duration_updatetb where my_id='$my_id'";
    $run_video_curr_duration = mysqli_query($con,$video_curr_duration);
	$check_video_curr_duration = mysqli_num_rows($run_video_curr_duration);
	if($check_video_curr_duration <1){
	
	$insert_post ="insert into video_duration_updatetb(my_id,current_duration) values ('$my_id','$current_duration')";
	$run_insert_post = mysqli_query($con,$insert_post);
}else{

    $update_video_duration ="update video_duration_updatetb set current_duration='$current_duration' where my_id='$my_id' ";
	$run_update_video_duration = mysqli_query($con,$update_video_duration);
	
}
}


if($status =='reset_insert_video_duration')
{
	$my_id = $_GET['my_id'];
	$current_duration = 0;
	
	$video_curr_duration ="select * from video_duration_updatetb where my_id='$my_id'";
    $run_video_curr_duration = mysqli_query($con,$video_curr_duration);
	$check_video_curr_duration = mysqli_num_rows($run_video_curr_duration);
	if($check_video_curr_duration <1){
	
	$insert_post ="insert into video_duration_updatetb(my_id,current_duration) values ('$my_id','$current_duration')";
	$run_insert_post = mysqli_query($con,$insert_post);
}else{

    $update_video_duration ="update video_duration_updatetb set current_duration='$current_duration' where my_id='$my_id' ";
	$run_update_video_duration = mysqli_query($con,$update_video_duration);
	
}
}


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

if($status =='get_video_curr_duration')
{
	$get_user = "select * from programertb";
	$run_get_user = mysqli_query($con,$get_user);
	while($row_get_user = mysqli_fetch_array($run_get_user))	
{
	     $programer_id = $row_get_user['id'];	
	
	$video_curr_duration ="select * from video_duration_updatetb where my_id='$programer_id'";
    $run_video_curr_duration = mysqli_query($con,$video_curr_duration);
    while($row_video_curr_duration= mysqli_fetch_array($run_video_curr_duration))
{
	   $video_id = $row_video_curr_duration['id'];
	   $current_duration = $row_video_curr_duration['current_duration'];
	//if($current_duration <1){$current_duration=1;}
	
?>	
	<input type="text" id="video_active_duration" value="<?php echo"$current_duration"; ?>" style="display:none;" />

<?php 
}
}
}

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



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


if($status =='display_pending_video')
{
	$get_user = "select * from programertb";
	$run_get_user = mysqli_query($con,$get_user);
	while($row_get_user = mysqli_fetch_array($run_get_user))	
{	   
       $programer_id = $row_get_user['id'];	
		 
	$get_pend_video ="select * from playing_videotb where user_id='$programer_id'";
    $run_pend_video = mysqli_query($con,$get_pend_video);
    while($row_pend_video = mysqli_fetch_array($run_pend_video))
{
	  $video_id = $row_pend_video['id'];
	  $pending_video = $row_pend_video['video_url'];
//onmouseover="show_more_option_btn();"
?>
<input id="helping_pending_video_url" value="<?php echo"$pending_video"; ?>" style="display:none;" />
<video id="<?php echo"$pending_video"; ?>" onClick="preview_video_now(this.id);" class="single_video_div"  >

  <source src="playing_video/<?php echo"$pending_video"; ?>" type="video/mp4">
  <source src="playing_video/<?php echo"$pending_video";?>" type="video/ogg">

  Your browser does not support the video tag.
</video>
<button name="<?php echo"$video_id";?>" id="pending_video_option_btn<?php echo"$video_id";?>" onmouseover="show_more_option_btn(this.name);" onmouseout="hide_more_option_btn(this.name);" onClick="show_pending_video_option_div(this.name);" class="pending_video_option_btn" >...</button>



<?php
}
}
}

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


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

if($status =='get_video_curr_duration')
{
	$get_user = "select * from programertb";
	$run_get_user = mysqli_query($con,$get_user);
	while($row_get_user = mysqli_fetch_array($run_get_user))	
{
	     $programer_id = $row_get_user['id'];	
	
	$video_curr_duration ="select * from video_duration_updatetb where my_id='$programer_id'";
    $run_video_curr_duration = mysqli_query($con,$video_curr_duration);
    while($row_video_curr_duration= mysqli_fetch_array($run_video_curr_duration))
{
	   $video_id = $row_video_curr_duration['id'];
	   $current_duration = $row_video_curr_duration['current_duration'];
	//if($current_duration <1){$current_duration=1;}
	
?>	
	<input type="text" id="video_active_duration" value="<?php echo"$current_duration"; ?>" style="display:none;" />

<?php 
}
}
}

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

if($status =='display_active_video_url')
{
	
	$get_user = "select * from programertb";
	$run_get_user = mysqli_query($con,$get_user);
	while($row_get_user = mysqli_fetch_array($run_get_user))	
		{
	      $programer_id = $row_get_user['id'];
	
	$get_online_video ="select * from online_playing_videotb where my_id='$programer_id'";
    $run_online_video = mysqli_query($con,$get_online_video);
    while($row_online_video = mysqli_fetch_array($run_online_video))
{
	$video_id = $row_online_video['id'];
	$pending_video = $row_online_video['playing_video_url'];
	
?>	
	<input type="text" id="online_active_video" value="<?php echo"$pending_video"; ?>" style="display:none;" />

<!--video id="playing_online_viedo" width="640" height="480" controls autoplay >
  <source src="playing_video/<?php echo"$pending_video";?>" type="video/mp4">
  <source src="playing_video/<?php echo"$pending_video";?>" type="video/ogg">
 
  Your browser does not support the video tag.
  

</video-->

<?php
}
}

	$update_playing_monitoring_video_url ="update monitor_videotb set monitor_status='active_two' where my_id='1'";
	$run_playing_monitoring_video_url = mysqli_query($con,$update_playing_monitoring_video_url);


		
}

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



if($status =='main_tv_active_video_url')
{
	
	$get_user = "select * from programertb";
	$run_get_user = mysqli_query($con,$get_user);
	while($row_get_user = mysqli_fetch_array($run_get_user))	
		{
	      $programer_id = $row_get_user['id'];
	
	$get_online_video ="select * from online_playing_videotb where my_id='$programer_id'";
    $run_online_video = mysqli_query($con,$get_online_video);
    while($row_online_video = mysqli_fetch_array($run_online_video))
{
	$video_id = $row_online_video['id'];
	$pending_video = $row_online_video['playing_video_url'];
	
?>	
	<input type="text" id="online_active_video" value="<?php echo"$pending_video"; ?>" style="display:none;" />

<!--video id="playing_online_viedo" width="640" height="480" controls autoplay >
  <source src="playing_video/<?php echo"$pending_video";?>" type="video/mp4">
  <source src="playing_video/<?php echo"$pending_video";?>" type="video/ogg">
 
  Your browser does not support the video tag.
  
  

</video-->

<?php
}
}

		
}


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

if($status =='insert_tv_view')
{
		$my_id = $_GET['my_id'];
		$user_ip = $_GET['user_ip'];
		//$post_id = $_GET['post_id'];
		$user_city = $_GET['user_city'];
		$user_country = $_GET['user_country'];
		$cur_date = date("Y-m-d");
		
		$tv_view ="select * from tv_viewstb where user_ip='$user_ip' AND date='$cur_date' ";
        $run_check_tv_view = mysqli_query($con,$tv_view);
		$check_tv_view = mysqli_num_rows($run_check_tv_view);
		if($check_tv_view >0){}else{
		
	
	$insert_tv_view ="insert into tv_viewstb(user_id,user_ip,city,country,date,time) values ('$my_id','$user_ip','$user_city','$user_country',CURDATE(),CURTIME() )";
	$run_insert_tv_view = mysqli_query($con,$insert_tv_view);
}
}







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

if($status =='remove_pending_video')
{
	$my_id = $_GET['my_id'];
	$pending_video_id = $_GET['pend_video_id'];
	$get_pend_video ="select * from playing_videotb where user_id='$my_id' AND id='$pending_video_id'";
    $run_pend_video = mysqli_query($con,$get_pend_video);
    while($row_pend_video = mysqli_fetch_array($run_pend_video))
{
	//$my_id = $row_pend_video['user_id'];
	$video_id = $row_pend_video['id'];
	$pending_video = $row_pend_video['video_url'];

	
	$path_pending_video	="playing_video/$pending_video";

if (!unlink($path_pending_video)){ //echo ("Error deleting $path_pending_video");
  
}else{ 

     $remove_pend_video = "delete from playing_videotb where id='$pending_video_id' AND user_id='$my_id'";
	 $run_remove_pend_video = mysqli_query($con,$remove_pend_video);

//echo ("Deleted $path_pending_video");
 }
	
}
}


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
















?>