<?php
require "init.inc.php";
$page->forceLogin();
$playlist = new sotf_Playlist();
if (sotf_Utils::getParameter("close") == "true") {
$lista = sotf_Utils::getParameter("lista");
$list = split("\\|", $lista);
$max = count($list);
for ($i = 1; $i < $max; $i++) {
$l = split(":", $list[$i]);
if ($l[1] != $i) {
//print($l[0].":".$l[1]." -> ".$i."<br>");
$playlist->setOrder($l[0], $i);
}
}
$page->redirect("closeAndRefresh.php");
//die("<HTML><HEAD></HEAD><BODY onload='javascript:window.opener.location.reload();window.close();'></BODY></HTML>");
}
$result = $playlist->load();
$programmes = array();
foreach ($result as $value) {
$programmes[$value["id"] . ":" . $value["order_id"]] = $value["title"];
}
$smarty->assign("result", $result);
$smarty->assign("count", count($result));
$smarty->assign("programmes", $programmes);
$page->sendPopup("playlistPopup.htm");
$smarty->assign($data);
$smarty->assign('STATIONS', sotf_Station::listStationNames());
$searchLangs = $languages;
array_unshift($searchLangs, "any_language");
for ($i = 0; $i < count($searchLangs); $i++) {
$langNames[$i] = $page->getlocalized($searchLangs[$i]);
}
$smarty->assign('searchLangs', $searchLangs);
$smarty->assign('langNames', $langNames);
$now = getDate();
$dayInThePast = mktime(0, 0, 0, $now['mon'], $now['mday'] - 10, $now['year']);
$fromDay = date('Y-m-d', $dayInThePast);
if ($page->loggedIn()) {
// get playlist
$playlist = new sotf_Playlist();
$smarty->assign('PLAYLIST', $playlist->load());
// check if user has default query
$advsearch = new sotf_AdvSearch();
$prefs = $user->getPreferences();
$defQuery = $prefs->getDefaultQuery();
}
// show default query instead of new programmes
if ($defQuery) {
$smarty->assign("DEF_QUERY", 1);
debug("default query", $defQuery);
$advsearch->Deserialize($defQuery);
$query = $advsearch->GetSQLCommand();
debug("query", $query);
//get the number of results
$max = $db->getOne("SELECT count(*) FROM ( {$query} ) as foo ");
$smarty->assign("DEF_QUERY_MAX", $max);
