[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 (8h) : Van Ness played most of season with broken thumb

wpr (9-Apr) : yay

Zero2Cool (9-Apr) : Mark Murphy says Steelers likely to protect Packers game. Meaning, no Ireland

Zero2Cool (8-Apr) : Struggling to figure out what text editor options are needed and which are 'nice to have'

Mucky Tundra (8-Apr) : *CHOMP CHOMP CHOMP*

Zero2Cool (2-Apr) : WR who said he'd break Xavier Worthy 40 time...and ran slower than you

Mucky Tundra (2-Apr) : Who?

Zero2Cool (2-Apr) : Texas’ WR Isaiah Bond is scheduled to visit the Bills, Browns, Chiefs, Falcons, Packers and Titans starting next week.

Zero2Cool (2-Apr) : Spotting ball isn't changing, only measuring distance is, Which wasn't the issue.

Zero2Cool (2-Apr) : The spotting of the ball IS the issue. Not the chain gang.

Mucky Tundra (2-Apr) : Will there be a tracker on the ball or something?

Zero2Cool (1-Apr) : uh oh

Martha Careful (1-Apr) : Too bad camera's can't spot the ball as well.

Mucky Tundra (1-Apr) : So will the chain gang be gone completely or will they still be around as a backup or whatever?

Zero2Cool (1-Apr) : The method for measuring first downs in the NFL will switch from chain gangs to camera-based technology in 2025, the league announced.

Martha Careful (1-Apr) : A big step in the right direction. Just put in the college system is very very good.

Zero2Cool (1-Apr) : NFL has passed a rule that allows both teams to possess the ball in OT during the regular season

Zero2Cool (1-Apr) : Touchbacks on kickoffs will now bring the ball to the 35-yard line.

beast (31-Mar) : It might of gotten more popular recently, but braiding hair (even men) in certain cultures goes back for centuries.

Martha Careful (30-Mar) : Is men braiding their hair a new style thing? Watching the NCAA men's tournament many players have done

Zero2Cool (29-Mar) : Ha. Well, it'd be nice for folks to reset their own password. Via validated email 😏

beast (29-Mar) : Monopoly was supposed to be an educational game, that show how evil capitalism was and how we should avoid it

beast (29-Mar) : Lol, I was thinking username would be better, as then I wouldn't have to keep an email up to date lol 😂

beast (29-Mar) : Zero2Cool (25-Mar) : I was thinking email because I think it'll make folks keep it up todate lol

wpr (29-Mar) : sure is

Zero2Cool (29-Mar) : Monopoly is a rip off of The Landlord's Game

wpr (27-Mar) : 28 days until the draft

earthquake (27-Mar) : Which seemed strange to my 9 year old self, that you could be a fan for a team other than the one you play for

earthquake (27-Mar) : Nothing eventful happened, other than it being clear that he was a bengals fan

earthquake (27-Mar) : And we went and hung out with him one afternoon, I must have been 9 or so

earthquake (27-Mar) : That’s wild, when I was a kid my friend lived in the same apartment complex in De Pere

Mucky Tundra (27-Mar) : Only career highspot was a 200 yard rushing game while playing for the Cardinals

Mucky Tundra (27-Mar) : He is a former Packer. Drafted out of Northern Illinois. Didn't do much in GB.

dfosterf (26-Mar) : Despicable

Zero2Cool (26-Mar) : Former NFL. I think Packers too

Zero2Cool (26-Mar) : NFL RB Leshon Johnson has been charged in a massive dog fighting operation, with the FBI seizing over 190 Pit Bulls

Mucky Tundra (26-Mar) : Some real irony of a QB as short as Wilson playing for the Giants

Mucky Tundra (26-Mar) : Giants country, let's be the tall beings of lore!

Mucky Tundra (26-Mar) : Russell Wilson signs with the Giants.

Zero2Cool (25-Mar) : I was thinking email because I think it'll make folks keep it up todate lol

wpr (25-Mar) : I don't think there is a significant difference. I use a user name for many. Others email.

Martha Careful (25-Mar) : email

Zero2Cool (25-Mar) : would it be better to use EMAIL or USERNAME to log into a site?

wpr (25-Mar) : Thanks Zero

Zero2Cool (24-Mar) : New forum has the ability to Thank a post now.

beast (24-Mar) : And the only time they have won the Championship in an even year, was the first time they did, in 2006.

beast (24-Mar) : Since 2007, there have been 10 odd numbered years, Wisconsin Women have won the Championship in 7 of those 10 odd numbered years.

buckeyepackfan (24-Mar) : Congratulations Lady Badger Hockey Team. NATIONAL CHAMPIONS!!

Zero2Cool (23-Mar) : I don't think it's completed yet. it was just announced last month, right?

dhazer (23-Mar) : did netflix ever release the Packers documentary

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