{$cm_text["searchterm"]}:

"; $cm_searched_string = str_replace ("'", "", $cm_searched_string); $cm_searched_string = str_replace ("\"", "", $cm_searched_string); $cm_searched_string = str_replace (",", "", $cm_searched_string); $cm_searched_string = str_replace ("*", "", $cm_searched_string); $cm_searched_string = str_replace (";", "", $cm_searched_string); $cm_searched_string = str_replace ("(", "", $cm_searched_string); $cm_searched_string = str_replace (")", "", $cm_searched_string); $cm_searched_string = trim ($cm_searched_string); if ($cm_searched_string) { $cm_searched_string = fcm_htmlentity ($cm_searched_string); $result1 = db_query("select cmdb_type, cmdb_directory, cmdb_title, cmdb_viewer_group, cmdb_keywords, cmdb_date_update, cmdb_abstract, cmdb_content, cmdb_logo from " . CM_DB_PREFIX . "content3 where (cmdb_directory like '%$cm_searched_string%' or cmdb_title like '%$cm_searched_string%' or cmdb_viewer_group like '%$cm_searched_string%' or cmdb_keywords like '%$cm_searched_string%' or cmdb_abstract like '%$cm_searched_string%' or cmdb_content like '%$cm_searched_string%') and cmdb_type like '%" . CM_HITTYPE_PAGE . "%' " . fcm_access_sqldef ($user_kurz) ) or db_die(); $cm_total_searchres = 0; while (($row1 = db_fetch_row($result1)) && ($cm_total_searchres < $cm_max_searchres)) { fcm_articlelist_box ($row1[1], $row1[2], $row1[6], $row1[5], false, fcm_get_totalcomments ($row1[1]), fcm_get_totalhits ($row1[1], CM_HITTYPE_PAGE), fcm_getaverage_rating ($row1[1]), fcm_is_cleditable ($row1[1], $user_kurz, $row1[0]), stristr ($row1[0], CM_HITTYPE_ANNOUNCE), $row1[8], true); $cm_total_searchres++; } $result1 = db_query("select " . CM_DB_PREFIX . "content3.cmdb_type, " . CM_DB_PREFIX . "content3.cmdb_directory, " . CM_DB_PREFIX . "content3.cmdb_title, " . CM_DB_PREFIX . "content3.cmdb_viewer_group, " . CM_DB_PREFIX . "content3.cmdb_keywords, " . CM_DB_PREFIX . "content3.cmdb_date_update, " . CM_DB_PREFIX . "content3.cmdb_abstract, " . CM_DB_PREFIX . "content3.cmdb_content, " . CM_DB_PREFIX . "cmcomments3.cmdb_directory, " . CM_DB_PREFIX . "cmcomments3.cmdb_title, " . CM_DB_PREFIX . "cmcomments3.cmdb_comment, " . CM_DB_PREFIX . "content3.cmdb_logo from " . CM_DB_PREFIX . "content3, " . CM_DB_PREFIX . "cmcomments3 where (" . CM_DB_PREFIX . "cmcomments3.cmdb_comment like '%$cm_searched_string%' or " . CM_DB_PREFIX . "cmcomments3.cmdb_title like '%$cm_searched_string%') and " . CM_DB_PREFIX . "cmcomments3.cmdb_directory like " . CM_DB_PREFIX . "content3.cmdb_directory and " . CM_DB_PREFIX . "content3.cmdb_type like '%" . CM_HITTYPE_PAGE . "%' " . fcm_access_sqldef ($user_kurz) ) or db_die(); while (($row1 = db_fetch_row($result1)) && ($cm_total_searchres < $cm_max_searchres)) { fcm_articlelist_box ($row1[1], $row1[2], $row1[6], $row1[5], false, fcm_get_totalcomments ($row1[1]), fcm_get_totalhits ($row1[1], CM_HITTYPE_PAGE), fcm_getaverage_rating ($row1[1]), fcm_is_cleditable ($row1[1], $user_kurz, $row1[0]), stristr ($row1[0], CM_HITTYPE_ANNOUNCE), $row1[11], true); $cm_total_searchres++; } if ($cm_total_searchres < 1) { fcm_message ("{$cm_text["nosearchreswith"]} \"$cm_searched_string\".", CM_MSGSTYLE_INFORMATION); } } //else { // fcm_message ("{$cm_text["nosearchreswith"]} \"$cm_searched_string\".", CM_MSGSTYLE_INFORMATION); //} echo $cm_html_footer; ?>