[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

Martha Careful (11h) : I hope it is colder than a well-diggers ass on Thanksgiving night.

Zero2Cool (19h) : doubt he wants to face the speedsters

beast (19h) : Dolphins offense can be explosive... I wonder if we'll have Alexander back

Zero2Cool (21h) : No Doubs could be issue Thursday

Mucky Tundra (25-Nov) : Bears. Santos. Blocked FG

Zero2Cool (24-Nov) : Bears. Vikings. OT

Mucky Tundra (24-Nov) : Thems the breaks I guess

Mucky Tundra (24-Nov) : Two players out and Williams had an injury designation this week but Oladapo is a healthy scratch

Zero2Cool (24-Nov) : Packers inactives vs 49ers: • CB Jaire Alexander • S Kitan Oladapo • LB Edgerrin Cooper • OL Jacob Monk

TheKanataThrilla (24-Nov) : Aaron Jones with a costly red zone fumble

Zero2Cool (24-Nov) : When we trade Malik for a 1st rounder, we'll need a new QB2.

packerfanoutwest (23-Nov) : Report: Aaron Rodgers wants to play in 2025, but not for the Jets

beast (23-Nov) : That's what I told the Police officer about my speed when he pulled me over

packerfanoutwest (23-Nov) : NFL told Bears that Packers’ blocked field goal was legal

packerfanoutwest (22-Nov) : 49ers are underdogs at Packers, ending streak of 36 straight games as favorites

Zero2Cool (22-Nov) : 49ers might be down their QB, DL, TE and LT?

packerfanoutwest (22-Nov) : Jaire Alexander says he has a torn PCL

Zero2Cool (20-Nov) : Even with the context it's ... what?

Mucky Tundra (20-Nov) : Matt LaFleur without context: “I don’t wanna pat you on the butt and you poop in my hand.”

beast (20-Nov) : We brought in a former Packers OL coach to help evaluate OL as a scout

beast (20-Nov) : Jets have been pretty good at picking DL

Zero2Cool (20-Nov) : He landed good players thanks to high draft slot. He isn't good.

Zero2Cool (20-Nov) : He can shove his knowledge up his ass. He knows nothing.

beast (20-Nov) : More knowledge, just like bring in the Jets head coach

Zero2Cool (19-Nov) : What? Why? Huh?

beast (19-Nov) : I wonder if the Packers might to try to bring Douglas in through Milt Hendrickson/Ravens connections

Zero2Cool (19-Nov) : The Jets fired Joe Douglas, per sources

packerfanoutwest (19-Nov) : Jets are a mess......

Zero2Cool (19-Nov) : Pretty sure Jets fired their scouting staff and just pluck former Packers.

Zero2Cool (19-Nov) : Jets sign Anders Carlson to their 53.

Zero2Cool (19-Nov) : When you cycle the weeks, the total over remains for season. But you get your W/L for that selected week. Confusing.

packerfanoutwest (19-Nov) : the total and percentage are the same as the previous weeks

packerfanoutwest (19-Nov) : the totals are accurate..nrvrtmind

Zero2Cool (19-Nov) : I don't follow what you are saying. The totals are not the same as last week.

packerfanoutwest (19-Nov) : ok so then wht are the totals the same as last week?

Zero2Cool (19-Nov) : NFL Pick'em is auto updated when NFL Scores tab is clicked

Martha Careful (19-Nov) : The offense was OK. Let's not forget the Bear defense is very very good.

packerfanoutwest (19-Nov) : Who updates the leaderboard on NFLPickem?

beast (19-Nov) : Has the Packers offense been worse since the former Jets coach joined the Packers?

Zero2Cool (19-Nov) : Offense gets his ass in gear, this could be good.

Zero2Cool (19-Nov) : Backup QB helped with three wins. Special Teams contributed to three wins.

bboystyle (18-Nov) : Lions played outside thats why. They scored 16 and 17 in the only 2 outside games this year

Zero2Cool (18-Nov) : The rest of the NFL is catching up to Packers ... kicking is an issue throughout league

packerfanoutwest (18-Nov) : Packers DL Kenny Clark: We knew 'we were going to block' Bears' game-winning field goal attempt

Zero2Cool (18-Nov) : Lions seem to be throttling everyone, but only (only) got 24 lol maybe the rain is why

Zero2Cool (18-Nov) : Packers vs Lions game doesn't seem so bad.

beast (18-Nov) : Dennis Green "They are what we thought they were, and we let them off the hook!"

Martha Careful (17-Nov) : comment of the day Z2Cool "Bears better than we want to admit. Packers worse than we think. It's facts."

Mucky Tundra (17-Nov) : my worst case scenario: Bears fix their oline and get a coach like Johnson from the Lions and his scheme

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

20 - 19

Sunday, Nov 24 @ 3:25 PM

49ERS

38 - 10

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