View Single Post
  #1336  
Old 06-18-2018, 07:56 AM
 
PhilJ PhilJ is offline
 

X-Guru
  
Join Date: Nov 2002
Posts: 4,094
 

Default Re: X-Cart - reBOOT - Responsive Template

They're random, with a limit of 5 by default. See reboot_get_testimonials.php

If you'd prefer the most recent displayed, with a limit of 10, replace...
Code:
$qry = "SELECT * FROM reboot_testimonials WHERE approved='Y' ORDER BY RAND() LIMIT 5";
With...
Code:
$qry = "SELECT * FROM reboot_testimonials WHERE approved='Y' ORDER BY added DESC LIMIT 10";
If you only want 10 star reviews displayed, use...
Code:
$qry = "SELECT * FROM reboot_testimonials WHERE approved='Y' AND rating='10' ORDER BY added DESC LIMIT 10";
__________________
xcartmods.co.uk
Reply With Quote