Make comments visible to comment author only

[gadall]

I've created a legal reference library for a client of mine. My client in turn sells access to relevant sections of the library to their clients. I'm currently using flexicontent/flexiaccess to create/manage the library. However my client wants there to be a column in each law where each client can place their own annotations, with the stipulation that only the client that created the annotation can see it. I was hoping JComment could fulfill this task or be simply modified to accomplish this.

[smart]

So you want to have comments which will be visible only for their author? I do not know how to make this for certain category or object but I can explain how to make this for whole site.

You have to:

1. Open file /components/com_jcomments/model/jcomments.php
2. Find line:

Code: (php)

$where = array();

and add after:

Code: (php)

$where[] = "c.userid = " . $acl->getUserId();

3. Find code:

Code: (php)

$query = "SELECT count(*) "
."\nFROM #__jcomments "
."\nWHERE object_id = ".$object_id
."\nAND object_group = '".$db->getEscaped($object_group)."'"

and replace with

Code: (php)

$query = "SELECT count(*) "
."\nFROM #__jcomments "
."\nWHERE object_id = ".$object_id
."\nAND object_group = '".$db->getEscaped($object_group)."'"
."\nAND c.userid = " . $acl->getUserId();

This modification will restrict comments viewing by only user's own comments.

[PauloOutor]

Hello,

Can you tell how to do this in version 2.3.0?

Thank you

[smart]

Can you tell how to do this in version 2.3.0?

In my mind it would be same just changed path to /components/com_jcomments/models/jcomments.php

[carruba14]

Hi smart, i tried to use your advise for v. 2.3.0
but

1)     $where = array();

is present twice (so what ?)

2)  
       $query = "SELECT count(*) "
       ."\nFROM #__jcomments "
       ."\nWHERE object_id = ".$object_id
       ."\nAND object_group = '".$db->getEscaped($object_group)."'"

is not easy to find (maybe it was modified?)


Thanks