"14", "RadioVelo" => "15", "SportsAndNews" => "9", "letop" => "22" ); //association dossiers emissions avec id flux podcasts $showsname = array( "IVYADS" => "Il Va Y Avoir Du Sport", "RadioVelo" => "Radio Vélo", "SportsAndNews" => "Sports And News", "letop" => "Le Top" ); //association emissions avec id flux podcasts db_conn(); foreach ($showsid as $a => $b) { foreach (glob("$a", GLOB_ONLYDIR) as $directory) { echo $directory; $fluxrssid = $showsid[$directory]; echo $fluxrssid; $files = scandir($directory, 1); $newest_file = $files[0]; $filename = $directory."/".$newest_file; $filepath = $pathto.$directory."/".$newest_file; $queryfiletest = "SELECT * FROM `jom_podcastmanager` WHERE `filename`='$filepath'"; $sqlfiletest = mysql_query($queryfiletest); $filetest = mysql_fetch_object($sqlfiletest); $podcastexist = mysql_num_rows($sqlfiletest); if ($podcastexist==0) { echo "podcast to create
"; if (file_exists($filename)) { $filedate = date("Y-m-d H:i:s", filemtime($filename)); $fileday = date("d/m/Y", filemtime($filename)); echo "$newest_file add the : ".$filedate."\n"; $mp3file = new MP3File($filename); //$duration1 = $mp3file->getDurationEstimate();//(faster) for CBR only $duration2 = $mp3file->getDuration();//(slower) for VBR (or CBR) //echo "duration: $duration1 seconds"."\n"; echo "estimate: $duration2 seconds"."\n"; $timeduration = MP3File::formatTime($duration2); echo $timeduration; echo "
"; $queryfeedname = "SELECT * FROM `jom_podcastmanager_feeds` WHERE `id`='$fluxrssid'"; $sqlfeedname = mysql_query($queryfeedname); $resultfeedname = mysql_fetch_object($sqlfeedname); $feedname = $resultfeedname->name; $title = $feedname." - ".$fileday; $alias = strtolower(str_replace(" ","-",$title)); $queryaddpodcast = "INSERT INTO `jom_podcastmanager`(`id`, `asset_id`, `filename`, `feedname`, `title`, `alias`, `published`, `created`, `created_by`, `publish_up`, `itAuthor`, `itDuration`, `mime`, `language`) VALUES (DEFAULT, '', '$filepath', '$fluxrssid', '$title', '$alias', '1', '$filedate', '$creator', '$filedate', '$itauthor', '$timeduration', '$mime', '$language')"; $sqladdpodcast = mysql_query($queryaddpodcast); } } else { echo "podcast already exist
"; } } } db_close($opened_db); ?>