//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 == "") { $portal_http = NULL; } if (isset($portal_http)) { if (substr($portal_http, 0, 7) != "http://") { $portal_http = "http://" . $portal_http; } $smarty->assign("old_upload", $portal_http);
$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 } else { $fields[title] = $page->getlocalized("title"); } //the title field always need to be present $selected = array(); $max = count($result); for ($i = 0; $i < $max; $i++) { foreach ($result[$i] as $key => $value) { if (array_key_exists($key, $fields) and $key != 'title') {
$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()]; 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 } else { $fields[title] = $page->getlocalized("title"); } //the title field always need to be present $selected = array(); $max = count($result); for ($i = 0; $i < $max; $i++) { foreach ($result[$i] as $key => $value) { if (array_key_exists($key, $fields) and $key != 'title') {