Board 8 > [BOP] Board Odds Project V2 for CBX - Now with REAL-TIME bracket counting!!

Topic List
Page List: 1, 2
Boo_Mario
10/08/18 12:59:37 AM
#1:


Sorry, I didn't mean to hijack @NowItsAngeTime 's topic, but I realized there's a much easier way to enter & aggregate everyone's contest entry without using JSFiddle or manually typing out a 150-match bracket. The new process literally takes 10 seconds!

Data Entry: http://fghj.pw/cbx/

Current Match by Match Odds: http://fghj.pw/cbx/bop.php
(Sorry, it does NOT include the submissions in NowItsAngeTime's topic, but going forward, this should save a lot of time.)

If you make changes to your bracket, just resubmit it & the BOP stats page will automatically pull your latest entry for aggregation.
... Copied to Clipboard!
_SecretSquirrel
10/08/18 1:42:51 AM
#2:


And done.
---
Agent Triple Zero at your service!
BKSheikah is the new greatone.
... Copied to Clipboard!
dilateDChemist
10/08/18 2:18:30 AM
#3:


tagg
---
-schwifty
... Copied to Clipboard!
abdou
10/08/18 8:58:47 AM
#4:


yeah this is much faster way.
---
...
... Copied to Clipboard!
ZeldaTPLink
10/08/18 9:02:37 AM
#5:


done
... Copied to Clipboard!
STElNER
10/08/18 9:12:41 AM
#6:


done
... Copied to Clipboard!
dimi161
10/08/18 12:15:32 PM
#7:


Submitted
... Copied to Clipboard!
swirIdude
10/08/18 1:25:27 PM
#8:


This is amazing, but the match by match tally needs line breaks between each match.
---
"The people who play Final Fantasy 7 actually have lives and dont NEED polls" ~MajinUltima
BKSheikah won Guru, but you know that.
... Copied to Clipboard!
TheArkOfTurus
10/08/18 1:31:19 PM
#9:


swirIdude posted...
This is amazing, but the match by match tally needs line breaks between each match.


Strongly agree with this.
---
Our eyes were removed
For our own safety
... Copied to Clipboard!
ZenOfThunder
10/08/18 1:43:55 PM
#10:


done

thank you ange!!

edit: thank you @Boo_Mario!!!!!

boo mario gets more exclamation points sorry ange
---
Curator of the Character Battle X Archive
https://bit.ly/2NEbCdA
... Copied to Clipboard!
PSI_NESS
10/08/18 5:23:06 PM
#11:


Done
---
Congrats to BKSheikah, winner of the BYIG Guru Contest!
... Copied to Clipboard!
pyresword
10/08/18 9:07:15 PM
#12:


Well I didn't look at every match but in any case I submitted it.

Wow my bracket ended up fucking boring, though I guess I might still change later.

Also I noticed an error the first time (it didn't update my most recent change), so I re-entered the source code and hit submit a 2nd time. I hope this updated my entry rather than submitting an entire second bracket.

Edit: There is a pick I made where I am the only one who picked it according to the BOP, so it looks like my bracket is only entered once.
---
Congratulations to BK_Sheikah00, this year's guru to achieve contest enlightenment!
... Copied to Clipboard!
Z1mZum
10/08/18 10:58:21 PM
#13:


I've made a huge mistake
---
Congrats to BKSheikah for doing the thing!
Former All-knowing guru.
... Copied to Clipboard!
Xuxon
10/08/18 11:02:04 PM
#14:


swirIdude posted...
This is amazing, but the match by match tally needs line breaks between each match.

this and also an extra line in bold for each round
---
... Copied to Clipboard!
ZeldaTPLink
10/08/18 11:26:01 PM
#15:


I'm using the bop to fine tune my bracket.

Expect cookies.
... Copied to Clipboard!
ZenOfThunder
10/08/18 11:47:27 PM
#16:


@Lolo_Guru
---
Curator of the Character Battle X Archive
https://bit.ly/2NEbCdA
... Copied to Clipboard!
Lolo_Guru
10/08/18 11:49:32 PM
#17:


oh its this
---
Lolo
... Copied to Clipboard!
Boo_Mario
10/09/18 1:19:46 AM
#18:


Changelog:
- Added percentage in addition to count
- Added line breaks between each match (thanks @swirIdude )
... Copied to Clipboard!
swirIdude
10/09/18 2:38:52 PM
#19:


The matches are showing 31 entries for Rounds 2 and beyond, but 32 entries for Round 1. Did someone submit a Round 1 only bracket?
---
"The people who play Final Fantasy 7 actually have lives and dont NEED polls" ~MajinUltima
BKSheikah won Guru, but you know that.
... Copied to Clipboard!
Ranticoot
10/09/18 3:47:47 PM
#20:


i think my bracket is done so i'm in

good shit
---
Born to lose, live to win!
... Copied to Clipboard!
Hbthebattle
10/09/18 3:50:00 PM
#21:


Gimme a few hours and Ill be done
---
Still hoping.
... Copied to Clipboard!
SuperNiceDog
10/09/18 4:02:35 PM
#22:


posted mine!
---
Raytan wins!
... Copied to Clipboard!
Haste_2
10/09/18 4:11:02 PM
#23:


Boo_Mario posted...
The new process literally takes 10 seconds!


It took me 11 seconds. I want my money back.

On a more serious note, great work!
---
"Ah, a party! We haven't had one of those. It could be fun! So... what is a party?" "Well, you drink punch and eat CAKE! ...I think."
... Copied to Clipboard!
NowItsAngeTime
10/09/18 9:06:58 PM
#24:


Almost at 40 brackets, not bad
---
ISFJ Big on Visual Novels, Anime, Video games. Twitter: superange128
Planned 2018 Fighting Game Mains: https://pbs.twimg.com/media/DgH4MCHVMAAKV9l.png
... Copied to Clipboard!
azuarc
10/09/18 10:41:15 PM
#25:


I'll post as soon as I stop making little changes that force me to remember the entire back half of my bracket.
---
Video Game Music Contest 12 winner: Ys 8 - Sunshine Coastline
... Copied to Clipboard!
Boo_Mario
10/10/18 2:30:08 AM
#26:


swirIdude posted...
The matches are showing 31 entries for Rounds 2 and beyond, but 32 entries for Round 1. Did someone submit a Round 1 only bracket?

It appears someone submitted an incomplete bracket. Should I exclude them from the counts or leave them in?
... Copied to Clipboard!
RoseChevalier
10/10/18 8:48:10 AM
#27:


alright, I'm in
---
I'm Rose Coldsteel, from Legend of Coldsteel
... Copied to Clipboard!
Ngamer64
10/10/18 9:45:12 PM
#28:


Boo_Mario posted...
swirIdude posted...
The matches are showing 31 entries for Rounds 2 and beyond, but 32 entries for Round 1. Did someone submit a Round 1 only bracket?

It appears someone submitted an incomplete bracket. Should I exclude them from the counts or leave them in?

I vote EXCLUDE.

And great work with this!


---
BKSheikah dominated even The Show hosts in 2017, wow!
board8.wikia.com | thengamer.com/xstats
... Copied to Clipboard!
charmander6000
10/11/18 11:30:09 AM
#29:


bump
---
Congratulations to BKSheikah for winning the guru
... Copied to Clipboard!
ZeldaTPLink
10/12/18 11:25:05 AM
#30:


bump
... Copied to Clipboard!
NowItsAngeTime
10/12/18 6:02:23 PM
#31:


Almost at 50 brackets
---
ISFJ Big on Visual Novels, Anime, Video games. Twitter: superange128
Planned 2018 Fighting Game Mains: https://pbs.twimg.com/media/DgH4MCHVMAAKV9l.png
... Copied to Clipboard!
Team Rocket Elite
10/13/18 11:16:20 PM
#32:


Bump
---
This was not the best year for my bracket.
Congrats to BK_Sheikah00 for winning the BYIG Guru Contest!
... Copied to Clipboard!
linkhatesganon
10/14/18 4:44:36 PM
#33:


Eh since I entered my bracket some hours ago I noticed that R2 and later rounds seem to have one less bracket than R1, is that normal?
---
All hail to he who could see the future, Guru 2017 BkSheikah
http://letterboxd.com/jesusoni; http://www.backloggery.com/linkhatesganon
... Copied to Clipboard!
AxemRedRanger
10/14/18 6:37:47 PM
#34:


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.
---
[NO BARKLEY NO PEACE]
[NO BKSheikah NO PEACE]
... Copied to Clipboard!
Menji
10/15/18 1:32:33 AM
#35:


Done
---
... Copied to Clipboard!
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
... Copied to Clipboard!
haloiscoolisbak
10/15/18 3:36:08 AM
#37:


Is this where we submit our brackets to enter the guru?
---
Started from the bottom now we here
... Copied to Clipboard!
SuperNiceDog
10/15/18 4:40:52 AM
#38:


love this project, thanks
---
Raytan wins!
... Copied to Clipboard!
Ngamer64
10/15/18 6:01:06 AM
#39:


haloiscoolisbak posted...
Is this where we submit our brackets to enter the guru?

No, that topic is coming on Wednesday.
---
BKSheikah dominated even The Show hosts in 2017, wow!
board8.wikia.com | thengamer.com/xstats
... Copied to Clipboard!
FlyingForever
10/15/18 8:17:01 AM
#40:


I'm an idiot so I literally just copy everything on the entire page and submit it ya ?
---
-~get rich or drunk trying ~-
... Copied to Clipboard!
ZeldaTPLink
10/15/18 8:23:41 AM
#41:


FlyingForever posted...
I'm an idiot so I literally just copy everything on the entire page and submit it ya ?


Right click the page, click to view the source code, and then copypaste the entire source code in that susbmission box.
... Copied to Clipboard!
swirIdude
10/15/18 10:31:42 AM
#42:


only 37 entrants? We've fallen off so hard from the glory days.
---
"The people who play Final Fantasy 7 actually have lives and dont NEED polls" ~MajinUltima
BKSheikah won Guru, but you know that.
... Copied to Clipboard!
NowItsAngeTime
10/15/18 12:56:18 PM
#43:



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


Sadly the BOP has always have had much less submissions than Guru,
simply cuz no prize/leaderboard invovled
---
ISFJ Big on Visual Novels, Anime, Video games. Twitter: superange128
Planned 2018 Fighting Game Mains: https://pbs.twimg.com/media/DgH4MCHVMAAKV9l.png
... Copied to Clipboard!
FlyingForever
10/15/18 1:25:30 PM
#44:


okay and done~!
---
-~get rich or drunk trying ~-
... Copied to Clipboard!
Ranticoot
10/15/18 1:52:00 PM
#45:


If we re-submit does it just replace the old bracket we put in

I made some changes so I submitted mine again then realized I hadn't actually picked a champion in my new one so I have to submit it yet again "whoops"
---
Born to lose, live to win!
... Copied to Clipboard!
azuarc
10/15/18 8:17:00 PM
#46:


Apparently this doesn't like all my matches?

https://imgur.com/3fi6z8x

I can tell that it registered those other votes, because it altered the percentages, but my selections were not reflected.
---
Video Game Music Contest 12 winner: Ys 8 - Sunshine Coastline
... Copied to Clipboard!
NowItsAngeTime
10/15/18 9:23:59 PM
#47:


Put in an updated bracket. No increases in numbers so looks good to me.
---
ISFJ Big on Visual Novels, Anime, Video games. Twitter: superange128
Planned 2018 Fighting Game Mains: https://pbs.twimg.com/media/DgH4MCHVMAAKV9l.png
... Copied to Clipboard!
Boo_Mario
10/16/18 6:54:26 AM
#48:


azuarc posted...
Apparently this doesn't like all my matches?

https://imgur.com/3fi6z8x

I can tell that it registered those other votes, because it altered the percentages, but my selections were not reflected.

Looks like your entry is not complete? It does not have all 150 battles. I notice some numbers are missing.
... Copied to Clipboard!
BlAcK TuRtLe
10/17/18 12:48:39 AM
#49:


86Bayonetta1638%
86Riku1433%
86Sans1024%
86Pac-Man25%

This is very surprising to me. I was thinking there isn't a chance Sans doesn't win this, and figured Riku would probably be the board favourite
---
BKSheikah, my hat is off to you. Welcome to the Guru Champions Club
lol xstats
... Copied to Clipboard!
NowItsAngeTime
10/17/18 1:54:26 PM
#50:


Almost at 50
---
ISFJ Big on Visual Novels, Anime, Video games. Twitter: superange128
Planned 2018 Fighting Game Mains: https://pbs.twimg.com/media/DgH4MCHVMAAKV9l.png
... Copied to Clipboard!
Topic List
Page List: 1, 2