function askSuggestions()
{
//header("Content-type: text/xml;charset=iso-8859-7");
$ie = isset($_GET['ie']) ? true : false;
$search_results_data = array();
$search_results_forum = array();
$search_results_pmsgs = array();
$results = EfrontSearch::searchFull('');
//$res = eF_getTableData("users_to_lessons", "lessons_ID", "users_LOGIN='******'s_login']."'");
$res = eF_getTableData("users_to_lessons,lessons", "lessons_ID", "users_to_lessons.archive=0 and lessons.archive=0 and users_LOGIN='******'s_login'] . "' and lessons.active=1 and lessons.id=users_to_lessons.lessons_ID");
// na min emfanizontai ta deactivated lessons
for ($i = 0; $i < sizeof($res); $i++) {
$lessons_have[] = $res[$i]['lessons_ID'];
}
$have_results = false;
if ($results) {
for ($i = 0; $i < sizeof($results); $i++) {
if ($results[$i]['table_name'] == "comments") {
$res1 = eF_getTableData("content,comments", "content.name AS name,content.id AS id,content.lessons_ID AS lessons_ID", "comments.content_ID=content.id AND comments.id=" . $results[$i]['foreign_ID']);
$type_str = _COMMENTS;
} elseif ($results[$i]['table_name'] == "news") {
$res1 = eF_getTableData($results[$i]['table_name'], "id,title AS name,lessons_ID", "id=" . $results[$i]['foreign_ID']);
$type_str = _ANNOUNCEMENTS;
} elseif ($results[$i]['table_name'] == "content") {
$res1 = eF_getTableData($results[$i]['table_name'], "id,name,lessons_ID,ctg_type", "id=" . $results[$i]['foreign_ID']);
$type_str = _LESSONCONTENT;
} elseif ($results[$i]['table_name'] == "f_messages") {
$res1 = eF_getTableData("f_messages, f_topics, f_forums", "f_forums.id as category_id, f_forums.lessons_ID, f_messages.id, f_messages.title, f_messages.f_topics_ID, f_topics.title as topic_title", "f_topics_ID = f_topics.id and f_forums.id = f_forums_ID and f_messages.id=" . $results[$i]['foreign_ID']);
$type_str = _MESSAGESATFORUM;
} elseif ($results[$i]['table_name'] == "f_personal_messages") {
$res1 = eF_getTableData("f_personal_messages, f_folders", "f_personal_messages.id, f_personal_messages.title, f_personal_messages.users_LOGIN, f_folders.name, f_folders.id as folder_id", "f_personal_messages.f_folders_ID = f_folders.id and f_personal_messages.id=" . $results[$i]['foreign_ID']);
$type_str = _MESSAGESATFORUM;
} elseif ($results[$i]['table_name'] == "lessons") {
$res1 = eF_getTableData($results[$i]['table_name'], "id as lessons_ID,name", "id=" . $results[$i]['foreign_ID'] . " and active=1");
$type_str = _LESSON;
} elseif ($results[$i]['table_name'] == "f_topics") {
$res1 = $res1 = eF_getTableData("f_messages, f_topics, f_forums", "f_forums.id as category_id, f_forums.lessons_ID, f_messages.id, f_messages.title, f_messages.f_topics_ID, f_topics.title as topic_title", "f_topics_ID = f_topics.id and f_forums.id = f_forums_ID and f_topics.id=" . $results[$i]['foreign_ID']);
$type_str = _MESSAGESATFORUM;
}
//print_r($res1);
if (sizeof($res1) > 0) {
$results[$i]['position'] == "title" ? $position_str = _TITLE : ($position_str = _TEXT);
if (isset($res1[0]['lessons_ID']) && in_array($res1[0]['lessons_ID'], $lessons_have)) {
$lesson = eF_getTableData("lessons", "name", "id=" . $res1[0]['lessons_ID']);
if ($results[$i]['table_name'] != 'f_messages' && $results[$i]['table_name'] != 'f_topics') {
if ($results[$i]['table_name'] == "lessons") {
$search_results_data[] = array('id' => $res1[0]['id'], 'name' => $res1[0]['name'], 'table_name' => $results[$i]['table_name'], 'lessons_ID' => $res1[0]['lessons_ID'], 'lesson_name' => $lesson[0]['name'], 'score' => sprintf("%.0f %%", $results[$i]['score'] * 100), 'type' => $type_str, 'position' => $position_str);
} elseif ($results[$i]['table_name'] != "lessons") {
//echo $res1[0]['id']."->".eF_isDoneContent($res1[0]['id']);
$search_results_data[] = array('id' => $res1[0]['id'], 'name' => $res1[0]['name'], 'table_name' => $results[$i]['table_name'], 'lessons_ID' => $res1[0]['lessons_ID'], 'lesson_name' => $lesson[0]['name'], 'ctg_type' => $res1[0]['ctg_type'], 'score' => sprintf("%.0f %%", $results[$i]['score'] * 100), 'type' => $type_str, 'position' => $position_str);
}
} else {
$search_results_forum[] = array('category_id' => $res1[0]['category_id'], 'lesson_name' => $lesson[0]['name'], 'topic_subject' => $res1[0]['topic_title'], 'topic_id' => $res1[0]['f_topics_ID'], 'message_subject' => $res1[0]['title'], 'message_id' => $res1[0]['id'], 'position' => $position_str);
}
} elseif ($results[$i]['table_name'] == 'f_personal_messages' && $_SESSION['s_login'] == $res1[0]['users_LOGIN']) {
$search_results_pmsgs[] = array('message_subject' => $res1[0]['title'], 'message_id' => $res1[0]['id'], 'folder_name' => $res1[0]['name'], 'folder_id' => $res1[0]['folder_id'], 'position' => $position_str);
}
}
}
}
echo "<?xml version=\"1.0\" ?>";
echo "<root>";
echo "<search_results_data>";
foreach ($search_results_data as $key => $value) {
echo "<search_result_data>";
echo "<id>" . $value['id'] . "</id>";
echo "<name>" . $value['name'] . "</name>";
echo "<table_name>" . $value['table_name'] . "</table_name>";
echo "<lessons_ID>" . $value['lessons_ID'] . "</lessons_ID>";
echo "<lesson_name>" . $value['lesson_name'] . "</lesson_name>";
echo "<score>" . $value['score'] . "</score>";
echo "<type>" . $value['type'] . "</type>";
echo "<position>" . $value['position'] . "</position>";
echo "</search_result_data>";
}
echo "</search_results_data>";
/*
for($i=0;$i<sizeof($result);$i++)
{
$name = str_replace("&","&",$result[$i]['name']);
$url = str_replace("&","&",$result[$i]['url']);
$id = $result[$i]['id'];
echo "<bookmark>";
if($ie)
{
echo "<name>".$name."</name>";
echo "<url>".$url."</url>";
echo "<id>".$id."</id>";
}
else
{
echo "<name>".iconv("UTF-8","ISO-8859-7",$name)."</name>";
echo "<url>".iconv("UTF-8","ISO-8859-7",$url)."</url>";
echo "<id>".$id."</id>";
}
echo "</bookmark>";
}
echo "</bookmarks>";
}
*/
echo "</root>";
}
$lesson_names = array();
$tmp_data = array();
$results = array();
$search_results_files = array();
$cr = explode(" ", $_POST['search_text']);
$crTemp = array();
//since search is done by words with length>3, criteria must be also remove other words.This must go in search.class.php methods in future
for ($i = 0; $i < sizeof($cr); $i++) {
if (mb_strlen($cr[$i]) > 3) {
$crTemp[] = $cr[$i];
}
}
$cr = $crTemp;
//Added to avoid problems with strings that contained single quotes
$searchText = htmlspecialchars($_POST['search_text'], ENT_QUOTES);
$results = EfrontSearch::searchFull($searchText);
$lessons_have = $courses_have = null;
$currentUser = EfrontUserFactory::factory($_SESSION['s_login']);
//Get active lessons of this user
$currentUser->applyRoleOptions();
if ($currentUser instanceof EfrontLessonUser) {
$smarty->assign("T_CURRENT_USER", $currentUser);
$userLessons = $currentUser->getLessons(true);
foreach ($userLessons as $key => $value) {
if (!$value->lesson['active']) {
unset($userLessons[$key]);
} else {
$lessons_have[] = $value->lesson['id'];
}
}
$userCourses = $currentUser->getUserCourses();