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.
Options
View
Go to last post Go to first unread
Offline Zero2Cool  
#1 Posted : Friday, October 18, 2013 7:29:06 AM(UTC)
Zero2Cool

Rank: Legend

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

United States
Joined: 10/13/2006(UTC)
Location: Green Bay, WI

Applause Given: 1,867
Applause Received: 2,039

Some have asked to see a percentage. This is not feasible to have a sort by this because someone could easily pick the 'locks' and get a high percentage. But for fun, I threw together a query and got something to show for kicks.


Code:
Name    Picks    Correct    
OSOGRANDE    16    12    75.00%
OlHoss1884    90    61    67.78%
dhazer    93    63    67.74%
Maverick    93    61    65.59%
gbguy20    63    41    65.08%
Wade    62    40    64.52%
steveishere    64    41    64.06%
buckeyepackfan    93    59    63.44%
wpr    93    59    63.44%
Zero2Cool    93    59    63.44%
Tezzy    90    57    63.33%
Gaycandybacon    32    20    62.50%
gbpfan    16    10    62.50%
Pack93z    93    58    62.37%
yooperfan    92    57    61.96%
macbob    76    47    61.84%
rlyon    44    27    61.36%
porky88    75    46    61.33%
The_Green_Ninja    15    9    60.00%
hardrocker950    93    55    59.14%
GoPack1984    93    54    58.06%
GermanGilbert    75    43    57.33%
beast    93    53    56.99%
SINCITYCHEEZE    93    50    53.76%
DoddPower    16    8    50.00%

Edited by user Friday, October 18, 2013 9:15:59 AM(UTC)  | Reason: Not specified

UserPostedImage
Sponsor
Online wpr  
#2 Posted : Friday, October 18, 2013 7:59:47 AM(UTC)
wpr

Rank: Hall of Famer

PackersHome NFL Pick'em - Gold: 2012PackersHome NFL Pick'em - Gold: 2013FleaFlicker Fantasy Football - Bronze: 2013

United States
Joined: 8/8/2008(UTC)

Applause Given: 2,835
Applause Received: 1,368

boy do I stink when it comes to picking. I will stay out of Vegas.
"You don't hurt 'em if you don't hit 'em." Chesty Puller



UserPostedImage

Offline Pack93z  
#3 Posted : Friday, October 18, 2013 8:04:56 AM(UTC)
Pack93z

Rank: Hall of Famer

PackersHome NFL Pick'em - Bronze: 2012

United States
Joined: 3/16/2007(UTC)
Location: North Central Wisconsin

Applause Given: 381
Applause Received: 1,027

Might want to check that query... Wayne has made over 200 picks? Big Grin
I think when there's enough will and aggression, there's no shortage of talent either.

UserPostedImage
Offline Zero2Cool  
#4 Posted : Friday, October 18, 2013 8:41:24 AM(UTC)
Zero2Cool

Rank: Legend

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

United States
Joined: 10/13/2006(UTC)
Location: Green Bay, WI

Applause Given: 1,867
Applause Received: 2,039

Originally Posted by: Pack93z Go to Quoted Post
Might want to check that query... Wayne has made over 200 picks? Big Grin


When you make 214 picks on September 10th, 2013, that'll be the case. The query takes all picks made and doesn't use a parameter for 'up to' the current week.
UserPostedImage
Offline Pack93z  
#5 Posted : Friday, October 18, 2013 8:54:35 AM(UTC)
Pack93z

Rank: Hall of Famer

PackersHome NFL Pick'em - Bronze: 2012

United States
Joined: 3/16/2007(UTC)
Location: North Central Wisconsin

Applause Given: 381
Applause Received: 1,027

Originally Posted by: Zero2Cool Go to Quoted Post
When you make 214 picks on September 10th, 2013, that'll be the case. The query takes all picks made and doesn't use a parameter for 'up to' the current week.


Ahh... so he has filled in his picks for the year already forward.. makes sense.. but it also highlights a problem as well.. the picks for this week are going to be misses as there is no result yet.

Can it be queried if the winning/correct team is not null?
I think when there's enough will and aggression, there's no shortage of talent either.

UserPostedImage
Offline Zero2Cool  
#6 Posted : Friday, October 18, 2013 9:05:59 AM(UTC)
Zero2Cool

Rank: Legend

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

United States
Joined: 10/13/2006(UTC)
Location: Green Bay, WI

Applause Given: 1,867
Applause Received: 2,039

Originally Posted by: Pack93z Go to Quoted Post
Ahh... so he has filled in his picks for the year already forward.. makes sense.. but it also highlights a problem as well.. the picks for this week are going to be misses as there is no result yet.

Can it be queried if the winning/correct team is not null?


Yes sir. It's more so just a glimpse that it can be done. I had a stumbling block on a work project and my mind went awry. :)

The structure of the database tables ... has room for improvement, but still offers a lot of flexibility to do as you suggest.

Easiest addition would be to add a condition that

AND GameDateTime < GetDate()

I think that would ensure the game has to be played or ... my mind just went blank. Lost my thought. I'll come back later if it comes back.
UserPostedImage
Offline Pack93z  
#7 Posted : Friday, October 18, 2013 9:13:26 AM(UTC)
Pack93z

Rank: Hall of Famer

PackersHome NFL Pick'em - Bronze: 2012

United States
Joined: 3/16/2007(UTC)
Location: North Central Wisconsin

Applause Given: 381
Applause Received: 1,027

LOL.. know the blank mind feeling.. people at times walk in here and I am probably zombie like.. lost in thought.. code or something.. lol.
I think when there's enough will and aggression, there's no shortage of talent either.

UserPostedImage
Online wpr  
#8 Posted : Friday, October 18, 2013 11:24:33 AM(UTC)
wpr

Rank: Hall of Famer

PackersHome NFL Pick'em - Gold: 2012PackersHome NFL Pick'em - Gold: 2013FleaFlicker Fantasy Football - Bronze: 2013

United States
Joined: 8/8/2008(UTC)

Applause Given: 2,835
Applause Received: 1,368

Originally Posted by: Zero2Cool Go to Quoted Post
When you make 214 picks on September 10th, 2013, that'll be the case. The query takes all picks made and doesn't use a parameter for 'up to' the current week.


swell now everyone will want to pick early.

BTW- does it change the data above when I come back and revise my picks later? (That is not counted as selecting twice?)

"You don't hurt 'em if you don't hit 'em." Chesty Puller



UserPostedImage

Offline Zero2Cool  
#9 Posted : Friday, October 18, 2013 11:29:24 AM(UTC)
Zero2Cool

Rank: Legend

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

United States
Joined: 10/13/2006(UTC)
Location: Green Bay, WI

Applause Given: 1,867
Applause Received: 2,039

Originally Posted by: wpr Go to Quoted Post
swell now everyone will want to pick early.

BTW- does it change the data above when I come back and revise my picks later? (That is not counted as selecting twice?)



Yes.
UserPostedImage
Online wpr  
#10 Posted : Friday, October 18, 2013 12:51:54 PM(UTC)
wpr

Rank: Hall of Famer

PackersHome NFL Pick'em - Gold: 2012PackersHome NFL Pick'em - Gold: 2013FleaFlicker Fantasy Football - Bronze: 2013

United States
Joined: 8/8/2008(UTC)

Applause Given: 2,835
Applause Received: 1,368

Originally Posted by: Zero2Cool Go to Quoted Post
Yes.


Since I have voted early, over the course of the season I have changed my vote on a few games each week.
"You don't hurt 'em if you don't hit 'em." Chesty Puller



UserPostedImage

Offline Zero2Cool  
#11 Posted : Friday, October 18, 2013 1:04:24 PM(UTC)
Zero2Cool

Rank: Legend

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

United States
Joined: 10/13/2006(UTC)
Location: Green Bay, WI

Applause Given: 1,867
Applause Received: 2,039

the timestamp is inserted on first selection. each time you change your pick, it updates the timestamp. the timestamp is nothing more than a way for big brother to spy to ensure one did not change their pick AFTER the game started or was concluded. there are no queries against it since all loopholes have been extinguished.
UserPostedImage
Offline gbguy20  
#12 Posted : Sunday, October 27, 2013 9:52:14 AM(UTC)
gbguy20

Rank: 1st Round Draft Pick

Joined: 8/28/2009(UTC)

Applause Given: 203
Applause Received: 284

How did i miss this until now?!

call me Dan
Rss Feed 
Users browsing this topic
Guest
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

Recent Topics
19m / Green Bay Packers Talk / nerdmann

20m / Green Bay Packers Talk / nerdmann

1h / Green Bay Packers Talk / Zero2Cool

1h / Green Bay Packers Talk / luigis

4h / Green Bay Packers Talk / Zero2Cool

6h / Green Bay Packers Talk / Zero2Cool

11h / Green Bay Packers Talk / texaspackerbacker

17h / Green Bay Packers Talk / texaspackerbacker

17h / Green Bay Packers Talk / sschind

17h / Green Bay Packers Talk / beast

18h / Green Bay Packers Talk / Dexter_Sinister

21h / Green Bay Packers Talk / wpr

21h / Green Bay Packers Talk / wpr

22h / Around The NFL / Cheesey

26-Aug / Green Bay Packers Talk / beast


Tweeter

Copyright © 2006-2014 PackersHome.com™. All Rights Reserved.