<?php
header("Cache-Control: no-cache, must-revalidate");

header("Content-Type: application/xml; charset=utf-8");

include('config.php');
$connect = mysqli_connect($dbhost,$dbuser,$dbpass,$dbname);
$con = mysqli_connect($dbhost,$dbuser,$dbpass);

$lang = $_GET['language'];

$res = mysqli_query($connect,"SELECT id as main_cat_id FROM `catalog` where name = 'Trending' and product_id=209");

$row = mysqli_fetch_assoc($res);

$id = $row['main_cat_id'];


error_log('zinglang_slider',0);
#$r = "SELECT id as cat_id,name as cat_name FROM `catalog` where pid= $id order by priority";


$res1 = mysqli_query($connect, "SELECT billing_type,id as cat_id,name as cat_name,cat_type,group_type,showlabel,showsynopsis,showcast,circle FROM `catalog` where pid= $id and id not in (2444,2485,2484,3030,3031,3032,3033,3045,3046) and billing_type!=5 order by priority");


#echo "SELECT billing_type,id as cat_id,name as cat_name,cat_type,group_type,showlabel,showsynopsis,showcast,circle FROM `catalog` where pid= $id and id not in (2444,2485,2484,3030,3031,3032,3033,3045,3046) order by priority";
#echo "SELECT id as cat_id,name as cat_name FROM `catalog` where pid= $id order by priority";
error_log('home'.$r,0);


//$row1 = mysqli_fetch_assoc($res1);
$movies = array();
//$movie_list = array();
$list = array();


while($row1 = mysqli_fetch_assoc($res1)){

$billing_type = $row1['billing_type'];


$c_id = $row1['cat_id'];
$c_name = $row1['cat_name'];
$cat_type = $row1['cat_type'];
$group_type = $row1['group_type'];
$showsynopsis = $row1['showsynopsis'];
$showlabel = $row1['showlabel'];
$circle = $row1['circle'];

$showcast =$row1['showcast'];
$lang_videos = array();
$movies['product_id'] = 367;
$movies['category_id'] = $c_id;
$movies['category_name'] = $c_name;
$movies['cat_type'] = $cat_type;
$movies['group_type'] = $group_type;

$movies['showlabel'] = $showlabel;
$movies['cat_ID'] = $billing_type;
$movies['showsynopsis'] = $showsynopsis;
$movies['showcast'] = $showcast;

$movies['circle'] = $circle;


if($cat_type == 'youtube'){
$movies['isPremium'] = "false";
}else{
$movies['isPremium'] = "true";
}
#$res2 = mysqli_query($con, "select cr.label,cr.id, cr.name,cr.cp_url,cr.url,cr.starcast,cr.rating,cr.director,cr.description,cr.cert,cr.genre,cr.language,cr.released,cr.ctype from cms.content cn, repo.contentdata cr where cn.content_id = cr.id and cn.catalog_id=$c_id order by rand()");


/*if($lang == 'Hindi'){
$res2 = mysqli_query($con, "select DISTINCT(cr.genre), cr.label,cr.id, cr.name,cr.cp_url,cr.url,cr.starcast,cr.rating,cr.director,cr.description,cr.cert,cr.genre,cr.language,cr.released,cr.ctype from cms.content cn, repo.contentdata cr where cn.content_id = cr.id and cn.catalog_id=$c_id and cr.genre in ('Action','Comedy','Drama','Thriller','Romance') order by rand() LIMIT 5");
}else{

$res2 = mysqli_query($con, "select cr.label,cr.id, cr.name,cr.cp_url,cr.url,cr.starcast,cr.rating,cr.director,cr.description,cr.cert,cr.genre,cr.language,cr.released,cr.ctype from cms.content cn, repo.contentdata cr where cn.content_id = cr.id and cn.catalog_id=$c_id");
}*/


if(($c_name == 'Ramayan') || ( $c_name == 'Prank Videos')  ||  ($c_name == 'Comedy Videos') || ($c_name == 'Mahabharat') || ($c_name == 'Movies') || ($c_name == 'Shri Krishna')) {
$res2 = mysqli_query($con, "select cn.catalog_id as caty_id,cr.trurl,cr.duration,cr.singer,cr.music_director,cr.type_of_content,cr.group_type,cr.label,cr.id, cr.name,cr.cp_url,cr.url,cr.starcast,cr.rating,cr.director,cr.description,cr.cert,cr.genre,cr.language,cr.released,cr.ctype from cms.content cn, repo.contentdata cr where cn.content_id = cr.id and cn.catalog_id=$c_id");

#echo  "select cn.catalog_id as caty_id,cr.trurl,cr.duration,cr.singer,cr.music_director,cr.type_of_content,cr.group_type,cr.label,cr.id, cr.name,cr.cp_url,cr.url,cr.starcast,cr.rating,cr.director,cr.description,cr.cert,cr.genre,cr.language,cr.released,cr.ctype from cms.content cn, repo.contentdata cr where cn.content_id = cr.id and cn.catalog_id=$c_id";


}else{

#echo "select cr.label,cr.id, cr.name,cr.cp_url,cr.url,cr.starcast,cr.rating,cr.director,cr.description,cr.cert,cr.genre,cr.language,cr.released,cr.ctype from cms.content cn, repo.contentdata cr where cn.content_id = cr.id and cn.catalog_id=$c_id and cr.genre in ('Action','Comedy','Drama','Thriller','Romance') LIMIT 5 order by rand()";

#$res2 = mysqli_query($con, "select cn.catalog_id as caty_id,cn.album_name,cr.trurl,cr.duration,cr.singer,cr.music_director,cr.type_of_content,cr.group_type,cr.label,cr.id, cr.name,cr.cp_url,cr.url,cr.starcast,cr.rating,cr.director,cr.description,cr.cert,cr.genre,cr.language,cr.released,cr.ctype from cms.content cn, repo.contentdata cr where cn.content_id = cr.id and cn.catalog_id=$c_id order by id desc limit 10");


#$res2 = mysqli_query($con, "select t.portrait,t.caty_id,t.album_name,t.trurl,t.duration,t.singer,t.music_director,t.type_of_content,t.group_type,t.label,t.id, t.name,t.cp_url,t.url,t.starcast,t.rating,t.director,t.description,t.cert,t.genre,t.language,t.released,t.ctype from (select cn.catalog_id as caty_id,cn.album_name,cr.trurl,cr.duration,cr.singer,cr.music_director,cr.type_of_content,cr.group_type,cr.label,cr.id, cr.name,cr.cp_url,cr.url,cr.starcast,cr.rating,cr.director,cr.description,cr.portrait,cr.cert,cr.genre,cr.language,cr.released,cr.ctype from cms.content cn, repo.contentdata cr where cn.content_id = cr.id and cn.catalog_id=$c_id order by cn.id desc limit 15)t order by rand()");

$res2 = mysqli_query($con, "select t.portrait,t.caty_id,t.caty_id as cat_idnew,t.album_name,t.trurl,t.duration,t.singer,t.music_director,t.type_of_content,t.group_type,t.label,t.id, t.name,t.cp_url,t.url,t.starcast,t.rating,t.director,t.description,t.cert,t.genre,t.language,t.released,t.ctype from (select cn.catalog_id as caty_id,cn.album_name,cr.trurl,cr.duration,cr.singer,cr.music_director,cr.type_of_content,cr.group_type,cr.label,cr.id, cr.name,cr.cp_url,cr.url,cr.starcast,cr.rating,cr.director,cr.description,cr.portrait,cr.cert,cr.genre,cr.language,cr.released,cr.ctype from cms.content cn, repo.contentdata cr where cn.content_id = cr.id and cn.catalog_id=$c_id order by cn.id desc limit 15)t");
}


$q="select t.portrait,t.caty_id,t.album_name,t.trurl,t.duration,t.singer,t.music_director,t.type_of_content,t.group_type,t.label,t.id, t.name,t.cp_url,t.url,t.starcast,t.rating,t.director,t.description,t.cert,t.genre,t.language,t.released,t.ctype from (select cn.catalog_id as caty_id,cn.album_name,cr.trurl,cr.duration,cr.singer,cr.music_director,cr.type_of_content,cr.group_type,cr.label,cr.id, cr.name,cr.cp_url,cr.url,cr.starcast,cr.rating,cr.director,cr.description,cr.portrait,cr.cert,cr.genre,cr.language,cr.released,cr.ctype from cms.content cn, repo.contentdata cr where cn.content_id = cr.id and cn.catalog_id=$c_id order by cn.id desc limit 15)t";


error_log('sliderget'.$q,0);

#echo "select cn.catalog_id as caty_id,cn.album_name,cr.trurl,cr.duration,cr.singer,cr.music_director,cr.type_of_content,cr.group_type,cr.label,cr.id, cr.name,cr.cp_url,cr.url,cr.starcast,cr.rating,cr.director,cr.description,cr.cert,cr.genre,cr.language,cr.released,cr.ctype from cms.content cn, repo.contentdata cr where cn.content_id = cr.id and cn.catalog_id=$c_id order by rand()";

$movie_list = array();

while($rows = mysqli_fetch_array($res2)){
//echo "dsf";
//$row_array['date'] = $rows['cdt'];
//$row_array['percentage'] = $rows['percentage'];
 $row_array['name'] = $rows['name'];
$row_array['youtube_url'] = $rows['url'];
$row_array['category_type'] = $rows['label'];
$row_array['cpurl'] = $rows['cp_url'];
$row_array['starcast'] = $rows['starcast'];
$row_array['rating'] = $rows['rating'];
$row_array['director'] = $rows['director'];
//$row_array['description'] = $rows['description'];
$row_array['certificate'] = $rows['cert'];
$row_array['genre'] = $rows['genre'];
$row_array['language'] = $rows['language'];
$row_array['released'] = $rows['released'];
$row_array['content_type'] = $rows['ctype'];
$row_array['content_id']= $rows['id'];

$row_array['trailer_url']= $rows['trailer_url'];
$row_array['duration']= $rows['duration'];
$row_array['portrait']= $rows['portrait'];
$row_array['group_type']= $rows['group_type'];
$row_array['type_of_content'] = $rows['type_of_content'];
$row_array['caty_id'] = $rows['caty_id'];
$cid = $rows['id'];
//$row_array['thumb'] = $rows['thumb'];
$ctype =  $rows['ctype'];
 $row_array['preview_image_url'] = "previewthumbnail.php?c_id=$cid&ctype=$ctype";


#if($c_name == 'Top Albums'){
if($cat_type == 'music'){
 $row_array['group_type'] = $group_type;
}

$row_array['isPremium'] = "true";

#$imgurl = "previewthumbnail.php?c_id=567260&ctype=MUSICD";


#$row_array['preview_image_url'] = $imgurl;
#}
 $row_array['description'] = utf8_encode($rows['description']);

$row_array['category_name_id']= $rows['album_name'];

#$row_array['category_name_id']= $rows['cat_idnew'];

$row_array['category_name_two'] = $c_name;
$row_array['music_director']= $rows['music_director'];
$row_array['singer']= $rows['singer'];


 array_push($movie_list,$row_array);


}
//$movie_list1 = array();
//$movies_list1= array("product_id"=>"467","category_id"=>$c_id,"category_name"=>$c_name,"videos"=>$movie_list);
//array_push($movies,$movie_list1);
$movies['videos'] = $movie_list;
//header('Content-Type: application/json');

array_push($list,$movies);

}
//$list = array();

//array_push($list,$movies);
header('Content-Type: application/json');


if (empty($list)) {

                                                                                                                         
$array = array();

 json_encode($array);

} else{
echo json_encode($list);
}


//echo json_encode($movie_list);

//mysqli_close($repo);
mysqli_close($repolink);


?>