[FEATURE] Top 10 Members

Zero2Cool
Elite Member Topic Starter

11 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

11 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

11 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

11 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

11 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

11 years ago

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

Porforis
Veteran Member

11 years ago

I love looking at statistics, thanks!

wpr
Preferred Member

11 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

11 years ago

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

zombieslayer
Registered

11 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 (6-May) : Happy 93rd Birthday to the Greatest Baseball Player of All-Time...Willie Mays

Zero2Cool (6-May) : Walter Stanely's son

buckeyepackfan (6-May) : and released CB Anthony Johnson and DL Deandre Johnson and waived/injured WR Thyrick Pitts (thigh-rick).

buckeyepackfan (6-May) : The Green Bay Packers have signed WR Julian Hicks, OL Lecitus Smith (luh-SEET-us) and WR Dimitri Stanley

Zero2Cool (6-May) : Petty, but it's annoying me how the NFL is making the schedule release an event.

Mucky Tundra (4-May) : @mattschneidman Matt LaFleur on how he tore his pec: “Got in a fight with the bench press. I lost.”

Zero2Cool (3-May) : Jordan Love CAN sign an extension as of today. Might tak weeks/months though

TheKanataThrilla (3-May) : Packers decline 5th year option for Stokes

Mucky Tundra (3-May) : @ProFootballTalk Jaylen Warren: Steelers' special teams coach has discussed Justin Fields returning kicks.

Zero2Cool (2-May) : Season officially ending tonight for Bucks ... sad face

Zero2Cool (2-May) : Giannis Antetokounmpo is listed as out for tonight's game.

dfosterf (2-May) : Surprisingly low initially is my guess cap wise, but gonna pay the piper after that

dfosterf (2-May) : The number on Love is going to be brutal.

Zero2Cool (2-May) : May 3rd. Extension day for Jordan Love. (soonest)

Zero2Cool (1-May) : USFL MVP QB Alex McGough moved to WR. So that's why no WR drafted!

earthquake (1-May) : Packers draft starters at safety ever few years. Collins, Clinton-Dix, Savage

beast (1-May) : Why can't the rookies be a day 1 starter? Especially when we grabbed 3 of them at the position

dfosterf (1-May) : Not going to be shocked if Gilmore goes to the Lions.

dfosterf (1-May) : I hear you dhazer, but my guess would be Gilmore Colts and Howard Vikings from what little has been reported.

Mucky Tundra (30-Apr) : S learn from McKinney who learns from Hafley who learns from the fans. Guaranteed Super Bowl

Zero2Cool (30-Apr) : could*

Zero2Cool (29-Apr) : Safeties should learn from Xavier.

dhazer (29-Apr) : And what about grabbing a Gilmore or Howard at CB ? Those are all Free Agents left

dhazer (29-Apr) : out of curiosity do they try and sign Simmons or Hyde to let these young safeties learn from, they can't be day 1 starters.

Zero2Cool (29-Apr) : I miss having Sam Shields.

Zero2Cool (29-Apr) : Not that he's making excuses, just pointing it out

Zero2Cool (29-Apr) : That's for dang sure. Make our erratic kicker have no excuse!

packerfanoutwest (28-Apr) : having a great long snapper is gold

Zero2Cool (28-Apr) : LaFleur looking like he had some weight. Coachin will do that lol

Zero2Cool (28-Apr) : Thanks Mucky and whomever created topcos for each pick!

Zero2Cool (28-Apr) : Insane about Kingsley

dfosterf (28-Apr) : Putring it here so Mucky sees it. He was our guy!

dfosterf (28-Apr) : Bowden long snapper Wisconsin. Consensus best LS in college.

dfosterf (28-Apr) : We got Peter Bowde

dfosterf (28-Apr) : I personally interpret that as a partial tear that can be recovered from with rehab

dfosterf (28-Apr) : MLF said Kingsley Enagbare did NOT tear his ACL and did NOT require surgery, and that he is "looking good" for the 2024 season!

beast (28-Apr) : T.O. son signs with the 49ers

Mucky Tundra (28-Apr) : damn those vikings

beast (27-Apr) : UDFA Vikings sign TE – Trey Knox, South Carolina

beast (27-Apr) : Kitchen was all high from Miami, he was more lucky than talented in 2022 and it showed in 2023

beast (27-Apr) : Reportedly Packers have UDFAs Jennings and Jones

beast (27-Apr) : OL – Donovan Jennings, USF OT – Trente Jones, Michigan

TheKanataThrilla (27-Apr) : Interesting draft. A bit shocked that we didn't select an early CB. Definitely have Safety help. Pretty happy overall.

dhazer (27-Apr) : wow the last 2 picks are really stupid and probably will be special teams players Top 10 draft pick next year book it

TheKanataThrilla (27-Apr) : I think he ended up with a terrible RAS score

dhazer (27-Apr) : Anyone know what went on with Kitchens from Florida? At 1 point he was to be the Packers 1st round and he is way down the board now

Martha Careful (27-Apr) : Z, could you please combine my thread with yours please. I obviously did not see it when I Created it

Martha Careful (26-Apr) : Re: 'Kool-Aid' McKinstry. Other than Icky Woods, has there ever been a good NFLer with a childish nickname?

Martha Careful (26-Apr) : Packers looking to trade up

Martha Careful (26-Apr) : Flag?

Please sign in to use Fan Shout

2023 Packers Schedule

Sunday, Sep 10 @ 3:25 PM

Bears

38 - 20

Sunday, Sep 17 @ 12:00 PM

Falcons

24 - 25

Sunday, Sep 24 @ 12:00 PM

SAINTS

18 - 17

Thursday, Sep 28 @ 7:15 PM

LIONS

20 - 34

Monday, Oct 9 @ 7:15 PM

Raiders

13 - 17

Sunday, Oct 22 @ 3:25 PM

Broncos

17 - 19

Sunday, Oct 29 @ 12:00 PM

VIKINGS

10 - 24

Sunday, Nov 5 @ 12:00 PM

RAMS

20 - 3

Sunday, Nov 12 @ 12:00 PM

Steelers

19 - 23

Sunday, Nov 19 @ 12:00 PM

CHARGERS

23 - 20

Thursday, Nov 23 @ 11:30 AM

Lions

29 - 22

Sunday, Dec 3 @ 7:20 PM

CHIEFS

27 - 19

Monday, Dec 11 @ 7:15 PM

Giants

22 - 24

Sunday, Dec 17 @ 12:00 PM

BUCCANEERS

20 - 34

Sunday, Dec 24 @ 12:00 PM

Panthers

33 - 30

Sunday, Dec 31 @ 7:20 PM

Vikings

33 - 10

Sunday, Jan 7 @ 3:25 PM

BEARS

17 - 9

Sunday, Jan 14 @ 3:30 PM

Cowboys

48 - 32

Saturday, Jan 20 @ 7:15 PM

49ers

21 - 24