require_once __DIR__ . '/../../links/link_functions.php'; require_once __DIR__ . '/functions.php'; ini_set('max_execution_time', 300); if ($m = $mysqli->query("SELECT id, title, year FROM movies ORDER BY popularity DESC")) { while ($params = mysqli_fetch_assoc($m)) { $link = get_netflix_link($params['title'], $params['year']); mysqli_query($mysqli, "DELETE FROM netflix WHERE id=" . $params['id']); $query = "INSERT INTO netflix VALUES (" . $params['id'] . ",'" . $link . "','" . date('Y-m-d H:i:s') . "')"; mysqli_query($mysqli, $query); if ($link) { if ($a = $mysqli->query("SELECT username FROM alerts WHERE all=1 AND id=" . $params['id'])) { while ($u = mysqli_fetch_assoc($a)) { $user = mysqli_fetch_assoc($mysqli->query("SELECT email FROM users WHERE username='******'username'] . "'")); send_new_link_email($user['email'], $u['username'], $params['id'], $params['title'], 'Netflix'); mysqli_query($mysqli, "UPDATE alerts SET all=0, netflix=0 WHERE username='******'username'] . "' AND id=" . $params['id']); } } if ($a = $mysqli->query("SELECT username FROM alerts WHERE netflix=1 AND id=" . $params['id'])) { while ($u = mysqli_fetch_assoc($a)) { $user = mysqli_fetch_assoc($mysqli->query("SELECT email FROM users WHERE username='******'username'] . "'")); send_new_link_email($user['email'], $u['username'], $params['id'], $params['title'], 'Netflix'); mysqli_query($mysqli, "UPDATE alerts SET netflix=0 WHERE username='******'username'] . "' AND id=" . $params['id']); } } } } } // REPORTING echo "\n---------------------------\n\n"; echo "Finished executing " . __FILE__ . " at " . date('g:i:s A') . " on " . date('F j, Y') . ".\n"; echo "\n\n---------------------------\n";
require_once __DIR__ . '/functions.php'; ini_set('max_execution_time', 300); if ($m = $mysqli->query("SELECT id, title, runtime, director FROM movies ORDER BY popularity DESC")) { while ($params = mysqli_fetch_assoc($m)) { $director = mysqli_fetch_assoc($mysqli->query("SELECT name FROM actors WHERE id=" . $params['director'])); $link = get_itunes_link($params['title'], $params['runtime'], $director['name']); mysqli_query($mysqli, "DELETE FROM itunes WHERE id=" . $params['id']); $query = "INSERT INTO itunes VALUES (" . $params['id'] . ",'" . $link['link'] . "','" . $link['rent'] . "','" . $link['buy'] . "','" . $link['itunesId'] . "','" . date('Y-m-d H:i:s') . "')"; mysqli_query($mysqli, $query); if ($link['link']) { if ($a = $mysqli->query("SELECT username FROM alerts WHERE all=1 AND id=" . $params['id'])) { while ($u = mysqli_fetch_assoc($a)) { $user = mysqli_fetch_assoc($mysqli->query("SELECT email FROM users WHERE username='******'username'] . "'")); send_new_link_email($user['email'], $u['username'], $params['id'], $params['title'], 'iTunes'); mysqli_query($mysqli, "UPDATE alerts SET all=0, itunes=0 WHERE username='******'username'] . "' AND id=" . $params['id']); } } if ($a = $mysqli->query("SELECT username FROM alerts WHERE itunes=1 AND id=" . $params['id'])) { while ($u = mysqli_fetch_assoc($a)) { $user = mysqli_fetch_assoc($mysqli->query("SELECT email FROM users WHERE username='******'username'] . "'")); send_new_link_email($user['email'], $u['username'], $params['id'], $params['title'], 'iTunes'); mysqli_query($mysqli, "UPDATE alerts SET itunes=0 WHERE username='******'username'] . "' AND id=" . $params['id']); } } } } } // REPORTING echo "\n---------------------------\n\n"; echo "Finished executing " . __FILE__ . " at " . date('g:i:s A') . " on " . date('F j, Y') . ".\n"; echo "\n\n---------------------------\n";
if ($c = $mysqli->query("SELECT a.name FROM actors a INNER JOIN roles r ON a.id = r.actor_id AND r.movie_id = {$params['id']}")) { while ($actor = mysqli_fetch_assoc($c)) { $cast[] = $actor['name']; } } $link = get_youtube_link($params['title'], $cast); mysqli_query($mysqli, "DELETE FROM youtube WHERE id=" . $params['id']); $query = "INSERT INTO youtube VALUES (" . $params['id'] . ",'" . $link . "','" . date('Y-m-d H:i:s') . "')"; mysqli_query($mysqli, $query); if ($link) { if ($a = $mysqli->query("SELECT username FROM alerts WHERE all=1 AND id=" . $params['id'])) { while ($u = mysqli_fetch_assoc($a)) { $user = mysqli_fetch_assoc($mysqli->query("SELECT email FROM users WHERE username='******'username'] . "'")); send_new_link_email($user['email'], $u['username'], $params['id'], $params['title'], 'YouTube'); mysqli_query($mysqli, "UPDATE alerts SET all=0, youtube=0 WHERE username='******'username'] . "' AND id=" . $params['id']); } } if ($a = $mysqli->query("SELECT username FROM alerts WHERE youtube=1 AND id=" . $params['id'])) { while ($u = mysqli_fetch_assoc($a)) { $user = mysqli_fetch_assoc($mysqli->query("SELECT email FROM users WHERE username='******'username'] . "'")); send_new_link_email($user['email'], $u['username'], $params['id'], $params['title'], 'YouTube'); mysqli_query($mysqli, "UPDATE alerts SET youtube=0 WHERE username='******'username'] . "' AND id=" . $params['id']); } } } } } // REPORTING echo "\n---------------------------\n\n"; echo "Finished executing " . __FILE__ . " at " . date('g:i:s A') . " on " . date('F j, Y') . ".\n"; echo "\n\n---------------------------\n";