//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 == "") {