Code: Alles auswählen
//Output
<?php $query = "SELECT B.author AS author,
B.created AS created,
C.realname AS realname
FROM
".$cfg["tab"]["art_lang"]." AS A,
".$cfg["tab"]["content"]." AS B,
".$cfg["tab"]["phplib_auth_user_md5"]." AS C
WHERE
A.idart = '$idart' AND
B.idartlang = A.idartlang AND
C.username = B.author
ORDER BY
B.created DESC";
$db->query($query);
$db->next_record();
$author = $db->f("author"); // loginname
$realname = $db->f("realname"); // realname
$created = strtotime($db->f("created"));
$created = date("d.m.Y",$created);
echo "<br><span class=\"date\">Erstellt am $created von $realname</span><br>";
?>
<?php
$query = "SELECT B.author AS author,
B.lastmodified AS lastmodified,
C.realname AS realname
FROM
".$cfg["tab"]["art_lang"]." AS A,
".$cfg["tab"]["content"]." AS B,
".$cfg["tab"]["phplib_auth_user_md5"]." AS C
WHERE
A.idart = '$idart' AND
B.idartlang = A.idartlang AND
C.username = B.author
ORDER BY
B.lastmodified DESC";
$db->query($query);
$db->next_record();
$author = $db->f("author"); // loginname
$realname = $db->f("realname"); // realname
$lastmodified = strtotime($db->f("lastmodified"));
$lastmodified = date("d.m.Y",$lastmodified);
echo "<span class=\"date\">Letzte Änderung: ".$lastmodified."\nvon ".$realname."\n</span>";
?>