TBCB History Utility - Page 2

sabotai · 03-13-2005, 01:32 AM

Quote:

Originally Posted by JohnnyBench

Just wondering, will this only work if we start a new Universe and begin from there or will it be able to retrieve the info from our already run Universes. As an example. I have a chronologically run universe that has 20 years of history. Will it go back and retrieve my past years or will it only work with my current year?

No, you don't need to start a new universe. What this does is take the CSV history output that the game provides (From Options->Import/Export->Export history database to CSV) and creates the HTML from that. The CSV file will then contain every fight that has been fought in your universe.

Bonedwarf · 03-13-2005, 04:05 AM

Awesome! As Johnny said, this could get me excited in TBCB again. (Which I've not touched much lately, mainly due to being sick of computers.)

JohnnyBench · 03-13-2005, 06:29 AM

Sounds great! This will relieve all of us from alot of "Notebook" Time and give us more Game time!

sabotai · 03-13-2005, 04:12 PM

Ok guys, here it is.

http://www.irregardlessproductions.com/TBCBHistory.zip

I hope I didn't forget anything.

Let me know if anyone has any problems with this. Since it's only reading off the CSV file, it doesn't interact with any of the game data files at all, so you don't have to worry about it effecting your universe.

I suggest just unzipping this into your Exchange folder since that's where the game exports the CSV file (the default location anyway)

Tiger Fan · 03-13-2005, 04:34 PM

Just tried it out and it was a breeze to use. Looks outstanding but I did notice a few errors on the title pages though. For example

Ike Williams is the only lightweight champ I have ever had and this was the print out

WBC Lightweight Title History
9/5/1946 - Ronnie James (0-0-0) KO6 Harold Green (17-0-0)
9/18/1946 - Enrique Bolanos (22-1-0) TKO15 Willie Pep (16-0-0)
2/23/1947 - Ike Williams (18-0-0) KO3 Joe Brown (12-2-0)
6/13/1947 - Bob Montgomery (29-11-0) UD15 Billy Smith (19-0-0)
9/12/1947 - Art Aragon (0-0-0) TKO13 Jack Hassen (20-0-0)

I will regenerate the history export and try again to see if that is where the problem lies.

sabotai · 03-13-2005, 04:54 PM

Could you go to those dates in the year-by-year section and see if they say WBC title next to those fights and if they are LW fights?

LeeSkye · 03-13-2005, 05:00 PM

Awesome sabotai!
I had 25,840 records output to the csv file and your program had the output done in no time. I walked to the fridge to get coke, figuring it would take a while and it was done when I walked back to my desk!

Tiger Fan · 03-13-2005, 05:10 PM

Just reran it and here is the LW title fight html page.

WBC Lightweight Title History
9/5/1946 - Ronnie James (3-5-1) KO6 Ike Williams (17-0-0)
9/18/1946 - Enrique Bolanos (14-0-0) TKO15 Ike Williams (16-0-0)
2/23/1947 - Ike Williams (19-3-2) KO3 Jackie Paterson (12-2-0)
6/13/1947 - Bob Montgomery (10-0-0) UD15 Ike Williams (19-0-0)
9/12/1947 - Art Aragon (14-4-1) TKO13 Ike Williams (20-0-0)

All the fights are title bouts but Williams won them all.

I dont have time now but late tonight I will go through what you ask.

sabotai · 03-13-2005, 05:23 PM

When you check it out, go into the game and see if Ike Williams did fight those guys and if the decisions were as listed.

Also, zip up your csv file and email it to me at chronokhan@yahoo.com so I can run it through the debug and see what's going on.

Gunsmoke · 03-13-2005, 06:13 PM

Terrific effort Sabotai, just tried it on my universe and it ran like a dream.

Thanks,
Mark

javier_83 · 03-13-2005, 06:39 PM

Sabotai you the man

thanks a lot

Tiger Fan · 03-13-2005, 06:58 PM

Quote:

Originally Posted by sabotai

When you check it out, go into the game and see if Ike Williams did fight those guys and if the decisions were as listed.

Also, zip up your csv file and email it to me at chronokhan@yahoo.com so I can run it through the debug and see what's going on.

Email of csv file is on the way.

Took a look at Williams and everything in the csv appears listed properly. Let me know if you want me to check anything else out. I am off to my Sunday hockey league game but should be back on line around 11 pm eastern.

To break down the lightweight title fights displayed on the HTML page

WBC Lightweight Title History
9/5/1946 - Ronnie James (3-5-1) KO6 Ike Williams (17-0-0) everything is correct except Williams not James won by KO 6.
9/18/1946 - Enrique Bolanos (14-0-0) TKO15 Ike Williams (16-0-0) Same as above Williams won KO 15
2/23/1947 - Ike Williams (19-3-2) KO3 Jackie Paterson (12-2-0) Williams did not ever fight Paterson, a flyweight. Paterson did have a Flyweight title fight with Speedy Akira on 2/23/47 and lost by KO in the 15th. Williams fought and KO 3 win over Joe Brown on the same date in LW title fight.
6/13/1947 - Bob Montgomery (10-0-0) UD15 Ike Williams (19-0-0) Reversed as Williams not Montgomery won the decision.
9/12/1947 - Art Aragon (14-4-1) TKO13 Ike Williams (20-0-0) also reversed as Williams beat Aragon by TKO13 on that date.

So somewhere along the way the winner and loser are getting reversed and there also seems to be an issue when two titles are contested on the same date. Hope that helps a little.

Also is anyone else seeing multiple links to each weight class on the index page. Here is a shot from my index page as an example. Btw, all the categories do link to the correct title page.

mh2365 · 03-13-2005, 07:57 PM

Works great, but he's right the title history is pretty messed up. Considering you just added that yesterday though ..... Great utility and thanks for the effort. I, for one, will use this alot!!!

CONN CHRIS · 03-13-2005, 08:10 PM

Very slick job! The fight listing is great. The title bout listing, which I am most interested in does do some odd things. In mine it is listing bouts and opponents that were not even for the title. Steffan Tangstad got one title shot and was blown out. The title bout listing shows him as winning two title fights. The folks back in Norway are thrilled.

It seems to be inverting fighter records and picking up non-title bouts for some reason. The non title bouts though are generaly involving fighters that did engage in a future title fight, so maybe something is just out of sync.

It is a very clean, easy little program to run tough - very nice job sabotai.

sabotai · 03-13-2005, 08:16 PM

The messed up listing of the weight classes pretty much tells me it's not ordering correctly.

Also, When I open up your CSV file, it starts with the FighterNum of 2. In my CSV file, it starts with 1. That's what I think is the source of the switched fighters. I figured all CSV files would start with 1 but I guess not. That should be an easy fix.

The big problem with your CSV file, however, is that there is a 7 line gap in it in which the fighter's name is not recorded (but a record is) and the fighter numbers are messed up. And then soon after that there seems to be a gap of many lines (maybe 100 or so). And then there's one more small one.

My guess is either your database is corrupted, you have deleted fighters who have fought at some point or the game isn't exporting the csv for you correctly for some reason.

Before you do anything, though, I'm going to put that Fighter Number fix in and see if that works. Then I'll see about the titles.

sabotai · 03-13-2005, 08:38 PM

Ok, I put in the fight number fix and now it does show Ike Williams winning all of his fights now, so that should (famous last words.

) fix the problem with winner and loser being switched.

But for your CSV output TigersFan, it's a mess in there. The reason why Jackie Paterson shows up fighting Ike Williams and not Joe Brown is because Paterson's fight is right after Ike's. Since you have a gap of an uneven number before this, it's messing everything up.

The way the CSV file works is that it outputs 2 lines for every 1 fight. 1 line for each fighter. Since you have a gap of an odd amount, it's completely messing up the order.

The problem now that I see as well is that in one spot, right after the gap, the fight results are a little messed up as well.

So...you CSV file is quite messes up TigersFan. I'm not sure if I'm going to able to get it to correct all of the problems with it.

sabotai · 03-13-2005, 09:25 PM

Uploaded new version (1.1)

The correct winners and losers should show now. I just assumed the CSV outputed 1,2,1,2,1,2,etc. but, when I looked at TigersFan's, his went 2,1,2,1,2,1,etc. and then in some cases, it liked to switch (2,1,2,1,2,2,1,2,1,2,etc.). So now it records the number and it should be fine now.

I think I also figured out the weight class ordering for the Title History.

Also, if anyone still has weird occurances happen, open up the CSV file and see if you have any gaps (records where the fighter's name is missing). If there aren't any, go ahead and email me your csv file to the email address I posted above and I'll see what's going on with it.

CONN CHRIS · 03-13-2005, 09:38 PM

Great! I can't wait to try again when you post it. Thanks so much.

sabotai · 03-13-2005, 10:08 PM

It's uploaded. Same link as before.

http://www.irregardlessproductions.com/TBCBHistory.zip

javier_83 · 03-13-2005, 10:22 PM

Thanks i will test your program

03-13-2005, 04:12 PM	#24
sabotai All Star Reserve Join Date: Apr 2002 Location: South Jersey Posts: 841	Ok guys, here it is. http://www.irregardlessproductions.com/TBCBHistory.zip I hope I didn't forget anything. Let me know if anyone has any problems with this. Since it's only reading off the CSV file, it doesn't interact with any of the game data files at all, so you don't have to worry about it effecting your universe. I suggest just unzipping this into your Exchange folder since that's where the game exports the CSV file (the default location anyway) Last edited by sabotai; 03-13-2005 at 04:13 PM.

03-13-2005, 04:34 PM	#25
Tiger Fan Hall Of Famer Join Date: Dec 2001 Location: Ontario Canada Posts: 9,537	Just tried it out and it was a breeze to use. Looks outstanding but I did notice a few errors on the title pages though. For example Ike Williams is the only lightweight champ I have ever had and this was the print out WBC Lightweight Title History 9/5/1946 - Ronnie James (0-0-0) KO6 Harold Green (17-0-0) 9/18/1946 - Enrique Bolanos (22-1-0) TKO15 Willie Pep (16-0-0) 2/23/1947 - Ike Williams (18-0-0) KO3 Joe Brown (12-2-0) 6/13/1947 - Bob Montgomery (29-11-0) UD15 Billy Smith (19-0-0) 9/12/1947 - Art Aragon (0-0-0) TKO13 Jack Hassen (20-0-0) I will regenerate the history export and try again to see if that is where the problem lies. __________________ Cliff Markle HOB1 greatest pitcher 360-160, 9 Welch Awards, 11 WS titles Columnist- The Figment Sporting Journal MY FIGMENT LEAGUE BROOKLYN KINGS DYNASTY PAST DYNASTYS My History of Hockey Replay Tiger Fan's Sporting News : the mid 1940's Tiger Fan's All Sport Replay: The 1920s History of Sports 1901-15 Historical Tutorial and Feedback League My first fictional attempt The HOB4: The last of my series of history of baseball replays that go back to OOTP2 and the old message board.

03-13-2005, 05:00 PM	#27
LeeSkye All Star Starter Join Date: Aug 2002 Location: Igloo Posts: 1,279	Awesome sabotai! I had 25,840 records output to the csv file and your program had the output done in no time. I walked to the fridge to get coke, figuring it would take a while and it was done when I walked back to my desk! __________________ What If Championship Boxing

03-13-2005, 05:10 PM	#28
Tiger Fan Hall Of Famer Join Date: Dec 2001 Location: Ontario Canada Posts: 9,537	Just reran it and here is the LW title fight html page. WBC Lightweight Title History 9/5/1946 - Ronnie James (3-5-1) KO6 Ike Williams (17-0-0) 9/18/1946 - Enrique Bolanos (14-0-0) TKO15 Ike Williams (16-0-0) 2/23/1947 - Ike Williams (19-3-2) KO3 Jackie Paterson (12-2-0) 6/13/1947 - Bob Montgomery (10-0-0) UD15 Ike Williams (19-0-0) 9/12/1947 - Art Aragon (14-4-1) TKO13 Ike Williams (20-0-0) All the fights are title bouts but Williams won them all. I dont have time now but late tonight I will go through what you ask. __________________ Cliff Markle HOB1 greatest pitcher 360-160, 9 Welch Awards, 11 WS titles Columnist- The Figment Sporting Journal MY FIGMENT LEAGUE BROOKLYN KINGS DYNASTY PAST DYNASTYS My History of Hockey Replay Tiger Fan's Sporting News : the mid 1940's Tiger Fan's All Sport Replay: The 1920s History of Sports 1901-15 Historical Tutorial and Feedback League My first fictional attempt The HOB4: The last of my series of history of baseball replays that go back to OOTP2 and the old message board.

03-13-2005, 08:10 PM	#34
CONN CHRIS Global Moderator Join Date: Oct 2004 Posts: 28,366	Very slick job! The fight listing is great. The title bout listing, which I am most interested in does do some odd things. In mine it is listing bouts and opponents that were not even for the title. Steffan Tangstad got one title shot and was blown out. The title bout listing shows him as winning two title fights. The folks back in Norway are thrilled. It seems to be inverting fighter records and picking up non-title bouts for some reason. The non title bouts though are generaly involving fighters that did engage in a future title fight, so maybe something is just out of sync. It is a very clean, easy little program to run tough - very nice job sabotai. __________________ Check Out My Cards!

03-13-2005, 04:05 AM	#22
Bonedwarf All Star Starter Join Date: Jan 2004 Posts: 1,341	Awesome! As Johnny said, this could get me excited in TBCB again. (Which I've not touched much lately, mainly due to being sick of computers.)

03-13-2005, 06:29 AM	#23
JohnnyBench Minors (Triple A) Join Date: Mar 2004 Posts: 254	Sounds great! This will relieve all of us from alot of "Notebook" Time and give us more Game time!

03-13-2005, 04:54 PM	#26
sabotai All Star Reserve Join Date: Apr 2002 Location: South Jersey Posts: 841	Could you go to those dates in the year-by-year section and see if they say WBC title next to those fights and if they are LW fights?

03-13-2005, 05:23 PM	#29
sabotai All Star Reserve Join Date: Apr 2002 Location: South Jersey Posts: 841	When you check it out, go into the game and see if Ike Williams did fight those guys and if the decisions were as listed. Also, zip up your csv file and email it to me at chronokhan@yahoo.com so I can run it through the debug and see what's going on.

03-13-2005, 06:13 PM	#30
Gunsmoke All Star Starter Join Date: Jun 2002 Posts: 1,012	Terrific effort Sabotai, just tried it on my universe and it ran like a dream. Thanks, Mark

03-13-2005, 06:39 PM	#31
javier_83 Hall Of Famer Join Date: Nov 2003 Posts: 3,088 Blog Entries: 3	Sabotai you the man thanks a lot

03-13-2005, 07:57 PM	#33
mh2365 Banned Join Date: Dec 2001 Location: louisville Posts: 14,941 Infractions: 0/2 (101)	Works great, but he's right the title history is pretty messed up. Considering you just added that yesterday though ..... Great utility and thanks for the effort. I, for one, will use this alot!!!

03-13-2005, 08:16 PM	#35
sabotai All Star Reserve Join Date: Apr 2002 Location: South Jersey Posts: 841	The messed up listing of the weight classes pretty much tells me it's not ordering correctly. Also, When I open up your CSV file, it starts with the FighterNum of 2. In my CSV file, it starts with 1. That's what I think is the source of the switched fighters. I figured all CSV files would start with 1 but I guess not. That should be an easy fix. The big problem with your CSV file, however, is that there is a 7 line gap in it in which the fighter's name is not recorded (but a record is) and the fighter numbers are messed up. And then soon after that there seems to be a gap of many lines (maybe 100 or so). And then there's one more small one. My guess is either your database is corrupted, you have deleted fighters who have fought at some point or the game isn't exporting the csv for you correctly for some reason. Before you do anything, though, I'm going to put that Fighter Number fix in and see if that works. Then I'll see about the titles.

03-13-2005, 08:38 PM	#36
sabotai All Star Reserve Join Date: Apr 2002 Location: South Jersey Posts: 841	Ok, I put in the fight number fix and now it does show Ike Williams winning all of his fights now, so that should (famous last words. ) fix the problem with winner and loser being switched. But for your CSV output TigersFan, it's a mess in there. The reason why Jackie Paterson shows up fighting Ike Williams and not Joe Brown is because Paterson's fight is right after Ike's. Since you have a gap of an uneven number before this, it's messing everything up. The way the CSV file works is that it outputs 2 lines for every 1 fight. 1 line for each fighter. Since you have a gap of an odd amount, it's completely messing up the order. The problem now that I see as well is that in one spot, right after the gap, the fight results are a little messed up as well. So...you CSV file is quite messes up TigersFan. I'm not sure if I'm going to able to get it to correct all of the problems with it. Last edited by sabotai; 03-13-2005 at 08:47 PM.

03-13-2005, 09:25 PM	#37
sabotai All Star Reserve Join Date: Apr 2002 Location: South Jersey Posts: 841	Uploaded new version (1.1) The correct winners and losers should show now. I just assumed the CSV outputed 1,2,1,2,1,2,etc. but, when I looked at TigersFan's, his went 2,1,2,1,2,1,etc. and then in some cases, it liked to switch (2,1,2,1,2,2,1,2,1,2,etc.). So now it records the number and it should be fine now. I think I also figured out the weight class ordering for the Title History. Also, if anyone still has weird occurances happen, open up the CSV file and see if you have any gaps (records where the fighter's name is missing). If there aren't any, go ahead and email me your csv file to the email address I posted above and I'll see what's going on with it. Last edited by sabotai; 03-13-2005 at 09:30 PM.

03-13-2005, 09:38 PM	#38
CONN CHRIS Global Moderator Join Date: Oct 2004 Posts: 28,366	Great! I can't wait to try again when you post it. Thanks so much. __________________ Check Out My Cards!

03-13-2005, 10:08 PM	#39
sabotai All Star Reserve Join Date: Apr 2002 Location: South Jersey Posts: 841	It's uploaded. Same link as before. http://www.irregardlessproductions.com/TBCBHistory.zip

03-13-2005, 10:22 PM	#40
javier_83 Hall Of Famer Join Date: Nov 2003 Posts: 3,088 Blog Entries: 3	Thanks i will test your program