Home | Webstore
Latest News: OOTP 26 Available - FHM 12 Available - OOTP Go! Available

Out of the Park Baseball 26 Buy Now!

  

Go Back   OOTP Developments Forums > Out of the Park Baseball 26 > OOTP Mods > OOTP Mods - Database Tools

OOTP Mods - Database Tools Do you need to take a dump? SQL gurus welcome

Reply
 
Thread Tools
Old 02-14-2011, 06:39 PM   #201
fhomess
Hall Of Famer
 
fhomess's Avatar
 
Join Date: Nov 2002
Posts: 3,648
Quote:
Originally Posted by cody8200 View Post
Sorry for the bump but I was hoping you might be able to look at this Frank.
Make sure that your HTML Path and HTML Root settings are correct on your admin page. Also make sure your images folder is readable by all users. The code that checks for the existence of the image is particularly fussy.

Quote:
Originally Posted by cody8200 View Post
Frank,

I believe I have had some type of bug hit me. Please look here.

Player Report for #25 Stanley Noble - StatsLab for OOTP11

I am having all of the 2013 all stars show up as being all stars twice in 2013. Any idea how I can fix this? A reload of data or something?
I can't say for certain without looking at your database, but it looks to me like the All-Star information got stored twice, in which case it'll do this. This can happen if there was an issue inside OOTP, but it could also happen if you loaded the tables in split file format and loaded them twice.
__________________
StatsLab- PHP/MySQL based utilities for Online Leagues
Baseball Cards - Full list of known templates and documentation on card development.
fhomess is offline   Reply With Quote
Old 02-14-2011, 09:54 PM   #202
cody8200
Hall Of Famer
 
cody8200's Avatar
 
Join Date: Jan 2003
Location: Indianapolis
Posts: 2,436
Thanks Frank! I got the picture thing fixed. Any way to fix the all star issue? Do I need to edit the database or something or will reloading work?
__________________
Sharp Guys Web Design -
Twitter: @sharpguysweb
cody8200 is offline   Reply With Quote
Old 02-15-2011, 02:06 AM   #203
fhomess
Hall Of Famer
 
fhomess's Avatar
 
Join Date: Nov 2002
Posts: 3,648
Quote:
Originally Posted by cody8200 View Post
Thanks Frank! I got the picture thing fixed. Any way to fix the all star issue? Do I need to edit the database or something or will reloading work?
Try reloading players_awards.mysql.sql first. If that doesn't work, I can look at the file to see if it's actually an issue with the DB by looking at that file.
__________________
StatsLab- PHP/MySQL based utilities for Online Leagues
Baseball Cards - Full list of known templates and documentation on card development.
fhomess is offline   Reply With Quote
Old 02-17-2011, 12:19 PM   #204
mikev
Hall Of Famer
 
mikev's Avatar
 
Join Date: Dec 2004
Location: Bay Area, CA
Posts: 4,014
I know I'm being whiny, but is there any way to implement a Rule 5 draft?
__________________
Global Unified Baseball Association - Vice Commish and Oakland Oaks GM
mikev is offline   Reply With Quote
Old 02-18-2011, 05:30 PM   #205
mjj55409
All Star Starter
 
mjj55409's Avatar
 
Join Date: Jun 2002
Posts: 1,166
Anyone have a clue why I'm not getting graphs displayed? Something missing server side?

Season Graphs - StatsLab for OOTP11
__________________
FABL -- Chicago Chiefs
mjj55409 is offline   Reply With Quote
Old 02-21-2011, 05:47 PM   #206
patriotcoach
Minors (Double A)
 
Join Date: Apr 2002
Posts: 184
Hello Frank. Due to popular demand I am trying to switch my league from using OOTPU to StatsLab and have run into a a couple of problems trying to install the program:

1) I have none of my league images showing in StatsLab.

2) When I have tried to load my SQL files from the Admin Section I get the following error

ERROR in league_history_batting_stats:
insert into `league_history_batting_stats` VALUES (0, 0, 0, 0, 0, 0, 87032, 77965, 20783, 15309, 0, 0, 4131, 388, 2560, 1541, 542, 0, 10938, 7694, 0, 725, 0, 648, 0, 0, 2270, 0, 7079, 0, 0.2666, 0.3355, 0.4280, 11961.8121, 5.5329, 0.1614, 1.#INF, 0.7635, 73.9798, 0.0000, 0.0000); -> You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
ERROR in league_history_batting_stats:
insert into `league_history_batting_stats` VALUES (0, 0, 0, 0, 0, 0, 98393, 87884, 22741, 18282, 0, 0, 4606, 561, 2482, 1429, 591, 0, 11481, 8926, 0, 865, 0, 718, 0, 0, 2590, 0, 7649, 0, 0.2588, 0.3306, 0.4087, 12755.6118, 5.1827, 0.1499, 1.#INF, 0.7393, 70.7426, 0.0000, 0.0000); -> You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

Warning: Cannot modify header information - headers already sent by (output started at /home/mlnbbase/public_html/StatsLab/db_update.php:207) in /home/mlnbbase/public_html/StatsLab/db_update.php on line 302

When I hit the back button though it shows that 61 files loaded in 150 seconds.

If anybody could help I would be appreciative.

I am always on AIM: VGCoachB
patriotcoach is offline   Reply With Quote
Old 02-21-2011, 08:01 PM   #207
patriotcoach
Minors (Double A)
 
Join Date: Apr 2002
Posts: 184
Okay I think part of my image problem has to do with the links to my html reports. Here is what the link is:

http://www.mlnbbaseball.com/StatsLab..._100_home.html

where the link should just be:

http://mlnbbaseball.com/news/html/le..._100_home.html

I can't figure out the setting that will change this link.
patriotcoach is offline   Reply With Quote
Old 02-21-2011, 08:07 PM   #208
mjj55409
All Star Starter
 
mjj55409's Avatar
 
Join Date: Jun 2002
Posts: 1,166
Quote:
Originally Posted by patriotcoach View Post
Okay I think part of my image problem has to do with the links to my html reports. Here is what the link is:

http://www.mlnbbaseball.com/StatsLab..._100_home.html

where the link should just be:

http://mlnbbaseball.com/news/html/le..._100_home.html

I can't figure out the setting that will change this link.
On the Admin page, HTML Root and HTLM Path.

__________________
FABL -- Chicago Chiefs
mjj55409 is offline   Reply With Quote
Old 02-21-2011, 08:30 PM   #209
patriotcoach
Minors (Double A)
 
Join Date: Apr 2002
Posts: 184
I have both of those set correctly.
patriotcoach is offline   Reply With Quote
Old 02-21-2011, 08:39 PM   #210
Cooleyvol
Hall Of Famer
 
Cooleyvol's Avatar
 
Join Date: Dec 2001
Location: Union City, TN
Posts: 6,383
Quote:
Originally Posted by patriotcoach View Post
I have both of those set correctly.

Your root setting is likely wrong in some way if the path to the images is not working.

This is likely what you have input: /StatsLab/mlnbbaseball.com/news/html/leagues

That's not correct. Try something like home/USERNAME/public_html

Last edited by Cooleyvol; 02-21-2011 at 08:41 PM.
Cooleyvol is offline   Reply With Quote
Old 02-21-2011, 08:51 PM   #211
mjj55409
All Star Starter
 
mjj55409's Avatar
 
Join Date: Jun 2002
Posts: 1,166
We figured it out; it was his server URL setting.

And now that we have some eyeballs on this thread, does anyone have a clue about my problem of the graphs not displaying?
__________________
FABL -- Chicago Chiefs
mjj55409 is offline   Reply With Quote
Old 02-21-2011, 09:06 PM   #212
patriotcoach
Minors (Double A)
 
Join Date: Apr 2002
Posts: 184
Thanks mjj55409 for fixing my server URL. If anybody has any expertise on putting widgets on Wordpress your help would be greatly appreciated
patriotcoach is offline   Reply With Quote
Old 02-22-2011, 01:17 AM   #213
fhomess
Hall Of Famer
 
fhomess's Avatar
 
Join Date: Nov 2002
Posts: 3,648
Quote:
Originally Posted by mjj55409 View Post
Anyone have a clue why I'm not getting graphs displayed? Something missing server side?

Season Graphs - StatsLab for OOTP11
Perhaps your PHP install doesn't have the GD library installed or enabled. If you shoot me a PM with commish access to StatsLab I can check.
__________________
StatsLab- PHP/MySQL based utilities for Online Leagues
Baseball Cards - Full list of known templates and documentation on card development.
fhomess is offline   Reply With Quote
Old 02-23-2011, 01:27 PM   #214
BleedingCubbyBlue
All Star Reserve
 
BleedingCubbyBlue's Avatar
 
Join Date: Jun 2003
Location: Gurnee, IL
Posts: 601
Quote:
Originally Posted by patriotcoach View Post
Thanks mjj55409 for fixing my server URL. If anybody has any expertise on putting widgets on Wordpress your help would be greatly appreciated
Install a widget called "PHP Widget" on WordPress then use simple PHP to include whatever StatsLab widget file you want. See below for code example.

Code:
<?php include("/FULL/SERVER/PATH/htdocs/STATSLAB/lg_100_sl_0_div_1_standings.wgt"); ?>
<hr />
__________________

BleedingCubbyBlue is offline   Reply With Quote
Old 02-23-2011, 02:41 PM   #215
Cooleyvol
Hall Of Famer
 
Cooleyvol's Avatar
 
Join Date: Dec 2001
Location: Union City, TN
Posts: 6,383
Quote:
Originally Posted by BleedingCubbyBlue View Post
Install a widget called "PHP Widget" on WordPress then use simple PHP to include whatever StatsLab widget file you want. See below for code example.

Code:
<?php include("/FULL/SERVER/PATH/htdocs/STATSLAB/lg_100_sl_0_div_1_standings.wgt"); ?>
<hr />

That code looks familiar, huh, patriotcoach?
Cooleyvol is offline   Reply With Quote
Old 02-23-2011, 03:58 PM   #216
Ktulu
Hall Of Famer
 
Join Date: Feb 2003
Location: BC
Posts: 4,506
Does statslab work with leagues that have ratings turned off and only potential on (ie talent only)? By work I mean is there any possibility for the actual ratings to be displayed anywhere?
__________________
"The ice is getting even more thinner, my friend!"
Ktulu is offline   Reply With Quote
Old 02-23-2011, 04:09 PM   #217
mjj55409
All Star Starter
 
mjj55409's Avatar
 
Join Date: Jun 2002
Posts: 1,166
Quote:
Originally Posted by Ktulu View Post
Does statslab work with leagues that have ratings turned off and only potential on (ie talent only)? By work I mean is there any possibility for the actual ratings to be displayed anywhere?
You have the option to turn off the display of actual/potential ratings in StatsLab, too.
__________________
FABL -- Chicago Chiefs
mjj55409 is offline   Reply With Quote
Old 02-24-2011, 09:57 PM   #218
patriotcoach
Minors (Double A)
 
Join Date: Apr 2002
Posts: 184
Quote:
Originally Posted by Cooleyvol View Post
That code looks familiar, huh, patriotcoach?
Yes it does. My question though is where do I go to install a widget in Wordpress? I have a widget section that has pre-installed widgets but I am not sure how to install this one.
patriotcoach is offline   Reply With Quote
Old 02-25-2011, 12:53 PM   #219
BleedingCubbyBlue
All Star Reserve
 
BleedingCubbyBlue's Avatar
 
Join Date: Jun 2003
Location: Gurnee, IL
Posts: 601
Quote:
Originally Posted by patriotcoach View Post
Yes it does. My question though is where do I go to install a widget in Wordpress? I have a widget section that has pre-installed widgets but I am not sure how to install this one.
PM received and replied to.
__________________

BleedingCubbyBlue is offline   Reply With Quote
Old 02-25-2011, 12:53 PM   #220
BleedingCubbyBlue
All Star Reserve
 
BleedingCubbyBlue's Avatar
 
Join Date: Jun 2003
Location: Gurnee, IL
Posts: 601
Quote:
Originally Posted by Cooleyvol View Post
That code looks familiar, huh, patriotcoach?
Mine's better!
__________________

BleedingCubbyBlue is offline   Reply With Quote
Reply

Bookmarks


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -4. The time now is 09:50 AM.

 

Major League and Minor League Baseball trademarks and copyrights are used with permission of Major League Baseball. Visit MLB.com and MiLB.com.

Officially Licensed Product – MLB Players, Inc.

Out of the Park Baseball is a registered trademark of Out of the Park Developments GmbH & Co. KG

Google Play is a trademark of Google Inc.

Apple, iPhone, iPod touch and iPad are trademarks of Apple Inc., registered in the U.S. and other countries.

COPYRIGHT © 2023 OUT OF THE PARK DEVELOPMENTS. ALL RIGHTS RESERVED.

 

Powered by vBulletin® Version 3.8.10
Copyright ©2000 - 2025, vBulletin Solutions, Inc.
Copyright © 2024 Out of the Park Developments