function admRename(&$session, $message)
{
global $rename_oldname, $rename_newname, $rename_backlinks;
$session->trace(TC_Gui1, 'admRename');
guiHeader($session, 'Umbenennen einer Seite');
guiHeadline($session, 1, 'Umbenennen einer Seite');
if (!empty($message)) {
guiParagraph($session, $message, false);
}
guiStartForm($session, 'Form', P_Rename);
echo '<table border="0">';
echo '<tr><td>Bisheriger Name:</td><td>';
guiTextField('rename_oldname', $rename_oldname, 64, 64);
echo '<tr><td>Neuer Name:</td><td>';
guiTextField('rename_newname', $rename_newname, 64, 64);
echo '</td></tr>' . "\n";
echo '<tr><td></td><td>';
guiButton('rename_info', 'Info');
if (!empty($rename_oldname) && !empty($rename_newname)) {
echo ' | ';
}
guiButton('rename_rename', 'Umbenennen');
echo '<br>';
guiCheckBox('rename_backlinks', 'Alle Verweise umbenennen', !isset($rename_backlinks) || $rename_backlinks == C_CHECKBOX_TRUE);
echo '</td></tr></table>' . "\n";
guiFinishForm($session);
if (!empty($rename_oldname) && dbPageId($session, $rename_oldname) > 0) {
$row = dbFirstRecord($session, 'select page,text,createdby,createdat from ' . dbTable($session, T_Text) . ' where replacedby is null and text like ' . dbSqlString($session, "%{$rename_oldname}%"));
if (!$row) {
guiParagraph($session, '+++ keine Verweise gefunden', false);
} else {
echo '<table border="1"><tr><td>Seite:</td><td>Typ:</td>' . '<td>von</td><td>Letzte Änderung</td><td>Fundstelle</td></tr>';
while ($row) {
$pagerecord = dbGetRecordById($session, T_Page, $row[0], 'name,type');
$text = findTextInLine($row[1], $rename_oldname, 10, true);
if (!empty($text)) {
echo "\n<tr><td>";
guiInternLink($session, encodeWikiName($session, $pagerecord[0]), $pagerecord[0], M_Base);
echo '</td><td>';
echo $pagerecord[1];
echo '</td><td>';
echo $row[2];
echo '</td><td>';
echo htmlentities($row[3]);
echo '</td><td>';
echo $text;
echo "</td><tr>\n";
}
$row = dbNextRecord($session);
}
echo "\n</table>\n";
}
}
guiFinishBody($session, null);
}
function baseSearchResults(&$session)
{
$session->trace(TC_Gui1, 'baseSearchAnswer');
if (isset($_POST['search_title'])) {
if (empty($_POST['search_titletext'])) {
guiParagraph($session, $session, '+++ kein Seitentitel angegeben', false);
}
$row = dbFirstRecord($session, 'select name,type from ' . dbTable($session, T_Page) . ' where name like ' . dbSqlString($session, '%' . $_POST['search_titletext'] . '%') . ' limit ' . $_POST['search_maxhits']);
if (!$row) {
guiParagraph($session, '+++ keine passenden Seiten gefunden', false);
} else {
outTable(1);
outTableRecord();
outTableCellStrong('Seite:');
outTableCellStrong('Typ:');
outTableRecordEnd();
while ($row) {
outTableRecord();
outTableInternLink($session, null, encodeWikiName($session, $row[0]), $row[0]);
outTableCell(textTypeToMime($row[1]));
outTableRecordEnd();
$row = dbNextRecord($session);
}
outTableEnd();
}
} else {
if (empty($_POST['search_bodytext'])) {
guiParagraph($session, '+++ kein Suchtext angegeben');
} else {
$row = dbFirstRecord($session, 'select page,text,createdby,createdat from ' . dbTable($session, T_Text) . ' where replacedby is null and text like ' . dbSqlString($session, '%' . $_POST['search_bodytext'] . '%') . ' limit ' . $_POST['search_maxhits']);
if (!$row) {
guiParagraph($session, '+++ keine passende Seiten gefunden', false);
} else {
outTableAndRecord($session, 1);
outTableCellStrong('Seite:');
outTableCellStrong('Typ:');
outTableCellStrong('von:');
outTableCellStrong('Letzte Änderung:');
outTableCellStrong('Fundstelle:');
outTableRecordEnd();
while ($row) {
$pagerecord = dbGetRecordById($session, T_Page, $row[0], 'name,type');
outTableRecord();
outTableInternLink($session, null, encodeWikiName($session, $pagerecord[0]), $pagerecord[0]);
outTableCell($pagerecord[1]);
outTableCell($row[2]);
outTableCell(htmlentities($row[3]));
outTableCell(findTextInLine($row[1], $_POST['search_bodytext'], 3));
outTableRecordEnd();
$row = dbNextRecord($session);
}
outTableEnd();
}
}
}
}
function admRename(&$session, $message)
{
$session->trace(TC_Gui1, 'admRename');
admStandardHeader($session, 'Umbenennen einer Seite');
if (!empty($message)) {
guiParagraph($session, $message, false);
}
guiStartForm($session);
outTableAndRecord();
outTableTextField($session, 'Bisheriger Name:', 'rename_oldname', null, 64, 64);
outTableRecordDelim();
outTableTextField($session, 'Neuer Name:', 'rename_newname', null, 64, 64);
outTableRecordDelim();
outTableCell(' ');
outTableDelim();
outButton($session, 'rename_info', 'Info');
if (!empty($_POST['rename_oldname']) && !empty($_POST['rename_newname'])) {
echo ' | ';
outButton($session, 'rename_rename', 'Umbenennen');
outNewline();
outCheckBox($session, 'rename_backlinks', 'Alle Verweise umbenennen', null);
}
outTableDelimAndRecordEnd();
outTableEnd();
guiFinishForm($session);
if (!empty($_POST['rename_oldname']) && dbPageId($session, $_POST['rename_oldname']) > 0) {
$row = dbFirstRecord($session, 'select page,text,createdby,createdat from ' . dbTable($session, T_Text) . ' where replacedby is null and text like ' . dbSqlString($session, '%' . $_POST['rename_oldname'] . '%'));
if (!$row) {
guiParagraph($session, '+++ keine Verweise gefunden', false);
} else {
outTableAndRecord(1);
outTableCellStrong('Seite');
outTableCellStrong('Typ');
outTableCellStrong('von');
outTableCellStrong('Letzte Änderung');
outTableCellStrong('Fundstelle');
outTableCellStrong('Seite');
outTableRecordEnd();
while ($row) {
$pagerecord = dbGetRecordById($session, T_Page, $row[0], 'name,type');
$text = findTextInLine($row[1], $_POST['rename_oldname'], 10, true);
if (!empty($text)) {
outTableRecord();
outTableInternLink($session, null, encodeWikiName($session, $pagerecord[0]), $pagerecord[0], M_Base);
outTableCell($pagerecord[1]);
outTableCell($row[2]);
outTableCell(htmlentities($row[3]));
outTableCell($text);
outTableRecordEnd();
}
$row = dbNextRecord($session);
}
outTableEnd();
}
}
admFinishBody($session);
}
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 baseSearchResults(&$session)
{
global $search_titletext, $search_title, $search_maxhits, $search_bodytext, $search_body;
$session->trace(TC_Gui1, 'baseSearchAnswer');
if (isset($search_title)) {
if (empty($search_titletext)) {
guiParagraph($session, $session, '+++ kein Seitentitel angegeben', false);
}
$row = dbFirstRecord($session, 'select name,type from ' . dbTable($session, T_Page) . ' where name like ' . dbSqlString($session, "%{$search_titletext}%") . " limit {$search_maxhits}");
if (!$row) {
guiParagraph($session, '+++ keine passenden Seiten gefunden', false);
} else {
echo '<table border="1"><tr><td>Seite:</td><td>Typ:</td></tr>';
while ($row) {
echo "\n<tr><td>" . guiInternLinkString($session, $row[0], $row[0]) . "</td><td>{$row['1']}</td></tr>";
$row = dbNextRecord($session);
}
echo "\n</table>\n";
}
} else {
if (empty($search_bodytext)) {
guiParagraph($session, '+++ kein Suchtext angegeben');
} else {
$row = dbFirstRecord($session, 'select page,text,createdby,createdat from ' . dbTable($session, T_Text) . ' where replacedby is null and text like ' . dbSqlString($session, "%{$search_bodytext}%") . " limit {$search_maxhits}");
if (!$row) {
guiParagraph($session, '+++ keine passende Seiten gefunden', false);
} else {
echo '<table border="1"><tr><td>Seite:</td><td>Typ:</td>' . '<td>von</td><td>Letzte Änderung</td><td>Fundstelle</td></tr>';
while ($row) {
$pagerecord = dbGetRecordById($session, T_Page, $row[0], 'name,type');
echo "\n<tr><td>" . guiInternLinkString($session, $pagerecord[0], $pagerecord[0]) . '</td><td>' . $pagerecord[1] . '</td><td>' . $row[2] . '</td><td>' . htmlentities($row[3]) . '</td><td>' . findTextInLine($row[1], $search_bodytext, 3) . '</td><tr>' . "\n";
$row = dbNextRecord($session);
}
echo "\n</table>\n";
}
}
}
}