Reviewpost VB3 Enhanced Index

[Chuck S]

If you plan to integrate ReviewPost into your vB3 Main Index you can now use the included (and supported!) files inc_reviewpost.php and inc_reviews.php

inc_reviewpost.php is used to integrate a review category listing into your forums
inc_reviews.php is used to add a "featured reviews" box to your Main Index

We recommend installing ReviewPost into your vB database, doing so will prevent the need to swtich databases for ReviewPost access.

Installation Instructions
=========================
1) Assuming you have already configured your config-intr.php file, you can modify the first section in inc_reviewpost.php and inc_reviews.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.

2) Upload the scripts to your ReviewPost directory.

These next steps involve changes to your vBulletin script files - this is necessary as you plan to display these items from within your vB forums.

3) In your vB index.php file, you will need to add two lines under under these four:

// ######################### REQUIRE BACK-END ############################
require_once('./global.php');
require_once('./includes/functions_bigthree.php');
require_once('./includes/functions_forumlist.php');
include('../reviewpost/inc_reviews.php');
include('../reviewpost/inc_reviewpost.php');

NOTE ABOVE PATHS ARE EXAMPLES. Change to the actual full path or correct short path.

vB TEMPLATE ADDITIONS
=====================

1) In your vB templates, select Forum Home Templates and edit the FORUMHOME template.

To include the PhotoPost "features" box, add the variable $reviewpostfeature to your template:

$header
$navbar
$reviewpostfeature

This places the feature at the top of the forum

TYPE 1
------
1) Down lower, to add your reviewpost section, add the $reviewpostcats variable under your Main section:

<!-- /main -->
<br />
$reviewpostcats
<br />

You can also place the $reviewpostfeature above the $reviewpostcats if you wish to move your features to just above the reviewpost category section.

TYPE 2
------
1) Down lower, to add your galleries into your forum table, add $reviewpostcats under the $forumbits variable:

Content visible to verified customers only.

Then click SAVE and your Forum Index should be displaying your ReviewPost categories on your forums!

[ericgtr]

I am not having any luck getting this to work, the error I keep getting is:

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/vhfansco/public_html/reviewpost/inc_reviews.php on line 57

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/vhfansco/public_html/reviewpost/inc_reviews.php on line 71

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/vhfansco/public_html/reviewpost/inc_reviews.php on line 109


Here is how I've setup my inc_reviews.php because I have vb in a seperate database:

Content visible to verified customers only.

And this at the bottom:

Content visible to verified customers only.

Any ideas?

[Chuck S]

Your telling the script to look for the reviewpost tables in your vbulletin database???

mysql_select_db ("vhfansco_vb")or die("Could not select reviewpost database");

Also note if the username and password is different to access the two databases you also need to uncomment and fill in this line

//$link = mysql_connect ("localhost", "$dbuserid", "$dbuserpassword") or die('I cannot connect to the database.');

[ericgtr]

Doh.. Okay it's working now but the images from the reviews show up as empty boxes.

[Chuck S]

Did you specify the correct path in config-intr.php to your data directory and did you upload the new images to the reviewpost images directory

[ericgtr]

I belive so, they show up fine in reviewpost itself too. Here's my config-intr.php setting:
// We need to know the server paths to both your vB installation and your ReviewPost installation
$vbpath = "/home/vhfansco/public_html/vb";
$rppath = "/home/vhfansco/public_html/reviewpost";

// We need the URL path to your PhotoPost and vb installation
$rpurl_path = "http://www.guitars101.com/reviewpost";
$vb_urlpath = "http://www.guitars101.com/vb";

// The URL of your photo dir where your images are stored (with / at end)
$rpdata_dir = "/home/vhfansco/public_html/reviewpost/data/";

I am not sure what you mean by "New" images but the images from the install are popuplated in the reviewpost images directory.

[Chuck S]

Your not using vbulletin's index file so there is your issue.

You might need to make it a PHP BLOCK if you want it to appear in vbadvanced

[ericgtr]

Everything on the forumhome works, it links to the right reviews etc. the only thing that doesn't show is the images. That's due to vbadvanced?

[Chuck S]

Right but this modification works by using the forumhome template and including our file on the index.php file of vbulletin. You have no index.php in vbulletin anymore. index.php belongs to vbadvanced now so you need to alter things a bit.

Vbadvanced has the ability to add php blocks to display on its page

Make a default centerblock in vbadvanced admin with contents like this

include('/some/path/to/inc_reviews.php');

echo "$reviewpostfeature";

THATS IT

[ericgtr]

Is there a way to change the call to forumindex.php instead of index.php? I don't mean to make this difficult but the center block part never works right on my forumhome.

[Chuck S]

I am sorry to say this works exactly how it is suppose to!

http://www.reeftalk.com/forums/index.php

I have both featured photos and featured reviews on my vbulletin forumhome.

Your issue is as I stated. Your using Vbadvanced as your index not vbulletin's. I gave you an easy way to include a review block on your main vbadvanced page by making a vbadvanced php block above in my last post.

Otherwise if your going to try to modify the instructions for some other script then you need to do this.

1. include our file in that script your talking about forumindex.php

2. Place in the appropriate template that forumindex.php uses $reviewpostfeature where you want it to display. I can't tell you what template that is since I dont use vbadvanced. I use vbportal and you can see examples of php blocks here

http://www.reeftalk.com

[ericgtr]

I don't mean to imply that this doesn't work as it is supposed to, I am sure it does perfectly and realize this is a special request. Please look at my forumhome here http://www.guitars101.com/vb/forumindex.php and you will see the review post included near the bottom. Again, everything works, even the overlay-roundp.gif it just doesn't display the associated image. I just want to make sure I have explained myself well enough is all It's so close that it appears one little thing (most likely caused by me ) is off.

[Chuck S]

Okay and here is your issue then now that I have a url to look at

In your Reviewpost edit integration options you have your reviewpost url data dir set to a path not url

URL to your ReviewPost DATA directory

[ericgtr]

See, I knew it was something I did! Thanks again for all of your help Chuck, it's working great.

[troller]

I also get this error:

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /reviews/inc_reviews.php on line 56

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /reviews/inc_reviews.php on line 107
Could not select ReviewPost database

This is my inc_reviews.php

/ 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 ReviewPost database.
//
//$link = mysql_connect ("localhost", "user_reviewpost", "pass") or die('I cannot connect to the database.');
//mysql_select_db ("user_reviewpost")or die("Could not select reviewpost database");

The Bottom

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

What is wrong ?

[Chuck S]

If you have reviewpost and vbulletin in separate databases you must follow the instructions above in NOTE 1

[troller]

Hi, yes I did all the steps, but I get always the same error. I don´t know what the problem is. You also saw my posting before..I think those settings are correct.

[Chuck S]

Okay let me post this again.

If you have reviewpost and vbulletin in separate databases you must fill out and uncomment the $link and mysql_select_db lines as noted in NOTE 1 of the installation instructions. Also check your config-int.php and make sure the correct prefix is set

Basically you have not set something stated in the instructions above correct and the two things above are all it can be.

[ncg]

how can i put it into a diffrent template than forumhome? it wont show up.

[Chuck S]

Well if your trying to put it in a different template you need to include the actual file like you do in index.php into the appropriate php file like forumdisplay.php whatever your trying to do