Zero2Cool
11 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
    11 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
    11 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
    11 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
    11 years ago
    Top 10 posters from The Netherlands.
    Zero2Cool
    11 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
    11 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
    11 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
    11 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
    11 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
    dfosterf (6m) : Maybe
    Mucky Tundra (20m) : Yes
    Zero2Cool (1h) : No.
    Mucky Tundra (3h) : End of a Degu-era
    dhazer (4h) : Steelers sign Patterson because of new kickoff rule interesting
    Zero2Cool (7h) : Former #Packers TE Josiah Deguara is signing a 1-year deal with the Jaguars, per source.
    Zero2Cool (8h) : They do not do it for "content sake".
    dfosterf (18h) : For the record, I enjoy Beast and Mucky drafts
    Zero2Cool (27-Mar) : Haha
    Mucky Tundra (27-Mar) : No time for talking! Back to work beast!
    beast (27-Mar) : You saw only 4,201 of my mocks? 🥺 I think that means you missed more than half of them 😢
    dfosterf (27-Mar) : Does anyone know what Lambeau field improvements got put on hold? My guess would be for the 2025 draft
    Zero2Cool (27-Mar) : It's like listen, you made 4,201 mocks, no shit.
    Zero2Cool (27-Mar) : Cuz during the draft "I had them mocked there!" as if it's amazing.
    Zero2Cool (27-Mar) : They're fun to do once in awhile. It's people who think they are "content" that annoy me.
    dfosterf (27-Mar) : Against tbd
    dfosterf (27-Mar) : Answer to your question is yes, it's a Thursday, will be the Chiefs aga
    dfosterf (27-Mar) : Luckily for all concerned, I don't post them. I did one, but that was like 25 mocks ago
    Zero2Cool (27-Mar) : NFL 2024 gonna start Sept 5th isn't it???
    Zero2Cool (27-Mar) : Ugh... kids these days!
    dfosterf (27-Mar) : I'm gonna go do some more mock draft hell instead 🤪
    Zero2Cool (27-Mar) : Did we do one of those prediction threads yet for 2024 season?
    dfosterf (27-Mar) : In my city, they are playing the nimby game, in order to keep some railroad tracks vs. 2 professional sports teams and a concert venue.
    dfosterf (27-Mar) : And/Or a city council, of which I haven't seen a good one in a very long time
    dfosterf (27-Mar) : That sounds like a Mayor, not a city.
    buckeyepackfan (26-Mar) : Packers halt scheduled 80mil upgrade of stadium until lease agreement talks are restarted
    Zero2Cool (26-Mar) : City of Green Bay puts Packers' Lambeau Field lease talks on hold
    buckeyepackfan (26-Mar) : Packers 1 of 3 teams to vote no on new kickoff rule.
    Zero2Cool (26-Mar) : Packers sign another Kicker
    dfosterf (26-Mar) : Lengthy explanation at PFF if you click the link
    dfosterf (26-Mar) : Kickoff rules officially changed.ngthy explan
    Zero2Cool (26-Mar) : lol
    Cheesey (26-Mar) : 2009? No thanks! One open heart surgery is enough!
    dfosterf (26-Mar) : Good for you!
    Zero2Cool (26-Mar) : Yes. That's the one.
    dfosterf (26-Mar) : Is that "Lady Dugan" per chance?
    dfosterf (26-Mar) : Crystal?
    dfosterf (26-Mar) : Please refresh my memory
    Zero2Cool (26-Mar) : Alan posts. Crystal back in my life. It's 2009 all over again! Lol
    Mucky Tundra (26-Mar) : BAH GAWD! THAT'S CHEESEYS MUSIC!
    Zero2Cool (25-Mar) : Gutekunst said early stages of Jordan Love contract being discussed.
    Zero2Cool (25-Mar) : Shouldn't be penalized cuz official screwed up
    Zero2Cool (25-Mar) : Yeah, challenge until you are incorrect twice.
    Zero2Cool (25-Mar) : Fining them is the goal, per the people who made the rule anyway.
    dfosterf (25-Mar) : Still waiting on the kickoff rule changes. Did hear yesterday that the touchback proposal will now be the 30 yard line, not the 35
    dfosterf (25-Mar) : Probably speed of game issues with your proposal
    dfosterf (25-Mar) : Hopefully the refs don't get in the habit of throwing flags on this
    beast (25-Mar) : I think when it comes to Challenges should get two strikes, so unlimited challenges as long as they keep winning them, but 2 wrong then done
    dfosterf (25-Mar) : Still subject to the fines etc
    dfosterf (25-Mar) : Yes, I should have been more specific. Also, they are now saying it would be a 15 yard penalty. That makes more sense .
    Please sign in to use Fan Shout
    2023 Packers Schedule
    Sunday, Sep 10 @ 3:25 PM
    Bears
    Sunday, Sep 17 @ 12:00 PM
    Falcons
    Sunday, Sep 24 @ 12:00 PM
    SAINTS
    Thursday, Sep 28 @ 7:15 PM
    LIONS
    Monday, Oct 9 @ 7:15 PM
    Raiders
    Sunday, Oct 22 @ 3:25 PM
    Broncos
    Sunday, Oct 29 @ 12:00 PM
    VIKINGS
    Sunday, Nov 5 @ 12:00 PM
    RAMS
    Sunday, Nov 12 @ 12:00 PM
    Steelers
    Sunday, Nov 19 @ 12:00 PM
    CHARGERS
    Thursday, Nov 23 @ 11:30 AM
    Lions
    Sunday, Dec 3 @ 7:20 PM
    CHIEFS
    Monday, Dec 11 @ 7:15 PM
    Giants
    Sunday, Dec 17 @ 12:00 PM
    BUCCANEERS
    Sunday, Dec 24 @ 12:00 PM
    Panthers
    Sunday, Dec 31 @ 7:20 PM
    Vikings
    Sunday, Jan 7 @ 3:25 PM
    BEARS
    Sunday, Jan 14 @ 3:30 PM
    Cowboys
    Saturday, Jan 20 @ 7:15 PM
    49ers
    Recent Topics
    9m / Green Bay Packers Talk / buckeyepackfan

    18h / Green Bay Packers Talk / dfosterf

    18h / Green Bay Packers Talk / bboystyle

    27-Mar / Green Bay Packers Talk / Mucky Tundra

    27-Mar / Random Babble / Zero2Cool

    27-Mar / Green Bay Packers Talk / beast

    26-Mar / Green Bay Packers Talk / beast

    26-Mar / Green Bay Packers Talk / beast

    26-Mar / Green Bay Packers Talk / bboystyle

    25-Mar / Green Bay Packers Talk / Zero2Cool

    25-Mar / Green Bay Packers Talk / Zero2Cool

    24-Mar / Around The NFL / dhazer

    24-Mar / Green Bay Packers Talk / beast

    24-Mar / Green Bay Packers Talk / beast

    22-Mar / Green Bay Packers Talk / beast

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