Discussion Board
Welcome Guest! You can login or register. Login or Register.

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

wpr  
#2 Posted : Friday, October 18, 2013 7:59:47 AM(UTC)
boy do I stink when it comes to picking. I will stay out of Vegas.
Pack93z  
#3 Posted : Friday, October 18, 2013 8:04:56 AM(UTC)
Might want to check that query... Wayne has made over 200 picks? [grin1]
Zero2Cool  
#4 Posted : Friday, October 18, 2013 8:41:24 AM(UTC)
Pack93z said: Go to Quoted Post
Might want to check that query... Wayne has made over 200 picks? [grin1]


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.
Pack93z  
#5 Posted : Friday, October 18, 2013 8:54:35 AM(UTC)
Zero2Cool said: 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?
Zero2Cool  
#6 Posted : Friday, October 18, 2013 9:05:59 AM(UTC)
Pack93z said: 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.
Pack93z  
#7 Posted : Friday, October 18, 2013 9:13:26 AM(UTC)
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.
wpr  
#8 Posted : Friday, October 18, 2013 11:24:33 AM(UTC)
Zero2Cool said: 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?)

Zero2Cool  
#9 Posted : Friday, October 18, 2013 11:29:24 AM(UTC)
wpr said: 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.
wpr  
#10 Posted : Friday, October 18, 2013 12:51:54 PM(UTC)
Zero2Cool said: 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.
Zero2Cool  
#11 Posted : Friday, October 18, 2013 1:04:24 PM(UTC)
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.
gbguy20  
#12 Posted : Sunday, October 27, 2013 9:52:14 AM(UTC)
How did i miss this until now?!

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

Fan Shout
beast (2h) : Darn, and I was already worried about Spriggs possibly vs Peppers
Zero2Cool (3h) : Jason Spriggs added to the injury report
Zero2Cool (3h) : whoa
beast (4h) : Packers are the only team to have less only 1 top 20 draft pick in the last decade... all other teams had more.
Zero2Cool (8h) : McCarthy's last two conferences ... much more jovial than last two months, huge difference.
Zero2Cool (8h) : If you picked Home for every NFL game, you'd have 115 correct picks. 55% success
Zero2Cool (10h) : Cincinnati Bengals co-founder Pete Brown dies
Zero2Cool (13-Dec) : Rodgers says he doesn't expect to adjust way he plays: "I wouldn’t be playing if I didn’t feel confident playing the way that I played my en
Zero2Cool (13-Dec) : Panthers Trai Turner enters concussion protocol
Zero2Cool (13-Dec) : Great stat from Mike Zimmer just now at his presser. No team has beaten three above .500 teams on the road in a row since 1967.
Zero2Cool (13-Dec) : Brett Hundley or Blake Bortles if you're the Jaguars?
Zero2Cool (13-Dec) : @ESPNStatsInfo Last season, Aaron Rodgers threw 13 TD and 0 Int while going 5-0 in Dec./Jan. regular season games
FLORIDA PACKER88 (13-Dec) : 12 12 12 12 12 12 12 12
buckeyepackfan (13-Dec) : THAT BAAAAAAAAD MAN IS BACK!!!!!
cheeseheads123 (13-Dec) : 12 is back baby lets go!!!
Zero2Cool (12-Dec) : WR Davante Adams nominated for Clutch Performer of the Week
Zero2Cool (11-Dec) : lol coach with jokes MM: "If i don't know tomorrow, they'll be putting Pat McKenzie on IR."
Zero2Cool (11-Dec) : Rod of Airs here to fook you up!
Zero2Cool (11-Dec) : Packers gonna play coy until Saturday night and go SURPRISE BITCHES
Zero2Cool (11-Dec) : Mike McCarthy on Rodgers timetable: "This is in the hands of the experts. ... Let's just wait until the experts make their decision."
Zero2Cool (11-Dec) : You can freaking localize ads too to region. This is NOT hard. Lazy asses.
Zero2Cool (11-Dec) : I think so too, but it's time they get with it. You can have ads in streaming too.
Nonstopdrivel (11-Dec) : You've been able to stream postseason games for a few years now, I think.
Zero2Cool (11-Dec) : last 4 games played, Packers have worst pass efficency, Browns 2nd worst
Zero2Cool (11-Dec) : On @oath @YahooSports and @NFL Apps
Zero2Cool (11-Dec) : Good news for NFL fans: starting with this season’s playoffs you can stream games on your phone. All phones. All carriers. For free. On
Zero2Cool (11-Dec) : Verizon to pay NFL $500 million a year to stream games
beast (11-Dec) : Packers can't catch Eagles so it doesn't directly effect our playoff chances.
Nonstopdrivel (11-Dec) : yoffs?
Nonstopdrivel (11-Dec) : So . . . could in theory be a severe sprain. Which might still sideline him for the rest of the season, but perhaps he'd be back for the pla
Zero2Cool (11-Dec) : That's regarding Carson Wentz
Zero2Cool (11-Dec) : @AlbertBreer Doctors determined with manual test there was damage to ACL, extent unknown until MRI tomorrow.
Zero2Cool (11-Dec) : Read reports that's what is feared and yes, you're right, usually if that's the fear = done
Nonstopdrivel (11-Dec) : MRI would me mostly a formality. He walked off on his own power, so possibly just a sprain? But I doubt it.
Nonstopdrivel (11-Dec) : Provocative tests on scene are pretty sensitive. If they fear his ACL is torn, it probably is.
Please sign in to use Fan Shout
2017 Packers Schedule
Sunday, Sep 10 @ 3:25 PM
SEAHAWKS
Sunday, Sep 17 @ 7:30 PM
at Falcons
Sunday, Sep 24 @ 3:25 PM
BENGALS
Thursday, Sep 28 @ 7:25 PM
BEARS
Sunday, Oct 8 @ 3:25 PM
at Cowboys
Sunday, Oct 15 @ 12:00 PM
at Vikings
Sunday, Oct 22 @ 12:00 PM
SAINTS
Sunday, Oct 29 @ 12:00 AM
- BYE -
Monday, Nov 6 @ 7:30 PM
LIONS
Sunday, Nov 12 @ 12:00 PM
at Bears
Sunday, Nov 19 @ 12:00 PM
RAVENS
Sunday, Nov 26 @ 7:30 PM
at Steelers
Sunday, Dec 3 @ 12:00 PM
BUCCANEERS
Sunday, Dec 10 @ 12:00 PM
at Browns
Sunday, Dec 17 @ 12:00 PM
at Panthers
Saturday, Dec 23 @ 7:30 PM
VIKINGS
Sunday, Dec 31 @ 12:00 PM
at Lions
Think About It
Think About It
Recent Topics
1h / Green Bay Packers Talk / Zero2Cool

4h / Green Bay Packers Talk / PackFanWithTwins

4h / Green Bay Packers Talk / PackFanWithTwins

5h / Green Bay Packers Talk / beast

7h / Green Bay Packers Talk / Zero2Cool

8h / Green Bay Packers Talk / beast

11h / Green Bay Packers Talk / wpr

23h / Green Bay Packers Talk / yooperfan

23h / Green Bay Packers Talk / yooperfan

13-Dec / Green Bay Packers Talk / yooperfan

13-Dec / Green Bay Packers Talk / yooperfan

13-Dec / Green Bay Packers Talk / Barfarn

13-Dec / Green Bay Packers Talk / beast

13-Dec / Green Bay Packers Talk / DoddPower

13-Dec / Green Bay Packers Talk / Barfarn

Headlines