public function getEpisodeDb($idTVShow, $numSeason, $numEpisode, $appendToResponse = 'append_to_response=trailers,images,credits,translations')
{
$datasave = $this->CI->db->query("SELECT * FROM movie_data WHERE id_tmdb=" . $idTVShow . $numSeason . $numEpisode . " AND seasons=" . $numSeason . " AND episodes=" . $numEpisode . " AND type='tv'")->result_array();
if (empty($datasave)) {
/*$url = self::_API_URL_.'tv/'. $idTVShow .'/season/'. $numSeason .'/episode/'. $numEpisode .'?api_key='. $this->getApikey() .'&language='. $this->getLang() .'&'.$appendToResponse;
$results=file_get_contents($url);
$original=json_decode(($results), false);*/
$originals = new Episode($this->_call('tv/' . $idTVShow . '/season/' . $numSeason . '/episode/' . $numEpisode, $appendToResponse), $idTVShow);
$original = $originals->getdata();
$keywords = $originals->getTitle();
$datacurrent = $this->CI->db->query("SELECT count(*) as cnt FROM movie_data WHERE parent_id_tmdb=" . $idTVShow . " AND seasons=" . $numSeason . " AND episodes=" . $numEpisode . " AND type='tv'")->result_array();
if ($datacurrent[0]['cnt'] == 0) {
$sqlinsert = "INSERT IGNORE INTO movie_data SET id_tmdb=?, parent_id_tmdb=?, id_genre='', original=?, seasons=?,episodes=?,date=?,type='tv', keywords=?";
$this->CI->db->query($sqlinsert, array($idTVShow . $numSeason . $numEpisode, $idTVShow, json_encode($original), $numSeason, $numEpisode, date('Y-m-d H:i:s'), $this->clean($keywords)));
}
} else {
$originals = new Episode(json_decode($datasave[0]['original'], true), $idTVShow);
// $original=json_decode($datasave[0]['original']);
}
// pr($originals);die;
return $originals;
}
