[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 (6h) : Jets released K Riley Patterson and signed K Anders Carlson to the practice squad.

wpr (6h) : Thanks guys

Mucky Tundra (7-Nov) : Happy Birthday wpr!

Zero2Cool (7-Nov) : Anders Carlson ... released by 49ers

dfosterf (7-Nov) : Happy Birthday!😊😊😊

wpr (7-Nov) : Thanks Kevin.

Zero2Cool (7-Nov) : Happy Birthday, Wayne! 🎉🎂🥳

beast (7-Nov) : Edge Rushers is the same... it's not the 4-3 vs 3-4 change, it's the Hafley's version of the 4-3... as all 32 teams are actually 4-2

Zero2Cool (6-Nov) : OLB to DE and player requests trade. Yet folks say they are same.

beast (5-Nov) : In other news, the Green Bay Packers have signed Zero2Cool to update their website 😋 jk

beast (5-Nov) : Might just re-sign the kicker we got

beast (5-Nov) : Are there any kickers worth drafting next year?

Zero2Cool (5-Nov) : Preston Smith for Malik Willis

Mucky Tundra (5-Nov) : Getting a 7th rounder from the Stillers

Zero2Cool (5-Nov) : At least we get 7th round pick now!! HELLO NEW KICKER

Mucky Tundra (5-Nov) : Steelers getting a premier lockdown corner!

Zero2Cool (5-Nov) : Packers are trading edge rusher Preston Smith to the Pittsburgh Steelers, per sources.

Mucky Tundra (5-Nov) : Preston Smith traded to the Steelers!!!!

Zero2Cool (5-Nov) : CB Marshon Lattimore to Commanders

Zero2Cool (5-Nov) : Bears are sending RB Khalil Herbert to the Bengals, per sources.

Zero2Cool (5-Nov) : ZaDarius Smith continues his "north" tour.

Zero2Cool (5-Nov) : Let the Chiefs trade a 5th for him

Zero2Cool (5-Nov) : Nearing 30, large contract, nope.

Martha Careful (5-Nov) : any interest in Marshon Lattimore?

Zero2Cool (4-Nov) : What does NFL do if they're over cap?

Mucky Tundra (4-Nov) : They've been able to constantly push it out through extensions, void years etc but they're in the hole by 72 million next year I believe

hardrocker950 (4-Nov) : Seems the Saints are always in cap hell

Mucky Tundra (4-Nov) : Saints HC job is not an envious one; gonna be in cap hell for 3 years

Mucky Tundra (4-Nov) : Dennis Allen has now been fired twice mid-season with Derek Carr as his starting QB

Zero2Cool (4-Nov) : Kuhn let go

beast (4-Nov) : I wonder if the Packers would have any interest in Z. Smith, probably not

Zero2Cool (4-Nov) : Shefter says Browns and Lions will figure out how to get a deal done for Za'Darius Smith..

Zero2Cool (4-Nov) : Packers are more likely to have 1,000 yard rusher than 4,000 yard passer

Zero2Cool (3-Nov) : It's raining hard.

Zero2Cool (3-Nov) : Packers inactives vs. Lions: CB Jaire Alexander S Evan Williams C Josh Myers Non-injury inactives: WR Malik Heath OL Travis Glover DE Bren

packerfanoutwest (3-Nov) : Malik Willis: My focus is helping the Packers win, not proving I can start elsewhere. But he could

Zero2Cool (1-Nov) : I had Texans, but the loss of another WR flipped me

wpr (1-Nov) : I thought about taking the Jets but they've been a disaster. Losing to the Pats last week

Zero2Cool (1-Nov) : Surprised more didn't pick Jets in Pick'em.

Please sign in to use Fan Shout

2024 Packers Schedule

Friday, Sep 6 @ 7:15 PM

Eagles

29 - 34

Sunday, Sep 15 @ 12:00 PM

COLTS

16 - 10

Sunday, Sep 22 @ 12:00 PM

Titans

30 - 14

Sunday, Sep 29 @ 12:00 PM

VIKINGS

29 - 31

Sunday, Oct 6 @ 3:25 PM

Rams

24 - 19

Sunday, Oct 13 @ 12:00 PM

CARDINALS

34 - 13

Sunday, Oct 20 @ 12:00 PM

TEXANS

24 - 22

Sunday, Oct 27 @ 12:00 PM

Jaguars

30 - 27

Sunday, Nov 3 @ 3:25 PM

LIONS

14 - 24

Sunday, Nov 17 @ 12:00 PM

Bears

Sunday, Nov 24 @ 3:25 PM

49ERS

Thursday, Nov 28 @ 7:20 PM

DOLPHINS

Thursday, Dec 5 @ 7:15 PM

Lions

Sunday, Dec 15 @ 7:20 PM

Seahawks

Monday, Dec 23 @ 7:15 PM

SAINTS

Sunday, Dec 29 @ 12:00 PM

Vikings

Saturday, Jan 4 @ 11:00 PM

BEARS