//the query
$smarty->assign("SQLquerySerial", $advsearch->Serialize());
//the serialized query
$smarty->assign("SQLqueryfields", $advsearch->GetSQLqueryfields($SQLquery));
//translated name for all rows of the query
$smarty->assign("EQdate", $advsearch->GetEQdate());
//EQ dropdown for date
$smarty->assign("EQstring", $advsearch->GetEQstring());
//EQ dropdown for string
$smarty->assign("EQlang", $advsearch->GetEQlang());
//EQ dropdown for lang
$smarty->assign("EQlength", $advsearch->GetEQlength());
//EQ dropdown for length
$smarty->assign("Languages", $advsearch->GetLanguages());
//all possible languages
$smarty->assign("Stations", sotf_Station::listStationNames());
//all possible stationnames
$smarty->assign("SQLstring", $SQLstring);
//selected values
//box 1
$smarty->assign("SQLfields", $advsearch->GetSQLfields());
//name of all possibble columns
$smarty->assign("SQLfieldDefault", key($advsearch->GetSQLfields($SQLquery)));
//set default selected to the first element
//box 2
$smarty->assign("sort1", $advsearch->GetSort1());
//current sort1
$smarty->assign("sort2", $advsearch->GetSort2());
//current sort2
//box 3
$smarty->assign("saved", $saved[example] = "Example");
if ($data['numNodes'] == 0) {
$data['numNodes'] = 1;
}
$data['numStations'] = sotf_Station::countAll();
$data['numProgs'] = sotf_Programme::countAll();
$data['numProgs'] = sotf_Programme::countAll();
$allStats = sotf_Statistics::networkStats();
$allStats['l_and_d'] = $allStats['listens'] + $allStats['downloads'];
$data['access'] = $allStats;
$fileStats = sotf_Programme::getFileStats();
$fileStats['size_mb'] = sprintf('%d', $fileStats['filesize'] / 1024 / 1024);
$fileStats['length_hour'] = sprintf('%d', $fileStats['play_length'] / 60 / 60);
$data['files'] = $fileStats;
$data['numUsers'] = sotf_User::countUsers();
$smarty->assign($data);
$smarty->assign('STATIONS', sotf_Station::listStationNames());
$searchLangs = $config['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']);
$dayInThePast = time() - 60 * 60 * 24 * 30;
// 30 days back
$fromDay = date('Y-m-d', $dayInThePast);
if ($page->loggedIn()) {
// get users's playlist
$playlist = new sotf_UserPlaylist();
function GetStations()
{
$stationsarray = sotf_Station::listStationNames();
$max = count($stationsarray);
for ($i = 0; $i < $max; $i++) {
$Stations[$stationsarray[$i][name]] = $stationsarray[$i][name];
}
return $Stations;
}
