JEvents Integration?

[smart]

I'm working hard on new JComments version with Joomla 1.6 compatibilty...

[busby]

Cheers! 

[webridder]

Hi smart,

any news on the progress of the update?
I have been following this thread for several months now, and am also very much interested in a working integration between these two fantastic components.

Any update is welcome.
Thanks in advance!

[busby]

Yes, add me to that - same here

[mandofever]

Add me to that list too! I would love to see proper integration between jevents and jcomments

[mahen]

Hi guys, i already solved this problem ...


you must create file (com_jevents.plugin.php) in com_jcomments/plugins


here the code :

Code:

<?php
class jc_com_jevents extends JCommentsPlugin

{

        function getObjectTitle($id)

        {

                $db = & JCommentsFactory::getDBO();

                $db->setQuery( 'SELECT summary FROM #__jevents_vevdetail WHERE evdet_id = ' . $id );
  $title = $db->loadResult();
                return stripslashes($title);

        }



        function getObjectLink($id)

        {

$db = & JCommentsFactory::getDBO();

$db->setQuery( 'SELECT dtstart, summary FROM #__jevents_vevdetail WHERE evdet_id = ' . $id );

$row = $db->loadObject();

$title = $row->summary;

$title = strip_tags($title);

$title = str_replace("\"","",$title);

$title = str_replace("'","",$title);

$title = str_replace(" ","-",$title);

$dtstart = $row->dtstart;

list ($startHour,$startMin,$startSecond,$startDay,$startMonth,$startYear,$startWD) = explode(":",strftime("0%H:0%M:0%S:%d:%m:%Y:%w",$dtstart));


$db->setQuery( 'SELECT uid FROM #__jevents_vevent WHERE ev_id  = ' . $id );

$uid = $db->loadResult();

$link = 'index.php?option=com_jevents&amp;task=icalrepeat.detail&amp;evid='.$id;

$_Itemid = JCommentsPlugin::getItemid('com_jevents');

$link .= ($_Itemid > 0) ? ('&Itemid=' . $_Itemid) : '';

$link .= '&amp;year='.$startYear;

$link .= '&amp;month='.$startMonth;

$link .= '&amp;day='.$startDay;

$link .= '&amp;title='.$title;

$link .= '&amp;uid='.$uid;

$link = JRoute::_( $link );

                return $link;

        }



}

?>

But I still have problem with SEO URL ...

If there is something wrong or less, please tell me ....

Thanks

[busby]

I am having endless problems with JComments/JEvents integration. Is it possible to stop JComments from appearing in JEvents - that would solve it for me..

At the moment I have comments appearing in the wrong events, duplicates, its just a mess - I would be happy just using it for articles

[erkki]

First of all thanks for the new component. I'm using Joomla 2.5 and newest components of JEvents and JComments.

The JComments module "JComments Latest" works great with Joomla content articles, but few problems remain with JEvents integration. The big problem is with ids - repetition id and event id. If you have repeated event in your calendar, it all gets messed up because now plugin uses just the event id and that's not correct anymore, because that repeated event has more than one occurrences. It should use the repetition id (rp_id) so that every event could have its own comments. I tried to find where it fetches that id but couldn't found it so I created a temporary solution:

In a folder components/com_jcomments/plugins is a file com_jevents.plugin.php and in it a function getObjectInfo. The original query ends with

Code:

WHERE rp_id = ' . $id

but because the id is actually event id I changed this to

Code:

WHERE ev.ev_id = ' . $id

. Then the info link must include the repetition id (rp_id) so I changed

Code:

$id

to

Code:

$row->rp_id

in the end of row 24.

After these two changes non-repeated events works fine but repeated events shows the comments in all of them no matter in which occurrence it was made and the read more link in the module always points to the first occurrence of the event. I hope someone comes up with a better fix.