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++;
}
