[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 (6h) : Z, could you please combine my thread with yours please. I obviously did not see it when I Created it

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

Martha Careful (11h) : Packers looking to trade up

Martha Careful (13h) : Flag?

Martha Careful (13h) : Sag?

Nonstopdrivel (13h) : It rhymes with "bag."

beast (26-Apr) : Family? That's Deadpool's F word

Nonstopdrivel (26-Apr) : Not THAT f-word.

Zero2Cool (26-Apr) : fuck

beast (25-Apr) : 49ers are Cap Tight

beast (25-Apr) : Fuck

Mucky Tundra (25-Apr) : Kanata, I will be when I'm on my lunch later

TheKanataThrilla (25-Apr) : Love you NSD

Nonstopdrivel (25-Apr) : Huh. I guess the F-word is censored in this fan shout.

Nonstopdrivel (25-Apr) : Anyone who doesn't hang out in the chat probably smokes pole.

TheKanataThrilla (25-Apr) : GoPackGo Thinking CB is the pick tonight

TheKanataThrilla (25-Apr) : Anyone hanging out in the chat tonight?

Zero2Cool (25-Apr) : whoa...49ers have had trade conversations about both Deebo Samuel and Brandon Aiyuk

Zero2Cool (25-Apr) : I hope they take a Punter at 9th overall. Be bold!

Mucky Tundra (25-Apr) : I may end up eating those words but I think they need a lot more talent then their 4 picks can provide

Mucky Tundra (25-Apr) : I really hope they stand pat and Draft a WR

Mucky Tundra (25-Apr) : @DMRussini

Mucky Tundra (25-Apr) : The Chicago Bears are very open for business at 9 and telling teams they are ready to move for the right price, per source

buckeyepackfan (24-Apr) : Lions extend Penei Soul 4yrs - 112mil

buckeyepackfan (24-Apr) : Lions extend St. Brown 4 years 120mil and

Mucky Tundra (24-Apr) : Now look, trading up to 13 to take a TE might not seem like a good idea later but it will be later!

dfosterf (24-Apr) : (Your trade up mock post)

dfosterf (24-Apr) : Mucky- The only thing fun to watch would be me flipping the f out if Gute goes up to 13 and grabs Brock Bowers, lol

beast (24-Apr) : DT Byron Murphy II, Texas... whom some believe is the next Aaron Donald (or the closest thing to Donald)

Zero2Cool (24-Apr) : What? And who?

Mucky Tundra (24-Apr) : *sad Mucky noises*

Mucky Tundra (24-Apr) : @JoeJHoyt Murphy said he’s been told he won’t slide past pick No. 16.

wpr (23-Apr) : Just about time to watch Sonny Weaver stick it to the seahags. I never get tired of it.

Martha Careful (23-Apr) : *game plan

Martha Careful (23-Apr) : IMHO, not even close. He is not a guy you game play around.

Mucky Tundra (23-Apr) : is Aiyuk worth a 1st rounder?

Zero2Cool (23-Apr) : 49ers are seeking a 1st round pick in exchange for WR Brandon Aiyuk

Mucky Tundra (22-Apr) : Based on Gutes comments, now I don't feel as silly having 13 picks in my mock the other day

Zero2Cool (22-Apr) : Zach Wilson to Broncos.

Zero2Cool (22-Apr) : Gutekunst says he'd love to have 13 or 14 picks. He's trading back huh lol

beast (22-Apr) : Someday we'll have a draft betting scandal

beast (21-Apr) : Sometimes looking extremely amazing, sometimes looking extremely lost

beast (21-Apr) : I haven't looked into the QBs, but some have suggested Maye has some of the most extremely inconsistent tape they've seen

beast (21-Apr) : Well it also sounds like Patriots are listening to trade offers, not that seriously considering any, but listening means they aren't locked

Zero2Cool (21-Apr) : Maye needs to be AFC

Mucky Tundra (21-Apr) : Not liking the idea of the Vikings getting Maye

Zero2Cool (21-Apr) : Vikings HC joked that he may or may not have sent flowers to Bob Kraft. That's where rumor came from.

beast (21-Apr) : Can't tell if this is real or BS, but some rumors about a possible Patriots/Vikings trade for #3 overall

dfosterf (21-Apr) : One playbook to my knowledge. I was shooting for facetious.

beast (20-Apr) : I'm not sure they have different playbooks for different OL positions, and Dillard run blocking is supposedly worse than his pass blocking..

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