RSS feed of Reviews

[greenhat]

I looked for this , but couldnt find it anyway.. so will try posting a new thread for the first time.

Would like to find or make a module that creates an RSS feed out of reviews.
Any suggestions?

Thank you

[greenhat]

I looked for this , but couldnt find it anyway.. so will try posting a new thread for the first time.

Would like to find or make a module that creates an RSS feed out of reviews.
Any suggestions?

Thank you

Finally figured this out. Figured, i'd share the knowledge. In case anyone is interested, here's how I resolved this. It could be used to create an RSS feed out of any data in Zen Cart DB.

The file that needs to be modified is:
/includes/modules/pages/rss_feed/header_php.php

Need to create a new case statement here : switch($_GET["feed"]) {

you can see what other case statements look like and just substitute for your own SQL. For example, i needed an RSS feed for 6 random reviews from my website. Here's the case statement:

case "reviews_random":
$random = true;
$limit = " LIMIT 6";

$random_review_select = "SELECT r.reviews_id, r.reviews_rating, p.products_id, p.products_image, pd.products_name, rd.reviews_text, r.customers_name, r.date_added
from " . TABLE_REVIEWS . " r, " . TABLE_REVIEWS_DESCRIPTION . " rd, "
. TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd
where p.products_status = '1'
and p.products_id = r.products_id
and r.reviews_id = rd.reviews_id
and rd.languages_id = '" . (int)$_SESSION['languages_id'] . "'
and p.products_id = pd.products_id
and pd.language_id = '" . (int)$_SESSION['languages_id'] . "'" .
" and r.status = 1 ORDER BY RAND() " . $limit;


$reviews = $db->Execute($random_review_select);

while (!$reviews->EOF) {
$xtags = array();
$xtags['image'] = $reviews->fields['products_image'];
$xtags['rating'] = $reviews->fields['reviews_rating'];
$link = zen_href_link(FILENAME_PRODUCT_REVIEWS, 'products_id=' . $reviews->fields['products_id'] . $laguage_url, 'NONSSL', false);
$rss->rss_feed_item($reviews->fields['products_name'],
$link,
array('url' => $link, 'PermaLink' => true),
$reviews->fields['date_added'],
$reviews->fields['reviews_text'],
$reviews->fields['products_image'],
false,
$reviews->fields['customers_name'],
false,
false,
$xtags
);
$reviews->MoveNext();
}

break;

---------------

once you implement a new case statement, you can access the results via this link:

/index.php?main_page=rss_feed&feed=reviews_random

where feed={name of the case statement}


hope this helps if anyone needs anything like this.

[asauterChicago]

I know this post is almost three years old, but thank you!!