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();