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
    Martha Careful (12h) : I hope it is colder than a well-diggers ass on Thanksgiving night.
    Zero2Cool (20h) : doubt he wants to face the speedsters
    beast (21h) : Dolphins offense can be explosive... I wonder if we'll have Alexander back
    Zero2Cool (22h) : No Doubs could be issue Thursday
    Mucky Tundra (25-Nov) : Bears. Santos. Blocked FG
    Zero2Cool (24-Nov) : Bears. Vikings. OT
    Mucky Tundra (24-Nov) : Thems the breaks I guess
    Mucky Tundra (24-Nov) : Two players out and Williams had an injury designation this week but Oladapo is a healthy scratch
    Zero2Cool (24-Nov) : Packers inactives vs 49ers: • CB Jaire Alexander • S Kitan Oladapo • LB Edgerrin Cooper • OL Jacob Monk
    TheKanataThrilla (24-Nov) : Aaron Jones with a costly red zone fumble
    Zero2Cool (24-Nov) : When we trade Malik for a 1st rounder, we'll need a new QB2.
    packerfanoutwest (23-Nov) : Report: Aaron Rodgers wants to play in 2025, but not for the Jets
    beast (23-Nov) : That's what I told the Police officer about my speed when he pulled me over
    packerfanoutwest (23-Nov) : NFL told Bears that Packers’ blocked field goal was legal
    packerfanoutwest (22-Nov) : 49ers are underdogs at Packers, ending streak of 36 straight games as favorites
    Zero2Cool (22-Nov) : 49ers might be down their QB, DL, TE and LT?
    packerfanoutwest (22-Nov) : Jaire Alexander says he has a torn PCL
    Zero2Cool (20-Nov) : Even with the context it's ... what?
    Mucky Tundra (20-Nov) : Matt LaFleur without context: “I don’t wanna pat you on the butt and you poop in my hand.”
    beast (20-Nov) : We brought in a former Packers OL coach to help evaluate OL as a scout
    beast (20-Nov) : Jets have been pretty good at picking DL
    Zero2Cool (20-Nov) : He landed good players thanks to high draft slot. He isn't good.
    Zero2Cool (20-Nov) : He can shove his knowledge up his ass. He knows nothing.
    beast (20-Nov) : More knowledge, just like bring in the Jets head coach
    Zero2Cool (19-Nov) : What? Why? Huh?
    beast (19-Nov) : I wonder if the Packers might to try to bring Douglas in through Milt Hendrickson/Ravens connections
    Zero2Cool (19-Nov) : The Jets fired Joe Douglas, per sources
    packerfanoutwest (19-Nov) : Jets are a mess......
    Zero2Cool (19-Nov) : Pretty sure Jets fired their scouting staff and just pluck former Packers.
    Zero2Cool (19-Nov) : Jets sign Anders Carlson to their 53.
    Zero2Cool (19-Nov) : When you cycle the weeks, the total over remains for season. But you get your W/L for that selected week. Confusing.
    packerfanoutwest (19-Nov) : the total and percentage are the same as the previous weeks
    packerfanoutwest (19-Nov) : the total and percentage are the same as the previous weeks
    packerfanoutwest (19-Nov) : the totals are accurate..nrvrtmind
    Zero2Cool (19-Nov) : I don't follow what you are saying. The totals are not the same as last week.
    packerfanoutwest (19-Nov) : ok so then wht are the totals the same as last week?
    Zero2Cool (19-Nov) : NFL Pick'em is auto updated when NFL Scores tab is clicked
    Martha Careful (19-Nov) : The offense was OK. Let's not forget the Bear defense is very very good.
    packerfanoutwest (19-Nov) : Who updates the leaderboard on NFLPickem?
    beast (19-Nov) : Has the Packers offense been worse since the former Jets coach joined the Packers?
    Zero2Cool (19-Nov) : Offense gets his ass in gear, this could be good.
    Zero2Cool (19-Nov) : Backup QB helped with three wins. Special Teams contributed to three wins.
    bboystyle (18-Nov) : Lions played outside thats why. They scored 16 and 17 in the only 2 outside games this year
    Zero2Cool (18-Nov) : The rest of the NFL is catching up to Packers ... kicking is an issue throughout league
    packerfanoutwest (18-Nov) : Packers DL Kenny Clark: We knew 'we were going to block' Bears' game-winning field goal attempt
    Zero2Cool (18-Nov) : Lions seem to be throttling everyone, but only (only) got 24 lol maybe the rain is why
    Zero2Cool (18-Nov) : Packers vs Lions game doesn't seem so bad.
    beast (18-Nov) : Dennis Green "They are what we thought they were, and we let them off the hook!"
    Martha Careful (17-Nov) : comment of the day Z2Cool "Bears better than we want to admit. Packers worse than we think. It's facts."
    Mucky Tundra (17-Nov) : my worst case scenario: Bears fix their oline and get a coach like Johnson from the Lions and his scheme
    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 @ 12:00 PM
    Vikings
    Saturday, Jan 4 @ 11:00 PM
    BEARS
    Recent Topics
    12h / Green Bay Packers Talk / Zero2Cool

    12h / Green Bay Packers Talk / bboystyle

    19h / Green Bay Packers Talk / Zero2Cool

    25-Nov / Green Bay Packers Talk / buckeyepackfan

    24-Nov / Green Bay Packers Talk / buckeyepackfan

    24-Nov / Green Bay Packers Talk / Zero2Cool

    23-Nov / Green Bay Packers Talk / dfosterf

    23-Nov / Green Bay Packers Talk / Zero2Cool

    21-Nov / Green Bay Packers Talk / Martha Careful

    21-Nov / Green Bay Packers Talk / Zero2Cool

    21-Nov / Green Bay Packers Talk / beast

    20-Nov / Green Bay Packers Talk / Zero2Cool

    20-Nov / Green Bay Packers Talk / beast

    20-Nov / Green Bay Packers Talk / wpr

    19-Nov / Green Bay Packers Talk / dfosterf

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