Discussion Board
Zero2Cool
2013-10-18T14:29:06Z
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.


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
  • wpr
  • Preferred Member
2013-10-18T14:59:47Z
boy do I stink when it comes to picking. I will stay out of Vegas.
Pack93z
2013-10-18T15:04:56Z
Might want to check that query... Wayne has made over 200 picks? [grin1]
Zero2Cool
2013-10-18T15:41:24Z
Originally Posted by: Pack93z 

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
2013-10-18T15:54:35Z
Originally Posted by: Zero2Cool 

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
2013-10-18T16:05:59Z
Originally Posted by: Pack93z 

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
2013-10-18T16:13:26Z
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
  • wpr
  • Preferred Member
2013-10-18T18:24:33Z
Originally Posted by: Zero2Cool 

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
2013-10-18T18:29:24Z
Originally Posted by: wpr 

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
  • wpr
  • Preferred Member
2013-10-18T19:51:54Z
Originally Posted by: Zero2Cool 

Yes.



Since I have voted early, over the course of the season I have changed my vote on a few games each week.
Zero2Cool
2013-10-18T20:04:24Z
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
2013-10-27T16:52:14Z
How did i miss this until now?!

Users browsing this topic
Fan Shout
Zero2Cool (13-Jul) : @FieldYates Chargers S Roderick Teamer has been suspended for the first four games of the 2020 regular season, per source. He was one of the more productive undrafted rookie free agents in the NFL las
Zero2Cool (13-Jul) : Should have been drinking nano bubbles.
Zero2Cool (13-Jul) : @AdamSchefter Russell Westbrook tested positive for COVID-19.
Cheesey (10-Jul) : Really though, I’m not slow, not fast....kinda “half-fassed!”
Cheesey (10-Jul) : I’m so slow, it looks like I’m going the other direction!😁
Zero2Cool (10-Jul) : Happy Birthday, Alan! Your mother did all the work, you're stealing her thunder! :D
Zero2Cool (10-Jul) : I laughed and said to myself "bet he's slow as crap!" haha
Zero2Cool (10-Jul) : My dad and I play Madden. We are several seasons beyond 2019. One of the rookies was Alan Smith.
Cheesey (10-Jul) : Thanks WPR. I’m getting closer to the finish line.....thank God.
wpr (10-Jul) : happy birthday cheesey
Cheesey (10-Jul) : I did....2and a half times!🤪
Zero2Cool (10-Jul) : Enjoy being 25!!
Cheesey (9-Jul) : Well...guess I’ll say it myself....HAPPY BIRTHDAY TO ME!
Mucky Tundra (9-Jul) : What I've always been mystified by is the amount of guests looking at threads from 4-9 years ago
Cheesey (7-Jul) : I don’t get it either, Zero. Maybe they figure they can slip by, as there’s no one there to notice them!😂
Zero2Cool (7-Jul) : How a site with low traffic attracts spammers is beyond me.
Zero2Cool (6-Jul) : One an half. 🤣
Cheesey (5-Jul) : BOTH of them?🤪😂
Zero2Cool (5-Jul) : Bills fans won't even notice a thing!
Cheesey (5-Jul) : I wish they would in force the law. It was like a war zone last night.
Cheesey (5-Jul) : Here’s something I don’t understand. It’s legal to buy fireworks here, but illegal to shoot them off.
Cheesey (5-Jul) : Hey Zero. How will the Buffalo Bills tell the difference from previous years?😂
KRK (4-Jul) : Happy Independence Day!!!
KRK (2-Jul) : Great thought of the day Z2C
Zero2Cool (2-Jul) : yikes -- No fans will be allowed to attend Buffalo Bills games during COVID
Zero2Cool (1-Jul) : from twitter...NFL reportedly to announce elimination of 1st and 4th 2020 preseason games
Cheesey (30-Jun) : I had to look up the story to get the details. The man was truly a hero. Jumped in when he couldn’t swim.
Zero2Cool (29-Jun) : @Chiefs 37 years ago today, Joe Delaney tragically passed away after attempting to save three children.
Zero2Cool (25-Jun) : @ShamsCharania Indiana Pacers guard Malcolm Brogdon tested positive for coronavirus.
Zero2Cool (25-Jun) : draft history updated
Zero2Cool (22-Jun) : Good catch smokey! I thought I did that already. I'll get on it later this week.
Zero2Cool (18-Jun) : 49ers WR Deebo Samuel has a bum wheel.
Zero2Cool (18-Jun) : That's noteworthy because Gordon applied for reinstatement today.
Zero2Cool (18-Jun) : @ProFootballTalk Josh Gordon relapsed after brother's death
Zero2Cool (15-Jun) : Thank you. We had like SIX of them. Why would anyone come here to spam? Not exactly high traffic lol
Cheesey (15-Jun) : Yeah, that’s why I called them to your attention. We don’t need that garbage on this great site!
Zero2Cool (15-Jun) : Dang spammers.
Zero2Cool (10-Jun) : @mattschneidman Packers at Giants in Week 3 of the preseason moved from 7 p.m. CT kickoff to 5 p.m. CT kickoff.
Zero2Cool (9-Jun) : @BillHuberSI Bakhtiari says he’s been training with Matthews at Clay’s house, where he has a gym.
Zero2Cool (5-Jun) : #Packers sign sixth-round G Jon Runyan.
Cheesey (27-May) : The irony is, you don’t get the irony. (Just kidding!)🤪
Nonstopdrivel (27-May) : I must have missed the joke. What is the irony?
Cheesey (25-May) : I think I’ll “irony” my laundry...🤪
Zero2Cool (25-May) : The irony lol....
Nonstopdrivel (23-May) : Agreed. I love doing research. I submitted a paper to a journal a couple of days ago. Fingers crossed that it gets accepted.
Zero2Cool (20-May) : Research projects can be tons of fun!
Nonstopdrivel (20-May) : I don't have any hospital responsibilities, just the endless onboarding process. I'm working on some research projects too.
TheKanataThrilla (18-May) : Is it vacation now NSD or do you still have hospital responsibilities?
Nonstopdrivel (16-May) : I'll be moving to Myrtle Beach in June.
TheKanataThrilla (16-May) : Congrats NSD. When are you moving?
Please sign in to use Fan Shout
2020 Packers Schedule
Sunday, Sep 13 @ 12:00 PM
Vikings
Sunday, Sep 20 @ 12:00 PM
LIONS
Sunday, Sep 27 @ 7:20 PM
Saints
Monday, Oct 5 @ 7:15 PM
FALCONS
Sunday, Oct 18 @ 3:25 PM
Buccaneers
Sunday, Oct 25 @ 12:00 PM
Texans
Sunday, Nov 1 @ 12:00 PM
VIKINGS
Thursday, Nov 5 @ 7:20 PM
49ers
Sunday, Nov 15 @ 12:00 PM
JAGUARS
Sunday, Nov 22 @ 12:00 PM
Colts
Sunday, Nov 29 @ 7:20 PM
BEARS
Sunday, Dec 6 @ 3:25 PM
EAGLES
Sunday, Dec 13 @ 12:00 PM
Lions
Sunday, Dec 20 @ 12:00 PM
PANTHERS
Sunday, Dec 27 @ 7:20 PM
TITANS
Sunday, Jan 3 @ 12:00 PM
Bears
Think About It
Think About It
Recent Topics
13m / Random Babble / Cheesey

27m / Green Bay Packers Talk / Cheesey

5h / Around The NFL / Zero2Cool

15h / Green Bay Packers Talk / beast

14-Jul / Green Bay Packers Talk / Cheesey

13-Jul / Green Bay Packers Talk / Smokey

13-Jul / Random Babble / KRK

12-Jul / Green Bay Packers Talk / Zero2Cool

12-Jul / Green Bay Packers Talk / shield4life

9-Jul / Around The NFL / Smokey

7-Jul / Random Babble / Zero2Cool

7-Jul / Green Bay Packers Talk / Zero2Cool

6-Jul / Green Bay Packers Talk / beast

5-Jul / Around The NFL / Cheesey

4-Jul / Random Babble / KRK

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