[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) : Fake news. Cowboys say no

Zero2Cool (2h) : Mystery candidate in the Cowboys head coaching search believed to be Packers ST Coordinator Rich Bisaccia.

beast (16h) : Also why do both NYC teams have absolutely horrible OL for over a decade?

beast (16h) : I wonder why the Jets always hire defensive coaches to be head coach

Zero2Cool (22-Jan) : Still HC positions available out there. I wonder if Hafley pops up for one

Zero2Cool (22-Jan) : Trent Baalke is out as the Jaguars GM.

dfosterf (22-Jan) : Jeff Hafley would have been a better choice, fortunately they don't know that. Someone will figure that out next off season

Zero2Cool (22-Jan) : Aaron Glenn Planning To Take Jets HC Job

dfosterf (22-Jan) : Martha- C'est mon boulot! 😁

Zero2Cool (22-Jan) : Thank you

wpr (22-Jan) : Z, glad you are feeling better.

wpr (22-Jan) : My son and D-I-L work for UM. It's a way to pick on them.

Zero2Cool (22-Jan) : Thank you. I rarely get sick, and even more rarely sick to the point I can't work.

wpr (22-Jan) : Beast- back to yesterday, I CAN say OSU your have been Michigan IF the odds of making the playoffs were more urgent.

dfosterf (22-Jan) : Glad to hear you are feeling a bit better.

Zero2Cool (22-Jan) : I've been near death ill last several days, finally feel less dead and site issues.

Zero2Cool (22-Jan) : It is a big deal. This host is having issues. It's frustrating.

Martha Careful (22-Jan) : just kidding...it was down

Martha Careful (22-Jan) : you were blocked yesterday, due to a a recalcitrant demeanor yesterday in the penalty box for a recalcitrant demeanor

dfosterf (22-Jan) : Was that site shutdown on your end or mine? No big deal, just curious

beast (21-Jan) : That way teams like Indiana and SMU don't make the conference championships by simply avoiding all the other good teams in their own confere

beast (21-Jan) : Also, with these "Super Conferences" instead of a single conference champion, have 4 teams make a Conference playoffs.

beast (21-Jan) : Also in college football, is a bye week a good or bad thing?

Martha Careful (21-Jan) : The tournament format was fine. Seeding could use some work.

beast (21-Jan) : You can't assume Ohio State would of won the Michigan game...

beast (21-Jan) : Rankings were 1) Oregon 2) Georgia 3) Texas 4) Penn State 5) Notre Dame 6) Ohio State, none of the rest mattered

wpr (21-Jan) : Texas, ND and OSU would have been fighting for the final 2 slots.

wpr (21-Jan) : Oregon and Georgia were locks. Without the luxury of extra playoff berths, Ohios St would have been more focused on Michigan game.

wpr (21-Jan) : Zero, no. If there were only 4 teams Ohio State would have been one of them. Boise St and ASU would not have been selected.

Zero2Cool (21-Jan) : So that was 7 vs 8, that means in BCS they never would made it?

Martha Careful (21-Jan) : A great game. Give ND credit for coming back, although I am please with the outcome.

Mucky Tundra (21-Jan) : FG to make it academic

Mucky Tundra (21-Jan) : and there's the dagger

Mucky Tundra (21-Jan) : ooooo 8 point game with 4 minutes to go!

Mucky Tundra (21-Jan) : ooooooooohhhhhh he missed!

Mucky Tundra (21-Jan) : Ooooo that completion makes things VERY interesting

Mucky Tundra (21-Jan) : Game not over yet

beast (21-Jan) : Oh yeah, Georgia starting quarterback season ending elbow injury

beast (21-Jan) : Sadly something happened to Georgia... they should be playing in this game against Ohio State

beast (21-Jan) : I thought Ohio State and Texas were both better than Notre Dame & Penn State

Mucky Tundra (21-Jan) : Notre Lame getting rolled

Martha Careful (21-Jan) : Ohio State just got punched in the gut. Lets see how they respond

Mucky Tundra (21-Jan) : Notre Lame vs the Luckeyes, bleh

Mucky Tundra (21-Jan) : Oh snap!!!

Zero2Cool (21-Jan) : Even Stevie Wonder can see that.

Zero2Cool (21-Jan) : Nah, you see Lions OC leaving to be HC of Bears is directly related to Packers.

Mucky Tundra (21-Jan) : ohhhhhhh Zero is in TROUBLE

packerfanoutwest (21-Jan) : Zero, per your orders, check Bearshome, not packershome

Zero2Cool (20-Jan) : Then he'll land with another team and flourish.

Zero2Cool (20-Jan) : Ben going to Bears. He'll be out in 3 years.

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

Sunday, Jan 12 @ 3:30 PM

Eagles

10 - 22