Display the last pictures on vbulletin index.php

[familiabierstedt]

Hello, I like to ask how can I display the last published fotos in my vbulletin 3.6.4 forum startpage? I like to tease the visitors to open the photo gallery.
Thanks in advance.

[Chuck S]

This thread should assist you

http://www.photopost.com/forum/showthread.php?t=122207

[familiabierstedt]

Chuck, thank you for your answer.

I am using two different data bases. One for photpost and one for vbulletin. Both are using same user table for registration.

My problems are:

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/httpd/docs/*****/photopost/inc_features.php on line 67

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/httpd/docs/*****/photopost/inc_features.php on line 143

I have seen on your threads and answers that you recommend to install photopost into vbulletin database.

My question is: Is there still a possibilty that can I integrate

inc_photopost.php ("is used to integrate a gallery listing into your forums")
inc_features.php ("is used to add a "featured photos" box to your Main Index")

into vbulletin?

P.S. ***** = folder (deleted the name here in the tread)

[familiabierstedt]

Sorry I just found following and I will try it.

1) Assuming you have already configured your config-int.php file, you can modify the first section in inc_photopost.php and inc_features.php to customize your layout. Follow the instructions in the Configuration section for any options which you can set.

If you have PhotoPost and vB in different databases, you'll need to scroll to the bottom of the script and uncomment the mysql_select_db() command (on line 26) and insert your vB database name and uncomment the mysql_select_db on line 310 and add your vB3 database in quotes. If your username password is different to connect to the databases then you will need to uncomment the $link statement and fill in the proper variables for the host username and password to access the photopost database

[familiabierstedt]

I changed in_features.php as followed

// If you use the same userid/password to access both databases, you don't need to
// uncomment the mysql_connect - this is only if you require different ids to access
// the PhotoPost database.
//
$link = mysql_connect ("myhost", "$Databasephoto", "$Passwordphoto") or die('I cannot connect to the database.');

mysql_select_db ("Databasphoto")or die("Could not select photopost database");

// If you use PhotoPost in a seperate database from vB, you'll need to reselect the vB database!
mysql_select_db ("Databasevbulletin");

But I am still receiving the error message "Could not select photopost database"

What is wrong?

$link = mysql_connect ("myhost", "$Databasephoto", "$Passwordphoto") or die('I cannot connect to the database.');

mysql_select_db ("Databasphoto")or die("Could not select photopost database");

$links = Access information to vBulletin or photopost?
mysql_select_db ("Databasphoto")or die("Could not select photopost database"); = Access information to vBulletin or photopost?

[familiabierstedt]

I like to post my question again.

Question:

1.) $links
What Access information do I need? vBulletin or photopost?

2.) mysql_select_db ("???")or die("Could not select photopost database")
What Access information do I need? vBulletin or photopost?

[Chuck S]

// If you use the same userid/password to access both databases, you don't need to
// uncomment the mysql_connect - this is only if you require different ids to access
// the PhotoPost database.
//

At the top you need to enter all photopost database info. at the bottom line you enter the vb database info.