foreach ($_POST['selected'] as $key => $value) {
$value = htmlspecialchars($value);
list($addr, $type) = split(":", $value);
$addr = mysql_real_escape_string($addr);
$type = mysql_real_escape_string($type);
$sql = "UPDATE valuefacts set state = 'A' where address = '{$addr}' and type = '{$type}'";
mysql_query($sql) or die("<br/>Error" . mysql_error());
mysql_query("update valuefacts set state = 'A' where type = 'UD'") or die("<br/>Error" . mysql_error());
}
requestAction("update-schemacfg", 2, 0, "", $resonse);
echo "<br/><div class=\"info\"><b><center>Einstellungen gespeichert</center></b></div><br/><br/>";
}
}
}
echo " <form action=" . htmlspecialchars($_SERVER["PHP_SELF"]) . " method=post>\n";
showButtons();
showTable("UD", "Allgemein");
showTable("VA", "Messwerte");
showTable("DI", "Digitale Eingänge");
showTable("DO", "Digitale Ausgänge");
showTable("AO", "Analoge Ausgänge");
showTable("W1", "One Wire Sensoren");
echo " </form>\n";
mysql_close();
include "footer.php";
//***************************************************************************
// Show Buttons
//***************************************************************************
function showButtons()
{
echo " <div>\n";
function view_object()
{
global $baseURL, $FF, $link, $link2, $loggedUser, $object, $step, $objLocation, $objObject, $objObservation, $objObserver, $objPresentations, $objUtil;
echo "<script type=\"text/javascript\" src=\"" . $baseURL . "lib/javascript/presentation.js\"></script>";
if (array_key_exists('viewobjectextrainfo', $_GET)) {
$viewobjectextrainfo = $_GET['viewobjectextrainfo'];
} elseif (array_key_exists('viewobjectextrainfo', $_COOKIE)) {
$viewobjectextrainfo = $_COOKIE['viewobjectextrainfo'];
} else {
$viewobjectextrainfo = 'hidden';
}
if (array_key_exists('viewobjectdetails', $_GET)) {
$viewobjectdetails = $_GET['viewobjectdetails'];
} elseif (array_key_exists('viewobjectdetails', $_COOKIE)) {
$viewobjectdetails = $_COOKIE['viewobjectdetails'];
} else {
$viewobjectdetails = 'show';
}
if (array_key_exists('viewobjectephemerides', $_GET)) {
$viewobjectephemerides = $_GET['viewobjectephemerides'];
} elseif (array_key_exists('viewobjectephemerides', $_COOKIE)) {
$viewobjectephemerides = $_COOKIE['viewobjectephemerides'];
} else {
$viewobjectephemerides = 'hidden';
}
if (array_key_exists('viewobjectobjectsnearby', $_GET)) {
$viewobjectobjectsnearby = $_GET['viewobjectobjectsnearby'];
} elseif (array_key_exists('viewobjectobjectsnearby', $_COOKIE)) {
$viewobjectobjectsnearby = $_COOKIE['viewobjectobjectsnearby'];
} else {
$viewobjectobjectsnearby = 'show';
}
if (array_key_exists('viewobjectobservations', $_GET)) {
$viewobjectobservations = $_GET['viewobjectobservations'];
} elseif (array_key_exists('viewobjectobservations', $_COOKIE)) {
$viewobjectobservations = $_COOKIE['viewobjectobservations'];
} else {
$viewobjectobservations = 'hidden';
}
if (!($theLocation = $loggedUser ? $objObserver->getObserverProperty($loggedUser, 'stdLocation') : '')) {
$viewobjectephemerides = 'hidden';
}
echo "<div id=\"main\">";
if ($viewobjectextrainfo == "show") {
showButtons($theLocation, $viewobjectdetails, $viewobjectephemerides, $viewobjectobjectsnearby, $viewobjectobservations);
echo $objPresentations->getDSSDeepskyLiveLinks1($object);
echo $objPresentations->getDSSDeepskyLiveLinks2($object);
echo "<hr />";
}
if ($viewobjectextrainfo == "hidden") {
$content = "<a href=\"" . $baseURL . "index.php?indexAction=detail_object&object=" . urlencode($_GET['object']) . '&zoom=' . $objUtil->checkGetKey("zoom", 30) . '&SID=Qobj&viewobjectextrainfo=show' . "\" >+ " . LangObjectShowExtraInfo . "</a>";
echo $content;
echo $objPresentations->getDSSDeepskyLiveLinks1($object);
echo $objPresentations->getDSSDeepskyLiveLinks2($object);
echo "<hr />";
}
if ($viewobjectdetails == "show") {
showObjectDetails(stripslashes($object));
}
if ($viewobjectephemerides == "show") {
showObjectEphemerides($theLocation);
}
if ($viewobjectobjectsnearby == "show") {
showObjectsNearby();
}
if ($imagesize = $objUtil->checkRequestKey('imagesize')) {
showObjectImage($imagesize);
}
if ($viewobjectobservations == "show") {
showObjectObservations();
}
if (array_key_exists('admin', $_SESSION) && $_SESSION['admin'] == "yes") {
showAdminObjectFunctions();
}
echo "</div>";
}
if (Symphony::Configuration()->get('direction_ltr', 'redactor') == 'yes') {
echo "direction: 'ltr',";
} else {
echo "direction: 'rtl',";
}
if (Symphony::Configuration()->get('enable_observeimages', 'redactor') == 'yes') {
echo "observeImages: true,";
} else {
echo "observeImages: false,";
}
if (Symphony::Configuration()->get('enable_airmode', 'redactor') == 'yes') {
$buttons = explode(',', Symphony::Configuration()->get('airbuttons', 'redactor'));
echo "airButtons: [" . showButtons($buttons) . "],";
} else {
$buttons = explode(',', Symphony::Configuration()->get('buttons', 'redactor'));
echo "buttons: [" . showButtons($buttons) . "],";
}
if (Symphony::Configuration()->get('enable_source', 'redactor') == 'yes') {
$tags = Symphony::Configuration()->get('allowedtags', 'redactor');
if (isset($tags)) {
$tags = explode(',', $tags);
echo "allowedTags: [";
foreach ($tags as $tag) {
echo '"' . $tag . '",';
}
echo "],";
}
}
if (Symphony::Configuration()->get('enable_fileupload', 'redactor') == 'yes') {
echo "fileUpload: Symphony.Context.get('root') + '/symphony/extension/richtext_redactor/fileupload/',";
}
function showSingleEpisode($singleEpisode, $justTitle)
{
include "core/includes.php";
$finalOutputEpisodes = NULL;
// declare final output to return
$resulting_episodes = NULL;
//declare the 1st time and then reset
////Validate the current episode
//NB. validateSingleEpisode returns [0] episode is supported (bool), [1] Episode Absolute path, [2] Episode XML DB absolute path,[3] File Extension (Type), [4] File MimeType, [5] File name without extension, [6] episode file supported but to XML present
$thisPodcastEpisode = validateSingleEpisode($singleEpisode);
////If episode is supported and has a related xml db, and if it's not set to a future date OR if it's set for a future date but you are logged in as admin
if ($thisPodcastEpisode[0] == TRUE and !publishInFuture($thisPodcastEpisode[1]) or $thisPodcastEpisode[0] == TRUE and publishInFuture($thisPodcastEpisode[1]) and isUserLogged()) {
////Parse XML data related to the episode
// NB. Function parseXMLepisodeData returns: [0] episode title, [1] short description, [2] long description, [3] image associated, [4] iTunes keywords, [5] Explicit language,[6] Author's name,[7] Author's email,[8] PG category 1, [9] PG category 2, [10] PG category 3, [11] file_info_size, [12] file_info_duration, [13] file_info_bitrate, [14] file_info_frequency
$thisPodcastEpisodeData = parseXMLepisodeData($thisPodcastEpisode[2]);
//// Return just title and end function here, if just title is required
if (isset($justTitle) and $justTitle == TRUE) {
return $thisPodcastEpisodeData[0];
}
//Function ends here
//// Start constructing episode HTML output
//Theme engine PG version >= 2.0 row-fluid
$resulting_episodes .= '<div class="episode">';
$resulting_episodes .= '<div class="span6 col-md-6 6u episodebox">';
//open the single episode DIV
////Title
$resulting_episodes .= '<h3 class="episode_title">' . $thisPodcastEpisodeData[0];
if (isItAvideo($thisPodcastEpisode[3])) {
$resulting_episodes .= ' <i class="fa fa-youtube-play"></i>';
}
//add video icon
$resulting_episodes .= '</h3>';
////Date
$resulting_episodes .= '<p class="episode_date">';
$thisEpisodeDate = filemtime($thisPodcastEpisode[1]);
if ($thisEpisodeDate > time()) {
//if future date
$resulting_episodes .= '<i class="fa fa-clock-o fa-2x"></i> ';
//show watch icon
}
$episodeDate = date($dateformat, $thisEpisodeDate);
$resulting_episodes .= $episodeDate . '</p>';
//// Edit/Delete button for logged user (i.e. admin)
if (isUserLogged()) {
$resulting_episodes .= '<p><a class="btn btn-inverse btn-xs btn-mini" href="?p=admin&do=edit&=episode&name=' . urlencode($thisPodcastEpisode[5]) . '.' . $thisPodcastEpisode[3] . '">' . _("Edit / Delete") . '</a></p>';
}
//Show Image embedded in the mp3 file or image associated in the images/ folder from previous versions of PG (i.e. 1.4-) - Just jpg and png extension supported
if (file_exists($absoluteurl . $img_dir . $thisPodcastEpisode[5] . '.jpg')) {
$resulting_episodes .= '<img class="episode_image" src="' . $url . $img_dir . $thisPodcastEpisode[5] . '.jpg" alt="' . $thisPodcastEpisodeData[0] . '" />';
} else {
if (file_exists($absoluteurl . $img_dir . $thisPodcastEpisode[5] . '.png')) {
$resulting_episodes .= '<img class="episode_image" src="' . $url . $img_dir . $thisPodcastEpisode[5] . '.png" alt="' . $thisPodcastEpisodeData[0] . '" />';
}
}
//// Show Long description if available, otherwise, short Description
if ($thisPodcastEpisodeData[2] != NULL) {
$resulting_episodes .= '<div>' . ampersandEntitiesConvert(htmlspecialchars_decode($thisPodcastEpisodeData[2])) . '</div>';
} else {
$resulting_episodes .= '<p>' . $thisPodcastEpisodeData[1] . '</p>';
}
/// Categories
$resulting_episodes .= '<p><em>' . _("Categories") . '</em> ';
if ($thisPodcastEpisodeData[8] != "") {
$resulting_episodes .= ' | <a href="?p=archive&cat=' . $thisPodcastEpisodeData[8] . '">' . categoryNameFromID($absoluteurl, $thisPodcastEpisodeData[8]) . '</a>';
}
if ($thisPodcastEpisodeData[9] != "") {
$resulting_episodes .= ' | <a href="?p=archive&cat=' . $thisPodcastEpisodeData[9] . '">' . categoryNameFromID($absoluteurl, $thisPodcastEpisodeData[9]) . '</a>';
}
if ($thisPodcastEpisodeData[10] != "") {
$resulting_episodes .= ' | <a href="?p=archive&cat=' . $thisPodcastEpisodeData[10] . '">' . categoryNameFromID($absoluteurl, $thisPodcastEpisodeData[10]) . '</a>';
}
$resulting_episodes .= '</p>';
////Buttons (More, Download, Watch).
$resulting_episodes .= showButtons($thisPodcastEpisode[5], $thisPodcastEpisode[3], $url, $upload_dir, "singleEpisode", $thisPodcastEpisode[1], $enablestreaming);
////Other details (file type, duration, bitrate, frequency)
//NB. read from XML DB (except file extension = $thisPodcastEpisode[3]).
$episodeDetails = _('Filetype:') . " " . strtoupper($thisPodcastEpisode[3]);
if ($thisPodcastEpisodeData[11] != NULL) {
$episodeDetails .= ' - ' . _('Size:') . " " . $thisPodcastEpisodeData[11] . _("MB");
}
if ($thisPodcastEpisodeData[12] != NULL) {
// display file duration
$episodeDetails .= " - " . _("Duration:") . " " . $thisPodcastEpisodeData[12] . " " . _("m");
}
if ($thisPodcastEpisode[3] == "mp3" and $thisPodcastEpisodeData[13] != NULL and $thisPodcastEpisodeData[14] != NULL) {
//if mp3 show bitrate and frequency
$episodeDetails .= " (" . $thisPodcastEpisodeData[13] . " " . _("kbps") . " " . $thisPodcastEpisodeData[14] . " " . _("Hz") . ")";
}
$resulting_episodes .= '<p class="episode_info">' . $episodeDetails . '</p>';
////Playes: audio (flash/html5) and video (html5), for supported files and browsers
//if audio and video streaming is enabled in PG options
if ($enablestreaming == "yes" and !detectMobileDevice()) {
$resulting_episodes .= showStreamingPlayers($thisPodcastEpisode[5], $thisPodcastEpisode[3], $url, $upload_dir, "singleEpisode");
}
$isvideo = FALSE;
//RESET isvideo for next episode
////Social networks and (eventual) embedded code
$resulting_episodes .= attachToEpisode($thisPodcastEpisode[5], $thisPodcastEpisode[3], $thisPodcastEpisodeData[0]);
//Close the single episode DIV
$resulting_episodes .= "</div>";
//Close div with class row-fluid (theme based on bootstrap). Theme engine >= 2.0
$resulting_episodes .= "</div>";
//close class row-fluid (bootstrap)
//Append this episode to the final output to return
$finalOutputEpisodes .= $resulting_episodes;
}
//Finally, return all the episodes to output on the web page
return $finalOutputEpisodes;
}
