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

Hi Robin,

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

Regards,

Greg