while ($row = $db->fetchRow($result)) { $videoTitle = $row['img_name']; echo "\n[Total: {$total} ({$cnt} of {$subTotal})] Video: {$videoTitle}\n"; // add URLs of pages where they are embedded for each video title $query = new GlobalUsageQuery($videoTitle); $query->execute(); $globalUsages = $query->getSingleImageResult(); if (empty($globalUsages)) { $video = array($videoTitle, ''); writeToFile($video); } else { foreach ($globalUsages as $wiki => $articles) { echo "\tGlobalUsages: Wiki: {$wiki}\n"; foreach ($articles as $article) { echo "\t\tArticle: Namespace:{$article['namespace']}, Name:{$article['title']}\n"; $url = rtrim(WikiFactory::DBtoURL($article['wiki']), '/'); $title = Title::newFromText($article['title'], $article['namespace_id']); if ($title instanceof Title) { $url .= $title->getLocalURL(); echo "\t\t\tURL: {$url}\n"; } $video = array($videoTitle, $url); writeToFile($video); $totalEmbed++; } } } $lastTitle = $row['img_name']; $cnt++; $total++; }