review post and vbadvanced

Andy Winters · March 15th, 2006, 02:34 PM

is there an easy way to have vbadvanced show the latest reviews in a module? using vbadvanced 2.0, vb3.5 and reviewpost.

Chuck S · March 17th, 2006, 06:38 PM

You can try this

Reviewpost VB3 Enhanced Index

You can try setting up a new module called reviews.php and place in your modules folder.

Make the php code something like this

Code:

Content visible to verified customers only.

Then make sure to save the block as clean output and use module shell set to no.

DSades · March 20th, 2006, 12:05 AM

Almost got it to work. I see the header bar, but no actual products--only the bar itself. It looks like this if the member doesn't have permission to view products, but I have permissions set to "Everyone" and I still can't see it. Any ideas why?

Thanks Chuck. Sorry to bother you with all these questions. If/When I get all these things fixed/set up, I'll be up for buying another full set for a different site (I'm just going to clone everything--two birds with one stone).

Chuck S · March 20th, 2006, 08:52 AM

Try removing this in inc_reviews.php

Code:

Content visible to verified customers only.

DSades · March 20th, 2006, 05:58 PM

Nope.

Chuck S · March 20th, 2006, 08:04 PM

Okay well check your usergroups permissions for the block in vbadvanced not much else I can add on this. You can post on the mod forum about vbadvanced blocks and such as thats all I know about vbadvanced how to make em since I dont own it.

DSades · March 21st, 2006, 12:07 AM

Aha! I removed PhotoPost module, and the ReviewPost module finally displayed proper errors:

Quote:

Warning: mysql_query() [function.mysql-query]: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) in /classifieds/inc_reviews.php on line 53

Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in /classifieds/inc_reviews.php on line 53

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

Warning: mysql_query() [function.mysql-query]: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) in /classifieds/inc_reviews.php on line 102

Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in /classifieds/inc_reviews.php on line 102

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

Why is that happening?

Chuck S · March 21st, 2006, 07:48 AM

Well why is the inc_reviews.php file in your classifieds directory? is that the directory for reviewpost?

However given those errors what I would recheck is the instructions on including this module on this forum we have posted.

Check the config-intr.php file and make sure your prefix for reviewpost is included and make sure if reviewpost and vbulletin are in separate databases you have uncommented the $link and mysql_select_db lines and filled in the proper variables.

The error above tells me specifically mysql is not even open which definately means you need to fill in the $link and select database lines and uncomment them

DSades · April 11th, 2006, 08:20 AM

Chuck, I finally got the Classifieds to work, but only when it is underneath Reviews module. When I moved Classifies to the left colum by itself, it no longer worked:

Quote:

Warning: mysql_query() [function.mysql-query]: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) in /classifieds/inc_ads.php on line 54

Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in /classifieds/inc_ads.php on line 54

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /classifieds/inc_ads.php on line 57

Warning: mysql_query() [function.mysql-query]: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) in /classifieds/inc_ads.php on line 105

Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in /classifieds/inc_ads.php on line 105

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /classifieds/inc_ads.php on line 109

any idea why?

Chuck S · April 11th, 2006, 09:03 AM

I would suggest you go make sure if classifieds is in an external database you have correctly uncommented the $link statement in that file and uncomment the mysql_select_db statements and fill them in.

DSades · April 11th, 2006, 11:26 AM

They're all on the same database. The strange part is that the Classifieds module works fine underneath the PhotoPost module, but if I move it above or to the sides of the PhotoPost module, it stops working. (this includes adding a Reviews module anywhere on the page)

Chuck S · April 11th, 2006, 01:12 PM

As stated fill in the variables as noted. The error your posting says there is not an open connection to the database.

Andy Winters · April 18th, 2006, 02:27 PM

nevermind....fixed my own problems.... :}
:

Suzie · August 30th, 2006, 10:18 PM

My error has became fatal.

Fatal error: Cannot redeclare rp_get_ext() (previously declared in /home/discuss/public_html/forum/reviews/inc_reviews.php:90) in /home/discuss/public_html/forum/reviews/inc_reviews.php on line 93

Chuck S · August 31st, 2006, 09:26 AM

You can not include the file twice and this would appear to be what you have done.

Suzie · August 31st, 2006, 05:56 PM

Got it now I think. Thanks

Suzie · August 31st, 2006, 06:31 PM

No I did have it repeated in the index file but when I removed it I am still getting the same error.

Chuck S · August 31st, 2006, 07:05 PM

If you still have the error your including the file twice somewhere on the index

Suzie · August 31st, 2006, 07:14 PM

Okay it was because I had it in my module block and the index apparently. Are the templates for the review script supposed to be in my VB templates? If not is there a template I can copy over and have it work as is?

Chuck S · August 31st, 2006, 09:08 PM

Our templates are not in vbulletin and this modification has no templates. You can only include the module once on a page