prefix . 'wpzillow_post_templates';
//use the template id to find template in db, echo error if we can't find it or just don't display anything
//Get the form--------------------------
$tid = htmlentities($a['tid']);
$tid = intval($tid);
$currentform = $wpdb->get_results("SELECT * FROM $table_name WHERE id = ".$tid);
//check to make sure template found
if(isset($currentform[0])){
//use values from currentform to get reviews from db
$table_name = $wpdb->prefix . 'wpzillow_reviews';
if($currentform[0]->hide_no_text=="yes"){
$min_words = 2;
$max_words = 5000;
} else {
$min_words = 0;
$max_words = 5000;
}
if($currentform[0]->display_order=="random"){
$sorttable = "RAND() ";
$sortdir = "";
} else {
$sorttable = "created_time_stamp ";
$sortdir = "DESC";
}
$reviewsperpage= $currentform[0]->display_num*$currentform[0]->display_num_rows;
$tablelimit = $reviewsperpage;
//change limit for slider
if($currentform[0]->createslider == "yes"){
$tablelimit = $tablelimit*$currentform[0]->numslides;
}
//----------------------
//pro filter settings min_words, max_words, min_rating, rtype, rpage, showreviewsbyid========
if($currentform[0]->min_words>0){
$min_words = intval($currentform[0]->min_words);
}
if($currentform[0]->max_words>0){
$max_words = intval($currentform[0]->max_words);
}
//min_rating filter----
if($currentform[0]->min_rating>0){
$min_rating = intval($currentform[0]->min_rating);
} else {
$min_rating ="";
}
//rtype filter-----
$rtypefilter = "";
if($currentform[0]->rtype!=""){
$rtypearray = json_decode($currentform[0]->rtype);
$rtypearray = array_filter($rtypearray);
$rtypearray = array_values($rtypearray);
if(count($rtypearray)>0){
for ($x = 0; $x < count($rtypearray); $x++) {
if($rtypearray[$x]=="fb"){$rtypearray[$x]="Facebook";}
if($rtypearray[$x]=="manual"){$rtypearray[$x]="Manual";}
if($rtypearray[$x]=="zillow"){$rtypearray[$x]="Zillow";}
if($x==0){
$rtypefilter = "AND (type = '".$rtypearray[$x]."'";
} else {
$rtypefilter = $rtypefilter." OR type = '".$rtypearray[$x]."'";
}
}
$rtypefilter = $rtypefilter.")";
}
}
//rpage filter-----
$rpagefilter = "";
if($currentform[0]->rpage!=""){
$rpagearray = json_decode($currentform[0]->rpage);
if(is_array($rpagearray)){
$rpagearray = array_filter($rpagearray);
$rpagearray = array_values($rpagearray);
if(count($rpagearray)>0){
for ($x = 0; $x < count($rpagearray); $x++) {
if($x==0){
$rpagefilter = "AND (pageid = '".$rpagearray[$x]."'";
} else {
$rpagefilter = $rpagefilter." OR pageid = '".$rpagearray[$x]."'";
}
}
$rpagefilter = $rpagefilter.")";
}
}
}
//showreviewsbyid filter---------replaces all other filters
$onlyselected = false;
if($currentform[0]->showreviewsbyid!=""){
$showreviewsbyidarray = json_decode($currentform[0]->showreviewsbyid);
$showreviewsbyidarray = array_filter($showreviewsbyidarray);
$showreviewsbyidarray = array_values($showreviewsbyidarray);
if(count($showreviewsbyidarray)>0){
$onlyselected = true;
}
}
if($onlyselected){
$query = "SELECT * FROM ".$table_name." WHERE id IN (";
//loop array and add to query
$n=1;
foreach ($showreviewsbyidarray as $value) {
if($value!=""){
if(count($showreviewsbyidarray)==$n){
$query = $query." $value";
} else {
$query = $query." $value,";
}
}
$n++;
}
$query = $query.")";
$totalreviews = $wpdb->get_results($query);
} else {
$totalreviews = $wpdb->get_results(
$wpdb->prepare("SELECT * FROM ".$table_name."
WHERE id>%d AND review_length >= %d AND review_length <= %d AND rating >= %d AND hide != %s ".$rtypefilter." ".$rpagefilter."
ORDER BY ".$sorttable." ".$sortdir."
LIMIT ".$tablelimit." ", "0","$min_words","$max_words","$min_rating","yes")
);
}
//echo $wpdb->last_query ;
//print_r($totalreviews);
//echo "
";
//only continue if some reviews found
$makingslideshow=false;
if(count($totalreviews)>0){
//if creating a slider than we need to split into chunks for each slider
//if($currentform[0]->createslider == "yes"){
//print_r(array_chunk($totalreviews, $reviewsperpage));
$totalreviewschunked = array_chunk($totalreviews, $reviewsperpage);
//}
//loop through each chunk
//if making slide show then add it here
if($currentform[0]->createslider == "yes"){
//make sure we have enough to create a show here
if($totalreviews>$reviewsperpage){
$makingslideshow = true;
echo '';
}
}
}
?>