LogFAQs > #910550557

LurkerFAQs, Active DB, DB1, DB2, DB3, Database 4 ( 07.23.2018-12.31.2018 ), DB5, DB6, DB7, DB8, DB9, DB10, DB11, DB12, Clear

Topic List	Page List: 1
Topic	[BOP] Board Odds Project V2 for CBX - Now with REAL-TIME bracket counting!!
Boo_Mario 10/15/18 2:58:48 AM #36:	@AxemRedRanger posted... So, um, I hate to be the bearer of bad news here, but you know that part where you're supposed to resubmit your bracket if you change it and this thing is only supposed to count the latest bracket submitted under that user name? Well I just tested it and the older submissions don't cycle out; My picks go up by 1 no matter how many previous times I've entered this account's bracket in. Sorry guys, my apologies. Also thanks to @dimi161 who reported this issue via PM. I was using `ROW_NUMBER() OVER PARTITION` which MySQL didn't support until v8.0, released earlier this year! Turns out my web host has an older version of MySQL installed, so windowing functions won't work. I've rewritten the query & confirmed it's doing what it's supposed to. This means the bracket count has decreased substantially (from 63 to 37), but it's legit. only 37 distinct users have submitted their brackets over the past week <cite>Boo_Mario posted [p:910550557] in [BOP] Boar... [t:77077890]...</cite> <quote><cite>@AxemRedRanger posted...</cite> <quote>So, um, I hate to be the bearer of bad news here, but you know that part where you're supposed to resubmit your bracket if you change it and this thing is only supposed to count the latest bracket submitted under that user name? Well I just tested it and the older submissions don't cycle out; My picks go up by 1 no matter how many previous times I've entered this account's bracket in.</quote> Sorry guys, my apologies. Also thanks to @dimi161 who reported this issue via PM. I was using ROW_NUMBER() OVER PARTITION which MySQL didn't support until v8.0, released earlier this year! Turns out my web host has an older version of MySQL installed, so windowing functions won't work. I've rewritten the query & confirmed it's doing what it's supposed to. This means the bracket count has decreased substantially (from 63 to 37), but it's legit. only 37 distinct users have submitted their brackets over the past week </quote> ... Copied to Clipboard!
Topic List	Page List: 1