Scoop || ordering comment ratiings

Front Page · Everything · News · Code · Help! · Wishlist · Project · Scoop Sites · Dev Notes · Latest CVS changes · Development Activities

ordering comment ratiings
By dr k , Section Code [] Posted on Fri Feb 22, 2002 at 12:00:00 PM PST

It would be nice if the comment ratings page (when you click on the score for a specific comment) had the user moderations sorted by rating. All the 5's at the top, all the 1's/0's at the bottom. Someone would just have to add an "ORDER BY" to the query.

< "TITLE" attribute should be used for tootlips | The Edge City Chronicle >

Menu

· create account
· faq
· search
· report bugs
· Scoop Administrators Guide
· Scoop Box Exchange

Login

Make a new account

Username:

Password:

Related Links

· More on Feature Requests
· Also by dr k

Story Views

17 Scoop users have viewed this story.

ordering comment ratiings | 6 comments (6 topical, 0 hidden)

Good idea (none / 0) (#1)
by rusty on Sun Mar 03, 2002 at 06:14:44 AM PST

For anyone looking to add this, in the "show_comment_raters" box, simply change the part that reads:

my ($rv, $sth) = $S->db_select({
  WHAT => 'uid, rating',
  FROM => 'commentratings',
  WHERE => qq{sid = $f_sid AND cid = $f_cid}});

To:

my ($rv, $sth) = $S->db_select({
  WHAT => 'uid, rating',
  FROM => 'commentratings',
  WHERE => qq{sid = $f_sid AND cid = $f_cid},
  ORDER_BY => 'rating DESC'});

This is a reply by rusty, 03/18/2002 11:21:06 AM PST (none / 0)

Still testing by rusty, 03/18/2002 11:21:46 AM PST (none / 0)

Am I just testing? Yes, yes I am. by rusty, 03/18/2002 11:23:27 AM PST (none / 0)

Great post (none / 0) (#5)
by mark22 on Tue Nov 01, 2016 at 08:11:37 AM PST

You have posted a nice tutorial which i like reading. I have learned a lot from your post. Keep writing such articles. gymnastic mats

best kitchen remodeling brooklyn (none / 0) (#6)
by Pervez on Sun Mar 31, 2019 at 01:04:48 PM PST

Love suitable for building having chiropractor doctor health practitioner. The internet site far more could possibly as I be given which model of truth publicized into their usual good course of action. It truly is simple to press in this article best kitchen remodeling brooklyn Together with agree to one's website page.

ordering comment ratiings | 6 comments (6 topical, 0 hidden)

create account | faq | search