if ($sort2 == NULL) {
$sort2 = "title";
}
if ($series == NULL) {
$series = "allseries";
}
if ($filter == NULL) {
$filter = "all";
}
//$max = $db->getAll("SELECT count(*) FROM (".$query.") as count"); //get the number of results
//$max = $max[0]["count"];
$max = $myProgs = sotf_Programme::myProgrammes($series, $filter, $sort1 . ", " . $sort2, true);
//counts it
$limit = $page->splitList($max, "?series={$series}&filter={$filter}&sort1={$sort1}&sort2={$sort2}");
//$result = $db->getAll($query.$limit["limit"]);
$myProgs = sotf_Programme::myProgrammes($series, $filter, $sort1 . ", " . $sort2 . $limit["limit"]);
//$plist = new sotf_PrgList($myProgs);
//// todo sort/filter using sotf_PrgList
//$l = $plist->getList();
$mySeriesData = array();
$mySeriesData[allseries] = $page->getlocalized("allseries");
foreach (sotf_Permission::mySeriesData($stationId) as $s) {
$mySeriesData[$s["id"]] = $s["title"];
}
$sortby[title] = $page->getlocalized("title");
$sortby[series] = $page->getlocalized("series");
$sortby[station] = $page->getlocalized("station");
$sortby[entry_date] = $page->getlocalized("entry_date");
$sortby[expiry_date] = $page->getlocalized("expiry_date");
$sortby[published] = $page->getlocalized("published");
$filters[all] = $page->getlocalized("all");
if (sotf_Utils::getParameter('addprog')) {
$fname = sotf_Utils::getFileSafeParameter('fname');
$station = sotf_Utils::getFileSafeParameter('station');
if (!sotf_Permission::get('upload', $station)) {
raiseError("no permission to upload to {$station}");
exit;
}
$newPrg = sotf_Programme::create($station);
$newPrg->setAudio($fname);
//$page->redirect("editFiles.php");
$page->redirect($_SERVER['SCRIPT_NAME']);
exit;
}
$userFtpUrl = str_replace('ftp://', "ftp://{$userid}@", "{$userFTP}{$userid}");
$smarty->assign("USERFTPURL", $userFtpUrl);
$stations = sotf_Permission::listStationsWithPermission('upload');
if (!empty($stations)) {
$smarty->assign_by_ref("STATIONS", $stations);
}
$userAudioFiles = new sotf_FileList();
$userAudioFiles->getAudioFromDir($user->getUserDir());
$list = $userAudioFiles->getFileNames();
if (!empty($list)) {
$smarty->assign_by_ref("USER_AUDIO_FILES", $list);
}
$myProgs = sotf_Programme::myProgrammes($user->name);
$plist = new sotf_PrgList($myProgs);
// todo sort/filter using sotf_PrgList
$l = $plist->getList();
$smarty->assign_by_ref("MYPROGS", $l);
$page->send();
