public function updateImdbInfo($id)
{
$sth = $this->db->prepare("SELECT * FROM imdbinfo WHERE id = ?");
$sth->bindParam(1, $id, PDO::FETCH_ASSOC);
$sth->execute();
$res = $sth->fetch(PDO::FETCH_ASSOC);
if (!$res) {
throw new Exception(L::get("MOVIE_NOT_FOUND"), 404);
}
$url = 'http://akas.imdb.com/title/' . $res["imdbid"] . '/';
$data = $this->fetchImdbData($url);
// if ($res["photo"] == 1) {
// $data["photo"] = 1;
//} else {
if (strlen($data["photo"]) > 10) {
file_put_contents($this->imdbPicturesDir . $res["imdbid"] . '.jpg', file_get_contents($data["photo"]));
$data["photo"] = 1;
} else {
$data["photo"] = 0;
}
//}
$sth = $this->db->prepare("UPDATE imdbinfo SET rating = ?, tagline = ?, genres = ?, photo = ?, director = ?, writer = ?, cast = ?, runtime = ?, seasoncount = ?, title = ?, lastUpdated = NOW() WHERE id = ?");
$sth->bindParam(1, $data["rating"], PDO::PARAM_INT);
$sth->bindParam(2, $data["tagline"], PDO::PARAM_STR);
$sth->bindParam(3, $data["genres"], PDO::PARAM_STR);
$sth->bindParam(4, $data["photo"], PDO::PARAM_INT);
$sth->bindParam(5, $data["director"], PDO::PARAM_STR);
$sth->bindParam(6, $data["writer"], PDO::PARAM_STR);
$sth->bindParam(7, $data["cast"], PDO::PARAM_STR);
$sth->bindParam(8, $data["runtime"], PDO::PARAM_INT);
$sth->bindParam(9, $data["seasoncount"], PDO::PARAM_INT);
$sth->bindParam(10, $data["title"], PDO::PARAM_STR);
$sth->bindParam(11, $id, PDO::PARAM_INT);
$sth->execute();
} break;
case validateRoute('POST', 'mailbox'):
$mailbox = new Mailbox($db, $user);
httpResponse($mailbox->create($postdata));
break;
case validateRoute('DELETE', 'mailbox/\\d+'):
$mailbox = new Mailbox($db, $user);
httpResponse($mailbox->delete((int) $params[1]));
break;
case validateRoute('GET', 'moviedata/\\d+'):
$movieData = new MovieData($db);
httpResponse($movieData->getData($params[1]));
break;
case validateRoute('GET', 'moviedata/\\d+/refresh'):
$movieData = new MovieData($db);
httpResponse($movieData->updateImdbInfo($params[1]));
break;
case validateRoute('GET', 'moviedata/search'):
$movieData = new MovieData($db);
httpResponse($movieData->search($_GET["search"]));
break;
case validateRoute('GET', 'moviedata/imdb/\\w+'):
$movieData = new MovieData($db);
$arr = $movieData->getDataByImdbId($params[2]);
httpResponse($arr);
break;
case validateRoute('GET', 'moviedata/toplist'):
$cacheId = 'toplists-toplist';
if ($memcache && ($cached = $memcache->get($cacheId))) {
httpResponse($cached);
} else {
