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
    beast (31m) : My first name starts with R and my beer belly is quite voluptuous! Thank you for noticing 😏
    Zero2Cool (4h) : beast, you're just one R from being voluptuous.
    Zero2Cool (4h) : And now some Packers blogger is like Doubs to Steelers makes sense!!!!
    Zero2Cool (4h) : You saw me Tweet???
    beast (4h) : Supposedly Steelers will be trading WR George Pickens to the Cowboys for a 3rd and late round pick swap
    Zero2Cool (5-May) : Ravens release Justin Tucker, err D. Watson Jr?
    Zero2Cool (5-May) : Cardinals have signed TE Josiah Deguara.
    Zero2Cool (5-May) : If I were to "Google" it, then I wouldn't read it in your words.
    Martha Careful (5-May) : Yes, in the military S2’s work on IPB, PERCEC, PHYSEC and IO
    dfosterf (4-May) : FYI civilian companies swipe the S2 designation from the military. S2 is the intelligence branch up to brigade level. G2 is division level.
    dfosterf (4-May) : Google it. Make sure to tack NFL on it or you will get the military meaning
    Zero2Cool (4-May) : S2?
    beast (4-May) : Seems like the S2 has a love/hate relationship with professional scouts.
    beast (4-May) : In theory, the S2 test how quickly a QBs brain can solve game like issues and how quickly they can do it.
    dfosterf (4-May) : Are you gentlemen and at least one lady familiar with the S2 cognition
    Zero2Cool (4-May) : Maybe there isn't an issue.
    beast (4-May) : NFL really needs to fix their position labeling issue, but I don't think they care
    Zero2Cool (1-May) : Packers did not activate the fifth-year options for linebacker Quay Walker, with the goal of signing him to a contract extension.
    Zero2Cool (1-May) : Matthew Golden spoke with Randall Cobb before draft. Looked like chance encounter.
    packerfanoutwest (1-May) : from a head left turn?
    packerfanoutwest (1-May) : someone drunk?
    Zero2Cool (1-May) : Unlikely.
    dfosterf (30-Apr) : How long until Jeff Sperbeck's family sues John Elway ?
    Zero2Cool (30-Apr) : Packers are exercising the fifth-year option on DT Devonte Wyatt, locking in a guaranteed $12.9M for the 2026 season.
    beast (30-Apr) : Sounds like P Luke Elzinga has a rookie try out opportunity from the Titans
    dfosterf (30-Apr) : Luke Elzinga Punter Oklahoma stil unsigned. Green Bay has been mentioned as good fit
    beast (30-Apr) : The Packers re-signed three exclusive rights free agents WR Melton, P Whelan and RB Wilson.
    Zero2Cool (29-Apr) : February 5, 2002 (age 23) ok no. packers.com is wrong
    Zero2Cool (29-Apr) : Micah Robinson is only 19??
    Zero2Cool (29-Apr) : 6 first rounders on Packers defense now
    Zero2Cool (29-Apr) : LB Isaiah Simmons. Signed. Called it!!! Oh yeah!
    Martha Careful (29-Apr) : ty bboystyle...fat fingers
    bboystyle (29-Apr) : Tom*
    Martha Careful (28-Apr) : RIP Packer Safety Tim Brown
    beast (27-Apr) : Yeah, but also some of the wording suggestions Jax only pranked called the QB, not the others... and if he had an open spreadsheet & 3 calls
    beast (27-Apr) : Thank goodness he's not leaving the Turtle in the Red Tide
    Mucky Tundra (27-Apr) : Cowboys 1st round pick Tyler Booker will indeed be bringing his pet turtle to Dallas with him
    Mucky Tundra (27-Apr) : that contained all prospects info and contact
    Mucky Tundra (27-Apr) : beast, according the Falcons statement Jax came across it on an ipad. If I had to guess, probably an open spread sheet or something
    Zero2Cool (27-Apr) : Simmons put up an emoji with cheese.
    beast (27-Apr) : Not sure anyone is interested in Isaiah Simmons... Collin Oliver might of taken his potential slot
    beast (27-Apr) : I'm going with Jax Ulbrich is not telling the whole truth... he accidentally came across it? Why would a defensive coordinator have a QB #?
    Zero2Cool (27-Apr) : He's not that great, but final piece of the script.\
    Zero2Cool (27-Apr) : If we add Isaiah Simmons, book your Super Bowl tickets
    Mucky Tundra (27-Apr) : Colts 1st round TE Tyler Warren also got prank called, was that Jax Ulbrich as well?
    Zero2Cool (27-Apr) : Jax Ulbrich, Jeff Ulbrich’s son, released an apology for his role in the Shedeur Sanders prank call.
    Martha Careful (27-Apr) : apparently he did not participate in practice or play on the east west shrine game nor the NFL combine. The kid was a mediocre spoiled brat
    Mucky Tundra (27-Apr) : Yeah that one that was a super wounded duck that Sanders supporters are highlighting to prove a point
    Zero2Cool (27-Apr) : Shough is the guy who missed guys at combine isn't he?
    beast (27-Apr) : It's not official until I'm dead! I have a chance still! (Not really)
    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
    Recent Topics
    19h / Green Bay Packers Talk / wpr

    19h / Green Bay Packers Talk / wpr

    19h / Green Bay Packers Talk / wpr

    19h / Green Bay Packers Talk / wpr

    19h / Green Bay Packers Talk / wpr

    5-May / Green Bay Packers Talk / Zero2Cool

    5-May / Green Bay Packers Talk / beast

    5-May / Green Bay Packers Talk / beast

    4-May / Green Bay Packers Talk / Zero2Cool

    3-May / Packers Draft Threads / Martha Careful

    3-May / Green Bay Packers Talk / beast

    3-May / Green Bay Packers Talk / beast

    3-May / Green Bay Packers Talk / beast

    3-May / Green Bay Packers Talk / buckeyepackfan

    2-May / Green Bay Packers Talk / wpr

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