function dbGetLastText(&$session, $pageid) { return dbGetValueByClause($session, T_Text, 'max(id)', 'page=' . (0 + $pageid)); }
function addressEditCard(&$session, $message = null, $card_id = null) { $session->trace(TC_Gui1, 'addressEditCard'); if (!isset($_POST['card_id']) || empty($_POST['card_id'])) { $session->trace(TC_X, 'addressEditCard-2'); if ($card_id == null) { $card_id = dbGetValueByClause($session, Tab_Card, 'min(id)', '1'); } list($books, $firstname, $lastname, $nickname, $emailprivate, $emailprivate2, $phoneprivate, $phoneprivate2, $faxprivate, $mobileprivate, $emailoffice, $emailoffice2, $phoneoffice, $phoneoffice2, $faxoffice, $mobileoffice, $street, $country, $zip, $city, $functions, $notes) = dbGetRecordById($session, Tab_Card, $card_id, 'books,firstname, lastname, nickname, ' . 'emailprivate, emailprivate2, phoneprivate, phoneprivate2, faxprivate, mobileprivate, ' . 'emailoffice, emailoffice2, phoneoffice, phoneoffice2, faxoffice, mobileoffice, ' . 'street, country, zip, city, ' . 'functions, notes'); } else { $session->trace(TC_Gui1, 'addressEditCard-3: ' . $_POST['card_books']); $books = $_POST['card_books']; $firstname = $_POST['card_firstname']; $lastname = $_POST['card_lastname']; $nickname = $_POST['card_nickname']; $emailprivate = $_POST['card_emailprivate']; $emailprivate2 = $_POST['card_emailprivate2']; $phoneprivate = $_POST['card_phoneprivate']; $phoneprivate2 = $_POST['card_phoneprivate2']; $faxprivate = $_POST['card_faxprivate']; $mobileprivate = $_POST['card_mobileprivate']; $emailoffice = $_POST['card_emailoffice']; $emailoffice2 = $_POST['card_emailoffice2']; $phoneoffice = $_POST['card_phoneoffice']; $phoneoffice2 = $_POST['card_phoneoffice2']; $faxoffice = $_POST['card_faxoffice']; $mobileoffice = $_POST['card_mobileoffice']; $street = $_POST['card_street']; $country = $_POST['card_country']; $zip = $_POST['card_zip']; $city = $_POST['card_city']; $functions = $_POST['card_functions']; $notes = $_POST['card_notes']; $card_id = $_POST['card_id']; } guiStandardHeader($session, 'Ändern einer Adresskarte ', Th_AddressHeader, Th_AddressBodyStart); $ids = preg_split('/[ ,]+/', $books); $books = ''; foreach ($ids as $ii => $id) { $books .= dbSingleValue($session, 'select name from ' . dbTable($session, Tab_Book) . " where id=" . (0 + $id)) . ($ii < count($ids) - 1 ? ',' : ''); $session->trace(TC_Gui1, 'addressEditCard-4: ' . $id . "/" . $books); } if (isset($search_title) || isset($search_body)) { baseSearchResults($session); } if ($message != null) { guiParagraph($session, $message, false); } guiStartForm($session); outHiddenField($session, 'card_id', $card_id); outTable(0); outTableRecordCells('Id:', $card_id); outTableRecord(); outTableTextField($session, 'Adressbücher:', 'card_books', $books, 34, 0); outTableRecordDelim(); outTableTextField2($session, 'Vor-, Nachname:', 'card_firstname', $firstname, 16, 64, ' ', 'card_lastname', $lastname, 16, 64); outTableRecordEnd(); outTableTextField($session, 'Spitzname:', 'card_nickname', $nickname, 16, 64); outTableRecordEnd(); outTableRecordCells('Privat', ' '); outTableRecord(); outTableTextField2($session, 'EMail EMail2:', 'card_emailprivate', $emailprivate, 34, 128, ' ', 'card_emailprivate2', $emailprivate2, 34, 128); outTableRecordDelim(); outTableTextField2($session, 'Telefon Telefon2:', 'card_phoneprivate', $phoneprivate, 34, 128, ' ', 'card_phoneprivate2', $phoneprivate2, 34, 128); outTableRecordDelim(); outTableTextField2($session, 'Mobil Fax:', 'card_mobileprivate', $mobileprivate, 34, 128, ' ', 'card_faxprivate', $faxprivate, 34, 128); outTableRecordDelim(); outTableCell('Land PLZ Ort Straße:'); outTableDelim(); outTextField($session, 'card_country', $country, 3, 64); echo ' '; outTextField($session, 'card_zip', $zip, 5, 12); echo ' '; outTextField($session, 'card_city', $city, 22, 64); echo ' '; outTextField($session, 'card_street', $street, 34, 128); outTableDelimAndRecordEnd(); outTableRecordCells('Geschäftlich:', ' '); outTableRecord(); outTableTextField2($session, 'EMail: EMail2:', 'card_emailoffice', $emailoffice, 34, 128, ' ', 'card_emailoffice2', $emailoffice2, 34, 128); outTableRecordDelim(); outTableTextField2($session, 'Telefon Telefon2:', 'card_phoneoffice', $phoneoffice, 34, 128, ' ', 'card_phoneoffice2', $phoneoffice2, 34, 128); outTableRecordDelim(); outTableTextField2($session, 'Mobil Fax:', 'card_mobileoffice', $mobileoffice, 34, 128, ' ', 'card_faxoffice', $faxoffice, 34, 128); outTableRecordDelim(); outTableTextField($session, 'Funktionen', 'card_functions', $functions, 34, 128); outTableRecordDelim(); outTableTextArea($session, 'Bemerkungen:', 'card_notes', $notes, 31, 4); outTableRecordDelim(); outTableButton2($session, ' ', 'card_change', 'Ändern', ' ', 'card_new', 'Neu'); outTableRecordDelim(); outTableTextField($session, 'Nächster DS (Id):', 'card_next', '', 8, 8); outTableRecordEnd(); outTableEnd(); guiFinishForm($session); guiStandardBodyEnd($session, Th_AddressBodyEnd); }
function baseAccountAnswer(&$session, $user) { $session->trace(TC_Gui1, 'baseAccountAnswer'); $message = ''; $code = encryptPassword($session, $_POST['account_user'], $_POST['account_code']); $locked = dbSqlString($session, !empty($_POST['account_locked'])); if (!empty($_POST['account_startpageoffer'])) { $_POST['account_startpage'] = $_POST['account_startpageoffer']; } if (isset($_POST['account_new'])) { if ($_POST['account_user2'] == '') { $message = '+++ Kein Benutzername angegeben'; } elseif (dbGetValueByClause($session, T_User, 'count(*)', 'name=' + dbSqlString($session, $_POST['account_user'])) > 0) { $message = '+++ Name schon vorhanden: ' + $_POST['account_user2']; } else { $uid = dbUserAdd($session, $_POST['account_user2'], $code, dbSqlString($session, false), $_POST['account_theme'], $_POST['account_width'], $_POST['account_height'], $_POST['account_maxhits'], $_POST['account_startpage'], $_POST['account_email']); modUserStoreData($session, true, $uid); $message = 'Benutzer ' . $_POST['account_user2'] . ' wurde angelegt. ID: ' . $uid; } } elseif (isset($_POST['account_change'])) { if (!empty($_POST['account_code']) && $_POST['account_code'] != $_POST['account_code2']) { $message = '+++ Passwort stimmt mit Wiederholung nicht überein'; } elseif (!($uid = dbUserId($session, $_POST['account_user'])) || empty($uid)) { $message = '+++ unbekannter Benutzer: ' . $_POST['account_name']; } elseif (($message = modUserCheckData($session, true, $uid)) != null) { } else { if (empty($_POST['account_theme'])) { $_POST['account_theme'] = Theme_Standard; } $what = 'locked=' . $locked . ','; if (!empty($_POST['account_code'])) { $what .= 'code=' . dbSqlString($session, $code) . ","; } $what .= 'theme=' . $_POST['account_theme'] . ',width=' . (0 + $_POST['account_width']) . ',height=' . (0 + $_POST['account_height']) . ',maxhits=' . (0 + $_POST['account_maxhits']) . ',startpage=' . dbSqlString($session, $_POST['account_startpage']) . ',email=' . dbSqlString($session, $_POST['account_email']) . ','; dbUpdate($session, T_User, $uid, $what); modUserStoreData($session, false, $uid); $message = 'Daten für ' . $_POST['account_user'] . ' (' . $uid . ') wurden geändert'; } } elseif ($_POST['account_other']) { if (empty($_POST['account_user2'])) { $message = '+++ kein Benutzername angegeben'; } elseif (!dbUserId($session, $_POST['account_user2'])) { $message = '+++ Unbekannter Benutzer: ' . $_POST['account_user2']; } } else { $message = 'keine Änderung'; } baseAccount($session, $message); }
function baseAccountAnswer(&$session, $user) { global $account_user, $account_code, $account_code2, $account_email, $account_rights, $account_locked, $account_new, $account_change, $account_name, $account_other, $account_user2, $account_theme, $account_width, $account_height, $account_maxhits, $account_startpage, $account_startpageoffer; $session->trace(TC_Gui1, 'baseAccountAnswer'); $message = ''; $code = encryptPassword($session, $account_user, $account_code); $locked = dbSqlString($session, !empty($account_locked)); if (!empty($account_startpageoffer)) { $account_startpage = $account_startpageoffer; } if (isset($account_new)) { if ($account_user2 == '') { $message = '+++ Kein Benutzername angegeben'; } elseif (dbGetValueByClause($session, T_User, 'count(*)', 'name=' + dbSqlString($session, $account_user)) > 0) { $message = '+++ Name schon vorhanden: ' + $account_user2; } else { $uid = dbUserAdd($session, $account_user2, $code, $session->fUserRights, dbSqlString($session, false), $account_theme, $account_width, $account_height, $account_maxhits, $account_startpage, $account_email); modUserStoreData($session, true, $uid); $message = "Benutzer {$account_user2} wurde angelegt. ID: " . $uid; } } elseif (isset($account_change)) { if (!empty($account_code) && $account_code != $account_code2) { $message = '+++ Passwort stimmt mit Wiederholung nicht überein'; } elseif (!($uid = dbUserId($session, $account_user)) || empty($uid)) { $message = '+++ unbekannter Benutzer: ' . $account_name; } elseif (($message = modUserCheckData($session, true, $uid)) != null) { } else { if (empty($account_theme)) { $account_theme = Theme_Standard; } $what = 'rights=' . dbSqlString($session, $account_rights) . ',locked=' . $locked . ','; if (!empty($account_code)) { $what .= 'code=' . dbSqlString($session, $code) . ","; } $what .= "theme={$account_theme},width={$account_width}," . 'height=' . (0 + $account_height) . ',maxhits=' . (0 + $account_maxhits) . ',startpage=' . dbSqlString($session, $account_startpage) . ',email=' . dbSqlString($session, $account_email) . ','; dbUpdate($session, T_User, $uid, $what); modUserStoreData($session, false, $uid); $message = 'Daten für ' . $account_user . ' (' . $uid . ') wurden geändert'; } } elseif ($account_other) { if (empty($account_user2)) { $message = '+++ kein Benutzername angegeben'; } elseif (!dbUserId($session, $account_user2)) { $message = '+++ Unbekannter Benutzer: ' . $account_user2; } } else { $message = 'keine Änderung'; } baseAccount($session, $message); }