$cName = "MyTitle";
$query = "SELECT c.id, c.title, c.fulltext, c.state, c.sectionid,"
."\n c.catid, c.created, c.modified, c.created_by, c.images,"
."\ns.title AS sectiontitle, ct.title AS cattitle, u.name AS author, c.attribs"
. "\n FROM #__content as c "
."\nLEFT JOIN #__sections as s ON s.id=c.sectionid"
."\nLEFT JOIN #__categories AS ct ON ct.id=c.catid"
."\nLEFT JOIN #__users AS u ON u.id=c.created_by"
. "\n WHERE c.title = '".$cName."'";
$database->setQuery($query);
$items= $database->loadObjectList();
foreach($items as $item){
}
global $_MAMBOTS;
//process mambots
//need to include an object called 'row' containing your DB row field data
//$row->text is processed by the mambots
$row->text = $item->fulltext;
$row->attribs = $item->attribs;
$row->images = $item->images;
$row->text = $item->fulltext;
$params = new mosParameters( $row->attribs );
//process images
$params->def( 'image', 1 );
$_MAMBOTS->loadBotGroup( 'content' );
$results = $_MAMBOTS->trigger( 'onPrepareContent', array( &$row, &$params,0), true );
$item->fulltext = $row->text;
$text = $item->fulltext;
echo "<div>".$text."</div>";
