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
    Zero2Cool (6h) : Packers coach Matt LaFleur hires Luke Getsy as senior assistant, extends Rich Bisaccia's deal
    Zero2Cool (13h) : Chiefs again huh? I guess another Super Bowl I'll be finding something else to do.
    Mucky Tundra (23h) : Chiefs Eagles...again...sigh
    dfosterf (27-Jan) : Happy Birthday Dave!
    Mucky Tundra (27-Jan) : happy birthday dhazer
    TheKanataThrilla (26-Jan) : Exactly buck...Washington came up with the ball. It is just a shitty coincidence one week later
    buckeyepackfan (26-Jan) : I forgot, they corrected the call a week later. Lol btw HAPPY BIRTHDAY dhazer!
    buckeyepackfan (26-Jan) : That brings up the question, why wasn't Nixon down by contact? I think that was the point Kanata was making.
    buckeyepackfan (26-Jan) : Turnovers rule, win the turnover battle, win the game.
    packerfanoutwest (26-Jan) : well, he was
    TheKanataThrilla (26-Jan) : Eagles down by contact on the fumble....fuck you NFL
    Mucky Tundra (26-Jan) : I think this games over
    beast (26-Jan) : Eagles sure get a lot of fumbles on kickoffs
    Mucky Tundra (26-Jan) : This game looks too big for Washington
    packerfanoutwest (26-Jan) : that being said, The Ravens are the Browns
    packerfanoutwest (26-Jan) : Browns, Dolphins have longest AFC Championship droughts
    packerfanoutwest (26-Jan) : As of today, Cowboys have longest NFC Championship drought,
    beast (26-Jan) : Someone pointed out, with Raiders hiring Carroll, the division games between Carroll and Jim Harbaugh are back on (who can whine more games)
    beast (26-Jan) : I'm confused, Pete Carroll and Brian Schottenheimer? When Todd Monken, Joe Brady, Kellen Moore, Kliff Kingsbury and Zac Robinson are availab
    Zero2Cool (25-Jan) : Any reason I'm catching a shot here about my intelligence?
    Martha Careful (25-Jan) : thank you Mucky for sticking up for me
    Martha Careful (25-Jan) : some of those people are smarter than you zero. However Pete Carroll is not
    Mucky Tundra (24-Jan) : Rude!
    beast (24-Jan) : Martha? 😋
    Zero2Cool (24-Jan) : Raiders hired someone from the elderly home.
    dfosterf (24-Jan) : I'm going with a combination of the two.
    beast (24-Jan) : Either the Cowboys have no idea what they're doing, or they're targeting their former OC, currently the Eagles OC
    Zero2Cool (23-Jan) : Fake news. Cowboys say no
    Zero2Cool (23-Jan) : Mystery candidate in the Cowboys head coaching search believed to be Packers ST Coordinator Rich Bisaccia.
    beast (23-Jan) : Also why do both NYC teams have absolutely horrible OL for over a decade?
    beast (23-Jan) : I wonder why the Jets always hire defensive coaches to be head coach
    Zero2Cool (22-Jan) : Still HC positions available out there. I wonder if Hafley pops up for one
    Zero2Cool (22-Jan) : Trent Baalke is out as the Jaguars GM.
    dfosterf (22-Jan) : Jeff Hafley would have been a better choice, fortunately they don't know that. Someone will figure that out next off season
    Zero2Cool (22-Jan) : Aaron Glenn Planning To Take Jets HC Job
    dfosterf (22-Jan) : Martha- C'est mon boulot! 😁
    Zero2Cool (22-Jan) : Thank you
    wpr (22-Jan) : Z, glad you are feeling better.
    wpr (22-Jan) : My son and D-I-L work for UM. It's a way to pick on them.
    Zero2Cool (22-Jan) : Thank you. I rarely get sick, and even more rarely sick to the point I can't work.
    wpr (22-Jan) : Beast- back to yesterday, I CAN say OSU your have been Michigan IF the odds of making the playoffs were more urgent.
    dfosterf (22-Jan) : Glad to hear you are feeling a bit better.
    Zero2Cool (22-Jan) : I've been near death ill last several days, finally feel less dead and site issues.
    Zero2Cool (22-Jan) : It is a big deal. This host is having issues. It's frustrating.
    Martha Careful (22-Jan) : just kidding...it was down
    Martha Careful (22-Jan) : you were blocked yesterday, due to a a recalcitrant demeanor yesterday in the penalty box for a recalcitrant demeanor
    dfosterf (22-Jan) : Was that site shutdown on your end or mine? No big deal, just curious
    beast (21-Jan) : That way teams like Indiana and SMU don't make the conference championships by simply avoiding all the other good teams in their own confere
    beast (21-Jan) : Also, with these "Super Conferences" instead of a single conference champion, have 4 teams make a Conference playoffs.
    beast (21-Jan) : Also in college football, is a bye week a good or bad thing?
    Please sign in to use Fan Shout
    2024 Packers Schedule
    Friday, Sep 6 @ 7:15 PM
    Eagles
    Sunday, Sep 15 @ 12:00 PM
    COLTS
    Sunday, Sep 22 @ 12:00 PM
    Titans
    Sunday, Sep 29 @ 12:00 PM
    VIKINGS
    Sunday, Oct 6 @ 3:25 PM
    Rams
    Sunday, Oct 13 @ 12:00 PM
    CARDINALS
    Sunday, Oct 20 @ 12:00 PM
    TEXANS
    Sunday, Oct 27 @ 12:00 PM
    Jaguars
    Sunday, Nov 3 @ 3:25 PM
    LIONS
    Sunday, Nov 17 @ 12:00 PM
    Bears
    Sunday, Nov 24 @ 3:25 PM
    49ERS
    Thursday, Nov 28 @ 7:20 PM
    DOLPHINS
    Thursday, Dec 5 @ 7:15 PM
    Lions
    Sunday, Dec 15 @ 7:20 PM
    Seahawks
    Monday, Dec 23 @ 7:15 PM
    SAINTS
    Sunday, Dec 29 @ 3:25 PM
    Vikings
    Sunday, Jan 5 @ 12:00 PM
    BEARS
    Sunday, Jan 12 @ 3:30 PM
    Eagles
    Recent Topics
    9m / Green Bay Packers Talk / wpr

    5h / Green Bay Packers Talk / beast

    13h / Green Bay Packers Talk / packerfanoutwest

    13h / Green Bay Packers Talk / beast

    25-Jan / Green Bay Packers Talk / beast

    25-Jan / Green Bay Packers Talk / Martha Careful

    25-Jan / Random Babble / Martha Careful

    20-Jan / Green Bay Packers Talk / Martha Careful

    20-Jan / Green Bay Packers Talk / bboystyle

    20-Jan / Green Bay Packers Talk / Zero2Cool

    20-Jan / Green Bay Packers Talk / beast

    19-Jan / Random Babble / Martha Careful

    18-Jan / Green Bay Packers Talk / Zero2Cool

    17-Jan / Green Bay Packers Talk / bboystyle

    17-Jan / Green Bay Packers Talk / Zero2Cool

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