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,