Showing last commented photos/files using jcomments?

[dkdyk]

Hello
I am using phoca gallery component (love it) and for comments I am using jcomments.
In module jcomments it shows the lastest photo categories comments, that working.
But I wonder if it´s simple to use module jcomments so it displays last photo comments.
Not comments for the album just for comments for single photos..
(the window that comes up when clicking on comment image)
Kind regards
David

[dkdyk]

Hi again
I have now get the lastest image comment to show.. but its linking wrong and I want to add the thumb..
the code what is need to be changed is:

com_photogallery_images

and the code is:

Code: Select all

<?php
/**
 * JComments plugin for PhocaGallery
 *
 * @version 2.1
 * @package JComments
 * @author Sergey M. Litvinov (smart@joomlatune.ru)
 * @copyright (C) 2006-2009 by Sergey M. Litvinov (http://www.joomlatune.ru)
 * @license GNU/GPL: http://www.gnu.org/copyleft/gpl.html
 **/
(defined('_VALID_MOS') OR defined('_JEXEC')) or die('Direct Access to this location is not allowed.');

class jc_com_phocagallery_images extends JCommentsPlugin
{
	function getTitles($ids)
	{
		$db = & JCommentsFactory::getDBO();
		$db->setQuery( 'SELECT id, title FROM #__phocagallery WHERE id IN (' . implode(',', $ids) . ')' );
		return $db->loadObjectList('id');
	}

	function getObjectTitle($id)
	{
		$db = & JCommentsFactory::getDBO();
		$db->setQuery( 'SELECT title, id FROM #__phocagallery WHERE id = ' . $id );
		return $db->loadResult();
	}

	function getObjectLink($id)
	{
		$db = & JCommentsFactory::getDBO();

		$link = '';

		$query = 'SELECT a.id, as imgid c.id as catid,'
			.' CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(\':\', c.id, c.alias) ELSE c.id END as catslug,'
			.' CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(\':\', a.id, a.alias) ELSE a.id END as slug'
			.' FROM #__phocagallery AS a'
			.' LEFT JOIN #__phocagallery_categories AS c ON c.id = a.catid'
			.' WHERE a.id = '. $id
			;
		$db->setQuery($query);
		$rows = $db->loadObjectList();
		if (count($rows)) {
			$row = $rows[0];

			$_Itemid = JCommentsPlugin::getItemid('com_phocagallery');
			
			// Comment is displayed in popup window so we must create link to category view
			// Because of possible pagination only this one image will be displayed not all
			
			$link = 'index.php?option=com_phocagallery&view=category&id=' . $row->catslug.'&cimgid=' . $row->slug;
			// Does not make any sense :-(
			//$link = 'index.php?option=com_phocagallery&view=comment&catid=' . $row->catslug . '&id=' . $row->slug;
			$link .= ($_Itemid > 0) ? ('&Itemid=' . $_Itemid) : '';
			$link = JRoute::_($link);
		}

		return $link;
	}
}
?>

Hope any one can help me ??
Kind regards
David

[Jan]

Hi, maybe this is more question on the developer who has made this plugin