Zero2Cool
12 years ago
I've started working on the NFL Picks application and in doing so created the ability to display data dynamically. You can see a little bit of an idea here - link .

That link shows the top ten most active members in the last 7 days by posts.

I was thinking of having the following things available as well.
[list]
  • Top 10 members over the last 7 days (maybe days will be dynamic?)
  • Top 10 members by post count
  • Top 10 members who have been applauded
  • Top 10 members who have given applause
  • Top 10 members who have more than 500 posts but haven't been around in 30 days [/list]


  • So, what do you think and are there anything you'd like to see? Remember, anything can be done so no idea is stupid or foolish.
    UserPostedImage
    Pack93z
    12 years ago
    Top 10 Posters in characters per post - especially if you could exclude characters within quotes.

    Post counts are nice.. but overall content added would be neat.

    Wade would probably win that hands down. [grin1]


    Additionally, top team members in applauds per post averages. (total Applaud counts / total posts)

    Neither pressing.. but more driven in quality of posts. Difference between a serial poster without much quality like me vs a more reserved posters with higher quality posts, like Porky88 that comes to mind.
    "The oranges are dry; the apples are mealy; and the papayas... I don't know what's going on with the papayas!"
    Zero2Cool
    12 years ago
    I think I got it, but the character one I think would really test my SQL skills, lol.



    Top 10 members who've typed the most alphanumeric characters per post.
    - Tally up all posts, do count on message by character, do parse count from [quote.] tags and minus that from total.

    Character Count - Member Name



    Top 10 applauded posts by member name and amount of applause.
    - Query top 10 posts with most Applause

    Applause - Member


    UserPostedImage
    Pack93z
    12 years ago

    I think I got it, but the character one I think would really test my SQL skills, lol.

    Top 10 members who've typed the most alphanumeric characters per post.
    - Tally up all posts, do count on message by character, do parse count from [quote.] tags and minus that from total.

    Character Count - Member Name

    Originally Posted by: Zero2Cool 



    Yep. Cannot make it easy. {Evil Snicker}


    "The oranges are dry; the apples are mealy; and the papayas... I don't know what's going on with the papayas!"
    Rockmolder
    12 years ago
    Top 10 posters from The Netherlands.
    Zero2Cool
    12 years ago

    Top 10 posters from The Netherlands.

    Originally Posted by: Rockmolder 



    [list=1]
  • Rockmolder
  • Rockmolder
  • Rockmolder
  • Rockmolder
  • Rockmolder
  • Rockmolder
  • Rockmolder
  • Rockmolder
  • Rockmolder
  • [*]Rockmolder[/list]
    UserPostedImage
    Pack93z
    12 years ago

    [list=1]

  • Rockmolder
  • Rockmolder
  • Rockmolder
  • Rockmolder
  • Rockmolder
  • Rockmolder
  • Rockmolder
  • Rockmolder
  • Rockmolder
  • Rockmolder[/list]

    Originally Posted by: Zero2Cool 


  • OR...

    1. R
    2. O
    3. C
    4. K
    5. M
    6. O
    7. L
    8. D
    9. E
    10 R

    I think he had that planned. 😉
    "The oranges are dry; the apples are mealy; and the papayas... I don't know what's going on with the papayas!"
    Zero2Cool
    12 years ago
    Haha, holy balls! The first two buttons worked perfect right out of the gate! God I love programming!!
    UserPostedImage
    Wade
    • Wade
    • Veteran Member
    12 years ago
    How about:

    1. Posts since poster put his foot in his mouth.
    2. Posts since poster got pissed off. (a "pissed off and post" button next to the "post" button)
    3. Posts since poster pissed someone off. (a "pisses me off" button next to the applaud button)
    And do not be conformed to this world, but be transformed by the renewing of your mind, that you may prove what is that good and acceptable and perfect will of God.
    Romans 12:2 (NKJV)
    Pack93z
    12 years ago
    Apparently I need to become more flippant in nature with doling out applause. Either that or I am a freaking scrooge. 🤔  GivingApplause.JPG You have insufficient rights to see the content.
    "The oranges are dry; the apples are mealy; and the papayas... I don't know what's going on with the papayas!"
    Fan Shout
    wpr (1h) : 1st world owners/stockholders problems dfosterf.
    Martha Careful (5h) : I would have otherwise admirably served
    dfosterf (7h) : Also, no more provision for a write-in candidate, so Martha is off the table at least for this year
    dfosterf (7h) : You do have to interpret the boring fine print, but all stockholders all see he is on the ballot
    dfosterf (7h) : It also says he is subject to another ballot in 2028. I recall nothing of this nature with Murphy
    dfosterf (7h) : Ed Policy is on my ballot subject to me penciling him in as a no.
    dfosterf (7h) : I thought it used to be we voted for the whatever they called the 45, and then they voted for the seven, and then they voted for Mark Murphy
    dfosterf (7h) : Because I was too lazy to change my address, I haven't voted fot years until this year
    dfosterf (7h) : of the folks that run this team. I do not recall Mark Murphy being subject to our vote.
    dfosterf (7h) : Ed Policy yay or nay is on the pre-approved ballot that we always approve because we are uninformed and lazy, along with all the rest
    dfosterf (7h) : Weird question. Very esoteric. For stockholders. Also lengthy. Sorry. Offseason.
    Zero2Cool (12h) : Maybe wicked wind chill made it worse?
    Mucky Tundra (19h) : And then he signs with Cleveland in the offseason
    Mucky Tundra (19h) : @SharpFootball WR Diontae Johnson just admitted he refused to enter a game in 41° weather last year in Baltimore because he felt “ice cold”
    Zero2Cool (24-Jun) : Yawn. Rodgers says he is "pretty sure" this be final season.
    Zero2Cool (23-Jun) : PFT claims Packers are having extension talks with Zach Tom, Quay Walker.
    Mucky Tundra (20-Jun) : GB-Minnesota 2004 Wild Card game popped up on my YouTube page....UGH
    beast (20-Jun) : Hmm 🤔 re-signing Walker before Tom? Sounds highly questionable to me.
    Mucky Tundra (19-Jun) : One person on Twitter=cannon law
    Zero2Cool (19-Jun) : Well, to ONE person on Tweeter
    Zero2Cool (19-Jun) : According to Tweeter
    Zero2Cool (19-Jun) : Packers are working on extension for LT Walker they hope to have done before camp
    dfosterf (18-Jun) : E4B landed at Andrews last night
    dfosterf (18-Jun) : 101 in a 60
    dfosterf (18-Jun) : FAFO
    Zero2Cool (18-Jun) : one year $4m with incentives to make it up to $6m
    dfosterf (18-Jun) : Or Lions
    dfosterf (18-Jun) : Beats the hell out of a Vikings signing
    Zero2Cool (18-Jun) : Baltimore Ravens now have signed former Packers CB Jaire Alexander.
    dfosterf (14-Jun) : TWO magnificent strikes for touchdowns. Lose the pennstate semigeezer non nfl backup
    dfosterf (14-Jun) : There was minicamp Thursday. My man Taylor Engersma threw
    dfosterf (11-Jun) : There will be a mini camp practice Thursday.
    Zero2Cool (11-Jun) : He's been sporting a ring for a while now. It's probably Madonna.
    Martha Careful (10-Jun) : We only do the tea before whoopee, it relaxes me.
    wpr (10-Jun) : That's awesome Martha.
    Mucky Tundra (10-Jun) : How's the ayahuasca tea he makes, Martha?
    Martha Careful (10-Jun) : Turns out he like older women
    Martha Careful (10-Jun) : I wasn't supposed to say anything, but yes the word is out and we are happy 😂😂😂
    Mucky Tundra (10-Jun) : I might be late on this but Aaron Rodgers is now married
    Mucky Tundra (10-Jun) : Well he can always ask his brother for pointers
    Zero2Cool (10-Jun) : Bo Melton taking some reps at CB as well as WR
    Zero2Cool (10-Jun) : key transactions coming today at 3pm that will consume more cap in 2025
    Zero2Cool (9-Jun) : Jaire played in just 34 of a possible 68 games since the start of the 2021 season
    Zero2Cool (9-Jun) : reported, but not expected to practice
    Zero2Cool (9-Jun) : Jenkins has REPORTED for mandatory camp
    Zero2Cool (9-Jun) : I really thought he'd play for Packers.
    buckeyepackfan (9-Jun) : Packers releasing Jaire Alexander.
    Mucky Tundra (8-Jun) : (Context: he wants his defense to create turnovers)
    Mucky Tundra (8-Jun) : Giants DC Shane Bowen tells players to “be a damn pirate."
    dfosterf (6-Jun) : Semper fi !
    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
    Recent Topics
    16h / Around The NFL / Martha Careful

    23-Jun / Green Bay Packers Talk / Mucky Tundra

    20-Jun / Green Bay Packers Talk / wpr

    20-Jun / Green Bay Packers Talk / beast

    20-Jun / Green Bay Packers Talk / beast

    18-Jun / Random Babble / Zero2Cool

    16-Jun / Green Bay Packers Talk / dfosterf

    15-Jun / Random Babble / Martha Careful

    14-Jun / Around The NFL / beast

    14-Jun / Community Welcome! / dfosterf

    13-Jun / Green Bay Packers Talk / dfosterf

    13-Jun / Green Bay Packers Talk / Adam

    12-Jun / Random Babble / Martha Careful

    12-Jun / Green Bay Packers Talk / Zero2Cool

    12-Jun / Green Bay Packers Talk / beast

    Headlines
    Copyright © 2006 - 2025 PackersHome.com™. All Rights Reserved.