X-Cart forums

[BoomBoomBap]

I was looking to find a way to display the number of reviews and reached this post: http://forum.x-cart.com/viewtopic.php?t=2292 - which shows how to display the number of votes

Taking off from this idea I made the following mod:

In customer/vote.php add the following code:

###################
//display total reviews
	$reviews_result = func_query_first ("SELECT COUNT(remote_ip) as total FROM $sql_tbl[product_reviews] WHERE productid='$productid'");

	if ($reviews_result["total"] == 0)
	$smarty->assign ("reviews_result", $reviews_result);
   $smarty->assign ("reviews_total", $reviews_result["total"]);
###################

and then in skin1/customer/Modules/Customer_Reviews/reviews.tpl add the following code where you want to display the number:

{$reviews_total}

Personally I placed it here:

{$reviews_total} {$lng.lbl_customer_reviews}

This shows something like "11 Customer Reviews"

Neat !


Next I'd like to limit the number of reviews shown to 5 and then "click here to display all"

[BoomBoomBap]

Okay, I've figured out how to limit the number of reviews displayed and then have a link to show all.

In customer/vote.php find this:

$reviews = func_query ("SELECT * FROM $sql_tbl[product_reviews] WHERE productid='$productid'");

replace with this:

//for showing all reviews
	if ($show_all_reviews == yes) {
	$reviews = func_query ("SELECT * FROM $sql_tbl[product_reviews] WHERE productid='$productid'");
} else {	
	$reviews = func_query ("SELECT * FROM $sql_tbl[product_reviews] WHERE productid='$productid' LIMIT 5");
}
// change the LIMIT number to display less or more reviews
// end

Then, in skin1/modules/Customer_Reviews/vote.tpl add this:

Show all reviews ({$reviews_total} total)

If you have NOT used the mod listed in the first post then remove

({$reviews_total} total)

and this part of the mod should still work.

[funkydunk]

Great mod

[ghhoz]

Thanks for sharing this mod - fits what i was looking for perfectly.