 . 'logo.png?id='.$this->version; ?>)
Pro Version of this plugin!', 'wp-zillow-reviews');
?>
query("TRUNCATE TABLE `".$table_name."`");
}
//pagenumber
if(isset($_GET['pnum'])){
$temppagenum = $_GET['pnum'];
} else {
$temppagenum ="";
}
if ( $temppagenum=="") {
$pagenum = 1;
} else if(is_numeric($temppagenum)){
$pagenum = intval($temppagenum);
}
if(!isset($_GET['sortdir'])){
$_GET['sortdir'] = "";
}
if ( $_GET['sortdir']=="" || $_GET['sortdir']=="DESC") {
$sortdirection = "&sortdir=ASC";
} else {
$sortdirection = "&sortdir=DESC";
}
$currenturl = remove_query_arg( 'sortdir' );
//make sure sortby is valid
if(!isset($_GET['sortby'])){
$_GET['sortby'] = "";
}
$allowed_keys = ['created_time_stamp', 'reviewer_name', 'rating', 'review_length', 'pagename', 'type' ];
$checkorderby = sanitize_key($_GET['sortby']);
if(in_array($checkorderby, $allowed_keys, true) && $_GET['sortby']!=""){
$sorttable = $_GET['sortby']. " ";
} else {
$sorttable = "created_time_stamp ";
}
if($_GET['sortdir']=="ASC" || $_GET['sortdir']=="DESC"){
$sortdir = $_GET['sortdir'];
} else {
$sortdir = "DESC";
}
unset($sorticoncolor);
for ($x = 0; $x <= 10; $x++) {
$sorticoncolor[$x]="";
}
if($sorttable=="hide "){
$sorticoncolor[0]="text_green";
} else if($sorttable=="reviewer_name "){
$sorticoncolor[1]="text_green";
} else if($sorttable=="rating "){
$sorticoncolor[2]="text_green";
} else if($sorttable=="created_time_stamp "){
$sorticoncolor[3]="text_green";
} else if($sorttable=="review_length "){
$sorticoncolor[4]="text_green";
} else if($sorttable=="pagename "){
$sorticoncolor[5]="text_green";
} else if($sorttable=="type "){
$sorticoncolor[6]="text_green";
}
$html .= '
| '.__('Name', 'wp-zillow-reviews').' |
'.__('Rating', 'wp-zillow-reviews').' |
'.__('Review Text', 'wp-zillow-reviews').' |
'.__('Date', 'wp-zillow-reviews').' |
'.__('Length', 'wp-zillow-reviews').' |
'.__('Page Name', 'wp-zillow-reviews').' |
'.__('Type', 'wp-zillow-reviews').' |
';
//get reviews from db
$lowlimit = ($pagenum - 1) * $rowsperpage;
$tablelimit = $lowlimit.",".$rowsperpage;
$reviewsrows = $wpdb->get_results(
$wpdb->prepare("SELECT * FROM ".$table_name."
WHERE id>%d
ORDER BY ".$sorttable." ".$sortdir."
LIMIT ".$tablelimit." ", "0")
);
//total number of rows
$reviewtotalcount = $wpdb->get_var( 'SELECT COUNT(*) FROM '.$table_name );
//total pages
$totalpages = ceil($reviewtotalcount/$rowsperpage);
if($reviewtotalcount>0){
foreach ( $reviewsrows as $reviewsrow )
{
if($reviewsrow->hide!="yes"){
$hideicon = '';
} else {
$hideicon = '';
}
$hideicon ='';
$html .= '
| '.$reviewsrow->reviewer_name.' |
'.$reviewsrow->rating.' |
'.$reviewsrow->review_text.' |
'.$reviewsrow->created_time.' |
'.$reviewsrow->review_length.' |
'.$reviewsrow->pagename.' |
'.$reviewsrow->type.' |
';
}
} else {
$html .= '
| '.__('No reviews found. Please visit the Get Zillow Reviews page to retrieve reviews.', 'wp-zillow-reviews').' |
';
}
$html .= '
';
$html .= '';
$html .= '
';
echo $html;
?>