protected function setupTemplate()
{
global $cfg;
parent::setupTemplate();
$db = Database::getInstance($cfg['DPS']['dsn']);
$count_query = "SELECT count(*) FROM requests";
$requestedNum = $db->getOne($count_query);
$query = "SELECT * FROM requests ORDER BY date DESC";
$requestedResult = $db->getAll($query);
$i = 0;
foreach ($requestedResult as $key => &$track) {
$track['number'] = $i;
$track['rtime'] = date("m/d/y", $track['date']);
$track['user'] = AuthUtil::getUsername($track['userid']);
$i++;
}
$trackCount = $i;
$auth = Auth::getInstance();
$userID = $auth->getUserID();
$this->assign('CensorTrack', AuthUtil::getDetailedUserrealmAccess(array(3, 21, 30), $userID));
$this->assign('RequestTrack', 't');
$this->assign('RemoveRequestTrack', AuthUtil::getDetailedUserrealmAccess(array(3, 21, 29), $userID));
$this->assign('Admin', AuthUtil::getDetailedUserrealmAccess(array(1), $userID));
$this->assign('requestedTracks', $requestedResult);
$this->assign('requestedNum', $requestedNum);
}
protected function setupTemplate()
{
global $cfg;
parent::setupTemplate();
$db = Database::getInstance($cfg['DPS']['dsn']);
$trackIDs = explode(";", $this->fieldData['trackID']);
$tracksDetails = array();
foreach ($trackIDs as $trackID) {
$sql = "SELECT audio.*, albums.name AS album \n\t\t\tFROM audio, albums \n\t\t\tWHERE audio.music_album = albums.id \n\t\t\t\tAND audio.id = " . pg_escape_string($trackID);
$trackDetails = $db->getRow($sql);
$sql = "SELECT DISTINCT artists.name AS name \n\t\t\tFROM artists, audioartists \n\t\t\tWHERE audioartists.audioid = " . pg_escape_string($trackID) . " \n\t\t\t\tAND audioartists.artistid = artists.id";
$trackDetails['artist'] = $db->getColumn($sql);
$sql = "SELECT DISTINCT keywords.name AS name \n\t\t\tFROM keywords, audiokeywords \n\t\t\tWHERE audiokeywords.audioid = " . pg_escape_string($trackID) . " \n\t\t\t\tAND audiokeywords.keywordid = keywords.id";
$trackDetails['keywords'] = $db->getColumn($sql);
$samples = $trackDetails['length_smpl'];
$trackDetails['length'] = $tracksLen = round($samples / 44100 / 60) . "mins " . $samples / 44100 % 60 . "secs.";
$sql = "SELECT * FROM audiocomments \n\t\t\tWHERE audioid = " . pg_escape_string($trackID) . " \n\t\t\tORDER BY creationdate ASC";
$trackDetails['comments'] = $db->getAll($sql);
foreach ($trackDetails['comments'] as &$comment) {
$comment['username'] = AuthUtil::getUsername($comment['userid']);
$comment['comment'] = str_replace("\n", "<br>", $comment['comment']);
$comment['ctime'] = substr($comment['creationdate'], 0, 10);
}
$tracksDetails[] = $trackDetails;
}
$auth = Auth::getInstance();
$userID = $auth->getUserID();
$this->assign('RequestTrack', AuthUtil::getDetailedUserrealmAccess(array(3, 21, 29), $userID));
$this->assign('Access_CommentTrack', AuthUtil::getDetailedUserrealmAccess(array(3, 21, 34), $userID));
$this->assign('Access_EditTrack', AuthUtil::getDetailedUserrealmAccess(array(3, 21, 27), $userID));
$this->assign('Admin', AuthUtil::getDetailedUserrealmAccess(array(1), $userID));
$this->assign('tracksDetails', $tracksDetails);
}
protected function setupTemplate()
{
global $cfg;
parent::setupTemplate();
$db = Database::getInstance($cfg['DPS']['dsn']);
$scriptID = pg_escape_string($this->fieldData['scriptID']);
$auth = Auth::getInstance();
$userID = $auth->getUserID();
$date = time();
if (is_numeric($scriptID)) {
$script_query = "SELECT bit_or(permissions) \n\t\t\t\tFROM v_tree_script\n\t\t\t\tWHERE id = {$scriptID}\n\t\t\t\t\tAND userid = {$userID}";
$checkScripts = $db->getOne($script_query);
if (substr($checkScripts, 0, 1) == "1") {
if (substr($checkScripts, 1, 1) == "1") {
$this->assign('write', 't');
} else {
$this->assign('write', 'f');
}
$script_sql = "SELECT * FROM scripts WHERE id = " . $scriptID;
$script = $db->getRow($script_sql);
$script['m'] = (int) ($script['length'] / 60);
$script['s'] = $script['length'] - $script['m'] * 60;
$script['niceProducer'] = AuthUtil::getUsername($script['creator']);
$this->assign('script', $script);
} else {
$this->assign('error', 'You do not have permission to edit that script.');
}
} else {
$this->assign('error', 'Invalid Show ID supplied');
}
$this->assign('Admin', AuthUtil::getDetailedUserrealmAccess(array(1), $userID));
}
protected function setupTemplate()
{
global $cfg;
parent::setupTemplate();
$db = Database::getInstance($cfg['DPS']['dsn']);
$auth = Auth::getInstance();
$userID = $auth->getUserID();
$audioID = pg_escape_string($this->fieldData['audioID']);
$sql = "SELECT jinglepkgid FROM audiojinglepkgs WHERE audioid = {$audioID}";
$jinglepkgID = $db->getOne($sql);
$sql = "SELECT name FROM jinglepkgs WHERE id = {$jinglepkgID}";
$currentpkg = $db->getOne($sql);
if ($currentpkg == '') {
$currentpkg = 'Default';
}
$sql = "SELECT title FROM audio WHERE id = {$audioID}";
$jinglename = $db->getOne($sql);
$sql = "SELECT name, id FROM jinglepkgs";
$jinglepkgs = $db->getAll($sql);
$this->assign('access_playlist', AuthUtil::getDetailedUserrealmAccess(array(3, 21, 33), $userID));
$this->assign('access_sue', AuthUtil::getDetailedUserrealmAccess(array(24, 20, 3), $userID));
$this->assign('Admin', AuthUtil::getDetailedUserrealmAccess(array(1), $userID));
$this->assign('jinglepkgs', $jinglepkgs);
$this->assign('currentpkg', $currentpkg);
$this->assign('currentpkgid', $jinglepkgID);
$this->assign('jinglename', $jinglename);
$this->assign('jingleID', $audioID);
}
protected function setupTemplate()
{
global $cfg;
parent::setupTemplate();
$db = Database::getInstance($cfg['DPS']['dsn']);
$auth = Auth::getInstance();
$userID = $auth->getUserID();
$loc = 1;
$sql = "SELECT v_tree_aw_sets.*, aw_sets_users.user_id AS userid\n from v_tree_aw_sets LEFT OUTER JOIN aw_sets_users\n ON aw_sets_users.set_id = v_tree_aw_sets.id\n\t\t\tWHERE v_tree_aw_sets.userid = " . $cfg['DPS']['systemUserID'] . " \n\t\t\t\tAND v_tree_aw_sets.permissions & B'" . $cfg['DPS']['fileR'] . "' = '" . $cfg['DPS']['fileR'] . "'";
// station awsets
$awsets = $db->getAll($sql);
$sql = "SELECT val FROM configuration \n\t\t\tWHERE location = {$loc} \n\t\t\t\tAND parameter = 'station_aw_set'";
$userset = $db->getOne($sql);
foreach ($awsets as &$awset) {
if ($userset == $awset['id']) {
$awset['active'] = 't';
} else {
$awset['active'] = 'f';
}
$sql = "SELECT BIT_OR(permissions) \n\t\t\t\tFROM v_tree_dir \n\t\t\t\tWHERE v_tree_dir.id = {$awset['parent']}\n\t\t\t\t\tAND v_tree_dir.userid = {$cfg['DPS']['systemUserID']}";
$awset['parentperm'] = $db->getOne($sql);
$awset['userid'] = AuthUtil::getUsername($awset['userid']);
}
$this->assign('access_playlist', AuthUtil::getDetailedUserrealmAccess(array(3, 21, 33), $userID));
$this->assign('Admin', AuthUtil::getDetailedUserrealmAccess(array(1), $userID));
$this->assign('awsets', $awsets);
}
protected function setupTemplate()
{
global $cfg;
parent::setupTemplate();
$auth = Auth::getInstance();
$ID = $this->fieldData['guid'];
$realmID = substr($this->fieldData['id'], 3);
$type = $this->fieldData['treeUser'];
if (stristr($_SERVER["HTTP_ACCEPT"], "application/xhtml+xml")) {
header("Content-type: application/xhtml+xml");
} else {
header("Content-type: text/xml");
}
if ($type == 'group') {
$treeInfo = AuthSubRealmViewer::singleRealmTree($realmID, $ID, true);
} else {
$treeInfo = AuthSubRealmViewer::singleRealmTree($realmID, $ID, false);
}
echo "<?xml version='1.0' encoding='iso-8859-1'?>\n";
if ($realmID == 0) {
$realmID = 0;
} else {
$realmID = "rlm" . $realmID;
}
$treeInfo = '<tree id="' . $realmID . '">' . $treeInfo . '</tree>';
echo $treeInfo;
}
protected function setupTemplate()
{
global $cfg;
parent::setupTemplate();
$db = Database::getInstance($cfg['DPS']['dsn']);
$trackid = $this->fieldData['trackID'];
if (is_numeric($trackid)) {
$query = "SELECT title, artist, md5, path FROM v_audio \n\t\t\t\tWHERE id = " . $trackid;
$file = $db->getRow($query);
//$filename = escapeshellarg($file['path']) . "/" .
// escapeshellarg($file['md5'][0]) . "/" .
// escapeshellarg($file['md5']);
$filename = $file['path'] . "/" . $file['md5'][0] . "/" . $file['md5'];
header('Pragma: public');
header('Expires: 0');
header('Content-Transfer-Encoding: binary');
#header('Cache-Control: no-store,no-cache,must-revalidate');
header('Content-Length: 180373');
$fileN = str_replace(' ', '_', $file['title']) . '-' . str_replace(' ', '_', $file['artist']) . '.mp3';
$fileN = str_replace('"', "", $fileN);
$headstr = 'Content-Disposition: attachment; filename="' . $fileN . "\"";
header($headstr);
header('Content-type: audio/mpeg');
passthru($cfg['general']['toolkitRoot'] . "/DPS/encode-digiplay-file.sh " . $filename);
}
}
protected function setupTemplate()
{
global $cfg;
parent::setupTemplate();
$auth = Auth::getInstance();
$userID = $auth->getUserID();
$dirID = substr($this->fieldData['id'], 3);
$type = $this->fieldData['treeUser'];
if (stristr($_SERVER["HTTP_ACCEPT"], "application/xhtml+xml")) {
header("Content-type: application/xhtml+xml");
} else {
header("Content-type: text/xml");
}
if ($type == 'group') {
$treeInfo = DPS::singleGroupTreeSetup($dirID, $cfg['Auth']['defaultNewUserGroup'], $this->fieldData['treeType']);
} else {
$treeInfo = DPS::singleTreeSetup($dirID, $userID, $this->fieldData['treeType']);
}
echo "<?xml version='1.0' encoding='iso-8859-1'?>\n";
if ($dirID == 1) {
$dirID = 0;
} else {
$dirID = "dir" . $dirID;
}
$treeInfo = '<tree id="' . $dirID . '">' . $treeInfo . '</tree>';
echo $treeInfo;
}
protected function setupTemplate()
{
global $cfg;
parent::setupTemplate();
$db = Database::getInstance($cfg['DPS']['dsn']);
$auth = Auth::getInstance();
$userID = $auth->getUserID();
$dirID = pg_escape_string($this->fieldData['rootdir']);
if (!is_numeric($dirID)) {
$this->assign('permError', 't');
} else {
$flag = false;
$sql = "SELECT count(*) FROM v_tree_dir\n\t\t\t\tWHERE id = {$dirID}\n\t\t\t\t\tAND\tuserid = {$userID}\n\t\t\t\t\tAND permissions & B'" . $cfg['DPS']['fileW'] . "' = '" . $cfg['DPS']['fileW'] . "'";
if ($db->getOne($sql) > 0) {
$flag = true;
}
if ($flag) {
$sql = "SELECT * FROM dir WHERE id = {$dirID}";
$folder = $db->getRow($sql);
$this->assign('folder', $folder);
} else {
$this->assign('permError', 't');
}
}
}
private static function initialize()
{
if (self::$initialized) {
return;
}
self::disable_ob();
try {
self::$redis = new Redis();
self::$redis_enabled = self::$redis->pconnect('127.0.0.1', 6379, 0.01);
} catch (Exception $e) {
}
if (isset($_SERVER['HTTP_HOST'])) {
self::$log_prefix = $_SERVER['HTTP_HOST'];
} else {
self::$log_prefix = basename(realpath(__DIR__ . '/../../../'));
}
if (file_exists(dirname(__FILE__) . '/system/logs/')) {
self::$log_path = dirname(__FILE__) . '/system/logs/';
} else {
if (file_exists(dirname(__FILE__) . '/../application/logs/')) {
self::$log_path = dirname(__FILE__) . '/../application/logs/';
}
}
self::$initialized = true;
}
protected function setupTemplate()
{
global $cfg;
parent::setupTemplate();
$db = Database::getInstance($cfg['DPS']['dsn']);
$auth = Auth::getInstance();
$userID = $auth->getUserID();
$scriptID = pg_escape_string($this->fieldData['scriptID']);
if (!is_numeric($scriptID)) {
$this->assign('permError', 't');
} else {
$sql = "SELECT count(*) FROM v_tree_script\n\t\t\t\tWHERE id = {$scriptID}\n\t\t\t\t\tAND\tuserid = {$userID}\n\t\t\t\t\tAND permissions & B'" . $cfg['DPS']['fileW'] . "' = '" . $cfg['DPS']['fileW'] . "'";
if ($db->getOne($sql) > 0) {
$sql = "SELECT dirid FROM scriptsdir\n\t\t\t\t\tWHERE scriptid = {$scriptID}";
$dirID = $db->getOne($sql);
"SELECT count(*) FROM v_tree_dir\n\t\t\t\t\tWHERE id = {$dirID}\n\t\t\t\t\t\tAND\tuserid = {$userID}\n\t\t\t\t\t\tAND permissions & B'" . $cfg['DPS']['fileW'] . "' = '" . $cfg['DPS']['fileW'] . "'";
if ($db->getOne($sql) > 0) {
$flag = true;
}
}
if ($flag) {
$sql = "SELECT * FROM scripts WHERE id = {$scriptID}";
$script = $db->getRow($sql);
$sql = "SELECT count(*) FROM v_tree_script\n\t\t\t\t\tWHERE id = {$scriptID}\n\t\t\t\t\t\tAND\tuserid = {$userID}\n\t\t\t\t\t\tAND permissions & B'" . $cfg['DPS']['fileO'] . "' = '" . $cfg['DPS']['fileO'] . "'";
$check = $db->getOne($sql);
if ($check > 0) {
$this->assign('own', 't');
}
$this->assign('script', $script);
$this->assign('treeType', '');
} else {
$this->assign('permError', 't');
}
}
}
protected function setupTemplate()
{
global $cfg;
parent::setupTemplate();
$db = Database::getInstance($cfg['DPS']['dsn']);
//Sue playing now/next
$query = "SELECT audio.title AS title, audio.id AS id \n\t\t\tFROM sustschedule, audio \n\t\t\tWHERE sustschedule.audioid = audio.id \n\t\t\tORDER BY sustschedule.id asc";
$suePlaylist = $db->getAll($query);
foreach ($suePlaylist as $key => &$track) {
$sql = "SELECT DISTINCT artists.name AS name \n\t\t\t\tFROM artists, audioartists \n\t\t\t\tWHERE audioartists.audioid = " . $track['id'] . " \n\t\t\t\t\tAND audioartists.artistid = artists.id";
$artists = $db->getAll($sql);
foreach ($artists as $artist) {
$track['artist'] = $track['artist'] . $artist['name'] . " & ";
}
$track['artist'] = rtrim($track['artist'], " & ");
}
$auth = Auth::getInstance();
$userID = $auth->getUserID();
$this->assign('Access_ViewSue', AuthUtil::getDetailedUserrealmAccess(array(58, 60, 3), $userID));
$this->assign('Access_EditSue', AuthUtil::getDetailedUserrealmAccess(array(58, 60, 66), $userID));
$this->assign('Access_SueStats', AuthUtil::getDetailedUserrealmAccess(array(58, 60, 2), $userID));
$this->assign('Admin', AuthUtil::getDetailedUserrealmAccess(array(1), $userID));
$this->assign('storedTracks', $systemTracks);
$this->assign('sueLastTrack', $suePlaylist[0]);
$this->assign('sueNextTrack', $suePlaylist[1]);
}
protected function action()
{
$this->addParameter('opacity', '0');
$this->showContentOnly = TRUE;
$this->pageToView = "message";
parent::action();
}
public static function addPredmet()
{
$id = intval($_GET['id']);
$predmetid = intval($_POST['predmetid']);
$ucitel = intval($_POST['ucitel']);
DB::query("INSERT INTO `tests` (trieda,predmetid,ucitel) VALUES ('" . $id . "','" . $predmetid . "','" . $ucitel . "')");
Viewer::addMessage("Predmet bot úspešne pridaný !", Viewer::OK);
}
protected function setupTemplate()
{
global $cfg;
parent::setupTemplate();
$loginTplID = MVCUtils::getTemplateID('login.tpl');
$this->assign('fwdtid', end($this->templateIDStack));
$this->assign('loginTplID', $loginTplID);
}
protected function setupTemplate()
{
global $cfg;
parent::setupTemplate();
$auth = Auth::getInstance();
$userID = $auth->getUserID();
$this->assign('treeType', 'jacspmr');
$this->assign('Admin', AuthUtil::getDetailedUserrealmAccess(array(1), $userID));
}
protected function setupTemplate()
{
global $cfg;
parent::setupTemplate();
$auth = Auth::getInstance();
$userID = $auth->getUserID();
$this->assign('RequestTrack', AuthUtil::getDetailedUserrealmAccess(array(3, 21, 29), $userID));
$this->assign('Admin', AuthUtil::getDetailedUserrealmAccess(array(1), $userID));
}
protected function setupTemplate()
{
global $cfg;
parent::setupTemplate();
$db = Database::getInstance($cfg['DPS']['dsn']);
$offset = $this->fieldData['dpsSearchPage'];
if ($offset == "") {
$offset = 0;
} else {
$offset--;
}
$searchValue = trim($this->fieldData['dpsSearchVal']);
$searchType = $this->fieldData['dpsSearchType'];
$letter = pg_escape_string($this->fieldData['dpsSearchLetter']);
if ($searchType == '' && $letter != '') {
if ($letter == "*") {
$searchType = 'Number';
} else {
$searchType = 'Letter';
}
}
if ($this->fieldData['dpsSortType'] != '') {
$sesh = Session::getInstance();
$sortType = $this->fieldData['dpsSortType'];
$sesh->setValue("dpsSortType", $sortType);
} else {
$sesh = Session::getInstance();
if ($sesh->keyExists("dpsSortType")) {
$sortType = $sesh->getValue("dpsSortType");
} else {
$sortType = "title";
}
}
if ($searchValue != '') {
$searchResult = DPS::searchAudio($searchValue, $searchType, $sortType, $offset, '');
$rNum = DPS::searchPageAudio($searchValue, $searchType, '');
$searchInfo = "Found {$rNum} results matching your query";
}
$pages = ceil($rNum / $cfg['DPS']['resultLimit']);
//fill the $pageArray array with values from 1 to $pages
$pageArray = range(1, $pages);
$auth = Auth::getInstance();
$userID = $auth->getUserID();
$this->assign('RequestTrack', AuthUtil::getDetailedUserrealmAccess(array(3, 21, 29), $userID));
$this->assign('CensorTrack', AuthUtil::getDetailedUserrealmAccess(array(3, 21, 30), $userID));
$this->assign('ReportTrack', AuthUtil::getDetailedUserrealmAccess(array(3, 21, 43), $userID));
$this->assign('EditTrack', AuthUtil::getDetailedUserrealmAccess(array(3, 21, 27), $userID));
$this->assign('DeleteTrack', AuthUtil::getDetailedUserrealmAccess(array(2, 21, 32), $userID));
$this->assign('Admin', AuthUtil::getDetailedUserrealmAccess(array(1), $userID));
$this->assign('page', $offset);
$this->assign('searchResult', $searchResult);
$this->assign('searchInfo', $searchInfo);
$this->assign('pages', $pageArray);
$this->assign('searchType', $searchType);
$this->assign('searchValue', $searchValue);
$this->assign('sortType', $sortType);
}
protected function setupTemplate()
{
parent::setupTemplate();
global $cfg;
$db = Database::getInstance($cfg['DPS']['dsn']);
$sql = "SELECT DISTINCT location as locid, location as locname \n\t\t\tFROM configuration \n\t\t\tWHERE location != -1 AND \n\t\t\t\tlocation != 0\n\t\t\tORDER BY location ASC";
$locs = $db->getAll($sql);
$this->assign('locs', $locs);
}
protected function setupTemplate()
{
global $cfg;
parent::setupTemplate();
$db = Database::getInstance($cfg['DPS']['dsn']);
$auth = Auth::getInstance();
$userID = $auth->getUserID();
$this->assign('Admin', AuthUtil::getDetailedUserrealmAccess(array(1), $userID));
}
public static function view($viewName, $model = null)
{
self::$model = $model;
$path = $_SERVER['DOCUMENT_ROOT'] . '/' . 'application/views/' . $viewName;
if (file_exists($path . '.php')) {
require_once $path . '.php';
} elseif (file_exists($path . '.html')) {
require_once $path . '.html';
}
}
/**
* Construct the viewer and load values
*
* If you intend on overriding this classes constructor you should ensure
* that you call parent::__construct(); to ensure that the class
* is loaded correctly.
*
* @param string $templateID The ID of the template for the page to be viewed. This ID is the ID of the template in the database.
* @param string $formName The name of the form (if any) which has been submitted
* @param array $fieldData An associative array for field/value pairs from the submitted form (if any)
* @todo Add authnetication checks to call processInvalid or processInvalid accordingly.
*/
public function __construct($templateIDS, $formName = null, $modelModuleName, $viewerModuleName, &$fieldData = array(), &$errors = array())
{
//Store class variables
$this->templateIDStack = $templateIDS;
$this->templateID = end($templateIDS);
$this->formName = $formName;
$this->fieldData =& $fieldData;
$this->errors =& $errors;
if (count($errors) > 0) {
$this->processInvalid();
} else {
$this->processValid();
}
//something
//Initialise the viewer
$this->viewer = MVCUtils::initializeViewer($this->templateIDStack, $formName, $viewerModuleName, $fieldData, $errors);
//The $viewer class variable is now loaded
$this->code = $this->viewer->getCode();
}
public static function query($sql)
{
Utils::log($sql);
//echo $sql."\n";
$res = self::$db->query($sql);
if ($res == FALSE) {
Utils::log("DB ERROR");
Viewer::addMessage("Nastala chyba pri komunikácii s databázou, prosím kontaktuj administrátora !", Viewer::ERROR);
}
return $res;
}
protected function setupTemplate()
{
global $cfg;
parent::setupTemplate();
$db = Database::getInstance($cfg['DPS']['dsn']);
$trackID = $this->fieldData['trackID'];
$auth = Auth::getInstance();
$userID = $auth->getUserID();
//As there is no general audio view
$sql = "SELECT count(*) FROM v_tree_jingle \n\t\t\tWHERE id = " . pg_escape_string($trackID) . " \n\t\t\t\tAND userid = " . $userID . " \n\t\t\t\tAND permissions & B'" . $cfg['DPS']['fileW'] . "' = '" . $cfg['DPS']['fileW'] . "'";
$check = $db->getOne($sql);
$sql = "SELECT count(*) FROM v_tree_advert \n\t\t\tWHERE id = " . pg_escape_string($trackID) . " \n\t\t\t\tAND userid = " . $userID . " \n\t\t\t\tAND permissions & B'" . $cfg['DPS']['fileW'] . "' = '" . $cfg['DPS']['fileW'] . "'";
$check = $check + $db->getOne($sql);
$sql = "SELECT count(*) FROM v_tree_prerec \n\t\t\tWHERE id = " . pg_escape_string($trackID) . " \n\t\t\t\tAND userid = " . $userID . " \n\t\t\t\tAND permissions & B'" . $cfg['DPS']['fileW'] . "' = '" . $cfg['DPS']['fileW'] . "'";
$check = $check + $db->getOne($sql);
if ($check < 1) {
$this->assign('authError', 't');
} else {
$sql = "SELECT audio.* FROM audio \n\t\t\t\tWHERE audio.id = " . pg_escape_string($trackID);
$trackDetails = $db->getRow($sql);
$sql = "SELECT DISTINCT artists.name AS name, artists.id AS id \n\t\t\t\tFROM artists, audioartists \n\t\t\t\tWHERE audioartists.audioid = " . pg_escape_string($trackID) . " \n\t\t\t\t\tAND audioartists.artistid = artists.id";
$trackDetails['artist'] = $db->getAll($sql);
$i = 0;
foreach ($trackDetails['artist'] as &$artist) {
$artist['number'] = $i;
$i++;
}
$artistNum = $i;
$sql = "SELECT DISTINCT keywords.name AS name, keywords.id AS id \n\t\t\t\tFROM keywords, audiokeywords \n\t\t\t\tWHERE audiokeywords.track = " . pg_escape_string($trackID) . " \n\t\t\t\t\tAND audiokeywords.keyword = keywords.id";
$trackDetails['keywords'] = $db->getAll($sql);
$i = 0;
foreach ($trackDetails['keywords'] as &$keyword) {
$keyword['number'] = $i;
$i++;
}
$keywordNum = $i;
$samples = $trackDetails['length_smpl'];
$trackDetails['length'] = $tracksLen = floor($samples / 44100 / 60) . "mins " . $samples / 44100 % 60 . "secs.";
$sql = "SELECT * from audiocomments \n\t\t\t\tWHERE audioid = " . pg_escape_string($trackID) . "\n\t\t\t\tORDER BY creationdate ASC";
$trackDetails['comments'] = $db->getAll($sql);
foreach ($trackDetails['comments'] as &$comment) {
$comment['username'] = AuthUtil::getUsername($comment['userid']);
$comment['comment'] = str_replace("\n", "<br>", $comment['comment']);
$comment['ctime'] = substr($comment['creationdate'], 0, 10);
}
$this->assign('trackDetails', $trackDetails);
$this->assign('keywordNum', $keywordNum);
$this->assign('artistNum', $artistNum);
$this->assign('trackID', $trackID);
}
$this->assign('access_playlist', AuthUtil::getDetailedUserrealmAccess(array(3, 21, 33), $userID));
$this->assign('Admin', AuthUtil::getDetailedUserrealmAccess(array(1), $userID));
$this->assign('studioAccess', AuthUtil::getDetailedUserrealmAccess(array(3, 21, 34), $userID));
}
/**
* <p>This is the only methods which runs the application. In fact it creates a new
* instance of this class because the constructor contains all necessary instructions to set up
* application variables and parse required data from XML source. It is as easy as possible 8-D</p>
*/
public static function run()
{
self::$instance = new Application();
try {
self::$instance->getParser()->parse();
Viewer::vizualize(self::$instance->getParams()->getRequestedView());
} catch (Exception $e) {
self::$instance->caughtException = $e;
Viewer::vizualize(self::$instance->getParams()->getErrorView());
}
}
protected function action()
{
$this->showContentOnly = TRUE;
try {
$idntwrkr = $this->uriPath[count($this->uriPath) - 1];
} catch (Exception $exc) {
$idntwrkr = NULL_PARENT_ROOT;
}
Session::setObj(Session::NETWORKER, new Utente($idntwrkr));
$this->pageToView = "loadntwrkr";
parent::action();
}
public function action_view()
{
$uri = $this->request->detect_uri();
if ($uri == '') {
$this->redirect(URL::to('page@view:home'));
}
$id = $this->request->param('id');
$query = $this->request->query();
$username = $this->request->post('username');
$password = $this->request->post('password');
$login = $this->request->post('login');
$identity = Identity::instance();
$info = ORM::factory('Page')->filter('alias', $id)->load();
if ($info->loaded()) {
//downloads
if ($id == 'download') {
$downloads = true;
}
//contact
if ($id == 'contact') {
$form = Form::factory('Contact');
//$form = Form::
if ($form->valid()) {
//var_dump($form->values());
$this->redirect(URL::to('page@view:contact') . '?form=sent');
}
} else {
$form = FALSE;
}
//login mechanism
if (empty($username) && $login == 'Login') {
$this->redirect(URL::current() . '?auth=nameError');
} elseif (empty($password) && $login == 'Login') {
$this->redirect(URL::current() . '?auth=false');
} elseif (!empty($username) && !empty($password) && $login == 'Login') {
$auth = $identity->authenticate($username, $password);
if ($auth) {
$this->redirect(URL::current());
} else {
$this->redirect(URL::current() . '?auth=false');
}
}
//logout mechanism
if ($login == 'Logout') {
$identity->destroy();
$this->redirect(URL::current());
}
$view = View::factory('page/item', array('item' => Viewer::factory($info), 'form' => $form, 'query' => $query, 'downloads' => isset($downloads) ? $downloads : null));
$this->response->body($view->render());
} else {
throw HTTP_Exception::factory(404, 'Page not found');
}
}
protected function setupTemplate()
{
parent::setupTemplate();
global $cfg;
$db = Database::getInstance($cfg['DPS']['dsn']);
$sql = "SELECT * FROM configuration ORDER BY location, parameter ASC";
$configs = $db->getAll($sql);
$sql = "SELECT DISTINCT location FROM configuration ORDER BY location ASC";
$locs = $db->getAll($sql);
$this->assign('configs', $configs);
$this->assign('locs', $locs);
}
protected function setupTemplate()
{
global $cfg;
parent::setupTemplate();
$auth = Auth::getInstance();
$userID = $auth->getUserID();
$this->assign('Admin', AuthUtil::getDetailedUserrealmAccess(array(1), $userID));
if ($userID == $cfg['Auth']['anonuserID']) {
$this->assign('Guest', 't');
} else {
$this->assign('Guest', 'f');
}
}
protected function setupTemplate()
{
global $cfg;
parent::setupTemplate();
$db = Database::getInstance($cfg['DPS']['dsn']);
//System Track count
$query = "SELECT count(audio.id) FROM audio";
$systemTracks = $db->getOne($query);
//System Track length
$query = "SELECT sum(audio.length_smpl) FROM audio";
$systemSamps = $db->getOne($query);
$days = floor($systemSamps / 44100 / 60 / 60 / 24);
$hours = floor($systemSamps / 44100 / 60 / 60 - $days * 24);
$mins = round($systemSamps / 44100 / 60 - $hours * 60 - $days * 24 * 60);
$systemLength = $days . "days " . $hours . "h " . $mins . "m";
//Sue Track count
$query = "SELECT count(audio.id) FROM audio WHERE sustainer = 't'";
$sueTracks = $db->getOne($query);
//Sue Track length
$query = "SELECT sum(audio.length_smpl) FROM audio WHERE sustainer = 't'";
$sueSamps = $db->getOne($query);
$days = floor($sueSamps / 44100 / 60 / 60 / 24);
$hours = floor($sueSamps / 44100 / 60 / 60 - $days * 24);
$mins = round($sueSamps / 44100 / 60 - $hours * 60 - $days * 24 * 60);
$sueLength = $days . "days " . $hours . "h " . $mins . "m";
//Sue playing now/next
$query = "SELECT audio.title AS title, audio.id AS id \n\t\tFROM sustschedule, audio \n\t\tWHERE sustschedule.audioid = audio.id \n\t\tORDER BY sustschedule.id asc";
$suePlaylist = $db->getAll($query);
foreach ($suePlaylist as $key => &$track) {
$sql = "SELECT DISTINCT artists.name as name \n\t\t\tFROM artists, audioartists \n\t\t\tWHERE audioartists.audioid = " . $track['id'] . " AND\n\t\t\t\taudioartists.artistid = artists.id";
$artists = $db->getAll($sql);
foreach ($artists as $artist) {
$track['artist'] = $track['artist'] . $artist['name'] . " & ";
}
$track['artist'] = rtrim($track['artist'], " & ");
}
$auth = Auth::getInstance();
$userID = $auth->getUserID();
$this->assign('Access_EditSue', AuthUtil::getDetailedUserrealmAccess(array(24, 20, 3), $userID));
$this->assign('Access_ViewSue', AuthUtil::getDetailedUserrealmAccess(array(26, 20, 3), $userID));
$this->assign('Admin', AuthUtil::getDetailedUserrealmAccess(array(1), $userID));
$this->assign('storedTracks', $systemTracks);
$this->assign('lengthOfTracks', $systemLength);
$this->assign('suePlaylistTracks', $sueTracks);
$this->assign('suePlaylistLength', $sueLength);
$this->assign('sueLastTrack', $suePlaylist[0]);
$this->assign('sueNextTrack', $suePlaylist[1]);
$this->assign('suePlaylist', $suePlaylist);
}
