Green Bay Packers Forum

Welcome to your Green Bay Packers Online Community!

Since 2006, PackersHome has been providing a unique experience for fans.
Your participation is greatly anticipated!
Login or Register.
4 Pages123>»
Options
Go to last post Go to first unread
Offline Zero2Cool  
#1 Posted : Thursday, September 13, 2012 10:22:47 AM(UTC)
Rank: Premier Member

Yahoo! NCAA March Madness - Gold: 2015Yahoo! Fantasy Football - Gold: 2009FleaFlicker Fantasy Football - Silver: 2010Yahoo! NCAA March Madness - Silver: 2011FleaFlicker Fantasy Football - Bronze: 2016ESPN NCAA March Madness - Bronze: 2010Yahoo! NCAA March Madness - Bronze: 2013

United States
Joined: 10/13/2006(UTC)
Location: Green Bay, WI
Applause Given: 2,503
Applause Received: 4,056
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.
  • 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



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.
Offline Pack93z  
#2 Posted : Thursday, September 13, 2012 11:20:01 AM(UTC)
Rank: Select Member

PackersHome NFL Pick'em - Bronze: 2012

United States
Joined: 3/16/2007(UTC)
Location: North Central Wisconsin
Applause Given: 437
Applause Received: 1,237
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.
Offline Zero2Cool  
#3 Posted : Thursday, September 13, 2012 11:30:26 AM(UTC)
Rank: Premier Member

Yahoo! NCAA March Madness - Gold: 2015Yahoo! Fantasy Football - Gold: 2009FleaFlicker Fantasy Football - Silver: 2010Yahoo! NCAA March Madness - Silver: 2011FleaFlicker Fantasy Football - Bronze: 2016ESPN NCAA March Madness - Bronze: 2010Yahoo! NCAA March Madness - Bronze: 2013

United States
Joined: 10/13/2006(UTC)
Location: Green Bay, WI
Applause Given: 2,503
Applause Received: 4,056
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

Offline Pack93z  
#4 Posted : Thursday, September 13, 2012 11:33:52 AM(UTC)
Rank: Select Member

PackersHome NFL Pick'em - Bronze: 2012

United States
Joined: 3/16/2007(UTC)
Location: North Central Wisconsin
Applause Given: 437
Applause Received: 1,237
Zero2Cool said: Go to Quoted Post
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



Yep. Cannot make it easy. {Evil Snicker}

Offline Rockmolder  
#5 Posted : Thursday, September 13, 2012 11:38:26 AM(UTC)
Rank: Veteran Member

FleaFlicker Fantasy Football - Bronze: 2010

Netherlands
Joined: 9/14/2008(UTC)
Applause Given: 245
Applause Received: 384
Top 10 posters from The Netherlands.
thanks Post received 1 applause.
wpr on 9/15/2012(UTC)
Offline Zero2Cool  
#6 Posted : Thursday, September 13, 2012 11:46:57 AM(UTC)
Rank: Premier Member

Yahoo! NCAA March Madness - Gold: 2015Yahoo! Fantasy Football - Gold: 2009FleaFlicker Fantasy Football - Silver: 2010Yahoo! NCAA March Madness - Silver: 2011FleaFlicker Fantasy Football - Bronze: 2016ESPN NCAA March Madness - Bronze: 2010Yahoo! NCAA March Madness - Bronze: 2013

United States
Joined: 10/13/2006(UTC)
Location: Green Bay, WI
Applause Given: 2,503
Applause Received: 4,056
Rockmolder said: Go to Quoted Post
Top 10 posters from The Netherlands.


  1. Rockmolder
  2. Rockmolder
  3. Rockmolder
  4. Rockmolder
  5. Rockmolder
  6. Rockmolder
  7. Rockmolder
  8. Rockmolder
  9. Rockmolder
  10. Rockmolder
Offline Pack93z  
#7 Posted : Thursday, September 13, 2012 11:49:15 AM(UTC)
Rank: Select Member

PackersHome NFL Pick'em - Bronze: 2012

United States
Joined: 3/16/2007(UTC)
Location: North Central Wisconsin
Applause Given: 437
Applause Received: 1,237
Zero2Cool said: Go to Quoted Post
  1. Rockmolder
  2. Rockmolder
  3. Rockmolder
  4. Rockmolder
  5. Rockmolder
  6. Rockmolder
  7. Rockmolder
  8. Rockmolder
  9. Rockmolder
  10. Rockmolder


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. ;)
Offline Zero2Cool  
#8 Posted : Thursday, September 13, 2012 12:14:38 PM(UTC)
Rank: Premier Member

Yahoo! NCAA March Madness - Gold: 2015Yahoo! Fantasy Football - Gold: 2009FleaFlicker Fantasy Football - Silver: 2010Yahoo! NCAA March Madness - Silver: 2011FleaFlicker Fantasy Football - Bronze: 2016ESPN NCAA March Madness - Bronze: 2010Yahoo! NCAA March Madness - Bronze: 2013

United States
Joined: 10/13/2006(UTC)
Location: Green Bay, WI
Applause Given: 2,503
Applause Received: 4,056
Haha, holy balls! The first two buttons worked perfect right out of the gate! God I love programming!!
Offline Wade  
#9 Posted : Thursday, September 13, 2012 12:28:09 PM(UTC)
Rank: Veteran Member

Joined: 8/1/2009(UTC)
Location: nowhere of importance
Applause Given: 891
Applause Received: 923
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)
Offline Pack93z  
#10 Posted : Friday, September 14, 2012 9:28:29 AM(UTC)
Rank: Select Member

PackersHome NFL Pick'em - Bronze: 2012

United States
Joined: 3/16/2007(UTC)
Location: North Central Wisconsin
Applause Given: 437
Applause Received: 1,237
Apparently I need to become more flippant in nature with doling out applause. Either that or I am a freaking scrooge. :-k
Pack93z attached the following image(s):
GivingApplause.JPG (78kb) downloaded 48 time(s).

You cannot view/download attachments. Try to login or register.
thanks Post received 1 applause.
wpr on 9/15/2012(UTC)
Rss Feed 
Users browsing this topic
Guest
4 Pages123>»
Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Notification

Icon
Error


Fan Shout
uffda udfa (6m) : MM: We ran into a buzzsaw today. LOL. U came with no tools at all.
hardrocker950 (49m) : They showed up and played, we crawled in and died...
mojaveson (56m) : Kudos to the Falcons. I hope they win the Super Bowl.
uffda udfa (1h) : All credit to ATL. Not a word about needing to get better.
Zero2Cool (1h) : Ran out of talent, something we didn't have a plethora of on defense (my opinion)
uffda udfa (1h) : MM: Ran out of gas but proud of his guys.
Please sign in to use Fan Shout

2016 Packers Schedule
Sunday, Sep 11 @ 12:00 PM
at Jaguars
Sunday, Sep 18 @ 7:30 PM
at Vikings
Sunday, Sep 25 @ 12:00 PM
LIONS
Sunday, Oct 2 @ 12:00 AM
BYE
Sunday, Oct 9 @ 7:30 PM
GIANTS
Sunday, Oct 16 @ 3:25 PM
COWBOYS
Thursday, Oct 20 @ 7:25 PM
BEARS
Sunday, Oct 30 @ 3:25 PM
at Falcons
Sunday, Nov 6 @ 3:25 PM
COLTS
Sunday, Nov 13 @ 12:00 PM
at Titans
Sunday, Nov 20 @ 7:30 PM
at Redskins
Monday, Nov 28 @ 7:30 PM
at Eagles
Sunday, Dec 4 @ 12:00 PM
TEXANS
Sunday, Dec 11 @ 3:25 PM
SEAHAWKS
Sunday, Dec 18 @ 12:00 PM
at Bears
Saturday, Dec 24 @ 12:00 PM
VIKINGS
Sunday, Jan 1 @ 7:30 PM
at Lions

Think About It
Think About It

Recent Topics
1m / Green Bay Packers Talk / dhazer

8m / Green Bay Packers Talk / wpr

8m / Green Bay Packers Talk / nerdmann

14m / Announcements / wpr

27m / Green Bay Packers Talk / uffda udfa

38m / Green Bay Packers Talk / Nonstopdrivel

45m / Green Bay Packers Talk / mojaveson

59m / Green Bay Packers Talk / mojaveson

5h / Green Bay Packers Talk / uffda udfa

6h / Green Bay Packers Talk / mojaveson

7h / Green Bay Packers Talk / luigis

7h / Around The NFL / mojaveson

7h / Green Bay Packers Talk / mojaveson

7h / Green Bay Packers Talk / mojaveson

7h / Green Bay Packers Talk / mojaveson


Packers Headlines