';
$database->setQuery($sql);
$rows = $database->loadObjectList();
foreach($rows as $row){
echo ' ' . $row->title . ' | ';
if ($showicons=="1"){
if ($showthemeicons=="1"){
echo ''
.''
.' '
.' | '
.''
.''
.' '
.' | '
.''
.''
.' '
.' | ';
}else{
echo ''
.''
.' '
.' | '
.''
.''
.' '
.' | '
.''
.''
.' '
.' | ';
}
}
echo ' '
.'
'
.' ';
if ($showuser=="1"){
$createdby = $row->created_by;
$query1 = "SELECT username FROM #__users WHERE id='$createdby'";
$database->setQuery( $query1 );
$rows1 = $database->loadObjectList();
$row1 = $rows1[0];
$createdby = $row1->username;
echo ''
.''
.'Written by ' . $createdby . ''
.' | '
.' ';
}
$timestamp = strtotime($row->created);
setlocale(LC_ALL, "pt_BR");
//$createddate = date('l, d F Y', $timestamp);
$createddate = strftime('%d %B %Y',$timestamp);
if ($showcreated=="1"){
echo 'Postado em: ' . $createddate . ' | ';
}
echo ''
.''
.$row->introtext
.' | '
.' '
.' '
.' ';
}
echo ' |