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 (2h) : Frigging host issues for site again
    beast (2h) : For the first time in their long history, the Bears fire their head coach mid-season. Which comes after three very close in-division losses.
    Zero2Cool (20h) : At the game now. Kampman and Cullen Jenkins are here.
    buckeyepackfan (20h) : Happy Thanksgiving Packer Fans! Gonna celebrate with some grilled Dolphin later!
    buckeyepackfan (20h) : Inactive 23 CB Jaire Alexander 56 LB Edgerrin Cooper 62 OL Jacob Monk 87 WR Romeo Doubs
    dhazer (20h) : Just a talking point, do we try and trade Jaire next year to get out from the contract as he can't stay healthy
    Zero2Cool (21h) : Happy Thanksgiving! About to head to game.
    wpr (22h) : Happy Thanksgiving
    Martha Careful (28-Nov) : Happy Thanksgiving Everybody...Go Packers!!!
    Zero2Cool (28-Nov) : That is what a lot of people seem to think. Even though when he was on Giants, he was trash.
    Martha Careful (27-Nov) : Brilliant move by Vikings!!! The signing provide great leverage in Darnold negotiations
    Mucky Tundra (27-Nov) : Boo!
    Zero2Cool (27-Nov) : Packers have ruled out Jaire Alexander, Edgerrin Cooper, and Romeo Doubs for Thursday's game against the Dolphins.
    Zero2Cool (27-Nov) : Daniel Jones joins Vikings
    Zero2Cool (27-Nov) : Tomorrow high 32° and low 19°
    beast (27-Nov) : Thanks Mucky!
    Mucky Tundra (27-Nov) : beast, forecast is looking like 27-28 degrees at kickoff, slight chance of snow flurries
    Zero2Cool (27-Nov) : Oh? It wasn't on the injury report. That sucks, but it's what is best.
    packerfanoutwest (26-Nov) : Doubs is out due to concussion
    beast (26-Nov) : What does the weather look like?
    Martha Careful (26-Nov) : You can wear long-johns mittens and a hat. We want Hill and their other skill guys FROZEN
    Zero2Cool (26-Nov) : I'm not sure I hope for that. I'll be at the game.
    Martha Careful (25-Nov) : I hope it is colder than a well-diggers ass on Thanksgiving night.
    Zero2Cool (25-Nov) : doubt he wants to face the speedsters
    beast (25-Nov) : Dolphins offense can be explosive... I wonder if we'll have Alexander back
    Zero2Cool (25-Nov) : 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......
    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
    34m / Green Bay Packers Talk / bboystyle

    2h / Green Bay Packers Talk / Mucky Tundra

    8h / Green Bay Packers Talk / wpr

    27-Nov / Green Bay Packers Talk / beast

    27-Nov / Green Bay Packers Talk / wpr

    26-Nov / Featured Content / Martha Careful

    26-Nov / Green Bay Packers Talk / Mucky Tundra

    25-Nov / Green Bay Packers Talk / Zero2Cool

    25-Nov / Green Bay Packers Talk / buckeyepackfan

    24-Nov / Green Bay Packers Talk / buckeyepackfan

    24-Nov / GameDay Threads / 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

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