Home | Webstore
Latest News: OOTP 26 Available - FHM 11 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 12-26-2012, 12:30 AM   #1
Dbobola22
Minors (Triple A)
 
Join Date: Jun 2003
Posts: 226
StatsLab13 install question

I'm stuck here, and not sure what exactly to fill in, any help would be appreciated.

8. Edit dbopen.php with your MySQL connection information (host, user, password, and database name)

When I hit edit, i get the following:
<?php
$db = mysql_connect('paramoun_statslab13.paramountbaseba ll.net','paramoun_statsla','mypasswordhere') or die('Could not connect: '.mysql_error());
mysql_select_db('sqldb');
?>


I'm not sure if this part is correct AT ALL.

9. In the StatsLab subfolder, copy cong.txt.sample and rename as config.txt

obviously not a problem here...

10. Edit config.txt with the full server path to your StatsLab install directory. If you’re not sure of the full path, ask your host.

This is what I see:

ADMINPATH|/home/<account>/sql/<league_name>

I need to know what to put here..

11. From your local machine, upload dbopen.php to your SQL upload folder created in step 3.
12. From your local machine, upload your StatsLab subfolder to the StatsLab folder created in step 4

In regards to 11 & 12, I just have 2 questions:
1) Where do I put the these. Should the SQL folder be in the public_html_cgi-bin, a folder created SQL?
2) shoal the StatsLab folder be in the public_html folder?

Once I get past these few parts, I can cruise right to the end I think..

Thanks in advance!
__________________
Commissioner:
Paramount Baseball League (running7-years real time)
American Baseball Legion (a new OOTP18 Startup)
Dbobola22 is offline   Reply With Quote
Old 01-03-2013, 12:51 PM   #2
fhomess
Hall Of Famer
 
fhomess's Avatar
 
Join Date: Nov 2002
Posts: 3,638
Quote:
Originally Posted by Dbobola22 View Post
8. Edit dbopen.php with your MySQL connection information (host, user, password, and database name)

When I hit edit, i get the following:
<?php
$db = mysql_connect('paramoun_statslab13.paramountbaseba ll.net','paramoun_statsla','mypasswordhere') or die('Could not connect: '.mysql_error());
mysql_select_db('sqldb');
?>


I'm not sure if this part is correct AT ALL.
I can't really tell you for sure if you've got it right or not without knowing all the details of your website, but hopefully the following makes sense:
HOST: This should be the server your MySQL database is hosted on. It is NOT your website domain name. If your website is hosted on the same server that you installed StatsLab on, try just entering "localhost", or the server name you use to connect to when you FTP files to your server.
SQLUSER: This is something you configure when you create your MySQL database.
SQLPASSWORD: This is something you configure when you create your MySQL database.
SQLDB: This is something you configure when you create your MySQL database.

Quote:
Originally Posted by Dbobola22 View Post
10. Edit config.txt with the full server path to your StatsLab install directory. If you’re not sure of the full path, ask your host.

This is what I see:

ADMINPATH|/home/<account>/sql/<league_name>

I need to know what to put here..
Your website's files are located in a specific folder on the server. You need to have a dedicated directory into which you put your MySQL files that OOTP generates. The full server path to this directory is what needs to be in config.txt. Your next question relates to this, too.

Quote:
Originally Posted by Dbobola22 View Post
1) Where do I put the these. Should the SQL folder be in the public_html_cgi-bin, a folder created SQL?
You can put this folder anywhere, although it's recommended NOT to put it under public_html. The reason for this is that anything under public_html can potentially be accessed by people browsing the web, and you'll have your dbopen.php file in this directory containing your MySQL access credentials. Creating a dedicated SQL folder outside of public_html is therefore recommended.

Quote:
Originally Posted by Dbobola22 View Post
2) shoal the StatsLab folder be in the public_html folder?
Yes, the StatsLab folder needs to be somewhere inside public_html. Otherwise, people can't access it from the web.
__________________
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
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:19 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