1. A search functionality/script for the website that can search a single word or a combination of words (phrase) or any of the keywords entered, in any language (english, german, spanish, greek, etc). There will be magnifying glass in the website navigation menu, user enters his search word/words/phrase and hits "search". It will take him to i.e. [login to view URL] page where the results will be presented.
2. The results should be presented in the results page one under the other and for each results we show the meta-description, then i.e X amount of characters before the matched search term that is highlighted and Y amount of characters after the searched term and below to show the actual webpage link so user can click to go that page. The results page to have a pagination where the results per page can be set in the script in advance and also have information like ("Your search for <search-term> matched yyyy records").
3. The functionality should be able to search both the database tables (MySQL) and also within the static files of the website (.asp, .txt, etc) and combine the results according to the search hit rate. From the script/code, I should be able to predefine the MySQL tables and columns to be searched and also be able to exclude entire folders and individual files from the search. For instance, folders like /images/, /uploads/, /admin/ and files like [login to view URL], [login to view URL] etc to be excluded from the search. User will not be able to select which tables or files. User just sees the search box and nothing else.
4. There is no need for login, roles and permissions. I am in position to edit the ASP code and define which folders, MySQL tables and individual files i wish to include or exclude from the search. If we can have these as variables, even better. So we can just add or delete folders/files as needed. The website is currently in 4 languages (english, german, italian, spanish and we will add greek as well). We have separate folders for each language and each have static .asp pages and dynamic reading from the database. In the DB we already save content in all 4 languages for each entry, for instance columns like"Title", "Summary", "Description" etc.