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