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
