LeaderBoard - August 27, 2007

[Laura F.]

Hi Everyone,

The database stores the rating information as the number of ratings (avg_msg_rating_count) and the number of stars (avg_msg_rating_total).   However, it stores the number of stars as 10, 20, 30, 40, 50 instead of 1-5.  I then added an extra column (avg_rating) to do the math to get the rating how it is displayed in our community.  I just now noticed that once the column hits a user that does not have rating information, it stops calculating!

I'm working with the Sept. 24th file and will post it a little later today.

Thanks,
Laura

Message Edited by Laura F. on 09-26-2007 09:59 AM

[Laura F.]

Here is the LeaderBoard file for September 24th with the new information.  I've added the column that Ben requested: total number of stars/number of posts.  In the csv file, this is (avg_msg_rating_total/10)/posts. 

 I'm not sure that it tells me much, although it certainly shows which people had a 1 star bandit problem (JoeLabView and parthabe jump out)

Thanks,
Laura

[Laura F.]

Also -

Congrats Dennis on 12,000 posts!
Congrats Altenbach on 7,000 posts!

I really enjoy running the LeaderBoard and watching the post counts go up   

Thanks,
Laura

[Ben]

And by next time we may have to bestow a new title.

Ben

PS: Dennis you still have not doubled me, so there! (Where is that smiley with the tongue sticking out?).

[Ray.R]

It's a long way to catch up to the Zealous crowd... 

Congrats to both Dennis & Altenbach.. 

I doubt I'll catch up to tst before his title changes..  It'll take me 5 more years to get there... 😞

😉

[tst]

Looks like I have the most logins. I guess that's because of how I use the forums.

P.S. Congratulations Altenbach and Dennis (and Ben, while we're at it).

Phew, got rid of that one in a single post.

---

@JoeLabView wrote:

I doubt I'll catch up to tst before his title changes.. 

---

Hey, waddayaknow? I didn't even notice that. 33 32 posts to go.

I guess you just ruined a good surprise I was about to get when I would notice that bar.

[Ben]

Thank you Yair.

I'd congratulate you in advance as well if I did not suspect that you would register under a new name and start all over again just to mees with our heads.

Besides, the 5K multiples are special.

Ben

[Wayne.C]

Ben,

Maybe Yair already has an alter ego and you just don't know about it yet? 

[Ben]

Centerbolt said

"Maybe Yair already has an alter ego and you just don't know about it yet?   "

If he does, I don't think I'm ready to learn about that yet. Not only is he kicking my rear post-wise on this forum he also slipped in the top 5 on LAVA (as YEN) where he is approaching 1K posts.

No, I think I will stay in this nice little corner where I feel safe.

Ben

[Ray.R]

---

@tst wrote:

I guess you just ruined a good surprise I was about to get when I would notice that bar.

---

D'Oh!!!!!!!!!  :womansurprised: