CONTENIDO Forum

Code: Alles auswählen

<?php 

$query = "SELECT A.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 = A.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 h:i",$lastmodified); 

echo "Verfasst von : ".$realname."\nLetzte Änderung: ".$lastmodified."\n"; 

?>