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();
}
}
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();
$dbTblBenutzer->refresh();
} else {
if (isset($_REQUEST[$dbTblBenutzer->getNewEntryButtonName()])) {
$dbTblBenutzer->setBorder(0);
$insMsk = $dbTblBenutzer->getInsertMask();
$hdnFld = $insMsk->getAttribute(1);
if ($hdnFld instanceof Hiddenfield) {
$insMsk->setAttribute(1, new Hiddenfield($dbTblBenutzer->getNewEntryButtonName(), "-"));
}
$rNew = $tblMain->createRow();
$rNew->setAttribute(0, $insMsk);
$rNew->setSpawnAll(true);
$tblMain->addRow($rNew);
$tblMain->addSpacer(0, 10);
} else {
$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
// --------------------------------------------------
if (isset($_REQUEST["DbTableUpdate" . $alarmgeberDBTbl->TABLENAME])) {
$alarmgeberDBTbl->doUpdate();
}
$mskUpdate = $alarmgeberDBTbl->getUpdateAllMask();
$mskUpdate->show();
$spc = new Spacer();
$spc->setHeight(10);
$spc->show();
if (!isset($_REQUEST['dbTableNew' . $alarmgeberDBTbl->TABLENAME])) {
$newBtn = $alarmgeberDBTbl->getNewEntryButton("Neuen Alarmgeber anlegen");
$newBtn->show();
$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);
// Neuer Eintrag
if (isset($_REQUEST['InsertIntoDB' . $regelItemsDbTable->TABLENAME]) && $_REQUEST['InsertIntoDB' . $regelItemsDbTable->TABLENAME] == "Speichern") {
$regelItemsDbTable->doInsert();
$regelItemsDbTable->refresh();
} else {
if (isset($_REQUEST[$regelItemsDbTable->getNewEntryButtonName()])) {
$regelItemsDbTable->setBorder(0);
$insMsk = $regelItemsDbTable->getInsertMask();
$hdnFld = $insMsk->getAttribute(1);
if ($hdnFld instanceof Hiddenfield) {
$insMsk->setAttribute(1, new Hiddenfield($regelItemsDbTable->getNewEntryButtonName(), "-"));
}
$rNew = $itemsTable->createRow();
$rNew->setSpawnAll(true);
$rNew->setAttribute(0, $insMsk);
$itemsTable->addRow($rNew);
$itemsTable->addSpacer(0, 10);
}
$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();
}
}
$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);
if ($hdnFld instanceof Hiddenfield) {
$insMsk->setAttribute(1, new Hiddenfield("dbTableNewhomecontrol_cron_items", "-"));
}
$insMsk->show();
}
}
if (isset($_REQUEST["DbTableUpdate" . $scItemsDbTable->TABLENAME])) {
$scItemsDbTable->doUpdate();
}
$dbTblSender->setColSizes(array("200", "40", "60", "90", "50", "50", "50"));
$deleteMask = null;
if ($dbTblSender->isDeleteInUpdate()) {
$deleteMask = !$dbTblSender->doDeleteFromUpdatemask() ? null : $dbTblSender->doDeleteFromUpdatemask();
}
if ($deleteMask != null) {
$rDel = $tblMain->createRow();
$rDel->setAttribute(0, $deleteMask);
$rDel->setSpawnAll(true);
$tblMain->addRow($rDel);
}
$newSwitchBtn = new Text("");
// Neuer Eintrag
if (isset($_REQUEST['InsertIntoDBhomecontrol_sender']) && $_REQUEST['InsertIntoDBhomecontrol_sender'] == "Speichern") {
checkDefaultSender($dbTblSender->ROWS);
$dbTblSender->doInsert();
$dbTblSender->refresh();
} else {
if (isset($_REQUEST[$dbTblSender->getNewEntryButtonName()])) {
$dbTblSender->setBorder(0);
$insMsk = $dbTblSender->getInsertMask();
$hdnFld = $insMsk->getAttribute(1);
if ($hdnFld instanceof Hiddenfield) {
$insMsk->setAttribute(1, new Hiddenfield($dbTblSender->getNewEntryButtonName(), "-"));
}
$rNew = $tblMain->createRow();
$rNew->setAttribute(0, $insMsk);
$rNew->setSpawnAll(true);
$tblMain->addRow($rNew);
$tblMain->addSpacer(0, 10);
} else {
