get_results($sql, ARRAY_A);
if(isset($_POST['id']) && $_POST['action']=='delete'){
$total_deleted = 0;
foreach($_POST['id'] as $key => $value) {
$delete_mlsid = $wpdb->get_results("SELECT * FROM ".AEM_PLUGIN_DB_Table." WHERE id = ".$value." LIMIT 1", ARRAY_A);
if(count($delete_mlsid ) > 0) {
$selected_mlsid_before = $wpdb->get_results("SELECT * FROM ".AEM_PLUGIN_DB_Table." WHERE id = ".$value." LIMIT 1", ARRAY_A);
$sql = "DELETE FROM ".AEM_PLUGIN_DB_Table." WHERE id = ".$value." LIMIT 1";
$wpdb->query($sql);
$selected_mlsid_after = $wpdb->get_results("SELECT * FROM ".AEM_PLUGIN_DB_Table." WHERE id = ".$value." LIMIT 1", ARRAY_A);
$total_deleted = ( $total_deleted + ( count($selected_mlsid_before) - count($selected_mlsid_after) ) );
}
}
if($total_deleted > 0) {
echo '';
echo $total_deleted.' Agents Deleted Successfully.';
echo '
';
echo 'Failed Deleting Agent.';
echo '
';
echo 'Properties Deleted Successfully.';
echo '
';
echo 'Failed Deleting Property.';
echo '
| Shortcodes |
Description |
|
|
When the Agent MLSID is supplied in the Plugin Settings and the Shortcode is on a page, it will display the auto feed of the Agents Active Listings.
|
|
|
When the Agent MLSID is supplied in the Plugin Settings and the Shortcode is on a page, it will display the auto feed of the Agents Sold Listings.
|
1){
$pagination .= "";
#$pagination .= "";
//previous button
if($page > 1) {
$pagination .= " « PREV ";
} else {
//$pagination .= "« prev";
}
//pages
if($lastpage < 7 +($adjacents * 2)) { //not enough pages to bother breaking it up
for($counter = 1; $counter <= $lastpage; $counter++)
{
if($counter == $page) {
$pagination .= "$counter";
} else {
$pagination .= "$counter";
}
}
} elseif($lastpage >= 7 +($adjacents * 2)) { //enough pages to hide some
//close to beginning; only hide later pages
if($page < 1 +($adjacents * 3))
{
for($counter = 1; $counter < 4 +($adjacents * 2); $counter++)
{
if($counter == $page) {
$pagination .= "$counter";
} else {
$pagination .= "$counter";
}
}
$pagination .= "....";
$pagination .= "$lpm1";
$pagination .= "$lastpage";
//in middle; hide some front and some back
} elseif($lastpage -($adjacents * 2) > $page && $page >($adjacents * 2)) {
$pagination .= "1";
$pagination .= "2";
$pagination .= "...";
for($counter = $page - $adjacents; $counter <= $page + $adjacents; $counter++)
{
if($counter == $page) {
$pagination .= "$counter";
} else {
$pagination .= "$counter";
}
}
$pagination .= "...";
$pagination .= "$lpm1";
$pagination .= "$lastpage";
//close to end; only hide early pages
} else {
$pagination .= "1";
$pagination .= "2";
$pagination .= "....";
for($counter = $lastpage -(1 +($adjacents * 3)); $counter <= $lastpage; $counter++)
{
if($counter == $page) {
$pagination .= "$counter";
} else {
$pagination .= "$counter";
}
}
}
}
//next button
if($page < $counter - 1) {
$pagination .= " NEXT »";
} else {
//$pagination .= "next »";
}
$pagination .= "";
}
return $pagination;
}
?>