Quote:

---

Omegatron said:
Info/Instructions: Mod assumes PhotoPost and Threads are installed into same database. If you have them in seperate databases, you will need to use a mysql_select_db() to switch to PP and then back to threads in the pppanel.php file.

---

Hi Omegatron,

I have Threads and Photopost using their own separate databases (database names, ie: fa_threads & fa_photopost), and both programs are installed in different folders on the server (ie: www.flightattendants.org/ubbthreads/ ... and ... www.flightattendants.org/photopost/ ...

I've installed the mod, but don't understand where to make the appropriate changes in pppanel.php. When I click on "Insert My Photos Into Post" I get the could not select database error message.

This is how I've currently got it set up in pppanel.php:

//Connecting, selecting database
$link = mysql_connect ("$host", "$user", "$password") or die ('I cannot connect to the database.');
mysql_select_db ("mysql_connect")or die("Could not select database. This feature has not yet been enabled. Please try again later.");


require ("/includes/main.inc.php");


$pp_prefix="";

$data_dir = "http://www.flightattendants.org/photopost/data/" ;

....and at the bottom I uncommented the mysql line as instructed.

Thanks for any advice you can offer!

Jason

--------------------
"Always remember you're unique ...just like everybody else."

Post Extras:

Quote:

---

Zarzal said:
I'm not Omegatron but I try to help You have to edit the pppanel.php. On top you find:

// configure your database settings
$host = "ip or dnsname of host for pp"; // Server Name
$user= "username for pp db"; // Username
$password= "password for pp db"; // Password
$database="databasename of pp db"; // Photopost database name or forum database name

---

Thanks for your input, Zarzal. Unfortunately I still wasn't able to get it working.

// configure your database settings
$host = "here I inserted localhost"; // Server Name
$user= "here I inserted my PP_db username"; // Username
$password= "I inserted my PP db password"; // Password
$database="I inserted my PP_database name"; // Photopost database name or forum database name

Under:

$i=0;
$color = "lighttable";
$photorow="";
$photopanel="";

...I added:

mysql_select_db ("I added my threads_database name here")or die("Could not select database");

...and commented out on the last lines:
//mysql_select_db ("UBBTHREADSDATABASE")or die("Could not select database");

I still get the could not select database error message.

Am I missing something else?

Sorry for not getting it, but thanks for your help!

Jason

Post Extras:

Quote:

---

//Connecting, selecting database
$link = mysql_connect ("$host", "$user", "$password") or die ('I cannot connect to the database.');
mysql_select_db ("mysql_connect")or die("Could not select database. This feature has not yet been enabled. Please try again later.");

---

Thats wrong mysql_select_db ("mysql_connect"....

I append my script here, just modify it for your settings. I have done some little modifications.

Post Extras:

Quote:

---

mysql_select_db ($database)or die("Could not select database"); // switch to PP DB

Do I manually enter my PP database name on this line? I thought $database would pull it from the $database value I entered at the top of the script. No?

---

Quote:

---

Also, if you are not using a database prefix (i.e. pp_), do you enter "0" or just leave it blank between the ""'s?

---

Post Extras: