StatsLab SQL Utilities for OOTPX - Page 13

griffeyin98 · 12-31-2009, 02:46 PM

so where do I "dump" the free agents into the draft pool?

wkelly73 · 12-31-2009, 04:41 PM

Every time I go to the admin page it appends a new '\' to my SQL Folder Path... so that I end up with \\\\\\\\\nawinfs03\\\\\\\\\home\\\\\\\\\etc...

Anyone have an idea what that would happen?

snnort · 12-31-2009, 06:45 PM

Quote:

Originally Posted by Cooleyvol

Dump the Free Agents to the inaugural draft and it works. I did this for Hardball Heroes.

I got it to work... freaking awesome!

griffeyin98 · 01-01-2010, 12:43 AM

so do i dump them into the draft pool in ootp or inside of statslab?

snnort · 01-01-2010, 03:10 PM

Quote:

Originally Posted by griffeyin98

so do i dump them into the draft pool in ootp or inside of statslab?

As always... make a backup of the OOTP league in question and then click the "dump all players into an inaugural draft" button.

Then make all the neccesary SQL file dumps and import them into StatsLab. Start messing around with the Draft in StatsLab and you'll notice that the same players in your inaugural draft in OOTP are also in the StatsLab draft pool.

griffeyin98 · 01-01-2010, 08:13 PM

i've never seen that button "dump all player into amateur draft"

can someone help direct me to it? thanks

udbacker58 · 01-01-2010, 08:31 PM

Hey guys, I'm trying to help someone set up StatsLab for his league. I don't know what I'm missing but I have to have forgotten something.

Here's a link to the login page with the warnings - OOTP SQL Utilites Login Page - StatsLab for OOTPX

Any help is appreciated. I'm just fried right now and can't figure out what (likely simple) mistake I've made. The settings seem right in the install.php

snnort · 01-01-2010, 08:44 PM

Quote:

Originally Posted by griffeyin98

i've never seen that button "dump all player into amateur draft"

can someone help direct me to it? thanks

Game -> Game Setup
League Setup

It's the third option down the listed buttons on the right... labeled:
"Release all players & schedule inaugural draft"

griffeyin98 · 01-01-2010, 11:35 PM

i see, i'm attempting to just put the current free agents (we contracted) into the inaugural draft, not release all the players and then dump them.

snnort · 01-01-2010, 11:41 PM

Quote:

Originally Posted by griffeyin98

i see, i'm attempting to just put the current free agents (we contracted) into the inaugural draft, not release all the players and then dump them.

Yeah... you're gonna have to run that draft manually on a forum or something.
There is no way (that I know of) to tell the OOTP engine to set up a draft for the remaining teams to participate in using the released players from contracted teams. AND since the OOTP engine can't setup that kind of draft... then StatsLab is not going to have any way to set up a draft like that unless you start editing MySQL files ... A LOT! That's a bunch of work that seems like more than it's worth to me. Since you don't have that many rounds worth of players to worry about... I would just set up a 3 to 5 round draft... start taking lists from your remaining teams managers, and knock that out in a weekend.

udbacker58 · 01-02-2010, 01:09 AM

Quote:

Originally Posted by udbacker58

Hey guys, I'm trying to help someone set up StatsLab for his league. I don't know what I'm missing but I have to have forgotten something.

Here's a link to the login page with the warnings - OOTP SQL Utilites Login Page - StatsLab for OOTPX

Any help is appreciated. I'm just fried right now and can't figure out what (likely simple) mistake I've made. The settings seem right in the install.php

Well, created my own settingsSQL.text and dbopen.php files and no longer have the error messages that I once had but I can't get the SQLs to load.

griffeyin98 · 01-02-2010, 03:19 PM

Quote:

Originally Posted by snnort

Yeah... you're gonna have to run that draft manually on a forum or something.
There is no way (that I know of) to tell the OOTP engine to set up a draft for the remaining teams to participate in using the released players from contracted teams. AND since the OOTP engine can't setup that kind of draft... then StatsLab is not going to have any way to set up a draft like that unless you start editing MySQL files ... A LOT! That's a bunch of work that seems like more than it's worth to me. Since you don't have that many rounds worth of players to worry about... I would just set up a 3 to 5 round draft... start taking lists from your remaining teams managers, and knock that out in a weekend.

thats what i figured, just thought i'd see if there was a way to run it through statslab and make my life easier. Forum based should be too difficult.

snnort · 01-02-2010, 03:50 PM

Quote:

Originally Posted by griffeyin98

thats what i figured, just thought i'd see if there was a way to run it through statslab and make my life easier. Forum based should be too difficult.

Forum based for just a few rounds won't be that bad. You could always do a live chat session for 3 rounds too and accept lists for people that can't be there. Back in the days of OOTP 4, 5, and 6.5 that is how we always had to do it in the CDBL and BCBL and it was a 2-3 hour process sometimes, we'd give each manager a 2 minute timer. And then had a couple helpers to work 3 or 4 lists from other managers. Manning more than 4 lists becomes a lot of work. AND you could give the guys manning the list an extra minute or two when it's their teams pick, since they are working overtime.

It's a lot of work, but it also was cool to have 12-15 managers from the league hanging out in a chatroom for a few hours.

Troy30 · 01-02-2010, 11:31 PM

Quote:

Originally Posted by udbacker58

Well, created my own settingsSQL.text and dbopen.php files and no longer have the error messages that I once had but I can't get the SQLs to load.

Anything on this fellas?

snnort · 01-03-2010, 05:50 AM

I have found that using StatsLab for an Inaugural Draft is not as clear cut and dry as an AMMY DRAFT. Basically the draft will not begin when you want it to, it will simply begin the next day. It completely ignores any date you set as the start date. It also will not allow the use of that Serpentine check box feature.

Basically the only way I was able to get the draft date for each pick the way I wanted AND to Serpentine the even numbered rounds.... I had to manually edit the files inside of MySQL. Well I imported them into MS Excel then exported them out to a CSV file, and then imported that back into MySQL. It was crude and cumbersome, but it looks like our Inaugural Draft is set to start on Wednesday.

Anyone else use StatsLab for an Inaugural Draft and have a different experience. Just want to know if I am crazy or not.

TheDelChop · 01-04-2010, 01:35 PM

Guys,

I get an error when I try to update player development. The same error is repeated again and again.

"Unknown column 'pitching_ratings_misc_ground_fly' in 'field list' "

Which then ends with the following error:

"Fatal error: Maximum execution time of 30 seconds exceeded in /home/majorlea/public_html/utility/gen_functions.php on line 38"

Can anybody tell me what I'm doing wrong?

Joe

snnort · 01-04-2010, 01:52 PM

Has anyone successfully installed StatsLab on a MS-Windows Server 2003 OS?

All my experience in MySQL based stuff is with a Linux based OS. I'm wondering if there are tricks with Win Server 2003 I need to know.

udbacker58 · 01-04-2010, 08:56 PM

Quote:

Originally Posted by udbacker58

2) Would it be possible to get a Through, After, Equal choice on the year setting in the leaderboards in a future patch? It is sweet to be able to see who has the most HR after age 40; but it would also be neat to see who has the most wins since year X.

Quote:

Originally Posted by fhomess

They should show up if you run the career metrics (Career Position, Ink Scores/HOF Monitor).

Will be in the next patch.

Dang, was hoping this would be in the new patch. Oh well, still an amazing utility and great service. Thank you very much for your efforts!

snnort · 01-11-2010, 12:10 AM

Quote:

Originally Posted by snnort

Has anyone successfully installed StatsLab on a MS-Windows Server 2003 OS?

All my experience in MySQL based stuff is with a Linux based OS. I'm wondering if there are tricks with Win Server 2003 I need to know.

No go on this one? I'm trying to help out the tMBU with setting up StatsLab for them. Anyone have success with StatsLab running on Windows 2003 Server?

f.montoya · 01-13-2010, 09:05 AM

Just wanted to say that I installed Statslab for the first time and must admit, it is pretty cool. Although I set it up for my personal use and for fun, I decided to share the video of my installation process. It turns out that there are a lot of steps but it is definitely easier than the instructions make it seem. (Not that I could do any better at writing instructions)

Anyway, take a look...

http://www.ootpdevelopments.com/boar...ml#post2886231

01-01-2010, 08:31 PM	#247
udbacker58 All Star Starter Join Date: Apr 2007 Posts: 1,140	Hey guys, I'm trying to help someone set up StatsLab for his league. I don't know what I'm missing but I have to have forgotten something. Here's a link to the login page with the warnings - OOTP SQL Utilites Login Page - StatsLab for OOTPX Any help is appreciated. I'm just fried right now and can't figure out what (likely simple) mistake I've made. The settings seem right in the install.php __________________ Heartland Baseball League Commissioner Fictional - Stats Only - 30 years of History! HBL HOME PAGE \| HBL REPORTS HOME \| HBL UTILITIES HOME

01-04-2010, 01:35 PM	#256
TheDelChop Bat Boy Join Date: Aug 2007 Posts: 13	Error When updating player development Guys, I get an error when I try to update player development. The same error is repeated again and again. "Unknown column 'pitching_ratings_misc_ground_fly' in 'field list' " Which then ends with the following error: "Fatal error: Maximum execution time of 30 seconds exceeded in /home/majorlea/public_html/utility/gen_functions.php on line 38" Can anybody tell me what I'm doing wrong? Joe

01-13-2010, 09:05 AM	#260
f.montoya Hall Of Famer Join Date: Nov 2004 Posts: 6,069	Just wanted to say that I installed Statslab for the first time and must admit, it is pretty cool. Although I set it up for my personal use and for fun, I decided to share the video of my installation process. It turns out that there are a lot of steps but it is definitely easier than the instructions make it seem. (Not that I could do any better at writing instructions) Anyway, take a look... http://www.ootpdevelopments.com/boar...ml#post2886231 __________________ Fidel Montoya Asahi2 Baseball ex-Commissioner(Historical League Since 2004) www.allsimbaseball.com (OOTP web hosting - Customized sites for online leagues - Sign up, Connect OOTP and Play!) Share Your Mods - Free, unlimited and easy to upload to share your Mods instantly(free site registration required)

12-31-2009, 02:46 PM	#241
griffeyin98 Major Leagues Join Date: Jun 2006 Posts: 311	so where do I "dump" the free agents into the draft pool?

12-31-2009, 04:41 PM	#242
wkelly73 Minors (Single A) Join Date: Mar 2003 Posts: 73	Every time I go to the admin page it appends a new '\' to my SQL Folder Path... so that I end up with \\\\\\\\\nawinfs03\\\\\\\\\home\\\\\\\\\etc... Anyone have an idea what that would happen?

01-01-2010, 12:43 AM	#244
griffeyin98 Major Leagues Join Date: Jun 2006 Posts: 311	so do i dump them into the draft pool in ootp or inside of statslab?

01-01-2010, 08:13 PM	#246
griffeyin98 Major Leagues Join Date: Jun 2006 Posts: 311	i've never seen that button "dump all player into amateur draft" can someone help direct me to it? thanks

01-01-2010, 11:35 PM	#249
griffeyin98 Major Leagues Join Date: Jun 2006 Posts: 311	i see, i'm attempting to just put the current free agents (we contracted) into the inaugural draft, not release all the players and then dump them.

01-03-2010, 05:50 AM	#255
snnort Minors (Triple A) Join Date: Apr 2004 Posts: 272	I have found that using StatsLab for an Inaugural Draft is not as clear cut and dry as an AMMY DRAFT. Basically the draft will not begin when you want it to, it will simply begin the next day. It completely ignores any date you set as the start date. It also will not allow the use of that Serpentine check box feature. Basically the only way I was able to get the draft date for each pick the way I wanted AND to Serpentine the even numbered rounds.... I had to manually edit the files inside of MySQL. Well I imported them into MS Excel then exported them out to a CSV file, and then imported that back into MySQL. It was crude and cumbersome, but it looks like our Inaugural Draft is set to start on Wednesday. Anyone else use StatsLab for an Inaugural Draft and have a different experience. Just want to know if I am crazy or not.

01-04-2010, 01:52 PM	#257
snnort Minors (Triple A) Join Date: Apr 2004 Posts: 272	Has anyone successfully installed StatsLab on a MS-Windows Server 2003 OS? All my experience in MySQL based stuff is with a Linux based OS. I'm wondering if there are tricks with Win Server 2003 I need to know.