[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) : CB Rasul Douglas is visiting the #Seahawks today, per source.

dfosterf (4h) : He's a switch and baiter. Its the same as a bait and switcher except he agreed to the switch first lol

dfosterf (4h) : 6.8 mil raise next year. Those are existing contract numbers

dfosterf (4h) : 12.8 plus 4.8 pro rata signing bonus is 17.6 mil. Top center in the league at 18

Zero2Cool (4h) : Elgton Jenkins wants to rework contract ahead of position change to center

Zero2Cool (7h) : 🏈Monday, Nov. 10: Eagles at Packers

buckeyepackfan (21h) : Packers @ Bears week 16(Saturday Game)

Zero2Cool (12-May) : Clifford hasn't been the same since losing 8

dfosterf (12-May) : Sean Clifford would probably disagree

dfosterf (12-May) : Canuck Cannon. Got a very good feeling about this

Zero2Cool (12-May) : Tom Pelissero also reports what bboy stated

bboystyle (12-May) : The Green Bay Packers on Monday signed Taylor Elgersma, the Canadian-born quarterback who tried out at the team’s rookie camp last weekend

beast (12-May) : There were reports four days ago that the Packers were signing QB Taylor Elgersma, but no official action since

Zero2Cool (12-May) : And for Ian Rapoport to announce Saints send 1st and 2nd rounder to Packers for Malik Willis.

dfosterf (12-May) : *Elgersma*

dfosterf (12-May) : Today would be a good day to discover the Pack signed Taylor Engersma, the Canadian QB

Zero2Cool (11-May) : It wasn't. He simply wanted his money back. They refused. Cops came. They gave him his money in end.

dfosterf (11-May) : Fortunately it doesn't sound like a big deal

Zero2Cool (10-May) : Elgton Jenkins Involved In Strip Club Dispute ... Cops Called To Mitigate

Zero2Cool (10-May) : Derek Carr retires. Shoulder must be bad.

Zero2Cool (10-May) : Packers Pro Shop is not currently printing Golden #22 jerseys “until his number is confirmed after Training Camp.”

greengold (9-May) : My impression is he's a Peruvian soccer fan not a bares fan.

Martha Careful (9-May) : Favored Illinois Bishop?

beast (9-May) : Technically, the I in FIB stands for Italian now, Si?

dfosterf (8-May) : I never thought I'd live long enough to call a pope a FIB, but here we are

Martha Careful (8-May) : Chicago produces a pope before it produces a 4000 yard passing quarterback

wpr (8-May) : HAHAHA Mucky Comment of the day.

Mucky Tundra (8-May) : According to reports, Mel Kiper is furious that Sanders wasn't selected as the new Pope

Zero2Cool (8-May) : Time taken to get picked:

Zero2Cool (8-May) : New Pope: 2 days | Shedeur Sanders: 3 days

Zero2Cool (8-May) : Collin Whitchurch @cowhitchurch · 1h Chicago got a pope before it got a QB to throw for 4,000 yards in a season.

Mucky Tundra (8-May) : New Pope from Chicago; in other words, the city produced a Pope before a 4000 yard passer

beast (7-May) : My first name starts with R and my beer belly is quite voluptuous! Thank you for noticing 😏

Zero2Cool (7-May) : beast, you're just one R from being voluptuous.

Zero2Cool (7-May) : And now some Packers blogger is like Doubs to Steelers makes sense!!!!

Zero2Cool (7-May) : You saw me Tweet???

beast (7-May) : Supposedly Steelers will be trading WR George Pickens to the Cowboys for a 3rd and late round pick swap

Zero2Cool (5-May) : Ravens release Justin Tucker, err D. Watson Jr?

Zero2Cool (5-May) : Cardinals have signed TE Josiah Deguara.

Zero2Cool (5-May) : If I were to "Google" it, then I wouldn't read it in your words.

Martha Careful (5-May) : Yes, in the military S2’s work on IPB, PERCEC, PHYSEC and IO

dfosterf (4-May) : FYI civilian companies swipe the S2 designation from the military. S2 is the intelligence branch up to brigade level. G2 is division level.

dfosterf (4-May) : Google it. Make sure to tack NFL on it or you will get the military meaning

Zero2Cool (4-May) : S2?

beast (4-May) : Seems like the S2 has a love/hate relationship with professional scouts.

beast (4-May) : In theory, the S2 test how quickly a QBs brain can solve game like issues and how quickly they can do it.

dfosterf (4-May) : Are you gentlemen and at least one lady familiar with the S2 cognition

Zero2Cool (4-May) : Maybe there isn't an issue.

beast (4-May) : NFL really needs to fix their position labeling issue, but I don't think they care

Zero2Cool (1-May) : Packers did not activate the fifth-year options for linebacker Quay Walker, with the goal of signing him to a contract extension.

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

30 - 17

Thursday, Dec 5 @ 7:15 PM

Lions

31 - 34

Sunday, Dec 15 @ 7:20 PM

Seahawks

30 - 13

Monday, Dec 23 @ 7:15 PM

SAINTS

34 - 0

Sunday, Dec 29 @ 3:25 PM

Vikings

25 - 27

Sunday, Jan 5 @ 12:00 PM

BEARS

22 - 24