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