StatsLab SQL Utilities for OOTPX

[ootpFox07]

Originally Posted by fhomess

The SQL data dump doesn't give you the level of detail you'd need to get this page generated for past seasons. You can get the batter and pitcher stats, but not the box scores.

Ah Right. A lot gets dumped in the season rollover. I have archives of all my seasons so I could feasibly go back, run the tool against past playoffs and save the HTML, just trying to find a streamlined way, if possible. Thanks.

[snnort]

Originally Posted by rutri01

How do I set up the email settings to sent out notification to the teams?

What do I put in those 2 email setting sections?

email list and reply to list

Originally Posted by snnort

I would be interested to know more about how email has worked for others too, as I've never used it, but would like to for this coming Ammy Draft.

Originally Posted by rutri01

We just installed stats labs and used it for our recent ammy draft. i used the email function and worked well to email each person which team is up and the upcoming list. It worked well and we will use it going forward.

What did you put into those two fields. I mean...
Email List: ???
Reply-to List: ???

Obviously you don't have give me dead on specifics... but in general... what format did you use?

[snake1399]

PM sent, Frank

thanks for the help

Snake

[Cooleyvol]

Originally Posted by snnort

What did you put into those two fields. I mean...
Email List: ???
Reply-to List: ???

Obviously you don't have give me dead on specifics... but in general... what format did you use?

Put the email addresses of your owners in there separated by spaces.

[ootpFox07]

BTW, another big thanks for your efforts as I used to compile team stats for each playoff series manually using the box scores in Excel and your playoff tool will now save me that effort.

[gollum65]

Hi all. I just upgraded to the latest patch. I'm trying to turn on offseason awards voting but the utility won't let me. Every time I check the box to enable voting and hit save it comes back with the box unchecked.

Thanks.

[fhomess]

Originally Posted by gollum65

Hi all. I just upgraded to the latest patch. I'm trying to turn on offseason awards voting but the utility won't let me. Every time I check the box to enable voting and hit save it comes back with the box unchecked.

Usually, this is related to file/folder permissions. The settings get saved in a text file on your server. If it can't read/write the existing one, then you'll see this behavior.

[rutri01]

Originally Posted by snnort

What did you put into those two fields. I mean...
Email List: ???
Reply-to List: ???

Obviously you don't have give me dead on specifics... but in general... what format did you use?

This is what confused me- you just need to list everyones email. I put everyone emails in both. Not sure if you need to but I did. It took a while but eventually it starts sending out emails after each picks.

Originally I had just put mine in and i didn't get an emaiol after someone picked. So I don't know if I didn't wait long enough because i also activated an email option on my website. Not sure if that had anything to do with it but after I did this and put in all the email addresses in- it started to work after a while. I try putting a few email addresses in including your and see what happens.

Edit-FYI- seperate the email addresses by commas.

[gollum65]

Originally Posted by fhomess

Usually, this is related to file/folder permissions. The settings get saved in a text file on your server. If it can't read/write the existing one, then you'll see this behavior.

Thanks for the response. So I went into the settings folder and set asConfig.txt, awConfig.txt and devConfig.txt all to 777 permissions. Now I can set the awards voting flag to on and it sticks. But there are no players to vote for.

[rutri01]

Originally Posted by gollum65

Hi all. I just upgraded to the latest patch. I'm trying to turn on offseason awards voting but the utility won't let me. Every time I check the box to enable voting and hit save it comes back with the box unchecked.

Thanks.

oops- you got an answer from the master

[rutri01]

Originally Posted by Cooleyvol

Put the email addresses of your owners in there separated by spaces.

I used commas- I didn't know spaces works too

[fhomess]

Originally Posted by gollum65

Thanks for the response. So I went into the settings folder and set asConfig.txt, awConfig.txt and devConfig.txt all to 777 permissions. Now I can set the awards voting flag to on and it sticks. But there are no players to vote for.

Try adjusting your settings. Players don't always qualify under the settings you think they would. If you want me to take a look, shoot me a PM with commish access credentials to your install.

[gollum65]

I think they're all set to default. And they worked last season for us. All we did was update the util to the latest version. Just to confirm, once the regular season is over you should have players to vote for right? We just finished our regular season but haven't done our playoffs yet.

[jmantemp]

I love StatsLab and have been using it for my online league that just has a few players who make moves exclusively online. It's given them a ton of data they wouldn't otherwise have in the HTML reports.

I had one question about the Development Tracker. Would it be possible when you're looking at the Yearly development to combine all the individual ratings changes into one big one so instead of Eye being on the chart say 3 times it's only there one with the aggregate change over the year?

I think that'd be a really helpful addition. Thanks!

[griffeyin98]

all my DH all stars to vote for are pitchers? anyone else have this issue? and how do I fix it?

[vesuvius]

Having trouble setting this up. It simply refuses to seem to load the sql files.

SQLloadlog.txt just has this :
Done Loading SQL Files: 0 files loaded in -1266527978 seconds

My manager_load.txt seems to indicate that it loaded all my managers,
INSERT INTO ootp_sql_users (human_manager_id,username,password) VALUES ('1','Eric Wedge',PASSWORD('baseball')) ON DUPLICATE KEY UPDATE username='Eric Wedge';

however, on my login page there are no users in the drop down, and if i go back to my admin page, it won't let me load it because i'm not logged in as admin.

Any ideas?

[BretRock]

Quick question re: All-Star Voting --

Everything is working correctly except that all pitchers are showing up as relievers and there are no starters...

I currently have the following settings:

Min. IP for Starters - 5
Min. IP for Relievers - 1
Min. Games Started Ratio for Starters - 1/1
Max. Games Started Ratio for Relievers - 3/1

I think I am just having some issues trying to figure out what the bottom two should be set to, guess I am having trouble wrapping my head around it.

Any assistance is greatly appreciated.

Bret

[CommishJoe]

Looks very nice. Great job!!

[fhomess]

Originally Posted by BretRock

Quick question re: All-Star Voting --

Everything is working correctly except that all pitchers are showing up as relievers and there are no starters...

I currently have the following settings:

Min. IP for Starters - 5
Min. IP for Relievers - 1
Min. Games Started Ratio for Starters - 1/1
Max. Games Started Ratio for Relievers - 3/1

I think I am just having some issues trying to figure out what the bottom two should be set to, guess I am having trouble wrapping my head around it.

Any assistance is greatly appreciated.

Bret

Check the documentation on these settings. The Min IP is IP/team game, not per appearance.

[udbacker58]

I want past GMs and GMs on the waiting list to be able to vote on the All-Star ballots so I checked the 'Allow Non-GM's To Login' box and have uploaded new SQL files. When I look at the admin page for the voting, I see the guys who don't have a team, but when I try to log in, they do not show up on the drop down. Anyone know why this is?