Archiv und "geändert von.."-Hinweis

[h75]

Halloo. Ist das möglich, das auch im Archiv der geändert von Hinweis zu sehen ist??? :confused:

[h75]

bitte mal kurz Antworten, oder habe ich was übersehen? Wenn ja, mit Nichtbeachtung erfahre ich das nie! Denn immerhin 16 haben den schon gelesen..

[pogo]

Ja, du müsstest nur das Query in archive/index.php ca. Zeile 297 erweitern, dass auch die Tabelle editlog abgefragt wird.
Wie das geht siehst du z.B. am Query in showthread.php ca. Zeile 847.

[h75]

Nachdem dieser Thread irgendwie abgetaucht ist... :rolleyes:

Ich vermute, es geht dabei um diese Zeilen aus showthread.php

Zeile 855/856
editlog.userid AS edit_userid, editlog.username AS edit_username, editlog.dateline AS edit_dateline,
editlog.reason AS edit_reason, Zeile 868
LEFT JOIN " . TABLE_PREFIX . "editlog AS editlog ON(editlog.postid = post.postid) Nur wie baue ich die jetzt in die /archive/index.php ein? :confused:

Mal so wie ichs grad gedacht habe, einfach nur einfügen? obwohl ich eher denke, das ich im Archiv an der index.php was umbauen muss, oder?
$posts = $DB_site->query("
SELECT post.postid, post.pagetext, IFNULL( user.username , post.username ) AS username, dateline
editlog.userid AS edit_userid, editlog.username AS edit_username, editlog.dateline AS edit_dateline,
editlog.reason AS edit_reason,
FROM " . TABLE_PREFIX . "post AS post
LEFT JOIN " . TABLE_PREFIX . "user AS user ON (user.userid = post.userid)
LEFT JOIN " . TABLE_PREFIX . "editlog AS editlog ON(editlog.postid = post.postid)
LEFT JOIN " . TABLE_PREFIX . "deletionlog AS deletionlog ON (deletionlog.primaryid = post.postid AND deletionlog.type = 'post')
WHERE threadid = $threadinfo[threadid]
AND visible = 1
AND deletionlog.primaryid IS NULL
$globalignore
ORDER BY dateline ASC
LIMIT " . (($p - 1) * $vboptions['archive_postsperpage']) . ", $vboptions[archive_postsperpage]
");

[zap]

Ersetze in der Datei archive/index.php den folgenden Code ab Zeile 297:

$posts = $DB_site->query("
SELECT post.postid, post.pagetext, IFNULL( user.username , post.username ) AS username, dateline
FROM " . TABLE_PREFIX . "post AS post
LEFT JOIN " . TABLE_PREFIX . "user AS user ON (user.userid = post.userid)
LEFT JOIN " . TABLE_PREFIX . "deletionlog AS deletionlog ON (deletionlog.primaryid = post.postid AND deletionlog.type = 'post')
WHERE threadid = $threadinfo[threadid]
AND visible = 1
AND deletionlog.primaryid IS NULL
$globalignore
ORDER BY dateline ASC
LIMIT " . (($p - 1) * $vboptions['archive_postsperpage']) . ", $vboptions[archive_postsperpage]
");
if ($pda AND false)
{
echo "<span id=\"posting\"><a href=\"?message=1\">New Reply</a></span>";
}
$i = 0;
while ($post = $DB_site->fetch_array($posts))
{
$i++;
$post['pagetext'] = strip_bbcode($post['pagetext']);
$post['postdate'] = vbdate($vboptions['dateformat'], $post['dateline']);
$post['posttime'] = vbdate($vboptions['timeformat'], $post['dateline']);
echo "\n<div class=\"post\"><div class=\"posttop\"><div class=\"username\">$post[username]</div><div class=\"date\">$post[postdate], $post[posttime]</div></div>";
echo "<div class=\"posttext\">" . nl2br(htmlspecialchars_uni($post['pagetext'])) . "</div></div><hr />\n\n";
}

mit diesem hier:

$posts = $DB_site->query("
SELECT post.postid, post.pagetext, IFNULL( user.username , post.username ) AS username, post.dateline AS dateline,
editlog.userid AS edit_userid, editlog.username AS edit_username, editlog.dateline AS edit_dateline, editlog.reason AS edit_reason
FROM " . TABLE_PREFIX . "post AS post
LEFT JOIN " . TABLE_PREFIX . "user AS user ON (user.userid = post.userid)
LEFT JOIN " . TABLE_PREFIX . "deletionlog AS deletionlog ON (deletionlog.primaryid = post.postid AND deletionlog.type = 'post')
LEFT JOIN " . TABLE_PREFIX . "editlog AS editlog ON(editlog.postid = post.postid)
WHERE threadid = $threadinfo[threadid]
AND visible = 1
AND deletionlog.primaryid IS NULL
$globalignore
ORDER BY dateline ASC
LIMIT " . (($p - 1) * $vboptions['archive_postsperpage']) . ", $vboptions[archive_postsperpage]
");
if ($pda AND false)
{
echo "<span id=\"posting\"><a href=\"?message=1\">New Reply</a></span>";
}
$i = 0;
while ($post = $DB_site->fetch_array($posts))
{
$i++;
$post['pagetext'] = strip_bbcode($post['pagetext']);
$post['postdate'] = vbdate($vboptions['dateformat'], $post['dateline']);
$post['posttime'] = vbdate($vboptions['timeformat'], $post['dateline']);
if ($post['edit_userid'])
{
$post['edit_date'] = vbdate($vboptions['dateformat'], $post['edit_dateline'], true);
$post['edit_time'] = vbdate($vboptions['timeformat'], $post['edit_dateline']);
$reason = ($post['edit_reason']) ? " Grund: $post[edit_reason]" : '';
$edited = "<br /><br /><div class=\"smallfont\">Geändert von $post[edit_username] ($post[edit_date] um <span class=\"time\">$post[edit_time]</span> Uhr).$reason</div>";
}
else
{
$edited = '';
}
echo "\n<div class=\"post\"><div class=\"posttop\"><div class=\"username\">$post[username]</div><div class=\"date\">$post[postdate], $post[posttime]</div></div>";
echo "<div class=\"posttext\">" . nl2br(htmlspecialchars_uni($post['pagetext'])) . "$edited</div></div><hr />\n\n";
}

Wenn du das Aussehen der Geändert von... Zeile ändern willst, dann musst du noch die Variable $edited anpassen.

Ich hoffe ich konnte helfen.

[h75]

Du hoffst? :) Det is ja unglaublich. Ich probiers nachher direkt aus und poste hier dann dat Ergebniss. Danke. War ja doch noch mehr, wie ich gedacht hatte. Man lernt nie aus!