Support/Comments for Jot

[Guest]

Welcome, Guest. Please login or register.
Did you miss your activation email?

1 Hour 1 Day 1 Week 1 Month Forever
Login with username, password and session length

[bS]

Give your site users the opportunity to enter feedback on your articles. Add comments to articles, create guestbooks, you can even use multiple instances on the same page. Jot is the reincarnation of the former Replix snippet.

* Latest Version: http://modxcms.com/Jot-998.html
* Jot Demo Site: http://projects.zerobarrier.nl/modx/
* Documentation: http://wiki.modxcms.com/index.php/Jot (wiki)

To Do: ( = 1.0 Final)

Snippet:

* detect identical submits.
* change to other custom field method.
* Edit comment.
* Sorting.
* Custom field validation
* Stylesheet options (don't include, auto-include, define custom stylesheet)
* Threaded comments (nested, reply to reply)
* Report to moderator.
* mode: Private Messaging.
* mode: Forum.
* Preview.
* User Postcount.

Module:
* Central moderation.
* Documentation.

Feature Requests:

* TrackBack

[dazze]

I want to use this snippet for a guestbook. But I miss a feature:
On some sites we have problems with spam guestbook entries. So I need an option to hide new entries by default. A webuser (or group) should be able to activate or delete this entries.

I missed this in usercomments and replix too. I hope that I don't have to write my own guestbook snippet.

Is it possible to add this feature in jot??

[Mitch]

That would be a nice feature. In my own custom guestbook (not ready enough for release) I have an option similar to that. In my case the new message is checked agains a "badwords" filter (a chunk with bad words in my case). If any of the bad words is found in the message then the message is hidden automatically and can be unhidden by an admin. By tweaking the badwords chunk it was quite easy for me to  catch all spam posts I get (about 2-3 a day) and all legit posts go through undisturbed.

[bS]

So I need an option to hide new entries by default. A webuser (or group) should be able to activate or delete this entries.

Good thing you mention this..  Jot is already prepared for this feature and I will add this in the next version.

@Mitch: nice idea.. I will add this to my list!

[JeremyL]

So does this version have

&makefolder 0 | 1 (optional)
   set to 1 to automatically convert the parent document to a folder.
   default: 0

Also is it database enabled yet?

These where really the only 2 options or replix that where must have for me because I don't want comments stored under the main content forcing the main centent to be a folder.

[rthrash]

Jot stores it all in the database, so makefolder is not needed.

[PaulGregory]

Mitch, could you share your badwords list?

I think "http" should be considered a badword - the majority of spam I get contains this.

Another approach would be a "trusted" field for users - so approved members could reply instantly.

[JeremyL]

Jot stores it all in the database, so makefolder is not needed.

Perfect. Thanks.

[bS]

Jot 1.0 Beta 3 is now available from the repository. 

Keep that feedback coming while it's hot. 

[JeremyL]

is there a way to add this to all blog posts without actually having to put the snippet in each post? I want my authors to only worry about content. not snippets needing to be added.

[bS]

is there a way to add this to all blog posts without actually having to put the snippet in each post? I want my authors to only worry about content. not snippets needing to be added.

put the call in the blog template, and use that template for each blog post

[Mitch]

Mitch, could you share your badwords list?

Of course, here it is.

Code:

viagra,adobe,href=,[URL,buy

It seems that only 1 or 2 bots were spamming my guestbook with the same method over and over again, so the list is pretty short. Do note that my site only has Dutch speaking visitors, so it was no problem for me to put "buy" on the bad words list.

[dazze]

There seems to be a problem when installing on MySQL 4.0 server.
Got this message:
« Execution of a query to the database failed - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'collate latin1_general_ci NOT NULL, `userid` mediumint(10) NO »
      SQL: CREATE TABLE `modx_jot_subscriptions` ( `id` mediumint(10) NOT NULL auto_increment, `uparent` mediumint(10) NOT NULL, `tagid` varchar(50) collate latin1_general_ci NOT NULL, `userid` mediumint(10) NOT NULL, PRIMARY KEY (`id`), KEY `uparent` (`uparent`), KEY `tagid` (`tagid`), KEY `userid` (`userid`) ) TYPE=MyISAM

I removed the "collate latin1_general_ci " and created the table manually (with phpMyAdmin).

[bS]

The auto-installer feature is a known issue, and the only thing that causes the release to be named  BETA .
I will alter the SQL to be as generic as possible and I also need a good way to check if the tables exist without throwing any errors.
I've looked at the way the MODx installer handles this thing but i'm still not happy about it.

Jot Beta 4 is available!
I added the badwords functionality, for usage documentation check the release notes. 

[sottwell]

I use code like this:

Code:

$sql = "SHOW TABLES LIKE 'mytable'";
$rs = $modx->db->query($sql);
$count = $modx->db->getRecordCount($rs);

and create the table/tables if $count is 0, or put up a page indicating that the table/s don't exist with a form with a button to let the user decide to create the tables or not. I use this for modules, to let the user decide to generate the tables at that point or not.