/** getGmapAdressinfo ( $strasse, $hausNr, $ort ) liefert ein Array zurück, welches der Antwort des Google-Services zur Anfrage der Geo-Informationen entspricht. Das Array hat folgende Struktur: Index Beschreibung 0. HTTP-Statuscode 1. Genauigkeit (siehe die Genauigkeits-Konstanten) 2. Geografische Breite 3. Geografische Länge ---------------------------------------------------------------------------------- zu Index 1: Die genauigkeit wird mittels einder der folgenden Konstanten beschrieben. Konstanten Beschreibung 0 Unbekannter Ort. (Seit 2.59) 1 Land. (Seit 2.59) 2 Bundesland/Bundesstaat, Provinz, Präfektur usw. (Seit 2.59) 3 Bezirk, Gemeinde usw. (Seit 2.59) 4 Ortschaft (Stadt, Dorf). (Seit 2.59) 5 Postleitzahl (PLZ). (Seit 2.59) 6 Straße. (Seit 2.59) 7 Kreuzung. (Seit 2.59) 8 Adresse. (Seit 2.59) ---------------------------------------------------------------------------------- @param String Der gesuchte Strassenname @param String Die gesuchte Hausnummer @param String Der gesuchte Ort */ function getGmapAdressinfo($strasse, $hausNr, $ort) { // Koordinaten bei google abrufen $adressSearchString = $strasse . "%20" . $hausNr . "+" . $ort; $tempUrlString = "http://maps.google.com/maps/geo?q=" . str_replace(" ", "%20", $adressSearchString) . "&output=csv&key=" . getPageConfigParam($_SESSION['config']->DBCONNECT, "google_maps_API_key"); $googleAdressInformations = file_get_contents($tempUrlString, 'r'); $arr = explode(",", $googleAdressInformations); return $arr; }
function getPauseLink() { $loginNeed = getPageConfigParam($_SESSION['config']->DBCONNECT, "loginForTimelinePauseNeed") == "J"; $loggedIn = $_SESSION['config']->CURRENTUSER->STATUS == "admin" || $_SESSION['config']->CURRENTUSER->STATUS == "user"; if ($this->isNextExecutionCron() && ($loginNeed && $loggedIn || !$loginNeed)) { if ($this->isCronPaused()) { return $this->getPauseDeactivationLink(); } else { return $this->getPauseActivationLink(); } } else { return new Spacer(0); } }
function logout() { $this->CONFIG->LOG->add("Logout"); $this->VORNAME = ""; $this->NACHNAME = ""; $this->USERNAME = ""; $this->USERID = ""; $this->STATUS = ""; $this->EMAIL = ""; $_REQUEST['menuParent'] = "Treffpunkt"; $RUNLINKS = new RunLinks($_SESSION['config']->DBCONNECT, "mainpage"); $_SESSION['MENU_PARENT'] = $_REQUEST['menuParent']; $_REQUEST['run'] = getPageConfigParam($_SESSION['config']->DBCONNECT, "default_runlink"); $_SESSION['mainpage'] = $_REQUEST['run']; }
<?php //Filename: Startseite.php $loginNeed = getPageConfigParam($_SESSION['config']->DBCONNECT, "loginForSwitchNeed") == "J"; $loginExternOnly = getPageConfigParam($_SESSION['config']->DBCONNECT, "loginExternOnly") == "J"; $loginOK = $_SESSION['config']->CURRENTUSER->STATUS == "admin" || $_SESSION['config']->CURRENTUSER->STATUS == "user"; $clientIP = explode(".", $_SERVER['REMOTE_ADDR']); $serverIP = explode(".", $_SERVER['SERVER_ADDR']); if (!$loginNeed || $loginOK || $loginExternOnly && ($serverIP[0] == $clientIP[0] && $serverIP[1] == $clientIP[1] && $serverIP[2] == $clientIP[2])) { $hcMap = new HomeControlMap(false, "MOBILE"); $hcMap->show(); } else { /* ------------------------------------ BENUTZERSTATUS ANZEIGEN ------------------------------------ */ $USR = $_SESSION['config']->CURRENTUSER; $USERSTATUS = new UserStatus($USR, -1, -1); $tbl = new Table(array("")); $tbl->setAlign("center"); $r = $tbl->createRow(); $r->setAttribute(0, $USERSTATUS); $tbl->addRow($r); $tbl->show(); /* --------------------------------- */ }
<?php echo "<html xmlns='http://www.w3.org/1999/xhtml' xml:lang='de' lang='de'>\r\n\t\t<meta http-equiv='Content-Type' content='text/html; charset=utf8' />\r\n\r\n\t \t<head>\r\n "; // <script language='javascript'>AC_FL_RunContent = 0;</script> // <script src='AC_RunActiveContent.js' language='javascript'></script> // <script type='text/javascript' src='scripts/swfobject.js'></script> include_once "generateCss.php"; // <META NAME=”GOOGLEBOT” CONTENT=”unavailable_after: 25-Aug-2007 15:00:00 GMT”> echo "\r\n <!-- Inhaltsangaben / Inhaber -->\r\n <meta name='description' content='" . htmlspecialchars($PUBLICVARS['pagetitel'], ENT_QUOTES) . " " . htmlspecialchars($PUBLICVARS['suchbegriffe'], ENT_QUOTES) . " '>\r\n <meta name='author' content='" . getPageConfigParam($_SESSION['config']->DBCONNECT, "pageowner") . "' >\r\n\t <meta name='page-topic' Content='Dienstleistung, Internet'>\r\n\t <meta name='keywords' lang='de' content='" . htmlspecialchars($PUBLICVARS['pagetitel'], ENT_QUOTES) . " " . htmlspecialchars($PUBLICVARS['suchbegriffe'], ENT_QUOTES) . " Daniel Scheidler '> \r\n <meta name='audience' Content='Zielgruppe'>\r\n <meta name='publisher' content='*****@*****.**'>\r\n \r\n <!-- Standardeinstellungen --> \r\n <meta http-equiv='Content-Type' content='text/html; charset=utf8'>\r\n <link rev='made' content='mailto:d.scheidler@web.de'>\r\n <meta name='copyright' content='*****@*****.**'>\r\n"; $default_title = $PUBLICVARS['pagetitel']; $currRunLnkName = getTextByRunlink($_SESSION['runLink']); $sub_title = isset($PUBLICVARS['pagesubtitel']) ? $PUBLICVARS['pagesubtitel'] : ""; $ttl = strlen($currRunLnkName) > 0 ? $PUBLICVARS['pagetitel'] . " - " . $currRunLnkName : $PUBLICVARS['pagetitel']; echo "<title> " . $ttl . " </title>"; $detect = new Mobile_Detect(); if (!$detect->isMobile()) { echo " \r\n <!-- CK Editor -->\r\n \t<script type=\"text/javascript\" src=\"ckeditor/ckeditor.js\"></script>\r\n \t<script src=\"ckeditor/ckedit_cbo.js\" type=\"text/javascript\"></script>\r\n \t<link href=\"ckeditor/ckedit_cbo.css\" rel=\"stylesheet\" type=\"text/css\" />\r\n \t<script type=\"text/javascript\">\r\n CKEDITOR.config.customConfig = 'ckeditor/config.js';\r\n\t CKEDITOR.config.enterMode = CKEDITOR.ENTER_BR;\r\n CKEDITOR.config.forceEnterMode = false;\r\n \t</script>\r\n\r\n "; } echo "\r\n </head>\r\n \r\n \r\n <body class='indexbody' onload='uhrzeit('jetzt'); setInterval('uhrzeit()', 1000); initialize()' onunload='GUnload()'>\r\n \r\n\t\r\n\t<!-- Tooltips -->\r\n\t <script type='text/javascript' src='scripts/calendar_popup.js'></script>\r\n\t <script type=\"text/javascript\" src=\"scripts/tooltip.js\"></script>\r\n\t <script type=\"text/javascript\" src=\"scripts/tooltip_menu.js\"></script>\r\n\t\r\n\t<!-- Pop-Up anzeigen-->\r\n\t <script type=\"text/javascript\" src=\"scripts/popup.js\"></script>\r\n\t\r\n\t\r\n\t<!-- Spans Sichtbar/Unsichtbar machen -->\r\n\t <script type=\"text/javascript\" src=\"scripts/makeVisible.js\"></script>\r\n \r\n \r\n <!-- Werte von Objekten ändern (value von Text bzw Hidden-Field ) -->\t \r\n <script type=\"text/javascript\" src=\"scripts/changeValue.js\"></script>\r\n "; if (!$detect->isMobile()) { echo "\r\n \t<div id=\"alerts\">\r\n\t\t<noscript>\r\n\t\t\t<p>\r\n\t\t<strong>Einige Funktionen dieser Webseite benötigen JavaScript!</strong>.<br>\r\n In einem Browser wie z.B. ihrem, werden daher einige Funktionen deaktiviert.\r\n Für vollen Funktionsumfang installieren Sie bitte JavaScript bzw. aktivieren Sie die JS-Funktionen in den Sicherheitseinstellungen.\r\n\t\t\t</p>\r\n\t\t</noscript>\r\n\t</div>\r\n\r\n "; } function getTextByRunlink($id) { $sql = "SELECT * FROM menu WHERE (link LIKE '%run=" . $id . "%') "; $result = $_SESSION['config']->DBCONNECT->executeQuery($sql); if (mysql_num_rows($result) > 0) { $r = mysql_fetch_array($result); return $r['text']; } return "";
function getArduinoUrlForDeviceId($hcConfigId, $dbConnect) { $selectSenderIP = "SELECT ip FROM `homecontrol_sender` WHERE id = (SELECT sender_id FROM homecontrol_config WHERE id = " . $hcConfigId . " )"; $rslt = $dbConnect->executeQuery($selectSenderIP); $r = mysql_fetch_array($rslt); if (isset($r['ip']) && strlen($r['ip']) > 0) { return "http://" . $r['ip'] . "/rawCmd"; } else { // Wenn keine Sender-IP zum Device ermittelt werden kann, Default holen. $selectSenderIP = "SELECT ip FROM `homecontrol_sender` WHERE default_jn = 'J'"; $rslt = $dbConnect->executeQuery($selectSenderIP); $r = mysql_fetch_array($rslt); if (isset($r['ip']) && strlen($r['ip']) > 0) { return "http://" . $r['ip'] . "/rawCmd"; } } // wird keine IP gefunden: FallBack auf altes Vorgehen return "http://" . getPageConfigParam($dbConnect, 'arduino_url'); }
/** * DbTable($con, $tbname="", $cols=array("*"), $labels="", $defaults="", $o="", $w="") * * @param $con * @param $tbname="" * @param $cols=array("*") * @param $labels="" * @param $defaults="" * @param $o="" * @param $w="" */ function DbTable($con, $tbname = "", $cols = array("*"), $labels = "", $defaults = "", $o = "", $w = "") { //Konstruktor $this->initialized = false; $this->ROWS = array(); $this->DBCONNECT = $con; $this->TABLENAME = $tbname; $this->setColNames($cols); $this->FIELDNAMES = $this->getFieldNames(); $this->LABELS = array(); $this->DEFAULTS = $defaults; $this->COLNAMESTRING = ""; $this->HEAD_ENABLED = false; $this->DELETE_IN_UPDATE = false; $this->setWhere($w); $this->setOrderBy($o); $this->MAX_ROWS_TO_FETCH = getPageConfigParam($_SESSION['config']->DBCONNECT, "max_rowcount_for_dbtable"); $this->setLimitActive(false); if (isset($_SESSION['tmp']['CURRENT_PAGE_' . $this->TABLENAME]) && strlen($_SESSION['tmp']['CURRENT_PAGE_' . $this->TABLENAME]) > 0) { $this->CURRENT_PAGE = $_SESSION['tmp']['CURRENT_PAGE_' . $this->TABLENAME]; } else { $this->CURRENT_PAGE = 1; $_SESSION['tmp']['CURRENT_PAGE_' . $this->TABLENAME] = 1; } if (isset($_REQUEST["changeDbPage" . $this->TABLENAME]) && $_REQUEST["changeDbPage" . $this->TABLENAME] > 0) { $this->CURRENT_PAGE = $_REQUEST["changeDbPage" . $this->TABLENAME]; $_SESSION['tmp']['CURRENT_PAGE_' . $this->TABLENAME] = $_REQUEST["changeDbPage" . $this->TABLENAME]; } $this->NOINSERTCOLS = array(); $this->NOUPDATECOLS = array(); $this->READONLYCOLS = array(); $this->INVISIBLECOLS = array(); $this->DEFAULT_HIDDEN_FIELDS = new Container(); // Falls keine Spaltennamen übergeben -> ALLE ermitteln if ($this->COLNAMES[0] == "*") { $stmnt = "SELECT *, id as rowid FROM " . $this->TABLENAME . " LIMIT 1 "; $result = $this->DBCONNECT->executeQuery($stmnt); //Spaltennamen in array setzen for ($i = 0; $i < mysql_num_fields($result); $i++) { $fldName = mysql_field_name($result, $i); if ($fldName != "rowid") { $this->COLNAMES[$i] = $fldName; } } } // ------------------------------------------------------- if (count($this->COLNAMES) > 0) { $chk = 0; foreach ($this->COLNAMES as $cn) { if ($chk > 0) { $this->COLNAMESTRING .= ", "; } $this->COLNAMESTRING .= $cn; $chk++; } } //----------------------------- // Übergebene Labels prüfen // und falls nicht gesetzt // automatisch setzen. //----------------------------- if (strlen($labels) >= 2) { $this->LABELS = explode(',', $labels); } else { $chk = 0; $stmnt = "SELECT "; foreach ($this->COLNAMES as $cn) { if ($chk > 0) { $stmnt .= ", "; } $stmnt .= $cn; $chk++; } $stmnt .= " FROM " . $this->TABLENAME . " LIMIT 1 "; //echo $stmnt; $result = $this->DBCONNECT->executeQuery($stmnt); for ($i = 0; $i < mysql_num_fields($result); $i++) { $fldName = mysql_field_name($result, $i); $this->LABELS[$i] = $fldName; } } $this->setLimitActive(false); $this->checkTableStructure(); $this->initialized = true; $this->refresh(); }
<?php include "init.php"; echo "\r\n\t<html>\r\n \t <head>\r\n \t \t \r\n \t <script type='text/javascript' src='scripts/calendar_popup.js'></script>\r\n\t <script src=\"http://maps.google.com/maps?file=api&v=2.x&sensor=false&key=" . getPageConfigParam($_SESSION['config']->DBCONNECT, "google_maps_API_key") . "\" type=\"text/javascript\"></script>\r\n\t <script type=\"text/javascript\">\r\n\t function initialize() {\r\n\t if (GBrowserIsCompatible()) {\r\n\t var map = new GMap2(document.getElementById(\"map_canvas\"));\r\n\t map.setCenter(new GLatLng(37.4419, -122.1419), 13);\r\n\t map.setUIToDefault();\r\n\t }\r\n\t }\r\n </script>\r\n \r\n <title>" . $PAGETITEL . "</title>\r\n "; include_once "generateCss.php"; echo "\r\n\t <meta http-equiv='Content-Type' content='text/html; charset=windows-1252'>\r\n <meta name='keywords' lang='de' content='" . $PAGETITEL . "'> \r\n\r\n </head>\r\n\t <body class='iframebody'>\r\n ";
<?php $timelineDuration = getPageConfigParam($_SESSION['config']->DBCONNECT, "timelineDuration"); $loginNeed = getPageConfigParam($_SESSION['config']->DBCONNECT, "loginForTimelinePauseNeed") == "J"; $loggedIn = $_SESSION['config']->CURRENTUSER->STATUS == "admin" || $_SESSION['config']->CURRENTUSER->STATUS == "user"; $spc = new Spacer(20); $ln = new Line(); $weekDays = array(0 => "sonntag", 1 => "montag", 2 => "dienstag", 3 => "mittwoch", 4 => "donnerstag", 5 => "freitag", 6 => "samstag"); $dayOfWeek = date("w", time()); $w = "(tagnr=" . $dayOfWeek . " AND ((stunde >= " . date("H") . " AND minute > " . date("i") . " ) OR (stunde > " . date("H") . "))) OR "; $o = "if( ((tagnr=" . $dayOfWeek . " AND ((stunde >= " . date("H") . " AND minute > " . date("i") . " ) OR (stunde > " . date("H") . "))) OR (tagnr!=" . $dayOfWeek . ") ) AND tagnr-" . $dayOfWeek . ">=0 ,tagnr-" . $dayOfWeek . ", tagnr+(7-" . $dayOfWeek . ")), stunde, minute"; if ($timelineDuration > 1) { for ($tmpDays = 1; $tmpDays < $timelineDuration; $tmpDays++) { $dayOfWeek = $dayOfWeek < 6 ? $dayOfWeek + 1 : 0; $w .= "tagnr=" . $dayOfWeek . " OR "; } } $nextDayOfWeek = $dayOfWeek < 6 ? $dayOfWeek + 1 : 0; //Where (Aktueller und nächster Wochentag) $w .= " (tagnr=" . $nextDayOfWeek . " AND ((stunde <= " . date("H") . " AND minute <= " . date("i") . " ) OR " . "(stunde < " . date("H") . ")))"; $scDbTable = new DbTable($_SESSION['config']->DBCONNECT, 'homecontrol_cronview', array("wochentag", "tagnr", "name", "montag", "dienstag", "mittwoch", "donnerstag", "freitag", "samstag", "sonntag", "stunde", "minute", "id"), "Wochentag, Tag Nr, Name, Mo, Di, Mi, Do, Fr, Sa, So, Std, Min", "", $o, $w); // -------------------------------------------- $t = new Title("Timeline"); $t->show(); $tbl = new Table(array("", "", "")); $tbl->setBackgroundColorChange(true); foreach ($scDbTable->ROWS as $row) { $cron = new HomeControlCron($row); $cron->checkPauseLink(); $r = $tbl->createRow(); $r->setAlignments(array("left", "left", "right"));
function validateLink() { // WENN KEIN TEXT GEFÃÂÃÂÃÂÃÂLLT -> ZIEL ANZEIGEN if (!method_exists($this->TEXT, "show") && strlen($this->TEXT) == 0) { $this->TEXT = $this->HREF; } if (!$this->getValidate()) { return; } $currentPath = dirname($_SERVER['SCRIPT_NAME']); if (substr($currentPath, strlen($currentPath) - 1) != "/" && strlen($currentPath) > 1) { $currentPath .= "/"; } // WENN LOKALER LINK -> VERVOLLSTÃÂÃÂÃÂÃÂNDIGEN if (strtolower(substr($this->HREF, 0, 7)) != "http://" && strtolower(substr($this->HREF, 0, 3)) != "www" && strtolower(substr($this->HREF, 0, 6)) != "ftp://" && $this->HREF != "#" && $this->HREF != "") { $pageProt = getPageConfigParam($_SESSION['config']->DBCONNECT, "https_active"); if ($pageProt === true || $pageProt == "true") { $protokoll = "https://"; } else { $protokoll = "http://"; } $this->HREF = $protokoll . $_SERVER['HTTP_HOST'] . $currentPath . $this->HREF; } }
function getFunkIdCombo($name, $leerEintrag = false, $default = null) { $cobArr = array(); if ($leerEintrag) { $cobArr[''] = " "; } $usedFunkIds = $this->getUsedFunkIds(); // Wenn BT-Switch aktiv stehen 80 IDs mehr zur Verfuegung $maxFunkId = getPageConfigParam($_SESSION['config']->DBCONNECT, "btSwitchActive") == "J" ? 386 : 306; for ($i = 1; $i <= $maxFunkId; $i++) { if (!existsInArray($i, $usedFunkIds) || $default == $i) { $code = $i; $value = $i; $cobArr[$code] = $value; } } $cob = new Combobox($name, $cobArr, $default); return $cob; }
$gesamtBreite = $_SESSION['tmp']['gMap_Width']; } if (isset($_SESSION['tmp']['gMap_Height']) && $_SESSION['tmp']['gMap_Height'] > 0) { $gesamtHoehe = $_SESSION['tmp']['gMap_Height']; } // Wenn Position von anderem Spieler angezeigt werden soll: if (isset($_SESSION['tmp']['gMap_GpsPosition_RowId']) && $_SESSION['tmp']['gMap_GpsPosition_RowId'] > 0) { $dbTableAdressen = new DbTable($_SESSION['config']->DBCONNECT, "gpsPositions", array("*"), "", "", "", " id = " . $_SESSION['tmp']['gMap_GpsPosition_RowId'] . " "); $adressRow = $dbTableAdressen->getRow(1); // Zu Zentrierende Adresse $userId = $adressRow->getNamedAttribute("user_id"); $user = getUsernameById($userId); $breitenGrad = $adressRow->getNamedAttribute("longitude"); $laengenGrad = $adressRow->getNamedAttribute("latitude"); } echo " <script src=\"http://maps.google.com/maps?file=api&v=2.x&sensor=false&key=" . getPageConfigParam($_SESSION['config']->DBCONNECT, "google_maps_API_key") . "\" type=\"text/javascript\"></script>\r\n\t\t <script src=\"http://www.google.com/uds/api?file=uds.js&v=1.0&key=" . getPageConfigParam($_SESSION['config']->DBCONNECT, "google_maps_API_key") . "\" type=\"text/javascript\"></script>\r\n\t\t <script src=\"http://www.google.com/uds/solutions/localsearch/gmlocalsearch.js\" type=\"text/javascript\"></script>\r\n\r\n\t \t <style type=\"text/css\">\r\n\t\t @import url(\"http://www.google.com/uds/css/gsearch.css\");\r\n\t\t @import url(\"http://www.google.com/uds/solutions/localsearch/gmlocalsearch.css\");\r\n\t\t </style>\r\n\t\t \r\n\t\t <script language=\"javascript\">\r\n\t\t var map;\r\n\t\t\t var mgr;\r\n\t function createMarker(posn, ttl, icn) {\r\n\t\t\t var marker = new GMarker(posn, {title: ttl, icon: icn, draggable:false });\r\n\t\t\t \r\n\t\t\t return marker;\r\n\t\t\t }\r\n\r\n\t\t\t function centerMapTo(x,y) {\r\n\t\t\t map.setCenter(new GLatLng( x, y), 11);\r\n\t\t\t }\r\n\r\n\t\t\t \r\n\r\n\t\t function initialize() {\r\n\t\t \t\r\n\t\t if (GBrowserIsCompatible()) {\r\n\t\t\t var allmarkers = [];\r\n\t\t\t \r\n\t\t\t\t" . getHeaderMapDefinition($breitenGrad, $laengenGrad, $gesamtBreite, $gesamtHoehe, $zoomFaktor) . "\r\n\t\t\t\t\r\n\t\t\t\t// Erstellt die kleinen Markierungssymbole\r\n\t\t\t\t" . getHeaderIconDefinitions() . "\r\n\t\t\t\t\r\n // Bereitet die Liste der POIs vor\r\n\t\t\t\t" . getHeaderPOIEntryDefinitions() . "\r\n\t\t\t }\r\n \r\n \r\n\t\t GSearch.setOnLoadCallback(initialize);\r\n\t\t\t}\r\n \r\n\r\n\t\t </script> \r\n "; /* NOTIZEN: GLatLng(myLatitude, myLongitude) WK Längen und Breitengrad: B: 51.15 / L: 7.21667 2582445.667, -5667001.07 */ /* In diesem Beispiel wird eine statische Datei ("data.xml"), die eine Liste von Längen- und Breitenkoordinaten in XML enthält, mithilfe der Methode GDownloadUrl heruntergeladen. Wenn der Herunterladevorgang abgeschlossen ist, wird das XML mit GXml analysiert und eine Markierung an jedem dieser Punkte im XML-Dokument erstellt. ----------------------------------------------------------------------------------------------------------
/** * show-Methode (wertet automatisch den gesetzten Typ aus) -> siehe setMenuType($t) */ function show() { if ($this->MENUTYPE == "buttons") { $this->showWithButtons(getPageConfigParam($_SESSION['config']->DBCONNECT, "hauptmenu_button_image"), getPageConfigParam($_SESSION['config']->DBCONNECT, "hauptmenu_button_image_hover")); } else { if ($this->MENUTYPE == "horizontal") { $this->showHorizontalMenu(); } else { if ($this->MENUTYPE == "horizontalbutton") { $this->showHorizontalButtonMenu(); } else { $this->showNormalMenu(); } } } }