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 (2-Apr) : WR who said he'd break Xavier Worthy 40 time...and ran slower than you
    Mucky Tundra (2-Apr) : Who?
    Zero2Cool (2-Apr) : Texas’ WR Isaiah Bond is scheduled to visit the Bills, Browns, Chiefs, Falcons, Packers and Titans starting next week.
    Zero2Cool (2-Apr) : Spotting ball isn't changing, only measuring distance is, Which wasn't the issue.
    Zero2Cool (2-Apr) : The spotting of the ball IS the issue. Not the chain gang.
    Mucky Tundra (2-Apr) : Will there be a tracker on the ball or something?
    Zero2Cool (1-Apr) : uh oh
    Martha Careful (1-Apr) : Too bad camera's can't spot the ball as well.
    Mucky Tundra (1-Apr) : So will the chain gang be gone completely or will they still be around as a backup or whatever?
    Zero2Cool (1-Apr) : The method for measuring first downs in the NFL will switch from chain gangs to camera-based technology in 2025, the league announced.
    Martha Careful (1-Apr) : A big step in the right direction. Just put in the college system is very very good.
    Zero2Cool (1-Apr) : NFL has passed a rule that allows both teams to possess the ball in OT during the regular season
    Zero2Cool (1-Apr) : Touchbacks on kickoffs will now bring the ball to the 35-yard line.
    beast (31-Mar) : It might of gotten more popular recently, but braiding hair (even men) in certain cultures goes back for centuries.
    Martha Careful (30-Mar) : Is men braiding their hair a new style thing? Watching the NCAA men's tournament many players have done
    Zero2Cool (29-Mar) : Ha. Well, it'd be nice for folks to reset their own password. Via validated email 😏
    beast (29-Mar) : Monopoly was supposed to be an educational game, that show how evil capitalism was and how we should avoid it
    beast (29-Mar) : Lol, I was thinking username would be better, as then I wouldn't have to keep an email up to date lol 😂
    beast (29-Mar) : Zero2Cool (25-Mar) : I was thinking email because I think it'll make folks keep it up todate lol
    wpr (29-Mar) : sure is
    Zero2Cool (29-Mar) : Monopoly is a rip off of The Landlord's Game
    wpr (27-Mar) : 28 days until the draft
    earthquake (27-Mar) : Which seemed strange to my 9 year old self, that you could be a fan for a team other than the one you play for
    earthquake (27-Mar) : Nothing eventful happened, other than it being clear that he was a bengals fan
    earthquake (27-Mar) : And we went and hung out with him one afternoon, I must have been 9 or so
    earthquake (27-Mar) : That’s wild, when I was a kid my friend lived in the same apartment complex in De Pere
    Mucky Tundra (27-Mar) : Only career highspot was a 200 yard rushing game while playing for the Cardinals
    Mucky Tundra (27-Mar) : He is a former Packer. Drafted out of Northern Illinois. Didn't do much in GB.
    dfosterf (26-Mar) : Despicable
    Zero2Cool (26-Mar) : Former NFL. I think Packers too
    Zero2Cool (26-Mar) : NFL RB Leshon Johnson has been charged in a massive dog fighting operation, with the FBI seizing over 190 Pit Bulls
    Mucky Tundra (26-Mar) : Some real irony of a QB as short as Wilson playing for the Giants
    Mucky Tundra (26-Mar) : Giants country, let's be the tall beings of lore!
    Mucky Tundra (26-Mar) : Russell Wilson signs with the Giants.
    Zero2Cool (25-Mar) : I was thinking email because I think it'll make folks keep it up todate lol
    wpr (25-Mar) : I don't think there is a significant difference. I use a user name for many. Others email.
    Martha Careful (25-Mar) : email
    Zero2Cool (25-Mar) : would it be better to use EMAIL or USERNAME to log into a site?
    wpr (25-Mar) : Thanks Zero
    Zero2Cool (24-Mar) : New forum has the ability to Thank a post now.
    beast (24-Mar) : And the only time they have won the Championship in an even year, was the first time they did, in 2006.
    beast (24-Mar) : Since 2007, there have been 10 odd numbered years, Wisconsin Women have won the Championship in 7 of those 10 odd numbered years.
    buckeyepackfan (24-Mar) : Congratulations Lady Badger Hockey Team. NATIONAL CHAMPIONS!!
    Zero2Cool (23-Mar) : I don't think it's completed yet. it was just announced last month, right?
    dhazer (23-Mar) : did netflix ever release the Packers documentary
    Zero2Cool (21-Mar) : And it is glorious!
    beast (21-Mar) : Unsigned FA QB Rodgers is supposedly in the Steelers building
    Martha Careful (19-Mar) : But I don't own a car! So can I still use it in my apartment?
    Zero2Cool (19-Mar) : btw, new site auto updates
    Zero2Cool (19-Mar) : Woohoo!
    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
    9h / Feedback, Suggestions and Issues / Zero2Cool

    2-Apr / Green Bay Packers Talk / Zero2Cool

    2-Apr / Green Bay Packers Talk / bboystyle

    1-Apr / Green Bay Packers Talk / Mucky Tundra

    1-Apr / Green Bay Packers Talk / wpr

    31-Mar / Green Bay Packers Talk / Zero2Cool

    30-Mar / Green Bay Packers Talk / Zero2Cool

    29-Mar / Random Babble / wpr

    28-Mar / Feedback, Suggestions and Issues / dfosterf

    28-Mar / Random Babble / Martha Careful

    26-Mar / Random Babble / Mucky Tundra

    25-Mar / Random Babble / Martha Careful

    24-Mar / Random Babble / packerfanoutwest

    24-Mar / Random Babble / Zero2Cool

    21-Mar / Green Bay Packers Talk / Zero2Cool

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