Website Comments

By robin - December 12, 2019

Hi Greg,

There is not a built in way to expire comments. (Though I think that's a great idea for future versions).

For now you could accomplish this with a small modification to the plugin.  

In the file websiteComments.php

Edit line 122:

From:

    'where'         => mysql_escapef("tableOrTag=? AND recordNum=?", $tableOrTag, $recordNum),

To:

    'where'         => mysql_escapef("tableOrTag=? AND recordNum=?", $tableOrTag, $recordNum) . " AND createdDate > (NOW() - INTERVAL 90 DAY)",

Please let me know if you run into any trouble.  Thanks,
Robin

Robin
Programmer
interactivetools.com

By gversion - December 13, 2019

Hi Robin,

That's worked perfectly, thank you so much for the help!

Regards,

Greg