function get_search_collections()
{
extract(tep_load('defs', 'database', 'sessions'));
$cAbstract = new abstract_zones();
$classes_array = $cAbstract->get_classes();
foreach ($classes_array as $key => $value) {
$cObject = new $value();
}
$keywords = isset($_GET['search']) && !empty($_GET['search']) ? $db->prepare_input($_GET['search']) : '';
$text_query_raw = "select gtext_id, gtext_title from " . TABLE_GTEXT . " where (gtext_title like '%" . $db->input($keywords) . "%' or gtext_alt_title like '%" . $db->input($keywords) . "%') order by gtext_title limit 10";
$text_array = $db->query_to_array($text_query_raw);
$j = count($text_array);
if ($j) {
echo '<div><table class="tabledata">' . "\n";
for ($i = 0; $i < $j; $i++) {
echo '<tr>' . "\n";
echo ' <td><a href="' . tep_href_link(FILENAME_GENERIC_TEXT, 'gtID=' . $text_array[$i]['gtext_id'] . '&action=new_generic_text') . '">' . $text_array[$i]['gtext_title'] . '</a></td>' . "\n";
echo ' <td><a href="' . tep_href_link($cDefs->script, 'cID=' . $text_array[$i]['abstract_zone_id'] . '&action=list') . '">' . $text_array[$i]['abstract_zone_name'] . '</a></td>' . "\n";
echo '<tr>' . "\n";
}
echo '</table></div>' . "\n";
} else {
echo 'Nothing Found';
}
$cSessions->close();
return true;
}
