TRTR Day 16 : I need to take a dump - Page 2

scuffleball · 05-16-2006, 08:48 AM

I would think that the main advantage to having access to all the stats independent of the game engine itself is that you are no longer limited by the display. What I mean is, you can display what you want, where you want, create your own queries or searches, and even create your own statistics by combining other statistics.

You could basically create your own Catobase, but with what you want displayed, in the order or form you want it displayed.

But there is also the possibility of new utilities and additions that can be created.

What will be developed (or could be developed) will all depend on what the game itself gives us in terms of filtering and display capabilities.

canadiancreed · 05-16-2006, 08:49 AM

is this jsut a sample of the full export?

If so, it shoudl be most intresting indeed

Marc Duffy · 05-16-2006, 08:58 AM

Yes, small selection of data from a full dump

jarmenia · 05-16-2006, 09:02 AM

This is what I've been waiting for!!!

silvam14 · 05-16-2006, 09:08 AM

Quote:

Originally Posted by Marc Duffy

(thanks silvam14 for the original thread title)

Anyway, complete with working examples for SQL and Access ... I've taken a dump today and you can read all about it

http://www.ootpbaseball2006.com/news...ews=view&id=81

1 new screenshot

Showing off the dumping screen, available in our gallery http://www.ootpbaseball2006.com/screenshots.php

Hey Mark! No problem, just doing my little part for the OOTP community!

gordyhulten · 05-16-2006, 09:48 AM

Now I can't wait for an .html dump! (hint, hint)

silvam14 · 05-16-2006, 10:22 AM

How does one get the tables created in ACCESS

kq76 · 05-16-2006, 10:59 AM

Quote:

Originally Posted by Marc Duffy

There are others, this is a small selection for all of you.

So I'm guessing we won't see a full dump before release? It's great to finally see some of it, but I was really hoping we'd get a full dump well before release (it's not well before anymore, but it's still before) so we could actually get started on what we'd like to work on and maybe even have a limited version of whatever it is by release time.

EDIT: Looking it over I guess we can get started, but a full dump would still be even sweeter.

jarmenia · 05-16-2006, 11:00 AM

Quote:

Originally Posted by silvam14

How does one get the tables created in ACCESS

I've written a module to read through a folder, find all the *.sql files and then execute the SQL commands in them. (would have been easer to use csv files for access dumps but anyway)..

Errors I've found so far in the access files:

* Duplicate field names in players_contract (player_id used more than once)

* Duplicate field names in players_contract_extension (player_id used more than once)

* Syntax error in players_contract_extension (Haven't determined the cause of this yet).

silvam14 · 05-16-2006, 11:02 AM

Quote:

Originally Posted by jarmenia

I've written a module to read through a folder, find all the *.sql files and then execute the SQL commands in them. (would have been easer to use csv files for access dumps but anyway)..

Errors I've found so far in the access files:

* Duplicate field names in players_contract (player_id used more than once)

* Duplicate field names in players_contract_extension (player_id used more than once)

* Syntax error in players_contract_extension (Haven't determined the cause of this yet).

Any chance you can PM me the text so I can paste it in a module?

andymac · 05-16-2006, 11:04 AM

Quote:

Originally Posted by kq76

So I'm guessing we won't see a full dump before release? It's great to finally see some of it, but I was really hoping we'd get a full dump well before release (it's not well before anymore, but it's still before) so we could actually get started on what we'd like to work on and maybe even have a limited version of whatever it is by release time.

I would guess that it is possible that the data is yet to be 100% set in stone, so it wouldn't really benefit to release a full dump and then all the modders find out it has been changed for the actual release of the game. In fact, we would probably see some angry modders

.

abailey3313 · 05-16-2006, 11:05 AM

I was intrigued by this thread title -- and I'm concerned that maybe that isn't saying too much about me.

MorseMoose · 05-16-2006, 11:12 AM

. I don't know anything about this stuff...so to keep with the tradition of me complaining...WHY IS THERE NO : DAY 16 in the title?

jarmenia · 05-16-2006, 11:14 AM

Quote:

Originally Posted by silvam14

Any chance you can PM me the text so I can paste it in a module?

Sure just let me clean it up first. Its still pretty raw.

Marc Duffy · 05-16-2006, 11:15 AM

Quote:

Originally Posted by MorseMoose

. I don't know anything about this stuff...so to keep with the tradition of me complaining...WHY IS THERE NO : DAY 16 in the title?

Sugar, will fix

Marc Duffy · 05-16-2006, 11:17 AM

Quote:

Originally Posted by silvam14

Any chance you can PM me the text so I can paste it in a module?

This is great stuff and I'll alert Andreas to this thread.

Zubes · 05-16-2006, 11:18 AM

i have been waiting for this for sometime as well, thanks Marc!

I will be interested to see all the programmers that take advantage of this and start working. My php/MYSQL knowledge is limited, but hopefully i know enough to get started.

kq76 · 05-16-2006, 11:19 AM

Quote:

Originally Posted by andymac

I would guess that it is possible that the data is yet to be 100% set in stone, so it wouldn't really benefit to release a full dump and then all the modders find out it has been changed for the actual release of the game. In fact, we would probably see some angry modders

.

True, and that's why I haven't been incessantly asking for it yet.

From what I have been hearing it sounds like a lot of things aren't quite finished yet and I can understand if this would be one of the things left nearer to the end. But it's getting awfully close to May 31st now so there's not much time for even things at the end of the priority list. No pressure, of course. I'm sure Markus is already up late at night constantly looking at his watch and yelling at the screen for everything to somehow go faster.

MorseMoose · 05-16-2006, 11:20 AM

Quote:

Originally Posted by Marc Duffy

Sugar, will fix

rdomico · 05-16-2006, 11:23 AM

This is cool. As a programmer, I can easily do reports and other cool stuff if all the data is in Access or MySQL.

I might actually do some cool third party utilities if I have time and if I can think of one. I am sure others will have good ideas.

05-16-2006, 08:48 AM	#21 (permalink)
scuffleball Minors (Triple A) Join Date: May 2003 Location: USA Posts: 240 Thanks: 50 Thanked 7x in 6 posts	I would think that the main advantage to having access to all the stats independent of the game engine itself is that you are no longer limited by the display. What I mean is, you can display what you want, where you want, create your own queries or searches, and even create your own statistics by combining other statistics. You could basically create your own Catobase, but with what you want displayed, in the order or form you want it displayed. But there is also the possibility of new utilities and additions that can be created. What will be developed (or could be developed) will all depend on what the game itself gives us in terms of filtering and display capabilities. Last edited by scuffleball; 05-16-2006 at 08:49 AM.

05-16-2006, 08:49 AM	#22 (permalink)
canadiancreed Hall Of Famer Join Date: Aug 2004 Posts: 11,025 Blog Entries: 1 Thanks: 463 Thanked 116x in 85 posts	is this jsut a sample of the full export? If so, it shoudl be most intresting indeed __________________ Once upon a time I stated if I ever got a warning it was time to go. It looks like that day has finally come.

05-16-2006, 09:02 AM	#24 (permalink)
jarmenia Hall Of Famer Join Date: Mar 2002 Location: Tampa, FL USA Posts: 4,289 Thanks: 27 Thanked 46x in 31 posts	This is what I've been waiting for!!! __________________ When is good enough, good enough?

05-16-2006, 09:48 AM	#26 (permalink)
gordyhulten All Star Starter Join Date: Jan 2003 Location: Champaign, IL Posts: 1,175 Thanks: 0 Thanked 3x in 1 post	Now I can't wait for an .html dump! (hint, hint) __________________ Gordy Hulten Owner / General Manager Red Willow Roadrunners -- Kennel Series Champions: 1951, 1959, 1964, 1965, 1972, 1975, 1980, 1982, 1983 Dog Days Baseball - "The World's Best Online OOTP League" Creator inactive: Republican League - OOTP 2009 Dynasty inactive: Republican League Dynasty - Version 2.0 inactive: Republican League Dynasty

05-16-2006, 11:05 AM	#32 (permalink)
abailey3313 Hall Of Famer Join Date: Nov 2004 Location: Maryland Posts: 3,643 Thanks: 0 Thanked 2x in 2 posts	I was intrigued by this thread title -- and I'm concerned that maybe that isn't saying too much about me. __________________ last.fm \| tswr - come on and join!

05-16-2006, 08:58 AM	#23 (permalink)
Marc Duffy SI Marketing Wizard Join Date: Mar 2004 Location: Old Street, London Posts: 4,737 Thanks: 0 Thanked 6x in 2 posts	Yes, small selection of data from a full dump

05-16-2006, 10:22 AM	#27 (permalink)
silvam14 Hall Of Famer Join Date: Apr 2004 Location: Medford, MA Posts: 4,219 Thanks: 286 Thanked 1,693x in 530 posts	How does one get the tables created in ACCESS

05-16-2006, 11:12 AM	#33 (permalink)
MorseMoose Hall Of Famer Join Date: Dec 2005 Posts: 4,835 Blog Entries: 4 Thanks: 162 Thanked 167x in 116 posts Infractions: 1/1 (1)	. I don't know anything about this stuff...so to keep with the tradition of me complaining...WHY IS THERE NO : DAY 16 in the title? __________________ [Referring to rich12545] Yoda: Fear is the path to the dark side. Fear leads to anger. Anger leads to hate. Hate leads to suffering. [Referring to rich12545] Princess Leia: But, why must you confront him? Luke: Because, there is good in him. I've felt it. He won't turn me over to the Emperor. I can save him. I can turn him back to the good side. I have to try

05-16-2006, 11:18 AM	#37 (permalink)
Zubes Major Leagues Join Date: Sep 2005 Location: Chicago, IL Posts: 361 Thanks: 0 Thanked 0x in 0 posts	i have been waiting for this for sometime as well, thanks Marc! I will be interested to see all the programmers that take advantage of this and start working. My php/MYSQL knowledge is limited, but hopefully i know enough to get started. __________________ Phil Zuber Beyond the Ivy - Commish, Twins GM Stars and Stripes Baseball League - Cubs GM Bricks and Ivy - Orioles GM Sim Coalition - co-founder

05-16-2006, 11:23 AM	#40 (permalink)
rdomico All Star Reserve Join Date: Mar 2002 Location: Monaca, PA Posts: 661 Thanks: 39 Thanked 20x in 12 posts	This is cool. As a programmer, I can easily do reports and other cool stuff if all the data is in Access or MySQL. I might actually do some cool third party utilities if I have time and if I can think of one. I am sure others will have good ideas.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode