[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

Mucky Tundra (3h) : Getting help would have been nice, but helping ourselves should always be the plan

beast (3h) : Too bad Seahawks couldn't beat Vikings

bboystyle (3h) : We just need to win Monday night and were in

Mucky Tundra (7h) : Or ties, but let's be real here

Mucky Tundra (7h) : Other scenario was Falcons+Rams losses

Mucky Tundra (7h) : Needed a Falcons loss for a Seahawk loss to clinch

buckeyepackfan (7h) : Am I wring in saying if Tge Vikings beat The Seahawks, The Packers clinch?

Mucky Tundra (21-Dec) : Agreed; you stinks

Zero2Cool (21-Dec) : I'm not beating anyone. I stinks.

Mucky Tundra (21-Dec) : rough injury for tank dell. guy can't catch abreak

beast (21-Dec) : So far the college playoffs have sucked... One team absolutely dominates the other

beast (21-Dec) : Well even if you weren't positive towards a guy, you wouldn't nessarily want to tell the media that (if they don't know about it)

Martha Careful (21-Dec) : I think MLF want Love to look past the end half issues, and feel good about his play. Our coaches generally keep a very positive tone.

beast (21-Dec) : I think a great running game will do that for most QBs

packerfanoutwest (21-Dec) : Coach Matt LaFleur has said quarterback Jordan Love is playing the best football of his career.

beast (21-Dec) : Oh, that's how you keep beating buckeye, with cheating

Zero2Cool (20-Dec) : There is a rule that if your name starts with 'b' you lose 15 points. Hey, I don't make the rules, I just enforce them!

wpr (20-Dec) : and then there is Beast. Running away with it all.

beast (20-Dec) : As of tonight, 3 way tie for 2nd in Pick'em, that battle is interesting!

beast (20-Dec) : Lions vs Vikings could be the main last game as it could determine division winners or #1 vs #2 seed

Mucky Tundra (20-Dec) : Or if KC needs to win for the #1 seed

Mucky Tundra (20-Dec) : Right now it looks like the only prime worthy games are Det-Minny and KC-Denver (if Denver can clinch a wild card spot)

Mucky Tundra (20-Dec) : The entirety of week 18 being listed as flex is weird

Zero2Cool (19-Dec) : Matt LaFleur today says unequivocally "Ted Thompson had nothing to do with the drafting of Jordan Love."

Zero2Cool (19-Dec) : Apparently, the editing is what pieces comments together. That Ted thing ... fake news.

Zero2Cool (19-Dec) : LaFleur "opportunity that Ted Thompson thought was too good to pass up"

Zero2Cool (19-Dec) : Jordan Love pick was Ted Thompson's idea.

Mucky Tundra (19-Dec) : Kyle Shanahan on signing De'Vondre Campbell as a FA last offseason: “We obviously made a mistake.”

packerfanoutwest (19-Dec) : Alexander’s last season with GB

Martha Careful (18-Dec) : if I were a professional athlete, I would probably look to see who the agent is for Kirk Cousins and then use him

beast (18-Dec) : $100 million fully guaranteed Kirk Cousins gets benched for rookie

Mucky Tundra (18-Dec) : a lower case b

Mucky Tundra (18-Dec) : The real lie is how beast capitalized his name in his message while it's normally spelled with

packerfanoutwest (18-Dec) : haha that's a lie

beast (17-Dec) : Despite what lies other might tell, Beast didn't hate the Winter Warnings, it felt refreshing to Beast for some reason.

Zero2Cool (17-Dec) : whiteout uniforms in general are pretty lame and weak. NFL greed at it's worst

Martha Careful (17-Dec) : The Viking uniforms, the whiteout uniforms specifically absolutely suck

beast (17-Dec) : Thanks Zero2Cool, looks a lot better now

beast (17-Dec) : Seems like someone has a crush on me, can't stop talking about me

Zero2Cool (17-Dec) : Should be gooder now. The forum default theme went to goofy land.

Zero2Cool (17-Dec) : What the hell

packerfanoutwest (17-Dec) : yeah beast hates the Winter Warning Unies

Mucky Tundra (16-Dec) : Okay I'm glad to know it's not just something happening to me lol

Mucky Tundra (16-Dec) : Zero, did you copy the Packers uniforms from last night and white out the board?

beast (16-Dec) : Oh crap, is the board going to the Winter Warning Uniforms too?!? It's all white on white right now!

Zero2Cool (16-Dec) : WR Odell Beckham Jr is officially a free agent after clearing waivers.

Zero2Cool (16-Dec) : Packers are 6th in sacks.

Zero2Cool (16-Dec) : RB David Montgomery will undergo season-ending knee surgery.

Mucky Tundra (16-Dec) : Dan Campbell on onside kick with 12 minutes left: In hindsight, wish I didn’t do that

Zero2Cool (16-Dec) : They have that whole 12th man thing so ...

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

Sunday, Dec 29 @ 12:00 PM

Vikings

Saturday, Jan 4 @ 11:00 PM

BEARS