*
* 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');
$sqlWhere = implode("','", $excludeList);
