/**
* For logging purposes
* @return array
*/
public function get_all_urls()
{
$db = nc_Core::get_object()->db;
$links = $db->get_col("SELECT `URL` FROM `Search_Link`");
foreach ($links as $i => $url) {
$links[$i] = nc_search_util::decode_url($url);
}
return $links;
}
return "<a href='" . htmlspecialchars($edit_link) . "' target='_blank'>" . NETCAT_MODULE_SEARCH_ADMIN_BROKEN_LINK_EDIT . "</a>";
}
// --------------------------------------------------------------- //
foreach ($res as $row) {
echo "<li>";
if ($group_by == 'referrer') {
echo "<b><a href='", htmlspecialchars($row['Referrer_URL']), "' target='_blank'>", $row['Title'] ? $row['Title'] : $row['Referrer_URL'], "</a></b> ", _edit_doc_link($row), "\n", "<ul>\n";
$where = $row["Referrer_Document_ID"] ? "`Referrer_Document_ID` = '{$row['Referrer_Document_ID']}'" : "`Referrer_URL` = '" . $db->escape($row["Referrer_URL"]) . "'";
$broken_links = $db->get_col("SELECT `URL`\n FROM `Search_BrokenLink`\n WHERE {$where}");
foreach ($broken_links as $link) {
echo "<li>" . nc_search_util::decode_url($link) . "</li>\n";
}
echo "</ul>\n";
} else {
// group by broken link URL
echo "<b>" . nc_search_util::decode_url($row['URL']) . "</b>\n<ul>";
$referrers = $db->get_results("SELECT l.`Referrer_URL`,\n doc.`Title`,\n doc.`Catalogue_ID`,\n doc.`Subdivision_ID`\n FROM `Search_BrokenLink` AS l\n LEFT JOIN `Search_Document` AS doc\n ON (l.`Referrer_Document_ID` = doc.`Document_ID`)\n WHERE l.`URL` = '" . $db->escape($row['URL']) . "'\n LIMIT {$max_referrer_links}", ARRAY_A);
foreach ($referrers as $n => $ref) {
echo "<li><b><a href='", htmlspecialchars($ref['Referrer_URL']), "' target='_blank'>", $ref['Title'] ? $ref['Title'] : $ref['Referrer_URL'], "</a></b> ", _edit_doc_link($ref), "</li>\n";
}
echo "</ul>\n";
if (count($referrers) == $max_referrer_links) {
echo "<div>", sprintf(NETCAT_MODULE_SEARCH_ADMIN_BROKEN_LINKS_REFERRER_LIMIT, $max_referrer_links), "</div>";
}
}
echo "</li>\n";
}
echo "</ul></div>";
// листалка по страницам
$page_link = $this->make_page_query(array('offset'), true);
if ($offset > 0) {
