Hoshotakamoto 259 Posted April 18, 2022 On 18/04/2022 at 18:26, Reonito said: If there is no plan to solve the db instability issues, might it be feasible to move the game entry method? I'd be willing to lend a (technical) hand on getting matters like this resolved for June. 3 Share this post Link to post Share on other sites
Seiyashi 4,108 Posted April 18, 2022 (edited) On 18/04/2022 at 18:28, Hoshotakamoto said: I made zero progress on writing new code to programmatically get better at this than my own intuition. My hastily thrown together last minute (human) picks: The DB is kiboshing any attempt at a data pull, if I even could reverse engineer the optimal data storage structure for it in the first place (relative script kiddie here). The amount of data is no joke to be running a bad data structure, although given the instability issues it might just be a question of getting data offline to begin with and sorting it later. Edited April 18, 2022 by Seiyashi 1 Share this post Link to post Share on other sites
Wamahada 57 Posted April 18, 2022 Entry is closed now, isn‘t it? Share this post Link to post Share on other sites
Wamahada 57 Posted April 18, 2022 My humble attempt: Yokozuna E: Terunofuji Y1e (3-3-9) Ozeki E: Mitakeumi O2w (11-4) Ozeki W: Shodai O1e (9-6) Ozeki W2: Takakeisho O1w (8-7) Sekiwake E: Wakatakakage S1e (12-3) Sekiwake W: Abi S1w (8-7) Komusubi E: Hoshoryu K1w (8-7) Komusubi W: Daieisho M1e (8-7) Maegashira E: Takayasu M7e (12-3) Maegashira W: Ichinojo M2e (9-6) Maegashira E2: Kiribayama M4e (10-5) Maegashira W2: Kotonowaka M6w (11-4) Maegashira E3: Tamawashi M2w (7-8) Maegashira W3: Endo M4w (8-7) Maegashira E4: Hokutofuji M6e (9-6) Maegashira W4: Tobizaru M9e (9-6) Maegashira E5: Onosho M3e (6-9) Maegashira W5: Wakamotoharu M9w (9-6) Maegashira E6: Takanosho K1e (4-11) Maegashira W6: Shimanoumi M10e (8-7) Maegashira E7: Takarafuji M5e (6-9) Maegashira W7: Ura M1w (4-11) Maegashira E8: Kotoeko M12e (9-6) Maegashira W8: Terutsuyoshi M11w (8-7) Maegashira E9: Kotoshoho M14e (9-6) Maegashira W9: Tochinoshin M15w (9-6) Maegashira E10: Nishikigi M16e (9-6) Maegashira W10: Midorifuji J6e (12-3) Maegashira E11: Aoiyama M10w (7-8) Maegashira W11: Myogiryu M11e (7-8) Maegashira E12: Okinoumi M7w (5-10) Maegashira W12: Chiyoshoma M8e (5-10) Maegashira E13: Sadanoumi M8w (5-10) Maegashira W13: Chiyotairyu M12w (7-8) Maegashira E14: Oho J1e (10-5) Maegashira W14: Azumaryu J2e (10-5) Maegashira E15: Yutakayama M14w (7-8) Maegashira W15: Ishiura M5w (2-7-6) Maegashira E16: Meisei M3w (1-14) Maegashira W16: Ichiyamamoto M17w (8-7) Maegashira E17: Kotokuzan M16w (7-8) Maegashira W17: Kagayaki M17e (7-8) Share this post Link to post Share on other sites
Kintamayama 45,527 Posted April 18, 2022 On 18/04/2022 at 18:29, Hoshotakamoto said: I'd be willing to lend a (technical) hand on getting matters like this resolved for June. I may take you up on that.. Share this post Link to post Share on other sites
Kintamayama 45,527 Posted April 18, 2022 On 18/04/2022 at 19:23, Wamahada said: My humble attempt: Yokozuna E: Terunofuji Y1e (3-3-9) Ozeki E: Mitakeumi O2w (11-4) Ozeki W: Shodai O1e (9-6) Ozeki W2: Takakeisho O1w (8-7) Sekiwake E: Wakatakakage S1e (12-3) Sekiwake W: Abi S1w (8-7) Komusubi E: Hoshoryu K1w (8-7) Komusubi W: Daieisho M1e (8-7) Maegashira E: Takayasu M7e (12-3) Maegashira W: Ichinojo M2e (9-6) Maegashira E2: Kiribayama M4e (10-5) Maegashira W2: Kotonowaka M6w (11-4) Maegashira E3: Tamawashi M2w (7-8) Maegashira W3: Endo M4w (8-7) Maegashira E4: Hokutofuji M6e (9-6) Maegashira W4: Tobizaru M9e (9-6) Maegashira E5: Onosho M3e (6-9) Maegashira W5: Wakamotoharu M9w (9-6) Maegashira E6: Takanosho K1e (4-11) Maegashira W6: Shimanoumi M10e (8-7) Maegashira E7: Takarafuji M5e (6-9) Maegashira W7: Ura M1w (4-11) Maegashira E8: Kotoeko M12e (9-6) Maegashira W8: Terutsuyoshi M11w (8-7) Maegashira E9: Kotoshoho M14e (9-6) Maegashira W9: Tochinoshin M15w (9-6) Maegashira E10: Nishikigi M16e (9-6) Maegashira W10: Midorifuji J6e (12-3) Maegashira E11: Aoiyama M10w (7-8) Maegashira W11: Myogiryu M11e (7-8) Maegashira E12: Okinoumi M7w (5-10) Maegashira W12: Chiyoshoma M8e (5-10) Maegashira E13: Sadanoumi M8w (5-10) Maegashira W13: Chiyotairyu M12w (7-8) Maegashira E14: Oho J1e (10-5) Maegashira W14: Azumaryu J2e (10-5) Maegashira E15: Yutakayama M14w (7-8) Maegashira W15: Ishiura M5w (2-7-6) Maegashira E16: Meisei M3w (1-14) Maegashira W16: Ichiyamamoto M17w (8-7) Maegashira E17: Kotokuzan M16w (7-8) Maegashira W17: Kagayaki M17e (7-8) Sorry, entry way too late.. Share this post Link to post Share on other sites
Wamahada 57 Posted April 18, 2022 I am already on the entry list, I made my pick successfully a few days ago. Just publish my pick as also in previous GTB. Wamahada Share this post Link to post Share on other sites
Kintamayama 45,527 Posted April 18, 2022 On 18/04/2022 at 20:09, Wamahada said: I am already on the entry list, I made my pick successfully a few days ago. Just publish my pick as also in previous GTB. Wamahada Sure Share this post Link to post Share on other sites
Hidenotora 82 Posted April 18, 2022 I notice that the site is up and working better than I've seen it work in a week now, shame that's no good! I know a few people who would normally have entered who didn't, but hopefully there'll be a backup in place for next time, because until something is done about the server, it would be foolish to rely on the site at this point. Honestly, at this point a Google Form would serve us better: easy to make, free and won't go down. I managed to submit the form (I'm the last entry on the entry list), here's my entry: Reveal hidden contents East West Terunofuji Y Mitakeumi O Shodai O Takakeisho Wakatakakage S Abi Hoshoryu K Daieisho Ichinojo M1 Kiribayama Takayasu M2 Kotonowaka Endo M3 Tamawashi Hokutofuji M4 Takanosho Onosho M5 Tobizaru Wakamotoharu M6 Ura Takarafuji M7 Kotoeko Shimanoumi M8 Terutsuyoshi Kotoshoho M9 Okinoumi Tochinoshin M10 Nishikigi Aoiyama M11 Myogiryu Chiyoshoma M12 Sadanoumi Chiyotairyu M13 Meisei Ishiura M14 Yutakayama Ichiyamamoto M15 Oho Azumaryu M16 Midorifuji Kotokuzan M17 Chiyomaru Hopefully that formats correctly. 1 Share this post Link to post Share on other sites
Hoshotakamoto 259 Posted April 18, 2022 (edited) On 18/04/2022 at 19:00, Seiyashi said: The DB is kiboshing any attempt at a data pull, if I even could reverse engineer the optimal data storage structure for it in the first place (relative script kiddie here). The amount of data is no joke to be running a bad data structure, although given the instability issues it might just be a question of getting data offline to begin with and sorting it later. So like 4 months ago I did the banzuke query to show rankings for 7 consecutive basho and this was a pretty efficient way to grab all the pertinent information for the banzuke history from 1994 to the present (I think I chose 1994 for reasons having to do with the contest). There was a little bit of edge case data to pick up - for example newer guys like Ishizaki were missed, but I think everything in the top division was fully covered. I was able to make incremental progress on the algorithm but some of the ideas I've had that would probably make it fairly bulletproof have not made it down the keyboard yet. I think my code right now would fairly consistently finish approximately 2nd to last in GTB. EDIT to mention I think there were substantial changes to the text I was quoting and the changes propagate into my quote (???) Yikes Edited April 19, 2022 by Hoshotakamoto 1 Share this post Link to post Share on other sites
Hoshotakamoto 259 Posted April 19, 2022 On 18/04/2022 at 19:23, Wamahada said: My humble attempt: Yokozuna E: Terunofuji Y1e (3-3-9) Ozeki E: Mitakeumi O2w (11-4) Ozeki W: Shodai O1e (9-6) Ozeki W2: Takakeisho O1w (8-7) Sekiwake E: Wakatakakage S1e (12-3) Sekiwake W: Abi S1w (8-7) Komusubi E: Hoshoryu K1w (8-7) Komusubi W: Daieisho M1e (8-7) Maegashira E: Takayasu M7e (12-3) Maegashira W: Ichinojo M2e (9-6) Maegashira E2: Kiribayama M4e (10-5) Maegashira W2: Kotonowaka M6w (11-4) Maegashira E3: Tamawashi M2w (7-8) Maegashira W3: Endo M4w (8-7) Maegashira E4: Hokutofuji M6e (9-6) Maegashira W4: Tobizaru M9e (9-6) Maegashira E5: Onosho M3e (6-9) Maegashira W5: Wakamotoharu M9w (9-6) Maegashira E6: Takanosho K1e (4-11) Maegashira W6: Shimanoumi M10e (8-7) Maegashira E7: Takarafuji M5e (6-9) Maegashira W7: Ura M1w (4-11) Maegashira E8: Kotoeko M12e (9-6) Maegashira W8: Terutsuyoshi M11w (8-7) Maegashira E9: Kotoshoho M14e (9-6) Maegashira W9: Tochinoshin M15w (9-6) Maegashira E10: Nishikigi M16e (9-6) Maegashira W10: Midorifuji J6e (12-3) Maegashira E11: Aoiyama M10w (7-8) Maegashira W11: Myogiryu M11e (7-8) Maegashira E12: Okinoumi M7w (5-10) Maegashira W12: Chiyoshoma M8e (5-10) Maegashira E13: Sadanoumi M8w (5-10) Maegashira W13: Chiyotairyu M12w (7-8) Maegashira E14: Oho J1e (10-5) Maegashira W14: Azumaryu J2e (10-5) Maegashira E15: Yutakayama M14w (7-8) Maegashira W15: Ishiura M5w (2-7-6) Maegashira E16: Meisei M3w (1-14) Maegashira W16: Ichiyamamoto M17w (8-7) Maegashira E17: Kotokuzan M16w (7-8) Maegashira W17: Kagayaki M17e (7-8) For future reference I learned in this forum that Oho and Azumaryu will not be elevated past Ichiyamamoto's top division KK as one of the set-in-stone rules of banzuke logic. 1 Share this post Link to post Share on other sites
Reonito 1,519 Posted April 19, 2022 On 18/04/2022 at 23:55, Hoshotakamoto said: So like 4 months ago I did the banzuke query to show rankings for 7 consecutive basho and this was a pretty efficient way to grab all the pertinent information for the banzuke history from 1994 to the present (I think I chose 1994 for reasons having to do with the contest). There was a little bit of edge case data to pick up - for example newer guys like Ishizaki were missed, but I think everything in the top division was fully covered. I was able to make incremental progress on the algorithm but some of the ideas I've had that would probably make it fairly bulletproof have not made it down the keyboard yet. I think my code right now would fairly consistently finish approximately 2nd to last in GTB. Just having that banzuke history in a searchable format somewhere reliable would be awesome. Share this post Link to post Share on other sites
Hoshotakamoto 259 Posted April 19, 2022 On 19/04/2022 at 00:46, Reonito said: Just having that banzuke history in a searchable format somewhere reliable would be awesome. Interesting .... I'm incentivized to expose this data through my employer if that's not too offputting. I can discuss over DM. Share this post Link to post Share on other sites
Gurowake 4,107 Posted April 19, 2022 Terunofuji(3-3 Ye) Y Mitakeumi(11-4 Ow) O Shodai(9-6 Oe) O Takakeisho(8-7 Ow) Wakatakakage(12-3 Se) S Abi(8-7 Sw) Hoshoryu(8-7 Kw) K Daieisho(8-7 M1e) Ichinojo(9-6 M2e) M1 Kiribayama(10-5 M4e) Takayasu(12-3 M7e) M2 Kotonowaka(11-4 M6w) Hokutofuji(9-6 M6e) M3 Endo(8-7 M4w) Tamawashi(7-8 M2w) M4 Takanosho(4-11 Ke) Onosho(6-9 M3e) M5 Tobizaru(9-6 M9e) Wakamotoharu(9-6 M9w) M6 Ura(4-11 M1w) Takarafuji(6-9 M5e) M7 Kotoeko(9-6 M12e) Shimanoumi(8-7 M10e) M8 Terutsuyoshi(8-7 M11w) Kotoshoho(9-6 M14e) M9 Tochinoshin(9-6 M15w) Okinoumi(5-10 M7w) M10 Aoiyama(7-8 M10w) Myogiryu(7-8 M11e) M11 Nishikigi(9-6 M16e) Chiyoshoma(5-10 M8e) M12 Sadanoumi(5-10 M8w) Chiyotairyu(7-8 M12w) M13 Meisei(1-14 M3w) Ishiura(2-7 M5w) M14 Oho(10-5 J1e) Azumaryu(10-5 J2e) M15 Yutakayama(7-8 M14w) Ichiyamamoto(8-7 M17w) M16 Midorifuji(12-3 J6e) Kotokuzan(7-8 M16w) M17 Chiyomaru(5-10 M13e) Share this post Link to post Share on other sites
Bill 0 Posted April 19, 2022 (edited) I 'm sending entry to motidi@yahoo.com, but I can't see my shikona in GTB entries for Natsu 2022...Why? Edited April 19, 2022 by Bill Share this post Link to post Share on other sites
Hoshotakamoto 259 Posted April 19, 2022 (edited) On 19/04/2022 at 03:18, Gurowake said: Terunofuji(3-3 Ye) Y Mitakeumi(11-4 Ow) O Shodai(9-6 Oe) O Takakeisho(8-7 Ow) Wakatakakage(12-3 Se) S Abi(8-7 Sw) Hoshoryu(8-7 Kw) K Daieisho(8-7 M1e) Ichinojo(9-6 M2e) M1 Kiribayama(10-5 M4e) Takayasu(12-3 M7e) M2 Kotonowaka(11-4 M6w) Hokutofuji(9-6 M6e) M3 Endo(8-7 M4w) Tamawashi(7-8 M2w) M4 Takanosho(4-11 Ke) Onosho(6-9 M3e) M5 Tobizaru(9-6 M9e) Wakamotoharu(9-6 M9w) M6 Ura(4-11 M1w) Takarafuji(6-9 M5e) M7 Kotoeko(9-6 M12e) Shimanoumi(8-7 M10e) M8 Terutsuyoshi(8-7 M11w) Kotoshoho(9-6 M14e) M9 Tochinoshin(9-6 M15w) Okinoumi(5-10 M7w) M10 Aoiyama(7-8 M10w) Myogiryu(7-8 M11e) M11 Nishikigi(9-6 M16e) Chiyoshoma(5-10 M8e) M12 Sadanoumi(5-10 M8w) Chiyotairyu(7-8 M12w) M13 Meisei(1-14 M3w) Ishiura(2-7 M5w) M14 Oho(10-5 J1e) Azumaryu(10-5 J2e) M15 Yutakayama(7-8 M14w) Ichiyamamoto(8-7 M17w) M16 Midorifuji(12-3 J6e) Kotokuzan(7-8 M16w) M17 Chiyomaru(5-10 M13e) wow you have a ton of agreement with my picks (which could be good, could be bad) but the places where we don't agree I feel really strongly about mine? EDIT to add: Nope, you crushed me with Oho and Azumaryu jumping ahead of Ichi's KK. I would have gone that way if I hadn't read these boards! *shakes fist* Edited April 26, 2022 by Hoshotakamoto results came in Share this post Link to post Share on other sites
fwuzzle23 66 Posted April 19, 2022 On 19/04/2022 at 03:36, Bill said: I 'm sending entry to motidi@yahoo.com, but I can't see my shikona in GTB entries for Natsu 2022...Why? As far as I'm aware, the entry list only displays the people who used the actual entry form through the website. I have no idea if it will eventually have the people who had to email theirs, but those have to be entered into the system manually, which seems like a difficult process from how much Moti seems to be dreading having to do that... Share this post Link to post Share on other sites
Kintamayama 45,527 Posted April 19, 2022 On 19/04/2022 at 03:36, Bill said: I 'm sending entry to motidi@yahoo.com, but I can't see my shikona in GTB entries for Natsu 2022...Why? Because all 20-odd entries by mail are not on the list. You will be seen.. Share this post Link to post Share on other sites
Kintamayama 45,527 Posted April 19, 2022 On 19/04/2022 at 06:17, fwuzzle23 said: As far as I'm aware, the entry list only displays the people who used the actual entry form through the website. I have no idea if it will eventually have the people who had to email theirs, but those have to be entered into the system manually, which seems like a difficult process from how much Moti seems to be dreading having to do that... Not me, Andoreasu does it. I feel very uncomfortable asking him to do it. Share this post Link to post Share on other sites
Kintamayama 45,527 Posted April 19, 2022 (edited) These are all entries received- if you sent an entry and are not on the list please PM me with some sort of proof that you did send me an email .. Shikona Kotononami Doreikishi Ketsukai Chartorenji AureliaLux Kirinoumi arkediaz SubmergedBass Oneychan Kaiowaka UsedChicken Kinoko Bosonami Tzutziyama SumoCBX cmlobue Shoryuyama Susanoo Athenayama Jejima jjdynasty Kuronopon Kakejolas Ullishimaru Wakatakatakatakatakatakatakatakatakatakatakatakata Yarimotsu Chubanoumi Gurowake Konishiki Vleuel Flohru holtyasu Wassupca Suijin SHiFT Itchynotoe Ganzohnesushi Akawainnoumi Randy Savage Yoshio glacier Barutonoumi Cheesofuji Yubinhaad Hourmanumi robnplunder Pandaazuma Mysko Ichinanjo Inazuma maorencze Kitakachiyama Leonishiki Wakawakawaka Oortael Tupayumi Konosato Kyotomo Sakura Pitinosato Saruwatari II Simon Kowaiazumaya kujo Sukubidubidu Chiyonosawa CaptSmarta$$ Tim Sumo Benimaru Chisaiwashi Kaminari no taiyō Goshobiyama BariiHachiBenson Takanorappa Suwihuto RaeucherLax Mitaketakakage Wamahada Moshogaeru gusoyama Ivar Toranoshin intarga Arthur Moschen Jakusotsu choccymilkchanko Matsunofuji Kasamatsuri Asset Chiyotasuke Seiyashi Seki Haruaki Dare Mr.Rofl GONZABUROW Nantonoyama Shatsume Bananawaka Kishikaisei Kaito Golynohana Heriokuno Asashosakari Furuimori Kaikaryu KatsumaBen Netakata TochiYESshin Kajiyanosho taxinohana Netsuzakura chishafuwaku Andoreasu Hidenotora Additonally, these entries were received by mail: Bill Torafujii Oskanohana Reonito Balon Screeching Owl Taiseiyama Gooner Hoshotakamoto Muhomatsu Andonishiki Purring Tamanaogijima Fujisan Kyoju Oshirokita Edited April 19, 2022 by Kintamayama Share this post Link to post Share on other sites
Kintamayama 45,527 Posted April 19, 2022 Doitsuyama is working on it-has been OK for the last hour.. Share this post Link to post Share on other sites
fwuzzle23 66 Posted April 19, 2022 On 19/04/2022 at 09:40, Kintamayama said: Not me, Andoreasu does it. I feel very uncomfortable asking him to do it. Ah, my mistake then. Still, for the sake of everyone running GTB I hope we don't have to go the manual route again in the future. Pain for both the people entering and the people running the show. Either by the DB server having more reliability now that Doitsuyama's implemented a fix to mitigate the bot issue, or having alternate means of submitting entries like some have mentioned. Share this post Link to post Share on other sites
Hoshotakamoto 259 Posted April 19, 2022 On 19/04/2022 at 12:08, Kintamayama said: Doitsuyama is working on it-has been OK for the last hour.. He can reach out to me at the Hoshotakamoto email I used to submit my picks. I would be interested in enabling the user to submit picks early and see them / modify them up to the last minute before the submission deadline. As discussed elsewhere in this thread I might provide the community a backup option to the not-always-reliable sumodb querying functionality. Share this post Link to post Share on other sites
Muhomatsu 246 Posted April 19, 2022 If we are thinking of features - perhaps once you pick a wrestler for a certain spot on the banzuke his name no longer appears in the drop down list. That is one that would help me out. I always make a mistake (ugh, I forgot XXX) and then I have to rework the thing. 1 Share this post Link to post Share on other sites
Kintamayama 45,527 Posted April 19, 2022 On 19/04/2022 at 12:08, Kintamayama said: Doitsuyama is working on it-has been OK for the last hour.. Has been online for many hours now. Share this post Link to post Share on other sites
