//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; }