Help with script.

[stuart1010]

Hello I have recived a script from a friend of mine to set up for him and was wondering how to get it working on his site.
The script he has is for a PTC (Pay to click) site.

The readme file includes
- create the table with the database.txt dump info
- modify the config.php and /admin/config.php files
- Upload all the files
- Configure Paypal email and sitename from administration
- Default account for admin section is
user: admin
pass: ******


The config files say.
<?php
// Database configuration
$bd_host = "localhost";
$bd_usuario = "username";
$bd_password = "pass";
$bd_base = "database";
$url = "http://www.yoursitehere.com";
$con = mysql_connect($bd_host, $bd_usuario, $bd_password); mysql_select_db($bd_base, $con);
?>


If any one could help me and tell me how to create this and get it working the help would be appreciated.

THank you.

[garrettroyce]

Using CPanel go to MySQL Database Wizard.

Create database using whatever name you want. It will be named like username_dbname where username is your CPanel login and dbname is what you typed in the box. Next, create a user with whatever name you want. Again, it will be like username_user. Set the password. Give the user all privileges on the next section.

Then, add the information you just created to the php file.

[stuart1010]

For the database you can't use under scores and what box are you talking about exactly.

[garrettroyce]

the underscores are automatic. For example, if you type in: database, your database name is username_database where "username" is your cpanel user name. The box is the one that says "new database" Make sure you use the MySQL wizard and not MySQL databases tool. They have the same icon.

[stuart1010]

sorry never mind about that last bit
but what do i do after i create the database where do i put the information from the php file

[garrettroyce]

edit the php file like this:

<?php
// Database configuration
$bd_host = "localhost"; // leave this the same
$bd_usuario = "username"; // change this to the database name, example: username_user
$bd_password = "pass"; // password for username_user
$bd_base = "database"; // database you created, example: username_database
$url = "http://www.yoursitehere.com"; // this is the url of your site, example: http://site.x10hosting.com
$con = mysql_connect($bd_host, $bd_usuario, $bd_password);
mysql_select_db($bd_base, $con);
?>

[stuart1010]

where do i upload what do i upload all of the files to public_html
is it ok if .php files are in here

[batman1]

upload all the files but the config file.

Login you server control panel.

Use the database panel to Create a MYSQL:

1. database - example "mysite_accounts"
2. username - example "mysite_john"
3. password - example "VcggTf23"

add the user to the database

edit the config files info

$bd_host = "localhost";
$bd_usuario = "mysite_john";
$bd_password = "VcggTf23";
$bd_base = "mysite_accounts";

save and upload the config file. Done

[stuart1010]

thank you both for the help.
now i have a new problem if you look at my site it is all full of errors like this Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/stuart10/public_html/index.php on line 12

do i need to change all the php files to work with the database ?

[gomarc]

...

The readme file includes
- create the table with the database.txt dump info

After creating the database / user /pass and giving privileges, did you create the table with the database.txt dump?