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 basePostingAnswer(&$session)
{
$session->trace(TC_Gui1, 'basePostingAnswer');
$message = null;
$mode = null;
$_POST['posting_text'] = textAreaToWiki($session, $_POST['posting_text']);
if (isset($_POST['posting_preview'])) {
$mode = isset($_POST['posting_id']) && isInt($_POST['posting_id']) ? C_Change : C_New;
} elseif (isset($_POST['posting_insert'])) {
$mode = C_New;
if (empty($_POST['posting_subject'])) {
$message = '+++ Thema fehlt';
} elseif (strlen($_POST['posting_text']) < 5) {
$message = '+++ Beitrag zu kurz';
} else {
$date = dbSqlDateTime($session, time());
$_POST['thread_id'] = $_POST['posting_id'] = dbInsert($session, T_Posting, 'createdat,changedat,forum,author,top,reference,subject,text', "{$date},{$date}," . $_POST['forum_id'] . ',' . dbSqlString($session, $session->fUserName) . ',' . (empty($_POST['thread_id']) ? 'null' : $_POST['thread_id']) . ',' . (empty($_POST['reference_id']) ? 'null' : $_POST['reference_id']) . ',' . dbSqlString($session, $_POST['posting_subject']) . ',' . dbSqlString($session, $_POST['posting_text']));
dbUpdateRaw($session, T_User, $session->fUserId, 'postings=postings+1');
baseForum($session);
$mode = NULL;
}
} elseif (isset($_POST['posting_change'])) {
$mode = C_Change;
if (empty($_POST['posting_subject'])) {
$message = '+++ Thema fehlt';
} elseif (strlen($_POST['posting_text']) < 5) {
$message = '+++ Beitrag zu kurz';
} else {
$date = dbSqlString($session, time());
dbUpdate($session, T_Posting, $_POST['posting_id'], 'changedby=' . dbSqlString($session, $session->fUserName) . ',changedat=' . $date . ',subject=' . dbSqlString($session, $_POST['posting_subject']) . ',text=' . dbSqlString($session, $_POST['posting_text']) . ',');
baseThread($session);
$mode = NULL;
}
}
if ($mode) {
basePosting($session, $message, $mode);
}
}
function basePostingAnswer(&$session)
{
global $forum_id, $thread_id, $posting_id, $posting_subject, $posting_text, $posting_preview, $posting_insert, $posting_change, $textarea_width, $textarea_height;
$session->trace(TC_Gui1, 'basePostingAnswer');
$message = null;
$mode = null;
$posting_text = textAreaToWiki($session, $posting_text);
if (isset($posting_preview)) {
$mode = isset($posting_id) && isInt($posting_id) ? C_Change : C_New;
} elseif (isset($posting_insert)) {
$mode = C_New;
if (empty($posting_subject)) {
$message = '+++ Thema fehlt';
} elseif (strlen($posting_text) < 5) {
$message = '+++ Beitrag zu kurz';
} else {
$date = dbSqlDateTime($session, time());
$thread_id = $posting_id = dbInsert($session, T_Posting, 'createdat,changedat,forum,author,top,reference,subject,text', "{$date},{$date},{$forum_id}," . dbSqlString($session, $session->fUserName) . ',' . (empty($thread_id) ? 'null' : $thread_id) . ',' . (empty($reference_id) ? 'null' : $reference_id) . ',' . dbSqlString($session, $posting_subject) . ',' . dbSqlString($session, $posting_text));
dbUpdateRaw($session, T_User, $session->fUserId, 'postings=postings+1');
baseForum($session);
$mode = NULL;
}
} elseif (isset($posting_change)) {
$mode = C_Change;
if (empty($posting_subject)) {
$message = '+++ Thema fehlt';
} elseif (strlen($posting_text) < 5) {
$message = '+++ Beitrag zu kurz';
} else {
$date = dbSqlString($session, time());
dbUpdate($session, T_Posting, $posting_id, 'changedby=' . dbSqlString($session, $session->fUserName) . ',changedat=' . $date . ',subject=' . dbSqlString($session, $posting_subject) . ',text=' . dbSqlString($session, $posting_text) . ',');
baseThread($session);
$mode = NULL;
}
}
if ($mode) {
basePosting($session, $message, $mode);
}
}
function baseLastChanges(&$session)
{
global $last_days;
$headline = 'Übersicht über die letzten Änderungen';
guiStandardHeader($session, $headline, Th_StandardHeader, Th_StandardBodyStart);
if (!isset($last_days) || $last_days < 1) {
$last_days = 7;
}
guiStartForm($session);
echo '<p>Zeitraum: die letzten ';
guiTextField('last_days', $last_days, 3, 4);
echo ' Tage ';
guiButton('last_refresh', 'Aktualisieren');
echo '</p>' . "\n";
echo '<table border="0">' . "\n";
for ($day = 0; $day <= $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) {
echo '<tr><td><b>';
echo $time_0;
echo '</b></td></tr>' . "\n";
do {
echo '<tr><td>';
echo dbSingleValue($session, 'select min(id) from ' . dbTable($session, T_Text) . ' where page=' . $rec[5]) == $rec[0] ? 'Neu' : 'Änderung';
echo '</td><td>';
echo $rec[0];
echo '</td><td>';
echo guiInternLink($session, $rec[1], $rec[1]);
echo '</td><td>';
guiAuthorLink($session, $rec[2]);
echo '</td><td>';
echo dbSqlDateToText($session, $rec[3]);
$pred_rec = dbSingleValue($session, 'select max(id) from ' . dbTable($session, T_Text) . ' where page=' . $rec[5] . ' and createdat<' . dbSqlDateTime($session, $time_2));
if ($pred_rec > 0) {
echo '</td><td>';
guiInternLink($session, $rec[5] . '?action=' . A_Diff . '&text_id=' . $rec[0] . '&text_id2=' . $pred_rec, 'Unterschied zum Vortag (' . $pred_rec . ')');
}
echo '</td></tr>' . "\n";
} while (($rec = dbNextRecord($session)) != null);
}
/* if (false){
$ids = dbIdList2 ($session, T_Text, 'distinct page', $condition);
if ($ids) {
echo '<tr><td><b>';
echo $time_0;
echo'</b></td></tr>' . "\n";
foreach ($ids as $ii => $pageid) {
$page = dbGetRecordById ($session, T_Page, $pageid, 'name');
$text = dbFirstRecord ($session,
'select id,createdby,createdat,replacedby from '
. dbTable ($session, T_Text) . ' where page=' . (0 + $pageid)
. ' and ' . $condition . ' order by id desc');
$count = 0;
while ($text) {
$pred_text = dbSingleValue ($session, 'select max(id) from '
. dbTable ($session, T_Text) . ' where page=' . $pageid
. ' and createdat<'
. dbSqlDateTime ($session, $time_2));
echo '<tr><td>';
echo dbSingleValue ($session, 'select min(id) from '
. dbTable ($session, T_Text) . ' where page=' . $pageid)
== $text [0] ? 'Neu' : 'Änderung';
echo '</td><td>';
echo $text [0];
echo '</td><td>';
echo $count++ > 0 ? htmlentities ($page [0])
: guiInternLink ($session, $page [0], $page [0]);
echo '</td><td>';
guiAuthorLink ($session, $text [1]);
echo '</td><td>';
echo dbSqlDateToText ($session, $text [2]);
if ($pred_text > 0) {
echo '</td><td>';
guiInternLink ($session, $page [0] . '?action=' . A_Diff
. '&text_id=' . $pred_text . '&text_id2=' . $text [0],
'Unterschied zum Vortag (' . $pred_text . ')');
}
echo '</td></tr>' . "\n";
$text = dbNextRecord ($session);
}
}
}
} */
}
echo '</table>';
guiStandardBodyEnd($session, Th_StandardBodyEnd);
}
