//if ($SQLquerySerial == "") //get old search query from session if none in url
// $SQLquerySerial = $_SESSION["SQLquerySerial"]; //get array from session
$SQLquery = $advsearch->Deserialize($SQLquerySerial);
//deserialize the content of the hidden field
if (sotf_Utils::getParameter('back') != NULL) {
$_SESSION["SQLquerySerial"] = $SQLquerySerial;
//save the new quey to the session
$page->redirect("advsearch.php");
}
$query = $advsearch->GetSQLCommand();
$max = $db->getAll("SELECT count(*) FROM (" . $query . ") as count");
//get the number of results
$max = $max[0]["count"];
$limit = $page->splitList($max, "?SQLquerySerial={$SQLquerySerial}");
$result = $db->getAll($query . $limit["limit"]);
$allfields = $advsearch->GetSQLfields();
//get all possible fileld names with translation
$max = count($SQLquery);
//$fields will contain all the USED field names
for ($i = 0; $i < $max; $i++) {
$fields[$SQLquery[$i][1]] = $allfields[$SQLquery[$i][1]];
}
//$fields[$advsearch->GetSort1()] = $allfields[$advsearch->GetSort1()];
//$fields[$advsearch->GetSort2()] = $allfields[$advsearch->GetSort2()];
$fields[$advsearch->GetSort1()] = $page->getlocalized($advsearch->GetSort1());
$fields[$advsearch->GetSort2()] = $page->getlocalized($advsearch->GetSort2());
if (array_key_exists("title", $fields)) {
$fields[alternative_title] = $page->getlocalized("alternative_title");
//if title presented this two
$fields[episode_title] = $page->getlocalized("episode_title");
//fields are needed as well
$smarty->assign("EQlength", $advsearch->GetEQlength());
//EQ dropdown for length
$smarty->assign("EQnumber", $advsearch->GetEQnumber());
//EQ dropdown for numbers
$smarty->assign("Languages", $advsearch->GetLanguages());
//all possible languages
$smarty->assign("Stations", $advsearch->GetStations());
//all possible stationnames
$smarty->assign("Genres", $advsearch->GetGenres());
//all possible genrenames
$smarty->assign("Ratings", $advsearch->getRatings());
//all possible ratings + a half value between all
$smarty->assign("SQLstring", $SQLstring);
//selected values
//box 1
$smarty->assign("SQLfields", $advsearch->GetSQLfields());
//name of all possibble columns
$smarty->assign("SQLfieldDefault", key($advsearch->GetSQLfields()));
//set default selected to the first element
//box 2
$smarty->assign("OrderFields", $advsearch->getOrderFields());
//name of all possibble columns
$smarty->assign("sort1", $advsearch->GetSort1());
//current sort 1
$smarty->assign("sort2", $advsearch->GetSort2());
//current sort 2
$smarty->assign("dir1", $advsearch->getDir1());
//current sort dir 1
$smarty->assign("dir2", $advsearch->getDir2());
//current sort dir 2
if ($portal_http == "") {
