<?php 
include('db.php');
session_start();
$status = $_GET['status'];
//////////////////////////////////////////////////////////
$curr_day = date("d");
$curr_month = date("m");
$curr_year = date("Y");
$curr_hour = date("H");
///////////////////////////////////////////////////////////////    
?>
<span 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
*/

if(isset($_SESSION['my_id']))
{
$userId = $_SESSION['my_id'];		
}

?> 
</span>
<?php
////////////////////////////////////////////////////////////////////

 if($status =="disp_featured_video")
{
	  $get_video ="select * from cb_videotb where cb_action='Featured' ";
  $run_get_video = mysqli_query($con,$get_video);
  while($row_get_video = mysqli_fetch_array($run_get_video))
  {
	$video_id = $row_get_video['id'];
	$studioId = $row_get_video['studioId'];
    $video_name = $row_get_video['video_name'];
    $video_url = $row_get_video['video_url'];	
    $thumb_url = $row_get_video['thumb_url'];

  $get_vidView_count ="select * from clip_videoviewtb where videoId='$video_id'"; 
  $run_get_vidView_count = mysqli_query($con,$get_vidView_count);
  $check_get_vidView_count = mysqli_num_rows($run_get_vidView_count);
  if($check_get_vidView_count <1){$count_vidView ="Views";}elseif($check_get_vidView_count==1){$count_vidView ="$check_get_vidView_count View";}else{ $count_vidView ="$check_get_vidView_count Views";}
?>

 <img src="CB_vid_thumb/<?php echo $thumb_url; ?>" alt="Featured Video" class="sl-hero-thumbnail" />
             <div class="sl-hero-overlay">
                 <span class="sl-hero-title"><?php echo"$video_name "; ?></span>
				 <a href="clip_player?vidid=<?php echo $video_id; ?>&vidname=<?php echo"$video_name "; ?>&vidurl=<?php echo $video_url; ?>&vidalbid=<?php echo $studioId; ?>&vidthumb=<?php echo $thumb_url; ?>&count_vidView=<?php echo $count_vidView; ?>" classk="single_trend_div" >
 
                 <button class="sl-hero-play-btn sl-cta-btn">Watch Now</button></a>
             </div>

<?php		
  }	
}

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

 if($status =="disp_video_list")
{
	?> 
	
<div id="card_div" class="card_div" >
<?php

$user_faith = $_GET['faith'];
if($user_faith=='all'){
 $get_video ="select * from cb_videotb order by id desc ";	
}else{
 $get_video ="select * from cb_videotb where faith_id='$user_faith' order by id desc ";	
}
 
  $run_get_video = mysqli_query($con,$get_video);
  $check_video = mysqli_num_rows($run_get_video);
  if($check_video <1){echo"currently no content for the selected feature";}else{
  while($row_get_video = mysqli_fetch_array($run_get_video))
  {
	$video_id = $row_get_video['id'];
	$studioId = $row_get_video['studioId'];
    $video_name = $row_get_video['video_name'];
    $video_url = $row_get_video['video_url'];	
    $thumb_url = $row_get_video['thumb_url'];
	$studioId = $row_get_video['studioId'];
	
$getComment_count ="select * from clip_commenttb where videoId='$video_id' ";
$run_getComment_count = mysqli_query($con,$getComment_count);
$check_comm_count = mysqli_num_rows($run_getComment_count);
	
	
  $get_vidView_count ="select * from clip_videoviewtb where videoId='$video_id'"; 
  $run_get_vidView_count = mysqli_query($con,$get_vidView_count);
  $check_get_vidView_count = mysqli_num_rows($run_get_vidView_count);
  if($check_get_vidView_count <1){$count_vidView ="Views";}elseif($check_get_vidView_count==1){$count_vidView ="$check_get_vidView_count View";}else{ $count_vidView ="$check_get_vidView_count Views";}
	
	?> 	
<a href="clip_player?vidid=<?php echo $video_id; ?>&vidname=<?php echo"$video_name "; ?>&vidurl=<?php echo $video_url; ?>&vidalbid=<?php echo $studioId; ?>&vidthumb=<?php echo $thumb_url; ?>&count_vidView=<?php echo $count_vidView; ?>" class="single_trend_div" >
<div class="trend_img_div" ><img src="CB_vid_thumb/<?php echo $thumb_url; ?>" alt="<?php echo"$video_name"; ?>" class="trend_img"/></div>
<span class="play_icon_span" ><img src="main_icon/play_ro.png" class="play_icon"/></span>
<div class="single_view_div" ><span class="view_output" ><?php echo"$count_vidView"; ?></span>  <img src="main_icon/comt.png" class="com_icon"/><span class="comt_output" ><?php if($check_comm_count <1){}else{ echo $check_comm_count;} ?></span> </div>

<span class="trend_song_title"><?php echo $video_name;?></span> 
<!--span class="trend_song_artis">
toop
</span--> 



</a>
	
<?php	} } ?>

</div>

<?php

}

//////////////////////////////////////////////////////////////////// 
 if($status =="disp_trending_video")
{ ?>
<div class="trending_div" >
<?php
	  $get_video ="select * from cb_videotb where cb_action='Trending' order by id desc ";
  $run_get_video = mysqli_query($con,$get_video);
  while($row_get_video = mysqli_fetch_array($run_get_video))
  {
	$video_id = $row_get_video['id'];
	$studioId = $row_get_video['studioId'];
	$faithId = $row_get_video['faith_id'];
    $video_name = $row_get_video['video_name'];
    $video_url = $row_get_video['video_url'];	
    $thumb_url = $row_get_video['thumb_url'];
	
	 $get_video_faith ="select * from cb_faithtb where id ='$faithId'";
  $run_get_video_faith = mysqli_query($con,$get_video_faith);
  while($row_get_video_faith= mysqli_fetch_array($run_get_video_faith))
  {
	$cb_faith = $row_get_video_faith['cb_faith'];

  $get_vidView_count ="select * from clip_videoviewtb where videoId='$video_id'"; 
  $run_get_vidView_count = mysqli_query($con,$get_vidView_count);
  $check_get_vidView_count = mysqli_num_rows($run_get_vidView_count);
  if($check_get_vidView_count <1){$count_vidView ="Views";}elseif($check_get_vidView_count==1){$count_vidView ="$check_get_vidView_count View";}else{ $count_vidView ="$check_get_vidView_count Views";}
	
	?>
<a href="clip_player?vidid=<?php echo $video_id; ?>&vidname=<?php echo"$video_name "; ?>&vidurl=<?php echo $video_url; ?>&vidalbid=<?php echo $studioId; ?>&vidthumb=<?php echo $thumb_url; ?>&count_vidView=<?php echo $count_vidView; ?>" classk="single_trend_div" >	
	<div class="single_trendingDiv">
	<img src="CB_vid_thumb/<?php echo $thumb_url; ?>" alt="trending Video" class="single_trendingImg" />
	<span class="single_trendingLebal"><?php echo $video_name; ?></span>
	<span class="single_trendingLebal" style="color:#FC795D;"><?php echo $cb_faith; ?></span>
	</div></a>
	<?php
  } }
 ?>
</div>	
<?php
}

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

 if($status =="disp_detail_video")
{
	?> 
	

<?php

$cur_play_vid =$_GET['ongoin_vidid'];


$getComment_count ="select * from clip_commenttb where videoId='$cur_play_vid' ";
$run_getComment_count = mysqli_query($con,$getComment_count);
$check_comm_count = mysqli_num_rows($run_getComment_count);

  $get_video ="select * from cb_videotb where id='$cur_play_vid' ";
  $run_get_video = mysqli_query($con,$get_video);
  while($row_get_video = mysqli_fetch_array($run_get_video))
  {
	$video_id = $row_get_video['id'];
	$studioId = $row_get_video['studioId'];
    $video_name = $row_get_video['video_name'];
    $video_url = $row_get_video['video_url'];	
    $thumb_url = $row_get_video['thumb_url'];

	
	?> 
<input id="detail_vidId" value="<?php echo $video_id; ?>" class="help_input" />	
<input id="detail_vidurl" value="<?php echo $video_url; ?>" class="help_input" />
<input id="video_name" value="<?php echo $video_name; ?>" class="help_input" />	
<input id="detail_vidCom" value="<?php if($check_comm_count <1){}else{ echo $check_comm_count;} ?>" class="help_input" />	
	<?php	

} 

$get_vidView_count ="select * from clip_videoviewtb where videoId='$cur_play_vid'"; 
$run_get_vidView_count = mysqli_query($con,$get_vidView_count);
$check_get_vidView_count = mysqli_num_rows($run_get_vidView_count);

	?> 
<input id="vidView_count" value="<?php if($check_get_vidView_count <1){echo"Views";}elseif($check_get_vidView_count==1){echo"$check_get_vidView_count View";}else{ echo"$check_get_vidView_count Views";}?>" classk="help_input" />	

	<?php	


}


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

 if($status =="disp_recommand_video")
{
	?> 
	
<div id="card_div" class="card_div" >
<h2 class="main_header_title">Recommended for you</h2><button onclick="close_forYou_div();" class="close_forYou_vidBtn">x</button>

<?php


  $get_video ="select * from cb_videotb ";
  $run_get_video = mysqli_query($con,$get_video);
  while($row_get_video = mysqli_fetch_array($run_get_video))
  {
	$video_id = $row_get_video['id'];
	$studioId = $row_get_video['studioId'];
    $video_name = $row_get_video['video_name'];
    $video_url = $row_get_video['video_url'];	
    $thumb_url = $row_get_video['thumb_url'];
	$studioId = $row_get_video['studioId'];
	
  $get_vidView_count ="select * from clip_videoviewtb where videoId='$video_id'"; 
  $run_get_vidView_count = mysqli_query($con,$get_vidView_count);
  $check_get_vidView_count = mysqli_num_rows($run_get_vidView_count);
  if($check_get_vidView_count <1){$count_vidView ="Views";}elseif($check_get_vidView_count==1){$count_vidView ="$check_get_vidView_count View";}else{ $count_vidView ="$check_get_vidView_count Views";}
	

$getComment_count ="select * from clip_commenttb where videoId='$video_id' ";
$run_getComment_count = mysqli_query($con,$getComment_count);
$check_comm_count = mysqli_num_rows($run_getComment_count);
		
	?> 
	
<div id="<?php echo $video_id; ?>" onClick="show_currentVid(this.id);" class="single_trend_div" >
<input id="detail_vidId" value="<?php echo $video_id; ?>" class="help_input" />
<input id="video_name" value="<?php echo $video_name; ?>" class="help_input" />

<div class="trend_img_div" ><img src="CB_vid_thumb/<?php echo $thumb_url; ?>" alt="<?php echo"$video_name"; ?>" class="trend_img"/></div>
<span class="play_icon_span" ><img src="main_icon/play_ro.png" class="play_icon"/></span>
<div class="vidName_reco" ><?php echo $video_name;?></div>
<div class="single_view_div" ><span class="view_output" ><?php echo"$count_vidView"; ?></span>  <img src="main_icon/comt.png" class="com_icon"/><span class="comt_output" ><?php if($check_comm_count <1){}else{ echo $check_comm_count;} ?></span> </div>

<!--span class="trend_song_title">r56<?php echo $video_name;?></span--> 
</div>
	
	<?php	

}  ?>



</div>
<?php

}

/////////////////////////////////////////////////////////////////////
if($status =="mainVidDisp")
{
$studioIdIn = $_GET['studioId'];
if($studioIdIn !==""){
$get_vid = "SELECT * FROM cb_videotb where studioId='$studioIdIn'";	
}else{ $get_vid = "SELECT * FROM cb_videotb"; }

$run_get_vid = mysqli_query($con, $get_vid);

while($row_get_vid = mysqli_fetch_array($run_get_vid)) {
$video_name = $row_get_vid['video_name'];
$video_description = $row_get_vid['video_description'];
$video_url = $row_get_vid['video_url'];
$thumb_url = $row_get_vid['thumb_url'];

$studioId = $row_get_vid['studioId'];
$curr_date = $row_get_vid['curr_date'];

?>
<div id="userSingleVid" class="userSingleVid" >
<a href="index?stdLink=<?php echo $studioId; ?>"><span id="singleThumb" class="singleThumb" ><img src="CB_vid_thumb/<?php echo $thumb_url; ?>" class="vid_thumb_img" id="vid_thumb_img"  /></span></a>
<span class="singleVidName" ><?php echo $video_name; ?></span>
<span class="vidPostDat" ><span>102 Views</span> <span style="float:right"><?php echo $curr_date; ?></span></span>
</div>
<?php
}
}


/////////////////////////////////////////////////////////////////////
if($status =="insertVid_comment")
{
$comVid_id = $_GET['comVid_id'];
$commentInput = $_GET['commentInput'];

// Use 'iis' assuming your database columns are INT, INT, and STRING.
$stmt = $con->prepare("INSERT INTO clip_commenttb (videoId, userId, clip_comment) VALUES (?, ?, ?)");

if ($stmt) {
    // Correctly bind parameters. 'i' for integer, 's' for string.
    $stmt->bind_param("iss", $comVid_id, $userId, $commentInput);

    if ($stmt->execute()) {
       // echo'Comment added successfully.';
    } else {
        http_response_code(500);
        echo json_encode(['success' => false, 'message' => 'Database error: ' . $stmt->error]);
    }

    $stmt->close();
} else {
    http_response_code(500);
    echo json_encode(['success' => false, 'message' => 'Failed to prepare the statement: ' . $con->error]);
}

}

/////////////////////////////////////////////////////////////////////
if($status =="displayVid_comment")
{
$comVid_id = $_GET['comVid_id'];

$getComment ="select * from clip_commenttb where videoId='$comVid_id' order by id desc ";
$run_getComment = mysqli_query($con,$getComment);
while($row_getComment = mysqli_fetch_array($run_getComment))
{
	$comment = $row_getComment['clip_comment'];
	?>
	
<div class="singleComm_dispDiv">
<img src="main_icon/avatar3.jpg" class="comProfile" alt="UserProfile" />

<span class="comUsername">Name</span>
<img src="main_icon/more_opton.png" class="comOptionBtn" alt="moreOpt" />
<span class="commentOutput"><?php echo $comment; ?></span>

 </div>
	
	
	<?php
}

}

/////////////////////////////////////////////////////////////////////
if($status =="Vid_comment_count")
{
$comVid_id = $_GET['comVid_id'];
$getComment_count ="select * from clip_commenttb where videoId='$comVid_id' ";
$run_getComment_count = mysqli_query($con,$getComment_count);
$check_comm_count = mysqli_num_rows($run_getComment_count);
if($check_comm_count <1){}else{ echo $check_comm_count;}


}

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

if($status =="search_video")
{
  $incoming_search = $_GET['incoming_search'];
  $get_song ="select * from cb_videotb where video_name LIKE '%$incoming_search%' OR video_description LIKE '%$incoming_search%' ";
  $run_get_song = mysqli_query($con,$get_song);
  while($row_get_video = mysqli_fetch_array($run_get_song))
  {
   	$video_id = $row_get_video['id'];
	$studioId = $row_get_video['studioId'];
    $video_name = $row_get_video['video_name'];
    $video_url = $row_get_video['video_url'];	
    $thumb_url = $row_get_video['thumb_url'];
	$studioId = $row_get_video['studioId'];
	
	
		$getComment_count ="select * from clip_commenttb where videoId='$video_id' ";
$run_getComment_count = mysqli_query($con,$getComment_count);
$check_comm_count = mysqli_num_rows($run_getComment_count);
	
	
  $get_vidView_count ="select * from clip_videoviewtb where videoId='$video_id'"; 
  $run_get_vidView_count = mysqli_query($con,$get_vidView_count);
  $check_get_vidView_count = mysqli_num_rows($run_get_vidView_count);
  if($check_get_vidView_count <1){$count_vidView ="Views";}elseif($check_get_vidView_count==1){$count_vidView ="$check_get_vidView_count View";}else{ $count_vidView ="$check_get_vidView_count Views";}
	
	
	?>

<!--a href="cob_videos?vidid=<?php echo $video_id; ?>&vidname=<?php echo"$video_name - $artist_name"; ?>&vidurl=<?php echo $video_url; ?>&vidview=<?php echo $check_get_video_view; ?>&vidalbid=<?php echo $vid_album_id; ?>" -->
<a href="clip_player?vidid=<?php echo $video_id; ?>&vidname=<?php echo"$video_name "; ?>&vidurl=<?php echo $video_url; ?>&vidalbid=<?php echo $studioId; ?>&vidthumb=<?php echo $thumb_url; ?>&count_vidView=<?php echo $count_vidView; ?>" >
<div class="song_title_search" ><?php echo $video_name;  ?> </div> </a> 

	<?php
	
  }	
}

////index/////////////////////////////////////////////////////////////////////////////////////////////////////////
if($status=="disp_daily_wisdomtb")
{
  //$incoming_search = $_GET['incoming_search'];
  $get_wisdom_text ="select * from daily_wisdomtb order by id desc limit 1 ";
  $run_get_wisdom_text = mysqli_query($con,$get_wisdom_text);
  while($row_get_wisdom_text = mysqli_fetch_array($run_get_wisdom_text))
  {
   	$wisdom_text = $row_get_wisdom_text['wisdom_text'];	
	echo $wisdom_text;
}
}


////cb_publisher/////////////////////////////////////////////////////////////////////////////////////////////////////////
if($status=="join_publisher")
{
  $religion = $_GET['religion'];
  $get_publihser ="select * from cb_publisher where userId='$userId' ";
  $run_get_publihser = mysqli_query($con,$get_publihser);
  $check_publisher = mysqli_num_rows($run_get_publihser);
  if($check_publisher <1){
  
  $join_publisher ="insert into cb_publisher (userId,religion,cur_country,cur_city,ipuser,join_date,join_time)
  values('$userId','$religion','$country','$city','$user_ip',CURDATE(),CURTIME())";
  $run_join_publisher = mysqli_query($con,$join_publisher);
  if(!$run_join_publisher){echo"Request not accepted";}
  }else{echo"You are already a publisher";}
}

////clip_studio/////////////////////////////////////////////////////////////////////////////////////////////////////////
if($status=="studio_disp_wisdomText")
{
  //$incoming_search = $_GET['incoming_search'];
  $get_wisdom_text ="select * from daily_wisdomtb";// order by id desc limit 1 ";
  $run_get_wisdom_text = mysqli_query($con,$get_wisdom_text);
  while($row_get_wisdom_text = mysqli_fetch_array($run_get_wisdom_text))
  {
   	$wisdom_text = $row_get_wisdom_text['wisdom_text'];	
	?>
	
<div class="sl-daily-wisdom-card">
    <h3 class="sl-section-heading">Daily Wisdom ✨</h3>
    <div id="dailyWisdomContent">
        <p class="sl-info-message"><?php echo $wisdom_text; ?></p>
    </div>
</div>	
	<?php

}
}
///////clip_studio///////////////////////////////////////////////////////////////////////////////////////////////////////////////////

if($status =="disp_user_info")
{

 $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 my_id='$userId' ";
	
	$run_get_user = mysqli_query($con,$get_user);
	$check_user = mysqli_num_rows($run_get_user);	
    while($row_get_user = mysqli_fetch_array($run_get_user))
	{
		$usrname = $row_get_user['lname'];
		echo $usrname;
	
	}
	
	
}
}




?>