$omdb_V1 = new OMDBv1(); # echo "DETALLES DE PELICULA"; $tm_info = $tmdb_V3->movieDetail($_POST['id']); $om_info = $omdb_V1->movieDetail($tm_info['imdb_id']); # echo"<pre>";print_r($tm_info);echo"</pre>"; # echo"<pre>";print_r($om_info);echo"</pre>"; $str_genres = ""; foreach ($tm_info['genres'] as $g) { if (empty($str_genres)) { $str_genres = $g['name']; } else { $str_genres .= ' | ' . $g['name']; } } # echo"<pre>";print_r($str_genres);echo"</pre>"; $idx_title = GetIndex($tm_info['title']); $db = new SQLite3('videoworld.sqlite'); $stmt = $db->prepare('INSERT INTO movies(id,imdb_id,original_title,overview,poster_path,release_date,title,imdbRating,backdrop_path,genres,actors,director,idx_title,imdbVotes) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?)'); $stmt->bindParam(1, $tm_info['id']); $stmt->bindParam(2, $tm_info['imdb_id']); $stmt->bindParam(3, $tm_info['original_title']); $stmt->bindParam(4, $tm_info['overview']); $stmt->bindParam(5, $tm_info['poster_path']); $stmt->bindParam(6, $tm_info['release_date']); $stmt->bindParam(7, $tm_info['title']); $stmt->bindParam(8, $om_info['imdbRating']); $stmt->bindParam(9, $tm_info['backdrop_path']); $stmt->bindParam(10, $str_genres); $stmt->bindParam(11, $om_info['Actors']); $stmt->bindParam(12, $om_info['Director']); $stmt->bindParam(13, $idx_title);
include_once dirname(__FILE__) . '/ressources/class.squid.inc'; include_once dirname(__FILE__) . '/ressources/class.dansguardian.inc'; include_once dirname(__FILE__) . '/framework/class.unix.inc'; include_once dirname(__FILE__) . '/framework/frame.class.inc'; include_once dirname(__FILE__) . "/ressources/class.categorize.externals.inc"; include_once dirname(__FILE__) . "/ressources/class.ccurl.inc"; include_once dirname(__FILE__) . "/ressources/class.tcpip.inc"; include_once dirname(__FILE__) . "/ressources/smtp/smtp.php"; include_once dirname(__FILE__) . '/ressources/class.mime.parser.inc'; include_once dirname(__FILE__) . '/ressources/class.rfc822.addresses.inc'; include_once dirname(__FILE__) . '/ressources/class.squid.categorize.generic.inc'; if ($argv[1] == "--push") { PushToRepo_alls(); exit; } GetIndex(); function GetIndex() { $WORKING_DIR = "/home/working_toulouse_databases"; $WORKING_DOWNLOAD = "{$WORKING_DIR}/dowloads"; $WORKING_UPLOAD = "{$WORKING_DIR}/uploads"; @mkdir($WORKING_DOWNLOAD, 0755, true); @mkdir($WORKING_UPLOAD, 0755, true); $unix = new unix(); $tar = $unix->find_program("tar"); $catz = new mysql_catz(); $tmpfile = $unix->FILE_TEMP(); $tmpdir = $unix->TEMP_DIR(); $rm = $unix->find_program("rm"); $mainuri = "ftp://ftp.univ-tlse1.fr/pub/reseau/cache/squidguard_contrib"; $EXEC_NICE = $unix->EXEC_NICE();
$currentSlide = filter_input(INPUT_POST, "slideNumber", FILTER_SANITIZE_NUMBER_INT); try { $pdo = DataBase::GetPDO(); } catch (Exception $error) { echo $error; } $pdo->setAttribute(PDO::ATTR_DEFAULT_FETCH_MODE, PDO::FETCH_OBJ); $sql = "SELECT * FROM `mkSlide` ORDER BY `priority` DESC, `id` ASC "; $sth = $pdo->prepare($sql); if (!$sth) { var_dump($pdo->errorInfo()); } else { $sth->execute(); } $res = $sth->fetchAll(); $index = GetIndex('id', $currentSlide, $res); $count = count($res); $loopCount = 0; //Check if any images to show do { if ($count - 1 <= $index) { $index = 0; } else { $index++; } } while (!InTimeArea($index, $res) && $count > $loopCount++); //the result mus be in time area. if ($loopCount > $count) { //No images to show } else { $json = json_encode($res[$index], true);
<?php include "SubIndex.php"; $db = new SQLite3('videoworld.sqlite'); $res = $db->query('SELECT id,title FROM movies'); $arr = array(); while ($row2 = $res->fetchArray(SQLITE3_ASSOC)) { $arr[$row2['id']] = GetIndex($row2['title']); } foreach ($arr as $id => $str_c02) { echo $str_c02; $stmt = $db->prepare('UPDATE movies SET idx_title=? WHERE id=?'); $stmt->bindParam(1, $str_c02); $stmt->bindParam(2, $id); $rc = $stmt->execute(); } $db->close();
<?php include "SubIndex.php"; $ofs = $_POST["ofs"]; $found = 0; $db = new SQLite3('MyVideos105.db'); $res = $db->query('SELECT idMovie,c00 FROM movie LIMIT 50 OFFSET ' . $ofs); $arr = array(); while ($row2 = $res->fetchArray(SQLITE3_ASSOC)) { $found = 1; $arr[$row2['idMovie']] = GetIndex($row2['c00']); } foreach ($arr as $idMovie => $str_c02) { echo $str_c02 . '<BR>'; $stmt = $db->prepare('UPDATE movie SET c02=? WHERE idMovie=?'); $stmt->bindParam(1, $str_c02); $stmt->bindParam(2, $idMovie); $rc = $stmt->execute(); } $db->close(); if ($found) { $ofs = $ofs + 50; echo '<script>$.post("' . $_SERVER['PHP_SELF'] . '",{ofs:' . $ofs . '},AppendBody);document.title = "Wait(' . $ofs . ') ...";</script>'; } else { echo '<script>document.title = "Ready!";</script>'; }