[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

beast (19h) : Seems like he was just pissed because he was no longer the starter

beast (19h) : Campbell is right, he's rich and he doesn't have to explain sh!t... but that attitude gives teams reasons to never sign him again.

dfosterf (22-Feb) : I have some doubt about all that

dfosterf (22-Feb) : I read De'Vondre Campbell's tweet this morning (via the New York Post) Florio says that if he invested his earnings wisely, he will be good

beast (20-Feb) : I haven't followed, but I believe he's good when healthy, just hasn't been able to stay healthy.

dfosterf (20-Feb) : Hasn"t Bosa missed more games than he has played in the last 3 years?

Mucky Tundra (19-Feb) : He hasn't been too bad when healthy but I don't feel like I ever heard much about when he is

Zero2Cool (19-Feb) : Felt like he was more interested in his body, than football. He flashed more than I expected

Zero2Cool (19-Feb) : When he was coming out, I thought he'd be flash in pan.

Mucky Tundra (19-Feb) : Joey seems so forgettable compared to his brother for some reason

Zero2Cool (19-Feb) : NFL informed teams today that the 2025 salary cap will be roughly $277.5M-$281.5M

Zero2Cool (19-Feb) : Los Angeles Chargers are likely to release DE Joey Bosa this off-season as a cap casualty, per league source.

Zero2Cool (18-Feb) : If the exploit is not fixed, we'll see tons of "50 top free agents, 50 perfect NFL team fits: We picked where each should sign in March" lo

Zero2Cool (18-Feb) : Issue should be solved, database cleaned and held strong working / meeting. Boom!

Zero2Cool (18-Feb) : It should be halted now.

Mucky Tundra (18-Feb) : usually spambots are trying to get traffic to shady websites filled with spyware; the two links being spammed were to the Packers website

Mucky Tundra (18-Feb) : you know when you put it that way combined with the links it was spamming (to the official Packers website)

Zero2Cool (18-Feb) : Yep. You can do that with holding down ENTER on a command in Console of browser

Mucky Tundra (18-Feb) : even with the rapid fire posts?

Zero2Cool (18-Feb) : I'm not certain it's a bot.

Mucky Tundra (18-Feb) : I've got to go to work soon which is a pity because I'm enthralled by this battle between the bot and Zero

Zero2Cool (18-Feb) : Yeah, I see what that did. Kind of funny.

Mucky Tundra (18-Feb) : now it's a link to Wes Hodkiezwicz mailbag

Mucky Tundra (18-Feb) : Now they're back with another topic

Mucky Tundra (18-Feb) : oh lol

Zero2Cool (18-Feb) : I have a script that purges them now.

Zero2Cool (18-Feb) : 118 Topics with Message.

Mucky Tundra (18-Feb) : what's 118 (besides a number)?

Zero2Cool (18-Feb) : They got 118 slapped in there.

Mucky Tundra (18-Feb) : that's why it confused the hell out of me

Zero2Cool (18-Feb) : Yeah, but this is taking a headline and slapping it into the Packers Talk

Mucky Tundra (18-Feb) : Wasnt there a time guests could post in the help forum?

Zero2Cool (18-Feb) : lol good question, kind of impressed!

Mucky Tundra (18-Feb) : So how is a guest posting?

Mucky Tundra (18-Feb) : Tell them its an emergency

Zero2Cool (18-Feb) : Working. Meetings.

Mucky Tundra (18-Feb) : Lots of fun; the spam goes back 4 or 5 pages by this point

Mucky Tundra (18-Feb) : I thought you'd look for yourself and put 2 and 2 together lol. I overestimated ya ;)

Mucky Tundra (18-Feb) : I thought Guests couldnt post?

Zero2Cool (18-Feb) : And gosh that's gonna be fun to clean up! hahaa

Zero2Cool (18-Feb) : Oh. Why not just say that then? Geez.

Mucky Tundra (18-Feb) : check the main forum, seems a spam bot is running amok

Zero2Cool (18-Feb) : What?

Mucky Tundra (18-Feb) : Is the Packers online game "Packers Predict" now available for 2024? I can't tell

Zero2Cool (17-Feb) : Bengals planning to Franchise Tag Tamaurice Higgins

Zero2Cool (14-Feb) : Packers are hiring Luke Getsy as senior offensive assistant.

Martha Careful (12-Feb) : I would love to have them both, esp. Crosby, but either might be too expensive.

Zero2Cool (12-Feb) : Keisean Nixon is trying to get Maxx Crosby and Davante Adams lol

Mucky Tundra (11-Feb) : Yeah where did it go?

packerfanoutwest (11-Feb) : or did you resctrict access to that topic?

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