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;
}
public function testGeneral()
{
$generator = new DbTable();
$generator->isTestOnly();
$generator->setTestOnly(true);
$generator->generate('picaso_platform_user');
$generator->generate('picaso_platform_core_extension');
}
function checkForInsertBBComment()
{
//$con, $tbname="", $cols=array("*"), $labels="", $defaults="", $o="", $w=""
if (isset($_REQUEST['SaveBBComment']) && isset($_REQUEST['comment']) && strlen($_REQUEST['comment']) > 0 && isset($_REQUEST['BBCommentPic']) && strlen($_REQUEST['BBCommentPic']) > 0) {
$currUserName = $_SESSION['config']->CURRENTUSER->VORNAME . " " . $_SESSION['config']->CURRENTUSER->NACHNAME;
$dbTableComments = new DbTable($_SESSION['config']->DBCONNECT, "bb_comments", array("comment"), "Kommentar", "autor = '" . $currUserName . "', pic = '" . $_REQUEST['BBCommentPic'] . "' ", "id ASC", "pic = '" . $_REQUEST['BBCommentPic'] . "'");
$dbTableComments->doInsert();
}
}
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;
}
/**
* Zeigt die Eingabemaske an, wenn isset($_REQUEST['dbTableNew'])
* ansonsten gibt die Methode false zurÃÂÃÂÃÂück.
*
* return boolean
*/
function showInsertMaskIfNeeded()
{
if (isset($_REQUEST['dbTableNew'])) {
$insert = new DbTable($_SESSION['config']->DBCONNECT, "news", array("Title", "Text", "Datum", "Autor"), "Titel, Text, Datum, Autor", "Datum='" . date("Y-m-d") . "', Autor = '" . $_SESSION['config']->CURRENTUSER->VORNAME . " " . $_SESSION['config']->CURRENTUSER->NACHNAME . "' ", "Datum DESC");
$insert->setBorder(0);
$insert->showInsertMask();
return true;
} else {
return false;
}
}
public static function getInstance()
{
if (self::$_instance === null) {
self::$_instance = new self::$_instanceClassName();
}
return self::$_instance;
}
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);
}
/**
* Sets up the fixture before executing a test method.
* If you override this method, make sure the parent implementation is invoked.
* Otherwise, the database fixtures will not be managed properly.
*/
public function setUp()
{
parent::setUp();
if (is_array($this->fixtures)) {
foreach ($this->fixtures as $fixtureName => $modelClass) {
$tableName = DbTable::model($modelClass)->tableName();
$this->resetTable($tableName);
$rows = $this->loadFixtures($modelClass, $tableName);
if (is_array($rows) && is_string($fixtureName)) {
$this->_rows[$fixtureName] = $rows;
if (isset($modelClass)) {
foreach (array_keys($rows) as $alias) {
$this->_records[$fixtureName][$alias] = $modelClass;
}
}
}
}
}
}
function __construct($table, $fields = "*", $from = "", $where = "", $limit_size = 30)
{
// Вызываем конструктор родительского класса
parent::__construct($table);
// Заполняем поля объекта
$this->fields = $fields;
if ('' == $from) {
$from = $table;
}
$this->from = $from;
$this->where = $where;
$this->limit_size = $limit_size;
// Конструируем sql-запрос (за исключением предложения LIMIT)
// Если нужен более сложный запрос - его необходимо задать после вызова конструктора
// явно заполнив поля объекта $sql
$connector = $this->connector;
global ${$connector};
$this->sql = " SELECT " . $this->fields . " " . " FROM " . $this->from . " " . ${$connector}->sqlGetWhere($where);
//dbg($this->sql);
}
/**
* マイグレーションの状態を表示
*/
public function showStatus()
{
// マイグレーションの一覧
$list = $this->listScripts();
if (count($list) == 0) {
$this->logger->log("migrate nothing");
return 0;
} else {
$code = 0;
foreach ($list as $version) {
if ($this->table->isApplied($version)) {
$this->logger->log("* {$version}");
} else {
$this->logger->log(" {$version}");
$code = 1;
}
}
return $code;
}
}
/**
* Remover um Arquivo no Banco de Dados
*
* Durante a remoção de um arquivo do sistema, precisamos remover a sua
* entrada no banco de dados para que este não seja mais selecionado. A
* remoção pode ser lógica, somente desabilitando a música no conjunto ou
* retirando-a totalmente do sistema.
*
* @param string $filename Nome do Arquivo para Remoção
* @param bool $complete Remover a Entrada do Banco de Dados
* @return Musics Próprio Objeto para Encadeamento
*/
public function removeFilename($filename, $complete = false)
{
// Conversão
$filename = (string) $filename;
$complete = (bool) $complete;
// Remoção Completa?
if ($complete) {
// Recurso de Banco de Dados
$resource = DbTable::getInstance()->getResource();
// Criação de Statement
$stmt = $resource->prepare('DELETE FROM `musics` WHERE `filename` = :filename');
// Passagem de Parâmetros
$stmt->bindParam(':filename', $filename, SQLITE3_TEXT);
// Execução
$stmt->execute();
} else {
// Remoção Lógica
$this->setEnabled($filename, false);
}
// Encadeamento
return $this;
}
* *
* This program is distributed in the hope that it will be useful, *
* but WITHOUT ANY WARRANTY; without even the implied warranty of *
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the *
* GNU Affero General Public License for more details. *
* *
* You should have received a copy of the GNU Affero General Public License *
* along with this program. If not, see <http://www.gnu.org/licenses/>. *
* *
*******************************************************************************/
global $args, $SqlDatabase, $User;
// Include API
require 'php/friend.php';
// TODO: Only run this the first time ------------------------------------------
// Check database!
$o = new DbTable('DockItem');
if (!$o->LoadTable()) {
$SqlDatabase->query('
CREATE TABLE DockItem
(
ID bigint(20) NOT NULL auto_increment,
`Parent` bigint(20) default \'0\',
UserID bigint(20) default \'0\',
`Application` varchar(255),
ShortDescription varchar(255),
SortOrder int(11) default \'0\',
PRIMARY KEY(ID)
)
');
}
// End run things first time ---------------------------------------------------
<?php
$t = new Title("Benutzer verwalten");
$t->setAlign("left");
$t->show();
$spc = new Spacer(10);
$spc->show();
if ($_SESSION['config']->CURRENTUSER->STATUS == "admin" && !$_SESSION['config']->CURRENTUSER->STATUS == "user") {
$e = new Error("Kein Zugriff", " Sie haben keine Berechtigung für diesen Bereich!");
}
$userTable = new DbTable($_SESSION['config']->DBCONNECT, "user", array("Vorname", "Nachname", "User", "Email", "Status"), "Vorname, Nachname, Benutzername, Email, Status", "", " Vorname ASC ", " User != 'Developer' AND User != 'admin' ");
$userTable->setHeaderEnabled(true);
$userTable->setDeleteInUpdate(true);
$userTable->setToCheck("Vorname, Nachname, User, Email, Status");
// Neuer Eintrag
if (isset($_REQUEST['InsertIntoDBuser']) && $_REQUEST['InsertIntoDBuser'] == "Speichern") {
if ($userTable->doInsert()) {
$userTable->refresh();
}
$spc->show();
} else {
if (isset($_REQUEST[$userTable->getNewEntryButtonName()])) {
$userTable->setBorder(0);
$insMsk = $userTable->getInsertMask();
$hdnFld = $insMsk->getAttribute(1);
if ($hdnFld instanceof Hiddenfield) {
$insMsk->setAttribute(1, new Hiddenfield($userTable->getNewEntryButtonName(), "-"));
}
$insMsk->show();
$spc->show();
}
$rTitle->setAttribute(0, $ttlZuord);
$rTitle->setSpawnAll(true);
$table->addRow($rTitle);
$table->addSpacer(0, 10);
$cobSelect = new ComboBoxBySql($_SESSION['config']->DBCONNECT, "SELECT id, name FROM homecontrol_cron ORDER BY name", "SelectedCronToEdit", isset($_SESSION['SelectedCronToEdit']) ? $_SESSION['SelectedCronToEdit'] : "", "id", "name", " ");
$cobSelect->setDirectSelect(true);
$rAuswahl = $table->createRow();
$rAuswahl->setColSizes(array(120));
$rAuswahl->setAttribute(0, new Text("Job auswaehlen: "));
$rAuswahl->setAttribute(1, $cobSelect);
$table->addRow($rAuswahl);
$table->addSpacer(0, 20);
$form = new Form();
// Zuordnung ausgewählt
if (isset($_SESSION['SelectedCronToEdit']) && strlen($_SESSION['SelectedCronToEdit']) > 0) {
$scItemsDbTable = new DbTable($_SESSION['config']->DBCONNECT, 'homecontrol_cron_items', array("config_id", "art_id", "zimmer_id", "etagen_id", "on_off", "cron_id"), "Objekt, Objekt-Art, Zimmer, Etage, An/Aus, Job", "cron_id=" . $_SESSION['SelectedCronToEdit'], "config_id DESC, zimmer_id DESC, etagen_id DESC", "cron_id=" . $_SESSION['SelectedCronToEdit']);
$scItemsDbTable->setReadOnlyCols(array("id"));
$scItemsDbTable->setNoInsertCols(array("id"));
$scItemsDbTable->setNoUpdateCols(array("cron_id"));
$scItemsDbTable->setDeleteInUpdate(true);
$scItemsDbTable->setHeaderEnabled(true);
$scItemsDbTable->setWidth("100%");
// Neuer Eintrag
if (isset($_REQUEST['InsertIntoDBhomecontrol_cron_items']) && $_REQUEST['InsertIntoDBhomecontrol_cron_items'] == "Speichern") {
$scItemsDbTable->doInsert();
$scItemsDbTable->refresh();
} else {
if (isset($_REQUEST['dbTableNewhomecontrol_cron_items'])) {
$scItemsDbTable->setBorder(0);
$insMsk = $scItemsDbTable->getInsertMask();
$hdnFld = $insMsk->getAttribute(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>";
}
}
public function __construct()
{
parent::__construct();
}
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 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);
}
/**
* 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>";
}
public function __construct($database, $table_name = 'string_store', $comment = '', $string_size = 1024, $string_index_size = 0, $recreate = false)
{
$this->StringSize = $string_size;
$this->StringIndexSize = $string_index_size;
parent::__construct($table_name, $comment, $database, $recreate);
}
}
$table->addSpacer(0, 10);
$newItemBtn = $termDbTable->getNewEntryButton("Neue Bedingung anlegen");
$rZuordnung = $table->createRow();
$rZuordnung->setSpawnAll(true);
$rZuordnung->setAttribute(0, $newItemBtn);
$table->addRow($rZuordnung);
$form = new Form();
$form->add($spc);
$form->add($table);
$form->add($spc);
$form->show();
// -------------------------------------------
// Schaltgruppen
// -------------------------------------------
$regelItemsDbTable = new DbTable($_SESSION['config']->DBCONNECT, 'homecontrol_regeln_items', array("config_id", "art_id", "zimmer_id", "etagen_id", "on_off", "regel_id", "id"), "Objekt, Objekt-Art, Zimmer, Etage, An/Aus", "regel_id=" . $_SESSION['SelectedRegelToEdit'], "config_id DESC, zimmer_id DESC, etagen_id DESC", "regel_id=" . $_SESSION['SelectedRegelToEdit']);
$regelItemsDbTable->setReadOnlyCols(array("id"));
$regelItemsDbTable->setNoInsertCols(array("id"));
$regelItemsDbTable->setNoUpdateCols(array("regel_id", "id"));
$regelItemsDbTable->setDeleteInUpdate(true);
$regelItemsDbTable->setHeaderEnabled(true);
$itemsTable = new Table(array("", ""));
//$itemsTable->setColSizes(array(150));
$itemsTable->setBorder(0);
$ttlItems = new Title("Zu schaltende Objekte");
$ttlItems->setAlign("left");
$itemsTable->addSpacer(0, 15);
$r1Title = $itemsTable->createRow();
$r1Title->setSpawnAll(true);
$r1Title->setAttribute(0, $ttlItems);
$itemsTable->addRow($r1Title);
$t->show();
if ($_SESSION['config']->CURRENTUSER->STATUS != "admin" && $_SESSION['config']->CURRENTUSER->STATUS != "user") {
/* ------------------------------------
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();
/* --------------------------------- */
} else {
$alarmgeberDBTbl = new DbTable($_SESSION['config']->DBCONNECT, "homecontrol_alarm_geber", array("name", "ip"), "", "", "name", "");
$alarmgeberDBTbl->setDeleteInUpdate(true);
$alarmgeberDBTbl->setHeaderEnabled(true);
$alarmgeberDBTbl->setToCheck("name", "ip");
$alarmgeberDBTbl->setWidth("100%");
// --------------------------------------------------
// Neuer Eintrag
// --------------------------------------------------
if (isset($_REQUEST['dbTableNew' . $alarmgeberDBTbl->TABLENAME])) {
$alarmgeberDBTbl->showInsertMask();
}
if (isset($_REQUEST['InsertIntoDB' . $alarmgeberDBTbl->TABLENAME]) && $_REQUEST['InsertIntoDB' . $alarmgeberDBTbl->TABLENAME] == "Speichern") {
$alarmgeberDBTbl->doInsert();
}
// --------------------------------------------------
// Bearbeiten-Maske
/**
* 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();
}
<?php
$tblMain = new Table(array("", ""));
$t2 = new Title("Benutzer-Einstellungen");
$t2->setAlign("left");
$rMainT1 = $tblMain->createRow();
$rMainT1->setSpawnAll(true);
$rMainT1->setAttribute(0, $t2);
$tblMain->addRow($rMainT1);
$dbTblBenutzer = new DbTable($_SESSION['config']->DBCONNECT, 'user', array("Vorname", "Nachname", "User", "Status", "aktiv", "Pw"), "Vorname, Nachname, Benutzername, Status, Aktiv?, Passwort", "", "Nachname, Vorname");
$dbTblBenutzer->setHeaderEnabled(true);
$dbTblBenutzer->setDeleteInUpdate(true);
$dbTblBenutzer->setInvisibleCols(array("Pw"));
$dbTblBenutzer->setNoUpdateCols(array("Pw"));
$dbTblBenutzer->setColSizes(array("200", "40", "60", "90", "50", "50"));
$deleteMask = null;
if ($dbTblBenutzer->isDeleteInUpdate()) {
$deleteMask = !$dbTblBenutzer->doDeleteFromUpdatemask() ? null : $dbTblBenutzer->doDeleteFromUpdatemask();
}
if ($deleteMask != null) {
$rDel = $tblMain->createRow();
$rDel->setAttribute(0, $deleteMask);
$rDel->setSpawnAll(true);
$tblMain->addRow($rDel);
}
$newBenutzerBtn = new Text("");
// Neuer Eintrag
if (isset($_REQUEST['InsertIntoDBuser']) && $_REQUEST['InsertIntoDBuser'] == "Speichern") {
if (isset($_REQUEST['Pw']) && strlen($_REQUEST['Pw']) > 0) {
$_REQUEST['Pw'] = md5($_REQUEST['Pw']);
}
$dbTblBenutzer->doInsert();
<?php require_once 'models/DbTable.php'; $db = new DbTable(); $createTable = file_get_contents(APPLICATION_PATH . DIRECTORY_SEPARATOR . '..' . DIRECTORY_SEPARATOR . 'database' . DIRECTORY_SEPARATOR . 'da1982_termek.sql'); $db->query($createTable); Redirect::to(BASE_URL);
function getIconPath()
{
$dbTable = new DbTable($_SESSION['config']->DBCONNECT, 'homecontrol_art', array("pic"), "", "", "", "id=" . $this->ART);
$row = $dbTable->getRow(1);
return $row->getNamedAttribute("pic");
}
* but WITHOUT ANY WARRANTY; without even the implied warranty of *
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the *
* GNU Affero General Public License for more details. *
* *
* You should have received a copy of the GNU Affero General Public License *
* along with this program. If not, see <http://www.gnu.org/licenses/>. *
* *
*******************************************************************************/
global $SqlDatabase, $args, $User;
//
// Status 0: pending
// Status 1: verified
// Status 2: fixed
//
include_once 'php/friend.php';
$d = new DbTable('FIssue');
if (!$d->Load()) {
$SqlDatabase->query('
CREATE TABLE FIssue
(
`ID` bigint(20) auto_increment NOT NULL,
`IssueID` bigint(20) NOT NULL default \'0\',
`UserID` bigint(20) default NULL,
`Subject` varchar(255),
`ShortDesc` text,
`Description` text,
`Reproduce` text,
`Status` int(11),
`IsDeleted` tinyint(4),
`DateCreated` datetime,
`DateModified` datetime,
