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; }