Joomla Extensions Club 20,483 posts

[guysmiley Friend guysmileyJoin date: October 2006Posts: 50Downloads:0Uploads:6 Thanked: 5 times in 1 posts]

#149903

Greetings,

The JComments’ Latest Comments module does not work correctly with JAVoice because a plugin is required.

According to JComments’ documentation, in order for the Latest Comments to show up in the ‘Latest Comments’ module, a JComments plugin needs to be created for JA Voice. I’ve done most of the work, but I can’t seem to get JComments to load JAVoice’s $type_id in the URL (near bottom of code):

[PHP]
<?php
/**
* JComments plugin for JCalPRO events support
*
* @version 2.0
* @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_javoice extends JCommentsPlugin
{
function getObjectTitle($id)
{
$db = & JCommentsFactory::getDBO();
$db->setQuery( ‘SELECT title AND voice_types_id FROM #__jav_items WHERE id = ‘ . $id );
return $db->loadResult();
}

function getObjectLink($id)
{
$_Itemid = JCommentsPlugin::getItemid( ‘com_javoice’ );
$link = JoomlaTuneRoute::_(‘index.php?option=com_javoice&view=items&layout=item&cid=’ . $id . ‘&type=’ . $type_id . ‘&Itemid=’ . $_Itemid);
return $link;
}
}
?>[/PHP]

This plugin file must be placed in the com_jcomments/plugin folder manually.

[Anonymous Moderator JA DeveloperJoin date: September 2014Posts: 9914Downloads:207Uploads:152 Thanks: 1789 Thanked: 2008 times in 1700 posts]

#338217

Hi guy,

setQuery( ‘SELECT title AND voice_types_id FROM #__jav_items WHERE id = ‘ . $id );

=> This is wrong

It must be:

setQuery( ‘SELECT title, voice_types_id FROM #__jav_items WHERE id = ‘ . $id );

[guysmiley Friend guysmileyJoin date: October 2006Posts: 50Downloads:0Uploads:6 Thanked: 5 times in 1 posts]

#338251

With your updated code, the following URL is produced:
index.php?option=com_javoice&view=items&layout=item&cid=190&type=&Itemid=33#comment-197

Notice how $type_id does not appear in the URL.

[Anonymous Moderator JA DeveloperJoin date: September 2014Posts: 9914Downloads:207Uploads:152 Thanks: 1789 Thanked: 2008 times in 1700 posts]

#338563

<em>@guysmiley 171981 wrote:</em><blockquote>With your updated code, the following URL is produced:
index.php?option=com_javoice&view=items&layout=item&cid=190&type=&Itemid=33#comment-197

Notice how $type_id does not appear in the URL.</blockquote>

Hi Guysmiley,

‘&type=’ . $type_id in the “getObjectLink” function, the ‘$type_id’ variable in this function has not been defined.

Please check again. If you still face the problem, kindly give me FTP & admin account and describe the issue in more details for a closer look.

[guysmiley Friend guysmileyJoin date: October 2006Posts: 50Downloads:0Uploads:6 Thanked: 5 times in 1 posts]

#338746

Thank you. Changes look great and work well. Joomlart’s updated code is below and I’ve attached the file that needs to go in components/com_jcomment/plugins/

[PHP]<?php
/**
* JComments plugin for JCalPRO events support
*
* @version 1.0
* @package JComments
* @author Joomlart
* @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_javoice extends JCommentsPlugin
{
function getObjectTitle($id)
{
$db = & JCommentsFactory::getDBO();
$db->setQuery( ‘SELECT title, voice_types_id FROM #__jav_items WHERE id = ‘ . $id );
return $db->loadResult();
}

function getObjectLink($id)
{
$_Itemid = JCommentsPlugin::getItemid( ‘com_javoice’ );

//get type_id
$db = & JCommentsFactory::getDBO();
$db->setQuery( ‘SELECT voice_types_id FROM #__jav_items WHERE id = ‘ . $id );
$type_id = $db->loadResult();

$link = JoomlaTuneRoute::_(‘index.php?option=com_javoice&view=items&layout=item&cid=’ . $id . ‘&type=’ . $type_id . ‘&Itemid=’ . $_Itemid);
return $link;
}
}
?>[/PHP]

---

Attachments:

1. com_javoice.plugin.zip

[Author]

Posts