StatsLab SQL Utilities for OOTPX

[fhomess]

Originally Posted by bayken37

I apologize if this has already been answered, but I was wondering if there is a way to add in the sandwich picks when using the Draft Utility on this mod?

Yes. Schedule your draft for an additional round. Then modify the draft order in round 2 to be your "sandwich pick round" using the Skip Pick links on the draft board.

[Mike Lowe]

Where are the passwords generated from for this utility? Is a GM's password the same as it is in game?

I have a handful of guys who's passwords work in-game but not with the utility.

Is there a way for me to adjust these?

[Alan T]

Originally Posted by Mike Lowe

Where are the passwords generated from for this utility? Is a GM's password the same as it is in game?

I have a handful of guys who's passwords work in-game but not with the utility.

Is there a way for me to adjust these?

I believe the default password in statslab for all owners is:

baseball

In your admin screen you should be able to reset a user's password back to default password if they forget it

[dangarion]

Is there any reason why all the passwords would all the sudden stop working? And how can I go about fixing that?

[fhomess]

Originally Posted by dangarion

Is there any reason why all the passwords would all the sudden stop working? And how can I go about fixing that?

Actually, yes. I've seen this happen a few times where a host has changed the encryption protocol used. The only recourse is to reset all the passwords from the Admin page (or using a SQL command directly into the DB if you know how to do that).

[dangarion]

Originally Posted by fhomess

Actually, yes. I've seen this happen a few times where a host has changed the encryption protocol used. The only recourse is to reset all the passwords from the Admin page (or using a SQL command directly into the DB if you know how to do that).

Ok well... Since the passwords all don't work, that means the admin password won't work either. I tried deleting the password in MySQL and logging in and that didn't work. How would I go about running a command to reset them?

[fhomess]

Originally Posted by dangarion

Ok well... Since the passwords all don't work, that means the admin password won't work either. I tried deleting the password in MySQL and logging in and that didn't work. How would I go about running a command to reset them?

Naturally...

PM sent with instructions.

[DWK]

I'm having a problem with Logos not showing up. I hit "Capitalize Team Logos" and nothing happens.

Other than that everything else works fine

[fhomess]

Originally Posted by DWK

I'm having a problem with Logos not showing up. I hit "Capitalize Team Logos" and nothing happens.

Other than that everything else works fine

Looks like your HTML reports have the same problem. Make sure you've loaded all the different sized versions of the logos to your website. For example, you only have san_diego_padres.png. You should have san_diego_padres_110.png, san_diego_padres_90.png, san_diego_padres_40.png, etc.

[Goody]

I am totally stumped after spending over 4 hours at least trying to figure out my problem installing StatsLab. I'm getting the same thing that Stu was getting, with the file permissions.

I've checked them and checked them again. Both the folders are at 755 and the files are at 644.

I've had two other apps running off of SQL databases that work. A phpBB board and drupal.


My last idea is maybe something to do with .htaccess file? Since drupal is installed directly into the root directory "public_html" I think it modified the .htaccess file to increase its security. But if this is the case it seems it would have broken my phpBB board, which it didn't. If it is the case I wouldn't have any idea what lines to add the .htaccess to allow the app permissions.


Like Stu, after changing both folders to 777 I was able to get a bit further, but still had lots of errors popping up.

[Ramzavail]

OOTP SQL Utilites Login Page - StatsLab for OOTPX

okay, I'm close. I guess. However, I see an issue with the username dropdown.

[Goody]

Originally Posted by Ramzavail

OOTP SQL Utilites Login Page - StatsLab for OOTPX

okay, I'm close. I guess. However, I see an issue with the username dropdown.

You have to go to the admin page now and upload the sql dump.

Change install.php or login.php to admin.php in the URL.

I wish mine looked like that! Still can't get it working so trying to get an allsimbaseball site. This has been one frustrating process!

[Ramzavail]

Ok I think I dumped some sql but now I get the ...You must be a commisioner to access this page

http://www.theamazinmess.com/ootpsqlou/admin.php

[Goody]

Originally Posted by Ramzavail

Ok I think I dumped some sql but now I get the ...You must be a commisioner to access this page

http://www.theamazinmess.com/ootpsqlou/admin.php

Now edit the URL back to /login.php and login as the commish and change your password.

[Ramzavail]

there are no user names to choose from. on that login page.

[DWK]

Originally Posted by fhomess

Looks like your HTML reports have the same problem. Make sure you've loaded all the different sized versions of the logos to your website. For example, you only have san_diego_padres.png. You should have san_diego_padres_110.png, san_diego_padres_90.png, san_diego_padres_40.png, etc.

I've try all that and I get 2 Logos to work (Reds, Braves). Is there something that I'm missing?

[Ramzavail]

Originally Posted by DWK

I've try all that and I get 2 Logos to work (Reds, Braves). Is there something that I'm missing?

make sure the names are lower case.

[fhomess]

Originally Posted by Ramzavail

there are no user names to choose from. on that login page.

There's an error with the query that loads the managers on the login page. This is due to one of three tables not being there:
human_managers
teams
ootp_sql_users

Since it's requiring that you be a commish to access the admin page, and it's got a commish on the managers page, it's probably that you never loaded the teams table. You'll need to go to your SQL admin and remove the ootp_sql_users table using a drop command, and then make sure you've loaded all the tables required by the util.

Originally Posted by DWK

I've try all that and I get 2 Logos to work (Reds, Braves). Is there something that I'm missing?

Yes, you're still missing all the logo files that have alternate sizes except for the Reds and Braves. Go into your HTML images folder and you'll see that san_diego_padres_40.png is not loaded to your website (nor any of the other sizes). This is true for the rest of the major league teams, too.

Originally Posted by Goody

I am totally stumped after spending over 4 hours at least trying to figure out my problem installing StatsLab. I'm getting the same thing that Stu was getting, with the file permissions.

Given what you've said above, the permissions look ok. I really can't help you further without a link to your site to see what errors you're getting. If you don't feel comfortable posting it here, feel free to PM me. FWIW, I'm getting closer to releasing an OOTP11 version of StatsLab which will do away with all these permissions requirements, and it should be functional for OOTPX as well.

Generally speaking, anyone who needs help with their StatsLab install should either post or PM me a link directly to their install. NOT to your website's main page, as many of you do not have links to StatsLab that are accessible to guests.

[Ramzavail]

I dropped that table, heck, I cleared out the whole database and now I'm getting an error when I try to Load the SQL files. So I'm stuck.

[Goody]

Thanks fhomess. It was something with my host. I got it set up on some allsimbaseball webspace just fine.