Zero2Cool
10 years ago
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%


UserPostedImage
wpr
  • wpr
  • Preferred Member
10 years ago
boy do I stink when it comes to picking. I will stay out of Vegas.
UserPostedImage
Pack93z
10 years ago
Might want to check that query... Wayne has made over 200 picks? [grin1]
"The oranges are dry; the apples are mealy; and the papayas... I don't know what's going on with the papayas!"
Zero2Cool
10 years ago

Might want to check that query... Wayne has made over 200 picks? [grin1]

Originally Posted by: Pack93z 



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
Pack93z
10 years ago

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.

Originally Posted by: Zero2Cool 



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?
"The oranges are dry; the apples are mealy; and the papayas... I don't know what's going on with the papayas!"
Zero2Cool
10 years ago

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?

Originally Posted by: Pack93z 



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
Pack93z
10 years ago
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.
"The oranges are dry; the apples are mealy; and the papayas... I don't know what's going on with the papayas!"
wpr
  • wpr
  • Preferred Member
10 years ago

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.

Originally Posted by: Zero2Cool 



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?)


UserPostedImage
Zero2Cool
10 years ago

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?)

Originally Posted by: wpr 



Yes.
UserPostedImage
wpr
  • wpr
  • Preferred Member
10 years ago

Yes.

Originally Posted by: Zero2Cool 



Since I have voted early, over the course of the season I have changed my vote on a few games each week.
UserPostedImage
Fan Shout
dfosterf (8h) : For the record, I enjoy Beast and Mucky drafts
Zero2Cool (15h) : Haha
Mucky Tundra (16h) : No time for talking! Back to work beast!
beast (16h) : You saw only 4,201 of my mocks? 🥺 I think that means you missed more than half of them 😢
dfosterf (19h) : Does anyone know what Lambeau field improvements got put on hold? My guess would be for the 2025 draft
Zero2Cool (22h) : It's like listen, you made 4,201 mocks, no shit.
Zero2Cool (22h) : Cuz during the draft "I had them mocked there!" as if it's amazing.
Zero2Cool (22h) : They're fun to do once in awhile. It's people who think they are "content" that annoy me.
dfosterf (22h) : Against tbd
dfosterf (22h) : Answer to your question is yes, it's a Thursday, will be the Chiefs aga
dfosterf (22h) : Luckily for all concerned, I don't post them. I did one, but that was like 25 mocks ago
Zero2Cool (22h) : NFL 2024 gonna start Sept 5th isn't it???
Zero2Cool (22h) : Ugh... kids these days!
dfosterf (22h) : I'm gonna go do some more mock draft hell instead 🤪
Zero2Cool (22h) : Did we do one of those prediction threads yet for 2024 season?
dfosterf (23h) : 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 (23h) : And/Or a city council, of which I haven't seen a good one in a very long time
dfosterf (23h) : 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 .
beast (25-Mar) : Simply fined in the week to follow
beast (25-Mar) : I agree with one NFL official, it'll probably be like some of the helmets hits, not really called by the refs on the field but simply fined
Zero2Cool (25-Mar) : Hip drop is not. Super confusing. Referees job is harder
Zero2Cool (25-Mar) : Swivel hip drop is banned
dfosterf (25-Mar) : The hip drop enforcement will be in the form of fines, etc. Not flags
dfosterf (25-Mar) : A major foul will be enforced on the offense if there are offsetting penalties in a change of possession situation
dfosterf (25-Mar) : Teams will receive a 3rd challenge if 1 was successful. Previously, it took 2
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
8h / Green Bay Packers Talk / dfosterf

8h / Green Bay Packers Talk / bboystyle

8h / Green Bay Packers Talk / bboystyle

15h / Green Bay Packers Talk / Mucky Tundra

20h / 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.