get_results("select * from ".$wpdb->prefix."banners WHERE 1= 1 order by id DESC ", OBJECT);
return count($res);
}
function apabs_get_status($id)
{ global $wpdb;
$result = $wpdb->get_results("select list_status from ".$wpdb->prefix."banners WHERE id = '$id' ", OBJECT);
foreach( $result as $entry ) {
$list_order = $entry->list_status;
}
return $list_order;
}
/* --------- Custom Function ends here ------------ */
if($mode=='delete')
{
$wpdb->query("delete from ".$wpdb->prefix."banners where id=$_REQUEST[pid]");
}
if($mode=='changeStatus')
{
$result = $wpdb->get_results("select list_status from ".$wpdb->prefix."banners WHERE id = $_REQUEST[pid]", OBJECT);
foreach( $result as $entry ) {
if($entry->list_status == '1')
{ $status_change_to = '0';
$status_change_message = 'Row successfully unpublished.';
}
else{
$status_change_to = '1';
$status_change_message = 'Row successfully published.';
}
$wpdb->update($wpdb->prefix.'banners',array('list_status'=>$status_change_to),array('id'=>$_REQUEST['pid']));
}
}
$result = $wpdb->get_results("select * from ".$wpdb->prefix."banners WHERE 1= 1 order by id DESC limit $start, $limit");
?>
Banner successfully added.';} ?>
Banner successfully updated.';} ?>
'.$status_change_message.'';} ?>
Home Page Banners
?page=list-plugin-data1" class="button">Add New
';
$status_title_change = 'Unpublish';
}
else
{ $image_icon_status = '
';
$status_title_change = 'Publish';
}
?>
?page=&pid=id;?>&status=changeStatus&mode=changeStatus" onclick="return confirm('Are you sure you want to ?')">