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);
}
