View Single Post
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