function dbForumName(&$session, $id, $with_link)
{
$session->trace(TC_Db3 + TC_Query, "dbForumName: {$id}");
$rc = dbSingleValue($session, 'select name from ' . dbTable($session, T_Forum) . ' where id=' . $id);
if ($with_link) {
$rc = guiInternLinkString($session, P_Forum . '?forum_id=' . $id, $rc);
}
return $rc;
}
function admExportPages(&$session, $message)
{
global $export_pattern, $export_preview, $export_exists;
$session->trace(TC_Gui1, 'admExportPages');
guiStandardHeader($session, 'Seitenexport', Th_StandardHeader, Th_StandardBodyStart);
if (!empty($message)) {
guiParagraph($session, $message, false);
}
if (isset($export_preview) && !empty($export_pattern)) {
guiShowTable($session, '<h2>Ausgesuchte Seiten (' . htmlentities($export_pattern) . "):</h2>\n", array('Id', 'Name'), 'select id,name from ' . dbTable($session, T_Page) . ' where ' . admBuildCondition($session, $export_pattern), true, 'border="1"');
}
if (isset($export_exists)) {
guiParagraph($session, 'Exportdatei: ' . guiInternLinkString($session, $export_exists, null), false);
}
guiStartForm($session, "export", P_ExportPages);
guiHiddenField('export_exists', $export_exists);
echo '<table border="0">';
echo '<tr><td>Namensmuster:</td><td>';
guiTextField('export_pattern', $export_pattern, 64, 0);
echo '</td><td>Joker: %: beliebig viele Zeichen _: ein Zeichen |: neues Teilmuster Bsp: Hilfe%|%Test%';
echo '</td></tr>' . "\n" . '<tr><td>Exportform:</td><td>';
guiComboBox('export_type', array('insert', 'update'), null);
echo '</td><tr>' . "\n" . '<tr><td></td><td>';
guiButton('export_preview', 'Vorschau');
echo ' | ';
guiButton('export_export', 'Exportieren');
echo "</td></tr>\n</table>\n";
guiFinishForm($session);
guiFinishBody($session, null);
}
function forumSearch(&$session, $with_text, $condition, $to_find)
{
global $search_maxhits;
$session->trace(TC_Gui2, 'forumSearch');
$rc = '';
$row = dbFirstRecord($session, 'select id,subject,author,createdat,top,forum' . ($with_text ? ',text from ' : ' from ') . dbTable($session, T_Posting) . ' where ' . $condition . ' order by changedat desc limit ' . $search_maxhits);
if (!$row) {
$rc = '+++ keine passenden Seiten gefunden';
} else {
$rc = '<table border="1"><tr><td><b>Nr</b></td><td><b>Forum</b></td>' . '<td>Titel</b></td><td><b>Autor</b></td><td><b>geschrieben am</b></td>' . '<td><b>Typ</b></td>' . ($with_text ? '<td><b>Fundstelle</b></td>' : '') . '</tr>';
$no = 0;
while ($row) {
$rc .= "\n<tr><td>" . ++$no . '</td><td>' . dbForumName($session, $row[5], true) . '</td><td>' . guiInternLinkString($session, P_Thread . '?action=' . A_ShowThread . '&posting_id=' . $row[0] . '&forum_id=' . $row[5], $row[1]) . '</td><td>' . htmlentities($row[2]) . '</td><td>' . dbSqlDateToText($session, $row[3]) . '</td><td>' . (empty($row[4]) ? 'Thema' : 'Antwort');
if ($with_text) {
$rc .= '</td><td>' . findTextInLine($row[6], $to_find, 3);
}
$rc .= '</td></tr>';
$row = dbNextRecord($session);
}
$rc .= "\n</table>\n";
}
return $rc;
}
function baseCompare(&$session, $pagename, $idnew, $idold)
{
$headline = 'Versionsvergleich';
guiStandardHeader($session, $headline, Th_StandardHeader, Th_StandardBodyStart);
$version_new = dbGetRecordById($session, T_Text, $idnew + 0, 'page,createdat,createdby,text');
$version_old = dbGetRecordById($session, T_Text, $idold + 0, 'page,createdat,createdby,text');
if ($version_new[0] != $version_old[0]) {
guiParagraph($session, 'Texte nicht von einer Seite: ' . (0 + $version_new[0]) . ' / ' . (0 + $version_old[0]), false);
} else {
$page_id = $version_new[0];
$page_link = encodeWikiName($session, $pagename);
guiParagraph($session, guiInternLinkString($session, $page_link, $pagename) . ': Änderungen von Version ' . guiInternLinkString($session, $page_link . '?action=' . A_ShowText . '&page_id=' . $page_id . '&text_id=' . ($idold + 0), $idold) . ' zu Version ' . guiInternLinkString($session, $page_link . '?action=' . A_ShowText . '&page_id=' . $page_id . '&text_id=' . ($idnew + 0), $idnew) . ' von ' . $version_new[2] . ($version_new[2] != $version_old[2] ? ' / ' . $version_old[2] : '') . ' (' . dbSqlDateToText($session, $version_new[1]) . ' / ' . dbSqlDateToText($session, $version_old[1]) . ')', false);
$engine = new DiffEngine($session, $version_old[3], $version_new[3]);
$engine->compare(1, 1);
}
guiStandardBodyEnd($session, Th_StandardBodyEnd);
}
function admExportPages(&$session, $message)
{
$session->trace(TC_Gui1, 'admExportPages');
admStandardHeader($session, 'Seitenexport');
if (!empty($message)) {
guiParagraph($session, $message, false);
}
if (isset($_POST['export_preview']) && !empty($_POST['export_pattern'])) {
guiShowTable($session, '<h2>Passende Seiten (' . htmlentities($_POST['export_pattern']) . "):</h2>\n", array('Id', 'Name'), 'select id,name from ' . dbTable($session, T_Page) . ' where ' . admBuildCondition($session, $_POST['export_pattern']), true, 'border="1"');
}
if (isset($_POST['export_exists'])) {
guiParagraph($session, 'Exportdatei: ' . guiInternLinkString($session, $_POST['export_exists'], null), false);
}
guiStartForm($session);
outDivision($session);
outHiddenField($session, 'export_exists');
outTableAndRecord();
outTableTextField($session, 'Namensmuster', 'export_pattern', null, 64);
outTableCell('Joker: %: beliebig viele Zeichen _: ein Zeichen |: neues Teilmuster' . TAG_NEWLINE . 'Bsp: Hilfe%|%Test%');
outTableRecordDelim();
outTableComboBox($session, 'Exportform:', 'export_type', array('wiki'), null, null);
outTableCell(' ');
outTableRecordDelim();
outTableButton2($session, ' ', 'export_preview', 'Vorschau', ' | ', 'export_export', 'Exportieren');
outTableAndRecordEnd();
outDivisionEnd($session);
guiFinishForm($session);
admFinishBody($session);
}
