RP311 - reviewspal.tmpl

InterFX · November 24th, 2005, 08:23 PM

How do I add the name (title or mfg.) of the product to the reviews pal? I tried the following in reviewpal.tmpl, but it does not work... Any other ideas to try?

<span class="{$Style['small']}">{$ptitle[$x]}{$compal['comment'][$x]}<br />by

InterFX

Chuck S · November 24th, 2005, 08:37 PM

Not something that easy

Basically you would need to a whole new query within the while loop to grab the title and define it for this variable which is the product id $cache['comments']['lcphoto'][$numfound]

Code:

Content visible to verified customers only.

and down lower

Code:

Content visible to verified customers only.

then of course $compal['title'][$x] would be the variable

Chuck S · November 24th, 2005, 08:38 PM

Not something that easy

Basically you would need to a whole new query within the while loop to grab the title and define it for this variable which is the product id $cache['comments']['lcphoto'][$numfound]

Code:

Content visible to verified customers only.

and down lower

Code:

Content visible to verified customers only.

then of course $compal['title'][$x] would be the variable

InterFX · November 24th, 2005, 09:24 PM

I did what you suggested... Made the 2 mods in the index.php file, and then added this line in the reviewspal.tmpl...

{$compal['title'][$x]}<br />{$compal['comment'][$x]}<br />by

It is close, but not quite working...

http://www.disneyreview.com

You can see below, it is showing the first letter C, A, S in each one (It is from Castaway Creek) from the last review added...

I know this is simple, but what am I missing?

InterFX

Chuck S · November 25th, 2005, 08:26 AM

list($cache['comments']['title']) = mysql_fetch_row($query1);

would be

list($cache['comments']['title'][$numfound]) = mysql_fetch_row($query1);

InterFX · November 25th, 2005, 11:16 AM

That worked great!

BobHarbison · July 24th, 2007, 11:38 PM

This works as promised, but I would also like to add the manufacturer as well as the title. How would I go about doing that?

Chuck S · July 25th, 2007, 09:50 AM

Alter your little hack or mod there and add manu to the query and define it in the list statement

BobHarbison · July 25th, 2007, 10:05 AM

Quote:

Originally Posted by Chuck S

Alter your little hack or mod there and add manu to the query and define it in the list statement

UH, yeah, easy for you to say.

The problem is that it's actually your hack, not mine, and while I generally understand what it does, I'm not very practiced at this stuff. For the most part I stick with stock code.

Chuck S · July 25th, 2007, 10:14 AM

Yeah well for the most part I try and stay out of modification discussions also but then every now and then someone brings on of these old things to the top.

BobHarbison · July 25th, 2007, 10:26 PM

OK, I did a little kludging and got it to work. I'm posting it here for two reasons.

1) I think the 2 queries could be combined into one, and so I'm hoping somebody better at coding than me can show me how...

2) This mod seems really important to review boards like mine. We do camera lens. Thumbnails of lens all look pretty much alike. Without the manufacturer and the title, the list of recent reviews isn't nearly as informative as it could be.

Original code by Chuck, errors by me.

Modified in index.php file:

Code:

Content visible to verified customers only.

As I mentioned, I think the 2 queries should be able to combined, but I haven't had any luck doing it...

Further down in index.php

Code:

Content visible to verified customers only.

Then change the reviewspal template as follows:

Code:

Content visible to verified customers only.

Result:

BobHarbison · July 27th, 2007, 10:03 PM

One more trick I've added...

This code will make the product title a clickable link to the full review. I found that new users weren't sure how to get to the full review (click on the photo) so this title link helps reduce confusion.

In reviewspal template

Code:

Content visible to verified customers only.