function addedit($tmdb, $tmdb_id, $list)
{
$movie = $tmdb->getMovie($tmdb_id);
$trailers = $tmdb->getMovieTrailers($tmdb_id);
addeditcastcrew($tmdb, $tmdb_id);
$query = "DELETE from trailers where tmdb_id = " . $tmdb_id . "";
$result = mysql_query($query) or die('Query failed: ' . mysql_error());
if (count($trailers["youtube"]) > 0) {
foreach ($trailers['youtube'] as $t) {
$t['name'] = preg_replace("/'/", "\\'", $t['name']);
$t['name'] = preg_replace("/\"/", "\\\"", $t['name']);
$query = "INSERT INTO trailers (tmdb_id,type,name,size,source)VALUES (" . $tmdb_id . ",'youtube','" . $t["name"] . "','" . $t["size"] . "','" . $t["source"] . "')";
$result = mysql_query($query) or die('Query failed: ' . mysql_error());
}
}
updateMovieGenres($movie["genres"], $tmdb_id);
$my_tmdb['poster_path_w185'] = $tmdb->getImageUrl($movie['poster_path'], 'poster', "w185");
$my_tmdb['poster_path_w342'] = $tmdb->getImageUrl($movie['poster_path'], 'poster', "w342");
$my_tmdb['poster_path_original'] = $tmdb->getImageUrl($movie['poster_path'], 'poster', "original");
$my_tmdb['backdrop_path_w185'] = $tmdb->getImageUrl($movie['backdrop_path'], 'poster', "w185");
$my_tmdb['backdrop_path_w342'] = $tmdb->getImageUrl($movie['backdrop_path'], 'poster', "w342");
$my_tmdb['backdrop_path_w500'] = $tmdb->getImageUrl($movie['backdrop_path'], 'poster', "w500");
$my_tmdb['backdrop_path_original'] = $tmdb->getImageUrl($movie['backdrop_path'], 'poster', "original");
$title = mysql_real_escape_string(utf8_decode($movie['title']));
$url = sanitize($title) . "-" . $tmdb_id;
$query = "SELECT id from movies where tmdb_id = " . $tmdb_id . "";
$result = mysql_query($query) or die('Query failed: ' . mysql_error());
if (mysql_num_rows($result) == 0) {
// INSERT
$query = "\n\t\tINSERT INTO \n\t\t`movies` (\n\t\t`id`, \n\t\t`backdrop_path_w185`, \n\t\t`backdrop_path_w342`, \n\t\t`backdrop_path_w500`, \n\t\t`backdrop_path_original`, \n\t\t`tmdb_id`, \n\t\t`imdb_id`, \n\t\t`original_title`, \n\t\t`overview`, \n\t\t`homepage`, \n\t\t`release_date`, \n\t\t`runtime`, \n\t\t`poster_path_w185`, \n\t\t`poster_path_w342`, \n\t\t`poster_path_original`, \n\t\t";
if (isset($movie['rating'])) {
$query = $query . " `rating`,";
}
$query = $query . "\n\t\t`title`, \n\t\t`url`, \n\t\t`vote_average`, \n\t\t`vote_count`, \n\t\t`insertion_date`, \n\t\t`update_date`\n\t\t) VALUES (\n\t\tNULL,\n\t\t'" . $my_tmdb['backdrop_path_w185'] . "', \n\t\t'" . $my_tmdb['backdrop_path_w342'] . "', \n\t\t'" . $my_tmdb['backdrop_path_w500'] . "', \n\t\t'" . $my_tmdb['backdrop_path_original'] . "', \n\t\t'" . $tmdb_id . "',\n\t\t'" . $movie['imdb_id'] . "',\n\t\t'" . mysql_real_escape_string(utf8_decode($movie['original_title'])) . "' ,\n\t\t'" . mysql_real_escape_string(utf8_decode($movie['overview'])) . "',\n\t\t'" . $movie['homepage'] . "' ,\n\t\t'" . $movie['release_date'] . "',\n\t\t'" . $movie['runtime'] . "',\n\t\t'" . $my_tmdb['poster_path_w185'] . "',\n\t\t'" . $my_tmdb['poster_path_w342'] . "',\n\t\t'" . $my_tmdb['poster_path_original'] . "',\n\t\t";
if (isset($movie['rating'])) {
$query = $query . "rating = '" . $movie['rating'] * 10 . "', ";
}
$query = $query . "\n\t\t'" . $title . "',\n\t\t'" . $url . "',\n\t\t'" . $movie['vote_average'] . "',\n\t\t'" . $movie['vote_count'] . "',\n\t\tCURRENT_TIMESTAMP,\n\t\t'0000-00-00 00:00:00'\t\t\n\t\t)";
} else {
// UPDATE
while ($row = mysql_fetch_assoc($result)) {
$id = $row['id'];
}
$query = "\n\t\tUPDATE `movies` \n\t\tSET\n\t\tbackdrop_path_w185 = '" . $my_tmdb['backdrop_path_w185'] . "', \n\t\tbackdrop_path_w342 = '" . $my_tmdb['backdrop_path_w342'] . "', \n\t\tbackdrop_path_w500 = '" . $my_tmdb['backdrop_path_w500'] . "', \n\t\tbackdrop_path_original = '" . $my_tmdb['backdrop_path_original'] . "', \n\t\ttmdb_id = '" . $tmdb_id . "',\n\t\timdb_id = '" . $movie['imdb_id'] . "',\n\t\toriginal_title = '" . mysql_real_escape_string(html_entity_decode($movie['original_title'])) . "' ,\n\t\toverview = '" . mysql_real_escape_string(utf8_decode($movie['overview'])) . "',\n\t\thomepage = '" . $movie['homepage'] . "' ,\n\t\trelease_date = '" . $movie['release_date'] . "',\n\t\truntime = '" . $movie['runtime'] . "',\n\t\tposter_path_w185 = '" . $my_tmdb['poster_path_w185'] . "',\n\t\tposter_path_w342 = '" . $my_tmdb['poster_path_w342'] . "',\n\t\tposter_path_original = '" . $my_tmdb['poster_path_original'] . "',\n\t\t";
if (isset($movie['rating'])) {
$query = $query . "rating = '" . $movie['rating'] * 10 . "', ";
}
$query = $query . "\n\t\ttitle = '" . $title . "',\n\t\turl = '" . $url . "',\n\t\tvote_average = '" . $movie['vote_average'] . "',\n\t\tvote_count = '" . $movie['vote_count'] . "',\n\t\tupdate_date = CURRENT_TIMESTAMP\n\t\tWHERE id = '" . $id . "'";
}
mysql_query($query) or die('Query failed: ' . mysql_error());
if (!isset($id)) {
$id = mysql_insert_id();
}
return array("title" => $title, "backdrop_path_w185" => $my_tmdb['backdrop_path_w342'], "poster_path_w185" => $my_tmdb["poster_path_w185"], "id" => mysql_insert_id(), "url" => $url);
}
} else {
if (empty($_SESSION['tmdb_id'])) {
$account = $tmdb->getAccount($_SESSION['tmdb_session_id']);
$_SESSION['tmdb_username'] = $account['username'];
$_SESSION['tmdb_id'] = $account['id'];
$_SESSION['tmdb_language'] = $account['iso_3166_1'];
}
if (isset($_GET["action"])) {
if ($_GET["action"] == 'updategenres') {
$query = "SELECT * from movies";
$result = mysql_query($query) or die('Query failed: ' . mysql_error());
ob_flush();
flush();
while ($row = mysql_fetch_assoc($result)) {
$movie = $tmdb->getMovie($row['tmdb_id']);
updateMovieGenres($movie["genres"], $row['tmdb_id']);
echo "movie " . $row['title'] . " has " . count($movie["genres"]) . " genres updated<br>";
}
} elseif ($_GET["action"] == 'importall') {
ob_end_flush();
$movies = $tmdb->getMoviesByGenre('28');
echo "<pre>";
var_dump($movies);
} elseif ($_GET["action"] == 'sanatizeall') {
$query = "SELECT * from movies";
$result = mysql_query($query) or die('Query failed: ' . mysql_error());
$i = 0;
while ($row = mysql_fetch_assoc($result)) {
$query = "\n\t\t\t\t\t\tUPDATE `flamestr`.`movies` \n\t\t\t\t\t\tSET\n\t\t\t\t\t\turl = '" . sanitize($row['title'] . "-" . $row['tmdb_id']) . "'\n\t\t\t\t\t\tWHERE id = '" . $row['id'] . "'";
mysql_query($query) or die('Query failed: ' . mysql_error());
$i++;
