New Feature: Message Rating System

Page 1Page 2The list can be sorted in other ways. For example, if you wish to see a mass of spammer suspension red dots, sort by "reg date" over at the right side of the table. Page 2 has a lot more than page 1.Adminnemooseus

From Message 45The message Larni is talking about is Message 1, which he posted on 04-29-2015, and he has 22 Cheers as of right now.Larni's great, I don't mean to take away from that. But how is this Member Rating supposed to work?He's still pegged at 10.0 three months later. How is it calculated?ABEIs it still this:rating = (total votes) / (total messages with one or more votes)from Message 203?Edited by Cat Sci, : No reason given.

Larni doesn't have enough votes to have a rating, must be a bug. I'll look into it tomorrow.

I did some checking myself and me having a persistent '10' rating is a feature, rather than a bug.I would leave it as it is or you may bork the whole message board.

Nobody likes a tattle tale.

We were out all day yesterday and today, so the feature will likely continue into tomorrow, though I am starting to look at it now.

As my Mom said; "Look but don't touch!"Edited by jar, : mu ---> my

Looks like the rating system is on hiatus. That's okay, it was hard to understand how mine would change up & down with no activity on my part.

This has unexpectedly become a busy period - nothing bad, but suddenly there are a bunch of things I have to take care of. So I've gotten into the middle of debugging this a couple times only to have to abandon the work. I've restored the printing of member ratings. I likely won't have time to work on this tomorrow either, but it shouldn't be too much longer.

Take your time, Percy. This rating thing is of no importance at all. You could turn it off permanently and ... well some people might yip but a lot of us couldn't care less.I know, I know, it's for the product. Ya gotta do what ya gotta do.Go about what needs doing. This will keep, I'm sure, for the next 6 to 48 months, give or take.

Sorry for causing a ruckus.I don't really care about the Member Rating, I was just curious how you intended it to work.What is it that it is rating? How "good" of a member you are? Or how much people like you? Or how good the content you post is?The current system doesn't indicate to me that it actually rates the members in any meaningful way.Do you want suggestions on changing the formula that calculates it?

The label "Member Rating" will be under control of the site manager. Sure. I've been struggling with this for a long time and have changed the formula at least twice that I remember.

Percy answers Cat Sci: Perhaps right after the total lifetime posts, you could put total lifetime "likes", then if you want to get fancy, the total likes over the last 100 posts. That would require a linked closed loop list of the last 100 for each member with a pointer to the next post to be replaced by a new one. Cool software stuff. I used to keep a Last 8 for my croquet players that way. C program...But maybe rule out the Coffee House??? Baby pictures? I dunno. I guess they're ok in their own way there.

The programming language is PHP (not c, unforunately), so one doesn't normally use linked lists (one *could*, but it isn't the way to go since the data is in the database), and the database is MySQL, so a good goal is to avoid needless queries. Right now votes are kept in a single table, so one might do a query like this to get all the votes for a given member's messages for the last 90 days: This returns an array of elements to PHP, each element an associative array with keys ['Yes'] and ['No'] (or [0] and [1] if you so choose), so you just count up the yes's and no's. You could also ask MySQL to do the counting for you, but that's more involved and probably not as fast.But I also have a dirty bit, so nothing is recalculated unless there's a change in the votes for his messages.Calculating total lifetime figures could be done at the same time and is relatively easy to add. I've considered excluding votes from certain locales and/or situations, but that would make the database tables and the queries more complicated, as well as the board's control panel so that the discussion board manager could set it up the way he wants.Edited by Admin, : Interestingly, [0] disappears unless you use HTML entities. All these years and I had no idea. I put this on my todo list. In my meantime I changed the text to use HTML entities.

That's what I would suggest. Then we can make up our own math.