//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') {
