\n";
$order_by = [
'0' => ' DESC',
'1' => ' ASC',
];
$sortby = !empty(Search_Engine::get_param('order')) ? " ORDER BY link_name".$order_by[Search_Engine::get_param('order')] : '';
$limit = (Search_Engine::get_param('stype') != "all" ? " LIMIT ".Search_Engine::get_param('rowstart').",10" : '');
switch (Search_Engine::get_param('fields')) {
case 2:
Search_Engine::search_column('link_name', 'sitelinks');
Search_Engine::search_column('link_url', 'sitelinks');
Search_Engine::search_column('link_id', 'sitelinks');
break;
case 1:
Search_Engine::search_column('link_name', 'sitelinks');
Search_Engine::search_column('link_id', 'sitelinks');
break;
default:
Search_Engine::search_column('link_name', 'sitelinks');
}
if (!empty(Search_Engine::get_param('search_param'))) {
$query = "SELECT * FROM ".DB_SITE_LINKS.(multilang_table('SL') ? " WHERE link_language='".LANGUAGE."' AND " : " WHERE ")
.groupaccess('link_visibility')." AND link_url !='' AND link_name != '---' AND link_name != '===' AND link_status = '1' AND ".Search_Engine::search_conditions('sitelinks');
$param = Search_Engine::get_param('search_param');
$result = dbquery($query, $param);
if (dbrows($result)) {
$rows = dbrows($result);
} else {
$rows = 0;
}
if ($rows != 0) {
$default_link_data = [
"link_id" => 0,
"link_name" => "",
"link_cat" => 0,
"link_url" => "",
"link_icon" => "",
"link_class" => "",
"link_active" => '',
"link_title" => FALSE, // true to add dropdown-header class to li.
"link_disabled" => FALSE, // true to disable link
"link_window" => FALSE,
];
$item_count = "".$rows." ".($rows == 1 ? $locale['s401'] : $locale['s402'])." ".$locale['522']."
\n";
$result = dbquery($query.$sortby.$limit, $param);
$search_result = '';
$itemlink = '';
while ($link_data = dbarray($result)) {
$link_data += $default_link_data;
$link_data['link_name'] = parsesmileys(parseubb($link_data['link_name']));
if (!empty($link_data['link_url'])) {
if ($link_data['link_url'] == 'index.php') {
$link_data['link_url'] = fusion_get_settings('opening_page');
}
$itemlink = BASEDIR.$link_data['link_url'];
// if link has site protocol
if (preg_match("!^(ht|f)tp(s)?://!i", $link_data['link_url'])
or (BASEDIR !== '' && stristr($link_data['link_url'], BASEDIR))
) {
$itemlink = $link_data['link_url'];
}
}
$link_target = ($link_data['link_window'] == "1" ? " target='_blank'" : '');
$link_icon = (!empty($link_data['link_icon']) ? "\n" : "![](".IMAGES."loupe.svg "\".$link_data[")
");
$search_result .= strtr(Search::render_search_item(), [
'{%item_url%}' => $itemlink,
'{%item_target%}' => $link_target,
'{%item_image%}' => $link_icon,
'{%item_title%}' => $link_data['link_name'],
'{%item_description%}' => '',
]
);
}
// Pass strings for theme developers
$formatted_result = strtr(Search::render_search_item_wrapper(), [
'{%image%}' => "![".$locale[](".ImageRepo::getimage()
",
'{%icon_class%}' => "fa fa-sitemap fa-lg fa-fw",
'{%search_title%}' => $locale['s400'],
'{%search_result%}' => $item_count,
'{%search_content%}' => $search_result
]);
}
Search_Engine::search_navigation($rows);
Search_Engine::search_globalarray($formatted_result);
Search_Engine::append_item_count($item_count);
}
}