osCshop

I really would like to use this mod but would like to see an example first. Anybody a hyperlink to a shop who's using this?

I would like to use the old 'Customer Review Image' contribution together with this Reviews in Product Display 2.3 contribution. I've got the Reviews in Product Display 2.3 work perfect together with the Review Approval and Allow Guest Reviews contribution. Could somebody please help me how to ad the following lines to the lines used for the Reviews in Product Display 2.3 contribution? Below the code that normally has to come in catalog/product_reviews.php // BOF Review Images $reviews_query_raw = "select r.reviews_id, left(rd.reviews_text, 100) as reviews_text, r.reviews_rating, r.date_added, r.customers_name, ri.reviews_image from " . TABLE_REVIEWS . " r, " . TABLE_REVIEWS_DESCRIPTION . " rd left join " . TABLE_REVIEWS_IMAGES . " ri on r.reviews_id = ri.reviews_id and ri.reviews_status = '1' where r.products_id = '" . (int)$product_info['products_id'] . "' and r.reviews_id = rd.reviews_id and rd.languages_id = '" . (int)$languages_id . "' and r.approved = '1' order by r.reviews_id desc"; // EOF Review Images <?php // BOF Review Images ?> <td valign="top" class="main"><?php echo (tep_not_null($reviews['reviews_image']) ? tep_image(DIR_WS_REVIEWS . $reviews['reviews_image'], $products_name, SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT, 'hspace="5" vspace="5" align="left"') : '') . tep_break_string(tep_output_string_protected($reviews['reviews_text']), 60, '-<br>') . ((strlen($reviews['reviews_text']) >= 100) ? '..' : '') . '<br><br><i>' . sprintf(TEXT_REVIEW_RATING, tep_image(DIR_WS_IMAGES . 'stars_' . $reviews['reviews_rating'] . '.gif', sprintf(TEXT_OF_5_STARS, $reviews['reviews_rating'])), sprintf(TEXT_OF_5_STARS, $reviews['reviews_rating'])) . '</i>'; ?></td> <?php // EOF Review Images ?> I gues I have to combine the above code with the code below(?) from product_info.php but have no idea how :huh: .. <?php // BEGIN PopTheTop Product Info Reviews ?> <?php $reviews_query = tep_db_query("select count(*) as count from " . TABLE_REVIEWS . " where products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "'"); $reviews = tep_db_fetch_array($reviews_query); $reviews_query_average = tep_db_query("select (avg(reviews_rating)) as average_rating from " . TABLE_REVIEWS . " where products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and approved = 1"); $reviews_average = tep_db_fetch_array($reviews_query_average); $reveiws_stars = $reviews_average['average_rating']; $reveiws_rating = number_format($reveiws_stars,0); ?> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '45'); ?></td> </tr> <?php if (MAX_REVIEWS_IN_PRODUCT_INFO > 0) { $reviews_query = tep_db_query("select r.reviews_id, rd.reviews_text, r.reviews_rating, r.date_added, r.customers_name from " . TABLE_REVIEWS . " r, " . TABLE_REVIEWS_DESCRIPTION . " rd where r.products_id = '" . $HTTP_GET_VARS['products_id'] . "' and rd.reviews_id = r.reviews_id and rd.languages_id = '" . $languages_id . "' and r.approved = '1' order by r.reviews_id DESC"); $num_rows = tep_db_num_rows($reviews_query); ?> <tr> <td> <table border="0" width="100%" cellspacing="0" cellpadding="0"> <tr> <td class="pageReviewHeading" valign="top"><?php echo BOX_HEADING_REVIEWS; ?></td> </tr> </table> </td> </tr> <?php if ($num_rows > 0) { $row = 0; while (($reviews_values = tep_db_fetch_array($reviews_query)) && ($row < MAX_REVIEWS_IN_PRODUCT_INFO)) { $row++; $date_added = tep_date_short($reviews_values['date_added']); // Write product reviews ?> <?php // END PopTheTop Product Info Reviews ?> I really hope someone could help me out with this one!!

Or this one?: Customer Review Images http://www.oscommerce.com/community/contributions,4965

OK, thanks for the reply. I'll check if there are better solutions then page2rss which I use now..

If you mean the RSS Create function under Tools in admin; I've tried it but nothing happend (probably because I don't use the info box) So i'm not sure how it works but I don't think I can create a dynamic rss feed with that. I need a dynamic feed from the rss_reader page..

Hi Jack, Long time ago but I have a new question. I'm using your RSS News 1.3 page on my website to show new items of my blog. What I would like to have is a RSS feed of the page showing the news on my own website. So I would like to have the traffic first on my website and from there to my blog. I'm using page2rss and twitterfeed to feed my Twitter but i'm not happy with it. All the traffic goes to page2rss instead of my website. Could you please help me to add an rss to the RSS News page? Greetings from Holland, osCshop

Me again, beside a fix for not showing words with no results; how to fix the W3C error: The spaces should be replace by '%20' for W3C..

:o It does show words with no results @ my site. How to filter this?

:blush: I've found the answer to my question. You have to put the code instead of product listing to advanced search result before: $breadcrumb->add(NAVBAR_TITLE_1, tep_href_link(FILENAME_ADVANCED_SEARCH)); $breadcrumb->add(NAVBAR_TITLE_2, tep_href_link(FILENAME_ADVANCED_SEARCH_RESULT, tep_get_all_get_params(), 'NONSSL', true, false));

Hi, I installed this nice little contribution, thanks! Is there still support? I ask this because there's no reply on the comment from ident/Dirk and because I have a question: I think this contribution works with words entered in the small search box. In my website I only use the advanced search page. How to adjust the code so it will work with words entered in this page? Hope someone can help me with this one :huh:

Not sure what you mean with 'sub-feeds that was attached' Jack. I only use one feed..

Strange, it works now without changing anything.. The '€' is presented as a '?'.

Me again. I think it has something to do with a special character. In this feed. Could the '€' euro character cause the error? If I try another feed there's no problem. The feed I use works fine on my Netvibes page. So i would put my money on the '€' character. How to fix this?

Hi Jack, Until today your contribution worked great! Now the page gives this error: Warning: fopen(http://www.rssdomain.com/rss/seat.rss) [function.fopen]: failed to open stream: Bad file descriptor in c:\domains\mydomain.nl\wwwroot\mydir\includes\modules\rss_reader.php on line 112 could not open XML input Any idea?

Aha, I wasn't aware that RSS News v1.3 had a RSS news page :blush: I've installed it and it works great. Thank you! For W3C validation I only had to remove a '</tr>' ad line 69 in catalog/rss_reader.php Thanks again!

Because of the same reason I've installed this old contribution (jan 4 '05) based on your work. It gives a clean page.. without the feed :-( I would love to have a rss page (no info boxes). Would you like to overthink to add such a page to your latest RSS News contribution Jack?

Could someone help me to make this contribution work with Chemo's Ult SEF URL's v2.0b PLZ? Subcategories show the cPath= instead of the categoryname...

Monica, Thank you so much for the help, it worked for me too :)

I'm also having the help files pop-up problem with STS. How to fix this? Are there people who have no problems with v2.5a? I've installed this version yesterday but now I read there're bugs in this version (what kind of bugs?).

Dr_DK, Can you post your product_listing as an example how to modifie it PLZ? I'm trying to place the Buy Now button under the Price in the Price Column...

HELP wanted; Instead of "Sort: Paperback | Year: 2005" I would like to show just "Paperback | 2005" in the productlisting. :huh:

Quote from long Contribution Announcement Threat: It seems more people would like to show the PEF information in the product_listing. I've also asked this in this thread but I think the question belongs here. Could anybody help me to get this done PLZ :huh: TIA

Not sure if Arnoud is still looking for the answer but I am! Actually I want to display the data of a few fields from PEF not the field name. Instead of "Sort: Paperback | Year: 2005" I would like to show just "Paperback | 2005" in the productlisting. I think many people would like to display this information in the productlisting! Help is welcome...

I still hope someone has the answer to my question:

I'm using STS version 2.1 and every category on my site has his own template. I wonder how I could make a template for the specials page. So instead of a category I want to use a template for a link to specials.php. Is this possible?!? Greetings from Holland!