function getShortcutImageString($configId, $width = 50) { $ret = ""; $configDb = new DbTable($_SESSION['config']->DBCONNECT, 'homecontrol_config', array("*"), "", "", "", "id=" . $configId); if ($configDb->getRow(1) != null) { $itm = new HomeControlItem($configDb->getRow(1), false); $ret = "<img src='" . $itm->getPic() . "' width='" . $width . "'>"; } return $ret; }
function getHeaderPOIEntryDefinitions($zoomFaktor = 14) { $dbTablePOI = new DbTable($_SESSION['config']->DBCONNECT, "gpsPositions", array("id", "timeonupdate", "longitude", "latitude", "altitiude", "accuracy", "user_id"), "", "", " IF( user_id = " . $_SESSION['config']->CURRENTUSER->USERID . " , 1, 0 ) ", ""); $rowCount = $dbTablePOI->getRowCount(); $ret = " \r\n\t\t\tvar markers = [];\r\n\t\t\ticon = null;\r\n\t\t\ttitle = \"\";\r\n\t\t\tposn = null;\r\n\t\t\t \r\n\t\t\tallmarkers.length = 0;\r\n\r\n\t\t\tmgr = new GMarkerManager(map);\r\n\t "; for ($i = 1; $i <= $rowCount && $rowCount > 0; $i++) { $poiRow = $dbTablePOI->getRow($i); // Ermittelter POI $userId = $poiRow->getNamedAttribute("user_id"); $user = getUserFullnameById($poiRow->getNamedAttribute("user_id")); $lg = $poiRow->getNamedAttribute("latitude"); $bg = $poiRow->getNamedAttribute("longitude"); $ret .= "\r\n\t\t\t\tmarker" . $userId . " = null; \r\n "; if ($bg != 0 && $lg != 0) { if ($userId != null && $userId == $_SESSION['config']->CURRENTUSER->USERID) { $ret .= "\r\n\t\t\t\t icon = iconCurrent; \r\n\t\t\t\t\t\t \r\n \t\t\t\t\t var myGeographicCoordinates = new GLatLng(" . $bg . ", " . $lg . ");\r\n\t\t \t\t\t map.setCenter(myGeographicCoordinates, " . $zoomFaktor . ");"; } else { if ($userId != null && isUserOnFriendlist($userId)) { $ret .= "\r\n\t\t\t\t icon = icon" . $userId . "; "; } else { $ret .= "\r\n\t\t\t\t icon = blueIcon; "; } } $ret .= "\r\n\t\t\t\t title = \"" . $user . "\" \r\n\t\t\t\t posn = new GLatLng( " . $bg . ", " . $lg . " );\r\n\t\t\t\t marker" . $userId . " = createMarker(posn,title,icon);\r\n \r\n var html" . $userId . " = \"" . getUserMarkerInfoSource($userId) . "\"; \r\n\t\t\t\t \r\n \r\n \r\n \t\t\t\t GEvent.addDomListener(marker" . $userId . ", \"click\", function() {\r\n\t\t\t\t\t\t // document.location.href = \"?showUser="******"\";\r\n marker" . $userId . ".openInfoWindowHtml(html" . $userId . ")\r\n\t\t\t\t\t\t });\r\n\r\n\t\t\t\t \r\n\t\t\t\t\t\t markers.push(marker" . $userId . ");\r\n\t\t\t\t allmarkers.push(marker" . $userId . ");\r\n\t\t\t"; } } $ret .= "\t\r\n mgr.addMarkers(markers, 10); \r\n "; // ------------------------ // Statische POIs // ------------------------ $ret .= "\r\n \t\t\t\t\r\n \t\t\t\tvar wkMarker = [];\r\n\t\t\t\tvar wkText = \"Wermelskirchen\";\r\n\t\t\t\t\r\n\t\t\t\tmarkerWk = createMarker(new GLatLng(51.15, 7.21667), wkText, iconWkWappen); \r\n\t\t\t\twkMarker.push(markerWk);\r\n\t\t\t\t\r\n \t\t\t\tmgr.addMarkers(wkMarker, 6);\r\n \t\t\t\tmgr.refresh();\r\n\t\t\t"; return $ret; }
/** * Liefert eine Tabelle mit einer Kurz-Info zum letzten Eintrag des Threads */ function getLastPostInfo($thread) { $ret = "Kein Eintrag vorhanden!"; $sql = "SELECT f.title, f.parent from forum f, forum_posts p where f.parent='" . $thread . "' or f.title='" . $thread . "' and f.title = p.title and f.parent = p.parent "; $res = $_SESSION['config']->DBCONNECT->executeQuery($sql); while ($rowThread = mysql_fetch_array($res)) { $dbTable = new DbTable($_SESSION['config']->DBCONNECT, 'forum_posts', array("parent", "title", "text", "datum", "autor"), "Titel", "", "datum ASC", "parent='" . $rowThread['parent'] . "' and title='" . $rowThread['title'] . "' "); if ($dbTable->getRowCount() > 0) { $currRow = $dbTable->getRow(1); $autorId = $currRow->getNamedAttribute("autor"); $datum = $currRow->getNamedAttribute("datum"); $ret = getCreateInfo($autorId, $datum); } } return $ret; }
function checkAction($chkVal) { $w = "chkVal='" . $chkVal . "'"; if (isset($_SESSION['config']) && $_SESSION['config']->CURRENTUSER->USERID != null) { $w .= " and user_id=" . $_SESSION['config']->CURRENTUSER->USERID; } $dbTblTest = new DbTable($_SESSION['config']->DBCONNECT, "chkActions", array("*"), "", "", "id desc", $w); if ($dbTblTest->getRowCount() > 0) { $r = $dbTblTest->getRow(1); if ($r->getNamedAttribute("chkVal") == $chkVal) { return false; } } $r = $dbTblTest->createRow(); $r->setNamedAttribute("user_id", $_SESSION['config']->CURRENTUSER->USERID); $r->setNamedAttribute("chkVal", $chkVal); $r->insertIntoDB(); return true; }
function getDbComboWhereStatement($rowDbCombo, $currentRow = null) { $ret = $rowDbCombo['combo_where']; $tmp = split('#', $ret); if (sizeof($tmp) > 1) { $currRowFieldName = $tmp[1]; $whereValue = ""; if ($currentRow != null) { $tmpTbl = new DbTable($_SESSION['config']->DBCONNECT, $rowDbCombo['tab_name'], array("*"), "", "", "id=" . $currentRow["rowid"]); $tmpRow = $tmpTbl->getRow(1); $whereValue = $tmpRow->getNamedAttribute($currRowFieldName); } $ret = $tmp[0] . " '" . $whereValue . "' "; if (sizeof($tmp) > 2) { $ret .= $tmp[2]; } $ret = ""; } return $ret; }
function getLaengeBreiteForAdressId($addressId) { $bg = null; $lg = null; $dbTableAdressen = new DbTable($_SESSION['config']->DBCONNECT, "adressen", array("*"), "", "", "", " id = " . $addressId . " "); $adressRow = $dbTableAdressen->getRow(1); // Zu Zentrierende Adresse $adressId = $adressRow->getNamedAttribute("id"); $strasse = $adressRow->getNamedAttribute("strasse"); $hausNr = $adressRow->getNamedAttribute("hausnummer"); $ort = $adressRow->getNamedAttribute("ort"); $breitenGrad = $adressRow->getNamedAttribute("breitengrad"); $laengenGrad = $adressRow->getNamedAttribute("laengengrad"); if (strlen($breitenGrad) == 0 || strlen($laengenGrad) == 0 && strlen($strasse) > 0 && strlen($ort) > 0) { $gmapInfo = getGmapAdressinfo($strasse, $hausNr, $ort); $breitenGrad = $gmapInfo[2]; $laengenGrad = $gmapInfo[3]; $adressRow->setNamedAttribute("breitengrad", $breitenGrad); $adressRow->setNamedAttribute("laengengrad", $laengenGrad); $adressRow->updateDB(); } return array($breitenGrad, $laengenGrad); }
function getIconPath() { $dbTable = new DbTable($_SESSION['config']->DBCONNECT, 'homecontrol_art', array("pic"), "", "", "", "id=" . $this->ART); $row = $dbTable->getRow(1); return $row->getNamedAttribute("pic"); }
/** * aktualisiert den aktuellen Standort * des angemeldeten Benutzers * * --------------------- * gpsPositions * --------------------- * id * timeonupdate * longitude * latitude * altitiude * accuracy * user_id */ function updateGpsKoords($userId, $long, $lat, $alt = 1, $acc = 1) { $dbKoordsTbl = new DbTable($_SESSION['config']->DBCONNECT, "gpsPositions", array("id", "longitude", "latitude", "altitiude", "accuracy", "user_id"), "Id, Longitude, Latitude, Altitude, Accuracy, Benutzer-Id", "", "", "user_id = " . $userId); $dbKoordsRow = null; // Wenn bereits ein Satz mit Koordinaten existiert // diesen aktualisieren // sonst neu anlegen if ($dbKoordsTbl->getRowCount() == 1) { $dbKoordsRow = $dbKoordsTbl->getRow(1); $dbKoordsRow->setNamedAttribute("longitude", $long); $dbKoordsRow->setNamedAttribute("latitude", $lat); $dbKoordsRow->setNamedAttribute("altitiude", $alt); $dbKoordsRow->setNamedAttribute("accuracy", $acc); $dbKoordsRow->setNamedAttribute("user_id", $userId); $dbKoordsRow->updateDB(); } else { if ($dbKoordsTbl->getRowCount() > 1) { // Wenn mehrere Sätze zu benutzer existieren, // alle löschen und neuen Satz anlegen. $sqlDel = "DELETE FROM gpsPositions WHERE user_id =" . $userId; $_SESSION['config']->DBCONNECT->executeQuery($sql); } // Ab hier neuen Eintrag erzeugen $dbKoordsRow = $dbKoordsTbl->createRow(); $dbKoordsRow->setNamedAttribute("longitude", $long); $dbKoordsRow->setNamedAttribute("latitude", $lat); $dbKoordsRow->setNamedAttribute("altitiude", $alt); $dbKoordsRow->setNamedAttribute("accuracy", $acc); $dbKoordsRow->setNamedAttribute("user_id", $userId); $dbKoordsRow->insertIntoDB(); } }
function getEtagenImagePath($etage) { $dbTable = new DbTable($_SESSION['config']->DBCONNECT, 'homecontrol_etagen', array("id, pic"), "", "", "", "id=" . $etage); $row = $dbTable->getRow(1); return $row != null ? $row->getNamedAttribute("pic") : "/pics/default_etage.jpg"; }
function getRowById($userId) { $dbTbl = new DbTable($_SESSION['config']->DBCONNECT, "user", array("*"), "", "", "", "id=" . $userId); return $dbTbl->getRow(1); }
$footMenuDiv->setWidth($bannerWidth); $footMenuDiv->setBackgroundColor($_SESSION['config']->COLORS['panel_background']); $footMenuDiv->setBorder(0); $footMenuDiv->setAlign("center"); $footMenu = new DbMenu("Fussmenue"); $footMenu->setHeight(14); $footMenu->setMenuType("horizontal"); $footMenu->setAlign("center"); $footMenu->setFontsize(1); $footMenuDiv->add($footMenu); $fussLayoutRow = $layoutTable->createRow(); $fussLayoutRow->setAttribute(0, $footMenuDiv); $layoutTable->addRow($fussLayoutRow); /* --------------------------------- */ $layoutTable->show(); $arduinoFrame = new IFrame($_SESSION['config'], "arduinoSwitch", -1, -1, 1, 1, 0); $arduinoFrame->show(); // MailSensor $dbSensorTable = new DbTable($_SESSION['config']->DBCONNECT, 'homecontrol_sensor', array("*"), "", "", "", "id=999999999"); if (count($dbSensorTable->ROWS) > 0) { $mailSensorRow = $dbSensorTable->getRow(1); $mailSensor = new HomeControlSensor($mailSensorRow, false); $x = 15; $y = $bannerHeight - 10; echo "<div style=\"position:absolute; left:" . $x . "px; top:" . $y . "px; width:26px; height:26px;\">"; echo $mailSensor->getSensorArtIconSrc(); echo "</div>"; if ($mailSensor->getLastValue() != null) { echo "<div style=\"background-color:#dedede; position:absolute; left:" . ($x + 5) . "px; top:" . ($y + $mailSensor->getControlImageHeight() / 2 - 3) . "px;\"><center><font size=2><b>" . $mailSensor->getLastValue() . "</b></font></center></div>"; } }
function isFunkId2Needed() { $dbTable = new DbTable($_SESSION['config']->DBCONNECT, 'homecontrol_art', array("zweite_funkid_jn"), "", "", "", "id=" . $this->ART); $row = $dbTable->getRow(1); return $row->getNamedAttribute("zweite_funkid_jn"); }
function getEtagenImagePath() { if (isset($_SESSION['aktEtage']) && strlen($_SESSION['aktEtage']) > 0) { $dbTable = new DbTable($_SESSION['config']->DBCONNECT, 'homecontrol_etagen', array("pic"), "", "", "", "id=" . $_SESSION['aktEtage']); $row = $dbTable->getRow(1); return $row != null ? $row->getNamedAttribute("pic") : "/pics/default_etage.jpg"; } else { return "/pics/default_etage.jpg"; } }
* @author Daniel Scheidler * @copyright Mai 2008 * * erwartet die BenutzerId des anzuzeigenden Benutzers in der Variable $_REQUEST['showUserId'] */ if (!isset($_REQUEST['showUserId']) || strlen($_REQUEST['showUserId']) <= 0) { $e = new Error("Fehlender Ãbergabewert", "Keine Eingabe in \$_REQUEST['showUserId'] gefunden"); } $currPath = dirname($_SERVER['SCRIPT_NAME']); $currPath = substr($currPath, 1); if (strlen($currPath) > 0) { $currPath = $currPath . "/"; } //Daten holen $userDBTable = new DbTable($_SESSION['config']->DBCONNECT, 'user', array("*"), "", "", "", "id=" . $_REQUEST['showUserId'] . " "); $userDBRow = $userDBTable->getRow(1); //Daten in Table stecken $userTable = new Table(array("", "")); $userTable->setWidth(400); $userTable->setAlign("left"); $ft = new FontType(); $ft->setFontsize(4); //User-Name $userRow = $userTable->createRow(); $userRow->setSpawnAll(true); $userRow->setAlign("center"); $user = new Text($userDBRow->getNamedAttribute("User")); $userRow->setAttribute(0, $user); $user->setFonttype($ft); $userTable->addRow($userRow); $userTable->addSpacer(0);
$ort = "Wermelskirchen"; $breitenGrad = 51.14; $laengenGrad = 7.21667; // if(isset($_SESSION['tmp']['gMap_Zoom_Faktor']) && $_SESSION['tmp']['gMap_Zoom_Faktor']>0 && $_SESSION['tmp']['gMap_Zoom_Faktor']<=20){ // $zoomFaktor = $_SESSION['tmp']['gMap_Zoom_Faktor']; // } if (isset($_SESSION['tmp']['gMap_Width']) && $_SESSION['tmp']['gMap_Width'] > 0) { $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