CVS edit link for linksunten

Starting in the beginning of 2009, Indymedia linksunten was set up as a leftist open publishing platform for South-West Germany. Indymedia is an open source project relying heavily on the possibility of commenting the contributed articles. We chose Drupal 6 but unfortunately, we could not find any decent comment moderation module available at that time.

Then we found an unfinished comment moderation module by Kyle Cunningham (CitizenKane on drupal.org) which he coded for Dot KDE. You can see a preliminary version of the module running on http://dot.kde.org and the current version comment_rating-6.x-0.4-dev running on http://linksunten.indymedia.org/.

Here is a feature list of the Comment Rating module:

* Community driven rating of comments
* Unfolded and folded comment themes
* AJAX-driven rating or moderation of comments
* AJAX-driven folding and unfolding of comments
* Views integration via Voting API module
* Moderation queue through Views
* Action integration: ontopic & offtopic
* Missing Drupal 6 core action "publish comment"
* Comment permissions by role:
* rate comments/rate own comment
* change own rating
* set own threshold
* delete comments/delete own comments
* edit comments/edit own comments
* show display options
* administer comment rating
* Compatible with Comment Mover and Hidden module

We hope you think this module is useful and let us maintain it as a project on drupal.org. And when we find even more time, we want to refactor our upload_media module and publish it on drupal.org, too...

Best wishes

Bart - bartolomeo at indymedia dot org

Indymedia linksunten - linksunten at indymedia dot org

CommentFileSizeAuthor
#1 comment_rating-6.x-0.4-dev.tar_.gz15.87 KBlinksunten

Comments

linksunten’s picture

linksunten commented
StatusFileSize
new comment_rating-6.x-0.4-dev.tar_.gz15.87 KB

README.txt of comment_rating-6.x-0.4-dev:

=== Comment Rating Module ===

The Comment Rating module provides community driven
comment rating (similar to Slashdot) for Drupal.

=== Features ===

* Community driven rating of comments
* Unfolded and folded comment themes
* AJAX-driven rating or moderation of comments
* AJAX-driven folding and unfolding of comments
* Views integration via Voting API module
* Moderation queue through Views
* Action integration: ontopic & offtopic
* Missing Drupal 6 core action "publish comment"
* Comment permissions by role:
* rate comments/rate own comment
* change own rating
* set own threshold
* delete comments/delete own comments
* edit comments/edit own comments
* show display options
* administer comment rating
* Compatible with Comment Mover and Hidden module

=== Moderation Queue ===

Comment Rating depends on Voting API which has a Views 2 integration. Thus, you can easily build a moderation queue for unmoderated comments by creating a view:

* Sort criteria
** Comment: Post date asc (Sort order: Ascending, Granularity: Second)
* Relationships
** Comment: Individual votes (Label: Rating, Value type: Points, Vote tag: Vote)
* Filters
** Voting API votes: Value empty (Relationship: Rating, Operator: Is empty (NULL)
** Comment: In moderation No (Moderated: No)

=== Changelog ===

6.x-0.4-dev
* Changed name of the module to Comment Rating.
* Fixed bugs.
* More options can be set by role.
* Users can define their own threshold.
* Introduced constants.
* Splitted the module into more files.
* Revised code with respect to security issues.
* Revised code with respect to coding standards.
* Added more commentary to the code.

6.x-0.3-dev
* Fixed javascript and php bugs.
* Made different modes work:
threaded vs. flat, collapsed vs. uncollapsed.
* Wrote fold function and made javascript persistent.
* Implemented permanent links.
* Made URLs compatible with hidden module.

6.x-0.2-dev
* Prevent users from voting on their own comment.
* Completely disallow anonymous users from voting on commments.
* Better themeability provided by over-riding theme functions
from comment.module and replacing them with moderated comments templates.
* Provided a default stylesheet which provides reasonable looking moderation controls.
* Enhanced javascript to include automatic score updating.
* Fix bug preventing the provided javascript to not work with clean urls.

6.x-0.1-dev
* Initial Release

=== License ===

This file is copyright by Indymedia linksunten
Based on a comment moderation module by Kyle Cunningham
It is licensed under the GNU GPL v2.
See LICENSE.txt for further licensing details.

linksunten’s picture

linksunten commented
Status: Postponed (maintainer needs more info) » Needs review

I forgot to set the status to "needs review".

sun’s picture

sun
Primary language German
Location Karlsruhe
commented
Status: Needs review » Closed (won't fix)

Most of this functionality already exists. You should rework the code to leverage other modules and avoid duplication of efforts.

=== Features ===

* Community driven rating of comments => Fivestar/Voting API module.
* Unfolded and folded comment themes
* AJAX-driven rating or moderation of comments => Fivestar/Voting API module.
* AJAX-driven folding and unfolding of comments
* Views integration via Voting API module
* Moderation queue through Views => http://drupal.org/project/modules?text=comment%20moderation
* Action integration: ontopic & offtopic
* Missing Drupal 6 core action "publish comment" => Views Bulk Operations
* Comment permissions by role:
* rate comments/rate own comment => Fivestar/Voting API module.
* change own rating => Fivestar/Voting API module.
* set own threshold
* delete comments/delete own comments
* edit comments/edit own comments
* show display options
* administer comment rating => Fivestar/Voting API module.
* Compatible with Comment Mover and Hidden module

=== Moderation Queue ===

Comment Rating depends on Voting API which has a Views 2 integration. Thus, you can easily build a moderation queue for unmoderated comments by creating a view:

* Sort criteria
** Comment: Post date asc (Sort order: Ascending, Granularity: Second)
* Relationships
** Comment: Individual votes (Label: Rating, Value type: Points, Vote tag: Vote)
* Filters
** Voting API votes: Value empty (Relationship: Rating, Operator: Is empty (NULL)
** Comment: In moderation No (Moderated: No)
sun’s picture

sun
Primary language German
Location Karlsruhe
commented

Most of this functionality already exists. You should rework the code to leverage other modules and avoid duplication of efforts.

=== Features ===

* Community driven rating of comments => Fivestar/Voting API module.
* Unfolded and folded comment themes
* AJAX-driven rating or moderation of comments => Fivestar/Voting API module.
* AJAX-driven folding and unfolding of comments
* Views integration via Voting API module
* Moderation queue through Views => http://drupal.org/project/modules?text=comment%20moderation
* Action integration: ontopic & offtopic
* Missing Drupal 6 core action "publish comment" => Views Bulk Operations
* Comment permissions by role:
* rate comments/rate own comment => Fivestar/Voting API module.
* change own rating => Fivestar/Voting API module.
* set own threshold
* delete comments/delete own comments
* edit comments/edit own comments
* show display options
* administer comment rating => Fivestar/Voting API module.
* Compatible with Comment Mover and Hidden module

=== Moderation Queue ===

Comment Rating depends on Voting API which has a Views 2 integration. Thus, you can easily build a moderation queue for unmoderated comments by creating a view:

* Sort criteria
** Comment: Post date asc (Sort order: Ascending, Granularity: Second)
* Relationships
** Comment: Individual votes (Label: Rating, Value type: Points, Vote tag: Vote)
* Filters
** Voting API votes: Value empty (Relationship: Rating, Operator: Is empty (NULL)
** Comment: In moderation No (Moderated: No)
mfb’s picture

mfb
they or he
commented

Btw, I noticed incorrect usage of db_rewrite_sql() throughout. The db_query() args shouldn't be passed to db_rewrite_sql(), and also it should only used for SELECT queries (afaik).

ClearXS’s picture

ClearXS commented

Hi, please edit the extra "_" out (or rename):
comment_rating-6.x-0.4-dev.tar_.gz =>
comment_rating-6.x-0.4-dev.tar.gz
(otherwise it won't extract)

ClearXS’s picture

ClearXS commented

Btw, I noticed incorrect usage of db_rewrite_sql() throughout. The db_query() args shouldn't be passed to db_rewrite_sql(), and also it should only used for SELECT queries (afaik).

What could that give for practical problems? Errors with some other modules, or security issues?

- - - -

And can't this LinksUnten module (same for the Indymedia Alba approach) be integrated with existing moderation modules? Think that is the favorable way of doing so?

Wiki Moderation modules : http://groups.drupal.org/node/71618/