[solved] Author Notification About Comments on his/her article

[hayatt]

Hello.

I've just migrated from JomComment to Jcomment, it went very well.  

But I do miss an important feature, which is the author notification.

I need that the author of the article gets an email whenever someone posts a comment on his article.
This is really crucial to me.
Is there such a feature or plugin maybe?

Thanks.

[smart]

I've posted plugin JComments - Autosubscribe... Search through forum and you'll find it...

[hayatt]

Thank you.
Is there a chance that you will release one that is compatible with joomla 2.5?
The one I have does not.

Thanks.

[smart]

Yes, new version will be released soon.

[hayatt]

Great We are waiting.
Thanks a lot!

[smart]

I've released new version of JComments - AutoSubscribe plugin.

Download JComments AutoSubscribe.

Note: this version is compatible with JComments 2.3.0 and higher.

[hayatt]

How wonderful! Thanks : )

[smart]

Note, that this plugin will subscribe author of the commented article when first comment will be added. If some article already has comments - it will not subscribe. This restriction is needed to allow author to unsubscribe - because in other case any new comment will subscribe it again.

[yaksushi]

smart will this work for K2?

[smart]

Yes, it will work with K2 also. But for K2 extension we have plugin K2  - JComments which allows to create subscription after creating new item in K2 component (it uses K2's event onAfterK2Save).

[hayatt]

Note, that this plugin will subscribe author of the commented article when first comment will be added. If some article already has comments - it will not subscribe. This restriction is needed to allow author to unsubscribe - because in other case any new comment will subscribe it again.

Oh, I was hoping that this version will allow subscriptions even for old comments.
Is there a way, perhaps via phpmyadin, a query that I can run, and which will subscribe authors to the articles that they are not subscribed with?

Thanks Smart.

[smart]

Is there a way, perhaps via phpmyadin, a query that I can run, and which will subscribe authors to the articles that they are not subscribed with?

Try next query:

Code: (sql)

INSERT INTO jos_jcomments_subscriptions (
`object_id`
, `object_group`
, `lang`
, `userid`
, `name`
, `email`
, `hash`
, `published`)

SELECT DISTINCT `object_id`
, `object_group`
, `lang`
, `userid`
, `name`
, `email`
, md5(concat(`object_id`,`object_group`,`userid`,`email`,`lang`))
, 1
FROM `jos_jcomments` AS c
WHERE `published` = 1
AND NOT EXISTS
(
SELECT * FROM `jos_jcomments_subscriptions` AS s
WHERE s.`object_id` = c.`object_id`
AND s.`object_group` = c.`object_group`
AND s.`lang` = c.`lang`
AND s.`userid` = c.`userid`
AND s.`email` = c.`email`
)

[hayatt]

Hello,
Sorry for my late reply.
I've just tried it and it worked.
THANKS