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

LurkerFAQs, Active Database ( 07.23.2018-present ), Database 1, Database 2, Database 3
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.
_SecretSquirrel
10/08/18 1:42:51 AM
2
And done.
---
Agent Triple Zero at your service!
BKSheikah is the new greatone.
dilateDChemist
10/08/18 2:18:30 AM
3
tagg
---
-schwifty
abdou
10/08/18 8:58:47 AM
4
yeah this is much faster way.
---
...
ZeldaTPLink
10/08/18 9:02:37 AM
5
done
STElNER
10/08/18 9:12:41 AM
6
done
dimi161
10/08/18 12:15:32 PM
7
Submitted
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.
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
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
PSI_NESS
10/08/18 5:23:06 PM
11
Done
---
Congrats to BKSheikah, winner of the BYIG Guru Contest!
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!
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.
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
---
ZeldaTPLink
10/08/18 11:26:01 PM
15
I'm using the bop to fine tune my bracket.

Expect cookies.
ZenOfThunder
10/08/18 11:47:27 PM
16
@Lolo_Guru
---
Curator of the Character Battle X Archive
https://bit.ly/2NEbCdA
Lolo_Guru
10/08/18 11:49:32 PM
17
oh its this
---
Lolo
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 )
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.
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!
Hbthebattle
10/09/18 3:50:00 PM
21
Gimme a few hours and Ill be done
---
Still hoping.
SuperNiceDog
10/09/18 4:02:35 PM
22
posted mine!
---
Raytan wins!
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."
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
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
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?
RoseChevalier
10/10/18 8:48:10 AM
27
alright, I'm in
---
I'm Rose Coldsteel, from Legend of Coldsteel
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
charmander6000
10/11/18 11:30:09 AM
29
bump
---
Congratulations to BKSheikah for winning the guru
ZeldaTPLink
10/12/18 11:25:05 AM
30
bump
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
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!
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
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]
Menji
10/15/18 1:32:33 AM
35
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
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
SuperNiceDog
10/15/18 4:40:52 AM
38
love this project, thanks
---
Raytan wins!
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
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 ~-
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.
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.
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
FlyingForever
10/15/18 1:25:30 PM
44
okay and done~!
---
-~get rich or drunk trying ~-
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!
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
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
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.
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
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
Topic List
Page List: 1, 2