[FEATURE] Top 10 Members

Zero2Cool
Elite Member Topic Starter

12 years ago

Feel free to check out the Top 10 page - link . You can also click the link on the horizontal bar below that neat logo.

[list]

Received Applause - This shows the top 10 members who have received the most applause.

Gave Applause - This shows the top 10 members who have given the most applause.

Most Posts - This shows

Post with Most Applause - This looks for the top 10 posts with the most applause.

Characters per Post - This sums all of messages by characters typed and averages with how many posts have been submitted.

Least Active - This checks for everyone who has posted more than 500 times and hasn't logged into the site through the duration you've selected. So, if you set Quantity to 2 and Duration to Months ... you'll see the top 10 members who have over 500 posts and haven't logged into PackersHome.com in 2 months.

[/list]

NOTE: If you set Quantity to 3, and Duration to Weeks. You'll be checking the values for three weeks prior to today's date. If you set Duration to All, that will query the entire database.

Wanna join the discussion?! Login to your PACKERSHOME forum account or Register a new forum account

Pack93z
Select Member

12 years ago

Characters per post with all selected timed out.. That might be too big of a query for an all statement.

That might be a not doable request.

"The oranges are dry; the apples are mealy; and the papayas... I don't know what's going on with the papayas!"

Zero2Cool
Elite Member Topic Starter

12 years ago

Characters per post with all selected timed out.. That might be too big of a query for an all statement.

That might be a not doable request.

Originally Posted by: Pack93z

Hmm, I'll have to make that a stored procedure. It took about 10 seconds for me too. You may have been trying when I was updating the core site DLL?

I ran it just now and after about 10 seconds this was returned.
[list=1]

5882 Arrigo

4923 The_Turtle

3399 August

3349 bt_impaler

3278 macbob

3270 RashaanSalaami

3118 Guest

3092 INDUCEDCOMA

3069 CalifPacker

2468 pmanning[/list]

That pesky Guest!!

Pack93z
Select Member

12 years ago

5882 Arrigo

4923 The_Turtle

3399 August

3349 bt_impaler

3278 macbob

3270 RashaanSalaami

3118 Guest

3092 INDUCEDCOMA

3069 CalifPacker

2468 pmanning[/list]

That pesky Guest!!

Originally Posted by: Zero2Cool

Are characters within quotes parsed out? Curious.

"The oranges are dry; the apples are mealy; and the papayas... I don't know what's going on with the papayas!"

Zero2Cool
Elite Member Topic Starter

12 years ago

Are characters within quotes parsed out? Curious.

Originally Posted by: Pack93z

They include quotes. I can't figure out how to eliminate the information between the quotes without writing a stored procedure and even that's going to be tricky as we have a plethora of posts with multiple quote boxes in it. So, for the time being, it's all characters.

Zero2Cool
Elite Member Topic Starter

12 years ago

I'm finding this feature pretty interesting and I check it every other day.

Porforis
Veteran Member

12 years ago

I love looking at statistics, thanks!

wpr
Preferred Member

12 years ago

me likey. 👍 it is kind of fun.

edit- something else you can add is who uses the most icon/smilies. [grin1]

or perhaps who uses this one [vikes] the most.

wpr
Preferred Member

12 years ago

what about most links for youtube or pictures or news stories?

zombieslayer
Registered

12 years ago

#10

Wade doesn't have the most characters per post?
Hmm...:-k

My man Donald Driver

(thanks to Pack93z for the pic)
2010 will be seen as the beginning of the new Packers dynasty. 🇹🇹 🇲🇲 🇦🇷

Important Information:

The PACKERSHOME uses cookies. By continuing to browse this site, you are agreeing to our use of cookies. More Details Close

Fan Shout

Zero2Cool (1h) : If healthy after, then thats all I care. Well, no drops would be nice

wpr (2h) : I made it through the 1st Q.

dfosterf (11h) : Just gotta figure out how.

dfosterf (11h) : Could have been a worse start, so there is that.

beast (11h) : Yeah, someone tell the Packers football season has started, seems like they weren't ready for it

Mucky Tundra (12h) : Sooooooo many penalties

Mucky Tundra (12h) : It may only be preseason, but this game is a trip to the dentist

Zero2Cool (12h) : Packers do bad -- FREAK OUT!!!!!!

Zero2Cool (12h) : Packers do good -- eh only preseason

dfosterf (12h) : Well that half was fun

Zero2Cool (14h) : Great, zayne is down

Zero2Cool (14h) : 13 minutes away from kickkkkkkkkkkkkkkkkoffff

Zero2Cool (16h) : Had Celebration of Life for my uncle up north. wicked rain hope it dont come south

Mucky Tundra (18h) : THE GREEN BAY PACKERS ARE PLAYING FOOTBALL TONIGHT!!!!!! THIS IS NOT A DRILL!!!!

Zero2Cool (19h) : Woo-hoo

TheKanataThrilla (19h) : NFL Network is broadcasting the game tonight, but not in Canada. Not sure why as no local television is showing the game.

beast (8-Aug) : But the Return from IR designations had to be applied by the 53 man cutdown.

beast (8-Aug) : It's a new rule, so it's not clear, but my understanding was that they could be IR'd at any time

Mucky Tundra (8-Aug) : *had to be IRed at 53

Mucky Tundra (8-Aug) : beast, I thought the designate return from IR players had to be IR at cutdowns to 53, not before

beast (8-Aug) : It's a brand new rule, either last season or this season, prior, all pre-season IRs were done for the season

beast (8-Aug) : But the Packers would have to use one for their return from IR spots on him, when they cut down to 53.

beast (8-Aug) : I think the NFL recently changed the IR rules, so maybe the season might not be over for OL Glover.

Zero2Cool (8-Aug) : Packers star Howton, first NFLPA prez, dies at 95 😔

dfosterf (8-Aug) : Apparently it is too complicated for several to follow your simple instructions, but I digress

dfosterf (8-Aug) : Zero- Did you see what I posted about Voice of Reason and his wife? She posted over at fleaflicker that they are both "In"

Zero2Cool (7-Aug) : Well, not crazy, it makes sense. Crazy I didn't notice/find it earlier

Zero2Cool (7-Aug) : it's crazy how one stored procedure to get data bogged everything down for speed here

dfosterf (7-Aug) : to herd cats or goldfish without a bowl. They reminded me of the annual assembly of our fantasy league

dfosterf (7-Aug) : out on a field trip, outfitting them with little yellow smocks. Most of the little folk were well behaved, but several were like trying

dfosterf (7-Aug) : Yesterday my wife and I spent the afternoon on the waterfront here in Alexandria, Va. A daycare company took about 15 three/four year olds

wpr (7-Aug) : seems faster. yay

dfosterf (7-Aug) : Wife of reason posted on the in/out thread on fleaflicker that both she and vor are in

Zero2Cool (7-Aug) : This page was generated in 0.135 seconds.

Mucky Tundra (7-Aug) : Tbh, I can never tell the difference in speed unless it's completely shitting the bed

Zero2Cool (7-Aug) : Sure does feel like site is more snappy

Zero2Cool (6-Aug) : I thought that was the Lions OL

Mucky Tundra (6-Aug) : Travis Glover placed on IR; seasons over for him

Zero2Cool (6-Aug) : found bad sql in database, maybe site faster now?

dfosterf (5-Aug) : I'm going to call that a good move.

Zero2Cool (4-Aug) : Packers sign CB Corey Ballentine

Zero2Cool (4-Aug) : I'm not sure how to kill the draft order just yet so it's not so confusing.

Mucky Tundra (4-Aug) : *to be able

Mucky Tundra (4-Aug) : and because it's not a dynasty league (which makes a lot more sense to be ability to trade picks)

Mucky Tundra (4-Aug) : Oh I know; I was just exploring and it blew my mind that you could trade picks because of the whole reordering thing

Mucky Tundra (4-Aug) : Zero, I think I preferred my offer: your 1st for my 15th rounder

Zero2Cool (4-Aug) : Keep in mind, we do a draft reorder once all members locked in

Zero2Cool (4-Aug) : You can have my 12th Rd for your 2nd round

Mucky Tundra (4-Aug) : Hey i didn't know we could trade picks in fantasy

Mucky Tundra (3-Aug) : Update: Rock has tried a cheese curd, promises it's not his last

Please sign in to use Fan Shout

2025 Packers Schedule

Sunday, Sep 7 @ 3:25 PM

LIONS

Thursday, Sep 11 @ 7:15 PM

COMMANDERS

Sunday, Sep 21 @ 12:00 PM

Browns

Sunday, Sep 28 @ 7:20 PM

Cowboys

Sunday, Oct 12 @ 3:25 PM

BENGALS

Sunday, Oct 19 @ 3:25 PM

Cardinals

Sunday, Oct 26 @ 7:20 PM

Steelers

Sunday, Nov 2 @ 12:00 PM

PANTHERS

Monday, Nov 10 @ 7:15 PM

EAGLES

Sunday, Nov 16 @ 12:00 PM

Giants

Sunday, Nov 23 @ 12:00 PM

VIKINGS

Thursday, Nov 27 @ 12:00 PM

Lions

Sunday, Dec 7 @ 12:00 PM

BEARS

Sunday, Dec 14 @ 3:25 PM

Broncos

Friday, Dec 19 @ 11:00 PM

Bears

Friday, Dec 26 @ 11:00 PM

RAVENS

Saturday, Jan 3 @ 11:00 PM

Vikings