function outTableTextFieldButton(&$session, $prefix, $name, $value, $size, $maxsize, $delim, $button_name, $button_text)
{
if ($prefix != null) {
outTableCell($prefix);
}
outTableDelim();
outTextField($session, $name, $value, $size, $maxsize);
if ($delim != null) {
echo $delim;
}
outButton($session, $button_name, $button_text);
echo TAG_TABLE_DELIM_END;
}
function baseLastChanges(&$session)
{
$headline = 'Übersicht über die letzten Änderungen';
guiStandardHeader($session, $headline, Th_StandardHeader, Th_StandardBodyStart);
if (!isset($_POST['last_days']) || $_POST['last_days'] < 1) {
$_POST['last_days'] = 7;
}
guiStartForm($session);
outParagraph($session);
echo 'Zeitraum: die letzten ';
outTextField($session, 'last_days', $_POST['last_days'], 3, 4);
echo ' Tage ';
outButton($session, 'last_refresh', 'Aktualisieren');
outParagraphEnd($session);
outTable();
for ($day = 0; $day <= $_POST['last_days']; $day++) {
$date = localtime(time() - $day * 86400);
$time_0 = strftime('%Y.%m.%d', time() - $day * 86400);
$time_2 = mktime(0, 0, 0, $date[4] + 1, $date[3], $date[5]);
$time_1 = dbSqlDateTime($session, $time_2);
$condition = 't.createdat>=' . $time_1 . ' and t.createdat<=' . str_replace('00:00:00', '23:59:59', $time_1);
$rec = dbFirstRecord($session, 'select t.id,p.name,t.createdby,t.createdat,t.replacedby,p.id from ' . dbTable($session, T_Text) . ' t, ' . dbTable($session, T_Page) . ' p where p.id=t.page and ' . $condition . ' order by createdat desc');
if ($rec) {
outTableRecord();
outTableCellStrong($time_0);
outTableRecordEnd();
do {
$text_id = $rec[0] + 0;
$page_id = $rec[5] + 0;
$page_name = $rec[1];
$page_link = encodeWikiName($session, $page_name);
outTableRecord();
outTableCell(dbSingleValue($session, 'select min(id) from ' . dbTable($session, T_Text) . ' where page=' . $page_id) == $text_id ? 'Neu' : 'Änderung');
outTableInternLink($session, null, $page_link . '?action=' . A_ShowText . '&page_id=' . $page_id . '&text_id=' . $text_id, $text_id);
outTableInternLink($session, null, $page_link, $page_name);
outTableAuthorLink($session, $rec[2]);
outTableCell(dbSqlDateToText($session, $rec[3]));
$pred_rec = dbSingleValue($session, 'select max(id) from ' . dbTable($session, T_Text) . ' where page=' . $page_id . ' and createdat<' . dbSqlDateTime($session, $time_2));
if ($pred_rec > 0) {
outTableInternLink($session, null, $page_link . '?action=' . A_Diff . '&text_id=' . $text_id . '&text_id2=' . $pred_rec, 'Unterschied zum Vortag (' . $pred_rec . ')');
}
outTableRecordEnd();
} while (($rec = dbNextRecord($session)) != null);
}
}
outTableEnd();
guiStandardBodyEnd($session, Th_StandardBodyEnd);
}
function addressShowCards(&$session, $message = null)
{
$session->trace(TC_Gui1, 'addressShowBook:');
guiStandardHeader($session, 'Anzeigen von Adressen', Th_AddressHeader, Th_AddressBodyStart);
if ($message != null) {
guiParagraph($session, $message, false);
}
guiStartForm($session);
guiHeadline($session, 2, 'Suchkriterien:');
$books = dbColumnList($session, Tab_Book, 'name', '1');
if (!isset($_POST['show_book'])) {
$_POST['show_book'] = $books[0];
}
echo 'Adressbuch: ';
guiComboBox('show_book', $books, null, null);
$fields = array('Name', 'Vorname', 'Spitzname', 'EMail', 'PLZ', 'Ort', 'Funktion', 'Notiz');
echo ' Auswahlkriterium: ';
guiComboBox('show_choice', $fields, null, null);
echo ' Suchmuster: ';
outTextField($session, 'show_pattern', null, 16);
echo ' ';
outButton($session, 'show_search', 'Suchen');
guiHeadline($session, 2, 'Ausgabefelder:');
outCheckBox($session, 'show_withname', 'Name');
echo ' ';
outCheckBox($session, 'show_withprivate', 'Privat');
echo ' ';
outCheckBox($session, 'show_withoffice', 'Geschäftlich');
echo ' ';
outCheckBox($session, 'show_withphone', 'Telefon');
echo ' ';
outCheckBox($session, 'show_withemail', 'EMail');
echo ' ';
outCheckBox($session, 'show_withaddress', 'Postadresse');
echo ' ';
outCheckBox($session, 'show_withfunction', 'Funktion');
echo ' ';
outCheckBox($session, 'show_withnote', 'Notiz');
echo ' ';
outCheckBox($session, 'show_withdate', 'Datum');
guiFinishForm($session, $session);
if (isset($_POST['show_pattern'])) {
$pattern = $_POST['show_pattern'];
if (empty($pattern)) {
$condidtion = '1';
} else {
$pattern = '%' . $pattern . '%';
switch ($_POST['show_choice']) {
case 'Name':
$condition = 'lastname like ' . dbSqlString($session, $pattern);
break;
case 'Vorname':
$condition = 'firstname like ' . dbSqlString($session, $pattern);
break;
case 'Spitzname':
$condition = 'nickname like ' . dbSqlString($session, $pattern);
break;
case 'EMail':
$condition = 'emailprivate like ' . dbSqlString($session, $pattern) . ' or emailprivate2 like ' . dbSqlString($session, $pattern) . ' or emailoffice like ' . dbSqlString($session, $pattern) . ' or emailoffice2 like ' . dbSqlString($session, $pattern);
break;
case 'PLZ':
$condition = 'zip like ' . dbSqlString($session, $pattern);
break;
case 'Ort':
$condition = 'city like ' . dbSqlString($session, $pattern);
break;
case 'Funktion':
$condition = 'function like ' . dbSqlString($session, $pattern);
break;
case 'Notiz':
$condition = 'note like ' . dbSqlString($session, $pattern);
break;
default:
$condition = '1';
break;
}
$what = 'lastname,firstname,country,zip,city,street,' . 'emailprivate,emailprivate2,phoneprivate,phoneprivate2,mobileprivate,faxprivate,' . 'emailoffice,emailoffice2,phoneoffice,phoneoffice2,mobileoffice,faxoffice,' . 'functions,notes,nickname,id,changedat,createdat';
addressPrintTable($session, "select {$what} from " . dbTable($session, Tab_Card) . " where {$condition}", 30);
}
}
guiStandardBodyEnd($session, Th_AddressBodyEnd);
}
function basePosting(&$session, $message, $mode)
{
$session->trace(TC_Gui1, 'basePosting: ' . $mode);
$headline = $mode == C_New ? empty($_POST['reference_id']) ? 'Neues Thema' : 'Antworten' : (empty($_POST['reference_id']) ? 'Thema ändern' : 'Antwort ändern');
guiStandardHeader($session, $headline, Th_AnswerHeader, Th_AnswerBodyStart);
if (!empty($_POST['reference_id']) && ($posting = dbGetRecordById($session, T_Posting, $_POST['reference_id'], 'author,subject,text,forum'))) {
guiHeadline($session, 1, 'Beitrag: ' . $posting[1]);
guiParagraph($session, 'Autor: ' . $posting[0], true);
wikiToHTML($session, $posting[2]);
guiLine($session, 2);
if ($mode == C_New) {
$pos = strpos($posting[1], 'Re: ');
$_POST['posting_subject'] = (is_int($pos) ? '' : 'Re: ') . $posting[1];
}
$_POST['forum_id'] = $posting[3];
} else {
if (isset($_POST['posting_text'])) {
$_POST['posting_text'] = str_replace($_POST['posting_text'], "\\'", "'");
} else {
$_POST['posting_text'] = '';
}
}
if (isset($_POST['posting_preview'])) {
guiHeadline($session, 1, 'Vorschau');
wikiToHtml($session, $_POST['posting_text']);
guiLine($session, 2);
}
guiHeadline($session, 1, $headline);
if (!empty($message)) {
guiParagraph($session, $message, true);
}
if ($mode == C_Change && !isset($_POST['posting_text'])) {
$posting = dbGetRecordById($session, T_Posting, $_POST['posting_id'], 'subject,text,forum');
$_POST['forum_id'] = $posting[2];
$_POST['posting_text'] = $posting[1];
$_POST['posting_subject'] = $posting[0];
}
getUserParam($session, U_TextAreaWidth, $textarea_width);
getUserParam($session, U_TextAreaHeight, $textarea_height);
guiStartForm($session);
outHiddenField($session, 'std_answer', 'j');
outHiddenField($session, 'last_pagename', null);
outHiddenField($session, 'forum_id', null);
outHiddenField($session, 'thread_id', null);
outHiddenField($session, 'posting_id', null);
outHiddenField($session, 'reference_id', null);
echo "<table border=\"0\">\n<tr><td>Thema:</td><td>";
outTextField($session, 'posting_subject', null, $textarea_width, 64);
echo "</td></tr>\n<tr><td>Text</td><td>";
outButton($session, 'posting_text', null, $textarea_width, $textarea_height);
echo '</td></tr><tr><td></td><td style="text-align: right;">Eingabefeld: Breite: ';
outTextField($session, U_TextAreaWidth, $textarea_width, 3, 3);
echo " Höhe: ";
outTextField($session, U_TextAreaHeight, $textarea_height, 3, 3);
echo "</td></tr>\n<tr><td></td><td>";
outButton($session, 'posting_preview', 'Vorschau');
echo ' | ';
if ($mode == C_New) {
outButton($session, 'posting_insert', 'Eintragen');
} else {
outButton($session, 'posting_change', 'Ändern');
}
echo "</td></tr>\n</table>\n";
guiFinishForm($session, $session);
guiStandardBodyEnd($session, Th_AnswerBodyEnd);
}
function admBackup(&$session, $with_header, $message)
{
$session->trace(TC_Gui1, 'admBackup');
if ($with_header) {
admStandardHeader($session, 'Datenbank-Backup');
}
if (!empty($message)) {
guiParagraph($session, $message, false);
}
if (empty($_POST['backup_file'])) {
$_POST['backup_file'] = $session->fDbTablePrefix . strftime("_%Y_%m_%d") . '.sql';
}
guiHeadLine($session, 1, 'Backup');
guiStartForm($session);
outTableAndRecord();
outTableTextField($session, 'Dateiname:', 'backup_file', null, 64, 64);
outTableRecordDelim();
outTableCell('Tabelle:');
outTableDelim();
outTextField($session, 'backup_table', null, 64, 64);
echo ' (leer: alle Tabellen)';
outTableDelimEnd();
outTableRecordDelim();
outTableCheckBox($session, ' ', 'backup_compressed', 'komprimiert', null);
outTableRecordDelim();
outTableButton($session, ' ', 'backup_save', 'Sichern');
outTableAndRecordEnd();
guiFinishForm($session);
admFinishBody($session);
}
