ungetestet:
(hatte nur die joomgallery hier - meines wissens haben sich einige tabellen- und feldnamen geändert - müsstest du dann eben anpassen.)
PHP-Code:
<?php
$content ="";
$database->setQuery(" SELECT comments.cmtpic , comments.cmttext , cat.catpath , gallery.imgthumbname , gallery.imgtitle "
." FROM #__ponygallery_comments AS comments "
." LEFT JOIN #__ponygallery AS gallery "
." ON gallery.id = comments.cmtpic "
." LEFT JOIN #__ponygallery_catg AS cat "
." ON cat.cid = gallery.catid "
." ORDER BY comments.cmtpic DESC "
." LIMIT 9 ")
;
$meslist = $database->loadObjectList();
$enum = 1;
foreach ($meslist as $mes){
$text = substr($mes->cmttext, 0, 23);
$content.=" <img class=\"pic\" src=\"".$mes->catpath."/".$mes->imgthumbname."\" alt=\"".$mes->imgtitle."\" /><a href=\"index.php?option=com_ponygallery&catid=&Itemid=&func=detail&id=".$mes->cmtpic."\">".$text."...</a><br/>";
$enum++;
}
$content.="<br/>";
?>
formatieren kannst es dann über deine CSS
HTML-Code:
img.pic { width: 25px;}
Lesezeichen