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
    Mucky Tundra (7h) : *to be able
    Mucky Tundra (7h) : and because it's not a dynasty league (which makes a lot more sense to be ability to trade picks)
    Mucky Tundra (7h) : Oh I know; I was just exploring and it blew my mind that you could trade picks because of the whole reordering thing
    Mucky Tundra (7h) : Zero, I think I preferred my offer: your 1st for my 15th rounder
    Zero2Cool (8h) : Keep in mind, we do a draft reorder once all members locked in
    Zero2Cool (8h) : You can have my 12th Rd for your 2nd round
    Mucky Tundra (9h) : Hey i didn't know we could trade picks in fantasy
    Mucky Tundra (3-Aug) : Update: Rock has tried a cheese curd, promises it's not his last
    Zero2Cool (3-Aug) : watch it!! lol
    Mucky Tundra (3-Aug) : you're right, we never did leave, the site just went down :P
    Mucky Tundra (3-Aug) : Rock claims to have never eaten a cheese curd
    Zero2Cool (3-Aug) : We did not leave.
    Mucky Tundra (3-Aug) : Family Night! WE ARE SO BACK!
    Mucky Tundra (2-Aug) : To this day, I'm still miffed about his 4 TD game against Dallas on Thanksgiving going to waste
    Martha Careful (2-Aug) : Congratulations Sterling Sharpe. He was terrific and I loved watching him play.
    beast (2-Aug) : I believe it's technically against the CBA rules, but Jerry just calls it a simple unofficial chat... and somehow gets away with it.
    beast (2-Aug) : Jerry Jones is infamous for ̶n̶e̶g̶o̶t̶i̶a̶t̶i̶n̶g̶ chatting with players one on one... and going around the agent.
    Mucky Tundra (1-Aug) : Oo just saw a blurb saying that Dallas negotiated directly with Parsons and not through his agent
    Mucky Tundra (1-Aug) : I assumed that both guys will get paid, just a matter of when or how we get there
    Zero2Cool (1-Aug) : McLaurin nor Micah going anywhere. They will get money
    Mucky Tundra (1-Aug) : the Synder years or do they take care of one of their own?
    Mucky Tundra (1-Aug) : Do the Commanders risk losing a top WR with an emerging QB just because he's turning 30 and potentially risk damaging the rebuild from
    Mucky Tundra (1-Aug) : Turns 30 this September, plays at a high level and Washington has some cap space I believe
    Mucky Tundra (1-Aug) : More interesting is Washington with Terry McLaurin
    Mucky Tundra (1-Aug) : I would imagine Dallas will resolve this issue with a truckload of money
    Zero2Cool (1-Aug) : Micah pulling a Myles with trade request
    beast (1-Aug) : Packers should make some cheese forks
    Mucky Tundra (31-Jul) : GRAB THE PITCHFORKS~
    Zero2Cool (31-Jul) : CUT HIM
    Mucky Tundra (31-Jul) : Socieltal collapse imminent
    Mucky Tundra (31-Jul) : The West has fallen
    Mucky Tundra (31-Jul) : After starting off camp with 25 straight made field goals, Brandon McManus has missed one
    Zero2Cool (31-Jul) : But it should be stable
    Zero2Cool (31-Jul) : It's probably gonna be slower.
    Zero2Cool (31-Jul) : We're gonna just full go on to the new host.
    Zero2Cool (31-Jul) : What crap. Site issues galore
    Zero2Cool (30-Jul) : if PH dies, there is packerpeople com available
    Zero2Cool (30-Jul) : database is on new host, eventually website will follow
    Mucky Tundra (30-Jul) : Zero, regarding Ewers, you are correct.
    Zero2Cool (30-Jul) : Sadly, this might be our life for awhile. I could put it on another host, but seems it was slower, although more stable
    beast (30-Jul) : How long will it be down?
    beast (30-Jul) : RIP site 😭
    Zero2Cool (30-Jul) : Site will die, I have to restart it.
    Zero2Cool (30-Jul) : Quinn stinks. Lot of underthrows. (my guess)
    beast (30-Jul) : How did Quinn Ewers effect where Golden was drafted?
    dfosterf (30-Jul) : All I've experienced was late at night or early morning. I just figured you were doing something in the background
    Zero2Cool (30-Jul) : Site sure seems to be down more than up
    dfosterf (29-Jul) : 50 cent hookers? I'm moving to Green Bay. I thought it was just real estate that was more affordable there. 😂
    Zero2Cool (29-Jul) : Sure seems site going down more than 50¢ hooker
    Mucky Tundra (27-Jul) : Golden with two TDs in red zone drills today
    Please sign in to use Fan Shout
    2025 Packers Schedule
    Sunday, Sep 7 @ 3:25 PM
    LIONS
    Thursday, Sep 11 @ 7:15 PM
    COMMANDERS
    Sunday, Sep 21 @ 12:00 PM
    Browns
    Sunday, Sep 28 @ 7:20 PM
    Cowboys
    Sunday, Oct 12 @ 3:25 PM
    BENGALS
    Sunday, Oct 19 @ 3:25 PM
    Cardinals
    Sunday, Oct 26 @ 7:20 PM
    Steelers
    Sunday, Nov 2 @ 12:00 PM
    PANTHERS
    Monday, Nov 10 @ 7:15 PM
    EAGLES
    Sunday, Nov 16 @ 12:00 PM
    Giants
    Sunday, Nov 23 @ 12:00 PM
    VIKINGS
    Thursday, Nov 27 @ 12:00 PM
    Lions
    Sunday, Dec 7 @ 12:00 PM
    BEARS
    Sunday, Dec 14 @ 3:25 PM
    Broncos
    Friday, Dec 19 @ 11:00 PM
    Bears
    Friday, Dec 26 @ 11:00 PM
    RAVENS
    Saturday, Jan 3 @ 11:00 PM
    Vikings
    Recent Topics
    7h / Fantasy Sports Talk / dhazer

    16h / Green Bay Packers Talk / Mucky Tundra

    18h / Green Bay Packers Talk / beast

    3-Aug / Feedback, Suggestions and Issues / Zero2Cool

    2-Aug / Green Bay Packers Talk / Mucky Tundra

    2-Aug / Green Bay Packers Talk / wpr

    31-Jul / Green Bay Packers Talk / wpr

    28-Jul / Random Babble / Zero2Cool

    28-Jul / Green Bay Packers Talk / Mucky Tundra

    28-Jul / Green Bay Packers Talk / Mucky Tundra

    27-Jul / Green Bay Packers Talk / Mucky Tundra

    27-Jul / Green Bay Packers Talk / beast

    25-Jul / Around The NFL / Mucky Tundra

    25-Jul / Green Bay Packers Talk / Mucky Tundra

    25-Jul / Green Bay Packers Talk / TheKanataThrilla

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