get( 'moduleclass_sfx' ); if ($option == 'com_content' && $task == 'view' && $id) { // select the meta keywords from the item $query = "SELECT metakey FROM #__content WHERE id='$id'"; $database->setQuery( $query ); if ($metakey = trim( $database->loadResult() )) { // explode the meta keys on a comma $keys = explode( ',', $metakey ); $likes = array(); // assemble any non-blank word(s) foreach ($keys as $key) { $key = trim( $key ); if ($key) { $likes[] = $database->getEscaped( $key ); } } if (count( $likes )) { // select other items based on the metakey field 'like' the keys found $query = "SELECT id, title" . "\nFROM #__content" . "\nWHERE id<>$id AND state=1 AND access <=$my->gid AND (metakey LIKE '%"; $query .= implode( "%' OR metakey LIKE '%", $likes ); $query .= "%')"; $database->setQuery( $query ); if ($related = $database->loadObjectList()) { echo "

\n"; foreach ($related as $item) { if ($option="com_content" && $task="view") { $Itemid = $mainframe->getItemid($item->id); } $href = sefRelToAbs( "index.php?option=com_content&task=view&id=$item->id&Itemid=$Itemid" ); echo "
• $item->title
\n"; } echo "

\n"; } } } } ?>