Zero2Cool
11 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
    11 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
    11 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
    11 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
    11 years ago
    Top 10 posters from The Netherlands.
    Zero2Cool
    11 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
    11 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
    11 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
    11 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
    11 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
    Zero2Cool (4h) : Chase Young to sign $13M contract with Saints
    Zero2Cool (4h) : Yosh to Panthers what noooo. Wait he didn't do crap
    wpr (18-Mar) : I say that he is technically HER BIL as he married her sister. I checked it out, he's considered my BIL as well. Sad.
    Mucky Tundra (18-Mar) : wpr, I assume its your BIL via marriage to your wife? If so, I can figure out where the smarts in the family went ;)
    wpr (18-Mar) : Mucky my B-I-L is Bare Stupid. I could write a book.
    Mucky Tundra (18-Mar) : As a teenager in Rockford IL I would get heckled by adults in public for wearing GB gear
    Mucky Tundra (18-Mar) : if you think the online ones are bad, try *living amongst* them
    Mucky Tundra (18-Mar) : Never doubt wprs loyalty. Poor guy is surrounded by Bears fans in Northern IL
    wpr (17-Mar) : pass Martha. Thanks for the invite though.
    Martha Careful (17-Mar) : blog * as the same ugly Illinois colors were adopted by the Baer
    Martha Careful (17-Mar) : WPR, perhaps you should be joining the Bears fans blog has the same ugly Illinois colors were adopted by the Bears
    Mucky Tundra (17-Mar) : Ah a fellow U of Illinois hater. I can respect that though I imagine it's for different reasons
    Zero2Cool (17-Mar) : BTW. I didn't catch the game. I just hate Illinois.
    Mucky Tundra (17-Mar) : They're your Big Ten Chumps and you will like it!
    Zero2Cool (17-Mar) : No, not for the record. Referee's handled that BS. Orange team was trash ass
    Mucky Tundra (17-Mar) : *Your* Big Ten Chumps for the record
    Zero2Cool (17-Mar) : No, not Big Ten Champs. IL is big ten CHUMPS
    wpr (17-Mar) : Big Ten Champs
    wpr (17-Mar) : !!!
    wpr (17-Mar) : INI
    wpr (17-Mar) : ILL
    Martha Careful (17-Mar) : Wisconsin with an outstanding on in the men’s Big Ten basketball tournament. Let’s hope it continues in the NCAAs
    Zero2Cool (17-Mar) : Almost like taking QB in 2020 even if you don't need one is good move.
    Mucky Tundra (16-Mar) : 2021 QB Draft class looking like a real clunker
    Mucky Tundra (16-Mar) : A conditional 6th rounder? I remember Bears fans arguing they'd get a day 2 pick at worst lol
    dfosterf (16-Mar) : So I got the no extension part right and the have to wait on the CW physical wrong
    Zero2Cool (16-Mar) : Bears are trading Justin Fields for a 2025 6th-round pick that goes to a 4th-round pick based on playtime, per sources.
    Zero2Cool (16-Mar) : Former Packer Jarrett Bush opens Wisconsin’s first blow dry bar in Green Bay
    dfosterf (16-Mar) : If the Bears are not doing a deal with Washington, they also cannot trade Fields until Williams physical with them. All hail Caleb Williams!
    dfosterf (16-Mar) : The talent is undeniable, but the (advertised) haul is obscene.
    dfosterf (16-Mar) : If the Bears are cutting a deal with the Commanders, in either scenario, cannot happen until williams passes a Commanders physical
    dfosterf (16-Mar) : My guess is no to the Fields extension, but yes to the trade back with the Commanders.
    dhazer (15-Mar) : I think the Bears do a Love extension and they will trade out of the 1st pick and take the haul
    Martha Careful (15-Mar) : that might make sense
    Zero2Cool (15-Mar) : Justin Fields to Steelers?
    Zero2Cool (15-Mar) : Kenny Pickett. Eagles. Done.
    Zero2Cool (15-Mar) : They can claim best two WR tandem.
    Mucky Tundra (15-Mar) : Aaron Donald retiring
    dhazer (15-Mar) : Campbell signing with 49ers
    dhazer (15-Mar) : I love how the Bear Fans are now claiming they have the best skill players in the NFC North lol
    Zero2Cool (15-Mar) : Vikings made a move to get a 2nd first round pick
    Mucky Tundra (15-Mar) : That's a not a bad deal for the Bears
    Zero2Cool (15-Mar) : Bears have traded for WR Keenan Allen sending Chargers a fourth rounder.
    Martha Careful (15-Mar) : *signs
    Martha Careful (14-Mar) : MLB Devon White science with the Eagles
    Mucky Tundra (14-Mar) : But that was before FA started
    Mucky Tundra (14-Mar) : Dhaze, I thought Kurls would be their #1 target when I read that he was an Amos comp (jack of all trades guy)
    dhazer (14-Mar) : I would like to see the Packers target 2 more FA still available Kamren Curl Safety and Chase Young edge
    Martha Careful (14-Mar) : wow...didn't see that coming
    Zero2Cool (14-Mar) : AJ Dillon re-signing with Packers.
    Please sign in to use Fan Shout
    2023 Packers Schedule
    Sunday, Sep 10 @ 3:25 PM
    Bears
    Sunday, Sep 17 @ 12:00 PM
    Falcons
    Sunday, Sep 24 @ 12:00 PM
    SAINTS
    Thursday, Sep 28 @ 7:15 PM
    LIONS
    Monday, Oct 9 @ 7:15 PM
    Raiders
    Sunday, Oct 22 @ 3:25 PM
    Broncos
    Sunday, Oct 29 @ 12:00 PM
    VIKINGS
    Sunday, Nov 5 @ 12:00 PM
    RAMS
    Sunday, Nov 12 @ 12:00 PM
    Steelers
    Sunday, Nov 19 @ 12:00 PM
    CHARGERS
    Thursday, Nov 23 @ 11:30 AM
    Lions
    Sunday, Dec 3 @ 7:20 PM
    CHIEFS
    Monday, Dec 11 @ 7:15 PM
    Giants
    Sunday, Dec 17 @ 12:00 PM
    BUCCANEERS
    Sunday, Dec 24 @ 12:00 PM
    Panthers
    Sunday, Dec 31 @ 7:20 PM
    Vikings
    Sunday, Jan 7 @ 3:25 PM
    BEARS
    Sunday, Jan 14 @ 3:30 PM
    Cowboys
    Saturday, Jan 20 @ 7:15 PM
    49ers
    Recent Topics
    59m / Green Bay Packers Talk / beast

    9h / Green Bay Packers Talk / dfosterf

    10h / Green Bay Packers Talk / beast

    18-Mar / Around The NFL / Mucky Tundra

    16-Mar / Random Babble / Martha Careful

    16-Mar / Green Bay Packers Talk / TheKanataThrilla

    15-Mar / Green Bay Packers Talk / dhazer

    15-Mar / Green Bay Packers Talk / dfosterf

    14-Mar / Green Bay Packers Talk / beast

    14-Mar / Random Babble / Zero2Cool

    14-Mar / Green Bay Packers Talk / dfosterf

    13-Mar / Random Babble / Zero2Cool

    13-Mar / Green Bay Packers Talk / Martha Careful

    13-Mar / Green Bay Packers Talk / Martha Careful

    13-Mar / Green Bay Packers Talk / beast

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