function getUser()
{
if (!isset($this->user)) {
return getlocalized("not_logged_in");
}
return $this->user;
}
function search($station, $author, $word, $from, $until, $language)
{
$sql = "SELECT * FROM sotf_programmes";
if ($station) {
if (array_search(getlocalized("every_station"), $station) === NULL) {
for ($stationcount = 0; $stationcount < count($station); $stationcount++) {
if ($stationcount != 0) {
$sqlstation = $sqlstation . " OR station='" . clean($station[$stationcount]) . "'";
} else {
$sqlstation = " (station='" . clean($station[0]) . "'";
}
}
$sqlstation = $sqlstation . ") ";
$where[] = $sqlstation;
} else {
unset($station);
unset($sqlstation);
}
}
if ($language) {
if (array_search(getlocalized("any_language"), $language) === NULL) {
for ($langcount = 0; $langcount < count($language); $langcount++) {
if ($langcount != 0) {
$sqllang = $sqllang . " OR language='" . clean($language[$langcount]) . "'";
} else {
$sqllang = " (language='" . clean($language[0]) . "'";
}
}
$sqllang = $sqllang . ") ";
$where[] = $sqllang;
}
}
if ($author) {
$where[] = " author ~* '.*" . clean($author) . ".*' ";
}
if ($word) {
$like = " '.*" . clean($word) . ".*' ";
$where[] = " (area ~* {$like} OR title ~* {$like} OR keywords ~* {$like} OR abstract ~* {$like}) ";
}
if ($from) {
$where[] = " production_date >= '" . clean($from) . "' ";
}
if ($until) {
$where[] = " production_date <= '" . clean($until) . "' ";
}
$where[] = " published='t' ";
// var_dump($where);
if ($where) {
$sql .= " WHERE " . join(" AND ", $where);
}
return $this->db->getAll($sql, DB_FETCHMODE_ASSOC);
}
}
if (!$contact_email) {
$error .= "&errorcontactemail=1";
}
if ($error) {
$page->redirect("editSeries.php?station=" . rawurlencode($station) . "&series_id=" . rawurlencode($series_id) . "&title=" . rawurlencode($title) . "&description=" . rawurlencode($description) . "&editor=" . rawurlencode($editor) . "&contact_email=" . rawurlencode($contact_email) . $error);
}
$ser->save();
if ($okURL) {
$page->redirect($okURL);
} else {
$page->redirect("listProgrammes.php?station=" . rawurlencode($station));
}
} elseif ($delete) {
$ser->delete();
$page->redirect("listProgrammes.php?station=" . rawurlencode($station));
}
$editor = $ser->get('editor');
if (!$editor) {
$editor = $user->name;
}
$contact_email = $ser->get('contact_email');
if (!$contact_email) {
$contact_email = $user->email;
}
$series_item = array(series_id => $ser->get('series_id'), title => $ser->get('title'), description => $ser->get('description'), editor => $editor, contact_email => $contact_email);
$smarty->assign('SERIES_ITEM', $series_item);
$page->send();
} else {
$page->halt(getlocalized('permission_error'));
}
if ($station != $station_old) {
$smarty->assign('STATUS', getlocalized(illegal_trackname));
} else {
sotf_Station::create($station, $desc);
$page->redirect("editStation.php?station={$station}");
}
} elseif ($delete) {
$st =& new sotf_Station($station);
$st->delete();
$smarty->assign('STATUS', $page->getlocalized('delete_ok'));
} elseif ($save) {
$st =& new sotf_Station($station);
$st->set('station', $station);
$st->set('description', $desc);
$st->save();
$smarty->assign('STATUS', getlocalized('save_ok'));
} elseif ($addstationmanager) {
if (sotf_Permission::addStationManager($username)) {
$smarty->assign('STATUS', $page->getlocalized('addstationmanager_ok'));
} else {
$smarty->assign('STATUS', $page->getlocalized('addstationmanager_failed'));
}
} elseif ($delstationmanager) {
if (sotf_Permission::delStationManager($username)) {
$smarty->assign('STATUS', $page->getlocalized('delstationmanager_ok'));
} else {
$smarty->assign('STATUS', $page->getlocalized('delstationmanager_failed'));
}
}
$users = sotf_Permission::getStationManagers();
if (count($users) > 0) {
