[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 (25m) : To this day, I'm still miffed about his 4 TD game against Dallas on Thanksgiving going to waste

Martha Careful (1h) : Congratulations Sterling Sharpe. He was terrific and I loved watching him play.

beast (17h) : I believe it's technically against the CBA rules, but Jerry just calls it a simple unofficial chat... and somehow gets away with it.

beast (17h) : Jerry Jones is infamous for ̶n̶e̶g̶o̶t̶i̶a̶t̶i̶n̶g̶ chatting with players one on one... and going around the agent.

Mucky Tundra (23h) : Oo just saw a blurb saying that Dallas negotiated directly with Parsons and not through his agent

Mucky Tundra (1-Aug) : I assumed that both guys will get paid, just a matter of when or how we get there

Zero2Cool (1-Aug) : McLaurin nor Micah going anywhere. They will get money

Mucky Tundra (1-Aug) : the Synder years or do they take care of one of their own?

Mucky Tundra (1-Aug) : Do the Commanders risk losing a top WR with an emerging QB just because he's turning 30 and potentially risk damaging the rebuild from

Mucky Tundra (1-Aug) : Turns 30 this September, plays at a high level and Washington has some cap space I believe

Mucky Tundra (1-Aug) : More interesting is Washington with Terry McLaurin

Mucky Tundra (1-Aug) : I would imagine Dallas will resolve this issue with a truckload of money

Zero2Cool (1-Aug) : Micah pulling a Myles with trade request

beast (1-Aug) : Packers should make some cheese forks

Mucky Tundra (31-Jul) : GRAB THE PITCHFORKS~

Zero2Cool (31-Jul) : CUT HIM

Mucky Tundra (31-Jul) : Socieltal collapse imminent

Mucky Tundra (31-Jul) : The West has fallen

Mucky Tundra (31-Jul) : After starting off camp with 25 straight made field goals, Brandon McManus has missed one

Zero2Cool (31-Jul) : But it should be stable

Zero2Cool (31-Jul) : It's probably gonna be slower.

Zero2Cool (31-Jul) : We're gonna just full go on to the new host.

Zero2Cool (31-Jul) : What crap. Site issues galore

Zero2Cool (30-Jul) : if PH dies, there is packerpeople com available

Zero2Cool (30-Jul) : database is on new host, eventually website will follow

Mucky Tundra (30-Jul) : Zero, regarding Ewers, you are correct.

Zero2Cool (30-Jul) : Sadly, this might be our life for awhile. I could put it on another host, but seems it was slower, although more stable

beast (30-Jul) : How long will it be down?

beast (30-Jul) : RIP site 😭

Zero2Cool (30-Jul) : Site will die, I have to restart it.

Zero2Cool (30-Jul) : Quinn stinks. Lot of underthrows. (my guess)

beast (30-Jul) : How did Quinn Ewers effect where Golden was drafted?

dfosterf (30-Jul) : All I've experienced was late at night or early morning. I just figured you were doing something in the background

Zero2Cool (30-Jul) : Site sure seems to be down more than up

dfosterf (29-Jul) : 50 cent hookers? I'm moving to Green Bay. I thought it was just real estate that was more affordable there. 😂

Zero2Cool (29-Jul) : Sure seems site going down more than 50¢ hooker

Mucky Tundra (27-Jul) : Golden with two TDs in red zone drills today

Mucky Tundra (27-Jul) : @JacobMorley Shoutout to Quinn Ewers for allowing Matthew Golden to be available when Green Bay picked.

Zero2Cool (27-Jul) : The menu you expanded to log in, it's the first icon under "PackersHome" .. maybe i should add text to it

dfosterf (27-Jul) : Feelin' pfowish can't find the sun. No big deal, will drag a laptop out when the time comes

Zero2Cool (27-Jul) : if you're on mobile, open the menu and its the "sun" icon

dfosterf (27-Jul) : Can't find the toggle, lol

dfosterf (27-Jul) : I can find that the Microsoft lady rep for Titletown Tech is the philanthropy boss for the entire Microsoft corporation, but. .

Zero2Cool (27-Jul) : There's a toggle for light/dark theme. Super easy.

dfosterf (27-Jul) : The white background beta was hard to read, especially the quotes

dfosterf (27-Jul) : Hopefully the color scheme remains the same

dfosterf (27-Jul) : *Friday*

dfosterf (27-Jul) : 100 million would be 539 million as of Fridsy

dfosterf (27-Jul) : Heck, they could have taken a hundred milliion and invested in DAVE inc. last year (semi random, humor, but real)

dfosterf (27-Jul) : Beer brat and ticket is where the money comes from

Please sign in to use Fan Shout

2025 Packers Schedule

Sunday, Sep 7 @ 3:25 PM

LIONS

Thursday, Sep 11 @ 7:15 PM

COMMANDERS

Sunday, Sep 21 @ 12:00 PM

Browns

Sunday, Sep 28 @ 7:20 PM

Cowboys

Sunday, Oct 12 @ 3:25 PM

BENGALS

Sunday, Oct 19 @ 3:25 PM

Cardinals

Sunday, Oct 26 @ 7:20 PM

Steelers

Sunday, Nov 2 @ 12:00 PM

PANTHERS

Monday, Nov 10 @ 7:15 PM

EAGLES

Sunday, Nov 16 @ 12:00 PM

Giants

Sunday, Nov 23 @ 12:00 PM

VIKINGS

Thursday, Nov 27 @ 12:00 PM

Lions

Sunday, Dec 7 @ 12:00 PM

BEARS

Sunday, Dec 14 @ 3:25 PM

Broncos

Friday, Dec 19 @ 11:00 PM

Bears

Friday, Dec 26 @ 11:00 PM

RAVENS

Saturday, Jan 3 @ 11:00 PM

Vikings