/** * 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) {