[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 (10h) : Both LB Quay Walker and Rookie DB Micah Robinson have passed their physicals

Zero2Cool (11h) : Happy to see site feels more snappy snappy

Zero2Cool (11h) : No sir. I did not.

dfosterf (11h) : You didn't get free childcare when you were at work?

wpr (12h) : These guys make hundreds of thousands of dollars a year. Pay for their own childcare.

dfosterf (13h) : 2nd issue. Number 1 issue was no gameday childcare. 1 of 3 teams not providing it

Zero2Cool (13h) : Suppose if locker room is main issue, we sitting pretty

wpr (13h) : I thought so Mucky. In those useless player polls GB always rates high overall. Locker is a part of it.

Mucky Tundra (14h) : Wasn't the locker room just updated like 6 or 7 years ago?

Zero2Cool (14h) : I have forum updated on different site. We'll see how this one goes before going to that

Zero2Cool (15h) : Elgton Jenkins has a back injury, is expect to end contract dispute

wpr (17h) : It's funny the PA complained about the locker room. It wasn't that long ago it was top shelf. Things change in a hurry.

wpr (17h) : The site is much more better.

Zero2Cool (17h) : NFLPA report said Packers lockerroom needed upgrade. Whining bout where you change?

Zero2Cool (17h) : I saw that and thought it was kind of lame.

dfosterf (17h) : Packers new locker room is pretty awesome. Great for morale, imo

Zero2Cool (18h) : Shuffled things on the web server. Hope it makes it faster.

Zero2Cool (18h) : Other times, it's turtle ass

Zero2Cool (18h) : Sometimes it's snappy, like now.

beast (19h) : I feel like it's loading at the top of the next minute, or something like that.

beast (19h) : Also the thanks/heart takes FOREVER to load, and posting in the shout box takes three times FOREVER!

beast (19h) : Thanks for saying something, I thought it was slow, but assumed it was on my end

Zero2Cool (19h) : Yeah, I noticed that too. Is it slow for PackerPeople.com too?

wpr (20h) : I don't know what you IT guys call it but the page loading is very slow for me today.

Zero2Cool (20h) : SSL might be settled now.

Zero2Cool (23-Jul) : Still working through SSL cert issues

wpr (23-Jul) : Glad to be back

Zero2Cool (23-Jul) : I think PH original finally working.

dfosterf (22-Jul) : Can tell you are having a fun day Kev

Zero2Cool (22-Jul) : Yep, I had to manually move them. It'll fix itself after more posts.

Mucky Tundra (22-Jul) : Same deal with the songs/videos thread, says you replied last but when I go there it's what I posted earlier is last

Zero2Cool (22-Jul) : I had to manually move three posts.

Mucky Tundra (22-Jul) : But when I go it, Martha's is the last reply

Mucky Tundra (22-Jul) : Still a little screwy; it shows on the main forum that you were the last person to reply to the Jenkins trade thread

Zero2Cool (22-Jul) : Host issues, been crazy day

Mucky Tundra (22-Jul) : Connect 4?

Zero2Cool (22-Jul) : Connecting to new database

Zero2Cool (22-Jul) : What the hell

beast (22-Jul) : Packershome going to the Whiteout unis again

Zero2Cool (21-Jul) : Oh wait, they got Cam Ward. 1st overall right? haha oops

Zero2Cool (21-Jul) : They could send Packers a 1st for a QB they are familiar with

Zero2Cool (21-Jul) : Titans QB Will Levis to have season-ending shoulder surgery

Zero2Cool (19-Jul) : Their season did kind of start there, so 🤷

dfosterf (19-Jul) : Eagles put an engraved Brazil flag on their super bowl rings

Zero2Cool (18-Jul) : Benton unsigned no more

Zero2Cool (17-Jul) : That's good analysis, yes you are getting old. It'd a blessing!

dfosterf (14-Jul) : *analysis* gettin' old

dfosterf (14-Jul) : One of the best analyisis I"ve ever watched at this time of an offseason

dfosterf (14-Jul) : Andy Herman interviewed Warren Sharp on his Pack a day podcast

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