* Handle parameter --remove * * Remove local videos that have already been deleted */ if ($removeVideos) { $sql = <<<SQL \t\tSELECT video_title \t\tFROM video_info \t\tLEFT JOIN image ON video_info.video_title = image.img_name \t\tWHERE image.img_name is null AND video_info.premium = 0 SQL; $result = $db->query($sql, __METHOD__); while ($row = $db->fetchObject($result)) { printText("Deleted video (local): {$row->video_title}"); if (!$dryrun) { $video->setVideoTitle($row->video_title); $video->deleteVideo(); } printText("..... DELETED.\n"); $removed++; } echo "Total deleted videos removed: {$removed}\n"; } /** * Handle parameter --add * * Add videos to the video_info table that are already on the wiki */ if ($addVideos) { // get embedded videos (premium) $excludeList = array('png', 'gif', 'bmp', 'jpg', 'jpeg', 'ogg', 'ico', 'svg', 'mp3', 'wav', 'midi');