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;
}
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;
}
/**
* Liefert die Anzahl der Unterthemen des angegebenen Threads
*
* @param $CurrentThreadtitle Name des aktuellen Themas
*/
function getForumThreadCount($CurrentThreadtitle)
{
$dbTable = new DbTable($_SESSION['config']->DBCONNECT, 'forum', array("title"), "Titel", "", "", "parent='" . $CurrentThreadtitle . "' ");
return $dbTable->getRowCount();
}
function addFriendRequest($userId, $friendId)
{
$dbTblFriends = new DbTable($_SESSION['config']->DBCONNECT, "freundesliste", array("user_id", "friend_id", "accepted"), "", "accepted = 'N'", "", "user_id=" . $userId . " AND friend_id=" . $friendId);
if ($dbTblFriends->getRowCount() > 0) {
echo "Dieser Benutzer ist bereits in Ihrer Freundesliste, oder Sie haben bereits eine Anfrage gestellt.";
return;
}
$dbRowNewFriend = $dbTblFriends->createRow();
$dbRowNewFriend->setNamedAttribute("user_id", $userId);
$dbRowNewFriend->setNamedAttribute("friend_id", $friendId);
$dbRowNewFriend->setNamedAttribute("accepted", "N");
$dbRowNewFriend->insertIntoDB();
echo "Freundesanfrage gesendet";
}
function existsUsername($name)
{
$dbTblUser = new DbTable($this->DBCONNECT, "user", array("*"), "", "", "", "User = '******' ");
return $dbTblUser->getRowCount() > 0;
}
/**
* Zeigt das gesamte DIV an
*/
function show()
{
echo "<div ";
if ($this->XPOS > 0 || $this->YPOS > 0) {
$tmp = ":absolute; ";
if ($this->YPOS > 0) {
$tmp .= " top:" . $this->YPOS . "px; ";
}
if ($this->XPOS > 0) {
$tmp .= " left:" . $this->XPOS . "px; ";
}
$this->setStyle("position", $tmp);
}
$this->getToolTipTag();
$this->showStyles();
echo " > ";
if ($this->KOPFTEXT_NEED) {
/*
* Bei berechtigung, Kopftext bearbeiten.
*/
if ($_SESSION['config']->CURRENTUSER->STATUS == "admin" || $_SESSION['config']->CURRENTUSER->STATUS == "user") {
if (isset($_REQUEST['changeHeadInfo']) && strlen($_REQUEST['changeHeadInfo']) > 5) {
$ktRl = substr($_REQUEST['changeHeadInfo'], 5);
$dbtbl = new DbTable($_SESSION['config']->DBCONNECT, "kopftexte", array("text"), "", "", "", "runlink = '" . $ktRl . "' ");
if ($dbtbl->getRowCount() == 0) {
$dbtblInsert = new DbTable($_SESSION['config']->DBCONNECT, "kopftexte", array("runlink", "parent", "text"), "", "", "", "runlink = '" . $ktRl . "' ");
$dbtblInsert->insertRowByArray(array($ktRl, null, ""));
$dbtbl->refresh();
}
if (isset($_REQUEST['DbTableUpdate' . $dbtbl->TABLENAME]) && $_REQUEST['DbTableUpdate' . $dbtbl->TABLENAME] == "Speichern") {
$dbtbl->doUpdate();
}
$frm = $dbtbl->getUpdateAllMask();
$frm->add(new Hiddenfield("changeHeadInfo", $_REQUEST['changeHeadInfo']));
$frm->show();
} else {
$sp = new Spacer(5);
$sp->show();
$txKtb = new Text("Kopftext bearbeiten<br>");
$txKtb->setFilter(false);
$lnk = new Link("?changeHeadInfo=Cnge-" . $_SESSION['runLink'], $txKtb);
$lnk->show();
}
}
$tx = new Text(getKopfText());
$tx->setFilter(false);
$tx->show();
}
if ($this->getObjectCount() > 0) {
foreach ($this->OBJECTS as $obj) {
$obj->show();
}
}
//--------------
include $this->FILE;
//--------------
echo "</div>";
}
